Hi,

 

I've looked through communities and I think this is maybe a feature which is being developed for the next release, but wondered if anyone knows of a way to do this in the mean time.

 

I have created an s-control to create a custom object, prepopluating it with certain fields from both the contacts and accounts objects.  This is working great.  However, I have now added a custom lookup field to the contacts object.  I want to get details from this lookup object but I can't seem to reference it in any way apart from the name or id.

 

Is this currently possible?  Is there a way to reference the fields of a lookup object?

 

Thanks

 

Sandra

I'm using the Apex data loader command line and wondered if there is a way of including parameters in the query string extractionSOQL to extract data from salesforce.  I want to extract all new accounts created that day by a certain user.

 

The XML from the sample process-conf.xml for a process is :- Code:

- <bean id="databaseAccountExtractProcess" class="com.salesforce.lexiloader.process.ProcessRunner" singleton="false" abstract="false" lazy-init="default" autowire="default" dependency-check="default">
  <description>DatabaseAccountExtract job gets account info from salesforce and updates or inserts info into database."</description> 
  <property name="name" value="databaseAccountExtract" /> 
- <property name="configOverrideMap">
- <map>
  <entry key="sfdc.debugMessages" value="false" /> 
  <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log" /> 
  <entry key="sfdc.endpoint" value="https://www.salesforce.com" /> 
  <entry key="sfdc.username" value="user@mycompany.com" /> 
- <!--  password specified below is invalid, please generate one using the encrypt.bat utility 
  --> 
  <entry key="sfdc.password" value="1111111111111111" /> 
  <entry key="sfdc.timeoutSecs" value="600" /> 
  <entry key="sfdc.loadBatchSize" value="200" /> 
  <entry key="sfdc.entity" value="Account" /> 
  <entry key="sfdc.extractionRequestSize" value="500" /> 
  <entry key="sfdc.extractionSOQL" value="Select Id, Name, Type, ParentId, Phone, AccountNumber, Website, Sic, AnnualRevenue, NumberOfEmployees, TickerSymbol, Oracle_Id__c FROM Account" /> 
  <entry key="process.operation" value="extract" /> 
  <entry key="process.mappingFile" value="c:\dataloader\samples\conf\accountExtractToDbMap.sdl" /> 
  <entry key="dataAccess.type" value="databaseWrite" /> 
  <entry key="dataAccess.name" value="updateAccount" /> 
  </map>
  </property>
  </bean>

 
Is there a way to extend the SQL string to add a parameter ( say a date stamp )?

 

 

Hi,

 

I want to use the Apex Data Loader ( version 9.0 ) command line interface to get information from a SQL server 2000 db and import it into salesforce.  So far I've managed to successfully import from a csv using the command line ( and the process-conf.xml ).  But to connect to my SQL server database I need to know which driver to use ( I'm not a java programmer ).  I've looked about and the driver seems to be

 com.sun.sql.jdbc.sqlserver.SQLServerDriver

 

 

 

 

 

Hi,

 

I want to use the Apex Data Loader ( version 9.0 ) command line interface to get information from a SQL server 2000 db and import it into salesforce.  So far I've managed to successfully import from a csv using the command line ( and the process-conf.xml ).  But to connect to my SQL server database I need to know which driver to use ( I'm not a java programmer ).  I've looked about and the driver seems to be

 com.sun.sql.jdbc.sqlserver.SQLServerDriver