Importing Records

Example

Example: In order for address information to be imported for both a contact and an account, the address information must be contained in separate columns that can be mapped to either the contact or the account. If the contact and account information is the same, then copy and paste each address column and give them distinct names so that they can be mapped separately in step 9.

• If you want to update an existing import template, click the Import Template drop-down arrow, select the template you want to update, and then click Update Current Template.
  The existing template will be saved with any import setting changes.
• If you want to create a new import template, click Save As Import Template, in the Description box, type a brief description of the import template, and then click Save.
  The new import template description is added to the Import Template list on the Import Leads dialog box.

On the Define Delimiter view, read the text at the top of the page, follow any recommendations, and review the records preview.

• If the preview looks correct, then click Next to continue the import.
• If necessary, change the options until the records preview looks correct.
  1. If you need to change the delimiter, select one of the following options:
     • Tab
     • Semicolon
     • Comma
     • Space
     • Other
  2. If you selected Other, you must specify the delimiter used to separate fields in the list. Type the delimiter character in the Other box.
  3. From the Text Qualifier list, click the drop-down arrow and select a qualifier from the list.
     A text qualifier identifies text that should be imported exactly as it appears.
  4. If the list contains field names, select the First Row Contains Field Names check box to display the field names in the Preview area.
     If there are extended characters in the imported file that do not correctly display in the Preview area, you must resave the import file and explicitly define the encoding type as UTF-8, Unicode, or ANSI. After you resave the file, click the Back button to return to the Select a File step and reselect the updated file before continuing the import.
  5. Click Next

1. Define the matching criteria to be used for identifying duplicate records in Infor CRM. Example
   The options available depend on the type of record being imported.

   Example: If importing contacts, matching Contacts based on Email will flag any records with the same email address as duplicate records.

   • Click the drop-down arrow and select from the list for each available match criteria.
     

   It is important to select match criteria that is most likely to be unique to a record. For example, an Email address is more likely to be unique to a record than Last Name, since many people may share a common last name.

2. Click the Default OwnerFind button to select the person or team who will own the imported records if an owner cannot be determined.
   The logged in user will be assigned as the account manager.

   The Default Owner may not be available for all imports.

3. Contact imports only. Select the Use Contact Name in place of empty Account Names check box to use the contact's first and last name to create an account if an account name is missing.
   If this option is cleared and an imported record does not have an account name, the contact will not be imported.

   Do not select this option if you intend to map an import field to the Infor CRM field "Contact_0_First Middle Last".

4. Set ad hoc group options.
   This group is automatically marked as a Favorite. Favorites display as tabs in alphabetical order up to the limit allowed by your administrator. Use the Groups list to manage your Favorites.

   • To add the imported records to a new group, select Create a new ad hoc group. Note the name of the group to be created.
     The new ad hoc group name must be unique.
   • To add the imported records to an existing group, select Add to existing ad hoc group, and then select a group from the list.

5. Click Next.

Map Fields

1. Click View Unmapped Fields to see only the fields that are not mapped.
   • For each field listed in the Import Field column, click the drop-down arrow in the Infor CRM Field column and select the Infor CRM field that you want to map to the import field.
     As fields are mapped, they will be removed from the View Unmapped Fields list and the count will decrease.

     If you are importing contacts: You must map the Infor CRM First Name and Last Name fields before you can continue with the import. If you map an import field to the Infor CRM field "Contact_0_First Middle Last, you must click the Back button and make sure the "Use Contact Name in place of empty Account Names" option is cleared before you can continue with the import.

2. Click View Mapped Fields to see only fields that are mapped.
   • Review the mapped fields to verify that all fields are mapped correctly.

     When importing address information, you must verify that the address fields are mapped to the appropriate entity address fields. For example, when importing contacts (and accounts), Address.City should be mapped for the imported contacts and imported account address information should be mapped to Account.Address.City. When importing product information, the product price must be mapped to the Infor CRM ProductProgram.Price field and, if applicable, the product program must be mapped to the Infor CRMProductProgram.Program field. The Actual ID maps to the SKU field on the Product Detail view.

3. (Optional) Click View All Fields to review all of the fields in the import file and review the mappings to Infor CRM fields.

• If you want to update an existing import template, click the Import Template drop-down arrow, select the template you want to update, and then click Update Current Template.
  The existing template will be saved with any import setting changes.
• If you want to create a new import template, click Save As Import Template, in the Description box, type a brief description of the import template, and then click Save.
  The new import template description is added to the Import Template list on the Import Leads dialog box.