Hi,

How we can configure process-config.xml and database-conf.xml file to fetch/upload INCREMENTAL data from Salesforce.com to Oracle table and vice-versa using Apex Data Loader.

I can see the 2 below line code in sample database-conf.xml file for incremental data load.

WHERE LAST_UPDATED > @process.lastRunDate@

and

<entry key="process.lastRunDate" value="java.sql.Timestamp"/>

I can also see the one line code inside process-conf.xml. But for both mentioned configuration, details are not available in document.

But I am not able understand how @process.lastRunDate@ will be replaced with actual value.

I can also see the below line code in process-config.xml, when this line of code is required. Is this required for incremental dataload?

 <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>

Can anybody help, please?

Thanks

Hi,

I am facing issue with Apex Data Loader build 25.0 with command line operation while using database write. I am getting issue:

Database error encountered during connecting for database configuration: INSERTAccount. Sql error: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)

However, it is working fine with Apex Data Loader build 22.0

Can anybody help me, what changes are required in build 25.0?

Thanks in advance,

Anzar

Hi ,

Is there any way to find Table or Column description in APEX API ?

Please provide the approach or syntax or any method available for finding the description.

Kindly, suggest me on this issue.

Thanks & Regards,

Anzar.

Hi,

I'm trying to use the ApexDataloader ver 16 command line option to export data from Salesforce to File (.csv) from one of the application. But I'm getting error message "Wrong process return code".

The content of config.properties file is as follows:

     #Loader Config
     username=<username>
     password=<password+security code>
     operation=extract
     extractionSOQL=select  Id,IsDeleted,MasterRecordId,Name,Type,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Fax,AccountNumber,Website,Sic,Industry,AnnualRevenue,NumberOfEmployees,Ownership,TickerSymbol,Description,Rating,Site,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastActivityDate,CustomerPriority__c,SLA__c,Active__c,NumberofLocations__c,UpsellOpportunity__c,SLASerialNumber__c,SLAExpirationDate__c from Account   where Type = 'Customer - Direct'
     extractionTarget=extract.csv

My command line script is as follows:

 cmd.exe /c C:/PROGRA~1/salesforce.com/APEXDA~1.0/_jvm/bin/java -Dsalesforce.config.dir=C:/PROGRA~1/salesforce.com/APEXDA~1.0/conf  -jar C:/PROGRA~1/salesforce.com/APEXDA~1.0/DataLoader.jar 1>"c:/production/data/salesforce/log/sforcedataloader.log" 2>"c:/production/data/salesforce/log/sforcedataloader.error"

Can anybody help me to fix this issue, please. It's very urgent.

I tried to find out the solution on net, but couldn't get.

Please help.

Thanks in advance,

Anzar

Hi,

I am facing issue with Apex Data Loader build 25.0 with command line operation while using database write. I am getting issue:

Database error encountered during connecting for database configuration: INSERTAccount. Sql error: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)

However, it is working fine with Apex Data Loader build 22.0

Can anybody help me, what changes are required in build 25.0?

Thanks in advance,

Anzar

Hi ,

Is there any way to find Table or Column description in APEX API ?

Please provide the approach or syntax or any method available for finding the description.

Kindly, suggest me on this issue.

Thanks & Regards,

Anzar.

Hi,

I'm trying to use the ApexDataloader ver 16 command line option to export data from Salesforce to File (.csv) from one of the application. But I'm getting error message "Wrong process return code".

The content of config.properties file is as follows:

     #Loader Config
     username=<username>
     password=<password+security code>
     operation=extract
     extractionSOQL=select  Id,IsDeleted,MasterRecordId,Name,Type,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Fax,AccountNumber,Website,Sic,Industry,AnnualRevenue,NumberOfEmployees,Ownership,TickerSymbol,Description,Rating,Site,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastActivityDate,CustomerPriority__c,SLA__c,Active__c,NumberofLocations__c,UpsellOpportunity__c,SLASerialNumber__c,SLAExpirationDate__c from Account   where Type = 'Customer - Direct'
     extractionTarget=extract.csv

My command line script is as follows:

 cmd.exe /c C:/PROGRA~1/salesforce.com/APEXDA~1.0/_jvm/bin/java -Dsalesforce.config.dir=C:/PROGRA~1/salesforce.com/APEXDA~1.0/conf  -jar C:/PROGRA~1/salesforce.com/APEXDA~1.0/DataLoader.jar 1>"c:/production/data/salesforce/log/sforcedataloader.log" 2>"c:/production/data/salesforce/log/sforcedataloader.error"

Can anybody help me to fix this issue, please. It's very urgent.

I tried to find out the solution on net, but couldn't get.

Please help.

Thanks in advance,

Anzar