function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Harshal DhageHarshal Dhage 

Update records which are exported from Salesforce

Hi All,

I want to update the records which are exported from the salesforce. Can you please let me know how can I achieve this?
ShivaKrishna(Freelancer)ShivaKrishna(Freelancer)
Hi Harshal,
  • Use data loader and export the records which would be in .csv format file.
  • update the extracted file as you require
  • map the id of .csv file with object id and click on update
  • click on update
I suggest you to refer this video if you are new to dataloader https://www.youtube.com/watch?v=D9MZ-Yy7BA4

let me know if it helps you :)
nagasfdc1@gmail.com
Harshal DhageHarshal Dhage
@Nagasudhakar P (https://developer.salesforce.com/forums/ForumsProfile?communityId=09aF00000004HMG&userId=005F00000043ezS&showHeader=false) : I want to schedule the data export activity using dataloader.io. and I want to export the csv to FTP location. So the records which are exported should not be exported again by salesforce. To make this sure I want to update records with some field value to identify which records are exported and which are not. Please guide me how to implement this.
 
venkat-Dvenkat-D
One way can be..create a batch class that updates records with "Ready for Export" flag with a certain criteria like created today or last modified today with whatever you want. Then run your export with criteria as ready for export. Then your batch class next day should mark yesterday's records as exported (ready for export = false) and update new records with ready for export. Just to make sure your records match in ftp and sfdc , you should have some reconciliation process.
ShivaKrishna(Freelancer)ShivaKrishna(Freelancer)
Hi Harshal,
  • hit https://dataloader.io/free-subscription
  • click on "Login with Salesforce" and login with your personal org details
  • click on allow for the permsion
  • then you can see the videos listed .. watch video for import and export that gives you better idea on how to schedule
  • If that is not fulfilling your requirement and complexity then better go for CLI schedule for apex dataloader

Let me know, if it helps you :)
nagasfdc1@gmail.com