Profil Center: Unterschied zwischen den Versionen

Aus Faces Dokumentation
Wechseln zu: Navigation, Suche
Zeile 100: Zeile 100:
 
|}
 
|}
  
−
===Import===
+
 
−
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  
 +
 
 
|-
 
|-
−
|
+
|  
 
| ''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  
 +
 
 
|-
 
|-
−
|
+
|  
 
| ''Amadeus CSX''
 
| ''Amadeus CSX''
 
|-
 
|-
Zeile 127: Zeile 132:
 
|-
 
|-
 
| System
 
| System
−
| Amadeus CSX  
+
| Amadeus CSX
 
|-
 
|-
 
| Profile no.
 
| Profile no.
Zeile 139: Zeile 144:
 
|-
 
|-
 
| 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 190:
 
|-
 
|-
 
| 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' ===
 +
 
 +
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
 +
|}
 +
 
 +
&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.
 +
 
 +
{|
 +
|-
 +
! Column
 +
! Description
 +
! Values/Actions
 +
|-
 +
| metadata.action
 +
| Action
 +
|
 +
*SAVE
 +
*DELETE
 +
 
 +
|-
 +
| uuid
 +
| Database No.
 +
| Blank if new profile
 +
|-
 +
| username
 +
| Faces Username
 +
| &nbsp;
 +
|-
 +
| email
 +
| E-Mail Address
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| gender
 +
| Gender
 +
|
 +
*MR
 +
*MRS
 +
 
 +
|-
 +
| title
 +
| Title
 +
|
 +
*DR
 +
*PROF
 +
 
 +
|-
 +
| name
 +
| Surename
 +
| &nbsp;
 +
|-
 +
| middlename
 +
| Middlename
 +
| &nbsp;
 +
|-
 +
| firstname
 +
| Firstname
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| phonePrivate
 +
| Phone private
 +
| &nbsp;
 +
|-
 +
| phoneMobile
 +
| Mobile
 +
| &nbsp;
 +
|-
 +
| receivedocs
 +
| Itinerary / e-ticket (yes/no)
 +
|
 +
*true
 +
*false
 +
 
 +
|-
 +
| preferredSeat
 +
| Seat Request
 +
|
 +
*A = Aisle
 +
*W = Window
 +
 
 +
|-
 +
| smoker
 +
| Smoker
 +
|
 +
*true
 +
*false
 +
 
 +
|-
 +
| traveller
 +
| Traveller
 +
|
 +
*true
 +
*false
 +
 
 +
|-
 +
| arranger
 +
| Arranger / Assistance
 +
|
 +
*true
 +
*false
 +
 
 +
|-
 +
| approver
 +
| Approver
 +
|
 +
*true
 +
*false
 +
 
 +
|-
 +
| comment
 +
| general.comment
 +
| &nbsp;
 +
|-
 +
| company.recordlocator
 +
| Company / Profile no.
 +
| &nbsp;
 +
|-
 +
| company.uuid
 +
| Company / uuid
 +
| &nbsp;
 +
|-
 +
| company.name
 +
| Company / Company Name
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| residentExtension.firstSurname
 +
| Resident information /
 +
| &nbsp;
 +
|-
 +
| residentExtension.secondSurname
 +
| Resident information /
 +
| &nbsp;
 +
|-
 +
| flightmemberships0.alliance
 +
| Frequent flyer / Airline
 +
| 2-letter-airline-code e.g. SR (Swiss)
 +
|-
 +
| flightmemberships0.membernumber
 +
| Frequent Flyer / Number
 +
| &nbsp;
 +
|-
 +
| flightmemberships0.additionalinfo
 +
| Frequent Flyer / PIN
 +
| &nbsp;
 +
|-
 +
| hotelmemberships0.alliance
 +
| Hotel Program / Hotel chain
 +
| 2-letter-hotel-code e.g. RT (Accor Hotel)
 +
|-
 +
| hotelmemberships0.membernumber
 +
| Hotel Program / Customer Number
 +
| &nbsp;
 +
|-
 +
| hotelmemberships0.additionalinfo
 +
| Hotel Program / Customer Request
 +
| &nbsp;
 +
|-
 +
| carmemberships0.alliance
 +
| Car Program / Company
 +
| 2-letter-car company-code e.g. ZE (Herz)
 +
|-
 +
| carmemberships0.membernumber
 +
| Car Program / Customer Number
 +
| &nbsp;
 +
|-
 +
| carmemberships0.additionalinfo
 +
| Car Program / Customer Request
 +
| &nbsp;
 +
|-
 +
| passports0.country
 +
| Passport / Country
 +
| 2-letter-country-code e.g. CH
 +
|-
 +
| passports0.number
 +
| Passport / Number
 +
| &nbsp;
 +
|-
 +
| passports0.issuedate
 +
| Passport / Issue date
 +
| Format = dd.mm.yyyy
 +
|-
 +
| passports0.issueplace
 +
| Passport / Issue place
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| visa0.issuedate
 +
| Visa Information / Issue date
 +
| Format = dd.mm.yyyy
 +
|-
 +
| visa0.issueplace
 +
| Not available in the user interface
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| employeecards0.issuedate
 +
| Not available in the user Interface
 +
| &nbsp;
 +
|-
 +
| employeecards0.issueplace
 +
| Not available in the user Interface
 +
| &nbsp;
 +
|-
 +
| employeecards0.expiration
 +
| Not available in the user Interface
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| emergencycontacts0.lastname
 +
| Emergency Contact / Surname
 +
| &nbsp;
 +
|-
 +
| emergencycontacts0.email
 +
| Emergency Contact / E-Mail
 +
| &nbsp;
 +
|-
 +
| emergencycontacts0.phone
 +
| Emergency Contact / Phone
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| 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
 
|}
 
|}
  
−
<h3> CSV-File - Description 'Travellers'</h3><p>The download of travellers in a CSV File includes following information.</p><p><b>General:</b> 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.
+
==== Custom fields 'Multiple Company CSV file' ====
−
</p><p><b>Example:</b> Enter 3 Frequent Flyer numbers in the CSV-File
+
 
−
</p>
+
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.
−
<table>
+
 
−
<tr>
+
Example:
−
<td> first number
+
 
