Hello All

Please help me in this issue. When i am tring to load data in salesforce.com through Command line (DataLoader), its showing me this below error, which is related to class. I am using the DataLoader version 20.0::

...........

C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin>process ..\conf Insert
RecordsinAccount
2010-10-01 12:42:24,887 INFO  [main] controller.Controller initLog (Controller.j
ava:375) - The log has been initialized
2010-10-01 12:42:24,887 INFO  [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:78) - Loading process configuration from config file: C:\Program F
iles\salesforce.com\Apex Data Loader 20.0\bin\..\conf\process-conf.xml
2010-10-01 12:42:24,966 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file
 [C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin\..\conf\process-conf
.xml]
2010-10-01 12:42:25,012 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:66) - JDK 1.4+ collections available
2010-10-01 12:42:25,028 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:71) - Commons Collections 3.x available
2010-10-01 12:42:25,106 INFO  [InsertAccount] controller.Controller initConfig (
Controller.java:336) - The controller config has been initialized
2010-10-01 12:42:25,122 INFO  [InsertAccount] process.ProcessRunner run (Process
Runner.java:91) - Initializing process engine
2010-10-01 12:42:25,122 INFO  [InsertAccount] process.ProcessRunner run (Process
Runner.java:94) - Loading parameters
2010-10-01 12:42:26,481 INFO  [InsertAccount] config.LastRun load (LastRun.java:
101) - Last run info will be saved in file: C:\Program Files\salesforce.com\Apex
 Data Loader 20.0\bin\..\conf\InsertAccount_lastRun.properties
2010-10-01 12:42:26,497 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:212) - Unable to run process InsertAccount
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const cl
ass com.salesforce.dataloader.action.OperationInfo.
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:137)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:75)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:227)
Caused by: java.lang.IllegalArgumentException: No enum const class com.salesforc
e.dataloader.action.OperationInfo.
        at java.lang.Enum.valueOf(Enum.java:192)
        at com.salesforce.dataloader.config.Config.getEnum(Config.java:439)
        at com.salesforce.dataloader.config.Config.getOperationInfo(Config.java:
975)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:98)
        ... 2 more
C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin>

...........................

The below is my process-conf.xml:::

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans default-lazy-init="false" default-autowire="no" default-dependency-check="none">
   
  <bean
      class="com.salesforce.dataloader.process.ProcessRunner"
      singleton="false"  lazy-init="default" autowire="default" dependency-check="default">
    <description> Insert Records in Account Object from CSV file through Command Line </description>
 
  <property value="InsertAccount" />
  <property>
    <map>
      
        <entry key="sfdc.connectionTimeoutSecs" value="60"/>
        <entry key="sfdc.username" value="mohit.bansal@hcl.in.test1" />
        <entry key="sfdc.password" value="9fbaf20cfb2a22e8ad8a3b39836bc71c" />
        <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\KeyFile.txt"  />
        <entry key="process.outputSuccess" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\SuccessFile.csv" />
        <entry key="sfdc.loadBatchSize" value="100" />
        <entry key="dataAccessName" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\dumpydata1.csv" />
        <entry key="process.useEuropeanDates" value="true" />
        <entry key="dataAccess.readBatchSize" value="100" />
        <entry key="sfdc.maxRetries" value="3" />
        <entry key="process.outputError" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\ErrorFile.csv" />
        <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
        <entry key="dataAccess.Type" value="csvRead" />
        <entry key="process.Operation" value="insert" />
        <entry key="sfdc.extractionRequestSize" value="200" />
        <entry key="truncateFields" value="true" />
        <entry key="sfdc.entity" value="Account" />
        <entry key="sfdc.enableRetries" value="true" />
        <entry key="sfdc.timeoutsecs" value="1000" />
        <entry key="process.enableLastRunOutput" value="true" />
        <entry key="process.mappingfile" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\AccountMapping.sdl" />
   </map>
  
  </property>

 </bean> 

