SFDCFiles Installation
Salesforce, Consultants, Crossdoor, Jobs, Freshers, Best Salesforce Consultants India, Salesforce CPQ, Salesforce CTA
333
page-template,page-template-full_width,page-template-full_width-php,page,page-id-333,page-child,parent-pageid-321,bridge-core-1.0.5,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,qode-theme-ver-18.1,qode-theme-bridge,disabled_footer_bottom,wpb-js-composer js-comp-ver-6.0.2,vc_responsive
Prerequisites

Before SFDCFiles can be installed you will need Java installed on your local machine. If you already have Java on your computer, you don’t need to install, so first verify the installation from a command prompt.Java version 1.7.x or later is recommended for better security and for the latest TLS security protocols.

To check the version of Java that’s installed on your system:

  1. Open a command prompt.
  2. At the prompt, type java -version and press Enter.
  3. If you have Java version 7, the output looks something like the following:
java version "1.7.0_21"
Java(TM) SE Runtime Environment (build 1.7.0_21-b11)
Java HotSpot(TM) 64-Bit Server VM (build 23.21-b01, mixed mode)

To install Java, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html and get the latest version of the Java JDK. When you’re finished with the installation, verify by typing java -version at a command prompt.

Setup

Follow these steps to download and install DumpIT:

  1. Make sure that Java is installed on your local machine.
  2. Download the latest version of the zip file.
  3. Extract the zip file locally on your machine.
  4. The extracted contents of the zip file will have the following files and folders:

SFDCFiles folder

  1. build.properties file. This is the file where you will configure the tool.
  2. SFDCFiles.jar file. The jar file name will have the version number in it.
Configuring

Make sure you have downloaded the latest version and followed the pre-requisites steps before SFDCFiles can be used. Follow these steps to use the tool:

Configure build.properties
source.username Salesforce username for the Salesforce org from which the files will be exported. Make sure the user at-least has “View All Data” permission. Preferably user should have System Administrator profile.
source.password The password for source Salesforce Org. If security token is required, append it along with the password.
source.serverURL Salesforce server URL for the source Org. Use https://login.salesforce.com for production and developer Orgs and https://test.salesforce.com for Sandbox Org.
extractFolderPath Absolute path of the folder where the files will be extracted. Make sure the folder path ends with a back slash.
extractFileName File name of the CSV which will hold the field values and the path to the extracted file. example value extract.csv. This will be created in the folder path specified above.
sourceFile File name of the CSV where you can specify a filtered set if file Ids, you want to extract. example value source.csv. This should be placed in the folder path specified above.
query Set the SOQL on the object you want to query. It can be Document, Attachments, ContentVersion. Make sure you specify the Blob field in the query which holds the binary data of the file. Example: “Select Id, Body, Name from Attachment”. Escape any equals to signs used in the query.
blobFieldName API name of the field which holds the binary data of the file. This must be added in the query above. Example “Body”.
nameFieldName Field Name from SOQL which consist the File Name, this has to be added in the above SOQL. Files extracted are named in a format i.e. ID_NAME. This is to handle the cases where there are more than 1 file with the same name. Example “Name”.
Run the tool

Now that you have configured the build.properties you are ready to see the tool in action.

  1. Open command prompt/terminal.
  2. Go to DumpIT folder (the one with build.properties and jar file).
  3. Run this command, change the name of the jar file based on the jar version file you have downloaded.

java -jar SFDCFiles2.jar