• rlong
  • NEWBIE
  • 0 Points
  • Member since 2008

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 4
    Replies
I am brand new at this so I'm sure it's something obvious to those that have used it before.
I've x'd out the user name and password. There isn't any updates to the log, the trace and the csv file
doesn't get created. No error messages come up either. Can anyone see if I am missing a key piece?
 
I execute the job from the RUN command line, using the code listed below and I get the following results:
 
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="serialExportProcess"
          class="com.salesforce.lexiloader.process.ProcessRunner"
          singleton="false">
      <description>Serial Number Export job gets serial number info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="SerialExportProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing\serialSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="xxxxxxx"/>
                <entry key="sfdc.password" value="xxxxxxxx"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Serial_Number__c"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select Id, Serial_Number_Key__c, Item_Number__c, Name FROM Serial_Number__c"/>
                <entry key="process.operation" value="extract"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.writeUTF8" value="true"/>
                <entry key="dataAccess.name" value="z:\SFDC SERIAL TEXT\sernextr.csv"/>
                <entry key="process.statusOutputDirectory" value="C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing\serialSoaplog.log"/>
            </map>
        </property>
    </bean>
</beans>
 
----------------------------------------

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>call proc

ess "C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing" ser

ialExportProcess

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>if not ["

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing"] == [] g

oto run

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>set PROCE

SS_OPTION=

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>if not [s

erialExportProcess] == [] set PROCESS_OPTION=process.name=serialExportProcess

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>..\_jvm\b

in\java.exe -cp ..\DataLoader.jar -Dsalesforce.config.dir="C:\Program Files\sale

sforce.com\Apex Data Loader 11.0\Batch Processing" com.salesforce.lexiloader.pro

cess.ProcessRunner process.name=serialExportProcess

0 [main] INFO com.salesforce.lexiloader.process.ProcessConfig  - Loading process

 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade

r 11.0\Batch Processing\process-conf.xml

5496 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader

- Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex D

ata Loader 11.0\Batch Processing\process-conf.xml]

5496 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader

 - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBu

ilderFactoryImpl@1256ea2]

5559 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and syst

em ID [http://www.springframework.org/dtd/spring-beans.dtd]

5559 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Trying to locate [spring-beans.dtd] in Spring jar

5575 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in class

path

5622 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Loading bean definitions

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default lazy init 'false'

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default autowire 'no'

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default dependency check 'none'

5653 [main] INFO org.springframework.core.CollectionFactory  - JDK 1.4+ collecti

ons available

5669 [main] INFO org.springframework.core.CollectionFactory  - Commons Collectio

ns 3.x available

5669 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.u

til.LinkedHashMap]

5669 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Found 1 <bean> elements in file [C:\Program Files\salesforce.com\Apex

Data Loader 11.0\Batch Processing\process-conf.xml]

 
 
  • June 26, 2008
  • Like
  • 0
I developed an XML member to do a simple extract of data from SalesForce using DataLoader. When I execute the process using a .bat file, the screen flashes and then nothing. No error messages or other messages. Is there a way to have a walkthrough on the code to see what it is actually doing? It isn't creating the extract, so something is incorrect. This is my first try at the command line processing, so I'm sure it is something simple I'm missing.
Any help would be appreciated.
  • June 25, 2008
  • Like
  • 0
I am brand new at this so I'm sure it's something obvious to those that have used it before.
I've x'd out the user name and password. There isn't any updates to the log, the trace and the csv file
doesn't get created. No error messages come up either. Can anyone see if I am missing a key piece?
 
I execute the job from the RUN command line, using the code listed below and I get the following results:
 
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="serialExportProcess"
          class="com.salesforce.lexiloader.process.ProcessRunner"
          singleton="false">
      <description>Serial Number Export job gets serial number info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="SerialExportProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing\serialSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="xxxxxxx"/>
                <entry key="sfdc.password" value="xxxxxxxx"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Serial_Number__c"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select Id, Serial_Number_Key__c, Item_Number__c, Name FROM Serial_Number__c"/>
                <entry key="process.operation" value="extract"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.writeUTF8" value="true"/>
                <entry key="dataAccess.name" value="z:\SFDC SERIAL TEXT\sernextr.csv"/>
                <entry key="process.statusOutputDirectory" value="C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing\serialSoaplog.log"/>
            </map>
        </property>
    </bean>
</beans>
 
----------------------------------------

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>call proc

ess "C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing" ser

ialExportProcess

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>if not ["

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing"] == [] g

oto run

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>set PROCE

SS_OPTION=

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>if not [s

erialExportProcess] == [] set PROCESS_OPTION=process.name=serialExportProcess

 

C:\Program Files\salesforce.com\Apex Data Loader 11.0\Batch Processing>..\_jvm\b

in\java.exe -cp ..\DataLoader.jar -Dsalesforce.config.dir="C:\Program Files\sale

sforce.com\Apex Data Loader 11.0\Batch Processing" com.salesforce.lexiloader.pro

cess.ProcessRunner process.name=serialExportProcess

0 [main] INFO com.salesforce.lexiloader.process.ProcessConfig  - Loading process

 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade

r 11.0\Batch Processing\process-conf.xml

5496 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader

- Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex D

ata Loader 11.0\Batch Processing\process-conf.xml]

5496 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader

 - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBu

ilderFactoryImpl@1256ea2]

5559 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and syst

em ID [http://www.springframework.org/dtd/spring-beans.dtd]

5559 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Trying to locate [spring-beans.dtd] in Spring jar

5575 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver

- Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in class

path

5622 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Loading bean definitions

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default lazy init 'false'

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default autowire 'no'

5637 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Default dependency check 'none'

5653 [main] INFO org.springframework.core.CollectionFactory  - JDK 1.4+ collecti

ons available

5669 [main] INFO org.springframework.core.CollectionFactory  - Commons Collectio

ns 3.x available

5669 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.u

til.LinkedHashMap]

5669 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinition

Parser  - Found 1 <bean> elements in file [C:\Program Files\salesforce.com\Apex

Data Loader 11.0\Batch Processing\process-conf.xml]

 
 
  • June 26, 2008
  • Like
  • 0
I developed an XML member to do a simple extract of data from SalesForce using DataLoader. When I execute the process using a .bat file, the screen flashes and then nothing. No error messages or other messages. Is there a way to have a walkthrough on the code to see what it is actually doing? It isn't creating the extract, so something is incorrect. This is my first try at the command line processing, so I'm sure it is something simple I'm missing.
Any help would be appreciated.
  • June 25, 2008
  • Like
  • 0