−
</td>
+
{|
−
<td> flightmemberships0.alliance
+
|-
−
</td></tr>
+
| &nbsp;
−
<tr>
+
! my agency custom fields
−
<td> second number
+
! company setup custom fields
−
</td>
+
|-
−
<td> flightmemberships1.alliance
+
! CSV column 1
−
</td></tr>
+
| allgroups0.fields0.value
−
<tr>
+
| allgroups1.fields0.value
−
<td> third number
+
|-
−
</td>
+
! CSV column 2
−
<td> flightmemberships3.alliance
+
| Contract Details
−
</td></tr></table>
+
| !Staff No. for Umbrella
−
<p>
+
|}
−
</p>
+
 
−
<h4>Standard Fields</h4><p>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.</p>
+
'''The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field'''
−
<table>
+
 
−
<tr>
+
=== CSV-File - Description 'Companies' ===
−
<th> Column
+
 
−
</th>
+
The download of companies in a CSV File includes following Information
−
<th> Description
+
 
−
</th>
+
{|
−
<th> Values/Actions
+
|-
−
</th></tr>
+
! Column
−
<tr>
+
! Description
−
<td> metadata.action
+
! Values/Actions
−
</td>
+
|-
−
<td> Action
+
| recordlocator
−
</td>
+
| Profile no.
−
<td>
+
|
−
<ul><li> SAVE</li>
+
Amadeus CSX Profil Recloc
−
<li> DELETE</li></ul>
+
 
−
</td></tr>
+
|-
−
<tr>
+
| uuid
−
<td> uuid
+
| Database number
−
</td>
+
| Blank if new profile
−
<td> Database No.
+
|-
−
</td>
+
| externalnr
−
<td> Blank if new profile
+
| Customer no.
−
</td></tr>
+
| &nbsp;
−
<tr>
+
|-
−
<td> username
+
| name
−
</td>
+
| Company Name
−
<td> Faces Username
+
| &nbsp;
−
</td>
+
|-
−
<td>
+
| shortname
−
</td></tr>
+
| Short Name
−
<tr>
+
| &nbsp;
−
<td> email
+
|-
−
</td>
+
| emailDelivery
−
<td> E-Mail Address
+
| Email delivery
−
</td>
+
|
−
<td>
+
*EMAIL = Amadeus Mail
−
</td></tr>
+
*EMAILPLUS = Amadeus Fax and Email plus
−
<tr>
+
 
−
<td> language
+
|-
−
</td>
+
| travellerFopOption
−
<td> User language
+
| Personal Cards
−
</td>
+
|
−
<td>
+
*FP_AND_GUARANTEE = FP and Guarantee
−
<ul><li> cs_CZ = Czech (Czech Republic)</li>
+
*GUARANTEE_ONLY = Guarantee only
−
<li> nl_BE = Dutch (Belgium)</li>
+
*NONE = none
−
<li> nl_NL = Dutch (Netherlands)</li>
+
 
−
<li> en_GB = English (United Kingdom) </li>
+
|-
−
<li> en_US = English (United States)</li>
+
| additionalFormOfPayment
−
<li> fr_CH = French (Switzerland)</li>
+
| Other forms of payment
−
<li> fr_FR = French (France)</li>
+
| INV = Invoice
−
<li> de_AT = German (Austria)</li>
+
|-
−
<li> de_DE = German (Germany)</li>
+
| hotelGuarantee
−
<li> de_CH = German (Switzerland)</li>
+
| Guarantee Hotel
−
<li> hu_HU = Hungarian (Hungary)</li>
+
| &nbsp;
−
<li> it_IT = Italian (Italy)</li>
+
|-
−
<li> it_CH = Italian (Switzerland)</li>
+
| carGuarantee
−
<li> pl_PL = Polish (Poland)</li>
+
| Guarantee rental car
−
<li> pt_PT = Portuguese (Portugal)</li>
+
| &nbsp;
−
<li> sk_SK = Slovak (Slovakia)</li>
+
|-
−
<li> es_ES = Spanish (Spain)</li></ul>
+
| confidential
−
</td></tr>
+
| Confidential
−
<tr>
+
| &nbsp;
−
<td> company.uuid
+
|-
−
</td>
+
| street
−
<td> Database No. Company
+
| Street
−
</td>
+
| &nbsp;
−
<td>
+
|-
−
</td></tr>
+
| street2
−
<tr>
+
| Street 2
−
<td> gender
+
| &nbsp;
−
</td>
+
|-
−
<td> Gender
+
| zip
−
</td>
+
| Zip
−
<td>
+
| &nbsp;
−
<ul><li> MR</li>
+
|-
−
<li> MRS  </li></ul>
+
| place
−
</td></tr>
+
| Place
−
<tr>
+
| &nbsp;
−
<td> title
+
|-
−
</td>
+
| country
−
<td> Title
+
| Country
−
</td>
+
| 2-letter-Country-Code
−
<td>
+
|-
−
<ul><li> DR</li>
+
| phone
−
<li> PROF</li></ul>
+
| Phone
−
</td></tr>
+
| &nbsp;
−
<tr>
+
|-
−
<td> name
+
| fax
−
</td>
+
| Fax
−
<td> Surename
+
| &nbsp;
−
</td>
+
|-
−
<td>
+
| email
−
</td></tr>
+
| Email
−
<tr>
+
| &nbsp;
−
<td> middlename
+
|-
−
</td>
+
| email2
−
<td> Middlename
+
| Email 2
−
</td>
+
| &nbsp;
−
<td>
+
|-
−
</td></tr>
+
| email3
−
<tr>
+
| Email 3
−
<td> firstname
+
| &nbsp;
−
</td>
+
|-
−
<td> Firstname
+
| emailInvoiceDelivery
−
</td>
+
| Email invoice delivery
−
<td>
+
| &nbsp;
−
</td></tr>
+
|-
−
<tr>
+
| receivedocs
−
<td> birthdate
+
| Itinerary / e-ticket
−
</td>
+
| &nbsp;
−
<td> Date of birth
+
|-
−
</td>
+
| gdsTarget
−
<td> Format = dd.mm.yyyy
+
| Target GDS
−
</td></tr>
+
|
−
<tr>
+
*0 = Amadeus
−
<td> nationality
+
*3 = Galileo
−
</td>
+
*5 = Sabre
−
<td> Citizenship
+
*999 = All
−
</td>
+
 
−
<td> 2-letter-country-code e.g. CH
+
|-
−
</td></tr>
+
| gwsOverrides.office
−
<tr>
+
| Galileo Overrides / Travel dep, PCC or IPCC
−
<td> additionalFormOfPayment
+
| Galileo PCC
−
</td>
+
|-
−
<td> Other forms of payment
+
| overrideGwsAdditionalInfo
−
</td>
+
| Galileo Overrides / Travel dep, PCC or IPCC
−
<td>
+
| Galileo HAP (mandatory)
−
<ul><li> CASH</li>
+
|-
−
<li> INV</li></ul>
+
| csxOverrides.office
−
</td></tr>
+
| CSX Overrides / Travel dep, PCC or IPCC
−
<tr>
+
| Amadeus OID
−
<td> hotelGuarantee
+
|-
−
</td>
+
| overrideCsxAdditionalInfo
−
<td> Hotel guarantee
+
| CSX Overrides / Travel dep. access or HAP
−
</td>
+
| Amadeus Org Id (optional)
−
<td>
+
|-
−
<ul><li> T/00 = 1st Traveller credit card</li>
+
| sabreOverrides.office
−
<li> T/01 = 2nd Traveller credit card</li>
+
| Sabre Overides / Travel dep, PCC or IPCC
−
<li> T/02 = 3rd Traveller credit Card</li>
+
| Sabre PCC
−
<li> C/00 = 1st Company credit card </li>
+
|-
−
<li> C/01 = 2nd Company credit card </li>
+
| sabreOverrides.additionalInfo
−
<li> C/02 = 3rd Company credit card </li></ul>
+
| Sabre Overides / Travel dep. access or HAP
−
</td></tr>
+
| &nbsp;
−
<tr>
+
|-
−
<td> carGuarantee
+
| gwsAgencyLocation
−
</td>
+
| Agency Location
−
<td> Guarantee rental car
+
| 3-Letter-City-Code
−
</td>
+
|-
−
<td>
+
| cytricElement
−
<ul><li> T/00 = 1st Traveller credit card</li>
+
| Cytric Org.
−
<li> T/01 = 2nd Traveller credit card</li>
+
| Cytric Location ID
−
<li> T/02 = 3rd Traveller credit Card</li>
+
|-
−
<li> C/00 = 1st Company credit card </li>
+
| aetmMainCommunity
−
<li> C/01 = 2nd Company credit card </li>
+
| Main Group
−
<li> C/02 = 3rd Company credit card </li></ul>
+
| AeTM Home Community
−
</td></tr>
+
|-
−
<tr>
+
| parentCompany.recordlocator
−
<td> webcard
+
| Parent company / Profile no.
−
</td>
+
| Profil number from the parent company
−
<td> Webcard
+
|-
−
</td>
+
| parentCompany.uuid
−
<td>
+
| Parent company / uuid
−
<ul><li> T/00 = 1st Traveller credit card</li>
+
| Database number (uuid) from the parent company - mandatory for import
−
<li> T/01 = 2nd Traveller credit card</li>
+
|-
−
<li> T/02 = 3rd Traveller credit Card</li>
+
| Parent company / Company name
−
<li> C/00 = 1st Company credit card </li>
+
| parentCompany.name
−
<li> C/01 = 2nd Company credit card </li>
+
| Name from the parent company
−
<li> C/02 = 3rd Company credit card </li></ul>
+
|-
−
</td></tr>
+
| hotelmemberships0.alliance
−
<tr>
+
| Hotel Travelguideline / Hotel Chain
−
<td> phoneBusiness
+
| 2-Letter-Hotel chain-Code
−
</td>
+
|-
−
<td> Phone Business
+
| hotelmemberships0.membernumber
−
</td>
+
| Hotel Travelguidelines / Ratecode
−
<td>
+
| 3-Letter-Rate-Code
−
</td></tr>
+
|-
−
<tr>
+
| hotelmemberships0.additionalinfo
−
<td> phonePrivate
+
| Hotel Travelguidelines / Customer Request
−
</td>
+
| &nbsp;
−
<td> Phone private
+
|-
−
</td>
+
| carmemberships0.alliance
−
<td>
+
| Car Travelguidelines / Company
−
</td></tr>
+
| 2-Letter-Rental Car-Code
−
<tr>
+
|-
−
<td> phoneMobile
+
| carmemberships0.membernumber
−
</td>
+
| Car Travelguidelines / Corporate discount number
−
<td> Mobile
+
| &nbsp;
−
</td>
+
|-
−
<td>
+
| carmemberships0.additionalinfo
−
</td></tr>
+
| Car Travelguidelines / Customer Reqeust
−
<tr>
+
| &nbsp;
−
<td> receivedocs
+
|-
−
</td>
+
| carmemberships0.additionalinfo2
−
<td> Itinerary / e-ticket (yes/no)
+
| Car Travelguidelines / Billing Number
−
</td>
+
| &nbsp;
−
<td>
+
|-
−
<ul><li> true</li>
+
| airlineincentives0.alliance
−
<li> false</li></ul>
+
| Airline Companyprogram / Company
−
</td></tr>
+
| 2-Letter-Airline-Code
−
<tr>
+
|-
−
<td> preferredSeat
+
| airlineincentives0.membernumber
−
</td>
+
| Airline Companyprogram / Info
−
<td> Seat Request
+
| &nbsp;
−
</td>
+
|-
−
<td>
+
| sortedCreditcards0.type
−
<ul><li> A = Aisle</li>
+
| Credit cards / Card type
−
<li> W = Window</li></ul>
+
|
−
</td></tr>
+
*VI = Visa
−
<tr>
+
*AX = American Express
−
<td> smoker
+
*CA = Mastercard / Eurocard
−
</td>
+
*TP = AirPlus
−
<td> Smoker
+
*DC = Diners
−
</td>
+
 
−
<td>
+
|-
−
<ul><li> true</li>
+
| sortedCreditcards0.numberMasked
−
<li> false</li></ul>
+
| Credit cards / Number
−
</td></tr>
+
| no Export function / only Import
−
<tr>
+
|-
−
<td> traveller
+
| sortedCreditcards0.expiration
−
</td>
+
| Cerdit cards / Expiration
−
<td> Traveller
+
| Format DD.MM.YYYY
−
</td>
+
|-
−
<td>
+
| sortedCreditcards0.publishAsFop
−
<ul><li> true</li>
+
| Credit cards / use as form of payment
−
<li>false</li></ul>
+
|
−
</td></tr>
+
*true
−
<tr>
+
*false
−
<td> arranger
+
 
−
</td>
+
|-
−
<td> Arranger / Assistance
+
| sortedPublishStates0.recordlocator
−
</td>
+
| Target System Profile number
−
<td>
+
|
−
<ul><li> true</li>
+
*Amadeus = Profile record locator
−
<li> false</li></ul>
+
*Galileo = Profile Name
−
</td></tr>
+
 
−
<tr>
+
|-
−
<td> approver
+
| sortedPublishStates0.id.publishTarget
−
</td>
+
| Target System
−
<td> Approver
+
|
−
</td>
+
*CSX = Amadeus
−
<td>
+
*GALILEO_WS = Galileo
−
<ul><li> true</li>
+
 
−
<li> false</li></ul>
+
|-
−
</td></tr>
+
| aetmSiteCode
−
<tr>
+
| AeTM Site Code
−
<td> comment
+
| 8 characters community Code
−
</td>
+
|-
−
<td> general.comment
+
| aetmSiteName
−
</td>
+
| AETM Site Name
−
<td>
+
| &nbsp;
−
</td></tr>
+
|-
−
<tr>
+
| privateCcIndex
−
<td> company.recordlocator
+
| Personal CC on
−
</td>
+
|
−
<td> Company / Profile no.
+
*CC_1
−
</td>
+
*CC_2
−
<td>
+
*CC_3
−
</td></tr>
+
 
−
<tr>
+
|-
−
<td> company.uuid
+
| privateCcIndex2
−
</td>
+
| 2nd Personal CC on
−
<td> Company / uuid
+
|
−
</td>
+
*CC_1
−
<td>
+
*CC_2
−
</td></tr>
+
*CC_3
−
<tr>
+
 
−
<td> company.name
+
|-
−
</td>
+
| privateCcIndex3
−
<td> Company / Company Name
+
| 3rd Personal CC on
−
</td>
+
|
−
<td>
+
*CC_1
−
</td></tr>
+
*CC_2
−
<tr>
+
*CC_3
−
<td> railExtension.delivery
+
 
−
</td>
+
|-
−
<td> Rail information / Delivery
+
| cytricElement
−
</td>
+
| Cytric Org (system number)
−
<td>
+
| &nbsp;
−
<ul><li>BAHNTIX</li>
+
|-
−
<li>ONLINE</li>
+
| sortedTravelGroups0.id.groupId
−
<li>PAPERTICKET</li>
+
| Travel Groups
−
<li>BAHNTIX</li></ul>
+
|
−
</td></tr>
+
*Cytric Travelpolicy Group (number)
−
<tr>
+
*AeTM Community Code
−
<td> railExtension.wagonType
+
 
−
</td>
+
|-
−
<td> Rail information / Wagontype
+
| sortedTravelGroups0.name
−
</td>
+
| Travel Group / Description
−
<td>
+
|
−
<ul><li>COMPARTMENT</li>
+
*Cytric Travelpolicy Name
−
<li>PREFER_WIDEBODY</li>
+
*AeTM Community Name
−
<li>REQUIRE_WIDEBODY</li>
+
 
−
<li>SINGLE</li>
+
|-
−
<li>TABLE</li></ul>
+
| genInternal<Name>.elective
−
</td></tr>
+
| <Name>
−
<tr>
+
|
−
<td> railExtension.wagonExtraType
+
*HIDDEN  
−
</td>
+
*MANDATORY  
−
<td> Rail information / Wagon extra
+
*OPTIONAL  
−
</td>
+
 
−
<td>
+
|}
−
<ul><li>PHONEAREA</li>
 
