How to run the badprimary.r 3.1 pre migration step in RecTrac 10.3
Default Subject
Question
We'll be migrating to 3.1 soon. One of the checklist items is to run badprimary.r. Can you tell us what it does and how to run it?
Answer
Of course! Badprimary.r finds potential problem records in a household where the first and second family member records might not match the primary and secondary records on the main household record. Failure to fix these records can result in duplicate family member records getting created during the migration process to RecTrac 3.1. Here's how to run it.
To Run Badprimary.r
-
Download the badprimary.r program from our sFTP site. Use the link below to get the current login credentials if you don't have them.
- If you're running progress 10.2 in RecTrac 10.3, then on theS FTP site go to /File Updates And Drivers/RecTrac/3.1/Upgrade/Archived.
- If you're running progress 11.3 in RecTrac 10.3, then on the FTP site go to /File Updates And Drivers/RecTrac/3.1/Upgrade/Archived/BadPrimary_OE11.
- Download the appropriate file and save it a local directory. Then exit the FTP site.
- Log into RecTrac 10.3 with a user ID that has access to the RecTrac Quick Fix Processor (Utilities System).
- From the quick fix processor browse out to the badprimary.r program that you downloaded above and select Process.
- To retrieve the list of potential bad records browse to Utilities System RecTrac File Explore.
- Expand All Files in RecTrac Database and click on preupgrade. On the right hand side, select badprimary.csv and choose select.