meta data for this page
EXPORTING REPORT DATA
AccuSQL/AccuTrack allows you to export the data of any of its reports to other applications. This is useful for example if you want to manipulate the data in Microsoft Excel or other applications.
To export the data, use the Report’s screen to select the reporting period and apply any desired filtering. When you are ready, click on the “Export Data” button. This will bring up the Export Data dialog box:
If you select one of the first three options, AccuSQL/AccuTrack will prompt you for a file name and location through the “Save As” dialog box. You can either keep the suggested name and path, or enter different ones. When you are ready to proceed, click on the “Save“ button.
EXPORTING DATA TO AN EXCEL FILE
The first option button in the Export Data box creates a Microsoft Excel worksheet file.
EXPORTING DATA TO AN SDF FILE
The second option in the Export Data box exports the data into an SDF file. An SDF file is an ASCII text file in which records have a fixed length and end with a carriage return and linefeed. For example, here is a sample exported from the student attendance report:
EXPORTING DATA TO AN COMMA-DELIMITED FILE
The third option will export the records to a comma-delimited file. This is an ASCII text file in which each record ends with a carriage return and linefeed. The field separator is a comma. For example, if you export the attendance data, you will get these fields:
For example, here is a sample exported from the student attendance report:
EXPORTING DATA DIRECTLY TO EXCEL
The last option (Excel Direct) allows you to export the data directly to Excel. When you select this option and click on the “OK” button, AccuSQL/AccuTrack will start Excel automatically, and you will see a notification message:
After a few seconds you will see an Excel sheet with the exported data. For example, if you export the attendance data, the spreadsheet will have columns showing the visitor’s sign-in ID, last name, first name, middle name (if any), category of activities, activity, sign-in date and time, sign-out date and time, and the sign-in session length (in seconds).