Download SDSStudentHelp

Web School Office . 301
Home > Web School Office > Reports > Quick Reports (View/Design/Display/Export) > Create Quick View for SQL Batch File
Create Quick View for SQL Batch File
The Quick View has been enhanced 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 (Web Control Center/V8.5). This allows you to export
data at any time you feel is needed.
This new control will do the following:
1. Find the SQL created by the Task Manager in the usr_disp\_Master\Flash directory.
2. It will run the SQL and create a CSV and a XML output/extraction from the system.
3. It will also create a HTM page that can be used for easy viewing of the XML file.
4. 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.
5. The FTP can then be accessed by other systems.
What you need to do to make this all work:
1. Make sure your Web Control Center is updated/windows system (v8.5).
2. A current build of Web School Office (i.e. after 3/11/2008).
3. Knowledge of the Microsoft Task Manager.
4. Basic knowledge of batch files and system directory structure.
Note: Using any text editor the batch file created can be adjusted by the district to copy the files to any location they 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 batch file will be created in the directory the School Office v8.5/Web Control
Center resides in. To edit the batch file, right click on it and choose Edit from the popup menu.
●
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 new tool that is adaptable to create data extractions for other software products you may have needs to
refresh 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 details:
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
See also
Create Quick Report for Photographer
SDSStudentHelp