AgileApps Support Wiki Pre Release

Mapping Profile

From AgileApps Support Wiki
Revision as of 20:13, 26 July 2011 by imported>Aeric

A mapping profile is used in Data Import. It tracks how to match CSV data fields with the record structure defined in the platform. It also specifies whether incoming data is appended or merged, and determines how a merge occurs.

Multiple Mapping Profiles can be created for the same object, one for each CSV file that uses a different arrangement.

Creating a Mapping Profile
  1. Click Settings > Data Management > Import Data
  2. Select the object to import into
  3. Select the file containing CSV Data (Required. See note below)
  4. Click [Next]
  5. Specify the Map Columns
  6. Click [Next]
  7. Specify merge parameters using Set Attributes
  8. Save the Mapping Profile.

Thumbsup.gif

Tip: An input file is required by the Data Import wizard, because the data fields are displayed when you create the mapping profile.

One way to make map-creation easier is to create a dummy file with a single row of data, and put names or recognizable test-data in that row. For example: acct name, acct number, acct type, industry, .... (Create as many columns as you'll need for a complete mapping.)

That data is displayed when you're mapping fields, which makes it easier to select the intended field. Then use that map when importing the real data.