Salesforce Developer Community

Chatter

Feed
7

Best Answers
0

Likes Received
0

Likes Given
12

Questions
20

Replies

I found this link on Google:

http://code.google.com/p/dataloadercliq/issues/detail?id=24

This is the exact same export problem I am having, although I am running Apex Data Loader 21.0. I am also running Windows 7. Any help would be greatly appreciated.

Gloria Lee

glorialeek12
April 16, 2011
Like
0

SOLVED

1 replies

APEX Data Loader beans definition

Hello,

I just downloaded Apex Data Loader 21.0 and now my process-conf.xml beans definitions are not working. The beans definitions worked fine for Apex Data Loader 17.0. I changed my sdfc.endpoint from "www.salesforce.com" (Apex 17.0) to "login.salesforce.com (Apex 21.0), but otherwise the beans definitions are identical. Whereas before, the log stayed in INFO, it now goes into DEBUG. Partial output follows:

0 [main] INFO com.salesforce.dataloader.process.ProcessConfig - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 21.0\Summit\process-conf.xml
41 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 21.0\Summit\process-conf.xml]
43 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl@1f42b49]
67 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
67 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to locate [spring-beans.dtd] in Spring jar
70 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath

Any help would be greatly appreciated!

glorialeek12
April 16, 2011
Like
0

SOLVED

3 replies

Error while running Data Loader through Command Line

I am trying to run the Data loader through command line and I am getting the following error. Can anyone help me where I am doing wrong.

ERROR MESSAGE:

C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>process.bat ./Config xnacMasterProcess
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig - Loading process
configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade
r 21.0\R4 Data Loader Integration\.\Config\process-conf.xml
78 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Dat
a Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
78 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader -
Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuil
derFactoryImpl@1f42b49]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and syste
m ID [http://www.springframework.org/dtd/spring-beans.dtd]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Trying to locate [spring-beans.dtd] in Spring jar
141 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classp
ath
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Loading bean definitions
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Default lazy init 'false'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Default autowire 'no'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Default dependency check 'none'
188 [main] INFO org.springframework.core.CollectionFactory - JDK 1.4+ collectio
ns available
203 [main] INFO org.springframework.core.CollectionFactory - Commons Collection
s 3.x available
203 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.ut
il.LinkedHashMap]
203 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Found 1 <bean> elements in file [C:\Program Files\salesforce.com\Apex D
ata Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creatin
g instance of bean 'xnacMasterProcess' with merged definition [Root bean: class
[com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=fal
se; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destroyM
ethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file [C
:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\
.\Config\process-conf.xml]]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors before instantiation of bean 'xnacMasterProcess'
250 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting
BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching
PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]

266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'class' of type [java.lang.Class]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'configOverrideMap' of type [java.util.Map]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'controller' of type [com.salesforce.dataloader.controller.Controller]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'name' of type [java.lang.String]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [
com.salesforce.dataloader.process.ProcessRunner] is cache-safe
281 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.ut
il.LinkedHashMap]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.pr
ocess.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
Name(java.lang.String)] with value of type [java.lang.String]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dat
aloader.process.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
ConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors before initialization of bean 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g afterPropertiesSet() on bean with name 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors after initialization of bean 'xnacMasterProcess'
359 [xnacMasterProcess] ERROR com.salesforce.dataloader.config.Config - Error i
nitializing encryption for key file C:\Program Files\salesforce.com\Apex Data Lo
ader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key File:
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
\EncryptionKey.key
375 [xnacMasterProcess] FATAL com.salesforce.dataloader.process.ProcessRunner -
Unable to run process xnacMasterProcess
java.lang.RuntimeException: com.salesforce.dataloader.exception.ControllerInitia
lizationException: Error loading config file: C:\Program Files\salesforce.com\Ap
ex Data Loader 21.0\R4 Data Loader Integration\.\Config\config.properties. Plea
se make sure that it exists and is readable
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:86)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: com.salesforce.dataloader.exception.ControllerInitializationException
: Error loading config file: C:\Program Files\salesforce.com\Apex Data Loader 21
.0\R4 Data Loader Integration\.\Config\config.properties. Please make sure that
it exists and is readable
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:333)
        at com.salesforce.dataloader.controller.Controller.<init>(Controller.jav
a:95)
        at com.salesforce.dataloader.controller.Controller.getInstance(Controlle
r.java:199)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:84)
        ... 2 more