−
<li>QUIETAREA</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.seatpref
 
−
</td>
 
−
<td> Rail information / Seat
 
−
</td>
 
−
<td>
 
−
<ul><li>AISLE</li>
 
−
<li>WINDOW</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.railclass
 
−
</td>
 
−
<td>Rail information / Class
 
−
</td>
 
−
<td>
 
−
<ul><li>FIRST</li>
 
−
<li>SECOND</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.identification
 
−
</td>
 
−
<td> Rail information / Identification
 
−
</td>
 
−
<td>
 
−
<ul><li>BANKCARD</li>
 
−
<li>PERSONALCARD</li>
 
−
<li>RAILCARD</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.idInfo
 
−
</td>
 
−
<td> Rail information / Bank card
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.railCards0.cardtype
 
−
</td>
 
−
<td> Railcard / Card
 
−
</td>
 
−
<td>
 
−
<p>Rail: Amadeus_Germany
 
−
</p>
 
−
<ul><li>BAHNBONUS = DB bahn.bonus</li>
 
−
<li>BONUSCARD = DB Bonuscard Business</li>
 
−
<li>DB100 = DB BahnCard 100</li>
 
−
<li>DB25 = DB BahnCard 25</li>
 
−
<li>DB25_BUSINESS = DB BahnCard 25 Business</li>
 
