We import data from tab-delimited text files so we prefer that you send your history in Excel. The Excel sheet should be formatted with the questions across the top and one row per shop. The header of each question column should be the corresponding Question ID # from SASSIE.
The header for the overall actual score column should be labeled "JobScore"(optional)
The header for the total possible score column should be labeled "TopScore"(optional)
The header for the Location ID column should be labeled "UserLocID"
The header for the Shop Date column should be labeled "1"
Data that we do import:
Question Responses (answer options, not scores, not "Yes".)
Yes/No, Yes/No/NA, Checkbox
Yes = 1
No = 2
NA = 3
Multiple Choice (Pull down menu, Radio Button, Multi checkbox)
First option = 1
Second option = 2
Third option = 3
MultiCheckbox: 1^2^3^4 etc
The actual text is imported.
Please note that "tabs" and "New Lines" cause problems.
Data we do not import:
Individual answer scores and Sectional Scores
(these get calculated based on how the form is set up in SASSIE)
Data we can import but prefer not to:
Overall Job Score
Overall Possible Score
(we prefer to calculate these based on how the form is set up in SASSIE. We can import them as is and lock them if necessary.)
Assuming the form is set up properly in SASSIE and there are no tabs or new lines in the text file, history can be imported in minutes. Cleaning up the tabs and new lines can take a considerable amount of time depending on how much history there is so the cleaner the file, the quicker it will go up.
Please deliver your history files to us via the Tracker.