MENU
|
INSERT:
CLIENT
EXPENSES
PRICES
RULES
POINT OF SALE
RESERVATION
|
TABLES:
MESSAGES
ROOMS
CASHBOXES
RULES
INVENTORY
DOCUMENTS
STATISTICS
RES. PAYMENTS
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
JANUARY
FEBRUARY
MARCH
APRIL
MAY
RESERVATIONS
ALL
CURRENT
FUTURE
ARRIVALS
DEPARTURES
DEPART. AND CURRENT
NUMBER
GO
CLIENTS
SEARCH
RATES
EXTRA COSTS
DEPOSITS AND TAXES
|
CONFIGURE
USERS
WEBSITE
INTERCONN.
BACKUP
DOCUMENTS
Document 10 (Export clients data)
Document format:
HTML
EMAIL
RTF
TXT
(
multi-language
)
Money format:
format from user
1.050.000,32
1,050,000.32
Dates format:
format from user
27-08-2002
08-27-2002
Change
Save documents with progressive number in the directory
Consider this document as an API
Pages where this document should not be displayed:
month table
reservations table
clients table
messages table
availability check
reservation modification
client modification
point of sale
cashboxes
Name for viewing and downloading the document:
document name or saved file name
variable [downloaded_document_name]
Extension for viewing and downloading the document:
default: .txt
custom: .
Edit document:
Variables:
surname
surname2
name
nickname
title
sex
nationality
birthdate
birthnation
birthregion
birthcity
nation
region
city
street
street2
street_number
document
document_type
document_city
document_region
document_nation
document_expiry
telephone
telephone2
telephone3
fax
email
email2
certified_email
postal_code
language_code
fiscal_code
vat_number
client_number
starting_date
ending_date
periods_num
estimated_checkin_time
checkin_time
checkout_time
comment
checkin_reminder
checkout_reminder
reservation_origin
people_num
extra_beds_num
people_num_tot
occupied_unit
units_list
rate_name
rate_price
rate_price_p
rate_currency
rate_exchange_rate
rate_currency_price
price_tot
price_tot_p
price_currency_tot
deposit
deposit_p
deposit_rest
deposit_rest_p
deposit_currency
deposit_currency_value
deposit_exchange_rate
deposit_payment_method
commissions
commissions_p
commissions_rest
commissions_rest_p
discount
discount_p
discount_currency_value
confirmation
paid
paid_p
rest_to_pay
rest_to_pay_p
rate_taxes_percentage
rate_taxes
rate_taxes_p
rate_price_without_taxes
rate_price_without_taxes_p
discount_taxes
discount_taxes_p
discount_without_taxes
discount_without_taxes_p
rate_price_of_array_day
rate_price_of_array_day_p
extra_cost_name (r3)
extra_cost_value (r3)
extra_cost_value_p (r3)
extra_cost_taxes_percentage (r3)
extra_cost_taxes (r3)
extra_cost_taxes_p (r3)
extra_cost_value_without_taxes (r3)
extra_cost_value_without_taxes_p (r3)
extra_cost_days (r3)
extra_cost_max_multiply (r3)
extra_cost_max_daily_value (r3)
extra_cost_max_daily_value_p (r3)
extra_cost_person_type (r3)
extra_cost_insertion_date (r3)
extra_cost_insertion_user (r3)
value_all_extra_costs
value_all_extra_costs_p
all_extra_costs
all_extra_costs_p
sel_extra_cost_name
sel_extra_cost_value
sel_extra_cost_value_p
sel_extra_cost_taxes_percentage
sel_extra_cost_taxes
sel_extra_cost_taxes_p
sel_extra_cost_max_multiply
sel_extra_cost_max_daily_value
sel_extra_cost_max_daily_value_p
extra_costs_number
payment_value (r5)
payment_value_p (r5)
payment_currency (r5)
payment_currency_value (r5)
payment_exchange_rate (r5)
payment_method (r5)
payment_id (r5)
payment_notes (r5)
payment_transaction_date (r5)
payment_date (r5)
payment_user (r5)
last_payment (r5)
all_payments
all_payments_p
payments_number
reservation_number
reservations_repetition_number
reservation_code
last_reservation_for_client
reservation_insertion_date
reservation_insertion_user
guests_tot_num
number_guest (r2)
client_number_guest (r2)
surname_guest (r2)
surname2_guest (r2)
name_guest (r2)
nickname_guest (r2)
title_guest (r2)
sex_guest (r2)
nationality_guest (r2)
relatedness_guest (r2)
birthdate_guest (r2)
birthcity_guest (r2)
birthregion_guest (r2)
birthnation_guest (r2)
city_guest (r2)
region_guest (r2)
nation_guest (r2)
street_guest (r2)
street2_guest (r2)
street_number_guest (r2)
document_guest (r2)
document_type_guest (r2)
document_city_guest (r2)
document_region_guest (r2)
document_nation_guest (r2)
document_expiry_guest (r2)
telephone_guest (r2)
telephone2_guest (r2)
telephone3_guest (r2)
fax_guest (r2)
email_guest (r2)
email2_guest (r2)
certified_email_guest (r2)
postal_code_guest (r2)
fiscal_code_guest (r2)
vat_number_guest (r2)
saved_document_name (r7)
saved_document_progressive_number (r7)
saved_document_creation_date (r7)
saved_document_filename (r7)
saved_document_download_name (r7)
document_progressive_number
unit_name (r6)
unit_house (r6)
unit_floor (r6)
unit_capacity (r6)
unit_priority (r6)
units_num (r6)
units_inventory_list (r6)
units_inventory_missing (r6)
units_inventory_details (r6)
price_tot_repetitions_sum
price_tot_repetitions_sum_p
deposit_repetitions_sum
deposit_repetitions_sum_p
deposit_rest_repetitions_sum
deposit_rest_repetitions_sum_p
paid_repetitions_sum
paid_repetitions_sum_p
rest_to_pay_repetitions_sum
rest_to_pay_repetitions_sum_p
people_num_tot_repetitions_sum
nationality_code
birthnation_code
birthregion_code
birthcity_code
nation_code
region_code
city_code
document_type_code
document_city_code
document_region_code
document_nation_code
nationality_code2
birthnation_code2
birthregion_code2
birthcity_code2
nation_code2
region_code2
city_code2
document_type_code2
document_city_code2
document_region_code2
document_nation_code2
nationality_code3
birthnation_code3
birthregion_code3
birthcity_code3
nation_code3
region_code3
city_code3
document_type_code3
document_city_code3
document_region_code3
document_nation_code3
nationality_code_guest (r2)
relatedness_code_guest (r2)
birthnation_code_guest (r2)
birthregion_code_guest (r2)
birthcity_code_guest (r2)
nation_code_guest (r2)
region_code_guest (r2)
city_code_guest (r2)
document_type_code_guest (r2)
document_city_code_guest (r2)
document_region_code_guest (r2)
document_nation_code_guest (r2)
nationality_code2_guest (r2)
relatedness_code2_guest (r2)
birthnation_code2_guest (r2)
birthregion_code2_guest (r2)
birthcity_code2_guest (r2)
nation_code2_guest (r2)
region_code2_guest (r2)
city_code2_guest (r2)
document_type_code2_guest (r2)
document_city_code2_guest (r2)
document_region_code2_guest (r2)
document_nation_code2_guest (r2)
nationality_code3_guest (r2)
relatedness_code3_guest (r2)
birthnation_code3_guest (r2)
birthregion_code3_guest (r2)
birthcity_code3_guest (r2)
nation_code3_guest (r2)
region_code3_guest (r2)
city_code3_guest (r2)
document_type_code3_guest (r2)
document_city_code3_guest (r2)
document_region_code3_guest (r2)
document_nation_code3_guest (r2)
selection_starting_date
selection_ending_date
selection_reservations_number
today
current_user
structure_name
structure_type
structure_email
structure_company_name
structure_website
structure_contact_name
structure_nation
structure_region
structure_city
structure_address
structure_postal_code
structure_telephone
structure_fax
structure_fiscal_code
structure_vat_number
structure_stars_number
structure_logo
structure_nation_code
structure_region_code
structure_city_code
structure_nation_code2
structure_region_code2
structure_city_code2
structure_nation_code3
structure_region_code3
structure_city_code3
currency_name
base_url_for_webpages
enquiry_email_text
enquiry_email_quoted_text
email_already_sent
carriage_return
new_line
null_value
downloaded_document_name
repetition_error
Mr
il
Il_
al
e
o
el
El_
al3
a
o3
surname_csv
name_csv
nickname_csv
title_csv
email_csv
telephone_csv
fax_csv
nation_csv
region_csv
city_csv
address_csv
postal_code_csv
nationality_csv
birthdate_csv
vat_number_csv
tmp_csv
email2_csv
certified_email_csv
telephone2_csv
telephone3_csv
client_shown_csv(client_number)
Limits of
reservations repetition [r]...[/r]
guests repetition [r2]...[/r2]
extra costs repetition [r3]...[/r3]
array repetition client_shown_csv [r4]...[/r4]
payments repetition [r5]...[/r5]
units repetition [r6]...[/r6]
saved documents repetition [r7]...[/r7]
part under condition [c]...[/c]
Surname,Name,Nickname,Title,Sex,Email,2nd Email,Certified Email,Telephone,2nd Telephone,3rd Telephone,Fax,Language,Nation of Residency,Region of Residency,City of Residency,Address,Postal Code,Nationality,Date of Birth,Vat Number [r][surname_csv],[name_csv],[nickname_csv],[title_csv],[sex],[email_csv],[email2_csv],[certified_email_csv],[telephone_csv],[telephone2_csv],[telephone3_csv],[fax_csv],[language_code],[nation_csv],[region_csv],[city_csv],[address_csv],[postal_code_csv],[nationality_csv],[birthdate_csv],[vat_number_csv] [/r]
Variables:
surname
surname2
name
nickname
title
sex
nationality
birthdate
birthnation
birthregion
birthcity
nation
region
city
street
street2
street_number
document
document_type
document_city
document_region
document_nation
document_expiry
telephone
telephone2
telephone3
fax
email
email2
certified_email
postal_code
language_code
fiscal_code
vat_number
client_number
starting_date
ending_date
periods_num
estimated_checkin_time
checkin_time
checkout_time
comment
checkin_reminder
checkout_reminder
reservation_origin
people_num
extra_beds_num
people_num_tot
occupied_unit
units_list
rate_name
rate_price
rate_price_p
rate_currency
rate_exchange_rate
rate_currency_price
price_tot
price_tot_p
price_currency_tot
deposit
deposit_p
deposit_rest
deposit_rest_p
deposit_currency
deposit_currency_value
deposit_exchange_rate
deposit_payment_method
commissions
commissions_p
commissions_rest
commissions_rest_p
discount
discount_p
discount_currency_value
confirmation
paid
paid_p
rest_to_pay
rest_to_pay_p
rate_taxes_percentage
rate_taxes
rate_taxes_p
rate_price_without_taxes
rate_price_without_taxes_p
discount_taxes
discount_taxes_p
discount_without_taxes
discount_without_taxes_p
rate_price_of_array_day
rate_price_of_array_day_p
extra_cost_name (r3)
extra_cost_value (r3)
extra_cost_value_p (r3)
extra_cost_taxes_percentage (r3)
extra_cost_taxes (r3)
extra_cost_taxes_p (r3)
extra_cost_value_without_taxes (r3)
extra_cost_value_without_taxes_p (r3)
extra_cost_days (r3)
extra_cost_max_multiply (r3)
extra_cost_max_daily_value (r3)
extra_cost_max_daily_value_p (r3)
extra_cost_person_type (r3)
extra_cost_insertion_date (r3)
extra_cost_insertion_user (r3)
value_all_extra_costs
value_all_extra_costs_p
all_extra_costs
all_extra_costs_p
sel_extra_cost_name
sel_extra_cost_value
sel_extra_cost_value_p
sel_extra_cost_taxes_percentage
sel_extra_cost_taxes
sel_extra_cost_taxes_p
sel_extra_cost_max_multiply
sel_extra_cost_max_daily_value
sel_extra_cost_max_daily_value_p
extra_costs_number
payment_value (r5)
payment_value_p (r5)
payment_currency (r5)
payment_currency_value (r5)
payment_exchange_rate (r5)
payment_method (r5)
payment_id (r5)
payment_notes (r5)
payment_transaction_date (r5)
payment_date (r5)
payment_user (r5)
last_payment (r5)
all_payments
all_payments_p
payments_number
reservation_number
reservations_repetition_number
reservation_code
last_reservation_for_client
reservation_insertion_date
reservation_insertion_user
guests_tot_num
number_guest (r2)
client_number_guest (r2)
surname_guest (r2)
surname2_guest (r2)
name_guest (r2)
nickname_guest (r2)
title_guest (r2)
sex_guest (r2)
nationality_guest (r2)
relatedness_guest (r2)
birthdate_guest (r2)
birthcity_guest (r2)
birthregion_guest (r2)
birthnation_guest (r2)
city_guest (r2)
region_guest (r2)
nation_guest (r2)
street_guest (r2)
street2_guest (r2)
street_number_guest (r2)
document_guest (r2)
document_type_guest (r2)
document_city_guest (r2)
document_region_guest (r2)
document_nation_guest (r2)
document_expiry_guest (r2)
telephone_guest (r2)
telephone2_guest (r2)
telephone3_guest (r2)
fax_guest (r2)
email_guest (r2)
email2_guest (r2)
certified_email_guest (r2)
postal_code_guest (r2)
fiscal_code_guest (r2)
vat_number_guest (r2)
saved_document_name (r7)
saved_document_progressive_number (r7)
saved_document_creation_date (r7)
saved_document_filename (r7)
saved_document_download_name (r7)
document_progressive_number
unit_name (r6)
unit_house (r6)
unit_floor (r6)
unit_capacity (r6)
unit_priority (r6)
units_num (r6)
units_inventory_list (r6)
units_inventory_missing (r6)
units_inventory_details (r6)
price_tot_repetitions_sum
price_tot_repetitions_sum_p
deposit_repetitions_sum
deposit_repetitions_sum_p
deposit_rest_repetitions_sum
deposit_rest_repetitions_sum_p
paid_repetitions_sum
paid_repetitions_sum_p
rest_to_pay_repetitions_sum
rest_to_pay_repetitions_sum_p
people_num_tot_repetitions_sum
nationality_code
birthnation_code
birthregion_code
birthcity_code
nation_code
region_code
city_code
document_type_code
document_city_code
document_region_code
document_nation_code
nationality_code2
birthnation_code2
birthregion_code2
birthcity_code2
nation_code2
region_code2
city_code2
document_type_code2
document_city_code2
document_region_code2
document_nation_code2
nationality_code3
birthnation_code3
birthregion_code3
birthcity_code3
nation_code3
region_code3
city_code3
document_type_code3
document_city_code3
document_region_code3
document_nation_code3
nationality_code_guest (r2)
relatedness_code_guest (r2)
birthnation_code_guest (r2)
birthregion_code_guest (r2)
birthcity_code_guest (r2)
nation_code_guest (r2)
region_code_guest (r2)
city_code_guest (r2)
document_type_code_guest (r2)
document_city_code_guest (r2)
document_region_code_guest (r2)
document_nation_code_guest (r2)
nationality_code2_guest (r2)
relatedness_code2_guest (r2)
birthnation_code2_guest (r2)
birthregion_code2_guest (r2)
birthcity_code2_guest (r2)
nation_code2_guest (r2)
region_code2_guest (r2)
city_code2_guest (r2)
document_type_code2_guest (r2)
document_city_code2_guest (r2)
document_region_code2_guest (r2)
document_nation_code2_guest (r2)
nationality_code3_guest (r2)
relatedness_code3_guest (r2)
birthnation_code3_guest (r2)
birthregion_code3_guest (r2)
birthcity_code3_guest (r2)
nation_code3_guest (r2)
region_code3_guest (r2)
city_code3_guest (r2)
document_type_code3_guest (r2)
document_city_code3_guest (r2)
document_region_code3_guest (r2)
document_nation_code3_guest (r2)
selection_starting_date
selection_ending_date
selection_reservations_number
today
current_user
structure_name
structure_type
structure_email
structure_company_name
structure_website
structure_contact_name
structure_nation
structure_region
structure_city
structure_address
structure_postal_code
structure_telephone
structure_fax
structure_fiscal_code
structure_vat_number
structure_stars_number
structure_logo
structure_nation_code
structure_region_code
structure_city_code
structure_nation_code2
structure_region_code2
structure_city_code2
structure_nation_code3
structure_region_code3
structure_city_code3
currency_name
base_url_for_webpages
enquiry_email_text
enquiry_email_quoted_text
email_already_sent
carriage_return
new_line
null_value
downloaded_document_name
repetition_error
Mr
il
Il_
al
e
o
el
El_
al3
a
o3
surname_csv
name_csv
nickname_csv
title_csv
email_csv
telephone_csv
fax_csv
nation_csv
region_csv
city_csv
address_csv
postal_code_csv
nationality_csv
birthdate_csv
vat_number_csv
tmp_csv
email2_csv
certified_email_csv
telephone2_csv
telephone3_csv
client_shown_csv(client_number)
Limits of
reservations repetition [r]...[/r]
guests repetition [r2]...[/r2]
extra costs repetition [r3]...[/r3]
array repetition client_shown_csv [r4]...[/r4]
payments repetition [r5]...[/r5]
units repetition [r6]...[/r6]
saved documents repetition [r7]...[/r7]
part under condition [c]...[/c]