BookingLive: Online Booking System

How to import customer data

In order to use BookingLive to import your data, it must be in the XML format as recognised by BookingLive. This format has the following properties:

1. Objects are all contained within the root <data> tag.

2. Tags within the root <data> tag are all the tags that describe collections of objects, i.e. <Locations> or <Activities>. If you only have one object of a type to import, it still must be contained within a collection tag.

3. Within collections of objects, individual objects of the same type can be defined, for example a <Locations> tag can include a set of <Location> tag.

4. Data to be included for each record can be included delimited by tags of the appropriate name within each object tag. For example a <Location> record may include a <Name>Swimming Pool</Name> field where "Name" is the name of the data field and "Swimming Pool" is the data to be entered into the "Name" field for this particular record. Object types reconised and their respective allowed data tags that can be included will be listed at the end of the document.

5. Optionally, each record may contain an <Identifier> tag, which may contain an identifier that identifies that record uniquely within the XML document.

6. If a record needs to be linked to another record of a different type, a record may include a tag defining the object within itself. For example, an <Schedule> tag may include an <Activity> tag.

7. If a record needs to be linked to many records of a different type, a record may include a tag defining the group of objects within itself. For example, an <Activity> tag may include a <Locations> tag, which in turn may include more <Location> tags.

8. Records may be defined 'in line' with another record, or if they need to be linked to form multiple other records, may be defined under the root <data> element and linked to via their <Identifier> tag. Here is a simple example of the first case:

<data>

       <Bookings>

              <Booking>

                     <BookingRef>BookingReference</BookingRef>

                     <Purchaser>

                           <FirstName>Adam</FirstName>

                     </Purchaser>

              </Booking>

       </Bookings>

</data>

You can see that a Booking defined here contains one purchaser record. Here is an example of the second case:

<data>

       <Activities>

              <Activity>

                     <Identifier>Act-001</Identifier>

                     <Name>Coconut Shy</Name>

              </Activity>

       </Activities>

       <Schedules>

              <Schedule>

                     <StartDate>01/01/2015</StartDate>

                     <EndDate>01/01/2015</EndDate>

                     <Activities>

                           <Activity>Act-001</Activity>

                     </Activities>

              </Schedule>

              <Schedule>

                     <StartDate>02/01/2015</StartDate>

                     <EndDate>02/01/2015</EndDate>

                     </Activities>

                           <Activity>Act-001</Activity>

                     </Activities>

              </Schedule>

       </Schedules>

</data>

Above you can see that two schedules that are defined both reference the same activity. Also, both schedules can reference more than one activity as shown by the use of <Activities> tags within each schedule record.

9. Finally, as per the XML specification[1], valid xml documents must also begin with an xml declaration: <?xml version="1.0" standalone='yes'?> 

Assuming you have a complete XML document and wish to upload it to your site, please use the url: http://<siteUrl>/dataimportpage o navigate to your site's data import page. You will be presented with a page as below:

Either enter the path to your xml file in the text box displayed or click the 'Browse...' button to find your file graphically. Click 'Submit Query' to import the data. Depending on the number of records, this may take a while. Once the records are all uploaded, it will present a screen like the following:

You will then be able to navigate to the normal site admin url and see the data imported.

Example XML File

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<data>

        <Activities>

                <Activity>

                        <Identifier>ACT-001</Identifier>

                        <Code>ACT-001</Code>

                        <Name>Activity 1</Name>

                </Activity>

        </Activities>

        <Schedules>

                <Schedule>

                        <Identifier>1</Identifier>

                        <StartDate>01-01-2010</StartDate>

                        <EndDate>02-01-2010</EndDate>

                        <StartTime>10.00</StartTime>

                        <EndTime>15.00</EndTime>

                </Schedule>

        </Schedules>

        <Bookings>

                <Booking>

                        <OrderRefNumber>REF-001</OrderRefNumber>

                        <DateBooked>01-01-2010</DateBooked>

                        <TotalCost>10.00</TotalCost>

                        <Purchaser>

                                <SocialTitle>Mr.</SocialTitle>

                                <FirstName>Andrew</FirstName>

                                <Surname>Test</Surname>

                                <Email>Test@Test.com</Email>

                                <FullAddress>Road 1, Town 2, Region 3</FullAddress>

                                <PostCode>AA1 1AA</PostCode>

                                <Telephone>01234567891</Telephone>

                                <MobileTelephone>07123456789</MobileTelephone>

                                <Dob>01-01-1976</Dob>

                        </Purchaser>

                        <BookingItems>

                                <BookingItem>

                                        <Activity>ACT-001</Activity>

                                        <Schedule>1</Schedule>

                                        <Participants>

                                                <Participant>

                                                        <SocialTitle>Mr.</SocialTitle>

                                                        <FirstName>Andrew</FirstName>

                                                        <Surname>Test</Surname>

                                                        <Dob>01-01-1976</Dob>

                                                        <Telephone>01234567891</Telephone>

                                                        <MobileTelephone>07123456789</MobileTelephone>

                                                        <TelephoneOther>01234567891</TelephoneOther>                                                            <MedicalConditions>Description</MedicalConditions>

                                                        <Email>Test@Test.com</Email>

                                                        <Address>Road 1, Town 2, Region 3</Address>

                                                        <PostCode>AA1 1AA</PostCode>                   

                                                </Participant>

                                        </Participants>

                                </BookingItem>                         

                        </BookingItems>

                </Booking>

        </Bookings>

</data>

Valid Record Tags and Related Data

This is a list of record tags that can be used, along with their respective plurals and data for each record.

Record Information

Data Tags

Tag

<Booking>

<OrderRefNumber>, <Status>, <DateBooked>, <TotalCost>

 

Plural

<Bookings>

Related

<BookingItems>

<Purchaser>

 

Tag

<BookingItem>

<Quantity>, <Cost>, <Description>

 

Plural

<BookingItems>

Related

<Booking>

<Activity>

<Schedule>

<Participants>

 

Tag

<Activity>

<Code>, <Name>, <BriefDescription>, <Price>, <DurationMinutes>, <DurationDays>, <Availabiliy>, <CloseOfSale>, <OpeningOfSale>, <MinimumParticipants>, <BookingMultiple>, <Status>, <EnquireOnly>, <Type>, <BookingPageSevenDayCalendar>

 

Plural

<Activities>

Related

<BookingItems>

<Schedules>

Tag

<Participant>

<SocialTitle>, <Type>, <FirstName>, <Surname>, <Dob>, <Telephone>, <MobileTelephone>, <TelephoneOther>, <DietryRequirements>, <MedicalConditions>, <Email>, <PostCode>, <Address>, <Country>,

(more as allowable for participant template items)

Plural

<Participants>

Related

<BookingItem>

Tag

<Schedule>

<StartDate>, <EndDate>, <StartTime>, <EndTime>, <OriginalSlots>, <Status>, <Featured>

Plural

<Schedules>

Related

<Activity>

Tag

<Purchaser>

<SocialTitle>, <FirstName>, <Surname>, <Telephone>, <MobileTelephone>, <Email>, <Organisation>, <FullAddress>, <Address1>, <Address2>, <Address3>, <Town>, <Dob>, <KinName>, <KinContactNumber>,

(more as allowable for purchaser template items)

Plural

<Purchasers>

Related

<Booking>


[1] Xml specification 1.0: http://www.w3.org/TR/REC-xml/