Accessed from the File menu, this screen allows a product file to be imported from another application. The data should be as coma separated values - a CSV file. If you do not have them in this format, it may be possible to convert from other formats by reading them with a spread sheet program and then saving as a CSV file.
To import a file select File|Import.
After selecting the file to be imported using the conventional File Open Dialog, the file is automatically read in. A clear all button will delete the existing contents before loading the new information if required. The user then has to assign fields for the bar code, product description and price by clicking on them with a mouse as instructed. Other fields are not used. The information is then loaded automatically into the Import database table when the OK button is clicked.
Products in the file are not automatically appended to the Product database table. Instead, when an unknown product is scanned, the Import table is searched for a match. If found, the product description and price information are entered automatically into the 'New Product Screen'. If this is done during a sale, the operator can, at least, just keep pressing the Enter key until the sale is accepted. The department and stock information will then need to be entered later in the 'Stock |Starting stock' screen.
Further CSV files can be appended to the Import table by re-activating the Import menu selection and selecting a different file.

The above is a small sample, showing the correct format.
Files without a price can also be imported. Simply click on the OK button when asked to click on the price. The price will then default to zero.

Home

Special offer