Version vom 6. März 2015, 15:20 Uhr (Quelltext anzeigen) Wolfgang (Diskussion | Beiträge) (→‎CSV Download / Upload) ← Zum vorherigen Versionsunterschied		Version vom 6. März 2015, 15:48 Uhr (Quelltext anzeigen) Wolfgang (Diskussion | Beiträge) (→‎CSV Download / Upload) Zum nächsten Versionsunterschied →
Zeile 231:		Zeile 231:
	[[Image:csv_upload_3.png|300px|CSV-Upload Ergebnis]]		[[Image:csv_upload_3.png|300px|CSV-Upload Ergebnis]]
−	Nach dem Hochladen werden allfällige Fehler angezeigt. Ebenso kann mit dem Link "Fehlerdatei" eine Textdatei mit den Fehlermeldungen heruntergeladen werden.	+	If the upload leads into an error the relevant messages are shown. A printable version of the error message is available in "errorfile".
−	=== Update bestehender Profile ===	+	=== Update of existing profiles ===
−	Wird ein schon bestehendes Profile aktualisiert, muss im CSV eine Spalte "uuid" und/oder "recordlocator" vorhanden sein. Letzteres bezieht sich immer auf den CSX Profil-Recordlocator.	+	If an already existing profiles will be updated, the "uuid" and/or "record locator" must be present in CSV. The record locator refers to the Amadeus CSX Profil-Recordlocator.
	<module name="AeTM">		<module name="AeTM">
