Importing tradeshow Lead notes into Notes & Attachments?

Question

I have a spreadsheet of Leads that have notes (conversions that took place at the tradshow that are valuable).  I would like to import those along with my Leads, but the Import Wizard does not allow me to import these notes into the Notes & Attachments.  Any suggestions on how to accomplish? Dave

Sai T · Answer

Hi Dave,

The Import Wizard can create the Lead records, but it doesn't directly support importing Notes into the Notes & Attachments related list.

A common approach is to do this in two steps:

Import the Leads and capture their Salesforce IDs.
Use Data Loader to insert the Notes/Attachments separately, using the Lead ID as the ParentId.

For Notes, you can prepare a CSV with fields such as ParentId, Title, and Body, then insert the records into the Note object with Data Loader.

If you have a large number of notes, Data Loader or an Apex-based import would be more suitable than the Import Wizard.

Importing tradeshow Lead notes into Notes & Attachments?

Data Management

관련 학습

도움 더 받기