Profil Center: Unterschied zwischen den Versionen
(→Upload) |
(→CSV Upload) |
||
| Zeile 451: | Zeile 451: | ||
=== CSV Upload=== | === CSV Upload=== | ||
| − | Please refer to section [[ | + | Please refer to section [[Profil Firma#CSV Download / Upload|CSV Download / Upload]]. |
Version vom 4. März 2015, 12:14 Uhr
Inhaltsverzeichnis
General
The Profile Center gives an overview on the numbers of profiles created in Umbrella Tenzing Faces, informs about publishing error (synchronisation error) and gives the opportunity to Import/Export CSV-File for one, more or all travellers related to company profiles.
Layout
Section 'Travel Büro'
Numbers of all company and traveller profiles available in "your agency" at Umbrella Tenzing Faces.
| Field | Description |
|---|---|
| No. of companies | The count of all company profies created in Umbrella Tenzing Faces are displayed. |
| No. of travellers | The count of all travellers profies created in Umbrella Tenzing Faces are displayed. |
Section 'Publishing Errors'
Publishing Errors can occur on creating manually profile in the user interface and it is important to identify any publishing error during/after a CSV Upload. A list of all errors are shown, a hyperlink on the profile name leads directly into the 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 'Import/Export'
The Export/Import Function allows to download and upload traveller profiles from one or more companies via CSV File.
| Field | Description |
|---|---|
| Company | Insert a specific company for the CSV-File download |
| add new | additional companies, which should be part of the CSV-file download |
| Travellers (CSV) | Click to start the download of specific companies CSV-file |
| All travellers (CSV) | click to download all travellers CSV-file in your agency |
| Upload ... | upload the CSV-file |
CSV-File - Description
The download of travellers in a CSV File will include the following Information.
General: in some fields more than one input is possible, in this case the columns contains value “0”. More values are possible to enter by expanding the numbers.
Example: enter 3 Frequent Flyer numbers in the CSV
| 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 Tenzing Faces. Also with specific custom developments (circle) the standard fields are shown. If none configured fields in a circel 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 |
| fopPublish | Form of payment |
|
| guarantee | Hotel guarantee |
|
| webcard | Webcard |
|
| phoneBusiness | Phone Business | |
| phonePrivate | Phone private | |
| phoneMobile | Mobile | |
| receivedocs | Itinerary / e-ticket (yes/no) |
|
| preferredSeat | Seat Request |
|
| smoker | Smoker |
|
| traveller | Traveller |
|
| arranger | Arranger / Assistance |
|
| approver | Approver |
|
| flightmemberships0.alliance | Frequent flyer / Airline | 2-letter-airline-code e.g. SR (Swiss) |
| flightmemberships0.membernumber | Frequent Flyer / Number | |
| flightmemberships0.additionalinfo | Frequent Flyer / PIN | |
| hotelmemberships0.alliance | Hotel Program / Hotel chain | 2-letter-hotel-code e.g. RT (Accor Hotel) |
| hotelmemberships0.membernumber | Hotel Program / Customer Number | |
| hotelmemberships0.additionalinfo | Hotel Program / Customer Request | |
| carmemberships0.alliance | Car Program / Company | 2-letter-car company-code e.g. ZE (Herz) |
| carmemberships0.membernumber | Car Program / Customer Number | |
| carmemberships0.additionalinfo | Car Program / Customer Request | |
| passports0.country | Passport / Country | 2-letter-country-code e.g. CH |
| passports0.number | Passport / Number | |
| passports0.issuedate | Passport / Issue date | Format = dd.mm.yyyy |
| passports0.issueplace | Passport / Issue place | |
| passports0.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 |
| 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 / Surename | |
| emergencycontacts0.email | Emergency Contact / E-Mail | |
| emergencycontacts0.phone | Emergency Contact / Phone | |
| emergencycontacts0.receivedocs | Itinerary / e-ticket (yes/no) |
|
| sortedAetmRoles0.community | AeTM Roles / Home community | community code e.g. ABCDABCD |
| sortedAetmRoles0.role | AeTM Roles / Role |
|
| sortedAetmRoles1.community | AeTM Roles / Further communtiy | |
| 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 |
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’s.
| 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’s. 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 an Company Setup custom field
CSV Upload
Please refer to section CSV Download / Upload.
