Thursday, November 24, 2011

Start working with Command Line Data Loader in 5 minutes, Cheers!!

About Cliq(CLI Quickstart):
CLIq provides a simple wizard to create directory structures and configuration files for the Salesforce Data Loader Command Line Interface. You can spend hours configuring the CLI manually, or use CLIq and you will have a working configuration in less than 5 minutes. After creating a CLIq configuration, you can reference the Data Loader documentation and make adjustments as needed.


Installation Instructions: 
  1. Install GUI version of Apex data loader in a directory other than program files(Actually, windows7 does not let you create any files in the data loader directory in program files).
  2. Make sure you have JRE installed.
  3. Extract the zip file from the above link and paste the folder in the data loader installation directory.
  4. Execute Cliq.bat to run Cliq!!

How to use: 
Login with your salesforce.com username, password + security token.
If you face any issues while logging in, try changing the following in cliq.properties file in Cliq directory:
(remember you have to replace the version of your data loader you are using)
sfdc.endpoint=https://www.salesforce.com/services/Soap/u/21.0
sfdc.endpoint=https://login.salesforce.com/services/Soap/u/21.0  (for production)
sfdc.endpoint=https://test.salesforce.com/services/Soap/u/21.0    (for sandbox)


  
Select the operation and enter the name of the process. Cliq will create various directories(Config, read, write and log) in this folder named as "cliq_process" under GUI data loaders parent dir.





Select the object(for example, if you have selected Insert operation)



Click on "Create Data Loader CLI Files". If you have given the process name as "InsertProcess_" in step2 then you will find a dir named as "InsertProcess_" and a batch file(.bat) of the same name within that directory. Double click on it and you are done!






You can change the various values and parameters in process-conf.xml created in the "config" dir in "InsertProcess_" dir.


Try it and let me know how you feel after using it.

 

3 comments:

  1. getting this error-
    Exception occurred during event dispatching:
    java.lang.NoClassDefFoundError: com/sforce/soap/partner/fault/ApiFault
    at com.salesforce.cliq.cliconfig.CliConfigFactory.getCliConfig(Unknown S
    ource)
    at com.salesforce.cliq.cliconfig.CliConfigFactory.getCliConfig(Unknown S
    ource)
    at com.salesforce.cliq.ui.OperationPanelDescriptor.aboutToHidePanel(Unkn
    own Source)
    at com.nexes.wizard.Wizard.setCurrentPanel(Unknown Source)
    at com.nexes.wizard.WizardController.nextButtonPressed(Unknown Source)
    at com.nexes.wizard.WizardController.actionPerformed(Unknown Source)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
    ce)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)

    ReplyDelete
  2. Can we generate a automated file name every time we run the bat file like
    filename_YYYYMMSS_HHMMSS.csv

    ReplyDelete

Your feedback is always appreciated, thanks!!