Skip to main content
Planview Customer Success Center

Import Customers (2017)

QUESTION:

I would like to import a series of companies that we have new in our ERP base, I would like to know if it would be possible to do an import from excel.


ANSWER:

About creating the import file for companies and contacts:

You must create a Microsoft Excel spreadsheet with the import data as follows:

 

The first row in the spreadsheet must contain the field names as they exist in the Changepoint database. For more information, see  Available fields for importing companies and Available fields for importing contacts.

To import data for lookup fields, you must use the Changepoint lookup values in the import file.

You must provide values for the mandatory fields. The System Metadata report lists all of the fields and their settings, including whether they are mandatory or not. .

The import file must be in Unicode text format.

The following table includes the fields and values that are required to import company data as a company, prospect, or lead.

 

Company type

Sales status

Required field

Company

Customer

None

Lead

Lead

SalesRepID

Unassigned lead

Lead

(none)

Prospect

Prospect

TelemarketerID

Unprocessed prospect

Unprocessed

None

Please check online help for further details