Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Customer Import

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Tue, 21 Sep 2010 09:59



Default Menu Location

Transaction >> Importers/Exporters >> Address Book >> Customer Import

Click here for a screenshot

General Description

The Customer Import tool allows you to import customer information into Adjutant.

It is mainly used to import new customers into the database during an Adjutant implementation, but it can also be used to update existing customer info.

Filters/Fields

File Name: The file being imported into Adjutant. Click the Browse button to locate and select the file.

Map Fields: Click this button to map the column headers in the spreadsheet to the data fields in the Adjutant database.

Try To Match Existing Orgs: Check this box to turn on additional logic that looks through your existing customers in Adjutant and tries to match each record in the spreadsheet with one in Adjutant. If the import program finds a match, it will update that customer's information with the info in the spreadsheet.

Validate Custnos: Check this box if you have customer IDs (organization IDs) in your spreadsheet and you want to update your existing customer records based on ID. This is commonly used if you export your customer database to do some mass updates in Excel and then want to import that data back in to Adjutant.

Attributes: You can assign attributes to all of the customers in the file by checking any of the attributes in the list.

The list is limited to attributes in the Organization Attributes rule that have the Show in Import flag checked. Click here for an example.

Sample Import File

Customer Import Template

Import Template Help



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions