InsightHireHelp Center

Importing from Salesforce

Bring customers, stores, hotels, applicants, workers, programs, shifts, texts and documents in from Salesforce CSV exports, without duplicates.

If you ran your staffing business in Salesforce, you can bring your records into Operations from CSV exports. Open Configuration → VMS setup → Salesforce import.

What you can import

Import in this order, so later records can find the ones they belong to:

  1. Customers (Salesforce Accounts)
  2. Stores
  3. Hotels
  4. Applicants
  5. Resources (your workers)
  6. Programs, with their weekly projects
  7. Projects
  8. Shifts
  9. Resource requests
  10. Text history, dashboard messages and documents

Import a file

  1. Pick one kind of record per file.
  2. Choose Choose CSV file and upload an export from a Salesforce report or Data Loader, up to 10 MB and 20,000 rows. Include the record Id column.
  3. Check the column mapping. Columns are matched to Salesforce's usual names, and you see the values from the first row.
  4. Choose Preview. Nothing is saved yet.
  5. Choose Import.

Results

Each row shows one of these:

ResultMeaning
NewA new record was created
UpdateAn existing record was updated
MatchedAn existing record was found and linked to the Salesforce Id
No changeNothing to update
SkippedThe same Id appears twice in the file
ErrorNot imported, with the reason

Turn on Show problems only to see what to fix. Past imports keeps the counts and problem rows for each run.

No duplicates

Every row's Salesforce Id is remembered. Importing the same export again updates the records instead of creating new ones. The first time, records are matched to what you already have: customers by name, stores by banner and store number, hotels by name and city, applicants by email, and workers by payroll ID, then email.

Blank cells never clear values you already have. States can be names or codes, money can be written like $17.50, and dates like 3/9/2025.

Good to know

  • Applicants become candidates and are added to the job with a matching title, with their status mapped. No emails or invites are sent.
  • Shifts dated before today are skipped, so history stays in Salesforce and only upcoming work comes over. Times are read in the store's time zone.
  • Text history is added to each person's inbox conversation. Nothing is texted. A STOP in the history opts the person out.
  • Dashboard messages become announcements to the reps they targeted.
  • Documents are saved on the person's profile.

Next