Profil Center: Unterschied zwischen den Versionen
(→CSV-File - Description 'Companies') |
|||
(36 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), | + | 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 = | ||
− | [[ | + | [[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. | ||
{| | {| | ||
− | |||
− | |||
|- | |- | ||
− | |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 |
− | | | + | | 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 === | ||
− | |||
The Export function allows to download all companies or traveller profiles from one or multiple companies via CSV File. | The Export function allows to download all companies or traveller profiles from one or multiple companies via CSV File. | ||
{| | {| | ||
+ | |- | ||
! Field | ! Field | ||
! Description | ! Description | ||
Zeile 100: | Zeile 108: | ||
|} | |} | ||
− | ===Import=== | + | Fields with long text areas and starting with '-' are not being exported correctly. This is an Excel bug and is caused since the programm believes that the cell should be formatted as number-cell and hence has a maximum of characters. We strongly recommend to not use '-' at the beginning of a text area field (e.g. Comment Box).<br/> |
− | 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 | ||
+ | |||
|- | |- | ||
− | | | + | | |
| ''Amadeus CSX'' | | ''Amadeus CSX'' | ||
|- | |- | ||
Zeile 126: | Zeile 141: | ||
|- | |- | ||
| System | | System | ||
− | | Amadeus CSX | + | | Amadeus CSX |
|- | |- | ||
| Profile no. | | Profile no. | ||
Zeile 138: | Zeile 153: | ||
|- | |- | ||
| Bulk company upload | | Bulk company upload | ||
− | | The activation of the checkbox and the click on <Import> will provide a list of all existing company profiles in the Amadeus Office ID. In this step every single company profile is de- or selectable. Please note that a mass upload will take some time (approx. 1000 profiles / 15 minutes). The upload will import all company profiles with their associated traveller profiles. | + | | The activation of the checkbox and the click on <Import> will provide a list of all existing company profiles in the Amadeus Office ID. In this step every single company profile is de- or selectable. Please note that a mass upload will take some time (approx. 1000 profiles / 15 minutes). The upload will import all company profiles with their associated traveller profiles. |
|- | |- | ||
| Import | | Import | ||
| Click on Import will upload the company and all associated traveller profiles. | | Click on Import will upload the company and all associated traveller profiles. | ||
− | A username for the traveller profile will be automatically created <first name>.<sure name>@<company short name> | + | A username for the traveller profile will be automatically created <first name>.<sure name>@<company short name> Following Amadeus CSX prefix can be processed: |
− | Following Amadeus CSX prefix can be processed: | + | |
+ | *AB | ||
+ | *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'' | | ''AeTM'' | ||
|- | |- | ||
Zeile 152: | Zeile 199: | ||
|- | |- | ||
| Company | | Company | ||
− | | Select relevant company. Company needs at least a setup in the AeTM Site-Code, Main Group and Travel Group. | + | | Select relevant company. Company needs at least a setup in the AeTM Site-Code, Main Group and Travel Group. |
|} | |} | ||
− | === CSV-File - Description 'Travellers'=== | + | === CSV-File - Description 'Travellers' === |
+ | |||
The download of travellers in a CSV File includes following information. | The download of travellers in a CSV File includes following information. | ||
Zeile 161: | Zeile 209: | ||
'''Example:''' Enter 3 Frequent Flyer numbers in the CSV-File | '''Example:''' Enter 3 Frequent Flyer numbers in the CSV-File | ||
+ | |||
{| | {| | ||
+ | |- | ||
| first number | | first number | ||
| flightmemberships0.alliance | | flightmemberships0.alliance | ||
Zeile 172: | Zeile 222: | ||
|} | |} | ||
− | ====Standard Fields==== | + | |
+ | |||
+ | | ||
+ | |||
+ | |||
+ | |||
+ | ==== Standard Fields ==== | ||
The CSV file will always include the standard fields of Umbrella Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circle are uploaded, than the values will be ignored. | The CSV file will always include the standard fields of Umbrella Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circle are uploaded, than the values will be ignored. | ||
{| | {| | ||
+ | |- | ||
! Column | ! Column | ||
! Description | ! Description | ||
Zeile 184: | Zeile 241: | ||
| Action | | Action | ||
| | | | ||
− | * SAVE | + | *SAVE |
− | * DELETE | + | *DELETE |
+ | |||
|- | |- | ||
| uuid | | uuid | ||
Zeile 193: | Zeile 251: | ||
| username | | username | ||
| Faces Username | | Faces Username | ||
− | | | + | | |
|- | |- | ||
| email | | email | ||
| E-Mail Address | | E-Mail Address | ||
− | | | + | | |
− | |- | + | |- |
| language | | language | ||
| User language | | User language | ||
| | | | ||
− | * en_GB = | + | *cs_CZ = Czech (Czech Republic) |
− | * de_AT = | + | *nl_BE = Dutch (Belgium) |
− | * de_DE = | + | *nl_NL = Dutch (Netherlands) |
− | * de_CH = | + | *en_GB = English (United Kingdom) |
− | * | + | *en_US = English (United States) |
− | * | + | *fr_CH = French (Switzerland) |
− | * | + | *fr_FR = French (France) |
− | * | + | *de_AT = German (Austria) |
− | * es_ES = | + | *de_DE = German (Germany) |
+ | *de_CH = German (Switzerland) | ||
+ | *hu_HU = Hungarian (Hungary) | ||
+ | *it_IT = Italian (Italy) | ||
+ | *it_CH = Italian (Switzerland) | ||
+ | *pl_PL = Polish (Poland) | ||
+ | *pt_PT = Portuguese (Portugal) | ||
+ | *sk_SK = Slovak (Slovakia) | ||
+ | *es_ES = Spanish (Spain) | ||
+ | |||
|- | |- | ||
| company.uuid | | company.uuid | ||
| Database No. Company | | Database No. Company | ||
− | | | + | | |
|- | |- | ||
| gender | | gender | ||
| Gender | | Gender | ||
− | | | + | | |
− | * MR | + | *MR |
− | * MRS | + | *MRS |
+ | *U | ||
+ | |||
|- | |- | ||
| title | | title | ||
| Title | | Title | ||
− | | | + | | |
− | * DR | + | *DR |
− | * PROF | + | *PROF |
+ | |||
|- | |- | ||
| name | | name | ||
| Surename | | Surename | ||
− | | | + | | |
|- | |- | ||
| middlename | | middlename | ||
| Middlename | | Middlename | ||
− | | | + | | |
|- | |- | ||
| firstname | | firstname | ||
| Firstname | | Firstname | ||
− | | | + | | |
|- | |- | ||
| birthdate | | birthdate | ||
Zeile 250: | Zeile 320: | ||
| additionalFormOfPayment | | additionalFormOfPayment | ||
| Other forms of payment | | Other forms of payment | ||
− | | | + | | |
− | * CASH | + | *CASH |
− | * INV | + | *INV |
+ | |||
|- | |- | ||
| hotelGuarantee | | hotelGuarantee | ||
| Hotel guarantee | | Hotel guarantee | ||
| | | | ||
− | * T/00 = 1st Traveller credit card | + | *T/00 = 1st Traveller credit card |
− | * T/01 = 2nd Traveller credit card | + | *T/01 = 2nd Traveller credit card |
− | * T/02 = 3rd Traveller credit Card | + | *T/02 = 3rd Traveller credit Card |
− | * C/00 = 1st Company credit card | + | *C/00 = 1st Company credit card |
− | * C/01 = 2nd Company credit card | + | *C/01 = 2nd Company credit card |
− | * C/02 = 3rd Company credit card | + | *C/02 = 3rd Company credit card |
+ | |||
|- | |- | ||
| carGuarantee | | carGuarantee | ||
| Guarantee rental car | | Guarantee rental car | ||
| | | | ||
− | * T/00 = 1st Traveller credit card | + | *T/00 = 1st Traveller credit card |
− | * T/01 = 2nd Traveller credit card | + | *T/01 = 2nd Traveller credit card |
− | * T/02 = 3rd Traveller credit Card | + | *T/02 = 3rd Traveller credit Card |
− | * C/00 = 1st Company credit card | + | *C/00 = 1st Company credit card |
− | * C/01 = 2nd Company credit card | + | *C/01 = 2nd Company credit card |
− | * C/02 = 3rd Company credit card | + | *C/02 = 3rd Company credit card |
+ | |||
|- | |- | ||
| webcard | | webcard | ||
| Webcard | | Webcard | ||
| | | | ||
− | * T/00 = 1st Traveller credit card | + | *T/00 = 1st Traveller credit card |
− | * T/01 = 2nd Traveller credit card | + | *T/01 = 2nd Traveller credit card |
− | * T/02 = 3rd Traveller credit Card | + | *T/02 = 3rd Traveller credit Card |
− | * C/00 = 1st Company credit card | + | *C/00 = 1st Company credit card |
− | * C/01 = 2nd Company credit card | + | *C/01 = 2nd Company credit card |
− | * C/02 = 3rd Company credit card | + | *C/02 = 3rd Company credit card |
+ | |||
|- | |- | ||
| phoneBusiness | | phoneBusiness | ||
| Phone Business | | Phone Business | ||
− | | | + | | |
|- | |- | ||
| phonePrivate | | phonePrivate | ||
| Phone private | | Phone private | ||
− | | | + | | |
|- | |- | ||
| phoneMobile | | phoneMobile | ||
| Mobile | | Mobile | ||
− | | | + | | |
|- | |- | ||
| receivedocs | | receivedocs | ||
| Itinerary / e-ticket (yes/no) | | Itinerary / e-ticket (yes/no) | ||
− | | | + | | |
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| preferredSeat | | preferredSeat | ||
| Seat Request | | Seat Request | ||
− | | | + | | |
− | * A = Aisle | + | *A = Aisle |
− | * W = Window | + | *W = Window |
+ | |||
+ | |- | ||
+ | | preferredFood | ||
+ | | Meal Request | ||
+ | | e.g. VGML | ||
|- | |- | ||
| smoker | | smoker | ||
| Smoker | | Smoker | ||
| | | | ||
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| traveller | | traveller | ||
| Traveller | | Traveller | ||
| | | | ||
− | * true | + | *true |
− | *false | + | *false |
+ | |||
|- | |- | ||
| arranger | | arranger | ||
| Arranger / Assistance | | Arranger / Assistance | ||
| | | | ||
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| approver | | approver | ||
| Approver | | Approver | ||
− | | | + | | |
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| comment | | comment | ||
| general.comment | | general.comment | ||
− | | | + | | |
|- | |- | ||
| company.recordlocator | | company.recordlocator | ||
| Company / Profile no. | | Company / Profile no. | ||
− | | | + | | |
|- | |- | ||
| company.uuid | | company.uuid | ||
| Company / uuid | | Company / uuid | ||
− | | | + | | |
|- | |- | ||
| company.name | | company.name | ||
| Company / Company Name | | Company / Company Name | ||
− | | | + | | |
|- | |- | ||
− | | railExtension.delivery | + | | railExtension.delivery |
− | | Rail information / Delivery | + | | Rail information / Delivery |
− | | | + | | |
− | *BAHNTIX | + | *BAHNTIX |
− | *ONLINE | + | *ONLINE |
− | *PAPERTICKET | + | *PAPERTICKET |
− | *BAHNTIX | + | *BAHNTIX |
+ | |||
|- | |- | ||
| railExtension.wagonType | | railExtension.wagonType | ||
| Rail information / Wagontype | | Rail information / Wagontype | ||
− | | | + | | |
− | *COMPARTMENT | + | *COMPARTMENT |
− | *PREFER_WIDEBODY | + | *PREFER_WIDEBODY |
− | *REQUIRE_WIDEBODY | + | *REQUIRE_WIDEBODY |
− | *SINGLE | + | *SINGLE |
− | *TABLE | + | *TABLE |
+ | |||
|- | |- | ||
| railExtension.wagonExtraType | | railExtension.wagonExtraType | ||
| Rail information / Wagon extra | | Rail information / Wagon extra | ||
− | | | + | | |
− | *PHONEAREA | + | *PHONEAREA |
− | *QUIETAREA | + | *QUIETAREA |
+ | |||
|- | |- | ||
| railExtension.seatpref | | railExtension.seatpref | ||
| Rail information / Seat | | Rail information / Seat | ||
| | | | ||
− | *AISLE | + | *AISLE |
− | *WINDOW | + | *WINDOW |
+ | |||
|- | |- | ||
| railExtension.railclass | | railExtension.railclass | ||
− | |Rail information / Class | + | | Rail information / Class |
− | | | + | | |
− | *FIRST | + | *FIRST |
− | *SECOND | + | *SECOND |
+ | |||
|- | |- | ||
| railExtension.identification | | railExtension.identification | ||
| Rail information / Identification | | Rail information / Identification | ||
− | | | + | | |
− | *BANKCARD | + | *BANKCARD |
− | *PERSONALCARD | + | *PERSONALCARD |
− | *RAILCARD | + | *RAILCARD |
+ | |||
|- | |- | ||
| railExtension.idInfo | | railExtension.idInfo | ||
| Rail information / Bank card | | Rail information / Bank card | ||
− | | | + | | |
|- | |- | ||
− | | railExtension.railCards0.cardtype | + | | railExtension.railCards0.cardtype |
| Railcard / Card | | Railcard / Card | ||
− | | | + | | |
Rail: Amadeus_Germany | Rail: Amadeus_Germany | ||
− | *BAHNBONUS = DB bahn.bonus | + | |
− | *BONUSCARD = DB Bonuscard Business | + | *BAHNBONUS = DB bahn.bonus |
− | *DB100 = DB BahnCard 100 | + | *BONUSCARD = DB Bonuscard Business |
− | *DB25 = DB BahnCard 25 | + | *DB100 = DB BahnCard 100 |
− | *DB25_BUSINESS = DB BahnCard 25 Business | + | *DB25 = DB BahnCard 25 |
− | *DB50 = DB BahnCard 50 | + | *DB25_BUSINESS = DB BahnCard 25 Business |
− | *DB50_BUSINESS = DB BahnCard 50 Business | + | *DB50 = DB BahnCard 50 |
− | *SBB_GA = GA Travelcard / Swisspass | + | *DB50_BUSINESS = DB BahnCard 50 Business |
− | *SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass | + | *SBB_GA = GA Travelcard / Swisspass |
− | *SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass | + | *SBB_HALFPRICE = Halfprice Card (excl. RailPlus) / Swisspass |
+ | *SBB_HALFPRICE_RAILPLUS = Halfprice Card (incl. RailPlus) / Swisspass | ||
+ | |||
Rail: Amadeus_Rail | Rail: Amadeus_Rail | ||
− | *SNCF_JEUNE | + | |
− | *SNCF_SENIOR | + | *SNCF_JEUNE |
− | *SNCF_WEEKEND | + | *SNCF_SENIOR |
− | *SNCF_CFF50 | + | *SNCF_WEEKEND |
− | *SNCF_CLUBTCP | + | *SNCF_CFF50 |
− | *SNCF_FAM30 | + | *SNCF_CFF50 |
− | *SNCF_FAM40 | + | *SNCF_CLUBTCP |
− | *SNCF_FAM50 | + | *SNCF_FAM30 |
− | *SNCF_FAM75 | + | *SNCF_FAM40 |
− | * | + | *SNCF_FAM50 |
− | *SNCF_FORFAIT | + | *SNCF_FAM75 |
− | *SNCF_FR_MILITARY | + | *SNCF_FORFAIT |
− | *SNCF_FREQ50 | + | *SNCF_FORFAIT |
− | *SNCF_FREQ_INTERMED | + | *SNCF_FR_MILITARY |
− | *SNCF_CARD | + | *SNCF_FR_MILITARY |
− | *SNCF_CLUB | + | *SNCF_FREQ50 |
− | *SNCF_PLUS | + | *SNCF_FREQ50 |
− | * | + | *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 | | railExtension.railCards0.cardnumber | ||
| Railcard / Number | | Railcard / Number | ||
− | | | + | | |
|- | |- | ||
| railExtension.railCards0.cardExpiration | | railExtension.railCards0.cardExpiration | ||
Zeile 439: | Zeile 592: | ||
| residentExtension.area | | residentExtension.area | ||
| Resident information / Resident Discount | | Resident information / Resident Discount | ||
− | | | + | | |
− | *CANARY | + | *CANARY |
− | *BALEARIC | + | *BALEARIC |
− | *CEUTA | + | *CEUTA |
− | *MELILLA | + | *MELILLA |
+ | |||
|- | |- | ||
| residentExtension.areaCode | | residentExtension.areaCode | ||
Zeile 451: | Zeile 605: | ||
| residentExtension.cardType | | residentExtension.cardType | ||
| Resident information / National Identity Card type | | Resident information / National Identity Card type | ||
− | | | + | | |
− | *NATIONAL_ID | + | *NATIONAL_ID |
− | *MINOR_RESIDENT | + | *MINOR_RESIDENT |
− | *RESIDENT_CARD | + | *RESIDENT_CARD |
− | *TEMP_RESIDENT | + | *TEMP_RESIDENT |
+ | |||
|- | |- | ||
| residentExtension.cardNumber | | residentExtension.cardNumber | ||
| Resident information / National Identity Card number | | Resident information / National Identity Card number | ||
− | | | + | | |
|- | |- | ||
| residentExtension.firstSurname | | residentExtension.firstSurname | ||
− | | Resident information / | + | | Resident information / |
− | | | + | | |
|- | |- | ||
| residentExtension.secondSurname | | residentExtension.secondSurname | ||
| Resident information / | | Resident information / | ||
− | | | + | | |
|- | |- | ||
| flightmemberships0.alliance | | flightmemberships0.alliance | ||
Zeile 475: | Zeile 630: | ||
| flightmemberships0.membernumber | | flightmemberships0.membernumber | ||
| Frequent Flyer / Number | | Frequent Flyer / Number | ||
− | | | + | | |
|- | |- | ||
| flightmemberships0.additionalinfo | | flightmemberships0.additionalinfo | ||
| Frequent Flyer / PIN | | Frequent Flyer / PIN | ||
− | | | + | | |
|- | |- | ||
| hotelmemberships0.alliance | | hotelmemberships0.alliance | ||
Zeile 487: | Zeile 642: | ||
| hotelmemberships0.membernumber | | hotelmemberships0.membernumber | ||
| Hotel Program / Customer Number | | Hotel Program / Customer Number | ||
− | | | + | | |
|- | |- | ||
| hotelmemberships0.additionalinfo | | hotelmemberships0.additionalinfo | ||
| Hotel Program / Customer Request | | Hotel Program / Customer Request | ||
− | | | + | | |
|- | |- | ||
| carmemberships0.alliance | | carmemberships0.alliance | ||
Zeile 499: | Zeile 654: | ||
| carmemberships0.membernumber | | carmemberships0.membernumber | ||
| Car Program / Customer Number | | Car Program / Customer Number | ||
− | | | + | | |
|- | |- | ||
| carmemberships0.additionalinfo | | carmemberships0.additionalinfo | ||
| Car Program / Customer Request | | Car Program / Customer Request | ||
− | | | + | | |
+ | |- | ||
+ | | carmemberships0.specialRequest | ||
+ | | Car Program / Special request | ||
+ | | | ||
|- | |- | ||
| passports0.country | | passports0.country | ||
Zeile 511: | Zeile 670: | ||
| passports0.number | | passports0.number | ||
| Passport / Number | | Passport / Number | ||
− | | | + | | |
|- | |- | ||
| passports0.issuedate | | passports0.issuedate | ||
Zeile 519: | Zeile 678: | ||
| passports0.issueplace | | passports0.issueplace | ||
| Passport / Issue place | | Passport / Issue place | ||
− | | | + | | |
+ | |- | ||
+ | | passports0.issueCountry | ||
+ | | Passport / Issue country | ||
+ | | 2-letter-country-code e.g. CH | ||
|- | |- | ||
| passports0.expiration | | passports0.expiration | ||
| Passport / Expires | | Passport / Expires | ||
− | | Format = dd.mm.yyyy | + | | Format = dd.mm.yyyy |
|- | |- | ||
| visa0.country | | visa0.country | ||
Zeile 531: | Zeile 694: | ||
| visa0.number | | visa0.number | ||
| Visa Information/ Number | | Visa Information/ Number | ||
− | | | + | | |
|- | |- | ||
| visa0.issuedate | | visa0.issuedate | ||
Zeile 539: | Zeile 702: | ||
| visa0.issueplace | | visa0.issueplace | ||
| Not available in the user interface | | Not available in the user interface | ||
− | | | + | | |
|- | |- | ||
| visa0.expiration | | visa0.expiration | ||
Zeile 545: | Zeile 708: | ||
| Format = dd.mm.yyyy | | Format = dd.mm.yyyy | ||
|- | |- | ||
− | | visa0. | + | | visa0.multiPurposeString |
− | | Visa Information / Entry type | + | | Visa Information / Entry type |
| | | | ||
− | * | + | *SINGLE |
− | * | + | *DOUBLE |
− | * | + | *MULTIPLE |
− | + | ||
|- | |- | ||
| employeecards0.country | | employeecards0.country | ||
Zeile 559: | Zeile 722: | ||
| employeecards0.number | | employeecards0.number | ||
| Identification cards / Number | | Identification cards / Number | ||
− | | | + | | |
|- | |- | ||
| employeecards0.issuedate | | employeecards0.issuedate | ||
| Not available in the user Interface | | Not available in the user Interface | ||
− | | | + | | |
|- | |- | ||
| employeecards0.issueplace | | employeecards0.issueplace | ||
| Not available in the user Interface | | Not available in the user Interface | ||
− | | | + | | |
|- | |- | ||
| employeecards0.expiration | | employeecards0.expiration | ||
| Not available in the user Interface | | Not available in the user Interface | ||
− | | | + | | |
|- | |- | ||
| arrangercontacts0.contact | | arrangercontacts0.contact | ||
Zeile 579: | Zeile 742: | ||
| arrangercontacts0.receivedocs | | arrangercontacts0.receivedocs | ||
| Itinerary / e-ticket (yes/no) | | Itinerary / e-ticket (yes/no) | ||
− | | | + | | |
− | * true | + | *true |
− | * false | + | *false |
− | |- | + | |
+ | |- | ||
| approvercontacts0.contact | | approvercontacts0.contact | ||
− | | Administration / Approver | + | | Administration / Approver |
| Approvers email address | | Approvers email address | ||
|- | |- | ||
| approvercontacts0.receivedocs | | approvercontacts0.receivedocs | ||
| Itinerary / e-ticket (yes/no) | | Itinerary / e-ticket (yes/no) | ||
− | | | + | | |
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| emergencycontacts0.firstname | | emergencycontacts0.firstname | ||
| Emergency Contact / First Name | | Emergency Contact / First Name | ||
− | | | + | | |
|- | |- | ||
| emergencycontacts0.lastname | | emergencycontacts0.lastname | ||
| Emergency Contact / Surname | | Emergency Contact / Surname | ||
− | | | + | | |
|- | |- | ||
| emergencycontacts0.email | | emergencycontacts0.email | ||
| Emergency Contact / E-Mail | | Emergency Contact / E-Mail | ||
− | | | + | | |
|- | |- | ||
| emergencycontacts0.phone | | emergencycontacts0.phone | ||
| Emergency Contact / Phone | | Emergency Contact / Phone | ||
− | | | + | | |
|- | |- | ||
| emergencycontacts0.receivedocs | | emergencycontacts0.receivedocs | ||
| Itinerary / e-ticket (yes/no) | | Itinerary / e-ticket (yes/no) | ||
− | | | + | | |
− | * true | + | *true |
− | * false | + | *false |
+ | |||
|- | |- | ||
| sortedTravelGroups0.groupId | | sortedTravelGroups0.groupId | ||
Zeile 621: | Zeile 787: | ||
| sortedTravelGroups0.role | | sortedTravelGroups0.role | ||
| Travel groups / Role | | Travel groups / Role | ||
− | | | + | | |
− | Cytric: | + | Cytric: |
+ | |||
*USER = User | *USER = User | ||
*TRAVELER = Booker | *TRAVELER = Booker | ||
− | *PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all) | + | *PRINCIPAL_TRAVEL_ARRANGER = Travel Arranger (all) |
− | *APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted) | + | *APPOINTEDTRAVEL_ARRANGER = Travel Arranger (restricted) |
− | *TRAVEL_ARRANGER = Travel Arranger | + | *TRAVEL_ARRANGER = Travel Arranger |
− | *TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin) | + | *TRAVEL_ARRANGER_RESTRICTED_PM = Travel Arranger (restricted with Profile Admin) |
− | *TRAVEL_APPROVER = Trip Approver | + | *TRAVEL_APPROVER = Trip Approver |
+ | |||
AeTM: | AeTM: | ||
− | *ADMINISTRAOR | + | |
+ | *ADMINISTRAOR | ||
*TRAVELER | *TRAVELER | ||
*PRINCIPAL_TRAVEL_ARRANGER | *PRINCIPAL_TRAVEL_ARRANGER | ||
*APPOINTEDTRAVEL_ARRANGER | *APPOINTEDTRAVEL_ARRANGER | ||
*TRAVEL_APPROVER | *TRAVEL_APPROVER | ||
− | *FALLBACK_APPROVER | + | *FALLBACK_APPROVER |
+ | |||
|- | |- | ||
| sortedTravelGroups1.groupId | | sortedTravelGroups1.groupId | ||
| Travel groups / Further travel group | | Travel groups / Further travel group | ||
− | | | + | | |
|- | |- | ||
| sortedPublishStates0.id.publishtarget | | sortedPublishStates0.id.publishtarget | ||
| Target system | | Target system | ||
− | | | + | | |
− | * CSX = Amadeus | + | *CSX = Amadeus |
− | * GALILEO_WS = Galileo | + | *GALILEO_WS = Galileo |
− | * AETM = Amadeus e-travel management | + | *CYTRIC = Cytric |
+ | *AETM = Amadeus e-travel management | ||
+ | |||
|- | |- | ||
| sortedPublishStates0.recordlocator | | sortedPublishStates0.recordlocator | ||
| Target system identification number/name | | Target system identification number/name | ||
| | | | ||
− | * Amadeus = Profile record locator | + | *Amadeus = Profile record locator |
− | * Galileo = Profile Name | + | *Galileo = Profile Name |
− | * AeTM = Login Name | + | *AeTM = Login Name |
+ | |||
if cell is blank, a new profile in the target system will be created | if cell is blank, a new profile in the target system will be created | ||
− | if cell contains value, the existing profile in the target system will be synchronised | + | if cell contains value, the existing profile in the target system will be synchronised |
+ | |||
|- | |- | ||
| sortedPublishStates0.internallocator | | sortedPublishStates0.internallocator | ||
Zeile 665: | Zeile 839: | ||
Only for import, no export available | Only for import, no export available | ||
+ | |||
{| | {| | ||
+ | |- | ||
! Column | ! Column | ||
! Values/Actions | ! Values/Actions | ||
Zeile 679: | Zeile 855: | ||
|- | |- | ||
| sortedCreditcards0.publishAsFop | | sortedCreditcards0.publishAsFop | ||
− | | | + | | |
− | *TRUE = use as form of payment | + | *TRUE = use as form of payment |
− | *FALSE = not use as form of payment | + | *FALSE = not use as form of payment |
+ | |||
|} | |} | ||
− | ====Custom fields 'Single Company CSV file'==== | + | ==== Custom fields 'Single Company CSV file' ==== |
Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data. | Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file download will include generic data. | ||
{| | {| | ||
− | !column | + | |- |
− | !Description | + | ! column |
+ | ! Description | ||
|- | |- | ||
| mergedgroups:general.header_general:0.value | | mergedgroups:general.header_general:0.value | ||
Zeile 711: | Zeile 889: | ||
|} | |} | ||
− | ====Custom fields 'Multiple Company CSV file'==== | + | ==== Custom fields 'Multiple Company CSV file' ==== |
− | Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file will include generic data. | + | Depending on the setup in ‚my agency‘ and in 'company setup' the CSV-file will include generic data. The 'Multiple Company CSV-file' contains other column identifiers compared to the 'Single Company CSV-file'. All custom fields are named with 'allgroups0.fields0.value' in a numeric row. The custom fields from a company setup are highlighted with a ‘!’ in column 2 followed by the given name of the field. |
− | The 'Multiple Company CSV-file' contains other column identifiers compared to the 'Single Company CSV-file'. | ||
− | All custom fields are named with 'allgroups0.fields0.value' in a numeric row. The custom fields from a company setup are highlighted with a ‘!’ in column 2 followed by the given name of the field. | ||
Example: | Example: | ||
{| | {| | ||
− | | | + | |- |
+ | | | ||
! my agency custom fields | ! my agency custom fields | ||
! company setup custom fields | ! company setup custom fields | ||
Zeile 730: | Zeile 907: | ||
! CSV column 2 | ! CSV column 2 | ||
| Contract Details | | Contract Details | ||
− | |!Staff No. for Umbrella | + | | !Staff No. for Umbrella |
|} | |} | ||
+ | |||
'''The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field''' | '''The '!' in front of the named field 'Staff no. for Umbrella' identifies the column as a company setup custom field''' | ||
− | === CSV-File - Description 'Companies'=== | + | |
+ | |||
+ | | ||
+ | |||
+ | | ||
+ | |||
+ | |||
+ | |||
+ | === CSV-File - Description 'Companies' === | ||
The download of companies in a CSV File includes following Information | The download of companies in a CSV File includes following Information | ||
{| | {| | ||
+ | |- | ||
! Column | ! Column | ||
! Description | ! Description | ||
Zeile 744: | Zeile 931: | ||
|- | |- | ||
| recordlocator | | recordlocator | ||
− | | Profile no. | + | | Profile no. |
| | | | ||
Amadeus CSX Profil Recloc | Amadeus CSX Profil Recloc | ||
+ | |||
|- | |- | ||
| uuid | | uuid | ||
Zeile 754: | Zeile 942: | ||
| externalnr | | externalnr | ||
| Customer no. | | Customer no. | ||
− | | | + | | |
|- | |- | ||
| name | | name | ||
| Company Name | | Company Name | ||
− | | | + | | |
|- | |- | ||
| shortname | | shortname | ||
| Short Name | | Short Name | ||
− | | | + | | |
|- | |- | ||
| emailDelivery | | emailDelivery | ||
| Email delivery | | Email delivery | ||
− | | | + | | |
− | *EMAIL = Amadeus Mail | + | *EMAIL = Amadeus Mail |
− | *EMAILPLUS = Amadeus Fax and Email plus | + | *EMAILPLUS = Amadeus Fax and Email plus |
+ | |||
|- | |- | ||
− | | | + | | travellerFopOption |
| Personal Cards | | Personal Cards | ||
− | | | + | | |
− | *FP_AND_GUARANTEE = FP and Guarantee | + | *FP_AND_GUARANTEE = FP and Guarantee |
− | *GUARANTEE_ONLY = Guarantee only | + | *GUARANTEE_ONLY = Guarantee only |
− | *NONE = none | + | *NONE = none |
+ | |||
|- | |- | ||
| additionalFormOfPayment | | additionalFormOfPayment | ||
Zeile 783: | Zeile 973: | ||
| hotelGuarantee | | hotelGuarantee | ||
| Guarantee Hotel | | Guarantee Hotel | ||
− | | | + | | |
|- | |- | ||
| carGuarantee | | carGuarantee | ||
| Guarantee rental car | | Guarantee rental car | ||
− | | | + | | |
|- | |- | ||
| confidential | | confidential | ||
| Confidential | | Confidential | ||
− | | | + | | |
|- | |- | ||
| street | | street | ||
| Street | | Street | ||
− | | | + | | |
|- | |- | ||
| street2 | | street2 | ||
| Street 2 | | Street 2 | ||
− | | | + | | |
|- | |- | ||
| zip | | zip | ||
| Zip | | Zip | ||
− | | | + | | |
|- | |- | ||
| place | | place | ||
| Place | | Place | ||
− | | | + | | |
|- | |- | ||
| country | | country | ||
Zeile 815: | Zeile 1'005: | ||
| phone | | phone | ||
| Phone | | Phone | ||
− | | | + | | |
|- | |- | ||
| fax | | fax | ||
| Fax | | Fax | ||
− | | | + | | |
|- | |- | ||
| email | | email | ||
| Email | | Email | ||
− | | | + | | |
|- | |- | ||
| email2 | | email2 | ||
| Email 2 | | Email 2 | ||
− | | | + | | |
|- | |- | ||
| email3 | | email3 | ||
| Email 3 | | Email 3 | ||
− | | | + | | |
|- | |- | ||
| emailInvoiceDelivery | | emailInvoiceDelivery | ||
− | | Email invoice delivery | + | | Email invoice delivery |
− | | | + | | |
|- | |- | ||
| receivedocs | | receivedocs | ||
| Itinerary / e-ticket | | 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 |
− | | Travel | + | | Sabre Overides / Travel dep, PCC or IPCC |
− | | | + | | Sabre PCC |
|- | |- | ||
− | | | + | | sabreOverrides.additionalInfo |
− | | Travel dep. | + | | Sabre Overides / Travel dep. access or HAP |
− | | | + | | |
|- | |- | ||
| gwsAgencyLocation | | gwsAgencyLocation | ||
Zeile 860: | Zeile 1'063: | ||
| 3-Letter-City-Code | | 3-Letter-City-Code | ||
|- | |- | ||
− | | | + | | cytricElement |
+ | | Cytric Org. | ||
+ | | Cytric Location ID | ||
+ | |- | ||
+ | | mainTravelGroup | ||
| Main Group | | Main Group | ||
| AeTM Home Community | | AeTM Home Community | ||
|- | |- | ||
− | | hotelmemberships0. | + | | 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 | | Hotel Travelguideline / Hotel Chain | ||
| 2-Letter-Hotel chain-Code | | 2-Letter-Hotel chain-Code | ||
|- | |- | ||
| hotelmemberships0.membernumber | | hotelmemberships0.membernumber | ||
− | | Hotel Travelguidelines / Ratecode | + | | Hotel Travelguidelines / Ratecode |
− | | 3-Letter-Rate-Code | + | | 3-Letter-Rate-Code |
− | |- | + | |- |
| hotelmemberships0.additionalinfo | | hotelmemberships0.additionalinfo | ||
| Hotel Travelguidelines / Customer Request | | Hotel Travelguidelines / Customer Request | ||
− | | | + | | |
|- | |- | ||
| carmemberships0.alliance | | carmemberships0.alliance | ||
Zeile 882: | Zeile 1'101: | ||
| carmemberships0.membernumber | | carmemberships0.membernumber | ||
| Car Travelguidelines / Corporate discount number | | Car Travelguidelines / Corporate discount number | ||
− | | | + | | |
|- | |- | ||
| carmemberships0.additionalinfo | | carmemberships0.additionalinfo | ||
| Car Travelguidelines / Customer Reqeust | | Car Travelguidelines / Customer Reqeust | ||
− | | | + | | |
|- | |- | ||
| carmemberships0.additionalinfo2 | | carmemberships0.additionalinfo2 | ||
| Car Travelguidelines / Billing Number | | Car Travelguidelines / Billing Number | ||
− | | | + | | |
|- | |- | ||
| airlineincentives0.alliance | | airlineincentives0.alliance | ||
Zeile 896: | Zeile 1'115: | ||
| 2-Letter-Airline-Code | | 2-Letter-Airline-Code | ||
|- | |- | ||
− | | airlineincentives0. | + | | airlineincentives0.additionalinfo |
| Airline Companyprogram / Info | | Airline Companyprogram / Info | ||
− | | | + | | |
+ | |- | ||
+ | | airlineincentives0.publishAs | ||
+ | | Airline Companyprogram / Publish as | ||
+ | | | ||
+ | *OS (OSI Element) | ||
+ | *SK (Special Keyword) | ||
+ | |||
|- | |- | ||
| sortedCreditcards0.type | | sortedCreditcards0.type | ||
| Credit cards / Card type | | Credit cards / Card type | ||
− | | | + | | |
− | * VI = Visa | + | *VI = Visa |
− | * AX = American Express | + | *AX = American Express |
− | * CA = Mastercard / Eurocard | + | *CA = Mastercard / Eurocard |
− | * TP = AirPlus | + | *TP = AirPlus |
− | * DC = Diners | + | *DC = Diners |
+ | |||
|- | |- | ||
| sortedCreditcards0.numberMasked | | sortedCreditcards0.numberMasked | ||
Zeile 919: | Zeile 1'146: | ||
| sortedCreditcards0.publishAsFop | | sortedCreditcards0.publishAsFop | ||
| Credit cards / use as form of payment | | Credit cards / use as form of payment | ||
− | | | + | | |
− | *true | + | *true |
− | *false | + | *false |
+ | |||
|- | |- | ||
| sortedPublishStates0.recordlocator | | sortedPublishStates0.recordlocator | ||
− | | | + | | Publishing / locator |
+ | | Profile record locator/Profile number/Profile name | ||
+ | |- | ||
+ | | sortedPublishStates2.internallocator | ||
+ | | Publishing / internallocator | ||
+ | | | ||
+ | |- | ||
+ | | sortedPublishStates0.id.publishTarget | ||
+ | | interface / targetsystem | ||
| | | | ||
− | *Amadeus = | + | *CSX = Amadeus |
− | * | + | *GALILEO_WS = Galileo |
+ | *SABRE = Sabre | ||
+ | *FARELOGIX = Farelogix | ||
+ | |||
|- | |- | ||
− | |||
− | |||
| | | | ||
− | * CSX = Amadeus | + | sortedTargetSystems0.agencyInterface.targetSystem |
− | * GALILEO_WS = Galileo | + | |
+ | | Target GDS / Target system | ||
+ | | | ||
+ | *CSX = Amadeus | ||
+ | *GALILEO_WS = Galileo | ||
+ | *SABRE = Sabre | ||
+ | *FARELOGIX = Farelogix | ||
+ | |||
+ | |- | ||
+ | | sortedTargetSystems0.agencyInterface.label | ||
+ | | Target GDS / Label | ||
+ | | | ||
|- | |- | ||
| aetmSiteCode | | aetmSiteCode | ||
− | | AeTM Site Code | + | | AeTM Site Code |
− | | 8 characters community Code | + | | 8 characters community Code (import only) |
|- | |- | ||
| aetmSiteName | | aetmSiteName | ||
| AETM Site Name | | AETM Site Name | ||
− | | | + | | |
|- | |- | ||
| privateCcIndex | | privateCcIndex | ||
| Personal CC on | | Personal CC on | ||
− | | | + | | |
− | * CC_1 | + | *CC_1 |
− | * CC_2 | + | *CC_2 |
− | * CC_3 | + | *CC_3<br/> (import only) |
+ | |||
|- | |- | ||
| privateCcIndex2 | | privateCcIndex2 | ||
| 2nd Personal CC on | | 2nd Personal CC on | ||
− | | | + | | |
− | * CC_1 | + | *CC_1 |
− | * CC_2 | + | *CC_2 |
− | * CC_3 | + | *CC_3<br/> (import only) |
+ | |||
|- | |- | ||
| privateCcIndex3 | | privateCcIndex3 | ||
| 3rd Personal CC on | | 3rd Personal CC on | ||
− | | | + | | |
− | * CC_1 | + | *CC_1 |
− | * CC_2 | + | *CC_2 |
− | * CC_3 | + | *CC_3<br/> (import only) |
+ | |||
|- | |- | ||
| cytricElement | | cytricElement | ||
| Cytric Org (system number) | | Cytric Org (system number) | ||
− | | | + | | |
|- | |- | ||
| sortedTravelGroups0.id.groupId | | sortedTravelGroups0.id.groupId | ||
| Travel Groups | | Travel Groups | ||
| | | | ||
− | *Cytric Travelpolicy Group (number) | + | *Cytric Travelpolicy Group (number) |
− | *AeTM Community Code | + | *AeTM Community Code<br/> (import only) |
+ | |||
|- | |- | ||
| sortedTravelGroups0.name | | sortedTravelGroups0.name | ||
| Travel Group / Description | | Travel Group / Description | ||
− | | | + | | |
− | * Cytric Travelpolicy Name | + | *Cytric Travelpolicy Name |
− | * AeTM Community Name | + | *AeTM Community Name<br/> (import only) |
+ | |||
+ | |- | ||
+ | | genInternal<Name>.elective | ||
+ | | <Name> | ||
+ | | | ||
+ | *HIDDEN | ||
+ | *MANDATORY | ||
+ | *OPTIONAL | ||
+ | |||
+ | |- | ||
+ | | general.comment | ||
+ | | comment | ||
+ | | | ||
+ | |} | ||
+ | |||
+ | === CSV Upload === | ||
+ | |||
+ | Please refer to section [[Profile_Company#CSV_Download_/_Upload|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'== | + | == 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 | + | | All profiles |
− | |Send credentials to all | + | | 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) | ||
|} | |} |
Aktuelle Version vom 15. November 2019, 11:46 Uhr
Inhaltsverzeichnis
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
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 from CSV | Upload the CSV-file for 'travellers' or 'companies'
|
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:
|
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 |
|
uuid | Database No. | Blank if new profile |
username | Faces Username | |
E-Mail Address | ||
language | User language |
|
company.uuid | Database No. Company | |
gender | Gender |
|
title | Title |
|
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 |
|
hotelGuarantee | Hotel guarantee |
|
carGuarantee | Guarantee rental car |
|
webcard | Webcard |
|
phoneBusiness | Phone Business | |
phonePrivate | Phone private | |
phoneMobile | Mobile | |
receivedocs | Itinerary / e-ticket (yes/no) |
|
preferredSeat | Seat Request |
|
preferredFood | Meal Request | e.g. VGML |
smoker | Smoker |
|
traveller | Traveller |
|
arranger | Arranger / Assistance |
|
approver | Approver |
|
comment | general.comment | |
company.recordlocator | Company / Profile no. | |
company.uuid | Company / uuid | |
company.name | Company / Company Name | |
railExtension.delivery | Rail information / Delivery |
|
railExtension.wagonType | Rail information / Wagontype |
|
railExtension.wagonExtraType | Rail information / Wagon extra |
|
railExtension.seatpref | Rail information / Seat |
|
railExtension.railclass | Rail information / Class |
|
railExtension.identification | Rail information / Identification |
|
railExtension.idInfo | Rail information / Bank card | |
railExtension.railCards0.cardtype | Railcard / Card |
Rail: Amadeus_Germany
Rail: Amadeus_Rail
|
railExtension.railCards0.cardnumber | Railcard / Number | |
railExtension.railCards0.cardExpiration | Railcard / Expiration | Format = dd.mm.yyyy |
residentExtension.area | Resident information / Resident Discount |
|
residentExtension.areaCode | Resident information / Area/Post Code | post code (numbers) |
residentExtension.cardType | Resident information / National Identity Card type |
|
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 |
|
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) |
|
approvercontacts0.contact | Administration / Approver | Approvers email address |
approvercontacts0.receivedocs | Itinerary / e-ticket (yes/no) |
|
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) |
|
sortedTravelGroups0.groupId | Travel groups / Main travel group | community code e.g. ABCDABCD (AeTM) or Location, Division (cytric) |
sortedTravelGroups0.role | Travel groups / Role |
Cytric:
AeTM:
|
sortedTravelGroups1.groupId | Travel groups / Further travel group | |
sortedPublishStates0.id.publishtarget | Target system |
|
sortedPublishStates0.recordlocator | Target system identification number/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 |
|
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 |
|
travellerFopOption | Personal Cards |
|
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 | |
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 |
|
sortedCreditcards0.type | Credit cards / Card type |
|
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 |
|
sortedPublishStates0.recordlocator | Publishing / locator | Profile record locator/Profile number/Profile name |
sortedPublishStates2.internallocator | Publishing / internallocator | |
sortedPublishStates0.id.publishTarget | interface / targetsystem |
|
sortedTargetSystems0.agencyInterface.targetSystem |
Target GDS / Target system |
|
sortedTargetSystems0.agencyInterface.label | Target GDS / Label | |
aetmSiteCode | AeTM Site Code | 8 characters community Code (import only) |
aetmSiteName | AETM Site Name | |
privateCcIndex | Personal CC on |
|
privateCcIndex2 | 2nd Personal CC on |
|
privateCcIndex3 | 3rd Personal CC on |
|
cytricElement | Cytric Org (system number) | |
sortedTravelGroups0.id.groupId | Travel Groups |
|
sortedTravelGroups0.name | Travel Group / Description |
|
genInternal<Name>.elective | <Name> |
|
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) |