AgileApps Support Wiki Pre Release

Mapping Profile

From AgileApps Support Wiki
Revision as of 00:36, 5 March 2011 by imported>Aeric (Text replace - 'Setup > ' to 'Settings > ')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

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.
Considerations
  • Multiple Mapping Profiles can be created for the same object, one for each CSV file that uses a different arrangement.
  • An input file is required by the Data Import wizard. If creating a mapping for later use, use a dummy file with test data, or create a simple place-holder with contents like this: a,b,c,d,e,... (Create as many columns as you'll need for a complete mapping.)

Thumbsup.gif

Tip: One way to make map-creation easier is to put field names into the columns of the dummy file. For example: acct name, acct number, acct type, industry, ... That data is displayed when you're mapping fields, which makes it easier to select the intended field.