Crew Scheduler roster data can quickly and easily be exported for advanced payroll imports or other employee reporting needs. The data includes all regularly scheduled assignments, time off's, overtime hours, partial hours and miscellaneous hours. Data can be exported into an easy to read .pdf file, .xls or .csv file. Payroll data is also available in JSON format for API users. Export files & reports include important scheduling & time / attendance data such as: employee id, name, work type, work code, subclass, assignment, hours and assignment position.
Once your report has been compiled, it will be listed on the right-hand side of the screen. The last 10 reports from your organization will appear here. Simply click to download:
Formatting CSV file in Excel or Open Office:
If you open the CSV file, and it appears a garbled mess, this is because you have not yet separated the values correctly.
If you've already opened the file and need to separate the values, simply select the entire cell (in this case cell A); click Data -> Text To Columns, and select semi-colon as the separator value. Your file should now be in an easy to read format.
If you would like information on our Vendor API to access more robust data from our system, please drop us an email or open a support ticket.