Booking import works with the licenseFile terminal. The file terminal must be defined in the terminal manager and linked in the 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 badge number.
Dateand 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 to one of the folders.