Batch File

The Web quick view has the functionality to create a Batch file which can be used to automatically re-run an export.

The created batch file can be executed from the windows task manager. This allows you to export data at any time you feel is needed. 

This control will do the following:
Find the SQL created by the task manager in the usr_disp\_Master\Flash directory.

•     It will run the SQL and create a CSV and a XML output/extraction from our system.

•     It will also create a HTM page that can be used for easy viewing of the XML file.

•     The procedure will then copy the three output files (CSV, XML, and HTM) to a directory named FTP under the directory with the batch file.

•     The FTP are can then be accessed by other systems. 

What you need to make this all work.

•     Updated version of our client/windows system (Control Center)

•     A current build of the web system

•     Knowledge of the Microsoft Task Manager

•     Basic knowledge of batch files and system directory structure 

NOTE:

•     Using any text editor the batch file created can be adjusted by your district to copy the files to any location you desire.

•     If the word “list” is found in the report name it will be removed. For example export using the report “Student_List_by_Homeroom” will create a report file name “Student_by_Homeroom”

•     The batch file name will be the report title plus the users ID. The output files will be named with the report file name plus the appropriate extension of CSV, XML and HTM.

•     The path and drive letters in the batch file are based on the directory structure on the server. If the batch file is run from a workstation adjustments to the batch file may be needed.

•     This is a powerful tool that is adaptable to create data extractions for other software products your district may have which needs refreshed information on a regular basis.

The report “Student_List_by_Homeroom” run by user “xyz” will create the following.

•     Batch file name: Student_ by_Homeroom_by_xyz.bat

•     CSV file name: Student_by_Homeroom_by_xyz.CSV

•     XML file name: Student_by_Homeroom_by_xyz.XML

•     HTM file name: Student_by_Homeroom_by_xyz.HTM

•     SQL control file: Student_by_Homeroom_by_xyz.SQL

For those who like detail:

This is a sample of the batch file. NOTE: The double quotes are needed in the parameter string for the program u22_xml.exe.

u22_xml.exe "1|Student_by_Homeroom_by_xyz "
copy C:\SDSADMIN\STUDENT\Usr_Disp\_Master\Flash\Student_by_Homeroom_by_xyz.csv C:\SDSADMIN\STUDENT\ftp /y
copy C:\SDSADMIN\STUDENT\Usr_Disp\_Master\Flash\Student_by_Homeroom_by_xyz.xml C:\SDSADMIN\STUDENT\ftp /y
copy C:\SDSADMIN\STUDENT\Usr_Disp\_Master\Flash\Student_by_Homeroom_by_xyz.htm C:\SDSADMIN\STUDENT\ftp /y