Caused by: com.salesforce.dataloader.exception.ConfigInitializationException: Er
ror initializing encryption for key file C:\Program Files\salesforce.com\Apex Da
ta Loader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key F
ile: C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integr
ation\EncryptionKey.key
        at com.salesforce.dataloader.config.Config.initEncryption(Config.java:70
2)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:616)
        at com.salesforce.dataloader.config.Config.load(Config.java:599)
        at com.salesforce.dataloader.config.Config.load(Config.java:575)
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:327)
        ... 5 more
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>

I have followed the following procedure

Generated an encrypted key and saved it in a file in .key format

encrypted my SFDC password along with security token using the encrypted key

created process.XML and Database.xml files

created config.properties file

when I tried to run the process.XML file through command prompt I am getting the above error message.

Follwing are the files I have created and placed then in a folder inside data loader folder

Process.XML file

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="xnacMasterProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <property name="name" value="xnacMasterProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.proxyHost" value="proxy host url"/>
                <entry key="sfdc.proxyPort" value="port number"/>
    <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
    <entry key="sfdc.username" value="test.user@mycompany.com"/>
                <entry key="sfdc.password" value="3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537"/>
                <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\Config\EncryptionKey.key"/>
                <entry key="sfdc.connectionTimeoutSecs" value="60"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
  <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="extract"/>
                <entry key="sfdc.enableRetries" value="TRUE"/>
                <entry key="sfdc.maxRetries" value="3"/>
                <entry key="sfdc.minRetrySleepSecs" value="3"/>
                <entry key="dataAccess.name" value="queryXNAC"/>
                <entry key="dataAccess.type" value="databaseRead"/>
            </map>
        </property>
    </bean>
</beans>

Database.XML

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@(DESCRIPTION_LIST=(FAILOVER=TRUE) (LOAD_BALANCE=FALSE) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
(CONNECT_DATA=(SERVICE_NAME=HRGLOBAL) (SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=SELECT) (METHOD=PRECONNECT) (RETRIES=20)(DELAY=30)))) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
(SERVER=DEDICATED)))"/>
    <property name="username" value="username"/>
    <property name="password" value="pwd"/>
</bean>
<bean id="queryXNAC"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryXNACSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="queryXNACSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            select parent3_xnac, parent3 from finaltable
        </value>
    </property>
    <property name="columnNames">
        <list>
        <value>parent3_xnac</value>
<value>parent3</value>
        </list>
    </property>
</bean>
</beans>

Config.Properties

#Loader Config
sfdc.endpoint=https\://www.salesforce.com
sfdc.username=test.user@mycompany.com
sfdc.password=3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537
process.encryptionKeyFile=C:\\Program Files\\salesforce.com\\Apex Data Loader 21.0\\R4 Data Loader Integration\\Config\\EncryptionKey.key

Thanks in Advance

mac_046
March 02, 2011
Like
0

SOLVED

4 replies

HELP! Reports UI changed!

I just logged on and realized that Salesforce changed the Reports tab user interface in the last few days. Instead of a nice set of folders that you can arrange any way you want, including hiding folders, the new UI lists all the folders on the left hand side of screen, Windows-Explorer-like and then you click on the folder to see the list of reports in the folder. I could live with it, except I don't see how to hide certain folders from the folder list. When I try to edit the folder, it does indeed indicate that the folder is hidden as I specified, yet it still shows up in the folder list and I can still run the reports that are in it? Any suggestions? This is an emergency, as all the extra folders will confuse the users to no end! I want the old interface back!!!