</beans>

Please let me know, why i am getting this error.

Hi ,

Any one tell me  how to  track the time during send the outbound message using Apex to othersystem from SFDC for Intigration

plz let me know :)

Hi,

I want create a out bound mesage using  Apex  & i successfully did it.I am posting the code down.

But here   I  am  hard-coding the add chidelement here.

Can some body let me know  is it possible to pass  the childelement Dynamically.Since  I am hardcording the field plz let.

HERE IS CODE

 public static void sendRequest()

{

String soapNS = 'http://schemas.xmlsoap.org/soap/envelope/';

String xsi = 'http://www.myservice.com/services/MyService/';

String endpntUrl = 'www.google.com';

String timeout = '10

// Account Fields

list<Account> lstAccounts = [Select id,Name from Account];

DOM.Document doc = new DOM.Document();

dom.XmlNode envelope = doc.createRootElement('Envelope', soapNS, 'soapenv');

envelope.setNamespace('xsi', xsi);

//Header

dom.XmlNode configData = envelope.addChildElement('_configData', soapNS, null);

dom.XmlNode endpointURL = configData.addChildElement('endpointURL', xsi, null).addTextNode(endpntUrl);

dom.XmlNode tout = configData.addChildElement('timeout', xsi, null).addTextNode(timeout);

//Body

dom.XmlNode body = envelope.addChildElement('Body', soapNS, null);

for(Account acc: lstAccounts){

dom.XmlNode accountList = body.addChildElement('accountList',xsi,null);

dom.XmlNode AccountName = accountList.addChildElement('Name', xsi, null).addTextNode(acc.Name);

dom.XmlNode Id = accountList.addChildElement('Id', xsi, null).addTextNode(acc.Id);

}

String req = doc.toXmlString();

system.debug('req----------------'+req);

}

Please Help me on this  :)

HI,

Can any one let me know  how to  display  data  in XML  in form of outbound message.

Also use wsdl.

Hi,

below is my  process. file.it is  running fine.I want to make some changes so  it will be generic,Iwant read the soql from a file.How to dothat.if store that file in local is it possisble  to read from there.itreied its showing error.

<bean id="exportAccounts"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Exports all accounts.</description>
        <property name="name" value="exportAccounts"/>
        <property name="configOverrideMap">
            <map>
        <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="G:\Apex\Test\logs\accountExport.log"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="sm_miky@gmail.com"/> <!-- INSERT YOUR SFDC USERNAME -->
                <entry key="sfdc.password" value="906355326acfbe1ba1297cb7ea61c1bd7d45f70f113639e2e77a1b551285c0d6527790ee11353e9b"/> <!--INSERT YOUR ENCRYPTED SFDC PASSWORD -->
        <entry key="process.encryptionKeyFile" value="G:\Apex\Test\key.txt"/> <!-- INSERT A PATH TO YOUR KEY FILE-->  
       
        <entry key="sfdc.entity" value="Account"/> <!-- INSERT THE API NAME OF REFERENCED SFDC OBJECT -->
                <entry key="sfdc.extractionSOQL" value="Select Id, Name, Type FROM Account"/> <!-- INSERT DOWN YOUR SOQL QUERY -->
               
        <entry key="process.operation" value="extract"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="G:\Apex\Test\exports\accountexpo.csv" /> <!-- INSERT A PATH TO YOUR EXPORT FILE -->
            </map>
        </property>
    </bean>

If some one have some solution please let me know.

Regards

Niky

while i m doin  webservices,i got one error  as compatibility issue,can some one help me in this?

Type in batch apex is- Contact [] conlist

Type in  generated code is-soapSforceComSchemasClassMyweb.Contact[] conlist



I  am getting error while generating classes in sandbox.

Error: unexpected token: 'delete' at 511:57

I am getting this error ,when i am generating apex classes in sandbox..can somebody help me out?

