Search the Omeda Knowledge Base

Data Loader – Available Fields

*All Character Max Lengths will be truncated if the number is exceeded.

Customer

Column NameMax Length (Characters)Description
Customer IDN/AUsed to tie a row to an existing customer.
- Overlaps with Postal Address ID. Having both is redundant.
Postal Address IDN/AUsed to tie a row to an existing customer.
- Overlaps with Customer ID. Having both is redundant. Customer ID will be used if both are mapped.
First Name100First part of the name of a customer.
- Overlaps with "First-Name-Last-Name," "Last-Name-First-Name," "Last Name, First Name."
Middle Name100Second part of the name of a customer.
Last Name 100Third part of the name of a customer.
- Overlaps with "First-Name-Last-Name," "Last-Name-First-Name," "Last Name, First Name."
First-Name Last-Name500*Full name field that breaks the name into different columns during processing.
- Space is used to break up the names. If multiple spaces exist, only the first and last pieces will be used.
- Not ideal for complex names. Use individual columns for better precision.
Last-Name First-Name500*Full name field that breaks the name into different columns during processing.
- Space is used to break up the names. If multiple spaces exist, only the first and last pieces will be used.
- Not ideal for complex names. Use individual columns for better precision.
Last Name, First Name500*Full name field that breaks the name into different columns during processing.
- Comma is used to break up the names.
- Not ideal for complex names. Use individual columns for better precision.
Salutation10Used for things such as Dr, Mr, Mrs, Ms.
Suffix10Used for things such as Senior, Sr, Junior, Jr, PhD.
Title100Used for things like "Software Developer," "Chief Executive Officer," "Chief Marketing Officer."
Gender1The gender of the customer.
External Customer ID255An alternative identifier belonging to a non-Omeda system.

* = The end result will be 100 characters being allocated for First Name and Last Name fields. Anything in the middle of the first and last batch of 200 will be lost. The 100 for each field is after the pieces have been separated. For example “Sterling Malory Archer” from a “First-Name Last-Name” field will end up as “Sterling” in the First Name and “Archer” in the Last Name. “Malory” will be dropped.

 

Postal Address

Addresses are matched against existing to see if they are similar enough to be considered the same. This matching is close to an exact match, meaning slight variants will count as new addresses.

ColumnMax Length (Characters)Description
Company Name255Name of the company that should be addressed.
Street255The street address.
Example: 1 N Dearborn St
Apt / Suite / Mailstop255Part of the street address for rooms at the given street location.
Extra Address255Used for any additional information regarding street not satisfied by the previous fields.
City100City of the address.
Region Code100Abbreviated version of the State, Province, Territory, etc. name.
Region100State, Province, Territory, etc. name.
Country Code100Abbreviated version of the Country's name.
Country 100Country's Name
Postal Code50Postal identifier. If it's a US zip-code, the program will attempt to parse out the relevant parts of it's zip+4.

 

Email Address

Addresses are matched against existing to see if they are similar enough to be considered the same. This matching is close to an exact match, meaning slight variants will count as new addresses.

ColumnMax Length (Characters)Description
Email Address320An email address tied to the customer.

 

Phone

Phones are matched against existing to see if they are similar enough to be considered the same. This matching is close to an exact match, meaning slight variants will count as new phones.

ColumnMax Length (Characters)Description
Phone32Normal phone number.
Fax32Number tied to a fax machine.
Pager32Number tied to a pager.
Mobile Number 32Number tied to a mobile phone.
Extension10Additional routing number.

 

Last Updated On June 19, 2019
Knowledge Base Feedback