It is rather annoying when Salesforce changes the user interface without telling the customers. Sometimes the new interfaces are not as good as the ones they replaced.

DSI
October 11, 2011
Like
0

SOLVED

1 replies

APEX 22.0 Data Loader - Command line interface

Hello,

I've been having problems with the last few versions of the APEX data loader. I use the command line interface from Windows 7. The last time it worked properly was with APEX 17.0. I missed APEX 18, 19, 20, but when I downloaded and used APEX 21 (and now also 22) with the same batch file, I get a bunch of debug messages that did not occur when I was using APEX 17.0. The debug messages do not appear to be affecting the ability of data to load properly, however my output files are huge. Here's an example of some of the DEBUG messages:

C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit>..\_jvm\bin\java.exe -cp ..\DataLoader.jar -Dsalesforce.config.dir="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit" com.salesforce.dataloader.process.ProcessRunner process.name="StuPeriodExportProcess"
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml
37 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]
39 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl@1f42b49]
60 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
60 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to locate [spring-beans.dtd] in Spring jar
63 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath
166 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Loading bean definitions
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default lazy init 'false'
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default autowire 'no'
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default dependency check 'none'
175 [main] INFO org.springframework.core.CollectionFactory - JDK 1.4+ collections available
184 [main] INFO org.springframework.core.CollectionFactory - Commons Collections 3.x available
185 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
189 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
190 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
191 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
192 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
193 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
195 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
195 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
196 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
198 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
199 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
200 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
201 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
202 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
205 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
205 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
206 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
207 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
208 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
208 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
209 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
210 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
211 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
211 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
212 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
213 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
213 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
216 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
216 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
217 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
217 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
218 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
218 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
219 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
219 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
221 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
221 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
224 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
230 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
232 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
232 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Found 84 <bean> elements in file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]
241 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'StuPeriodExportProcess' with merged definition [Root bean: class [com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=false; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destroyMethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]]
242 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before instantiation of bean 'StuPeriodExportProcess'
273 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
277 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'class' of type [java.lang.Class]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'configOverrideMap' of type [java.util.Map]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'controller' of type [com.salesforce.dataloader.controller.Controller]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'name' of type [java.lang.String]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [com.salesforce.dataloader.process.ProcessRunner] is cache-safe
281 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.process.ProcessRunner]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setName(java.lang.String)] with value of type [java.lang.String]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dataloader.process.ProcessRunner]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before initialization of bean 'StuPeriodExportProcess'
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking afterPropertiesSet() on bean with name 'StuPeriodExportProcess'
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors after initialization of bean 'StuPeriodExportProcess'

I'm using the log-conf and config.properties files that come with as samples. Specifically, my log-conf is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration>
    <appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
        <param name="File"   value="${java.io.tmpdir}/sdl.log" />
        <param name="Append" value="true" />
        <param name="MaxFileSize" value="100KB" />
        <param name="MaxBackupIndex" value="1" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>
    </appender>
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>
    </appender>

    <category name="org.apache.log4j.xml">
        <priority value="warn" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </category>

    <logger name="org.apache" >
            <level value ="warn" />
    </logger>

    <root>
        <priority value ="info" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </root>
</log4j:configuration>

and my config.properties file is:

#Loader Config
#Thu Sep 10 09:37:47 PDT 2009
sfdc.endpoint=https://login.salesforce.com

Can anyone tell me how to get rid of these?

DSI
September 07, 2011
Like
0

SOLVED

2 replies

Restricting read access for roles and hierarchies

Hello,

I'm using roles to try to restrict access to records. It seems to work as expected for Edit, but not for read.

I've created two accounts as follows:

Account Owner

100 a1

200 a2

User Role Profile

a1 A B

a2 A B

I have an object called O that has a field, F, that is defined as Master-Detail (Account)