−
<li>DB50 = DB BahnCard 50</li>
 
−
<li>DB50_BUSINESS = DB BahnCard 50 Business</li>
 
−
<li>SBB_GA = GA Travelcard / Swisspass</li>
 
−
<li>SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass</li>
 
−
<li>SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass</li></ul>
 
−
<p>Rail: Amadeus_Rail
 
−
</p>
 
−
<ul><li>SNCF_JEUNE</li>
 
−
<li>SNCF_SENIOR</li>
 
−
<li>SNCF_WEEKEND</li>
 
−
<li>SNCF_CFF50</li>
 
−
<li>SNCF_CFF50</li>
 
−
<li>SNCF_CLUBTCP</li>
 
−
<li>SNCF_FAM30</li>
 
−
<li>SNCF_FAM40</li>
 
−
<li>SNCF_FAM50</li>
 
−
<li>SNCF_FAM75</li>
 
−
<li>SNCF_FORFAIT</li>
 
−
<li>SNCF_FORFAIT</li>
 
−
<li>SNCF_FR_MILITARY</li>
 
−
<li>SNCF_FR_MILITARY</li>
 
−
<li>SNCF_FREQ50</li>
 
−
<li>SNCF_FREQ50</li>
 
−
<li>SNCF_FREQ_INTERMED</li>
 
−
<li>SNCF_FREQ_INTERMED</li>
 
−
<li>THALYS_LYS</li>
 
−
<li>THALYS_CORP</li>
 
−
<li>THALYS_PASS_BUSINESS</li>
 
−
<li>THALYS_PASS_PREMIUM</li>
 
−
<li>THALYS_PASS_WEEKEND</li>
 
−
<li>SJR_SJ_PRIO</li>
 
−
<li>SJR_ARSKORT_GOLD</li>
 
−
<li>SJR_ARSKORT_GOLD_RES</li>
 
−
<li>SJR_ARSKORT_SILVER</li>
 
