Configuring Import/Export Mapping

The mapping of data between ClientSpace and Salesforce is defined using Import Map Headers.

Two Import Maps must be created:

Export Map Header
Import Map Detail

Export Map Header

Field Description
Source File SFORCE_export_mapping*.csv
Dataform Import_Organization
Custom Import Class not yet implemented
Import Type Salesforce Export
Execution Pipeline ignored
Import Action ignored
Execute Business Logic ignored
Special Import checked

Import Map Header

Use Import Map Headers to map data between ClientSpace and Salesforce.

To create the Import Map Header:

1. Go to System Admin > Advanced > Configure Import.
The Import Map Header Search page is displayed.
2. Click Add.
The Import Map Header Detail form is displayed.

3. Complete the form fields:
Field Description
Source File SFORCE_import_mapping*.csv
Dataform Import_Organization
Custom Import Class not yet implemented
Import Type Salesforce Import
Execution Pipeline ignored
Import Action ignored
Execute Business Logic ignored
Special Import selected
4. Click Save.

The next step is to add fields by configuring the import map detail.

To configure the Import Map Detail:

1. Open the newly created Import Map Header.

The Import Map Header Detail form is displayed.

2. In Action Items, click Fields.

The Import Map Search list is displayed, showing the existing fields.

3. To add a field, click Add.

The Import Map Detail form is displayed.

4. Complete the form:
Field Description
Source Field Ignored. Enter text that describes the source of this detail (OrgName or sfAcctName) for clarification.
Field and Project Type

This is where the data from Salesforce will be stored. Select any non-parent field type on any single-form.

When mapping Organization, select Import_Organization project type.
When mapping Contact, select Import_Contact project type.
API Path

This is where the data from Salesforce will be retrieved. The format of this field is SF_ObjectType/FieldName (e.g., Account/BillingStreet).

The only valid SF_ObjectType values are Opportunity, Account, Contact, Lead, Event, or Task. Other values are ignored.
Can only contain an SF_ObjectType and up to two subfields, as in Account/RecordType/Name.
Cannot contain special characters (other than ‘/’) and no spaces.
Salesforce fields that are Calculated are not exported by ClientSpace because Salesforce does not allow them to be directly updated.

For details on locating the API Path, see Finding the API Path in Salesforce.

Data Type
Text: Most fields should be mapped as Text (even if the source or destination fields are integers or dates/etc.)
Lookup: Not yet implemented (use Text).
Foreign Key
Currently, this is only implemented for Imports and locating CS Users.
It accepts a Salesforce User ID and locates that User in ClientSpace by Email. A call is made to Salesforce using the SF User ID. The SF User Email is located and used to find a matching Email in ClientSpace.
Default Value
A Default Value can be set in this field.
If a Salesforce field does not exist, the API Path must be set to Object/UseDefault. This default value is set in the appropriate ClientSpace field. For Imports the Object is not important, the Default Value is set in the CS field.
Active, Required Value, and Required Column
Only Active records are used.
Required Value and Required Column settings are ignored.
Minimum Required Field
5. Click Save.

To configure the Import Map Detail for fields from multiforms:

Note:  Before you complete this procedure, you must contact Professional Services about setting up the Salesforce API to use the csworkspacedataproc additional parameter with a custom stored procedure. You will use the variables from the custom stored procedure to define the fields to populate in Salesforce.

  1. Go to System Admin > Advanced > Configure Import.

    The system displays the Import Map Header Search page.

  2. Click (Jump) for the row that contains the Salesforce mapping source file.

    The system displays the Import Map Header Detail page.

  3. In Action Items, click Fields.

    The system displays the Import Map Search, showing the existing fields.

  4. Click Add to create a new field map.

  5. Complete the following information in the form:

    Field Description
    File Column Enter the variable from the stored procedure for the field that you are mapping to Salesforce.
    Dataform

    This is field must be blank so that the system can pull data by using the variable in the saved procedure that is associated with the Salesforce API csworkspacedataproc additional parameter.

    Data Type

    Select a Data Type:

    Text: Most fields should be mapped as Text (even if the source or destination fields are integers or dates/etc.)
    Lookup: Not yet implemented (use Text).
    Foreign Key
    Currently, this is only implemented for Imports and locating CS Users.
    It accepts a Salesforce User ID and locates that User in ClientSpace by Email. A call is made to Salesforce using the SF User ID. The SF User Email is located and used to find a matching Email in ClientSpace.
    Default Value
    A Default Value can be set in this field.
    If a Salesforce field does not exist, the API Path must be set to Object/UseDefault. This default value is set in the appropriate ClientSpace field. For Imports the Object is not important, the Default Value is set in the CS field.
    Active, Required Value, and Required Column
    Only Active records are used.
    Required Value and Required Column settings are ignored.
    Minimum Required Field
    API Path

    This is where the data from Salesforce will be retrieved. The format of this field is SF_ObjectType/FieldName (e.g., Account/BillingStreet).

    The only valid SF_ObjectType values are Opportunity, Account, Contact, Lead, Event, or Task. Other values are ignored.
    Can only contain an SF_ObjectType and up to two subfields, as in Account/RecordType/Name.
    Cannot contain special characters (other than ‘/’) and no spaces.
    Salesforce fields that are Calculated are not exported by ClientSpace because Salesforce does not allow them to be directly updated.

    For details on locating the API Path, see Finding the API Path in Salesforce.

  6. Click Save

Related Topics: