meta data for this page

EXPORTING REPORT DATA

Click on the “Export Data” button to send the data that meets your filter to an Excel file. You will see a browse window. Use this to select the location where you want to save the exported file and its name. Click on “Open” to proceed. AccuSQL/AccuTrack will save the file and will then ask you whether you want to see the file:

If you click on “Yes”, AccuSQL/AccuTrack will launch MS Excel and will load the file. The exported file will have the following fields: Student’s name, sign-in ID, profile answers (P1 column is first Profile Question answer, and so on), activity (with the category between two square brackets []), the number of visits of that student to this activity, and the total time (in seconds).

EXPORTING DATA TO AN EXCEL FILE

The first option button in the Export Data box creates a Microsoft Excel worksheet file.

Note: The default extension of the exported file is ‘.XLS’.

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: 

7598 3 18109/20/2004 15:03:0009/20/2004 15:53:0022** 3000013207962 Abdullah, Ronica M Tutoring Sociology

Note: The default extension of the exported file is ‘.TXT‘.

EXPORTING DATA TO A 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: 

7598,3,181,09/20/2004 15:03:00,09/20/2004 15:53:00,2,2,"*","*",3000,"013207962","Abdullah, Ronica M","Tutoring","Sociology","",""

For example, here is a sample exported from the student attendance report: 

7598,3,181,09/20/2004 15:03:00,09/20/2004 15:53:00,2,2,"*","*",3000,"013207962","Abdullah, Ronica M","Tutoring","Sociology","",""

Note: The default extension of the exported file is ‘.TXT‘.

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).

Tip: Excel understands the date-time format of the sign-in and sign-out fields. To do calculations on these two fields, format the columns as the date type “3/4/97 1:30 PM”. This will enable you for example to subtract the sign-in time from the sign-out time. You can also format the result of the subtraction is the time type “13:30”, which will show it in hours-minutes format.

Previous - CHARTING DATA (CHART VISITS REPORT DETAILS) | Back to TABLE OF CONTENTS | Next - APPENDIX A: WHY DO MY REPORT VISITS NUMBERS LOOK DIFFERENT?