−
<li>SJR_ARSKORT_SILVER_RES</li>
 
−
<li>SJR_ARSKORT_SILVER_PL</li>
 
−
<li>SJR_ARSKORT_SIL_PL_RES</li>
 
−
<li>SNCF_EUROSTAR</li>
 
−
<li>SNCF_CARD</li>
 
−
<li>SNCF_CLUB</li>
 
−
<li>SNCF_PLUS</li>
 
−
<li>SNCF_VOYAGEUR</li>
 
−
<li>THALYS_CARD</li>
 
−
<li>TTL_16_25</li>
 
−
<li>TTL_ANNUAL_GOLD</li>
 
−
<li>TTL_CAMBRIAN_LINES</li>
 
−
<li>TTL_COTSWORLD_LINE</li>
 
−
<li>TTL_DALES</li>
 
−
<li>TTL_DEVON_CORNWALL</li>
 
−
<li>TTL_DISABLED_ADULT</li>
 
−
<li>TTL_ESK_VALLEY</li>
 
−
<li>TTL_GROUPSAVE</li>
 
−
<li>TTL_HEART_OF_WALES</li>
 
−
<li>TTL_HIGHLAND</li>
 
−
<li>TTL_HM_FORCES</li>
 
−
<li>TTL_JOBCENTRE_PLUS</li>
 
−
<li>TTL_NETWORK </li>
 
−
<li>TTL_NEW_DEAL</li>
 
−
<li>TTL_PEMBROKESHIRE</li>
 
−
<li>TTL_SCOTTISH_YOUTH</li>
 
−
<li>TTL_SENIOR</li>
 
−
<li>TTL_TWO_TOGETHER</li>
 
−
<li>TTL_VALLEY_LINES_SENIOR</li>
 
−
<li>TTL_VALLEY_LINES_JUNIOR</li>
 
−
<li>DB25</li>
 
−
<li>DB25</li>
 
−
<li>DB25_BUSINESS</li>
 
−
<li>DB25_BUSINESS</li>
 
−
<li>DB50</li>
 
−
<li>DB50</li>
 
−
<li>DB50_BUSINESS</li>
 
−
<li>DB50_BUSINESS</li>
 
−
<li>DB100</li>
 
−
<li>DB100</li>
 
−
<li>BONUSCARD</li>
 
−
<li>SBB_HALFPRICE</li>
 
−
<li>SBB_HALFPRICE_RAILPLUS</li>
 
−
<li>SBB_GA</li>
 
−
<li>OEBB_VC</li>
 
−
<li>RENFE_CARNET_GO_25_ISTC</li>
 
−
<li>RENFE_CARNET_JOVEN</li>
 
−
<li>RENFE_TARJETA_DORADA</li>
 
−
<li>RENFE_TARJETA_JOVEN</li>
 
−
<li>RENFE_TARJETA_RAIL_PLUS_JUNIOR</li>
 
−
<li>RENFE_PLUS</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.railCards0.cardnumber
 
−
</td>
 
−
<td> Railcard / Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> railExtension.railCards0.cardExpiration
 
−
</td>
 
−
<td> Railcard / Expiration
 
−
</td>
 
−
<td> Format = dd.mm.yyyy
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.area
 
−
</td>
 
−
<td> Resident information / Resident Discount
 
−
</td>
 
−
<td>
 
−
<ul><li>CANARY</li>
 
−
<li>BALEARIC</li>
 
−
<li>CEUTA</li>
 
−
<li>MELILLA</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.areaCode
 
−
</td>
 
−
<td> Resident information / Area/Post Code
 
−
</td>
 
−
<td> post code (numbers)
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.cardType
 
−
</td>
 
−
<td> Resident information / National Identity Card type
 
−
</td>
 
−
<td>
 
−
<ul><li>NATIONAL_ID</li>
 
−
<li>MINOR_RESIDENT</li>
 
−
<li>RESIDENT_CARD</li>
 
−
<li>TEMP_RESIDENT</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.cardNumber
 
−
</td>
 
−
<td> Resident information / National Identity Card number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.firstSurname
 
−
</td>
 
−
<td> Resident information /
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> residentExtension.secondSurname
 
−
</td>
 
−
<td> Resident information /
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> flightmemberships0.alliance
 
−
</td>
 
−
<td> Frequent flyer / Airline
 
−
</td>
 
−
<td> 2-letter-airline-code e.g. SR (Swiss)
 
−
</td></tr>
 
−
<tr>
 
−
<td> flightmemberships0.membernumber
 
−
</td>
 
−
<td> Frequent Flyer / Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> flightmemberships0.additionalinfo
 
−
</td>
 
−
<td> Frequent Flyer / PIN
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.alliance
 
−
</td>
 
−
<td> Hotel Program / Hotel chain
 
−
</td>
 
−
<td> 2-letter-hotel-code e.g. RT (Accor Hotel)
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.membernumber
 
−
</td>
 
−
<td> Hotel Program / Customer Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.additionalinfo
 
−
</td>
 
−
<td> Hotel Program / Customer Request
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.alliance
 
−
</td>
 
−
<td> Car Program / Company
 
−
</td>
 
−
<td> 2-letter-car company-code e.g. ZE (Herz)
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.membernumber
 
−
</td>
 
−
<td> Car Program / Customer Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.additionalinfo
 
−
</td>
 
−
<td> Car Program / Customer Request
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.country
 
−
</td>
 
−
<td> Passport / Country
 
−
</td>
 
−
<td> 2-letter-country-code e.g. CH
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.number
 
−
</td>
 
−
<td> Passport / Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.issuedate
 
−
</td>
 
−
<td> Passport / Issue date
 
−
</td>
 
−
<td> Format = dd.mm.yyyy
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.issueplace
 
−
</td>
 
−
<td> Passport / Issue place
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.issueCountry
 
−
</td>
 
−
<td> Passport / Issue country
 
−
</td>
 
−
<td> 2-letter-country-code e.g. CH
 
−
</td></tr>
 
−
<tr>
 
−
<td> passports0.expiration
 
−
</td>
 
−
<td> Passport / Expires
 
−
</td>
 
−
<td> Format = dd.mm.yyyy
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.country
 
−
</td>
 
−
<td> Visa Information / Country
 
−
</td>
 
−
<td> 2-letter-country-code e.g. RU
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.number
 
−
</td>
 
−
<td> Visa Information/ Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.issuedate
 
−
</td>
 
−
<td> Visa Information / Issue date
 
−
</td>
 
