×
Menu
Index

Bookings Import

 
Booking import works with the license File terminal. The file terminal must be defined in terminal manager and linked in terminal group. Bookings import will assign the bookings from a CSV file and link these to employees as defined in the CSV file.
 
Bookings import tab in Astrow IO Service
 
The bookings import CSV file must contain this structure:
 
Badgenr, Date and time, MC code, CC code, Terminal serial
1234,28/11/2018 09:33, , ,1217736
 
Import settings
 
Badgenr: The the badge number.
Date and time: In the field Bookings date & time format you can define the date format of the import. If can be any of the formats Astrow accepts (in Settings - System - Regional settings). The time format is set as hh:mm.
MC or CC code: The codes for bookings MC and CC. Let empty in case there are none.
Terminal serial: The serial is the serial of the physical terminal you want to import the bookings.
 
Other settings
 
Import folder: The path of the import file.
Export header: If you choose to keep the header by checking this option, the import will start with the second line.
 
Bookings file for import in Astrow Web
 
Save the settings made before running the import.
 
To run the import, put the file in the import folder. You will notice that this action creates 3 folders: completed, failed and incomplete. The service will check at the scheduled time for the import file and import data, if existing. Depending on the operation status, the import file will be moved in one of the folders.