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.

 

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 group

Cytric:

  • Location
  •  Division
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
sortedTravelGroups1.groupIdTravel groups / Further travel group 
sortedPublishStates0.id.publishtargetTarget system
  • CSX = Amadeus
  • GALILEO_WS = Galileo
  • CYTRIC = Cytric
sortedPublishStates0.recordlocatorTarget system identification number/name
  • Amadeus = Profile record locator
  • Galileo = Profile 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/name 
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