This article will outline how audit files from MD, LA, NC and MA are to be prepared for loading into the production system. These files often contain formatting errors which we need to address before loading into the system
Prerequisites
Access to the MDCE.exe program in the DBApps folder
A text file from containing the list of Social workers to audit
A text file from containing the Courses to be verified
Microsoft Excel
\uD83D\uDCD8 Instructions
Section 1 - Cleaning Social Worker
Open the social workers to audit file in Excel
Excel should automatically display the “Text Import Wizard”
Select “Delimited” and press [Next]
In the delimiters group
Uncheck the “Tab” checkbox
Check the “Semicolon” checkbox
Ensure the “Text Qualifier” is set to double-quotes
Click the [Finish Button]
The file should contain 11 columns
You will need to review any line where the data is incorrect, this is often easy to identify as the line will have less than or more than 11 columns. The Social Worker Audit File table below can be used to identify what should be in each column
Highlight important information in a panel like this one. To edit this panel's color or style, select one of the options in the menu.