Visitor export file

These fields are included in the Visitor export file:

Column header	Description	Comment
Badge Code	Badge code of Visitor
Language	Translation selected during registration
Gender	Gender selected during registrations	M/F
Initials	Entered in initials field	If ‘Initials’ field is not used during registration this will be blank
Title	Entered in Title field
First Name	Entered in First Name field
Last Name Prefix	Entered in Last Name Prefix field
Last Name	Entered in Last Name field
Suffix	Name suffix	e.g. Jnr
Date of Birth	Entered in Date of Birth field
Nationality	Entered in Nationality field
Company	Entered in the Company field
Department	Entered in the Department field
Job Function	Entered in the Job Function field
Address line 1	Entered in the Address Line 1 field
Address line 2	Entered in the Address Line 2 field
Address line 3	Entered in the Address Line 3 field
House number	Entered in the House Number field	Only available If this is selected in the Full Address System question
House number suffix	Entered in the House Number suffix field	Only available if this is selected in the Full Address System question
Postal code	Entered in the Postal Code field
City	Entered in the City field
State	Entered in the State field
Country	Entered in the Country field
Country ISO	The 2-letter ISO code of the country
Phone 1	Entered in the Phone 1 field
Phone 2	Entered in the Phone 2 field
Fax	Entered in the Fax field
Website	Entered in the Website field
Email	Entered in the Email field
VAT number	Entered in the VAT Number field
CoC Number	Entered in the CoC Number field
Comments	Entered in the Comments field
Registration key	Auto-generated number during registration	A number is also created if a Visitor is imported
Mailing	Entered in the Mailing question	Possible answers are Yes and No
Data Use 1	Entered in the Data Use 1 question	Possible answers are Yes and No
Data Use 2	Entered in the Data Use 2 question	Possible answers are Yes and No
Data Use 3	Entered in the Data Use 3 question	Possible answers are Yes and No
Registrant State	Registration Status of the Visitor	See Appendix D for more details
Method	The registration method used	Possible values are online (Form), onsite (Manned Registration) or onsite_self (Self Registration)
Location	Location of the Eventbox where first scan took place	If no location value for the EventBox is defined, this field is blank
Reference	Contact reference	Unique reference created by user to import records
Invitation Partner	If the Visitor registered via a Partner link, the partner name
Partner Type	If the Visitor registered via a Partner link, the partner type
Registered via	Partner name if registered via a Partner link
Create time	The time the registration started.	Time is in UTC time zone.
Registration time	The time the registration completed, in UTC time.	Time is in UTC time zone. If a delayed payment option is chosen this value remains blank until the transaction is successful.
Visit time	The time the Visitor is first scanned at the event.	Time is in UTC time zone.
Number of visits	The number of times a Visitor re-enters an event
Registrant type	The type assigned to the Visitor	Type is assigned during registration or import
Action Code	Entered in the action code field
Action Code Name	The name that corresponds to the Action Code field entered
Mail Badge to	Selection in portal	Possible values are Main or Individual
Order code	If a valid is made, this is the order number
Order items	Items that belong to the order
Amount paid	The total amount paid for any shop items ordered	If the payment is made in Euros, GBP or USD the currency symbol appears in front of the amount. If a different currency is used no symbol will appear.
Payment Code	Identifier from the PSP for the order payment
Registration Link	Hotlink
Tag	Entered in the Tag field
Social Media	Social media platform used during registration	If used, possible values are Facebook, LinkedIn, Google+ or Twitter
Main visitor’s badge code	If a Visitor is registered via Group Registration, the badge number of the main registrant
UN	The unique reference of the visitor badge	Needed when using Visit Connect
Visitor Reference	No longer valid
Verification Log	History of changes made to the Verification details of a registration	Applicable only to Organisations that have the Registration Verification module and that has been activated for the registration form used.
First Entry Time	The very first time that a Visitor is scanned as entering an Event	Time is in the local event time zone.
Last Exit Time	The very last time that a Visitor is scanned as leaving an Event,	Time is in the local event time zone.
Dwelling Time	The total amount of time that a Visitor is inside an Event.	If a Visitor leaves an event and re-enters, the time they are out is not included in the calculation.

After this, any questions you ask during the registration process are listed, along with answers. Note that the field names mentioned above refer to System questions. If you create your own question (with the same name as a System question) and use that in the registration, it will be displayed at the end of the Visitor export file.