Load Associations From File - PEUTLA
This function allows the user to add or update Association Assignments in batch format. The utility accepts a comma-delimited file and will load the information into the PEDB.
Name of the file to be converted: Input files should be created using a spreadsheet application. The spreadsheet column order from left to right must correspond to the following field order:
Column | Field |
---|---|
A | PEID (required; PEID must have been previously defined in PEUPPE) |
B | Code (required) |
C | Value (required) |
D | Description (optional) |
Save the spreadsheet file to comma-delimited format (CSV). Use a simple text editor to verify that the comma-delimited field order matches the spreadsheet order (this is to make sure there were no hidden columns or headers in the spreadsheet before it was saved as a comma-delimited file).
Test mode only? Test mode will cause the program to skip any data base changes.
Number of header lines to skip An optional question allows the number of header lines to skip before file processing begins.
When the utility is run, new association assignments will be added to the PEDB and existing records will be updated. An error will occur if you attempt to load an association for a PEID that has not yet been defined in PEUPPE.