Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Application: Assessing Online #38
Fran sends Satyen an export twice a year of assessments data based on the FY quarter system.
Assessing has multiple systems for their assessing data, but right now they are migrating to a newer system - and off the old COBOL frame. The last export Satyen received from Fran was from the old system, but in Jan they are switching to the new one. The export might be a different file system type - so it will change the way the export is done.
Currently, in ZGM05dev, there is an assessing folder in which there is documentation that details each SQL conversation, query and job that processes the assessing data and ports it into the databases.
The newer system in January should be a relational db system and it will be easier to just automate the export and schedule it.
For the documentation see:
The documentation is around 10-12 pages so I'm leaving that for you to delve through. The application itself just runs a search on the data, using VBScript to parse and find related matches. The VBscript in the