Import - Define ‘Customer’ values

Introduction

Accounting Software import map customers

This screen allows you to map the customers found in the import file with the system defined customers.

The screen is comprised of:

  • A Mapping Tools widget on the left of the screen that provides tools to help you complete the mapping process more quickly.
  • The Mapping Table taking up the remainder of the screen. This table contains all the unique customer values found in your import file (so a value appearing twice in your import file will only appear once in this table)

Mapping Table

The ‘Mapping Table’ is made up of three columns:

  1. Map - A check box allowing you to ignore a value so you don’t have to map that value to continue.
  2. Value - The value found in the file that you are importing
  3. Customer - The system Customer record that you have mapped to the given ‘Value’

To map a customer to a value you can either:

  • Select an existing customer record by starting to type its name in the ‘Customer’ text field and then selecting it from the filtered list of customers that will appear.
  • Press the ‘New …’ button to bring up the Quick Add Customer dialogue to allow you to create a new customer to map to the value.

Mapping Tools

De-select All / Select All

Clicking this button will un-check/check all the check boxes of the ‘Mapping Table’ for you.

Set All Missing To ‘X’

This feature allows you in one go to map all the values that currently are missing mapping values to a chosen default value.

Clicking on the “Set All Missing To ‘X’” button will bring up the ‘Select default’ pop-up:

Accounting Software import map select default

Start to type the name of the default value in the ‘Value’ text field and then selecting it from the system list of valid values that will appear.

Once you have selected the desired default value click the ‘Done’ button. The chosen default value will now be populated in any mapping field that previously had no mapping.

Clear All

Clicking the ‘Clear All’ button will clear out any mappings currently made.

Strip Numbers From Values

Clicking this toggle button will remove the all characters after the first number from the values found in your import file. This is designed for situations where you have an otherwise unique value that is repeated in the Mapping Table because it is post-fixed with a date/time string.

So for example if you had the three values:

  1. “Petrol 01/05/2010”
  2. “Petrol 07/05/2010”
  3. “Petrol 14/05/2010”

After clicking the ‘Strip Numbers From Values’ toggle button you would just be left with the single value of:

  1. “Petrol”

You can click on the button again to revert back to the previous ‘un-stripped’ values.

Tip: This feature is sometimes useful for a number of values but not all of the values in your import file. However you can save time mapping by temporarily enabling this feature, mapping the values that have been correctly consolidated, and then disabling the feature again. Even after you have disabled the feature the mappings you made when the feature was enabled will still remain so saving you the effort of having to individually map those values.