Preparing For Card Import

Back Top Previous Next

Before cardfiles (customer, user, prospect and vendor information) can be imported into Jim2, the data must be prepared first. The following is an explanation of Jim2 CardFile fields.

 

Info

Note: Prospects can also be imported via the Prospects import selection.

 

importprosp

 

Happen Business provides a spreadsheet template that can be used to import data into Jim2. Please contact support@happen.biz to obtain it.

 

Quality

It is very important to get the data right at this stage – the correct spelling, the look required, all the records verified. It is a lot easier and quicker to amend it now in a spreadsheet than later when it is in database form.

 

hmtoggle_arrow1The fields in red are mandatory in Jim2

 

Tip

When entering numbers that have a leading zero in any columns, to ensure Excel does not trim off the zeroes, set the column format to Text or add an apostrophe (') prior to the 0.

 

Further information

Import CardFiles

Preparing Stock

Import Stock

Import Contacts

Import Items

Import Non Report Groups

Import Opening Balances