−
<td> Format = dd.mm.yyyy
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.issueplace
 
−
</td>
 
−
<td> Not available in the user interface
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.expiration
 
−
</td>
 
−
<td> Visa Information / Expires
 
−
</td>
 
−
<td> Format = dd.mm.yyyy
 
−
</td></tr>
 
−
<tr>
 
−
<td> visa0.multiPurposeString
 
−
</td>
 
−
<td> Visa Information / Entry type
 
−
</td>
 
−
<td>
 
−
<ul><li>SINGLE</li>
 
−
<li>DOUBLE</li>
 
−
<li>MULTIPLE</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> employeecards0.country
 
−
</td>
 
−
<td> Identification cards / Country
 
−
</td>
 
−
<td> 2-letter-country-code e.g. CH
 
−
</td></tr>
 
−
<tr>
 
−
<td> employeecards0.number
 
−
</td>
 
−
<td> Identification cards / Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> employeecards0.issuedate
 
−
</td>
 
−
<td> Not available in the user Interface
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> employeecards0.issueplace
 
−
</td>
 
−
<td> Not available in the user Interface
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> employeecards0.expiration
 
−
</td>
 
−
<td> Not available in the user Interface
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> arrangercontacts0.contact
 
−
</td>
 
−
<td> Administration / Arranger / Assitance
 
−
</td>
 
−
<td> Arrangers email address
 
−
</td></tr>
 
−
<tr>
 
−
<td> arrangercontacts0.receivedocs
 
−
</td>
 
−
<td> Itinerary / e-ticket (yes/no)
 
−
</td>
 
−
<td>
 
−
<ul><li> true</li>
 
−
<li> false</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> approvercontacts0.contact
 
−
</td>
 
−
<td> Administration / Approver
 
−
</td>
 
−
<td> Approvers email address
 
−
</td></tr>
 
−
<tr>
 
−
<td> approvercontacts0.receivedocs
 
−
</td>
 
−
<td> Itinerary / e-ticket (yes/no)
 
−
</td>
 
−
<td>
 
−
<ul><li> true</li>
 
−
<li> false</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emergencycontacts0.firstname
 
−
</td>
 
−
<td> Emergency Contact / First Name
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emergencycontacts0.lastname
 
−
</td>
 
−
<td> Emergency Contact / Surname
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emergencycontacts0.email
 
−
</td>
 
−
<td> Emergency Contact / E-Mail
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emergencycontacts0.phone
 
−
</td>
 
−
<td> Emergency Contact / Phone
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emergencycontacts0.receivedocs
 
−
</td>
 
−
<td> Itinerary / e-ticket (yes/no)
 
−
</td>
 
−
<td>
 
−
<ul><li> true</li>
 
−
<li> false</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedTravelGroups0.groupId
 
−
</td>
 
−
<td> Travel groups / Main travel group
 
−
</td>
 
−
<td> community code e.g. ABCDABCD (AeTM) or Location, Division (cytric)
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedTravelGroups0.role
 
−
</td>
 
−
<td> Travel groups / Role
 
−
</td>
 
−
<td>
 
−
<p>Cytric:
 
−
</p>
 
−
<ul><li>USER = User </li>
 
−
<li>TRAVELER = Booker </li>
 
−
<li>PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all)</li>
 
−
<li>APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted)</li>
 
−
<li>TRAVEL_ARRANGER = Travel Arranger</li>
 
−
<li>TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin)</li>
 
−
<li>TRAVEL_APPROVER = Trip Approver</li></ul>
 
−
<p>AeTM:
 
−
</p>
 
−
<ul><li>ADMINISTRAOR</li>
 
−
<li>TRAVELER </li>
 
−
<li>PRINCIPAL_TRAVEL_ARRANGER </li>
 
−
<li>APPOINTEDTRAVEL_ARRANGER </li>
 
−
<li>TRAVEL_APPROVER </li>
 
−
<li>FALLBACK_APPROVER</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedTravelGroups1.groupId
 
−
</td>
 
−
<td> Travel groups / Further travel group
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedPublishStates0.id.publishtarget
 
−
</td>
 
−
<td> Target system
 
−
</td>
 
−
<td>
 
−
<ul><li> CSX = Amadeus</li>
 
−
<li> GALILEO_WS = Galileo</li>
 
−
<li> CYTRIC = Cytric</li>
 
−
<li> AETM = Amadeus e-travel management</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedPublishStates0.recordlocator
 
−
</td>
 
−
<td> Target system identification number/name
 
−
</td>
 
−
<td>
 
−
<ul><li> Amadeus = Profile record locator</li>
 
−
<li> Galileo = Profile Name</li>
 
−
<li> AeTM = Login Name</li></ul>
 
−
<p>if cell is blank, a new profile in the target system will be created
 
−
</p><p>if cell contains value, the existing profile in the target system will be synchronised
 
−
</p>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedPublishStates0.internallocator
 
−
</td>
 
−
<td> Target System additional number/name
 
−
</td>
 
−
<td> AeTM = traveller id
 
−
</td></tr></table>
 
−
<p>Only for import, no export available
 
−
</p>
 
−
<table>
 
−
<tr>
 
−
<th> Column
 
−
</th>
 
−
<th> Values/Actions
 
−
</th></tr>
 
−
<tr>
 
−
<td> sortedCreditcards#.type
 
−
</td>
 
−
<td> Credit card vendor (VI, AX, CA etc.)
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards#.numberMasked
 
−
</td>
 
−
<td> Credit card number
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.expiration
 
−
</td>
 
−
<td> Credit card expiry
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.publishAsFop
 
−
</td>
 
−
<td>
 
−
<ul><li>TRUE = use as form of payment</li>
 
−
<li>FALSE = not use as form of payment</li></ul>
 
−
</td></tr></table>
 
−
<h4>Custom fields 'Single Company CSV file'</h4>
 
−
<p>Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data.
 
−
</p>
 
−
<table>
 
−
<tr>
 
−
<th>column
 
−
</th>
 
−
<th>Description
 
−
</th></tr>
 
−
<tr>
 
−
<td> mergedgroups:general.header_general:0.value
 
−
</td>
 
−
<td> Section 'General'
 
−
</td></tr>
 
−
<tr>
 
−
<td> mergedgroups:company.header_agency:0.value
 
−
</td>
 
−
<td> Section 'Your Agency'
 
−
</td></tr>
 
−
<tr>
 
−
<td> mergedgroups:traveller.adminheader:0.value
 
