Bookings ImportBooking 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.
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.
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.
|