Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

File format for Service import

The generic file format is described in Generic file format (Extended). This documents describes all available import fields.

Examples

Attachments
 

Field codeField typeMandatoryDescription
INSTIT
INSTITUTION
Text 15
CodeYesInstitution code owning the data to be imported.
ORGANIZATION
Text 15
Code
Yes
NoOrganization code owning the data to be imported.
OPERATION  Not yet use
If leave it empty, the institution code will be used.
ORDER_NR
Text 50YesOrder number
NumberNoIf leave it empty, order number will be set while importing by default.
One line is one ticket. So each line is a unique order number if leave it empty.
Many tickets can be in an order if leave them the same order number. This number can be started from 1 in a new data file. Then it will be given new one while importing.
This will be file number also.
ORDER_DATEDateNo
YesOrder date.OP
Buying date.
If leave it empty, it will be imported date by default.
OPERATION_TYPE
 
EnumYes
 REMARKText Order remark.SEASON_CODE Yes EVENT_CODE Yes START_TIMEDate ???SEAT_NUMBER  
Allowed values: SALE or RESERVATION.
CONFIRMATION_DATEDateNoExpiration date to confirm reservation.
REMARKText 2000NoInternal remark of order.
???
BUYING_CONTACT_NRNumber
 
NoContact number who buys the order.
If leave it empty, the sale will be anonymous by default.
ORIGIN_COUNTRY
 
Text 50
 
NoCountry of buying contact (only if buying contact is not specified).
 
ORIGIN_REGION
 
Text 50
 
NoRegion of buying contact (only if buying contact is not specified).
 
ORIGIN_ZIPCODE
 
Text 50
  CULTURAL_CONTACT_NR   FIRST_NAME   LAST_NAME   SEATCAT_CODE   AUDSUBCAT_CODE   CONTINGENT_CODE   PRICE   CHARGE   VAT   PAYMENT_DATE   TICKET_STATE   GENERATION_DATE   BARCODE   FISCAL_NR   SHIPMENT_DATE   SHIPMENT_MODE   
NoZip code of buying contact (only if buying contact is not specified).
SEASONCodeYesSeason code of service.
SERVICECodeYesProduct code of service.
ITEMCodeYesItem code of service.
VALIDITY_BEGINTimestampYesThe date starts to validate.
VALIDITY_ENDTimestampYesThe date stops to validate.
TARIFFCodeYesTariff code.
PRICEAmountYesPrice of ticket * 100 (so that 25$ = 2500).
CHARGEAmountNoCharge of ticket * 100 (so that 1$ = 100).
VATPercentageNoIf leave it empty, it will be 0 while importing by default.
Vat rate in percent * 100 (so that 1% = 100).
Choose the rate that active and valid following this:
Valid from date of vat rate <= ORDER_DATE <= Valid to date of vat rate.
PAYMENT_DATEDateNoIf leave it empty, the operation type is SALE and the price is not 0, the order date will be used by default. Means it can be imported date if the order date is not given.
SERVICE_NRNumberNoEach service has a unique number to know how many services have been published.
In importation, it helps to define ticket to check between data excel file and database system after importing.
This number can be started from 1 in a new data file. Then it will be given new one while importing.
CULTURAL_CONTACT_NRNumberNoContact number who is ticket holder.
If leave it empty and first/last name are empty, the buying contact number will be used by default.
BENEFICIARY_FIRSTNAMEText 50NoBeneficiary first name (only if cultural contact is not specified).
BENEFICIARY_LASTNAMEText 50NoBeneficiary last name (only if cultural contact is not specified).
TICKET_STATEEnumYes if SALEMandatory when the operation type is SALE.
Allowed values: NOT_PRINTED, PRINTED, CONTROLLED.
GENERATION_DATEDateNoIf leave it empty and the ticket has been printed or controlled, the order date will be used by default. Means it can be imported date if the order date is not given.
BARCODEText 50NoIf leave it empty and the ticket has been printed or controlled, it will be generated following import rules by default 'IMP-' + ticket id.
TAX_NUMBERText 50NoIf leave it empty and the ticket has been printed or controlled, it will be generated following import rules by default 'IMP-' + ticket id.
SHIPMENT_DATEDateNoIf leave it empty, the order date will be used by default. Means it can be imported date if the order date is not given.
SHIPMENT_MODECodeNoIf leave it empty and the ticket has been printed or controlled, it will be imported following import rules by default.
PERFORMANCE_DATE