Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
cl0s3r I have a spreadsheet with 15k rows that I would like to bounce the data against Salesforce to get the Salesforce ID, what is the best way to accomplish this? I know I can break it down into 1k rows and feed it into force.com explorer but I am looking for an easier to manage process. How is everyone else accomplishing this?
No one else has had this issue?
Assuming you are using excel, you could
1. Export the complete data set from the object that you need to match on, include the Id field and at least the fields you will need to match against.
then
2 Use the VLOOKUP funtion in excel to match your records and assign the Salesforce Id.
If your dataset is very large you could also create a custom object with a lookup to the object that you are matching against and use the Import Wizard