−	Damit einem bestehendes Profil auch ein AeTM Profil kreiert wird müssen im CSV die folgenden Spalten eingetragen werden	+	If from an existing Profile a AeTM profile is created, the CSV-files must contains the following columns:
	{|		{|
−	! Spalte	+	! Column
−	! Beschreibung	+	! Discription
	|-		|-
	|sortedAetmRoles0.community		|sortedAetmRoles0.community
−	|Community-Code, die sortedAetmRoles0.community gilt immer als Home-Community des Reisenden	+	|Community-Code, sortedAetmRoles0.community is always the Home-Community for the traveller
	|-		|-
	|sortedAetmRoles1.community,sortedAetmRoles2.community		|sortedAetmRoles1.community,sortedAetmRoles2.community
−	| weiter Communities, es können beliebig viele Communities eingetragen werden (Nummerierung sortedAetmRoles"X")	+	| further Communities, it can be down any numbers of communities (numbering: sortedAetmRoles"X")
	|-		|-
	|sortedAetmRoles0.role,sortedAetmRoles1.role,sortedAetmRoles2.role		|sortedAetmRoles0.role,sortedAetmRoles1.role,sortedAetmRoles2.role
−	|AeTM Rollen:	+	|AeTM Roles:
	* TRAVELER		* TRAVELER
	* PRINCIPAL_TRAVEL_ARRANGER		* PRINCIPAL_TRAVEL_ARRANGER
Zeile 258:		Zeile 258:
	|-		|-
	| sortedPublishStates1.id.publishtarget		| sortedPublishStates1.id.publishtarget
−	| Hier wird der Wert "AETM" für die Übertragung nach AeTM eingetragen	+	| Insert the value "AETM" for a transmission into AeTM
	|-		|-
	| sortedPublishStates1.recordlocator		| sortedPublishStates1.recordlocator
−	| AeTM Login-Name	+	| AeTM Login name
	|-		|-
−	|colspan=2| ''Um ein bereits existentes AeTM Profil mit einen bestehende Profil zu koppeln, ist zusätzlich die folgende Angabe im CSV notwendig.''	+	|colspan=2| ''To synchronize the existing AeTM profile with an existing Tenzing Faces Profil, the additional information is necessary.''
	|-		|-
	| sortedPublishStates1.internallocator		| sortedPublishStates1.internallocator

---

Version vom 6. März 2015, 15:48 Uhr

U N D E R --- C O N S T R U C T I O N

General

In this tab company profiles will be created and modified.

Layout

User Interface

Section 'General'

Field	Description
Parent company	Administrative assignment of a company, which is the main company.
Travel Department OID	Entry of the Amadeus Office ID in which the profile will be synchronized, if field is empty, profile will be synchronized into the main office ID.
Travel Department Org-ID	Entry of the Amadeus Organisation ID (allocated to the OID)
Customer No.	AIAN of the company (also synchronized as PIN)
Company	The full name from the company.
Short name	must be unique in the GDS (PCN)!
Street	Street from the company.
Street 2	Addition to the street.
ZIP	The ZIP code from the company.
Place	The place form the company.
County	The country.
phone	Main phone number
Fax	Main fax number
E-Mail, E-Mail 2, E-Mail 3	Main E-Mailaddresses from the company.
Form of Payment	Entry of the main credit card. This credit Card is wirten as FoP (F. or FP) in the GDS's.
Creditcard No.	Credit card number
Expiration	The expiration date of the credit card (Format DD/YY)
Use as web-card	Here you can specify how the traveller is allowed to use the company card (hotel guarantee or web card). Traveller decides: Traveller can choose the company card (optional). Mandatory use: Traveller automatically has chosen the company car. No personal credit card can be used for Hotel guarantee and web card.. Prohibited use: Traveller can not choose the company card.
Web-Card	In this field a second company credit card can be stored. This is useful when the primary card is a AirPlus or BTA which will not be accepted as a web cards and hotel as guarantee.
Personal cards	Setup how credit cards can be entered in traveller Profile associated to the company. FP and guarantee: Travellers are allowed to enter a credit card in his profile. Credit card can be used for form of payment, hotel guarantee and web-card. Guarantee only: Travellers are allowed to enter a credit card in his profile. Credit card can be used hotel guarantee and web-card None: Travellers are not allowed to enter a credit card,
Personal CC on	Module: AeTM Configuration in which AeTM Field (possible values CC1, CC2 or CC3) the personal credit card will be transmitted.

Section 'Publishing'

Field	Description
Amadeus CSX	Result of the last synchronization including date, time. Profile record locator.
Profil no.	Profile record locator.
AeTM Communities, Description	Module: AeTM Company related AeTM communities indluding free text description

Section 'Preferences'

Field	Description
Airline Company program
Airline	Entry of the different coperate airline programs.
Published as	CSX Präfix Command (OSI or SK)
Guarantee Hotel/Rental car	Guarantee for hotel and car rental with a creditcard (company or web card).
Hotel Travelguidelines
Hotel chain	Drop down menu with relvant hotel chains.
Rate code	Definition of the rate code (e.g. RAC, COR). One rate code per chain is permitted
Customer Request	Free text reqeusts
Car Travelguidelines
Company	Drop down menu with relevant car rental companies.
Corporate Discount Nummer	Customers Corporate Discount Nummer
Customer Request	Free text reqeusts
Prefered Rental	Prefered Rental are registered as PPC in Amadeus CSX.

Section 'Your Team'

Field	Description
Agency	Travel Agency which the company is allocated.
Confidential	free text
Email delivery	Amadeus Fax Email Plus Amadeus Mail
E-Mail invoice delivery	E-Mailaddress which is used for invoice delivery. This field can be used in profile-action, source 'emailInvoiceDelivery'.
Reporting Office	The Amadeus Office ID will be transmitted as "shadow destination".
AeTM Site-Name	Module: AeTM Entry of the AeTM Site-Name. (e.g. umbrella) The ending of the URL http://e-travelmanagement22.amadeus.com/Login/umbrella is used.
Site Code	Module: AeTM Entry of the AeTM main community (L1)

Section 'Comment'

Comments are free text formats.

Section 'Log'

The log is a history of all saved modifications. The log shows date, time, user and status "saved profile".

Procedures / Processes

Company create / modify

Company profiles can be created, edited and deleted. New companies will be created in the tab "Companies". The click on "Manage companies" and a second click to the green "Plus symbol" will create a new empty input mask for company profile. The Deletion of a company profile also deletes all associated travellers. After saving a company profile (new or modifications) the profile data’s are transmitted to the relevant systems. A Status message is shown in the Section Publishing.

CSV Download / Upload

All traveller profiles from a specific company can be downloaded and uploaded via a CSV-File (comma-separated values).

Every single data fields in the CSV will be transmitted into the Tenzing Faces Profile. Please take into account::

• Mandatory fields has to be filled in the CSV
• Dates like birthday must have the Format dd.mm.yyyy (e.g. 23.06.1962)
• The modifications of numbers (credit card numbers, frequent Flyer numbers) in Microsoft Excel in a CSV-file has some specifications! In Microsoft Excel a number, with more than 15 count, is automatically displayed exponentially.(KB214233). Numbers like 12345678901234567 will be converted in 1.23457E+16. To prevent this situation, numbers should be captured including spaces, e.g. '1234 5678 9012 34567'.

If the upload leads into an error the relevant messages are shown. A printable version of the error message is available in "errorfile".

Update of existing profiles

If an already existing profiles will be updated, the "uuid" and/or "record locator" must be present in CSV. The record locator refers to the Amadeus CSX Profil-Recordlocator.

Technische/Funktionale Details

Feld-Mapping

Faces	CSX	AeTM
Kundennummer	AI AN, PIN	n/a
Firma	AP	n/a
Kurzname	PCN	n/a
Strasse	AB/AD1	n/a
Strasse 2		n/a
PLZ	AB/ZP	n/a
Ort	AB/CI	n/a
Land	AB/CO	n/a
Telefon	AP -B	n/a
Fax	AP -F	n/a
E-Mail, E-Mail 2, E-Mail 3	APE oder RM*EMAIL	n/a
Zahlungsform	FP	n/a
Airline Firmenprogramm		n/a
Fluglinie	SK oder OS	n/a
Garantie Hotel/Mietwagen	PHI/G und PCI/G	n/a
Hotel Reiserichtlinien		n/a
Hotelkette	PHI/CO	n/a
Rate-Code	PHI/SR	n/a
Kundenwunsch	PHI/SI	n/a
Mietwagen Reiserichtlinien		n/a
Mietwagen Anbieter	PCI/CO	n/a
Corporate Discount Nummer	PCI/CD	n/a
Kundenwunsch	PCI/SI	n/a
Bevorzugter Anbieter	PPC	n/a
Vertraulich	RX	n/a
Versandart E-Mail		n/a
E-Mail Rechnungsversand		n/a
Reporting Office	FK und ES	n/a
Kommentar	PN	n/a

Profil Aktionen

COPY

Firma, Telefon, Fax

name,phone,fax

Kundennummer

externalnr

Email, Email2, Email3

email, email2, email3

Web-Karte (Kreditkarten Vendor, Nummer, Ablaufdatum)

fopCreditcardType2,fopNumber2,fopExpiration2

Hotelkette

hotelmemberships0.alliance

Hotel rate code

hotelmemberships[0].membernumber

Mietwagen Anbieter

carmemberships0.alliance

Mietwagen Coperate Discount Nummer

carmemberships0.membernumber

Mietwagen Kundenwunsch

carmemberships[0].additionalinfo

Garantie Hotel/Mietwagen

guarantee

Generische Felder, zB im Abschnitt "Präferenzen"

mergedgroups:general.header_prefs:0.value

Webkarte

webcard

AeTM Community

communities[0].id.community

AeTM Community Beschreibung

communities[0].name

Dachgesellschaft

parentCompany.name

Airline Firmenprogramm (Airline)

airlineincentives#.alliance

Airline Firmenprogramm (Infotext)

airlineincentives#.additionalinfo

Zahlungsart Amadeus CSX

fop

Zahlungsart Galileo GWS

fopGws

FILTER

Filter Firmenname

//pnrElements[pnrElementInformation/pnrElementIdentification/textSubjectQualifier = '3' and pnrElementInformation/pnrElementIdentification/informationType = '5'][1]

Filter Telefon Business

//pnrElements[pnrElementInformation/pnrElementIdentification/textSubjectQualifier = '3' and pnrElementInformation/pnrElementIdentification/informationType = '3']

Filter Fax

//pnrElements[pnrElementInformation/pnrElementIdentification/textSubjectQualifier = '3' and pnrElementInformation/pnrElementIdentification/informationType = 'P01']

Filter Kundennummer / AIAN

//accountingSection[accountingInformation]

Firmenadresse

//addressSection

Filter PIN

//generalProfileInformation[globalIndex]

Amadeus CSX

Änderunge der Reisestelle OID

Wird auf einer bestehende Firma eine neue Reisestelle OID eingetragen (oder geändert), so wird:

1. Die Firma in der alten OID deaktiviert (im CSX werden damit implizit alle verknüpften Reisende deaktiviert)
2. Die Firma in der neuen OID neu eröffnet
3. In Faces werden die CSX record locator auf allen Reisenden gelöscht. Innerhalb der nächsten 60min werden dann alle betroffenen Reisenden in der neuen OID neu erstellt

AeTM

Firmenprofile werden nicht mit AeTM synchronisiert.