Profil Center: Unterschied zwischen den Versionen

Aus Faces Dokumentation
Wechseln zu: Navigation, Suche
(→‎CSV Upload)
 
(21 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 +
 
= General =
 
= General =
  
−
The Profile Center shows an overview about the numbers of profiles created in Umbrella Faces. Additionally it informs about publishing errors (synchronisation errors), provides the opportunity to Import/Export CSV-File for one, several or all travellers related to company profiles, provides a possibility to mass-synchronize profiles and to send mass-credentials. Some functions are not available for every user.
+
The Profile Center shows an overview about the numbers of profiles created in Umbrella Faces. Additionally it informs about publishing errors (synchronisation errors), provides the opportunity to Import/Export CSV-File for one, several or all travellers related to company profiles, provides a possibility to mass-synchronize profiles and to send mass-credentials. Some functions are not available for every user.
  
 
= Layout =
 
= Layout =
  
−
[[Image:Profilcenter.PNG|800px|Profile-Center]]
+
[[File:Profilcenter.PNG|800px|Profile-Center]]
  
 
== Section 'Travel Agency' ==
 
== Section 'Travel Agency' ==
Zeile 12: Zeile 13:
  
 
{|
 
{|
 +
|-
 
! Field
 
! Field
 
! Description
 
! Description
Zeile 22: Zeile 24:
 
|}
 
|}
  
−
== Section 'Publishing Errors'==
+
== Section 'Publishing Errors' ==
  
−
Publishing errors may occur when creating profiles manually in the user Interface. It is important to identify any such publishing error during/after a CSV Upload.
+
Publishing errors may occur when creating profiles manually in the user Interface. It is important to identify any such publishing error during/after a CSV Upload. A list of all errors is shown including a hyperlink, which leads directly to the incorrect profile.
−
A list of all errors is shown including a hyperlink, which leads directly to the incorrect profile.
 
  
 
{|
 
{|
 +
|-
 
! Field
 
! Field
 
! Description
 
! Description
 
|-
 
|-
 
| Company
 
| Company
−
| List of all companies with a publishing (synchronisation) error including the related system (e.g. Amadeus CSX) and error message (e.g. Record locater not found)  
+
| List of all companies with a publishing (synchronisation) error including the related system (e.g. Amadeus CSX) and error message (e.g. Record locater not found)
 
|-
 
|-
 
| Traveller
 
| Traveller
Zeile 38: Zeile 40:
 
|}
 
|}
  
−
== Section 'Publishing'==
+
== Section 'Publishing' ==
  
−
Publishing can be used to save all profiles, either the erroneous (see publishing errors), all company and traveller profiles and travellers from a specific company.
+
Publishing can be used to save all profiles, either the erroneous (see publishing errors), all company and traveller profiles and travellers from a specific company. Publishing all travellers and/or companies could have an enormous impact to your profiles.
−
Publishing all travellers and/or companies could have an enormous impact to your profiles.
 
  
 
{|
 
{|
−
!Field
 
−
!Description
 
 
|-
 
|-
−
|Travellers of
+
! Field
−
|Save (publishing) all travellers of a specific company
+
! Description
 
|-
 
|-
−
|All erroneous
+
| Travellers of
−
|Save (publishing) all errors, which are displayed in the section error publishing
+
| Save (publishing) all travellers of a specific company
 
|-
 
|-
−
|All companies
+
| All erroneous
−
|Save (publishing) all company profiles
+
| Save (publishing) all errors, which are displayed in the section error publishing
 
|-
 
|-
−
|All travellers
+
| All companies
−
|Save (publishing) all traveller profiles
+
| Save (publishing) all company profiles
 +
|-
 +
| All travellers
 +
| Save (publishing) all traveller profiles
 
|}
 
|}
−
== Section 'Send Credentials'==
+
 
 +
== Section 'Send Credentials' ==
 +
 
 
Credentials can be send to all profiles or arrangers of specific company profiles
 
Credentials can be send to all profiles or arrangers of specific company profiles
 +
 
{|
 
{|
−
!Field
 
−
!Description
 
 
|-
 
|-
−
|Company
+
! Field
−
|Search for the company profile
+
! Description
 
|-
 
|-
−
|All profiles
+
| Company
−
|Send credentials to all profiles (traveller, arranger, approver) of the specified company
+
| Search for the company profile
 
|-
 
|-
−
|All arrangers
+
| All profiles
−
|Send credentials to all arrangers of the specified company
+
| Send credentials to all profiles (traveller, arranger, approver) of the specified company
 +
|-
 +
| All arrangers
 +
| Send credentials to all arrangers of the specified company
 
|}
 
|}
  
−
== Section 'Import/Export'==
+
== Section 'Import/Export' ==
 +
 
 +
=== Export ===
  
−
===Export===
 
 
The Export function allows to download all companies or traveller profiles from one or multiple companies via CSV File.
 
The Export function allows to download all companies or traveller profiles from one or multiple companies via CSV File.
  
 
{|
 
{|
 +
|-
 
! Field
 
! Field
 
! Description
 
! Description
Zeile 100: Zeile 108:
 
|}
 
|}
  
−
===Import===
+
Fields with long text areas and starting with '-' are not being exported correctly. This is an Excel bug and is caused since the programm believes that the cell should be formatted as number-cell and hence has a maximum of characters. We strongly recommend to not use '-' at the beginning of a text area field (e.g. Comment Box).<br/> &nbsp;
−
The Import function allows to upload via CSV file, from Amadeus CSX or AeTM.  
+
 
 +
=== Import ===
 +
 
 +
The Import function allows to upload via CSV file, from Amadeus CSX or AeTM.
  
 
{|
 
{|
 +
|-
 
! Field
 
! Field
 
! Description
 
! Description
 
|-
 
|-
 
| Import Opiton
 
| Import Opiton
−
|
+
|  
−
*CSV: upload companies or traveller profiles from multiple companies via CSV File. Traveller profiles form a single profile has to be imported in the company Profile!
+
*CSV: upload companies or traveller profiles from multiple companies via CSV File. Traveller profiles form a single profile has to be imported in the company Profile!  
−
*Amadeus CSX: upload Company including all associated traveller profiles form Amadeus CSX
+
*Amadeus CSX: upload Company including all associated traveller profiles form Amadeus CSX  
−
*AeTM: upload all traveller form AeTM for a specific Company
+
*AeTM: upload all traveller form AeTM for a specific Company  
 +
 
 
|-
 
|-
−
|
+
| &nbsp;
 
| ''CSV''
 
| ''CSV''
 
|-
 
|-
 
| Upload from CSV
 
| Upload from CSV
−
| Upload the CSV-file for 'travellers' or 'companies'
+
| Upload the CSV-file for 'travellers' or 'companies'  
−
* Note: Mandatory columns for travellers CSV upload are: metadata.action, uuid, username, firstname, gender, name, email, company.uuid
+
*Note: Mandatory columns for travellers CSV upload are: metadata.action, uuid, username, firstname, gender, name, email, company.uuid  
 +
 
 
|-
 
|-
−
|
+
| &nbsp;
 
| ''Amadeus CSX''
 
| ''Amadeus CSX''
 
|-
 
|-
Zeile 127: Zeile 141:
 
|-
 
|-
 
| System
 
| System
−
| Amadeus CSX  
+
| Amadeus CSX
 
|-
 
|-
 
| Profile no.
 
| Profile no.
Zeile 139: Zeile 153:
 
|-
 
|-
 
| Bulk company upload
 
| Bulk company upload
−
| The activation of the checkbox and the click on <Import> will provide a list of all existing company profiles in the Amadeus Office ID. In this step every single company profile is de- or selectable. Please note that a mass upload will take some time (approx. 1000 profiles / 15 minutes). The upload will import all company profiles with their associated traveller profiles.  
+
| The activation of the checkbox and the click on <Import> will provide a list of all existing company profiles in the Amadeus Office ID. In this step every single company profile is de- or selectable. Please note that a mass upload will take some time (approx. 1000 profiles / 15 minutes). The upload will import all company profiles with their associated traveller profiles.
 
|-
 
|-
 
| Import
 
| Import
 
| Click on Import will upload the company and all associated traveller profiles.  
 
| Click on Import will upload the company and all associated traveller profiles.  
−
A username for the traveller profile will be automatically created <first name>.<sure name>@<company short name>
+
A username for the traveller profile will be automatically created <first name>.<sure name>@<company short name> Following Amadeus CSX prefix can be processed:
−
Following Amadeus CSX prefix can be processed:  
+
 
−
* AB
+
*AB  
−
* AM (Traveller only)
+
*AM (Traveller only)  
−
* AP
+
*AP  
−
* APE
+
*APE  
−
* ES
+
*ES  
−
* FFN
+
*FFN  
−
* FP (if Amadeus Local Security Sign is set PCD-Y)
+
*FP (if Amadeus Local Security Sign is set PCD-Y)  
−
* FPO/
+
*FPO/  
−
* FK
+
*FK  
−
* FT
+
*FT  
−
* FZ
+
*FZ  
−
* NM
+
*NM  
−
* OS
+
*OS  
−
* PAS
+
*PAS  
−
* PBD
+
*PBD  
−
* PCI
+
*PCI  
−
* PCZ
+
*PCZ  
−
* PID
+
*PID  
−
* PIV
+
*PIV  
−
* PHI
+
*PHI  
−
* PN
+
*PN  
−
* PPR
+
*PPR  
−
* PPT
+
*PPT  
−
* RM
+
*RM  
−
* RC
+
*RC  
−
* RX
+
*RX  
−
* RM (category e.g. RMA/)
+
*RM (category e.g. RMA/)  
−
* RIR
+
*RIR  
−
* RIZ
+
*RIZ  
−
* SR DOCS
+
*SR DOCS  
−
* SK
+
*SK  
 +
 
 
|-
 
|-
−
|
+
| &nbsp;
 
| ''AeTM''
 
| ''AeTM''
 
|-
 
|-
Zeile 184: Zeile 199:
 
|-
 
|-
 
| Company
 
| Company
−
| Select relevant company. Company needs at least a setup in the AeTM Site-Code, Main Group and Travel Group.  
+
| Select relevant company. Company needs at least a setup in the AeTM Site-Code, Main Group and Travel Group.
 
|}
 
|}
  
−
=== CSV-File - Description 'Travellers'===
+
=== CSV-File - Description 'Travellers' ===
 +
 
 
The download of travellers in a CSV File includes following information.
 
The download of travellers in a CSV File includes following information.
  
Zeile 193: Zeile 209:
  
 
'''Example:''' Enter 3 Frequent Flyer numbers in the CSV-File
 
'''Example:''' Enter 3 Frequent Flyer numbers in the CSV-File
 +
 
{|
 
{|
 +
|-
 
| first number
 
| first number
 
| flightmemberships0.alliance
 
| flightmemberships0.alliance
Zeile 204: Zeile 222:
 
|}
 
|}
  
 +
&nbsp;
  
−
====Standard Fields====
+
&nbsp;
 +
 
 +
 
 +
 
 +
==== Standard Fields ====
  
 
The CSV file will always include the standard fields of Umbrella Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circle are uploaded, than the values will be ignored.
 
The CSV file will always include the standard fields of Umbrella Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circle are uploaded, than the values will be ignored.
  
 
{|
 
{|
 +
|-
 
! Column
 
! Column
 
! Description
 
! Description
Zeile 217: Zeile 241:
 
| Action
 
| Action
 
|  
 
|  
−
* SAVE
+
*SAVE  
−
* DELETE
+
*DELETE  
 +
 
 
|-
 
|-
 
| uuid
 
| uuid
Zeile 226: Zeile 251:
 
| username
 
| username
 
| Faces Username
 
| Faces Username
−
|
+
| &nbsp;
 
|-
 
|-
 
| email
 
| email
 
| E-Mail Address
 
| E-Mail Address
−
|
+
| &nbsp;
−
|-
+
|-
 
| language
 
| language
 
| User language
 
| User language
 
|  
 
|  
−
* en_GB = english (United Kingdom)  
+
*cs_CZ = Czech (Czech Republic)
−
* de_AT = german (Austria)
+
*nl_BE = Dutch (Belgium)
−
* de_DE = german (Germany)
+
*nl_NL = Dutch (Netherlands)
−
* de_CH = german (Switzerland)
+
*en_GB = English (United Kingdom)
−
* fr_CH = French (Switzerland)
+
*en_US = English (United States)
−
* nl_BE = Dutch (Belgium)
+
*fr_CH = French (Switzerland)
−
* nl_NL = Dutch (Netherlands)
+
*fr_FR = French (France)  
−
* IT_IT = Italian (Italy)
+
*de_AT = German (Austria)  
−
* es_ES = Spainish (Spain)
+
*de_DE = German (Germany)  
 +
*de_CH = German (Switzerland)  
 +
*hu_HU = Hungarian (Hungary)
 +
*it_IT = Italian (Italy)
 +
*it_CH = Italian (Switzerland)  
 +
*pl_PL = Polish (Poland)  
 +
*pt_PT = Portuguese (Portugal)  
 +
*sk_SK = Slovak (Slovakia)  
 +
*es_ES = Spanish (Spain)  
 +
 
 
|-
 
|-
 
| company.uuid
 
| company.uuid
 
| Database No. Company
 
| Database No. Company
−
|
+
| &nbsp;
 
|-
 
|-
 
| gender
 
| gender
 
| Gender
 
| Gender
−
|
+
|  
−
* MR
+
*MR  
−
* MRS
+
*MRS  
 +
*U
 +
 
 
|-
 
|-
 
| title
 
| title
 
| Title
 
| Title
−
|
+
|  
−
* DR
+
*DR  
−
* PROF
+
*PROF  
 +
 
 
|-
 
|-
 
| name
 
| name
 
| Surename
 
| Surename
−
|
+
| &nbsp;
 
|-
 
|-
 
| middlename
 
| middlename
 
| Middlename
 
| Middlename
−
|
+
| &nbsp;
 
|-
 
|-
 
| firstname
 
| firstname
 
| Firstname
 
| Firstname
−
|
+
| &nbsp;
 
|-
 
|-
 
| birthdate
 
| birthdate
Zeile 283: Zeile 320:
 
| additionalFormOfPayment
 
| additionalFormOfPayment
 
| Other forms of payment
 
| Other forms of payment
−
|
+
|  
−
* CASH
+
*CASH  
−
* INV
+
*INV  
 +
 
 
|-
 
|-
 
| hotelGuarantee
 
| hotelGuarantee
 
| Hotel guarantee
 
| Hotel guarantee
 
|  
 
|  
−
* T/00 = 1st Traveller credit card
+
*T/00 = 1st Traveller credit card  
−
* T/01 = 2nd Traveller credit card
+
*T/01 = 2nd Traveller credit card  
−
* T/02 = 3rd Traveller credit Card
+
*T/02 = 3rd Traveller credit Card  
−
* C/00 = 1st Company credit card  
+
*C/00 = 1st Company credit card  
−
* C/01 = 2nd Company credit card  
+
*C/01 = 2nd Company credit card  
−
* C/02 = 3rd Company credit card  
+
*C/02 = 3rd Company credit card  
 +
 
 
|-
 
|-
 
| carGuarantee
 
| carGuarantee
 
| Guarantee rental car
 
| Guarantee rental car
 
|  
 
|  
−
* T/00 = 1st Traveller credit card
+
*T/00 = 1st Traveller credit card  
−
* T/01 = 2nd Traveller credit card
+
*T/01 = 2nd Traveller credit card  
−
* T/02 = 3rd Traveller credit Card
+
*T/02 = 3rd Traveller credit Card  
−
* C/00 = 1st Company credit card  
+
*C/00 = 1st Company credit card  
−
* C/01 = 2nd Company credit card  
+
*C/01 = 2nd Company credit card  
−
* C/02 = 3rd Company credit card  
+
*C/02 = 3rd Company credit card  
 +
 
 
|-
 
|-
 
| webcard
 
| webcard
 
| Webcard
 
| Webcard
 
|  
 
|  
−
* T/00 = 1st Traveller credit card
+
*T/00 = 1st Traveller credit card  
−
* T/01 = 2nd Traveller credit card
+
*T/01 = 2nd Traveller credit card  
−
* T/02 = 3rd Traveller credit Card
+
*T/02 = 3rd Traveller credit Card  
−
* C/00 = 1st Company credit card  
+
*C/00 = 1st Company credit card  
−
* C/01 = 2nd Company credit card  
+
*C/01 = 2nd Company credit card  
−
* C/02 = 3rd Company credit card  
+
*C/02 = 3rd Company credit card  
 +
 
 
|-
 
|-
 
| phoneBusiness
 
| phoneBusiness
 
| Phone Business
 
| Phone Business
−
|
+
| &nbsp;
 
|-
 
|-
 
| phonePrivate
 
| phonePrivate
 
| Phone private
 
| Phone private
−
|
+
| &nbsp;
 
|-
 
|-
 
| phoneMobile
 
| phoneMobile
 
| Mobile
 
| Mobile
−
|
+
| &nbsp;
 
|-
 
|-
 
| receivedocs
 
| receivedocs
 
| Itinerary / e-ticket (yes/no)
 
| Itinerary / e-ticket (yes/no)
−
|
+
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| preferredSeat
 
| preferredSeat
 
| Seat Request
 
| Seat Request
−
|
+
|  
−
* A = Aisle
+
*A = Aisle  
−
* W = Window
+
*W = Window  
 +
 
 +
|-
 +
| preferredFood
 +
| Meal Request
 +
| e.g. VGML
 
|-
 
|-
 
| smoker
 
| smoker
 
| Smoker
 
| Smoker
 
|  
 
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| traveller
 
| traveller
 
| Traveller
 
| Traveller
 
|  
 
|  
−
* true
+
*true  
−
*false
+
*false  
 +
 
 
|-
 
|-
 
| arranger
 
| arranger
 
| Arranger / Assistance
 
| Arranger / Assistance
 
|  
 
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| approver
 
| approver
 
| Approver
 
| Approver
−
|
+
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| comment
 
| comment
 
| general.comment
 
| general.comment
−
|
+
| &nbsp;
 
|-
 
|-
 
| company.recordlocator
 
| company.recordlocator
 
| Company / Profile no.
 
| Company / Profile no.
−
|  
+
| &nbsp;
 
|-
 
|-
 
| company.uuid
 
| company.uuid
 
| Company / uuid
 
| Company / uuid
−
|
+
| &nbsp;
 
|-
 
|-
 
| company.name
 
| company.name
 
| Company / Company Name
 
| Company / Company Name
−
|
+
| &nbsp;
 
|-
 
|-
−
| railExtension.delivery
+
| railExtension.delivery
−
| Rail information / Delivery
+
| Rail information / Delivery
−
|
+
|  
−
*BAHNTIX
+
*BAHNTIX  
−
*ONLINE
+
*ONLINE  
−
*PAPERTICKET
+
*PAPERTICKET  
−
*BAHNTIX
+
*BAHNTIX  
 +
 
 
|-
 
|-
 
| railExtension.wagonType
 
| railExtension.wagonType
 
| Rail information / Wagontype
 
| Rail information / Wagontype
−
|
+
|  
−
*COMPARTMENT
+
*COMPARTMENT  
−
*PREFER_WIDEBODY
+
*PREFER_WIDEBODY  
−
*REQUIRE_WIDEBODY
+
*REQUIRE_WIDEBODY  
−
*SINGLE
+
*SINGLE  
−
*TABLE
+
*TABLE  
 +
 
 
|-
 
|-
 
| railExtension.wagonExtraType
 
| railExtension.wagonExtraType
 
| Rail information / Wagon extra
 
| Rail information / Wagon extra
−
|
+
|  
−
*PHONEAREA
+
*PHONEAREA  
−
*QUIETAREA
+
*QUIETAREA  
 +
 
 
|-
 
|-
 
| railExtension.seatpref
 
| railExtension.seatpref
 
| Rail information / Seat
 
| Rail information / Seat
 
|  
 
|  
−
*AISLE
+
*AISLE  
−
*WINDOW
+
*WINDOW  
 +
 
 
|-
 
|-
 
| railExtension.railclass
 
| railExtension.railclass
−
|Rail information / Class
+
| Rail information / Class
−
|
+
|  
−
*FIRST
+
*FIRST  
−
*SECOND
+
*SECOND  
 +
 
 
|-
 
|-
 
| railExtension.identification
 
| railExtension.identification
 
| Rail information / Identification
 
| Rail information / Identification
−
|
+
|  
−
*BANKCARD
+
*BANKCARD  
−
*PERSONALCARD
+
*PERSONALCARD  
−
*RAILCARD
+
*RAILCARD  
 +
 
 
|-
 
|-
 
| railExtension.idInfo
 
| railExtension.idInfo
 
| Rail information / Bank card
 
| Rail information / Bank card
−
|  
+
| &nbsp;
 
|-
 
|-
−
| railExtension.railCards0.cardtype
+
| railExtension.railCards0.cardtype
 
| Railcard / Card
 
| Railcard / Card
−
|
+
|  
 
Rail: Amadeus_Germany
 
Rail: Amadeus_Germany
−
*BAHNBONUS = DB bahn.bonus
+
 
−
*BONUSCARD = DB Bonuscard Business
+
*BAHNBONUS = DB bahn.bonus  
−
*DB100 = DB BahnCard 100
+
*BONUSCARD = DB Bonuscard Business  
−
*DB25 = DB BahnCard 25
+
*DB100 = DB BahnCard 100  
−
*DB25_BUSINESS = DB BahnCard 25 Business
+
*DB25 = DB BahnCard 25  
−
*DB50 = DB BahnCard 50
+
*DB25_BUSINESS = DB BahnCard 25 Business  
−
*DB50_BUSINESS = DB BahnCard 50 Business
+
*DB50 = DB BahnCard 50  
−
*SBB_GA = GA Travelcard / Swisspass
+
*DB50_BUSINESS = DB BahnCard 50 Business  
−
*SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass
+
*SBB_GA = GA Travelcard / Swisspass  
−
*SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass
+
*SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass  
 +
*SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass  
 +
 
 
Rail: Amadeus_Rail
 
Rail: Amadeus_Rail
−
*SNCF_JEUNE
+
 
−
*SNCF_SENIOR
+
*SNCF_JEUNE  
−
*SNCF_WEEKEND
+
*SNCF_SENIOR  
−
*SNCF_CFF50
+
*SNCF_WEEKEND  
−
*SNCF_CLUBTCP
+
*SNCF_CFF50
−
*SNCF_FAM30
+
*SNCF_CFF50  
−
*SNCF_FAM40
+
*SNCF_CLUBTCP  
−
*SNCF_FAM50
+
*SNCF_FAM30  
−
*SNCF_FAM75
+
*SNCF_FAM40  
−
*SNCF_EUROSTAR
+
*SNCF_FAM50  
−
*SNCF_FORFAIT
+
*SNCF_FAM75  
−
*SNCF_FR_MILITARY
+
*SNCF_FORFAIT
−
*SNCF_FREQ50
+
*SNCF_FORFAIT  
−
*SNCF_FREQ_INTERMED
+
*SNCF_FR_MILITARY
−
*SNCF_CARD
+
*SNCF_FR_MILITARY  
−
*SNCF_CLUB
+
*SNCF_FREQ50  
−
*SNCF_PLUS
+
*SNCF_FREQ50
−
*THALYS_LYS
+
*SNCF_FREQ_INTERMED
−
*THALYS_CORP
+
*SNCF_FREQ_INTERMED  
 +
*THALYS_LYS
 +
*THALYS_CORP
 +
*THALYS_PASS_BUSINESS
 +
*THALYS_PASS_PREMIUM
 +
*THALYS_PASS_WEEKEND
 +
*SJR_SJ_PRIO
 +
*SJR_ARSKORT_GOLD
 +
*SJR_ARSKORT_GOLD_RES
 +
*SJR_ARSKORT_SILVER
 +
*SJR_ARSKORT_SILVER_RES
 +
*SJR_ARSKORT_SILVER_PL
 +
*SJR_ARSKORT_SIL_PL_RES
 +
*SNCF_EUROSTAR
 +
*SNCF_CARD  
 +
*SNCF_CLUB  
 +
*SNCF_PLUS  
 +
*SNCF_VOYAGEUR
 +
*THALYS_CARD
 +
*TTL_16_25
 +
*TTL_ANNUAL_GOLD
 +
*TTL_CAMBRIAN_LINES
 +
*TTL_COTSWORLD_LINE
 +
*TTL_DALES
 +
*TTL_DEVON_CORNWALL
 +
*TTL_DISABLED_ADULT
 +
*TTL_ESK_VALLEY
 +
*TTL_GROUPSAVE
 +
*TTL_HEART_OF_WALES
 +
*TTL_HIGHLAND
 +
*TTL_HM_FORCES
 +
*TTL_JOBCENTRE_PLUS
 +
*TTL_NETWORK
 +
*TTL_NEW_DEAL
 +
*TTL_PEMBROKESHIRE
 +
*TTL_SCOTTISH_YOUTH
 +
*TTL_SENIOR
 +
*TTL_TWO_TOGETHER
 +
*TTL_VALLEY_LINES_SENIOR
 +
*TTL_VALLEY_LINES_JUNIOR
 +
*DB25
 +
*DB25
 +
*DB25_BUSINESS
 +
*DB25_BUSINESS
 +
*DB50
 +
*DB50
 +
*DB50_BUSINESS
 +
*DB50_BUSINESS
 +
*DB100
 +
*DB100
 +
*BONUSCARD
 +
*SBB_HALFPRICE
 +
*SBB_HALFPRICE_RAILPLUS
 +
*SBB_GA
 +
*OEBB_VC
 +
*RENFE_CARNET_GO_25_ISTC
 +
*RENFE_CARNET_JOVEN
 +
*RENFE_TARJETA_DORADA
 +
*RENFE_TARJETA_JOVEN
 +
*RENFE_TARJETA_RAIL_PLUS_JUNIOR
 +
*RENFE_PLUS
 +
 
 
|-
 
|-
 
| railExtension.railCards0.cardnumber
 
| railExtension.railCards0.cardnumber
 
| Railcard / Number
 
| Railcard / Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| railExtension.railCards0.cardExpiration
 
| railExtension.railCards0.cardExpiration
Zeile 472: Zeile 592:
 
| residentExtension.area
 
| residentExtension.area
 
| Resident information / Resident Discount
 
| Resident information / Resident Discount
−
|
+
|  
−
*CANARY
+
*CANARY  
−
*BALEARIC
+
*BALEARIC  
−
*CEUTA
+
*CEUTA  
−
*MELILLA
+
*MELILLA  
 +
 
 
|-
 
|-
 
| residentExtension.areaCode
 
| residentExtension.areaCode
Zeile 484: Zeile 605:
 
| residentExtension.cardType
 
| residentExtension.cardType
 
| Resident information / National Identity Card type
 
| Resident information / National Identity Card type
−
|
+
|  
−
*NATIONAL_ID
+
*NATIONAL_ID  
−
*MINOR_RESIDENT
+
*MINOR_RESIDENT  
−
*RESIDENT_CARD
+
*RESIDENT_CARD  
−
*TEMP_RESIDENT
+
*TEMP_RESIDENT  
 +
 
 
|-
 
|-
 
| residentExtension.cardNumber
 
| residentExtension.cardNumber
 
| Resident information / National Identity Card number
 
| Resident information / National Identity Card number
−
|
+
| &nbsp;
 
|-
 
|-
 
| residentExtension.firstSurname
 
| residentExtension.firstSurname
−
| Resident information /  
+
| Resident information /
−
|
+
| &nbsp;
 
|-
 
|-
 
| residentExtension.secondSurname
 
| residentExtension.secondSurname
 
| Resident information /
 
| Resident information /
−
|
+
| &nbsp;
 
|-
 
|-
 
| flightmemberships0.alliance
 
| flightmemberships0.alliance
Zeile 508: Zeile 630:
 
| flightmemberships0.membernumber
 
| flightmemberships0.membernumber
 
| Frequent Flyer / Number
 
| Frequent Flyer / Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| flightmemberships0.additionalinfo
 
| flightmemberships0.additionalinfo
 
| Frequent Flyer / PIN
 
| Frequent Flyer / PIN
−
|
+
| &nbsp;
 
|-
 
|-
 
| hotelmemberships0.alliance
 
| hotelmemberships0.alliance
Zeile 520: Zeile 642:
 
| hotelmemberships0.membernumber
 
| hotelmemberships0.membernumber
 
| Hotel Program / Customer Number
 
| Hotel Program / Customer Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| hotelmemberships0.additionalinfo
 
| hotelmemberships0.additionalinfo
 
| Hotel Program / Customer Request
 
| Hotel Program / Customer Request
−
|
+
| &nbsp;
 
|-
 
|-
 
| carmemberships0.alliance
 
| carmemberships0.alliance
Zeile 532: Zeile 654:
 
| carmemberships0.membernumber
 
| carmemberships0.membernumber
 
| Car Program / Customer Number
 
| Car Program / Customer Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| carmemberships0.additionalinfo
 
| carmemberships0.additionalinfo
 
| Car Program / Customer Request
 
| Car Program / Customer Request
−
|
+
| &nbsp;
 +
|-
 +
| carmemberships0.specialRequest
 +
| Car Program / Special request
 +
| &nbsp;
 
|-
 
|-
 
| passports0.country
 
| passports0.country
Zeile 544: Zeile 670:
 
| passports0.number
 
| passports0.number
 
| Passport / Number
 
| Passport / Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| passports0.issuedate
 
| passports0.issuedate
Zeile 552: Zeile 678:
 
| passports0.issueplace
 
| passports0.issueplace
 
| Passport / Issue place
 
| Passport / Issue place
−
|
+
| &nbsp;
 +
|-
 +
| passports0.issueCountry
 +
| Passport / Issue country
 +
| 2-letter-country-code e.g. CH
 
|-
 
|-
 
| passports0.expiration
 
| passports0.expiration
 
| Passport / Expires
 
| Passport / Expires
−
| Format = dd.mm.yyyy  
+
| Format = dd.mm.yyyy
 
|-
 
|-
 
| visa0.country
 
| visa0.country
Zeile 564: Zeile 694:
 
| visa0.number
 
| visa0.number
 
| Visa Information/ Number
 
| Visa Information/ Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| visa0.issuedate
 
| visa0.issuedate
Zeile 572: Zeile 702:
 
| visa0.issueplace
 
| visa0.issueplace
 
| Not available in the user interface
 
| Not available in the user interface
−
|
+
| &nbsp;
 
|-
 
|-
 
| visa0.expiration
 
| visa0.expiration
Zeile 578: Zeile 708:
 
| Format = dd.mm.yyyy
 
| Format = dd.mm.yyyy
 
|-
 
|-
−
| visa0.multiPurposeInt
+
| visa0.multiPurposeString
−
| Visa Information / Entry type
+
| Visa Information / Entry type
 
|  
 
|  
−
*0 = -
+
*SINGLE
−
*1 = single entry
+
*DOUBLE
−
*2 = double entry
+
*MULTIPLE
−
*3 = multiple entry
+
 
 
|-
 
|-
 
| employeecards0.country
 
| employeecards0.country
Zeile 592: Zeile 722:
 
| employeecards0.number
 
| employeecards0.number
 
| Identification cards / Number
 
| Identification cards / Number
−
|
+
| &nbsp;
 
|-
 
|-
 
| employeecards0.issuedate
 
| employeecards0.issuedate
 
| Not available in the user Interface
 
| Not available in the user Interface
−
|
+
| &nbsp;
 
|-
 
|-
 
| employeecards0.issueplace
 
| employeecards0.issueplace
 
| Not available in the user Interface
 
| Not available in the user Interface
−
|
+
| &nbsp;
 
|-
 
|-
 
| employeecards0.expiration
 
| employeecards0.expiration
 
| Not available in the user Interface
 
| Not available in the user Interface
−
|
+
| &nbsp;
 
|-
 
|-
 
| arrangercontacts0.contact
 
| arrangercontacts0.contact
Zeile 612: Zeile 742:
 
| arrangercontacts0.receivedocs
 
| arrangercontacts0.receivedocs
 
| Itinerary / e-ticket (yes/no)
 
| Itinerary / e-ticket (yes/no)
−
|
+
|  
−
* true
+
*true  
−
* false
+
*false  
−
|-  
+
 
 +
|-
 
| approvercontacts0.contact
 
| approvercontacts0.contact
−
| Administration / Approver  
+
| Administration / Approver
 
| Approvers email address
 
| Approvers email address
 
|-
 
|-
 
| approvercontacts0.receivedocs
 
| approvercontacts0.receivedocs
 
| Itinerary / e-ticket (yes/no)
 
| Itinerary / e-ticket (yes/no)
−
|
+
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| emergencycontacts0.firstname
 
| emergencycontacts0.firstname
 
| Emergency Contact / First Name
 
| Emergency Contact / First Name
−
|
+
| &nbsp;
 
|-
 
|-
 
| emergencycontacts0.lastname
 
| emergencycontacts0.lastname
 
| Emergency Contact / Surname
 
| Emergency Contact / Surname
−
|
+
| &nbsp;
 
|-
 
|-
 
| emergencycontacts0.email
 
| emergencycontacts0.email
 
| Emergency Contact / E-Mail
 
| Emergency Contact / E-Mail
−
|
+
| &nbsp;
 
|-
 
|-
 
| emergencycontacts0.phone
 
| emergencycontacts0.phone
 
| Emergency Contact / Phone
 
| Emergency Contact / Phone
−
|
+
| &nbsp;
 
|-
 
|-
 
| emergencycontacts0.receivedocs
 
| emergencycontacts0.receivedocs
 
| Itinerary / e-ticket (yes/no)
 
| Itinerary / e-ticket (yes/no)
−
|
+
|  
−
* true
+
*true  
−
* false
+
*false  
 +
 
 
|-
 
|-
 
| sortedTravelGroups0.groupId
 
| sortedTravelGroups0.groupId
Zeile 654: Zeile 787:
 
| sortedTravelGroups0.role
 
| sortedTravelGroups0.role
 
| Travel groups / Role
 
| Travel groups / Role
−
|
+
|  
−
Cytric:  
+
Cytric:
 +
 
 
*USER = User  
 
*USER = User  
 
*TRAVELER = Booker  
 
*TRAVELER = Booker  
−
*PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all)
+
*PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all)  
−
*APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted)
+
*APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted)  
−
*TRAVEL_ARRANGER = Travel Arranger
+
*TRAVEL_ARRANGER = Travel Arranger  
−
*TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin)
+
*TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin)  
−
*TRAVEL_APPROVER = Trip Approver
+
*TRAVEL_APPROVER = Trip Approver  
 +
 
 
