Child pages
  • USAS-R Import Process
Skip to end of metadata
Go to start of metadata

Goals

The primary goal of the USAS-R import process is to import 100% of all relevant data from the Classic USAS System on OpenVMS.  Early milestone releases do not yet achieve this goal.  However, significant progress has been made in importing most data.  See the specific Milestones page for details on current limitations.

Export from Classic USAS

The export process on the OpenVMS system is based on the "SSWAT Exports".  The SSWAT exports were the most comprehensive extracts produced by USAS and have been enhanced to provide additional information for USAS-R.  We recommend that exports intended for importing into USAS-R be placed in a separate directory.  The exports for USAS-R vary slightly from normal SSWAT exports and will typically contain all transactions for the district, rather than the current fiscal year.

To prepare, create a directory on the OpenVMS server to contain the USAS-R exports, for example ( DKA0:[USASR-EXPORTS] ).  Exports for multiple districts may be placed in the same location.  To execute the export, use the following commands:

The above example uses SETUPENV to define the district's OECN$DTA directory.  ITC's may use any customary method for defining OECN$DTA.  See the comments and documentation for SSWAT_USAS_EXPORTS.COM for additional options if you wish to export selected fiscal years.  If you select less than all data, you should be sure to at least include the current fiscal year.

 

Importing Data into USAS-R Application

The USAS-R web application provides a UI for initiating and monitoring the import process.  After executing the application (using instructions from the Milestone release you are using), login and navigate to the Admin->Import page.  The following page will be displayed:


  • Enter the VMS Host name and VMS Username/password which has access to the files extracted.
  • Remote path is the VMS Directory name where the files are located (e.g. DKA0:[USASR-EXPORTS])
  • IRN is the IRN of the school district.  This must match the IRN in the extract file names.

  • Anonymize Data: Check this box if you wish to have Vendor, Organization data randomized.  Use this option if you intend to use the data for demonstration.

Clicking the Start button will initiate the download and import process.  The application contains an embedded FTP client to perform the download step.  Therefore, the application must be able to access the servers FTP port (inside the site's firewall) and the OpenVMS user must be authorized for FTP.

The import page will monitor the status of the import process and tell you when it has completed.  You should also watch the command-line window for additional messages and errors.

When the the process is completed, timings for each import step will be displayed on the page.  All information displayed in the page will be saved in the working directory named: importResults-datetime.txt.  You should inspect this file for additional error messages not included on the monitor page.   If you report a problem to the SSDT, please attached the associated importResults file to the JIRA issue.  The file also contains additional technical and environment information which may assist in diagnosing problems.

 

  • No labels