−
</td>
 
−
<td> Section 'Administration'
 
−
</td></tr>
 
−
<tr>
 
−
<td> mergedgroups:general.header_prefs:0.value
 
−
</td>
 
−
<td> Section 'Preferences'
 
−
</td></tr>
 
−
<tr>
 
−
<td> mergedgroups:traveller.papersheader:0.value
 
−
</td>
 
−
<td> Section 'Travel documents'
 
−
</td></tr>
 
−
<tr>
 
−
<td> genericgroups0.fields0.value
 
−
</td>
 
−
<td> Section '-custom-' e.g. Reference Details
 
−
</td></tr></table>
 
−
<h4>Custom fields 'Multiple Company CSV file'</h4>
 
−
<p>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.
 
−
</p><p>Example:
 
−
</p>
 
−
<table>
 
−
<tr>
 
−
<td>
 
−
</td>
 
−
<th> my agency custom fields
 
−
</th>
 
−
<th> company setup custom fields
 
−
</th></tr>
 
−
<tr>
 
−
<th> CSV column 1
 
−
</th>
 
−
<td> allgroups0.fields0.value
 
−
</td>
 
−
<td> allgroups1.fields0.value
 
−
</td></tr>
 
−
<tr>
 
−
<th> CSV column 2
 
−
</th>
 
−
<td> Contract Details
 
−
</td>
 
−
<td>!Staff No. for Umbrella
 
−
</td></tr></table>
 
−
<p><b>The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field</b>
 
−
</p>
 
−
<h3> CSV-File - Description 'Companies'</h3><p>The download of companies in a CSV File includes following Information
 
−
</p>
 
−
<table>
 
−
<tr>
 
−
<th> Column
 
−
</th>
 
−
<th> Description
 
−
</th>
 
−
<th> Values/Actions
 
−
</th></tr>
 
−
<tr>
 
−
<td> recordlocator
 
−
</td>
 
−
<td> Profile no.
 
−
</td>
 
−
<td>
 
−
<p>Amadeus CSX Profil Recloc
 
−
</p>
 
−
</td></tr>
 
−
<tr>
 
−
<td> uuid
 
−
</td>
 
−
<td> Database number
 
−
</td>
 
−
<td> Blank if new profile
 
−
</td></tr>
 
−
<tr>
 
−
<td> externalnr
 
−
</td>
 
−
<td> Customer no.
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> name
 
−
</td>
 
−
<td> Company Name
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> shortname
 
−
</td>
 
−
<td> Short Name
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emailDelivery
 
−
</td>
 
−
<td> Email delivery
 
−
</td>
 
−
<td>
 
−
<ul><li>EMAIL = Amadeus Mail</li>
 
−
<li>EMAILPLUS = Amadeus Fax and Email plus</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> travellerFopOption
 
−
</td>
 
−
<td> Personal Cards
 
−
</td>
 
−
<td>
 
−
<ul><li>FP_AND_GUARANTEE = FP and Guarantee</li>
 
−
<li>GUARANTEE_ONLY = Guarantee only</li>
 
−
<li>NONE = none</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> additionalFormOfPayment
 
−
</td>
 
−
<td> Other forms of payment
 
−
</td>
 
−
<td> INV = Invoice
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelGuarantee
 
−
</td>
 
−
<td> Guarantee Hotel
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carGuarantee
 
−
</td>
 
−
<td> Guarantee rental car
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> confidential
 
−
</td>
 
−
<td> Confidential
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> street
 
−
</td>
 
−
<td> Street
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> street2
 
−
</td>
 
−
<td> Street 2
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> zip
 
−
</td>
 
−
<td> Zip
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> place
 
−
</td>
 
−
<td> Place
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> country
 
−
</td>
 
−
<td> Country
 
−
</td>
 
−
<td> 2-letter-Country-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> phone
 
−
</td>
 
−
<td> Phone
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> fax
 
−
</td>
 
−
<td> Fax
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> email
 
−
</td>
 
−
<td> Email
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> email2
 
−
</td>
 
−
<td> Email 2
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> email3
 
−
</td>
 
−
<td> Email 3
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> emailInvoiceDelivery
 
−
</td>
 
−
<td> Email invoice delivery
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> receivedocs
 
−
</td>
 
−
<td> Itinerary / e-ticket
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> gdsTarget
 
−
</td>
 
−
<td> Target GDS
 
−
</td>
 
−
<td>
 
−
<ul><li>0 = Amadeus</li>
 
−
<li>3 = Galileo</li>
 
−
<li>5 = Sabre</li>
 
−
<li>999 = All</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> gwsOverrides.office
 
−
</td>
 
−
<td> Galileo Overrides / Travel dep, PCC or  IPCC
 
−
</td>
 
−
<td> Galileo PCC
 
−
</td></tr>
 
−
<tr>
 
−
<td> overrideGwsAdditionalInfo
 
−
</td>
 
−
<td> Galileo Overrides / Travel dep, PCC or  IPCC
 
−
</td>
 
−
<td> Galileo HAP (mandatory)
 
−
</td></tr>
 
−
<tr>
 
−
<td> csxOverrides.office
 
−
</td>
 
−
<td> CSX Overrides / Travel dep, PCC or  IPCC
 
−
</td>
 
−
<td> Amadeus OID
 
−
</td></tr>
 
−
<tr>
 
−
<td> overrideCsxAdditionalInfo
 
−
</td>
 
−
<td> CSX Overrides / Travel dep. access or HAP
 
−
</td>
 
−
<td> Amadeus Org Id (optional)
 
−
</td></tr>
 
−
<tr>
 
−
<td> sabreOverrides.office
 
−
</td>
 
−
<td> Sabre Overides / Travel dep, PCC or  IPCC
 
−
</td>
 
−
<td> Sabre PCC
 
−
</td></tr>
 
−
<tr>
 
−
<td> sabreOverrides.additionalInfo
 
−
</td>
 
−
<td> Sabre Overides / Travel dep. access or HAP
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> gwsAgencyLocation
 
−
</td>
 
−
<td> Agency Location
 
−
</td>
 
−
<td> 3-Letter-City-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> aetmMainCommunity
 
−
</td>
 
−
<td> Main Group
 
−
</td>
 
−
<td> AeTM Home Community
 
−
</td></tr>
 
−
<tr>
 
−
<td> parentCompany.recordlocator
 
−
</td>
 
−
<td> Parent company / Profile no.
 
−
</td>
 
−
<td> Profil number from the parent company
 
