Purpose: Your Prelude product includes a powerful utility that allows users to update large numbers of Standing Data fields in Product Files or Sales and Purchase Ledgers by automatically importing selected data from an external CSV (Comma Separated Value) file. Up to 40 Data fields can be imported at any one time. See also – Input Your Opening Data.
Use this to transfer supplier standing data from another system into a company set up in your product.. data transferred from an external file is known as Source Data. Source data is imported into Target fields in your product.
The process of selecting both Source and Target is known as Mapping. Source data is mapped to target fields.
First time use – refer to Tables, Records, Forms and Fields.
Ensure any data changes have been notified to and agreed with the Buyer and/or Production Management.
Ensure all other users are off the system.
If required, set up a new company – see Create New Companies.
Processing: Add additional supplier details – Ensure existing supplier details are complete and up to date.
Create and save CSV file containing the clean data – note the directory in which this is saved. If unsure contact your existing software/system provider for instructions.
Take a backup of the company’s data – see Back Up Company Data
Print a supplier listing before importing data – see List Suppliers.
Identify and note the names of the Source Data fields.
Identify the required Prelude product Target fields – here are details of fields for Importing.
Note: Imported Data of more than the prescribed number of characters will be truncated when imported.
On the main menu click Ledgers > Purchases > CSV Import – see Suppliers CSV Import Form.
Using the drop down boxes, select source data and target fields.
Preview the data selected.
Correct any selected mappings, and preview data.
Click OK to import data.
Export a supplier listing to Excel – see List Suppliers and compare this with the supplier listing run before CSV import to ensure that any changes are correct and complete.
File both supplier listings in a backed up directory.
4 blocks of 10 possible entries.
Left column entry – first cell enter Account code cell name = ‘A’. Thereafter as above select details of cell – ‘B’ etc and in the right cell select the appropriate field.
The fields don’t have to be in order but the cell must match the selected field – this process is called ‘Mapping’
When complete find the import CSV file by clicking on the search button.
Click on the ‘Preview’ button to check – you can always clear and correct until happy.
‘Save’ saves the format of the file for future imports.
Click on ‘OK‘ to import the data and ‘Close‘ to close without saving.