Customer Import Checklist


WARNING icon
WARNING: The Customer Import Checklist has limited functionality and it is recommended that if you want to import customer information to either create new customers or update existing ones, you use the Customer Import Tool.

Please email Development if you would like more information about the import tool.


WARNING icon
Importing Customers is an Advanced User feature.
Please ensure you understand the options on the Import Screen, understand the process, read all the instructions and backup your data before use.

Importing Customers

  1. Open [ System Data | Company | Company Classes ] and create a temporary company class.
  2. Close all screens.
  3. Open a Customer screen (show me how).
  4. Display the drop-down 'Other Actions' menu either by pressing F9 or clicking the down arrow immediately to the right of the green circle with a white cross icon at the top of the button bar.
  5. Select "Import Data from Mailing List".
  6. Press Ctrl+N or click the New item icon is the button bar's NEW button .


ScrCustomerImport.jpg

  1. Enter a setup name.
  2. Enter the start line number for the imported data.
  3. Select the CSV filename.
  4. Untick the "Business Import" check box.
    Note: if you have multiple contacts listed against a company then leave this ticked.
  5. Make sure the "Supplier" checkbox (in the top left) is not ticked.
  6. Enter the column numbers for the fields required.
  7. Check the capitalization is as required (U=upper case, L=lower case, M=mixed, A=as is). Where the field does not have an associated case select drop down it will be imported 'as-is'.
  8. Apply the temporary company class.
  9. Press Ctrl+S or click the disk icon is the button bar's SAVE button to save the import details.
  10. Click on the import button button.
  11. In the Warning popup click on 'OK'.
  12. Click on 'Yes' to begin the import in the next warning message.
  13. In the Import Data popup click on 'Yes'.
  14. In the Process records in Batches click as appropriate, if 'Yes' enter the number per batch.
  15. In the next Confirm popup select as appropriate.
  16. Check the information popup, then click on 'Ok'.
    Note: if there are any errors there will be a message detailing them.
  17. Check that the records have been imported as required.

Note: you may get different messages depending on the file that you are importing.

Importing Suppliers


WARNING icon
Importing Suppliers is an Advanced User feature.
Please ensure you understand the process, read all the instructions and backup your data before use.

Repeat the process detailed above but check both the "Business import" and "Suppliers" check boxes.

Applying a new company class to the imported records

  1. Open a Customer screen (show me how).
  2. In the List screen's grid find and green-select all the records you wish to block change.
  3. Click on the The 'Block Change Selected Items...' button button.
  4. The Update Selected Items Dialog will be displayed.
  5. Change the traffic light from red Red Traffic Light Filter to green Green Traffic Light Filter adjacent to the Company Class option.
  6. Select the new customer classification from the Company Class drop down.
  7. Click on 'OK'.
  8. In the Confirm popup click on Yes to Update all selected company records....

Did you find this article helpful?