AeTM:
 
AeTM:
−
*ADMINISTRAOR
+
 
 +
*ADMINISTRAOR  
 
*TRAVELER  
 
*TRAVELER  
 
*PRINCIPAL_TRAVEL_ARRANGER  
 
*PRINCIPAL_TRAVEL_ARRANGER  
 
*APPOINTEDTRAVEL_ARRANGER  
 
*APPOINTEDTRAVEL_ARRANGER  
 
*TRAVEL_APPROVER  
 
*TRAVEL_APPROVER  
−
*FALLBACK_APPROVER
+
*FALLBACK_APPROVER  
 +
 
 
|-
 
|-
 
| sortedTravelGroups1.groupId
 
| sortedTravelGroups1.groupId
 
| Travel groups / Further travel group
 
| Travel groups / Further travel group
−
|
+
| &nbsp;
 
|-
 
|-
 
| sortedPublishStates0.id.publishtarget
 
| sortedPublishStates0.id.publishtarget
 
| Target system
 
| Target system
−
|
+
|  
−
* CSX = Amadeus
+
*CSX = Amadeus  
−
* GALILEO_WS = Galileo
+
*GALILEO_WS = Galileo  
−
* AETM = Amadeus e-travel management
+
*CYTRIC = Cytric
 +
*AETM = Amadeus e-travel management  
 +
 
 