−
</td></tr>
 
−
<tr>
 
−
<td> parentCompany.uuid
 
−
</td>
 
−
<td> Parent company / uuid
 
−
</td>
 
−
<td> Database number (uuid) from the parent company - mandatory for import
 
−
</td></tr>
 
−
<tr>
 
−
<td> Parent company / Company name
 
−
</td>
 
−
<td> parentCompany.name
 
−
</td>
 
−
<td> Name from the parent company
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.alliance
 
−
</td>
 
−
<td> Hotel Travelguideline / Hotel Chain
 
−
</td>
 
−
<td> 2-Letter-Hotel chain-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.membernumber
 
−
</td>
 
−
<td> Hotel Travelguidelines / Ratecode
 
−
</td>
 
−
<td> 3-Letter-Rate-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> hotelmemberships0.additionalinfo
 
−
</td>
 
−
<td> Hotel Travelguidelines / Customer Request
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.alliance
 
−
</td>
 
−
<td> Car Travelguidelines / Company
 
−
</td>
 
−
<td> 2-Letter-Rental Car-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.membernumber
 
−
</td>
 
−
<td> Car Travelguidelines / Corporate discount number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.additionalinfo
 
−
</td>
 
−
<td> Car Travelguidelines / Customer Reqeust
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> carmemberships0.additionalinfo2
 
−
</td>
 
−
<td> Car Travelguidelines / Billing Number
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> airlineincentives0.alliance
 
−
</td>
 
−
<td> Airline Companyprogram / Company
 
−
</td>
 
−
<td> 2-Letter-Airline-Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> airlineincentives0.membernumber
 
−
</td>
 
−
<td> Airline Companyprogram / Info
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.type
 
−
</td>
 
−
<td> Credit cards / Card type
 
−
</td>
 
−
<td>
 
−
<ul><li> VI = Visa</li>
 
−
<li> AX = American Express</li>
 
−
<li> CA = Mastercard / Eurocard</li>
 
−
<li> TP = AirPlus</li>
 
−
<li> DC = Diners</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.numberMasked
 
−
</td>
 
−
<td> Credit cards / Number
 
−
</td>
 
−
<td> no Export function / only Import
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.expiration
 
−
</td>
 
−
<td> Cerdit cards / Expiration
 
−
</td>
 
−
<td> Format DD.MM.YYYY
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedCreditcards0.publishAsFop
 
−
</td>
 
−
<td> Credit cards / use as form of payment
 
−
</td>
 
−
<td>
 
−
<ul><li>true</li>
 
−
<li>false</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedPublishStates0.recordlocator
 
−
</td>
 
−
<td> Target System Profile number
 
−
</td>
 
−
<td>
 
−
<ul><li>Amadeus = Profile record locator </li>
 
−
<li>Galileo = Profile Name </li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedPublishStates0.id.publishTarget
 
−
</td>
 
−
<td> Target System
 
−
</td>
 
−
<td>
 
−
<ul><li> CSX = Amadeus</li>
 
−
<li> GALILEO_WS = Galileo</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> aetmSiteCode
 
−
</td>
 
−
<td> AeTM Site Code
 
−
</td>
 
−
<td> 8 characters community Code
 
−
</td></tr>
 
−
<tr>
 
−
<td> aetmSiteName
 
−
</td>
 
−
<td> AETM Site Name
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> privateCcIndex
 
−
</td>
 
−
<td> Personal CC on
 
−
</td>
 
−
<td>
 
−
<ul><li> CC_1</li>
 
−
<li> CC_2</li>
 
−
<li> CC_3</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> privateCcIndex2
 
−
</td>
 
−
<td> 2nd Personal CC on
 
−
</td>
 
−
<td>
 
−
<ul><li> CC_1</li>
 
−
<li> CC_2</li>
 
−
<li> CC_3</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> privateCcIndex3
 
−
</td>
 
−
<td> 3rd Personal CC on
 
−
</td>
 
−
<td>
 
−
<ul><li> CC_1</li>
 
−
<li> CC_2</li>
 
−
<li> CC_3</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> cytricElement
 
−
</td>
 
−
<td> Cytric Org (system number)
 
−
</td>
 
−
<td>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedTravelGroups0.id.groupId
 
−
</td>
 
−
<td> Travel Groups
 
−
</td>
 
−
<td>
 
−
<ul><li>Cytric Travelpolicy Group (number)</li>
 
−
<li>AeTM Community Code</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> sortedTravelGroups0.name
 
−
</td>
 
−
<td> Travel Group / Description
 
−
</td>
 
−
<td>
 
−
<ul><li> Cytric Travelpolicy Name</li>
 
−
<li> AeTM Community Name</li></ul>
 
−
</td></tr>
 
−
<tr>
 
−
<td> genInternal&lt;Name&gt;.elective
 
−
</td>
 
−
<td> &lt;Name&gt;
 
−
</td>
 
−
<td>
 
−
<ul><li> HIDDEN</li>
 
−
<li> MANDATORY</li>
 
−
<li> OPTIONAL</li></ul>
 
−
</td></tr>
 
−
</table>
 
  
 
=== CSV Upload===
 
=== CSV Upload===

Version vom 14. September 2017, 09:37 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


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
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
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  
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  
gdsTarget Target GDS
  • 0 = Amadeus
  • 3 = Galileo
  • 5 = Sabre
  • 999 = All
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
aetmMainCommunity 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.membernumber Airline Companyprogram / Info  
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 Target System Profile number
  • Amadeus = Profile record locator
  • Galileo = Profile Name
sortedPublishStates0.id.publishTarget Target System
  • CSX = Amadeus
  • GALILEO_WS = Galileo
aetmSiteCode AeTM Site Code 8 characters community Code
aetmSiteName AETM Site Name  
privateCcIndex Personal CC on
  • CC_1
  • CC_2
  • CC_3
privateCcIndex2 2nd Personal CC on
  • CC_1
  • CC_2
  • CC_3
privateCcIndex3 3rd Personal CC on
  • CC_1
  • CC_2
  • CC_3
cytricElement Cytric Org (system number)  
sortedTravelGroups0.id.groupId Travel Groups
  • Cytric Travelpolicy Group (number)
  • AeTM Community Code
sortedTravelGroups0.name Travel Group / Description
  • Cytric Travelpolicy Name
  • AeTM Community Name
genInternal<Name>.elective <Name>
  • HIDDEN
  • MANDATORY
  • OPTIONAL

CSV Upload

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

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

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=1404»