Skip to end of metadata
Go to start of metadata

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, then the values will be ignored.

Overview

The attached file is an example of a traveller CSV file containing only standard fields. The file has to be downloaded to be viewed. Each single field is elaborated in the description below.

KB-Traveller CSV Standad fields.csv

 

Description

ColumnDescriptionValues/Actions
metadata.actionAction
  • SAVE
  • DELETE
uuidDatabase No.Blank if new profile
usernameFaces Username 
emailE-Mail Address 
languageUser 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)
genderGender (Faces field"Greeting")
  • MR
  • MRS
  • U
titleTitle
  • DR
  • PROF
nameSurname 
middlenameMiddlename 
firstnameFirstname 
birthdateDate of birthFormat = dd.mm.yyyy
nationalityCitizenship2-letter-country-code e.g. CH
additionalFormOfPaymentOther forms of payment
  • CASH
  • INV
hotelGuaranteeHotel 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
carGuaranteeGuarantee 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
webPaymentWebcard
  • 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
phoneBusinessPhone Business 
phonePrivatePhone private 
phoneMobileMobile 
receivedocsItinerary / e-ticket (yes/no)
  • true
  • false
preferredSeatSeat Request
  • A = Aisle
  • W = Window
preferredFoodMeal Requeste.g. VGML
smokerSmoker
  • true
  • false
travellerTraveller
  • true
  • false
arrangerArranger / Assistance
  • true
  • false
approverApprover
  • true
  • false
commentgeneral.comment 
company.recordlocatorCompany / Profile no. 
company.uuidDatabase No. Company 
company.nameCompany / Company Name 
railExtension.deliveryRail information / Delivery
  • BAHNTIX
  • ONLINE
  • PAPERTICKET
  • BAHNTIX
railExtension.wagonTypeRail information / Wagontype
  • COMPARTMENT
  • PREFER_WIDEBODY
  • REQUIRE_WIDEBODY
  • SINGLE
  • TABLE
railExtension.wagonExtraTypeRail information / Wagon extra
  • PHONEAREA
  • QUIETAREA
railExtension.seatprefRail information / Seat
  • AISLE
  • WINDOW
railExtension.railclassRail information / Class
  • FIRST
  • SECOND
railExtension.identificationRail information / Identification
  • BANKCARD
  • PERSONALCARD
  • RAILCARD
railExtension.idInfoRail information / Bank card 
sortedRailCards0.cardtypeRailcard / 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
sortedRailCards0.cardnumberRailcard / Number 
sortedRailCards0.cardExpirationRailcard / ExpirationFormat = dd.mm.yyyy
residentExtension.areaResident information / Resident Discount
  • CANARY
  • BALEARIC
  • CEUTA
  • MELILLA
residentExtension.areaCodeResident information / Area/Post Codepost code (numbers)
residentExtension.cardTypeResident information / National Identity Card type
  • NATIONAL_ID
  • MINOR_RESIDENT
  • RESIDENT_CARD
  • TEMP_RESIDENT
residentExtension.cardNumberResident information / National Identity Card number 
residentExtension.firstSurnameResident information / 
residentExtension.secondSurnameResident information / 
flightmemberships0.allianceFrequent flyer / Airline2-letter-airline-code e.g. SR (Swiss)
flightmemberships0.membernumberFrequent Flyer / Number 
flightmemberships0.additionalinfoFrequent Flyer / PIN 
hotelmemberships0.allianceHotel Program / Hotel chain2-letter-hotel-code e.g. RT (Accor Hotel)
hotelmemberships0.membernumberHotel Program / Customer Number 
hotelmemberships0.additionalinfoHotel Program / Customer Request 
carmemberships0.allianceCar Program / Company2-letter-car company-code e.g. ZE (Herz)
carmemberships0.membernumberCar Program / Customer Number 
carmemberships0.additionalinfoCar Program / Customer Request 
carmemberships0.specialRequestCar Program / Special request 
passports0.countryPassport / Country2-letter-country-code e.g. CH
passports0.numberPassport / Number 
passports0.issuedatePassport / Issue dateFormat = dd.mm.yyyy
passports0.issueplacePassport / Issue place 
passports0.issueCountryPassport / Issue country2-letter-country-code e.g. CH
passports0.expirationPassport / ExpiresFormat = dd.mm.yyyy
visa0.countryVisa Information / Country2-letter-country-code e.g. RU
visa0.numberVisa Information/ Number 
visa0.issuedateVisa Information / Issue dateFormat = dd.mm.yyyy
visa0.issueplaceNot available in the user interface 
visa0.expirationVisa Information / ExpiresFormat = dd.mm.yyyy
visa0.multiPurposeStringVisa Information / Entry type
  • SINGLE
  • DOUBLE
  • MULTIPLE
employeecards0.countryIdentification cards / Country2-letter-country-code e.g. CH
employeecards0.numberIdentification cards / Number 
employeecards0.issuedateNot available in the user Interface 
employeecards0.issueplaceNot available in the user Interface 
employeecards0.expirationNot available in the user Interface 
arrangercontacts0.contactAdministration / Arranger / AssitanceArrangers email address
arrangercontacts0.receivedocsItinerary / e-ticket (yes/no)
  • true
  • false
approvercontacts0.contactAdministration / ApproverApprovers email address
approvercontacts0.receivedocsItinerary / e-ticket (yes/no)
  • true
  • false
emergencycontacts0.firstnameEmergency Contact / First Name 
emergencycontacts0.lastnameEmergency Contact / Surname 
emergencycontacts0.emailEmergency Contact / E-Mail 
emergencycontacts0.phoneEmergency Contact / Phone 
emergencycontacts0.receivedocsItinerary / e-ticket (yes/no)
  • true
  • false
sortedTravelGroups0.groupIdTravel groups / Main travel groupcommunity code e.g. ABCDABCD (AeTM) or Location, Division (cytric)
sortedTravelGroups0.roleTravel 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.groupIdTravel groups / Further travel group 
sortedPublishStates0.id.publishtargetTarget system
  • CSX = Amadeus
  • GALILEO_WS = Galileo
  • CYTRIC = Cytric
  • AETM = Amadeus e-travel management
sortedPublishStates0.recordlocatorTarget 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.internallocatorTarget System additional number/nameAeTM = traveller id
Only for import, no export available...!!!!
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

Wolfgang Schuller was ist mit Feldern wie railExtension.uuid??File durchgehen

 

 


  • No labels