|-
 
|-
 
| sortedPublishStates0.recordlocator
 
| sortedPublishStates0.recordlocator
 
| Target system identification number/name
 
| Target system identification number/name
 
|  
 
|  
−
* Amadeus = Profile record locator
+
*Amadeus = Profile record locator  
−
* Galileo = Profile Name
+
*Galileo = Profile Name  
−
* AeTM = Login Name
+
*AeTM = Login Name  
 +
 
 
if cell is blank, a new profile in the target system will be created
 
if cell is blank, a new profile in the target system will be created
  
−
if cell contains value, the existing profile in the target system will be synchronised  
+
if cell contains value, the existing profile in the target system will be synchronised
 +
 
 
|-
 
|-
 
| sortedPublishStates0.internallocator
 
| sortedPublishStates0.internallocator
Zeile 698: Zeile 839:
  
 
Only for import, no export available
 
Only for import, no export available
 +
 
{|
 
{|
 +
|-
 
! Column
 
! Column
 
! Values/Actions
 
! Values/Actions
Zeile 712: Zeile 855:
 
|-
 
|-
 
| sortedCreditcards0.publishAsFop
 
| sortedCreditcards0.publishAsFop
−
|
+
|  
−
*TRUE = use as form of payment
+
*TRUE = use as form of payment  
−
*FALSE = not use as form of payment
+
*FALSE = not use as form of payment  
 +
 
 
|}
 
|}
  