a1 and a2 are both able to see each other's account information when accessing object O.

Under sharing settings, I have no sharing rules defined, and Default Access has been set to Private for Account, and to Controlled By Parent for O.

Under Profiles, Basic Access is set to Read for both Accounts and O, and no Data Administration options have been checked.

I don't understand why a1 and a2 are still able to see each other's records. What more do I need to do to restrict access?

Gloria Lee

DSI
October 23, 2009
Like
0

SOLVED

1 replies

using master-detail data type to control role level access

Hello,

I'm trying to create row-level access using Accounts. I am using mostly custom objects, so what I normally do is just link the AccountID field in the object back to Account, by specifying the AccountID field as a master-detail type and specifying Account as the master.

Unfortunately, I'm encountering conflicting usage rules between my Developer version and my Enterprise version. In Enterprise, it appears I can do this for all of my objects. But in the Develpor version, it seems I am only allowed to do this when the Name field of the object is Autonumber. If I take the text(80) option, then one of the standard fields is Owner and I'm not allowed to change it. For the Autonumber objects, there is no Owner standard field. Note that there doesn't ever appear to be an Owner standard field in the Enterprise version.

I am using Eclipse to synchronize the meta data across multiple systems (I am an ISV), so I would like my Developer edition to be the master. But that means I need to set the AccountID in text defined name field objects to master detail that points back to Account.

I would be most grateful for any help.

Thanks,

Gloria Lee

DSI
October 22, 2009
Like
0

0 replies

Changing Account and Contact report layouts

Hello,

I am building a non-CRM application on Force.com with mostly custom objects. I need to use the Account and Contact objects for role privileges, but they do not actually represent Accounts and Objects. I have created custom fields within Account and Contact for the information I need, but when I create reports using these objects, I would like to suppress all but the custom fields I have created on the Select Columns screen. In other words, I don't want to see BillingStreet, BillingCity or any of the other standard Account fields.

Normally, you'd just change the page layout on a custom object, but I don't see a way to do this for Account and Contact.

Any ideas?

Gloria

DSI
September 07, 2009
Like
0

0 replies

Using report types

Hello,

I am building a reporting app that uses mostly custom objects. I am having a heck of a time trying to avoid bumping into the custom report types limit. I got some reprieve since there seem to be default report types in the Other Reports folder that I can use to generate reports as long as there is only one lookup required in the report. For instance if I have a custom object with three lookups in it, I can choose any one lookup and build a report. For reports that require multiple objects to be looked up, I have resorted to creating a custom report type.

Unfortunately most of my reports/ custom objects will have TWO lookups. One to either Account or Contact and one to another custom object.

Does anyone know how I accomplish two lookups for a report without resorting to creating a Custom Report Type?

Thanks.

Gloria

DSI
July 11, 2009
Like
0

1 replies

Other Report report type category

Hello,

I have a developer account where I am creating custom report types. I recently did a fair amount of maintenance on these report types (deleting old ones and adding new ones). I stored all of the reports under the "Other Reports" report type category.

My problem is that when I go to actually create a Custom Report and choose the Other Reports category to search for the report type I need, the list contains all of the Report Types I deleted as well. It is a real mess and I can no longer tell what the report types in the list actually represent.

How do I clean up the Other Reports category list to only reflect the Reports that I currently have?

Thanks,

Gloria Lee

DSI
March 25, 2009
Like
0

9 replies

record level access

Does anyone know how to set up read access to objects so someone can only see their records? e.g. a salesperson would only see information for their customers. I don't really care about update, since this will be primarily a reporting system, but I need to control access so people can't see records that don't belong to them.

Thanks,

Gloria Lee

DSI
March 19, 2009
Like
0

1 replies

Need Report sorting help!

I would like to create report with an aggregate column, but not sort by the grouped column. For instance, I would like to rollup sales (sum sales) by sales rep (group by sales rep), but then I need to create a report that allows me to sort by total sales, not the sales rep. How do I do that?

