SUPN - Simple Update Part Numbers
|
Select SETUP from the menu.
Select fields to update in the same order as your spreadsheet is laid out.
PART-NO. is assumed to be the first field in the file.
If there is an existing setup, F4 clears it, otherwise it returns you to the menu. F3 saves the setup for this port. Saving it for the current port means more than 1 user can access SUPN for separate updates. You should always check the SETUP immediately before doing an update. If you did not select SO, you will be prompted for a default.
If you did not select SS, you will be prompted for a default.
If you selected any price fields, you will be given this prompt:
If you select ADD/UPDATE PART NUMBERS MANUALLY, you will be prompted for each part #, and then for each field selected in SETUP. This is best for updating or adding just a few part numbers. If you selected O.H. in SETUP, and the qty entered is different than the old O.H. (0 for a new number), a plus or minus transaction is recorded. |
At the [Paste here now] prompt, paste data copied from your spreadsheet.
This can be done in batches (paste several rows, paste more rows, etc.).
Just press [enter] after the last one.
Better yet, there is a Visual Basic Macro for Reflection that can extract the data right out of a saved file and insert it into SUPN.
As records are pasted, the only thing echoed on the screen will be the record number in the lower part of the screen. If the program encounters an error such as a bad source or the wrong number of fields (columns) in a record, it will abort. |
Saving a file for use by Visual Basic macro
|
Make sure the data in the spreadsheet is straightforward and clean:
|
Click File | Save As |
Navigate to the C:\Scheduled folder.
|
Save as file name SUPN, and save as type Text (Tab delimited) (*.txt).
|
|
There is no need to save again, because you already Saved As.
|
| Run the macro at the Paste here now prompt. See the second screen shot from the top of this page. |
|
Last Updated on ... August 22, 2007 |