• Jonathan Bolanos
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
HI All, 

So after much frustration on this ... 
Can someone help me . 
I have tried using CLIq and that didn't work for me.  
I am trying to run Data Loader via Command Line and I get this error.

Process-conf (file)
---------------------
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>

   <bean id="extractEP" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false">
            <description>Export Widgets to CSV </description>
            <property name="name" value="extractEP" />
            <property name="configOverrideMap">
                <map>
                    <entry key="sfdc.debugMessages" value="true"/>
                    <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                    <entry key="sfdc.Server host" value="https://www.salesforce.com"/>

    <!-- Your login ID goes on the nextline. -->
                    <entry key="sfdc.username" value="xxx@xxxx.com"/>

        <!-- Your password that was generated using encrypt.bat utility goes between the value quotes on the next line. -->
                    <entry key="sfdc.password" value="xxxxx"/>

    <!-- Change the next line to match the path to your key file -->
                    <entry key="process.encryptionKeyFile" value="C:\Users\jbolanos\.dataloader\dataLoader.key"/>

                    <entry key="sfdc.timeoutSecs" value="600"/>
                    <entry key="sfdc.useBulkApi" value="true"/>
                    <entry key="sfdc.loadBatchSize" value="500"/>
                       <entry key="sfdc.extractionRequestSize" value="10000"/>
        
    <!--  Change the next line to match the Salesforce object you with to extract -->
            <entry key="sfdc.entity" value="Epic_Policy__c"/>

    <!-- Change the SOQL statement in the next line to get the fields you want from the above obect -->
                    <entry key="sfdc.extractionSOQL" value="Select Id FROM Epic_Policy__c"/>
                
            <entry key="process.operation" value="extract"/>
                
    <!-- Change the next line to the path and file that you wish to save the extract to.  -->
            <entry key="dataAccess.name" value="c:\dataloader\extract.csv"/>

                    <entry key="dataAccess.type" value="csvWrite"/>
                  </map>
            </property>
    </bean>


</beans>

-----------------------------



c:\Program Files (x86)\salesforce.com\Data Loader\bin>process c:\dataloader extractEP
2018-09-18 09:11:30,784 INFO  [main] controller.Controller initLog (Controller.java:496) - Using built-in logging configuration, no log-conf.xml in C:\Users\jbolanos\AppData\Local\salesforce.com\Data Loader 43.0.0\conf\log-conf.xml
2018-09-18 09:11:30,788 INFO  [main] controller.Controller initLog (Controller.java:498) - The log has been initialized
2018-09-18 09:11:30,790 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:104) - Loading process configuration from config file: c:\dataloader\process-conf.xml
2018-09-18 09:11:30,846 INFO  [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@18f9dd6: startup date [Tue Sep 18 09:11:30 PDT 2018]; root of context hierarchy
2018-09-18 09:11:30,876 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [c:\dataloader\process-conf.xml]
2018-09-18 09:11:30,877 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: extractEP configuration from config file: c:\dataloader\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from file [c:\dataloader\process-conf.xml]; nested exception is java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:111)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
Caused by: java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(Unknown Source)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSystemResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more
2018-09-18 09:11:30,879 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:251) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: extractEP configuration from config file: c:\dataloader\process-conf.xml

        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from file [c:\dataloader\process-conf.xml]; nested exception is java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:111)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more
Caused by: java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(Unknown Source)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSystemResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more
c:\Program Files (x86)\salesforce.com\Data Loader\bin>



 
HI All, 

So after much frustration on this ... 
Can someone help me . 
I have tried using CLIq and that didn't work for me.  
I am trying to run Data Loader via Command Line and I get this error.

Process-conf (file)
---------------------
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>

   <bean id="extractEP" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false">
            <description>Export Widgets to CSV </description>
            <property name="name" value="extractEP" />
            <property name="configOverrideMap">
                <map>
                    <entry key="sfdc.debugMessages" value="true"/>
                    <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                    <entry key="sfdc.Server host" value="https://www.salesforce.com"/>

    <!-- Your login ID goes on the nextline. -->
                    <entry key="sfdc.username" value="xxx@xxxx.com"/>

        <!-- Your password that was generated using encrypt.bat utility goes between the value quotes on the next line. -->
                    <entry key="sfdc.password" value="xxxxx"/>

    <!-- Change the next line to match the path to your key file -->
                    <entry key="process.encryptionKeyFile" value="C:\Users\jbolanos\.dataloader\dataLoader.key"/>

                    <entry key="sfdc.timeoutSecs" value="600"/>
                    <entry key="sfdc.useBulkApi" value="true"/>
                    <entry key="sfdc.loadBatchSize" value="500"/>
                       <entry key="sfdc.extractionRequestSize" value="10000"/>
        
    <!--  Change the next line to match the Salesforce object you with to extract -->
            <entry key="sfdc.entity" value="Epic_Policy__c"/>

    <!-- Change the SOQL statement in the next line to get the fields you want from the above obect -->
                    <entry key="sfdc.extractionSOQL" value="Select Id FROM Epic_Policy__c"/>
                
            <entry key="process.operation" value="extract"/>
                
    <!-- Change the next line to the path and file that you wish to save the extract to.  -->
            <entry key="dataAccess.name" value="c:\dataloader\extract.csv"/>

                    <entry key="dataAccess.type" value="csvWrite"/>
                  </map>
            </property>
    </bean>


</beans>

-----------------------------



c:\Program Files (x86)\salesforce.com\Data Loader\bin>process c:\dataloader extractEP
2018-09-18 09:11:30,784 INFO  [main] controller.Controller initLog (Controller.java:496) - Using built-in logging configuration, no log-conf.xml in C:\Users\jbolanos\AppData\Local\salesforce.com\Data Loader 43.0.0\conf\log-conf.xml
2018-09-18 09:11:30,788 INFO  [main] controller.Controller initLog (Controller.java:498) - The log has been initialized
2018-09-18 09:11:30,790 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:104) - Loading process configuration from config file: c:\dataloader\process-conf.xml
2018-09-18 09:11:30,846 INFO  [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@18f9dd6: startup date [Tue Sep 18 09:11:30 PDT 2018]; root of context hierarchy
2018-09-18 09:11:30,876 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [c:\dataloader\process-conf.xml]
2018-09-18 09:11:30,877 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: extractEP configuration from config file: c:\dataloader\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from file [c:\dataloader\process-conf.xml]; nested exception is java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:111)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
Caused by: java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(Unknown Source)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSystemResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more
2018-09-18 09:11:30,879 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:251) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: extractEP configuration from config file: c:\dataloader\process-conf.xml

        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from file [c:\dataloader\process-conf.xml]; nested exception is java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:111)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more
Caused by: java.io.FileNotFoundException: c:\dataloader\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(Unknown Source)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSystemResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more
c:\Program Files (x86)\salesforce.com\Data Loader\bin>