Load file attachments in bulk

The Data Loader takes care of bulk data loading to set up current and history data for your team members. To load existing attachments to team members' employment records in bulk, you can use the Salesforce Data Loader, freely available to existing Salesforce users.

This section provides need-to-know information to install and use the Salesforce Data Loader for bulk loading attachments to Sage People employment records.

Attachments are added to the Notes & Attachments related list on the team member's employment record.

There are 3 steps:

  1. Install the Salesforce Data Loader.

  2. Generate a list of attachments as a CSV file. Each record in the list must contain:

    • An identifier for the team member's employment record. This is where each attachment is to be held. Use the unique Employment Record Id.

    • The name of the file to be attached.

    • The path to the attachment to tell the Apex Data Loader where each file can be found.

  3. Run the Salesforce Apex Data Loader to insert the attachments in your Sage People system.

Salesforce help content provides more information about the Salesforce Data Loader.