What format is your data file?

By March 23, 2016 No Comments

FAID Quantum uses comma delimited text files with an ‘.rtq’ (Roster Quantum) file extension. The files have no header information.

There is one task/shift/rostered activity record per line containing three compulsory fields of information (ID, Start, End), with optional fields like Task Risk, Origin, Destination, Activity Code, Location Start and Location End.  The optional fields need to be turned on within the Settings section of FAID:

ID can be text (i.e. a person’s name), or value (i.e. payroll number) used to identify an employee or planned sequence of shifts (“line of work”).

Start and End are the date and time of the task – FAID writes these in “dd mmm yyyy hhmm” format but is quite versatile in interpreting (reading) most common date/time formats.

Task Risk (if using multiple Tolerance Levels) must be one of “Low”, “Moderate”, or “High”

For example:

Smith,1 Nov 2017 0900,1 Nov 2017 1730,Moderate

Smith,2 Nov 2017 0900,2 Nov 2017 1730,Low

 

View a sample .rtq file

Sample Work Schedule (5.6 KiB)

Additional information on generating this data using Microsoft Excel can be found in the I am having trouble entering and manipulating data for importing, what do you recommend? FAQ.

Was this answer helpful ? Yes (0) / No (0)

Leave a Reply