Profil Center: Unterschied zwischen den Versionen

Aus Faces Dokumentation
Wechseln zu: Navigation, Suche
 
(11 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
 +
|-
 +
| Travellers of
 +
| Save (publishing) all travellers of a specific company
 
|-
 
|-
−
|All erroneous
+
| All erroneous
−
|Save (publishing) all errors, which are displayed in the section error publishing
+
| Save (publishing) all errors, which are displayed in the section error publishing
 
|-
 
|-
−
|All companies
+
| All companies
−
|Save (publishing) all company profiles
+
| Save (publishing) all company profiles
 
|-
 
|-
−
|All travellers
+
| All travellers
−
|Save (publishing) all traveller profiles
+
| 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:
 
|}
 
|}
  
 +
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;
  
 
=== Import ===
 
=== Import ===
Zeile 214: Zeile 223:
  
 
&nbsp;
 
&nbsp;
 +
 +
&nbsp;
 +
 +
  
 
==== Standard Fields ====
 
==== Standard Fields ====
Zeile 275: Zeile 288:
 
*MR  
 
*MR  
 
*MRS  
 
*MRS  
 +
*U
  
 
|-
 
|-
Zeile 369: Zeile 383:
 
*W = Window  
 
*W = Window  
  
 +
|-
 +
| preferredFood
 +
| Meal Request
 +
| e.g. VGML
 
|-
 
|-
 
| smoker
 
| smoker
Zeile 640: Zeile 658:
 
| carmemberships0.additionalinfo
 
| carmemberships0.additionalinfo
 
| Car Program / Customer Request
 
| Car Program / Customer Request
 +
| &nbsp;
 +
|-
 +
| carmemberships0.specialRequest
 +
| Car Program / Special request
 
| &nbsp;
 
| &nbsp;
 
|-
 
|-
Zeile 885: 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'''
 +
 +
&nbsp;
 +
 +
&nbsp;
 +
 +
&nbsp;
 +
 +
  
 
=== CSV-File - Description 'Companies' ===
 
=== CSV-File - Description 'Companies' ===
Zeile 1'001: Zeile 1'031:
 
| &nbsp;
 
| &nbsp;
 
|-
 
|-
−
| gdsTarget
+
| selfRegistrationKey
−
| Target GDS
+
| Self-registration key&nbsp;&nbsp; &nbsp;
−
|  
+
| &nbsp;
−
*0 = Amadeus
 
−
*3 = Galileo
 
−
*5 = Sabre
 
−
*999 = All
 
−
 
 
 
|-
 
|-
 
| gwsOverrides.office
 
| gwsOverrides.office
Zeile 1'042: Zeile 1'067:
 
| Cytric Location ID
 
| Cytric Location ID
 
|-
 
|-
−
| aetmMainCommunity
+
| mainTravelGroup
 
| Main Group
 
| Main Group
 
| AeTM Home Community
 
| AeTM Home Community
Zeile 1'090: Zeile 1'115:
 
| 2-Letter-Airline-Code
 
| 2-Letter-Airline-Code
 
|-
 
|-
−
| airlineincentives0.membernumber
+
| airlineincentives0.additionalinfo
 
| Airline Companyprogram / Info
 
| Airline Companyprogram / Info
 
| &nbsp;
 
| &nbsp;
 +
|-
 +
| airlineincentives0.publishAs
 +
| Airline Companyprogram / Publish as
 +
|
 +
*OS (OSI Element)
 +
*SK (Special Keyword)
 +
 
|-
 
|-
 
| sortedCreditcards0.type
 
| sortedCreditcards0.type
Zeile 1'120: Zeile 1'152:
 
|-
 
|-
 
| 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
+
sortedTargetSystems0.agencyInterface.targetSystem&nbsp;&nbsp; &nbsp;
 +
 
 +
| Target GDS / Target system
 
|  
 
|  
 
*CSX = Amadeus  
 
*CSX = Amadeus  
 
*GALILEO_WS = Galileo  
 
*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
Zeile 1'144: Zeile 1'194:
 
| Personal CC on
 
| Personal CC on
 
|  
 
|  
−
*CC_1  
+
*CC_1&nbsp;
 
*CC_2  
 
*CC_2  
−
*CC_3  
+
*CC_3<br/> (import only)
  
 
|-
 
|-
Zeile 1'154: Zeile 1'204:
 
*CC_1  
 
*CC_1  
 
*CC_2  
 
*CC_2  
−
*CC_3  
+
*CC_3<br/> (import only)
  
 
|-
 
|-
Zeile 1'162: Zeile 1'212:
 
*CC_1  
 
*CC_1  
 
*CC_2  
 
*CC_2  
−
*CC_3  
+
*CC_3<br/> (import only)
  
 
|-
 
|-
Zeile 1'173: Zeile 1'223:
 
|  
 
|  
 
*Cytric Travelpolicy Group (number)  
 
*Cytric Travelpolicy Group (number)  
−
*AeTM Community Code  
+
*AeTM Community Code<br/> (import only)
  
 
|-
 
|-
Zeile 1'180: Zeile 1'230:
 
|  
 
|  
 
*Cytric Travelpolicy Name  
 
*Cytric Travelpolicy Name  
−
*AeTM Community Name  
+
*AeTM Community Name<br/> (import only)
  
 
|-
 
|-
Zeile 1'190: Zeile 1'240:
 
*OPTIONAL  
 
*OPTIONAL  
  
 +
|-
 +
| general.comment
 +
| comment
 +
| &nbsp;
 
|}
 
|}
−
 
  
 
=== CSV Upload ===
 
=== CSV Upload ===
Zeile 1'213: Zeile 1'266:
 
To mass delelte company profile please add column "metadata.action" with the value DELETE
 
To mass delelte company profile please add column "metadata.action" with the value DELETE
  
−
== Section 'Send credentials'==
+
== 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, 11: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»