Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Creating a Salesforce Insert Operation

This page described how to create a Salesforce Insert operation using the Jitterbit Connect Salesforce Insert Wizard.

The wizard follows these steps:

Table of Contents
maxLevel2
minLevel2
indent20px
excludeCreating a Salesforce.*Operation|^Start.*

Multiexcerpt include
MultiExcerptNamesw-version
PageWithExcerptSalesforce Org Wizard

Start the Wizard

Multiexcerpt include
MultiExcerptNamesw-jitterbit-connect-dialog
PageWithExcerptSalesforce Org Wizard

  • To start the wizard, click the  Salesforce Insert  button in the Jitterbit Connect Wizard menu, which opens the wizard.

Salesforce Login

Multiexcerpt include
MultiExcerptNamesf-login
PageWithExcerptSalesforce Query Wizard

Select the Salesforce Object

Multiexcerpt include
MultiExcerptNameselect-salesforce-object
PageWithExcerptSalesforce Query Wizard

Define the Source

Multiexcerpt include
MultiExcerptNamedefine-the-source
PageWithExcerptSalesforce Upsert Wizard

Create a Schedule and Set Options

Multiexcerpt include
MultiExcerptNamesw-create-schedule
PageWithExcerptSalesforce Query Wizard

  • Click the Response Option checkbox if you need to interact with the response from Salesforce and want to map information directly from that response:

  • When finished, click Next to move to the Summary screen.

Summary Screen

On the Summary, you can edit the Name given to the wizard and specify whether to use Jitterbit’s Automapper to map the data:


  • Click Map & Finish to complete the wizard.
  • If you need to create or approve a transformation mapping, you will be taken to that screen.
  • Otherwise, the design items for your insert will be created and become visible in the Project Items panel on the left side of the screen and you will be taken to the operation's Salesforce Insert page.

Transformation Mapping

If you chose Select an existing File Format (or created a new one) in the Target screen of the wizard, the transformation mapping appears in your work area.

Multiexcerpt include
MultiExcerptNametransformation-mapping
PageWithExcerptSalesforce Query Wizard

Completed Salesforce Insert

  • Once completed, you will be taken to the summary screen for the new Salesforce Insert.
  • You can return to this summary page by finding its operation name under Jitterbit Connect in the Project Items panel.
  • You can modify any of the design items in your project such as Salesforce Login, Read data from, Mappings, Operation, and Run on Schedule by clicking their adjacent Edit button.
  • The Run Insert, Test Insert, Result History, and Delete button functions are described below in Deploy the Project and Run the Operation
  • Advanced Options include operation options such as chunking and field truncation. They are covered below in Advanced Options.

Anchor
sf-insert-advanced-options
sf-insert-advanced-options
Advanced Options

These advanced options are available for a Salesforce Insert:

File Options

  • Read as UTF-8: Select to read the source file as UTF-8 character encoding.
  • Date Options: Displays a dialog to set the date options for the source. See the Salesforce Advanced page.
  • Source file has a header: Select to indicate if there is a header and ignore it as not data.
  • Start at data row: Gives the row number of the first row of the source file to be considered as data.

Operation Options

  • Retry Policy: Displays a dialog to set the retry policies. See the Salesforce Advanced page.
  • Chunking settings: Displays a dialog to set the chunking settings. By default, chunking is enabled with a chunk size of 200 and a maximum number of 2 threads. See the Salesforce Advanced page.
  • Insert null values: If selected, allows the insertion of null values into a record.
  • Compress: By default, compression is turned on.
  • Allow field truncation: If selected, if a value for certain Salesforce datatypes is too large, the value is truncated; otherwise, too large values raise an error instead.
  • All or none: If selected, any failed records in a call cause all changes for the call to be rolled back.
  • Duplicate Records Rules:
    • Allow save: If selected, allows the saving of duplicate records, bypassing any Salesforce alerts.
    • Include record details: If selected, returns fields and values for records detected as duplicates; otherwise, only record IDs are returned.
    • Run as current user: If selected, the sharing rules for the current user are enforced.

Additional operation options for writing success and failure records are described on the Salesforce Advanced page.

Anchor
sf-insert-deploy-run
sf-insert-deploy-run
Deploy the Project and Run the Operation

Multiexcerpt include
MultiExcerptNamedeploy-project
PageWithExcerptSalesforce Query Wizard

Panel
borderColor#65379B
titleColor#FFFFFF
titleBGColor#65379B
titleOn This Page
Table of Content Zone

Table of Contents
maxLevel3
minLevel2
indent20px

Panel
borderColor#FF7C4C
titleColor#FFFFFF
titleBGColor#FF7C4C
titleRelated Articles
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel = "salesforce" and space = "DOC"
Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel in ("sf-connect-overview","template-overview") and space = "DOC"

HideElements
metastrue

Last updated: 

Lastmodifieddate