−
====Custom fields 'Single Company CSV file'====
+
==== Custom fields 'Single Company CSV file' ====
  
 
Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data.
 
Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data.
  
 
{|
 
{|
−
!column
+
|-
−
!Description
+
! column
 +
! Description
 
|-
 
|-
 
| mergedgroups:general.header_general:0.value
 
| mergedgroups:general.header_general:0.value
Zeile 744: Zeile 889:
 
|}
 
|}
  
−
====Custom fields 'Multiple Company CSV file'====
+
==== Custom fields 'Multiple Company CSV file' ====
  
−
Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file will include generic data.  
+
Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file will include generic data. The 'Multiple Company CSV-file' contains other column identifiers compared to the 'Single Company CSV-file'. All custom fields are named with 'allgroups0.fields0.value' in a numeric row. The custom fields from a company setup are highlighted with a ‘!’ in column 2 followed by the given name of the field.
−
The 'Multiple Company CSV-file' contains other column identifiers compared to the 'Single Company CSV-file'.
 
−
All custom fields are named with 'allgroups0.fields0.value' in a numeric row. The custom fields from a company setup are highlighted with a ‘!’ in column 2 followed by the given name of the field.
 
  
 
Example:
 
Example:
  
 
{|
 
{|
−
|
+
|-
 +
| &nbsp;
 
! my agency custom fields
 
! my agency custom fields
 
! company setup custom fields
 
! company setup custom fields
Zeile 763: Zeile 907:
 
! CSV column 2
 
! CSV column 2
 
| Contract Details
 
| Contract Details
−
|!Staff No. for Umbrella
+
| &nbsp;!Staff No. for Umbrella
 
|}
 
|}
 +
 
'''The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field'''
 
'''The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field'''
  
−
=== CSV-File - Description 'Companies'===
+
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
 
 +
 
 +
=== CSV-File - Description 'Companies' ===
  
 
The download of companies in a CSV File includes following Information
 
The download of companies in a CSV File includes following Information
  
 
{|
 
{|
 +
|-
 
! Column
 
! Column
 
! Description
 
! Description
Zeile 777: Zeile 931:
 
|-
 
|-
 
| recordlocator
 
| recordlocator
−
| Profile no.
+
| Profile no.
 
|  
 
|  
 
Amadeus CSX Profil Recloc
 
Amadeus CSX Profil Recloc
 +
 
|-
 
|-
 
| uuid
 
| uuid
Zeile 787: Zeile 942:
 
| externalnr
 
| externalnr
 
| Customer no.
 
| Customer no.
−
|
+
| &nbsp;
 
|-
 
|-
 
| name
 
| name
 
| Company Name
 
| Company Name
−
|
+
| &nbsp;
 
|-
 
|-
 
| shortname
 
| shortname
 
| Short Name
 
| Short Name
−
|
+
| &nbsp;
 
|-
 
|-
 
| emailDelivery
 
| emailDelivery
 
| Email delivery
 
| Email delivery
−
|
+
|  
−
*EMAIL = Amadeus Mail
+
*EMAIL = Amadeus Mail  
−
*EMAILPLUS = Amadeus Fax and Email plus
+
*EMAILPLUS = Amadeus Fax and Email plus  
 +
 
 
|-
 
|-
 
| travellerFopOption
 
| travellerFopOption
 
| Personal Cards
 
| Personal Cards
−
|
+
|  
−
*FP_AND_GUARANTEE = FP and Guarantee
+
*FP_AND_GUARANTEE = FP and Guarantee  
−
*GUARANTEE_ONLY = Guarantee only
+
*GUARANTEE_ONLY = Guarantee only  
−
*NONE = none
+
*NONE = none  
 +
 
 
|-
 
|-
 
| additionalFormOfPayment
 
| additionalFormOfPayment
Zeile 816: Zeile 973:
 
| hotelGuarantee
 
| hotelGuarantee
 
| Guarantee Hotel
 
| Guarantee Hotel
−
|  
+
| &nbsp;
 
|-
 
|-
 
| carGuarantee
 
| carGuarantee
 
| Guarantee rental car
 
| Guarantee rental car
−
|
+
| &nbsp;
 
|-
 
|-
 
| confidential
 
| confidential
 
| Confidential
 
| Confidential
−
|
+
| &nbsp;
 
|-
 
|-
 
| street
 
| street
 
| Street
 
| Street
−
|
+
| &nbsp;
 
|-
 
|-
 
| street2
 
| street2
 
| Street 2
 
| Street 2
−
|
+
| &nbsp;
 
|-
 
|-
 
| zip
 
| zip
 
| Zip
 
| Zip
−
|
+
| &nbsp;
 
|-
 
|-
 
| place
 
| place
 
| Place
 
| Place
−
|
+
| &nbsp;
 
|-
 
|-
 
| country
 
| country
Zeile 848: Zeile 1'005:
 
| phone
 
| phone
 
| Phone
 
| Phone
−
|
+
| &nbsp;
 
|-
 
|-
 
| fax
 
| fax
 
| Fax
 
| Fax
−
|
+
| &nbsp;
 
|-
 
|-
 
| email
 
| email
 
| Email
 
| Email
−
|
+
| &nbsp;
 
|-
 
|-
 
| email2
 
| email2
 
| Email 2
 
| Email 2
−
|
+
| &nbsp;
 
|-
 
|-
 
| email3
 
| email3
 
| Email 3
 
| Email 3
−
|
+
| &nbsp;
 
|-
 
|-
 
| emailInvoiceDelivery
 
| emailInvoiceDelivery
−
| Email invoice delivery
+
| Email invoice delivery
−
|
+
| &nbsp;
 
|-
 
|-
 
| receivedocs
 
| receivedocs
 
| Itinerary / e-ticket
 
| Itinerary / e-ticket
−
|
+
| &nbsp;
 
|-
 
|-
−
| gdsTarget
+
| selfRegistrationKey
−
| Target GDS
+
| Self-registration key&nbsp;&nbsp; &nbsp;
−
|
+
| &nbsp;
−
*0 = Amadeus
 
−
*3 = Galileo
 
−
*5 = Sabre
 
−
*999 = All
 
 
|-
 
|-
 
| gwsOverrides.office
 
| gwsOverrides.office
−
| Galileo Overrides / Travel dep, PCC or IPCC
+
| Galileo Overrides / Travel dep, PCC or IPCC
 
| Galileo PCC
 
| Galileo PCC
 
|-
 
|-
−
| overrideGwsAdditionalInfo
+
| overrideGwsAdditionalInfo
−
| Galileo Overrides / Travel dep, PCC or IPCC
+
| Galileo Overrides / Travel dep, PCC or IPCC
 
| Galileo HAP (mandatory)
 
| Galileo HAP (mandatory)
 
|-
 
|-
 
| csxOverrides.office
 
| csxOverrides.office
−
| CSX Overrides / Travel dep, PCC or IPCC
+
| CSX Overrides / Travel dep, PCC or IPCC
 
| Amadeus OID
 
| Amadeus OID
 
|-
 
|-
−
| overrideCsxAdditionalInfo
+
| overrideCsxAdditionalInfo
 
| CSX Overrides / Travel dep. access or HAP
 
| CSX Overrides / Travel dep. access or HAP
 
| Amadeus Org Id (optional)
 
| Amadeus Org Id (optional)
 
|-
 
|-
−
| sabreOverrides.office
+
| sabreOverrides.office
−
| Sabre Overides / Travel dep, PCC or IPCC
+
| Sabre Overides / Travel dep, PCC or IPCC
 
| Sabre PCC
 
| Sabre PCC
 
|-
 
|-
 
| sabreOverrides.additionalInfo
 
| sabreOverrides.additionalInfo
 
| Sabre Overides / Travel dep. access or HAP
 
| Sabre Overides / Travel dep. access or HAP
−
|
+
| &nbsp;
 
|-
 
|-
 
| gwsAgencyLocation
 
| gwsAgencyLocation
Zeile 910: Zeile 1'063:
 
| 3-Letter-City-Code
 
| 3-Letter-City-Code
 
|-
 
|-
−
| aetmMainCommunity
+
| cytricElement
 +
| Cytric Org.
 +
| Cytric Location ID
 +
|-
 +
| mainTravelGroup
 
| Main Group
 
| Main Group
 
| AeTM Home Community
 
| AeTM Home Community
Zeile 919: Zeile 1'076:
 
|-
 
|-
 
| parentCompany.uuid
 
| parentCompany.uuid
−
| Parent company / uuid
+
| Parent company / uuid
 
| Database number (uuid) from the parent company - mandatory for import
 
| Database number (uuid) from the parent company - mandatory for import
 
|-
 
|-
Zeile 926: Zeile 1'083:
 
| Name from the parent company
 
| Name from the parent company
 
|-
 
|-
−
| hotelmemberships0.allicance
+
| hotelmemberships0.alliance
 
| Hotel Travelguideline / Hotel Chain
 
| Hotel Travelguideline / Hotel Chain
 
| 2-Letter-Hotel chain-Code
 
| 2-Letter-Hotel chain-Code
 
|-
 
|-
 
| hotelmemberships0.membernumber
 
| hotelmemberships0.membernumber
−
| Hotel Travelguidelines / Ratecode
+
| Hotel Travelguidelines / Ratecode
−
| 3-Letter-Rate-Code  
+
| 3-Letter-Rate-Code
−
|-  
+
|-
 
| hotelmemberships0.additionalinfo
 
| hotelmemberships0.additionalinfo
 
| Hotel Travelguidelines / Customer Request
 
| Hotel Travelguidelines / Customer Request
−
|
+
| &nbsp;
 
|-
 
|-
 
| carmemberships0.alliance
 
| carmemberships0.alliance
Zeile 944: Zeile 1'101:
 
| carmemberships0.membernumber
 
| carmemberships0.membernumber
 
| Car Travelguidelines / Corporate discount number
 
| Car Travelguidelines / Corporate discount number
−
|  
+
| &nbsp;
 
|-
 
|-
 
| carmemberships0.additionalinfo
 
| carmemberships0.additionalinfo
 
| Car Travelguidelines / Customer Reqeust
 
| Car Travelguidelines / Customer Reqeust
−
|
+
| &nbsp;
 
|-
 
|-
 
| carmemberships0.additionalinfo2
 
| carmemberships0.additionalinfo2
 
| Car Travelguidelines / Billing Number
 
| Car Travelguidelines / Billing Number
−
|  
+
| &nbsp;
 
|-
 
|-
 
| airlineincentives0.alliance
 
| airlineincentives0.alliance
Zeile 958: Zeile 1'115:
 
| 2-Letter-Airline-Code
 
| 2-Letter-Airline-Code
 
|-
 
|-
−
| airlineincentives0.membernumber
+
| airlineincentives0.additionalinfo
 
| Airline Companyprogram / Info
 
| Airline Companyprogram / Info
−
|
+
| &nbsp;
 +
|-
 +
| airlineincentives0.publishAs
 +
| Airline Companyprogram / Publish as
 +
|
 +
*OS (OSI Element)
 +
*SK (Special Keyword)
 +
 
 
|-
 
|-
 
| sortedCreditcards0.type
 
| sortedCreditcards0.type
 
| Credit cards / Card type
 
| Credit cards / Card type
−
|
+
|  
−
* VI = Visa
+
*VI = Visa  
−
* AX = American Express
+
*AX = American Express  
−
* CA = Mastercard / Eurocard
+
*CA = Mastercard / Eurocard  
−
* TP = AirPlus
+
*TP = AirPlus  
−
* DC = Diners
+
*DC = Diners  
 +
 
 
|-
 
|-
 
| sortedCreditcards0.numberMasked
 
| sortedCreditcards0.numberMasked
Zeile 981: Zeile 1'146:
 
| sortedCreditcards0.publishAsFop
 
| sortedCreditcards0.publishAsFop
 
| Credit cards / use as form of payment
 
| Credit cards / use as form of payment
−
|
+
|  
−
*true
+
*true  
−
*false
+
*false  
 +
 
 
|-
 
|-
 
| sortedPublishStates0.recordlocator
 
| sortedPublishStates0.recordlocator
−
| Target System Profile number
+
| Publishing / locator
 +
| Profile record locator/Profile number/Profile name
 +
|-
 +
| sortedPublishStates2.internallocator
 +
| Publishing / internallocator
 +
| &nbsp;
 +
|-
 +
| sortedPublishStates0.id.publishTarget
 +
| interface / targetsystem
 
|  
 
|  
−
*Amadeus = Profile record locator
+
*CSX = Amadeus  
−
*Galileo = Profile Name
+
*GALILEO_WS = Galileo
 +
*SABRE = Sabre
 +
*FARELOGIX = Farelogix
 +
 
 
|-
 
|-
−
| sortedPublishStates0.id.publishTarget
 
−
| Target System
 
 
|  
 
|  
−
* CSX = Amadeus
+
sortedTargetSystems0.agencyInterface.targetSystem&nbsp;&nbsp; &nbsp;
−
* GALILEO_WS = Galileo
+
 
 +
| Target GDS / Target system
 +
|
 +
*CSX = Amadeus  
 +
*GALILEO_WS = Galileo  
 +
*SABRE = Sabre
 +
*FARELOGIX = Farelogix
 +
 
 +
|-
 +
| sortedTargetSystems0.agencyInterface.label
 +
| Target GDS / Label
 +
| &nbsp;
 
|-
 
|-
 
| aetmSiteCode
 
| aetmSiteCode
−
| AeTM Site Code  
+
| AeTM Site Code
−
| 8 characters community Code
+
| &nbsp;8 characters community Code (import only)
 
|-
 
|-
 
| aetmSiteName
 
| aetmSiteName
 
| AETM Site Name
 
| AETM Site Name
−
|  
+
| &nbsp;
 
|-
 
|-
 
| privateCcIndex
 
| privateCcIndex
 
| Personal CC on
 
| Personal CC on
−
|
+
|  
−
* CC_1
+
*CC_1&nbsp;
−
* CC_2
+
*CC_2  
−
* CC_3
+
*CC_3<br/> (import only)
 +
 
 
|-
 
|-
 
| privateCcIndex2
 
| privateCcIndex2
 
| 2nd Personal CC on
 
| 2nd Personal CC on
−
|
+
|  
−
* CC_1
+
*CC_1  
−
* CC_2
+
*CC_2  
−
* CC_3
+
*CC_3<br/> (import only)
 +
 
 
|-
 
|-
 
| privateCcIndex3
 
| privateCcIndex3
 
| 3rd Personal CC on
 
| 3rd Personal CC on
−
|
+
|  
−
* CC_1
+
*CC_1  
−
* CC_2
+
*CC_2  
−
* CC_3
+
*CC_3<br/> (import only)
 +
 
 
|-
 
|-
 
| cytricElement
 
| cytricElement
 
| Cytric Org (system number)
 
| Cytric Org (system number)
−
|
+
| &nbsp;
 
|-
 
|-
 
| sortedTravelGroups0.id.groupId
 
| sortedTravelGroups0.id.groupId
 
| Travel Groups
 
| Travel Groups
 
|  
 
|  
−
*Cytric Travelpolicy Group (number)
+
*Cytric Travelpolicy Group (number)  
−
*AeTM Community Code
+
*AeTM Community Code<br/> (import only)
 +
 
 
|-
 
|-
 
| sortedTravelGroups0.name
 
| sortedTravelGroups0.name
 
| Travel Group / Description
 
| Travel Group / Description
−
|
+
|  
−
* Cytric Travelpolicy Name
+
*Cytric Travelpolicy Name  
−
* AeTM Community Name
+
*AeTM Community Name<br/> (import only)
 +
 
 
|-
 
|-
 
| genInternal<Name>.elective
 
| genInternal<Name>.elective
 
| <Name>
 
| <Name>
−
|
+
|  
−
* HIDDEN
+
*HIDDEN  
−
* MANDATORY
+
*MANDATORY  
−
* OPTIONAL
+
*OPTIONAL  
 +
 
 
|-
 
|-
 +
| general.comment
 +
| comment
 +
| &nbsp;
 
|}
 
|}
  
