The FuseIT.G4S.DataExportConsole.exe
application can be executed directly from the command prompt (via cmd window) or you can embed the command line in a script file.
You can see argument help if you use:
FuseIT.SFDC.DataExportConsole.exe /?
There are two ways to use the command line. By specifying the login details (1) or by supplying a connection string (2).
1. Specifying Login Details
The following arguments are required:
- /u:
Salesforce.com Partner API user name - /p:
Salesforce.com Partner API password - /t:
Salesforce.com Partner API security token - /e:
Salesforce binding environment. Required to be one of the following:- Production
- DeveloperEdition
- Sandbox
- Pre_release
- save path:
File path where the exported zip files will be saved (enclose in "speech marks", back slashes should be escaped)
An example command line might look like:
FuseIT.SFDC.DataExportConsole.exe /u:user@test.com /p:12345678 /t:C3P3qivIf5t6Q6uYtzxxxxxx /e:Production "C:\\SFDCexports"
2. Supplying a Connection String
The connection string can be generated in the FuseIT SFDC Explorer, and then copied into the FuseIT.SFDC.DataExportConsole.exe.config
(See Login Section). To add a connection string to the FuseIT.SFDC.DataExportConsole.exe
, browse to the directory where the FuseIT.SFDC.DataExportConsole.exe
was installed and open the FuseIT.SFDC.DataExportConsole.exe.config
file. Find the element <connectionStrings> and insert your connection string within this tag (see screenshot below).
An example connection string (without proxy authentication):
<add name="testConnectionString" connectionString="G4S:user id=testuser@test.com;password=test;token=Y3623283JAADJK7;enviroment=Production;" />
Additionally, if you are using the FuseIT.SFDC.DataExportConsole.exe through a proxy, the connection string would look like:
<add name="testConnectionString" connectionString="G4S:user id=testuser@test.com;password=test;token=Y3623283JAADJK7;environment=Production;proxyserver=192.168.132.123; proxyport=808;proxyusername=test; proxypassword=test!;proxyauthentication=PROPRIETARY; proxyssltype=ALWAYS" />
When using the FuseIT.SFDC.DataExportConsole.exe
in the command line the following arguments are required:
- /c:
connectionstringname: The name of the connection string - as specified in theFuseIT.SFDC.DataExportConsole.exe.config
- Save path
Server file path where the exported zip files will be saved (enclose in "speech marks", back slashes should be escaped)
An example command line using a connection string might look like:
FuseIT.SFDC.DataExportConsole.exe /c:testConnectionString "C:\\SFDCexports"
See additional configuration options in FuseIT SFDC Data Exporter - AppSettings
Automated Data Export retrieval
Once the command line tool is configured you can automate the process by scheduling a task in Windows to invoke it at the required date and time.