Error: Invalid type: enterpriseSoapSforceComNew.QueryResult at 40:16

Hi this is my process .config file.

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="accountMasterProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>LOGIN</description>
        <property name="name" value="accountMasterProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="D:\Apex Dataloader\samples\status\accountMasterSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="sm_miky@gmail.com"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="0a2aeb7885e668e6f80a8187cf4eec85"/>
              <!--  <entry key="process.encryptionKeyFile" value="D:\Apex Dataloader\samples\conf\sample.key"/>-->
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>                          
               
                <entry key="dataAccess.type" value="databaseRead"/>
                <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>
            </map>
        </property>
    </bean>
 </beans>
   

when i run my above file   I am getting following error.

:\Apex Dataloader\bin>process conf accountMasterProcess
2011-08-29 12:14:34,058 INFO  [main] controller.Controller initLog (Controller.j
ava:367) - The log has been initialized
2011-08-29 12:14:34,101 INFO  [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:78) - Loading process configuration from config file: D:\Apex Data
loader\bin\conf\process-conf.xml
2011-08-29 12:14:34,231 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file
 [D:\Apex Dataloader\bin\conf\process-conf.xml]
2011-08-29 12:14:34,325 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:66) - JDK 1.4+ collections available
2011-08-29 12:14:34,372 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:71) - Commons Collections 3.x available
2011-08-29 12:14:34,938 INFO  [accountMasterProcess] controller.Controller initC
onfig (Controller.java:328) - The controller config has been initialized
2011-08-29 12:14:34,948 INFO  [accountMasterProcess] process.ProcessRunner run (
ProcessRunner.java:90) - Initializing process engine
2011-08-29 12:14:34,949 INFO  [accountMasterProcess] process.ProcessRunner run (
ProcessRunner.java:93) - Loading parameters
2011-08-29 12:14:38,184 INFO  [accountMasterProcess] config.LastRun load (LastRu
n.java:101) - Last run info will be saved in file: D:\Apex Dataloader\bin\conf\a
ccountMasterProcess_lastRun.properties
2011-08-29 12:14:38,208 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:211) - Unable to run process accountMasterProcess
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const cl
ass com.salesforce.dataloader.action.OperationInfo.
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:136)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: java.lang.IllegalArgumentException: No enum const class com.salesforc
e.dataloader.action.OperationInfo.
        at java.lang.Enum.valueOf(Enum.java:192)
        at com.salesforce.dataloader.config.Config.getEnum(Config.java:441)
        at com.salesforce.dataloader.config.Config.getOperationInfo(Config.java:
981)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:97)
        ... 2 more

plese some one help me

Hi ,

Is it possible to  use batch  job with scheduler .If its possible can some one send me one example.

HI,

 I want to push data using CLI.

Any wan tell me what is the value <entry key="sfdc.password">

is it only login pwd or pwd+security token.

after setting when i m running  i m getting  these exception

05:08:25,511 ERROR [accountMasterProcess] config.Config decryptProper
ty (Config.java:674) - Error loading parameter: sfdc.password of type: java.lang
.String
javax.crypto.BadPaddingException: Given final block not properly padded
        at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)
        at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA12275)
        at javax.crypto.Cipher.doFinal(DashoA12275)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(Encry
ptionUtil.java:197)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
68)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:620)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:646)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:94)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
2011-08-26 05:08:25,511 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:211) - Unable to run process accountMasterProcess
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadExc
eption: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:136)
        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.ParameterLoadException: Error loa
ding parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
75)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:620)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:646)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:94)
        ... 2 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padd
ed
        at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)
        at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA12275)
        at javax.crypto.Cipher.doFinal(DashoA12275)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(Encry
ptionUtil.java:197)

Can any one let me know. bit urgent  :smileyindifferent:

        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
68)

I have a page contating various textboxes,
in one of the textbox I enter a value and perform search .
On the basis of search others textboxes should get filled withe respective searched data
means   I want to display the searched data in textbox not in the form of a table .Is it possible in salesforce.Please reply urgently required.

