function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
lovecrmlovecrm 

How to extract data from sfdc using commandline on weekly basis to a particular folder.

Hi All,

 

 

Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.

 

Can anyone of you know how to approach with this.

 

Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.

 

We are having Autosys Job scheduling tool.

 

So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.

 

Any information/suggestion to approach would be appreciated.

 

Thankyou in advance.

 

carol.

kxa422kxa422

Hello,

 

You can use a scheduled batch to extract and send to a FTP server.

The batch should use the DataLoader in command line to extract the information from SalesForce to a folder in CSV files

the second part of the batch could transfer those files by FTP. 

lovecrmlovecrm

Thankyou...

 

Here after extract ,the data need to be mapped as there are from 5 different objects.

 

I get data from Opp's, Visit, VisitOpp's and these are having relations which to be mapped and then from the User object need to get the names for createdBy and ModifiedBy fields.

 

can we do all these in the second part of the batch?

 

If so, can you please detail me how to do the scheduled batch.

 

Or can I find any information how to work with batch anywhere?

 

Thankyou,

carol.

kxa422kxa422

If your datamapping tools accept command line, it could be part 2 of the batch file.

 

A batch file is a .BAT file.

 

Ift could be something like that

 

@echo off

PUSHD "C:\Program Files\salesforce.com\Apex Data Loader 15.0\bin\"
CALL process.bat ..\MyConfFolder MyBeanToExecute

 

Call mapping tool with command line

Call FTP script to export your result in the FTP server