You are here: Update > Run: Upload mapped update data from Excel to Salesforce

Run: Upload mapped update data from Excel to Salesforce

After you click the Run tab, the data file opens. You can use Instant Query to retrieve data based on the conditions that you specify.

Add conditions and run Instant Query

To define the data that will be downloaded, create a condition.

  1. On the Map tab, click Condition Builder.

    The Condition Builder box opens.

  2. Select the field.

    The default is All Fields.

  3. In the Field Description box, click the field you want.
  4. In the Value Type box, choose Fixed Value.
  5. In the Comparison box, choose an operator from the list.

    The list shows only the operators that match the data type.

  6. In the Value box, type the number or text.
  7. Choose And or Or if you want to add more conditions.
  8. Click the Add icon.
  9. Repeat for any other conditions, and then click OK.

Notes:
To add multiple values, such a Number of Employees > 50 and < 500, use the left bracket on the first value and the right bracket on the last value.

You can nest up to five conditions in the query.

For more information about conditions, see Add a condition.

Next, click Instant Query.

For each record that matches the condition, Winshuttle for Salesforce downloads existing data based on the fields that are in the script.

Update the data and run the script

  1. In each column of the data file, enter the data you want to upload. Salesforce has tools that can help:
    • If a column heading includes List of Values, click List of Values on the ribbon, choose a value for that field, and then click Copy.
    • If a column heading includes Look Up, click Look Up on the ribbon, type text in the Search box to look for the values, select the value or values that you want, and then click Copy to Selected Row. The % character is a wildcard character.

    For more information, see Lists of values and Look Up.

    Important: Be sure to include the ID.

    Tips:
    If you add a value that starts with 0, such as a ZIP/Postal code, type a single quotation mark (‘) before the 0.

    If you don't want to change the existing data for a field, see Skip or clear a field.

  2. Click an empty cell.
  3. In the Start Row box, type the number for the first row of data you want to upload.
  4. In the End Row box, type the number for the last row of data you want to upload.
  5. If you are uploading large sets of data, and it is not critical data, check the Use Bulk API box for faster processing. For more information, see Use the Bulk Upload API.
  6. Click Data Validation.

    Salesforce checks the data for missing or invalid items and returns a message for each record in the Data Validation column.

  7. Click Run.

Studio for Salesforce updates Salesforce with the data from the worksheet.

Other run features

  • Data File: To create a new data file, open a different data file, or save the active data file, click Data File and click the command you want.
  • Write Headers: To add the mapped columns to a new sheet, click Write Headers.
  • ID Column: Winshuttle automatically adds the ID Column from the Data File Preview.
  • Log Column: Winshuttle automatically adds the Log Column from the Data File Preview.
  • Send email: Check the box to send email notifications automatically after the run. The email addresses for the sender and recipients are set on the Email Settings tab of the Application Options box.
  • Run Specified Range: To run the range of rows specified in the Start Row and End Row boxes, click the arrow on the Run button and click Run Specified Range.
  • Run Validated Rows: To run the rows that have already been successfully validated.
  • Run Error Rows Only: To run only the rows that returned errors during an earlier run, click the arrow on the Run button and click Run Error Rows Only.
  • Run Unprocessed Rows Only: To run rows in a data file that haven’t been run, including error rows, click the arrow on the Run button and click Run Error Rows Only. If a row has not been run and does not have an error, its cell in the Log Column is empty.
  • Run Selected Rows Only: Manually select rows in the data set and run only those rows. Validate will run on all rows, but only the selected rows will be uploaded to Salesforce.
  • Schedule: Schedule a script to run regularly or at a later time. For more information, see Schedule a run.