Hi I am getting the following  exception when I  try to run a test class.

I just remove the key based in condition from Map

So how to deal with this.

System.FinalException: Cannot modify a collection while it is being iterated

plz plz  reply   any one

How to  iterate through map

Map<Date, List<String>>  m1=new Map <Date, List<String>>();

I had the list ,now how to papulate list inside the map..

How to do this....bit urgent...

Thanks

Hi Its me again....

In orcle  inside one procedure  we are calling  another 3 procedure.....

How to do this thing in apex.

example..

1st procedure.Get_date procedure -- select sysdate from Dual.

2nd.prcedure. select  id,Name, from  account;

                             it will invoke the  1st procedure.

how to doit in apex coding

Hi My requirement is like this,

First get all  the account  which are created  last 7 days.

Create new contact if  they are not having contact. address from contact

Then  shedule that  in hourly basis....

How to dothat..

Please let me know ......It would be a great help for me.....

Hi,

I am New To  apex coding.

Can any body told me how to get the record count of  an object (accounts)  using Apex coding .

Its bit urgent.

Please Please suggest any answer

Hi,

Please some one let me know for apex scheduler with sample codeapex

Hi,

Please some one let me know for apex scheduler with sample codeapex

Hi All,

I am getting the below error  in class while developing visualforcepage for   page reference. Please correct me 

System.QueryException: List has no rows for assignment to SObject 

Class.MyCustomController.<init>: line 4, column

visualforce page code:

<apex:page controller="MyCustomController" tabStyle="Account" >
<apex:form >
<apex:pageBlock title="Accountdetails">
<apex:pageBlockSection title="AccountInformation" collapsible="true">
<apex:inputfield value="{!Account.Name}"/>
<apex:inputfield value="{!Account.Phone}"/>
<apex:inputfield value="{!Account.Industry}"/>
<apex:inputfield value="{!Account.Rating}"/>
<apex:inputfield value="{!Account.Website}"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Accountdetails" collapsible="true">
<apex:inputfield value="{!Account.BillingCity}"/>
<apex:inputfield value="{!Account.billingCountry}"/>
<apex:inputfield value="{!Account.Shippingcity}"/>
<apex:inputfield value="{!Account.shippingCountry}"/>
<apex:inputfield value="{!Account.Annualrevenue}"/>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

class

public class MyCustomController {
public Account acc;
public MyCustomController(){
acc=[select name,id,phone,industry,website,rating,BillingCity,BillingCountry,
ShippingCity,ShippingCountry,AnnualRevenue from Account where id=:Apexpages.currentPage().getParameters().get('id')];

}
public Account getAccount() {
return acc;
}
public PageReference saveMethod()
{
update acc;
PageReference pf=new apexPages.StandardController(acc).view();
return pf;
}
}

Hi ,

Any one tell me  how to  track the time during send the outbound message using Apex to othersystem from SFDC for Intigration

plz let me know :)

HI,

Can any one let me know  how to  display  data  in XML  in form of outbound message.

Also use wsdl.

I seem to be having an issue with the Encrypt or decrypt portion of the password process. From what i read on the return from command prompt, it knows the first two characters in my password and decrypts it properly ("Sh") but it seems to have a problem with something after this point??? Or i could be completely crazy...

Might anyone be able to shed some light? Did i encrypt wrong? Is it recquired to have a key file? If so, where am i supposed to place it?

Any help would be appreciated.

834 [main] FATAL com.salesforce.dataloader.process.ProcessRunner  - Unable to ru
n process UofUAccountExtractToCSV
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadExc
eption: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:136)
        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.ParameterLoadException: Error loa
ding parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
83)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:620)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:646)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:94)
        ... 2 more
