| Purpose & Benefits |
|---|
| This function allows you to change the TAS Product Code of one or more TAS Product/Service records at the same time. It updates the codes both in the main TAS database (as assigned by using TAS function 511) and in the Bill of Materials database, together with all related history. The change can be done interactively one Product at a time or in “bulk” from a simple pre-prepared ASCII CSV file. To avoid analysis reporting problems in TAS, the change is also applied retrospectively to the chosen product’s history throughout the TAS database. |
Important
It is strongly recommended that a backup of the TAS data is taken immediately before running programs involving “heavy-duty” database changes such as this. You are asked to confirm before proceeding further. The process of importing data requires the exclusive use of the TAS data files to ensure good performance. All other users are therefore required to log out of TAS during the import process.
The main form is displayed, initially with an empty grid:
To add a single product to the grid for its Code change, click on Add Single Product.
The ‘Select Product‘ dialogue appears:
Existing Product
Select/enter an existing TAS product using the Navigation function keys (or by entering the code). The system displays its description.
New Product
Select/enter the New Product Code. Click the OK button to insert the change into the Product List grid:
Note that the system checks that the new Product Code does not exist for another product on the system. If it does, a warning appears in the Comment column and the change is not processed. Similarly, it provides warnings if a New Code is duplicated in the grid.
If you make an error, you can remove the offending row by pressing Ctrl+Del.
To add a list of products “in bulk” to the grid from an ASCII CSV file, click on Add List From File ; this brings up the standard CSV file selection dialogue with the starting folder being the current TAS data directory. Highlight your selection and click the Open button to continue.
The CSV file is pre-processed into the grid with old and new TAS Product codes being validated; any errors or problem areas are reported in the grid, which you can correct by highlighting the row and clicking Edit Row to edit. To troubleshoot any errors, you can use the Troubleshooting ASCII CSV File Data Errors section in the Appendices.
When satisfied with the grid’s Product contents click Start Processing Product(s). Due to the many file updates, the program needs to “lock” the TAS system so that that users cannot then log into TAS whilst the import is in progress. When the system is successfully locked, simply click the Yes button to continue or No to cancel.
The main part of the processing starts, with progress being reported on the original form – all other buttons are now disabled. Each row in the grid is processed. If there are any problems in a row it is skipped.
An ASCII text CSV Log file is created listing all changes that have taken place during this process (Product_Code_Change_YY-MM-DD_NN.LOG). It records each successful change or error, including those items skipped, with: Product Code and Note – “Successful” or, if an error/skip is involved, an appropriate error message.
The import file is renamed to help prevent processing twice by mistake and the LOG file is assigned a corresponding name. When processing is complete a message to that effect is displayed in the top progress bar and the Close button becomes active
Click the Close button on the Product Code Change form and the TAS users are ‘unlocked’ following the same procedure in reverse as the locking method mentioned above.
