Import/adjust stock from file

 

Import stock from an external file to the Board library

 

This option is for importing stock to the board library via the Stock control options.

 

If using this import for the first time it is important to look at the System parameters: Stock control tab (Main screen - System parameters) because there are several settings that control how the import or adjustment works including a setting for the type of file format for import.

 

At the Main screen:-

 

 Select: Stock - Import / adjust stock from file

 

Program displays a dialog with a list of files to import

 

 

 Select a file  (only one file can be selected at a time)

 Select OK to begin import

 

Program prompts: Add new Stock?

 

The import file may contain both updates to existing stock and new stock

 

Y - add new stock

N - do not add new stock

 

Program prompts: Update Existing stock?

 

Y - update existing stock

N - do not update existing stock

 

The program then updates the board library from the file. If any errors are detected these are reported. All valid board codes and new board items are updated.

 

When the update is complete the program reports:-

 

Finished

 

 Select OK to return to the main menu

 

 

Notes

 

- Files must be located in the directory set by the System parameter: Path for import data. The location of the SQL database is set via System parameters on the 'Stock control' tab.

 

- The option at the Main screen 'Import boards' is different to this option and is used for importing boards to a new board list and NOT importing directly to the board library

 

- The grain and board parameters specified for the board are taken from the incoming file.

 

- Material density is imported only for new materials.

 

 

See also