Caused by: java.lang.NumberFormatException: For input string: "Sh"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
        at java.lang.Integer.parseInt(Integer.java:447)
        at java.lang.Integer.valueOf(Integer.java:526)
        at java.lang.Integer.decode(Integer.java:919)
        at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(Encrypt
ionUtil.java:58)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(Encry
ptionUtil.java:194)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
68)

 process-conf.xml looks like this:

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

    <bean id="UofUAccountExtractToCSV"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
      <description>Gets the UofU accounts with clients and exports to CSV"</description>
        <property name="name" value="UofUAccountExtractToCSV"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="c:\Salesforce\DataLoader\Resources\Logs\SFDCdebug.log"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="sfdcusername"/>
		<entry key="sfdc.password" value="value returned by encrypt.bat -e"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Client__c"/>
                <entry key="sfdc.extractionSOQL" value="SELECT c.LIS_Account_Name__c, c.Entity_Code__c,c.ClientID_Ext_Id__c, c.Phone_and_Extension__c, c.Secured_Fax__c, c.Comments__c,c.Street_Address__c, c.City__c, c.State__c, c.account__r.name from client__c c where c.account__r.recordtypeid ='012C0000000Q7lIIAS'"/>
                <entry key="process.operation" value="extract"/>
                <entry key="process.mappingFile" value="c:\Salesforce\DataLoader\Resources\Mapping\UofUAccountExtractMap.sdl"/>
                <entry key="process.outputError" value="c:\Salesforce\DataLoader\Resources\Logs\LastOperationError.csv"/>
    		<entry key="dataAccess.writeUTF8" value="true"/>            
		<entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="c:\Salesforce\DataLoader\Resources\Data\UofUSFDCExtract.csv"/>
            </map>
        </property>
    </bean>
</beans>

I have a page contating various textboxes,
in one of the textbox I enter a value and perform search .
On the basis of search others textboxes should get filled withe respective searched data
means   I want to display the searched data in textbox not in the form of a table .Is it possible in salesforce.Please reply urgently required.

I'm getting following error frequently (not always) when trying to Upload Bulk Data using  Data Loader Command line script.

Failed to send request to https://www.salesforce.com/services/Soap/u/21.0/services/Soap/u/21.0 at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:117)

Hi,

We use SalesForce to maintain Account and Contact details, and keep our other internal systems in sync by using Outbound Messages fired on create / modify.  These messages are monitored by an internal process to fetch the data out of SalesForce via the API and update internally.

The problem we have is that we want a delete in SalesForce to flag the record as deleted in our internal systems.

The issues we're hitting are:

Workflows aren't fired on delete (doesn't count as a modify?)

Can't manually trigger an Outbound Message, say in a before delete trigger (this is my assumption, please advise if wrong)

Even if we did manually trigger an OM, once the object is deleted, my testing shows it is removed from the OM queue if not already delivered (=> unreliable)

So, from what I can see we have a couple of options:

1) Allow delete, but have an additional, scheduled process that scans SF looking for records deleted in the last x hours / minutes and update internal systems.

2) Implement some sort of Approval process for deletes, requiring the setting of a non-SF delete flag to tell our internal systems, before allowing delete after manual confirmation of the internal update.

Both of these are quite clunky given the existing processing of creation / updates.  Has anyone been here before?  Got a neat solution?

Cheers,

Neil

Hi I am getting the following  exception when I  try to run a test class.

I just remove the key based in condition from Map

So how to deal with this.

System.FinalException: Cannot modify a collection while it is being iterated

plz plz  reply   any one

Hello All

Please help me in this issue. When i am tring to load data in salesforce.com through Command line (DataLoader), its showing me this below error, which is related to class. I am using the DataLoader version 20.0::

...........

