So, I can't get this to evaluate the way I expect it to.

For some reason, the record type id "0121R000000SeOsQAK" isn't showing 777, and I'm not sure why.

I also tried NOT(RecordTypeId = "0121R000000SeOsQAK") in the second and third IF statements, and it doesn't work either.
 

IF(RecordTypeId = "0121R000000SeOsQAK",777,
    IF(AND(RecordTypeId != "0121R000000SeOsQAK", CONTAINS(Legacy_ID__c, 'SD')=TRUE), PL_Deliverable_Type__r.Days__c,
        IF(AND(RecordTypeId != "0121R000000SeOsQAK",Deliverable_End_Date__c < DATE(2021,02,02)),Legacy_Days__c,
				PL_Deliverable_Type__r.Days__c)
			))

 

I'm trying to create a version of the Campaign Influence Report.

What I basically want is, for a given Campaign, I want to get a list of distinct accounts that are tied to the contacts in the Campaign Members. From that list, I want to get all of the open opps for that account as well as all of the opps that have closed since the start of the campaign.

The probelm I'm having is that if the Campaign Members contain, for example, 3 contacts from the same account, and that account has 2 qualifiying opps, I only want to see 2 opps, not 2x3.  I basically don't care about the contacts, I just want the opps.

I could do this easily in SQL, but I'm having troubles building this in SOQL or in Reports.

Any thoughts??

thanks!


 

I need a field on the Account layout that will aggregate specific types of Service Contracts. In other words if an account has 20 contracts, 16 of which are active, and of those 16 active contracts, there are 6 of them of a particular type, I'd like the field to say 6.

In pseudo soql code, something like like " select count(quantity) from service_Contracts where item_category='Licenses' and today() between start_date and end_date and account_id = &account_id"  where &account_id is the account_id of the account being viewed.

Is there an easy way to do this?

thanks

I've verified the JAVA_PATH is correct as an environment variable.

I'm running encrypt.bat from the "D:\Program Files\salesforce.com\Data Loader\bin" directory, but I just a one line output of "The system cannot find the path specified."

I have accounts in Salesforce that have a field that contains the ID of that same account in our Oracle ERP system.

I would like to be able to import Service Contracts and tie them to the correct account, but the only information that I have available to me in the extract from Oracle is the Oracle ID, not the Salesforce Id.

Is there a way to accomplish this? (I want to automate this, so getting the Salesforce ID and performing Vlookups, etc. isn't a workable solution).

Thanks for any help!!

 

I've created a conf xml file, done the encrypting of the password, and I'm ready to run process.bat 

However, when I run it using the command: "C:\users\JJ\AppData\Local\salesforce.com\Data Loader\samples\conf\" auto_account_process-conf

I get the following:
C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\bin>process.bat "C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\samples\conf\" auto_accoun
_process-conf
Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="Sun Microsystems Inc."
Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)
where options include:
    -d32          use a 32-bit data model if available
    -d64          use a 64-bit data model if available
    -client       to select the "client" VM
    -server       to select the "server" VM
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose:[class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  Warning: this feature is deprecated and will be removed
                  in a future release.
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -no-jre-restrict-search
                  Warning: this feature is deprecated and will be removed
                  in a future release.
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions with specified granularity
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions with specified granularity
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                  see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument
    -splash:<imagepath>
                  show splash screen with specified image
See http://www.oracle.com/technetwork/java/javase/documentation/index.html for more details.
C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\bin>
 

So, I can't get this to evaluate the way I expect it to.

For some reason, the record type id "0121R000000SeOsQAK" isn't showing 777, and I'm not sure why.

I also tried NOT(RecordTypeId = "0121R000000SeOsQAK") in the second and third IF statements, and it doesn't work either.
 

IF(RecordTypeId = "0121R000000SeOsQAK",777,
    IF(AND(RecordTypeId != "0121R000000SeOsQAK", CONTAINS(Legacy_ID__c, 'SD')=TRUE), PL_Deliverable_Type__r.Days__c,
        IF(AND(RecordTypeId != "0121R000000SeOsQAK",Deliverable_End_Date__c < DATE(2021,02,02)),Legacy_Days__c,
				PL_Deliverable_Type__r.Days__c)
			))

 

I have accounts in Salesforce that have a field that contains the ID of that same account in our Oracle ERP system.

I would like to be able to import Service Contracts and tie them to the correct account, but the only information that I have available to me in the extract from Oracle is the Oracle ID, not the Salesforce Id.

Is there a way to accomplish this? (I want to automate this, so getting the Salesforce ID and performing Vlookups, etc. isn't a workable solution).

Thanks for any help!!

 

I've created a conf xml file, done the encrypting of the password, and I'm ready to run process.bat 

However, when I run it using the command: "C:\users\JJ\AppData\Local\salesforce.com\Data Loader\samples\conf\" auto_account_process-conf

I get the following:
C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\bin>process.bat "C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\samples\conf\" auto_accoun
_process-conf
Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="Sun Microsystems Inc."
Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)
where options include:
    -d32          use a 32-bit data model if available
    -d64          use a 64-bit data model if available
    -client       to select the "client" VM
    -server       to select the "server" VM
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose:[class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  Warning: this feature is deprecated and will be removed
                  in a future release.
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -no-jre-restrict-search
                  Warning: this feature is deprecated and will be removed
                  in a future release.
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions with specified granularity
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions with specified granularity
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                  see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument
    -splash:<imagepath>
                  show splash screen with specified image
See http://www.oracle.com/technetwork/java/javase/documentation/index.html for more details.
C:\Users\JJ\AppData\Local\salesforce.com\Data Loader\bin>