Import bookings into HBook from a spreadsheet

详细信息

I have a camping website with the HBook plugin, on Wordpress.
There is a spreadsheet of previous bookings to be added to the booking system.
The plugin developers have given me the instructions below.
I am looking for someone to import the old bookings quite quickly.
I am open to offers on this project.
Here are the instructions.
Thanks - also, I now attach the old bookings that will need to be added in xls and csv format.
I give you some information below regarding the import of customers and reservations from the old booking system.
Regarding Customers:
You would import your customers in the "hb_customers" table of the database. This is more straight forwards since this table is independent of any other table. You need to know how to format properly your existing customer list to match "hb_customers" table structure. You will use the import function of PhpMyAdmin for example.
Regarding reservations:
There are 2 options :- working with database- working with ical
Option 1 - Import via Ical
You can create an ical file of your reservations for each accommodation. If your existing system supports ical export or sync, this is the easiest way to go. Alternatively you can compile your ical file but you need basic PHP knowledge. It is rather basic formatting. For example, a calendar with 2 events (= 2 reservations):

http://BEGIN:VCALENDAR
http://METHOD:PUBLISH
PRODID:-//HBook Demo 1//HBook-single-room-1// EN
http://CALSCALE:GREGORIAN
http://VERSION:2.0
http://BEGIN:VEVENT
DTEND;VALUE=http://DATE:20240411
DTSTART;VALUE=http://DATE:20240404
http://DTSTAMP:20230428T085052Z
http://UID:D2023-11-27T20:13:00U5bfda54c78249@wp.com/booking-plugins/hbook/demo-1
http://DESCRIPTION:NAME: John Doe\nEMAIL: john.doe@test.com
http://SUMMARY:HBook reservation - John Doe - Resa id: 115
http://STATUS:CONFIRMED
http://CREATED:20181127T201300Z
http://END:VEVENT
http://BEGIN:VEVENT
DTEND;VALUE=http://DATE:20240221
DTSTART;VALUE=http://DATE:20240120
http://DTSTAMP:20230428T085052Z
http://UID:D2024-01-12T01:17:22U5c394022b968d@wp.com/booking-plugins/hbook/demo-1
http://DESCRIPTION:NAME: Jane Fox\nEMAIL: janefox@email.com
http://SUMMARY:HBook reservation - Jane Fox - Resa id: 192
http://STATUS:CONFIRMED
http://CREATED:20190112T011722Z
http://END:VEVENT
http://END:VCALENDAR

You can customize the content of the property SUMMARY and DESCRIPTION. It will be added in the comment section of the reservation table. Please note that the customer information, payment information, nuimber of guests, etc... will not be filled since ical sync is about syncing availability. The room will be blocked for these dates and your client can see all information given in the ical file in the comment section.
Option 2 - Work with database
If you wish to have all reservation information (number of person, customer created, etc...), you should then use csv import to fill the database with the correct content.
If you wish to import the reservations in the same way, you need to be more careful since you will have to take into account:- accommodation type id : "accom_id" column- accommodation num : "accom_num" column- customer id: this will be available once you have imported the customer data in "hb_customers".
This information will need to be retrieved from the table "hb_accom_num" once you have created your accommodation types in Accommodations menu.