File format for Pass Visits
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Examples
Visitpass Group Example 1.xlsx
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Code | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Code | Yes | Organization code owning the data to be imported. By default, the organization code is the same as the institution code. |
| ORDER_ID | Number | No | Order number. Will be set by import package while importing if left empty. |
| ORDER_DATE | Date | Yes | Order date. By default, order date is importing date. |
| OPERATION_TYPE | Enum | Yes | Operation type. Allowed values: SALE or RESERVATION. |
| REMARK | Text | No | Order remark. |
| CONTACT_NR | Number | Yes | Buying contact number. |
| HOLDER_CONTACT_NR | Number | No | If not filled in, the purchase contact is used. For a group visit, the contact must be of type RELAY. |
| FIRST_NAME | Text 50 | No | Beneficiary first name. Set this info only for sold visits. |
| LAST_NAME | Text 50 | No | Beneficiary last name. Set this info only for sold visits. |
| SEASON_CODE | Code | Yes | Season code of visit pass. |
| VISIT_CODE | Code | Yes | Product code of visit pass. |
| START_TIME | Timestamp | Yes | Start time of the visit. |
| DURATION | Number | Yes | Duration of the visit in seconds. |
| CONTINGENT | Code | No | Contingent code. |
| TARIFF | Code | Yes | Tariff code. |
| PRICE | Amount | Yes | Price of visit * 100. If flat rate, full price of the visit. If individual rate, unit price per participant. |
| CHARGE | Amount | No | Charge of ticket * 100. |
| VAT | Percentage | Yes | 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_DATE | Timestamp | Yes if SALE | Mandatory when the operation type is SALE and price is not 0. Default value: Order date. |
| TICKET_STATE | Enum | Yes if SALE | The state of ticket. Mandatory when the operation type is SALE. Allowed values: NOT_PRINTED, PRINTED or CONTROLLED. |
| GENERATION_DATE | Timestamp | Yes if PRINTED or CONTROLLED | Generation date. Mandatory if the ticket has been printed or controlled. Default value: Order date. |
| BARCODE | Text | Yes if PRINTED or CONTROLLED | Bar code of the visit. Mandatory if the ticket has been printed or controlled. |
| TAX_NUMBER | Text | Yes if PRINTED or CONTROLLED | The tax number of the visit. Mandatory if the ticket has been printed or controlled. |
| SHIPMENT_DATE | Timestamp | Yes if SHIPMENT_MODE=SENT | Shipment date of the visit. Default value: Order date. |
| SHIPMENT_MODE | Code | Yes if PRINTED or CONTROLLED | Shipment mode of the season ticket. Allowed values: SENT, SENT EMAIL, BOXOFFICE, CONTROL. Mandatory if the ticket has been printed or controlled. |
| GROUP_NAME | Text | Yes if group visits | Name of the group. Leave empty for individual visits. |
| GROUP_KIND | Code | Yes if group visits | Group kind. Leave empty for individual visits. |
| THEME | Code | No | Theme of the visit (only useful for guided visits) |
| LANGUAGE | Code | No | ISO Language code of the visit (fr, en, ...) (only useful for guided visits) |
| VISITOR_TYPE | Enum | Yes | Type of visitor. Allowed values: PARTICIPANT or ACCOMPANIER. |
| NB_VISITORS | Number | Yes | Number of visitors. Must be > 0. |
| PLACE | Text50 | No | |
| GUIDE | Text50 | No | Last name and First name of the guide. |
| GROUP_CRIT_ELEMENT | Code | No | Group criterion element code. |