Page tree
Skip to end of metadata
Go to start of metadata

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.

Prerequisites

The Data Export Command Line tool requires the .NET Framework 3.5 to be available.

Without it you may see a message like:

"This app can't run on your PC
To find a version for your PC, check with the software publisher"
- Windows Server 2012 R2 

See Enable .NET Framework 3.5 by using the Add Roles and Features Wizard

Usage


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.


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 the FuseIT.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.

  • No labels