−
=== CSV Upload===
+
=== CSV Upload ===
  
−
Please refer to section [[Profile Company#CSV Download / Upload|CSV Download / Upload]].
+
Please refer to section [[Profile_Company#CSV_Download_/_Upload|CSV Download / Upload]]. Additional Upload fields
  
−
Additional Upload field
+
{|
 +
|-
 +
! Field
 +
! Description
 +
|-
 +
| cytricElement
 +
| Cytric Org./Cytric Location ID
 +
|-
 +
| cytricEndpoint
 +
| Cytric Server
 +
|}
  
−
cytricElement = Cytric Org. Cytric Location ID
+
&nbsp;
−
cytricEndpoint = Cytric Server
 
  
−
== Section 'Send credentials'==
+
To mass delelte company profile please add column "metadata.action" with the value DELETE
 +
 
 +
== Section 'Send credentials' ==
  
 
Credentials can be send to all profiles or to all arrangers and to all profiles or all arranger from a specific company. The email address, which is stored at the field E-mail in the profile, will be used for sending the credentials
 
Credentials can be send to all profiles or to all arrangers and to all profiles or all arranger from a specific company. The email address, which is stored at the field E-mail in the profile, will be used for sending the credentials
  
 
{|
 
{|
−
!Field
 
−
!Description
 
 
|-
 
|-
−
|All profiles
+
! Field
−
|Send credentials to all profiles (Traveller, Arranger, Approver, Profilmanager)
+
! Description
 
|-
 
|-
−
|All arrangers
+
| All profiles
−
|Send credentials to all arrangers
+
| Send credentials to all profiles (Traveller, Arranger, Approver, Profilmanager)
 
|-
 
|-
−
|Company field
+
| All arrangers
−
|Choose the company for which credentials should be send (all profiles or all arrangers)
+
| Send credentials to all arrangers
 
|-
 
|-
 +
| Company field
 +
| Choose the company for which credentials should be send (all profiles or all arrangers)
 
|}
 
|}

Aktuelle Version vom 15. November 2019, 12:46 Uhr

General

The Profile Center shows an overview about the numbers of profiles created in Umbrella Faces. Additionally it informs about publishing errors (synchronisation errors), provides the opportunity to Import/Export CSV-File for one, several or all travellers related to company profiles, provides a possibility to mass-synchronize profiles and to send mass-credentials. Some functions are not available for every user.

Layout

Profile-Center

Section 'Travel Agency'

Overview about the number of all company and traveller profiles available in "your agency" at Umbrella Faces.

Field Description
No. of companies The count of all company profiles created in Umbrella Faces are displayed.
No. of travellers The count of all traveller profiles created in Umbrella Faces are displayed.

Section 'Publishing Errors'

Publishing errors may occur when creating profiles manually in the user Interface. It is important to identify any such publishing error during/after a CSV Upload. A list of all errors is shown including a hyperlink, which leads directly to the incorrect profile.

Field Description
Company List of all companies with a publishing (synchronisation) error including the related system (e.g. Amadeus CSX) and error message (e.g. Record locater not found)
Traveller List of all travellers with a publishing (synchronisation) error including the related system (e.g. AeTM) and error message (e.g. Login name not found).

Section 'Publishing'

Publishing can be used to save all profiles, either the erroneous (see publishing errors), all company and traveller profiles and travellers from a specific company. Publishing all travellers and/or companies could have an enormous impact to your profiles.

Field Description
Travellers of Save (publishing) all travellers of a specific company
All erroneous Save (publishing) all errors, which are displayed in the section error publishing
All companies Save (publishing) all company profiles
All travellers Save (publishing) all traveller profiles

Section 'Send Credentials'

Credentials can be send to all profiles or arrangers of specific company profiles

Field Description
Company Search for the company profile
All profiles Send credentials to all profiles (traveller, arranger, approver) of the specified company
All arrangers Send credentials to all arrangers of the specified company

Section 'Import/Export'

Export

The Export function allows to download all companies or traveller profiles from one or multiple companies via CSV File.

Field Description
Company Insert a specific company for the CSV-File download
Add new Add additional companies, which should be part of the CSV-file download
Travellers (CSV) Click to start the download of travellers of a specific company into a CSV-file
All travellers (CSV) Click to download all travellers of your agency into a CSV-file
All companies (CSV) Click to download all companies of your agency into a CSV-file

Fields with long text areas and starting with '-' are not being exported correctly. This is an Excel bug and is caused since the programm believes that the cell should be formatted as number-cell and hence has a maximum of characters. We strongly recommend to not use '-' at the beginning of a text area field (e.g. Comment Box).
 

Import

The Import function allows to upload via CSV file, from Amadeus CSX or AeTM.

Field Description
Import Opiton
  • CSV: upload companies or traveller profiles from multiple companies via CSV File. Traveller profiles form a single profile has to be imported in the company Profile!
  • Amadeus CSX: upload Company including all associated traveller profiles form Amadeus CSX
  • AeTM: upload all traveller form AeTM for a specific Company
  CSV
Upload from CSV Upload the CSV-file for 'travellers' or 'companies'
  • Note: Mandatory columns for travellers CSV upload are: metadata.action, uuid, username, firstname, gender, name, email, company.uuid
  Amadeus CSX
Agency Select relevant travel agency
System Amadeus CSX
Profile no. Amadeus company profile record locator
Office ID Amadeus Office Id in which the company profile belongs to.
Org-ID. Amadeus Organisation Id (optional)
Bulk company upload The activation of the checkbox and the click on <Import> will provide a list of all existing company profiles in the Amadeus Office ID. In this step every single company profile is de- or selectable. Please note that a mass upload will take some time (approx. 1000 profiles / 15 minutes). The upload will import all company profiles with their associated traveller profiles.
Import Click on Import will upload the company and all associated traveller profiles.

A username for the traveller profile will be automatically created <first name>.<sure name>@<company short name> Following Amadeus CSX prefix can be processed:

  • AB
  • AM (Traveller only)
  • AP
  • APE
  • ES
  • FFN
  • FP (if Amadeus Local Security Sign is set PCD-Y)
  • FPO/
  • FK
  • FT
  • FZ
  • NM
  • OS
  • PAS
  • PBD
  • PCI
  • PCZ
  • PID
  • PIV
  • PHI
  • PN
  • PPR
  • PPT
  • RM
  • RC
  • RX
  • RM (category e.g. RMA/)
  • RIR
  • RIZ
  • SR DOCS
  • SK
  AeTM
Agency Select relevant travel agency
Company Select relevant company. Company needs at least a setup in the AeTM Site-Code, Main Group and Travel Group.

CSV-File - Description 'Travellers'

The download of travellers in a CSV File includes following information.

General: In some fields more than one input is possible. In this case the columns contain the value “0”. Enter more values by adding the numbers behind the value.

Example: Enter 3 Frequent Flyer numbers in the CSV-File

first number flightmemberships0.alliance
second number flightmemberships1.alliance
third number flightmemberships3.alliance

 

 


Standard Fields

The CSV file will always include the standard fields of Umbrella Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circle are uploaded, than the values will be ignored.

Column Description Values/Actions
metadata.action Action
  • SAVE
  • DELETE
uuid Database No. Blank if new profile
username Faces Username  
email E-Mail Address  
language User language
  • cs_CZ = Czech (Czech Republic)
  • nl_BE = Dutch (Belgium)
  • nl_NL = Dutch (Netherlands)
  • en_GB = English (United Kingdom)
  • en_US = English (United States)
  • fr_CH = French (Switzerland)
  • fr_FR = French (France)
  • de_AT = German (Austria)
  • de_DE = German (Germany)
  • de_CH = German (Switzerland)
  • hu_HU = Hungarian (Hungary)
  • it_IT = Italian (Italy)
  • it_CH = Italian (Switzerland)
  • pl_PL = Polish (Poland)
  • pt_PT = Portuguese (Portugal)
  • sk_SK = Slovak (Slovakia)
  • es_ES = Spanish (Spain)
company.uuid Database No. Company  
gender Gender
  • MR
  • MRS
  • U
title Title
  • DR
  • PROF
name Surename  
middlename Middlename  
firstname Firstname  
birthdate Date of birth Format = dd.mm.yyyy
nationality Citizenship 2-letter-country-code e.g. CH
additionalFormOfPayment Other forms of payment
  • CASH
  • INV
hotelGuarantee Hotel guarantee
  • T/00 = 1st Traveller credit card
  • T/01 = 2nd Traveller credit card
  • T/02 = 3rd Traveller credit Card
  • C/00 = 1st Company credit card
  • C/01 = 2nd Company credit card
  • C/02 = 3rd Company credit card
carGuarantee Guarantee rental car
  • T/00 = 1st Traveller credit card
  • T/01 = 2nd Traveller credit card
  • T/02 = 3rd Traveller credit Card
  • C/00 = 1st Company credit card
  • C/01 = 2nd Company credit card
  • C/02 = 3rd Company credit card
webcard Webcard
  • T/00 = 1st Traveller credit card
  • T/01 = 2nd Traveller credit card
  • T/02 = 3rd Traveller credit Card
  • C/00 = 1st Company credit card
  • C/01 = 2nd Company credit card
  • C/02 = 3rd Company credit card
phoneBusiness Phone Business  
phonePrivate Phone private  
phoneMobile Mobile  
receivedocs Itinerary / e-ticket (yes/no)
  • true
  • false
preferredSeat Seat Request
  • A = Aisle
  • W = Window
preferredFood Meal Request e.g. VGML
smoker Smoker
  • true
  • false
traveller Traveller
  • true
  • false
arranger Arranger / Assistance
  • true
  • false
approver Approver
  • true
  • false
comment general.comment  
company.recordlocator Company / Profile no.  
company.uuid Company / uuid  
company.name Company / Company Name  
railExtension.delivery Rail information / Delivery
  • BAHNTIX
  • ONLINE
  • PAPERTICKET
  • BAHNTIX
railExtension.wagonType Rail information / Wagontype
  • COMPARTMENT
  • PREFER_WIDEBODY
  • REQUIRE_WIDEBODY
  • SINGLE
  • TABLE
railExtension.wagonExtraType Rail information / Wagon extra
  • PHONEAREA
  • QUIETAREA
railExtension.seatpref Rail information / Seat
  • AISLE
  • WINDOW
railExtension.railclass Rail information / Class
  • FIRST
  • SECOND
railExtension.identification Rail information / Identification
  • BANKCARD
  • PERSONALCARD
  • RAILCARD
railExtension.idInfo Rail information / Bank card  
railExtension.railCards0.cardtype Railcard / Card

Rail: Amadeus_Germany

  • BAHNBONUS = DB bahn.bonus
  • BONUSCARD = DB Bonuscard Business
  • DB100 = DB BahnCard 100
  • DB25 = DB BahnCard 25
  • DB25_BUSINESS = DB BahnCard 25 Business
  • DB50 = DB BahnCard 50
  • DB50_BUSINESS = DB BahnCard 50 Business
  • SBB_GA = GA Travelcard / Swisspass
  • SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass
  • SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass

Rail: Amadeus_Rail

  • SNCF_JEUNE
  • SNCF_SENIOR
  • SNCF_WEEKEND
  • SNCF_CFF50
  • SNCF_CFF50
  • SNCF_CLUBTCP
  • SNCF_FAM30
  • SNCF_FAM40
  • SNCF_FAM50
  • SNCF_FAM75
  • SNCF_FORFAIT
  • SNCF_FORFAIT
  • SNCF_FR_MILITARY
  • SNCF_FR_MILITARY
  • SNCF_FREQ50
  • SNCF_FREQ50
  • SNCF_FREQ_INTERMED
  • SNCF_FREQ_INTERMED
  • THALYS_LYS
  • THALYS_CORP
  • THALYS_PASS_BUSINESS
  • THALYS_PASS_PREMIUM
  • THALYS_PASS_WEEKEND
  • SJR_SJ_PRIO
  • SJR_ARSKORT_GOLD
  • SJR_ARSKORT_GOLD_RES
  • SJR_ARSKORT_SILVER
  • SJR_ARSKORT_SILVER_RES
  • SJR_ARSKORT_SILVER_PL
  • SJR_ARSKORT_SIL_PL_RES
  • SNCF_EUROSTAR
  • SNCF_CARD
  • SNCF_CLUB
  • SNCF_PLUS
  • SNCF_VOYAGEUR
  • THALYS_CARD
  • TTL_16_25
  • TTL_ANNUAL_GOLD
  • TTL_CAMBRIAN_LINES
  • TTL_COTSWORLD_LINE
  • TTL_DALES
  • TTL_DEVON_CORNWALL
  • TTL_DISABLED_ADULT
  • TTL_ESK_VALLEY
  • TTL_GROUPSAVE
  • TTL_HEART_OF_WALES
  • TTL_HIGHLAND
  • TTL_HM_FORCES
  • TTL_JOBCENTRE_PLUS
  • TTL_NETWORK
  • TTL_NEW_DEAL
  • TTL_PEMBROKESHIRE
  • TTL_SCOTTISH_YOUTH
  • TTL_SENIOR
  • TTL_TWO_TOGETHER
  • TTL_VALLEY_LINES_SENIOR
  • TTL_VALLEY_LINES_JUNIOR
  • DB25
  • DB25
  • DB25_BUSINESS
  • DB25_BUSINESS
  • DB50
  • DB50
  • DB50_BUSINESS
  • DB50_BUSINESS
  • DB100
  • DB100
  • BONUSCARD
  • SBB_HALFPRICE
  • SBB_HALFPRICE_RAILPLUS
  • SBB_GA
  • OEBB_VC
  • RENFE_CARNET_GO_25_ISTC
  • RENFE_CARNET_JOVEN
  • RENFE_TARJETA_DORADA
  • RENFE_TARJETA_JOVEN
  • RENFE_TARJETA_RAIL_PLUS_JUNIOR
  • RENFE_PLUS
railExtension.railCards0.cardnumber Railcard / Number  
railExtension.railCards0.cardExpiration Railcard / Expiration Format = dd.mm.yyyy
residentExtension.area Resident information / Resident Discount
  • CANARY
  • BALEARIC
  • CEUTA
  • MELILLA
residentExtension.areaCode Resident information / Area/Post Code post code (numbers)
residentExtension.cardType Resident information / National Identity Card type
  • NATIONAL_ID
  • MINOR_RESIDENT
  • RESIDENT_CARD
  • TEMP_RESIDENT
residentExtension.cardNumber Resident information / National Identity Card number  
residentExtension.firstSurname Resident information /  
residentExtension.secondSurname Resident information /  
flightmemberships0.alliance Frequent flyer / Airline 2-letter-airline-code e.g. SR (Swiss)
flightmemberships0.membernumber Frequent Flyer / Number  
flightmemberships0.additionalinfo Frequent Flyer / PIN  
hotelmemberships0.alliance Hotel Program / Hotel chain 2-letter-hotel-code e.g. RT (Accor Hotel)
hotelmemberships0.membernumber Hotel Program / Customer Number  
hotelmemberships0.additionalinfo Hotel Program / Customer Request  
carmemberships0.alliance Car Program / Company 2-letter-car company-code e.g. ZE (Herz)
carmemberships0.membernumber Car Program / Customer Number  
carmemberships0.additionalinfo Car Program / Customer Request  
carmemberships0.specialRequest Car Program / Special request  
passports0.country Passport / Country 2-letter-country-code e.g. CH
passports0.number Passport / Number  
passports0.issuedate Passport / Issue date Format = dd.mm.yyyy
passports0.issueplace Passport / Issue place  
passports0.issueCountry Passport / Issue country 2-letter-country-code e.g. CH
passports0.expiration Passport / Expires Format = dd.mm.yyyy
visa0.country Visa Information / Country 2-letter-country-code e.g. RU
visa0.number Visa Information/ Number  
visa0.issuedate Visa Information / Issue date Format = dd.mm.yyyy
visa0.issueplace Not available in the user interface  
visa0.expiration Visa Information / Expires Format = dd.mm.yyyy
visa0.multiPurposeString Visa Information / Entry type
  • SINGLE
  • DOUBLE
  • MULTIPLE
employeecards0.country Identification cards / Country 2-letter-country-code e.g. CH
employeecards0.number Identification cards / Number  
employeecards0.issuedate Not available in the user Interface  
employeecards0.issueplace Not available in the user Interface  
employeecards0.expiration Not available in the user Interface  
arrangercontacts0.contact Administration / Arranger / Assitance Arrangers email address
arrangercontacts0.receivedocs Itinerary / e-ticket (yes/no)
  • true
  • false
approvercontacts0.contact Administration / Approver Approvers email address
approvercontacts0.receivedocs Itinerary / e-ticket (yes/no)
  • true
  • false
emergencycontacts0.firstname Emergency Contact / First Name  
emergencycontacts0.lastname Emergency Contact / Surname  
emergencycontacts0.email Emergency Contact / E-Mail  
emergencycontacts0.phone Emergency Contact / Phone  
emergencycontacts0.receivedocs Itinerary / e-ticket (yes/no)
  • true
  • false
sortedTravelGroups0.groupId Travel groups / Main travel group community code e.g. ABCDABCD (AeTM) or Location, Division (cytric)
sortedTravelGroups0.role Travel groups / Role

Cytric:

  • USER = User
  • TRAVELER = Booker
  • PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all)
  • APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted)
  • TRAVEL_ARRANGER = Travel Arranger
  • TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin)
  • TRAVEL_APPROVER = Trip Approver

AeTM:

  • ADMINISTRAOR
  • TRAVELER
  • PRINCIPAL_TRAVEL_ARRANGER
  • APPOINTEDTRAVEL_ARRANGER
  • TRAVEL_APPROVER
  • FALLBACK_APPROVER
sortedTravelGroups1.groupId Travel groups / Further travel group  
sortedPublishStates0.id.publishtarget Target system
  • CSX = Amadeus
  • GALILEO_WS = Galileo
  • CYTRIC = Cytric
  • AETM = Amadeus e-travel management
sortedPublishStates0.recordlocator Target system identification number/name
  • Amadeus = Profile record locator
  • Galileo = Profile Name
  • AeTM = Login Name

if cell is blank, a new profile in the target system will be created

if cell contains value, the existing profile in the target system will be synchronised

sortedPublishStates0.internallocator Target System additional number/name AeTM = traveller id

Only for import, no export available

Column Values/Actions
sortedCreditcards#.type Credit card vendor (VI, AX, CA etc.)
sortedCreditcards#.numberMasked Credit card number
sortedCreditcards0.expiration Credit card expiry
sortedCreditcards0.publishAsFop
  • TRUE = use as form of payment
  • FALSE = not use as form of payment

Custom fields 'Single Company CSV file'

Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data.

column Description
mergedgroups:general.header_general:0.value Section 'General'
mergedgroups:company.header_agency:0.value Section 'Your Agency'
mergedgroups:traveller.adminheader:0.value Section 'Administration'
mergedgroups:general.header_prefs:0.value Section 'Preferences'
mergedgroups:traveller.papersheader:0.value Section 'Travel documents'
genericgroups0.fields0.value Section '-custom-' e.g. Reference Details

Custom fields 'Multiple Company CSV file'

Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file will include generic data. The 'Multiple Company CSV-file' contains other column identifiers compared to the 'Single Company CSV-file'. All custom fields are named with 'allgroups0.fields0.value' in a numeric row. The custom fields from a company setup are highlighted with a ‘!’ in column 2 followed by the given name of the field.

Example:

  my agency custom fields company setup custom fields
CSV column 1 allgroups0.fields0.value allgroups1.fields0.value
CSV column 2 Contract Details  !Staff No. for Umbrella

The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field

 

 

 


CSV-File - Description 'Companies'

The download of companies in a CSV File includes following Information

Column Description Values/Actions
recordlocator Profile no.

Amadeus CSX Profil Recloc

uuid Database number Blank if new profile
externalnr Customer no.  
name Company Name  
shortname Short Name  
emailDelivery Email delivery
  • EMAIL = Amadeus Mail
  • EMAILPLUS = Amadeus Fax and Email plus
travellerFopOption Personal Cards
  • FP_AND_GUARANTEE = FP and Guarantee
  • GUARANTEE_ONLY = Guarantee only
  • NONE = none
additionalFormOfPayment Other forms of payment INV = Invoice
hotelGuarantee Guarantee Hotel  
carGuarantee Guarantee rental car  
confidential Confidential  
street Street  
street2 Street 2  
zip Zip  
place Place  
country Country 2-letter-Country-Code
phone Phone  
fax Fax  
email Email  
email2 Email 2  
email3 Email 3  
emailInvoiceDelivery Email invoice delivery  
receivedocs Itinerary / e-ticket  
selfRegistrationKey Self-registration key      
gwsOverrides.office Galileo Overrides / Travel dep, PCC or IPCC Galileo PCC
overrideGwsAdditionalInfo Galileo Overrides / Travel dep, PCC or IPCC Galileo HAP (mandatory)
csxOverrides.office CSX Overrides / Travel dep, PCC or IPCC Amadeus OID
overrideCsxAdditionalInfo CSX Overrides / Travel dep. access or HAP Amadeus Org Id (optional)
sabreOverrides.office Sabre Overides / Travel dep, PCC or IPCC Sabre PCC
sabreOverrides.additionalInfo Sabre Overides / Travel dep. access or HAP  
gwsAgencyLocation Agency Location 3-Letter-City-Code
cytricElement Cytric Org. Cytric Location ID
mainTravelGroup Main Group AeTM Home Community
parentCompany.recordlocator Parent company / Profile no. Profil number from the parent company
parentCompany.uuid Parent company / uuid Database number (uuid) from the parent company - mandatory for import
Parent company / Company name parentCompany.name Name from the parent company
hotelmemberships0.alliance Hotel Travelguideline / Hotel Chain 2-Letter-Hotel chain-Code
hotelmemberships0.membernumber Hotel Travelguidelines / Ratecode 3-Letter-Rate-Code
hotelmemberships0.additionalinfo Hotel Travelguidelines / Customer Request  
carmemberships0.alliance Car Travelguidelines / Company 2-Letter-Rental Car-Code
carmemberships0.membernumber Car Travelguidelines / Corporate discount number  
carmemberships0.additionalinfo Car Travelguidelines / Customer Reqeust  
carmemberships0.additionalinfo2 Car Travelguidelines / Billing Number  
airlineincentives0.alliance Airline Companyprogram / Company 2-Letter-Airline-Code
airlineincentives0.additionalinfo Airline Companyprogram / Info  
airlineincentives0.publishAs Airline Companyprogram / Publish as
  • OS (OSI Element)
  • SK (Special Keyword)
sortedCreditcards0.type Credit cards / Card type
  • VI = Visa
  • AX = American Express
  • CA = Mastercard / Eurocard
  • TP = AirPlus
  • DC = Diners
sortedCreditcards0.numberMasked Credit cards / Number no Export function / only Import
sortedCreditcards0.expiration Cerdit cards / Expiration Format DD.MM.YYYY
sortedCreditcards0.publishAsFop Credit cards / use as form of payment
  • true
  • false
sortedPublishStates0.recordlocator Publishing / locator Profile record locator/Profile number/Profile name
sortedPublishStates2.internallocator Publishing / internallocator  
sortedPublishStates0.id.publishTarget interface / targetsystem
  • CSX = Amadeus
  • GALILEO_WS = Galileo
  • SABRE = Sabre
  • FARELOGIX = Farelogix

sortedTargetSystems0.agencyInterface.targetSystem    

Target GDS / Target system
  • CSX = Amadeus
  • GALILEO_WS = Galileo
  • SABRE = Sabre
  • FARELOGIX = Farelogix
sortedTargetSystems0.agencyInterface.label Target GDS / Label  
aetmSiteCode AeTM Site Code  8 characters community Code (import only)
aetmSiteName AETM Site Name  
privateCcIndex Personal CC on
  • CC_1 
  • CC_2
  • CC_3
    (import only)
privateCcIndex2 2nd Personal CC on
  • CC_1
  • CC_2
  • CC_3
    (import only)
privateCcIndex3 3rd Personal CC on
  • CC_1
  • CC_2
  • CC_3
    (import only)
cytricElement Cytric Org (system number)  
sortedTravelGroups0.id.groupId Travel Groups
  • Cytric Travelpolicy Group (number)
  • AeTM Community Code
    (import only)
sortedTravelGroups0.name Travel Group / Description
  • Cytric Travelpolicy Name
  • AeTM Community Name
    (import only)
genInternal<Name>.elective <Name>
  • HIDDEN
  • MANDATORY
  • OPTIONAL
general.comment comment  

CSV Upload

Please refer to section CSV Download / Upload. Additional Upload fields

Field Description
cytricElement Cytric Org./Cytric Location ID
cytricEndpoint Cytric Server

 

To mass delelte company profile please add column "metadata.action" with the value DELETE

Section 'Send credentials'

Credentials can be send to all profiles or to all arrangers and to all profiles or all arranger from a specific company. The email address, which is stored at the field E-mail in the profile, will be used for sending the credentials

Field Description
All profiles Send credentials to all profiles (Traveller, Arranger, Approver, Profilmanager)
All arrangers Send credentials to all arrangers
Company field Choose the company for which credentials should be send (all profiles or all arrangers)
Von «http://doc.umbrella.ch/tzdoc/index.php?title=Profil_Center&oldid=1580»