C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin>process ..\conf Insert
RecordsinAccount
2010-10-01 12:42:24,887 INFO  [main] controller.Controller initLog (Controller.j
ava:375) - The log has been initialized
2010-10-01 12:42:24,887 INFO  [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:78) - Loading process configuration from config file: C:\Program F
iles\salesforce.com\Apex Data Loader 20.0\bin\..\conf\process-conf.xml
2010-10-01 12:42:24,966 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file
 [C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin\..\conf\process-conf
.xml]
2010-10-01 12:42:25,012 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:66) - JDK 1.4+ collections available
2010-10-01 12:42:25,028 INFO  [main] core.CollectionFactory <clinit> (Collection
Factory.java:71) - Commons Collections 3.x available
2010-10-01 12:42:25,106 INFO  [InsertAccount] controller.Controller initConfig (
Controller.java:336) - The controller config has been initialized
2010-10-01 12:42:25,122 INFO  [InsertAccount] process.ProcessRunner run (Process
Runner.java:91) - Initializing process engine
2010-10-01 12:42:25,122 INFO  [InsertAccount] process.ProcessRunner run (Process
Runner.java:94) - Loading parameters
2010-10-01 12:42:26,481 INFO  [InsertAccount] config.LastRun load (LastRun.java:
101) - Last run info will be saved in file: C:\Program Files\salesforce.com\Apex
 Data Loader 20.0\bin\..\conf\InsertAccount_lastRun.properties
2010-10-01 12:42:26,497 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:212) - Unable to run process InsertAccount
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const cl
ass com.salesforce.dataloader.action.OperationInfo.
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:137)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:75)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:227)
Caused by: java.lang.IllegalArgumentException: No enum const class com.salesforc
e.dataloader.action.OperationInfo.
        at java.lang.Enum.valueOf(Enum.java:192)
        at com.salesforce.dataloader.config.Config.getEnum(Config.java:439)
        at com.salesforce.dataloader.config.Config.getOperationInfo(Config.java:
975)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:98)
        ... 2 more
C:\Program Files\salesforce.com\Apex Data Loader 20.0\bin>

...........................

The below is my process-conf.xml:::

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans default-lazy-init="false" default-autowire="no" default-dependency-check="none">
   
  <bean
      class="com.salesforce.dataloader.process.ProcessRunner"
      singleton="false"  lazy-init="default" autowire="default" dependency-check="default">
    <description> Insert Records in Account Object from CSV file through Command Line </description>
 
  <property value="InsertAccount" />
  <property>
    <map>
      
        <entry key="sfdc.connectionTimeoutSecs" value="60"/>
        <entry key="sfdc.username" value="mohit.bansal@hcl.in.test1" />
        <entry key="sfdc.password" value="9fbaf20cfb2a22e8ad8a3b39836bc71c" />
        <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\KeyFile.txt"  />
        <entry key="process.outputSuccess" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\SuccessFile.csv" />
        <entry key="sfdc.loadBatchSize" value="100" />
        <entry key="dataAccessName" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\dumpydata1.csv" />
        <entry key="process.useEuropeanDates" value="true" />
        <entry key="dataAccess.readBatchSize" value="100" />
        <entry key="sfdc.maxRetries" value="3" />
        <entry key="process.outputError" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\ErrorFile.csv" />
        <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
        <entry key="dataAccess.Type" value="csvRead" />
        <entry key="process.Operation" value="insert" />
        <entry key="sfdc.extractionRequestSize" value="200" />
        <entry key="truncateFields" value="true" />
        <entry key="sfdc.entity" value="Account" />
        <entry key="sfdc.enableRetries" value="true" />
        <entry key="sfdc.timeoutsecs" value="1000" />
        <entry key="process.enableLastRunOutput" value="true" />
        <entry key="process.mappingfile" value="C:\Program Files\salesforce.com\Apex Data Loader 20.0\conf\AccountMapping.sdl" />
   </map>
  
  </property>

 </bean> 

</beans>

Please let me know, why i am getting this error.

I have a Salesforce Site that uses Customer Portal as the authentication mechanism.  For the life of me, I cannot get the Site to stay in HTTPS after the initial login.  I am entering the site using the HTTPS force.com URL.  I login successfully, but I am redirected to the site's homepage, but it's put to HTTP.  Why?

