Amy: Created page with "== What are UID’s and why are they important when importing? == When you create a record in SME, there is a UID (unique identifier) assigned to the record.
A customer reco..."

2012-05-16T17:32:41Z

Created page with "== What are UID’s and why are they important when importing? == When you create a record in SME, there is a UID (unique identifier) assigned to the record. A customer reco..."

New page

== What are UID’s and why are they important when importing? ==
When you create a record in SME, there is a UID (unique identifier) assigned to the record.
 A customer record has a UID
 A contact has a UID
 An inventory item has a UID
 A vendor has a UID

 If you are importing a child/site customer and you need to link the site customer to a billing customer, you need to use the billing customer's UID to link to the site customer.

 Also, all of the drop down values throughout SME have UIDs. For example, each value in the Division drop down (Image 1) below has a UID. To get the UID associated with each drop down value, you need to export the Division table out of SME (see Image 2 below)
 [[File:Import_Image1.png]]

 If you are importing into a drop down list, you need to include the UID for the drop down value.
 For example, if I am importing customer records into the customer table and need to include “division” in the import, I would need to include the DivisionUID

 [[File:CustomerImport_Image3.png]]
 This way, when the customers are imported, the division drop down is populated:

 [[File:CustomerImport_Image4.png]]

== How to export a table to get the UIDs ==
 1.Go to '''Utilities''' module > '''Utilities''' > '''Export Data''' and click '''Run It.'''
 2.In the Export Window, select the table you need to export
 3.Move the following fields from the source field side to the destination field side:''' UID''' and '''Name'''
 4.In '''Output Directory''' field, select your desktop
 5.In the '''Output Filename''', enter a name that ends in '''.csv''' (e.g. DivisionTable.csv)
 6.Click '''start'''. When completed, go to your desktop and open the file.

Before Importing - About UID - Revision history

Amy: Created page with "== What are UID’s and why are they important when importing? == When you create a record in SME, there is a UID (unique identifier) assigned to the record. A customer reco..."

Amy: Created page with "== What are UID’s and why are they important when importing? == When you create a record in SME, there is a UID (unique identifier) assigned to the record.
A customer reco..."