• Rich13
  • NEWBIE
  • 10 Points
  • Member since 2005

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 17
    Questions
  • 10
    Replies
Can some one suggest a way/workaround for this scenario.

Our email marketing team sends sales emails to contacts (leads) in our database (SFDC) with the obective to get response from them. The email messages are categorized under multiple themes e.g. 'A', 'B', 'C' etc. Based on prospect's response individual email marketing rep. has to update the SFDC record as Cold or Warm or Hot.

If the prospect responds to 'A' message SFDC record should be updated for that message or theme only. So a prospect response could be a cold or warm or hot for message 'A' or 'B' or 'C'.
I thought of using 3 checkboxes as Cold, Warm, Hot for message A, 3 more checkboxes for message B. As I am going to have 8 types of messages I need to create 8*3=24 checkboxes.

I don't feel this is the way. Can some one suggest an approach for this, so that I can pull reports for type of response for the respective message type.

Thank you
Hi,

I would like create a report with SFDC links to the respective records as a seperate column. How can I creat such kind of report?

Please suggest. Thank you
Hi,

I am trying to extract campaing member record IDs through command line batch process. But I am getting the following error though i made sure the password, security token and encrption key are accurate.

Please let me know what would went wrong. Below is the error.

2014-02-15 01:47:18,117 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process csvCampaignMemberExtractProcess
java.lang.RuntimeException: Invalid username, password, security token; or user locked out.


Thank you.
Hi ,

I am trying to create a batch process to extract record IDs from CampaignMember Object from Command line. But it throwing the folliwng errors. Could you please me on this.

2014-01-27 06:21:39,237 INFO  [main] controller.Controller initLog (Controller.java:388) - The log has been initialized
2014-01-27 06:21:39,244 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\users\
stanikanti\desktop\test2\process-conf.xml
2014-01-27 06:21:39,360 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from fi
le [C:\users\stanikanti\desktop\test2\process-conf.xml]
2014-01-27 06:21:39,398 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: campaignMemberExtract configura
tion from config file: C:\users\stanikanti\desktop\test2\process-conf.xml
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'campaignMemberExtract' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
2014-01-27 06:21:39,401 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: campaignMemberExtract configuration from config file: C:\users\stan
ikanti\desktop\test2\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'campaignMemberExtract' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more
Hi ,

I am trying to create a batch file with scheduler to periodically delete particular category of tasks create in our lead records. I am understanding and trying to run a sample batch file given in the Data loader guide - command line quick start. But it is throwing lot of errors and I don't understand what they are. Can any one help me what's going wrong. Here are the errors.

2014-01-20 23:08:21,518 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:96) - Error loading process: accountInsert configuration from
config file: C:\program files\salesforce.com\data loader\bin\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\program files\salesforce.com\data loader\bin\proc
ess-conf.xml]; nested exception is java.io.FileNotFoundException: C:\program fil
es\salesforce.com\data loader\bin\process-conf.xml (The system cannot find the f
ile specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:78)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: java.io.FileNotFoundException: C:\program files\salesforce.com\data l
oader\bin\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more
2014-01-20 23:08:21,534 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: accountInsert configuration from config file: C:\program files\salesf
orce.com\data loader\bin\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOExc
eption parsing XML document from file [C:\program files\salesforce.com\data load
er\bin\process-conf.xml]; nested exception is java.io.FileNotFoundException: C:\
program files\salesforce.com\data loader\bin\process-conf.xml (The system cannot
find the file specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:78)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        ... 3 more
Caused by: java.io.FileNotFoundException: C:\program files\salesforce.com\data l
oader\bin\process-conf.xml (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more

Hi ,

 

I am implementing the lead scoring framework in SFDC, as part of this process I have created a formula field to calculate the location rating. Formula as below:

IF( 

(

Corporate_Headquarters__c  = "AL" ||

Corporate_Headquarters__c  = "HI" ||

Corporate_Headquarters__c  = "ID" ||

Corporate_Headquarters__c  = "LA" ||

Corporate_Headquarters__c  = "MT")

,15,0)

 

In this way I have 3 blocks for all the 51 United states with different scores (15,20,25). (Not Copying the complete formula here as it is big and for 51 states) . When I checked it for syntax its show the green line with no Syntax error and compiled size as about 2000 characters.

 

But when I try to save, it is throwing the error as " Error: Invalid Data. Review all error messages below to correct your data.
Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (5,593 characters). Maximum size is 5,000 characters (Related field: Formula)"

 

I expeirmented by creating 3 formula fields and put the 3 blocks and finally added all these 3 forumla fields putting in an another final Formula filed. But still it is throwing the same error.

 

I tried this logic with CASE function also, but same error, even more characters.

 

Please any body guide me on this.

 

Thank You.

 

 

 

 

Hi,

I was trying to use the upsert function on DataLoader, but there was no external ID field defined on the Lead Object. So SFDC was taking Lead ID (machine generated) as external ID which will not serve the purpose of upsert.

With suggestions from group friends I have defined a custom filed as Email type, Unique and External ID. Created a workflow to update this field with the standard email field via workflow and ran a record update on all lead records to invoke the workflow. Now the Custom Email field is a replica of Standard Email field.

But when I started using Data Loader Upsert funcation it is still showing Lead ID as the only External ID defined. No trace of Custom Email filed created as unique and extenal ID type.

Please advise.

Thanks

We have a lead object, and is associated with Releted lists (Task, Events) and each lead record displays Activity History with list of Tasks. We use Marketing automation Software that logs a record for each email it sends.

I have a couple of questions here -

1. I want to update the  lead status field (Picklist) as Disqualified automatically when a task (Activity) is logged by our marketing software with Subject field "bounced". I See the Task Object fields and Subject is one of them.

I tried Workflow rule creating individually for Lead and Task, but none of them have a common field to link and update the field i am looking for.

2. In the same manner as above, I want to update a custom fied in the lead with last email sent date which i can only pull from Tasks (activities) logged in Activity History of that lead record. I tried with Workflow rule and Fied update actions but having the same problem as above.

 

I have tried to creat a custome object to define Parent-Child, Many-Many relationship as I read in SFDC help. But I lost my way and totally got confused.

 

I am a novice at coding. Does it require to develop Apexclass etc? Kindly help me on this. Thanks