Once logged into the site and manually change the URL to HTTPS, I am able to keep it on HTTPS pages as I do things.  It's just the login that redirects me out of HTTPS and back to HTTP.

Ideas?

hi,

I am trying to Load data from Salesforce into SQL Server 2005 using command line. Here are my settings for SQL Server in database-conf file

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

        <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
        <property name="url" value="jdbc:sqlserver://MyServerName:1433:databasename=MyDatabase;"/>

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

I have installed MSSQL Server jdbc2.0 on my machine at this location

"C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_2.0\enu"

When I run the integration it gives me following error.

**************************************

2438 [AccountExtractDB] ERROR com.salesforce.lexiloader.dao.database.DatabaseCon
text  - Database error encountered during connecting for database configuration:
 DBAccountInsert.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlse
rver.jdbc.SQLServerDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.m
icrosoft.sqlserver.jdbc.SQLServerDriver'
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:766)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:540)
        at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:89)
        at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnectio
n(DatabaseContext.java:81)
        at com.salesforce.lexiloader.dao.database.DatabaseWriter.checkConnection
(DatabaseWriter.java:92)
        at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:121)
        at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSer
verDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:760)
        ... 6 more
2485 [AccountExtractDB] FATAL com.salesforce.lexiloader.process.ProcessRunner  -
 Database error encountered during connecting for database configuration: DBAcco
untInsert.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jd
bc.SQLServerDriver'.
Exception in thread "main" java.lang.RuntimeException: com.salesforce.lexiloader
.exception.DataAccessObjectInitializationException: Database error encountered d
uring connecting for database configuration: DBAccountInsert.  Sql error: Cannot
 load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
        at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:154)
        at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: com.salesforce.lexiloader.exception.DataAccessObjectInitializationExc
eption: Database error encountered during connecting for database configuration:
 DBAccountInsert.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlse
rver.jdbc.SQLServerDriver'.
        at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:97)
        at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnectio
n(DatabaseContext.java:81)
        at com.salesforce.lexiloader.dao.database.DatabaseWriter.checkConnection
(DatabaseWriter.java:92)
        at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:121)
        ... 1 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver c
lass 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:766)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:540)
        at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:89)
        ... 4 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSer
verDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:760)
        ... 6 more
Press any key to continue . . .

**************************************

Expecting a positive response from this forum :smileyhappy:

Nilove

Hello Friends,

My requirement is that, i need to generate an XML out of my VF page. For this, i specified the "ContentType="application/xml" on my page header and then included the DOCTYPE tags to generate a standard XML out of it.

But somehow, i am not able to get the XML styling in the generated page and it shows me the shole page elements intead of just showing me the data.

Can you please let me know where i am going wrong or is this possible in VF? Pasting my VF page code below:

<apex:page cache="true" Controller="TestController" contentType="application/xml" showHeader="false">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/html" xml:lang="en" lang="en">
<body>
<apex:form >
<apex:pageblock id="exportDocs">
<apex:pageBlockTable value="{!exportValues}" var="actual">
<apex:column headerValue="Id" value="{!actual.Id}"/>
<apex:column headerValue="Act Name" value="{!actual.Name}"/>
<apex:column headerValue="MType" value="{!actual.A_Type__c}"/>
<apex:column headerValue="Country" value="{!actual.Country__c}"/>
<apex:column headerValue="B" value="{!actual.B__c}"/>
<apex:column headerValue="Actual C" value="{!actual.C__c}"/>
<apex:column headerValue="Actual G" value="{!actual.G__c}"/>
<apex:column headerValue="Actual I" value="{!actual.I__c}"/>
</apex:pageBlockTable>
</apex:pageblock>
</apex:form>
</body>
</html>
</apex:page>

Any help/guidance would be highly appreciated!!

Many Thanks,