I would also like the user to be able to click on any column and sort by that column (e.g. region or salesrep or country, or etc.). Finally is there any way to specify specify a dynamic sort order (e.g. by region, then by total sales, then by salesrep)?

Thanks,

Gloria Lee

DSI
August 10, 2008
Like
0

7 replies

How do you deal with multiple master-detail relationships on a custom object?

For instance, an order might be identified by (order no, customer id, product id, salesrep id). When I do a report on an order, I need to print the customer details (e.g. name, company, title), product details (e.g. product group, product name) and salesrep info (e.g. name, contact info). Ideally I would like to create three masters (customer, product, salesrep) for one detail (order). The documentation says I can only specify one master for a given detail table if the detail is a custom object.

Lookups allow me to customize the picklists with descriptive information, but this doesn't help me with reports.

Any ideas on how I can implement this? Thanks.

DSI
April 16, 2008
Like
0

2 replies

How do you limit drill down column list?

I am develping some reports, and when the report is executed, there is an option to drill down to a column. The picklist here displays all columns (even system generated ones). This makes for a very complicated list of columns for the user to navigate. I would like to limit the list to just the columns I want the user to be able to drill down by. Does anyone know how to do this?

DSI
April 16, 2008
Like
0

2 replies

Embedding Reports inside of tabs

force.com comes with a marketing app whose tabs for Contacts and Campaigns have links to execute reports from inside the tab. How did they do that? I have looked inside of the Contacts and Campaigns object for clues and can't seem to find anything.

DSI
April 15, 2008
Like
0

SOLVED

4 replies

HELP! Reports UI changed!

It is rather annoying when Salesforce changes the user interface without telling the customers. Sometimes the new interfaces are not as good as the ones they replaced.

DSI
October 11, 2011
Like
0

SOLVED

1 replies

APEX 22.0 Data Loader - Command line interface

Hello,

I'm using the log-conf and config.properties files that come with as samples. Specifically, my log-conf is as follows:

and my config.properties file is:

#Loader Config
#Thu Sep 10 09:37:47 PDT 2009
sfdc.endpoint=https://login.salesforce.com

Can anyone tell me how to get rid of these?

DSI
September 07, 2011
Like
0

SOLVED

1 replies

APEX data loader beans definition (Part 2)

I found this link on Google:

http://code.google.com/p/dataloadercliq/issues/detail?id=24

This is the exact same export problem I am having, although I am running Apex Data Loader 21.0. I am also running Windows 7. Any help would be greatly appreciated.

Gloria Lee

glorialeek12
April 16, 2011
Like
0

SOLVED

1 replies

APEX Data Loader beans definition

Hello,

Any help would be greatly appreciated!

glorialeek12
April 16, 2011
Like
0

SOLVED

3 replies

Error while running Data Loader through Command Line

I am trying to run the Data loader through command line and I am getting the following error. Can anyone help me where I am doing wrong.

ERROR MESSAGE:

I have followed the following procedure

Generated an encrypted key and saved it in a file in .key format

encrypted my SFDC password along with security token using the encrypted key

created process.XML and Database.xml files

created config.properties file

when I tried to run the process.XML file through command prompt I am getting the above error message.

Follwing are the files I have created and placed then in a folder inside data loader folder

Process.XML file

Database.XML

Config.Properties

Thanks in Advance

mac_046
March 02, 2011
Like
0

SOLVED

3 replies

Apex Data Loader Account update

Hello,

I'm using the Apex Data Loader (17.0) to load the account table. I have Sys Admin privilege. I can't seem to update the OwnerID field though the data loader to an owner other than myself. No matter what I do, Salesforce sets my ID as the ownerID. I can change it just fine interactively through the wizard to whatever I want, but I can't seem to do it from inside of the Apex Data Loader. The OwnerID value I am using in the Data Loader is the ID field that goes with the user I want. Anyone have any suggestions?

Gloria Lee