We are looking for an affordable web based training on more advanced salesforce funcationality - workflows, validation rules, etc. The salesforce official training is very expensive and we are exploring other alternatives.

Does anyone have any training options that would be web based that are somewhat affordable?  I look forward to hearing all of your ideas. :robothappy:

We were supplied a class by a vendor that works successfully on our sandbox. This was created by generating the WSDL.  I am having all sorts of trouble sending this to production as this dramatically drops our code coverage.  The bulk of the class is just defining variables. 

Is there a way that anyone has come across to test these string declarations? 

If this helps, this is called by another class that sends the information to web service. Obviously, the other class that calls this fails as well.

// THIS IS THE CLASS
public class webserviceEvo {
    public class updateTaskByCaptureId_element {
        public String captureId;
        public String channel;
        public String category;
        public DateTime activationDateTime;
        public DateTime dueDateTime;
        public DateTime expirationDateTime;
        public DateTime reprioritizeDateTime;
        public Integer businessValue;
        public Integer priority;
        public brokerGtlEvo.TaskExt ext;
        public webserviceCaptureGtlEvo.string2stringMap data;
        public String reason;
        public String actor;
        private String[] captureId_type_info = new String[]{'captureId','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] channel_type_info = new String[]{'channel','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] category_type_info = new String[]{'category','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] activationDateTime_type_info = new String[]{'activationDateTime','http://www.w3.org/2001/XMLSchema','dateTime','1','1','true'};
        private String[] dueDateTime_type_info = new String[]{'dueDateTime','http://www.w3.org/2001/XMLSchema','dateTime','1','1','true'};
        private String[] expirationDateTime_type_info = new String[]{'expirationDateTime','http://www.w3.org/2001/XMLSchema','dateTime','1','1','true'};
        private String[] reprioritizeDateTime_type_info = new String[]{'reprioritizeDateTime','http://www.w3.org/2001/XMLSchema','dateTime','1','1','true'};
        private String[] businessValue_type_info = new String[]{'businessValue','http://www.w3.org/2001/XMLSchema','int','1','1','true'};
        private String[] priority_type_info = new String[]{'priority','http://www.w3.org/2001/XMLSchema','int','1','1','true'};
        private String[] ext_type_info = new String[]{'ext','http://broker.gtl.evo','TaskExt','1','1','true'};
        private String[] data_type_info = new String[]{'data','http://webservice.capture.gtl.evo','string2stringMap','1','1','true'};
        private String[] reason_type_info = new String[]{'reason','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] actor_type_info = new String[]{'actor','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] apex_schema_type_info = new String[]{'http://webservice.capture.gtl.evo','true','true'};
        private String[] field_order_type_info = new String[]{'captureId','channel','category','activationDateTime','dueDateTime','expirationDateTime','reprioritizeDateTime','businessValue','priority','ext','data','reason','actor'};
    }
    
 public class completeTaskByBrokerId_element {
        public Long brokerId;
        public String reason;
        public String actor;
        public DateTime completedDateTime;
        private String[] brokerId_type_info = new String[]{'brokerId','http://www.w3.org/2001/XMLSchema','long','1','1','true'};
        private String[] reason_type_info = new String[]{'reason','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] actor_type_info = new String[]{'actor','http://www.w3.org/2001/XMLSchema','string','1','1','true'};
        private String[] completedDateTime_type_info = new String[]{'completedDateTime','http://www.w3.org/2001/XMLSchema','dateTime','1','1','true'};
        private String[] apex_schema_type_info = new String[]{'http://webservice.capture.gtl.evo','true','true'};
        private String[] field_order_type_info = new String[]{'brokerId','reason','actor','completedDateTime'};
    }

I am trying to get my error message on a validation rule to look like the following:

CONTACT ALERT 

The contact information entered have the email domain of a competitor!! 

Please transfer caller to the Broker Queue: x8742

I have tried unsuccesfully to do this by adding HTML elements (<br> tags):

CONTACT ALERT <br>
The contact information entered have the email domain of a competitor!! <br>
Please transfer caller to the Broker Queue: x8742

This seems to not recognize what I am doing and displaying this all in one row:

CONTACT ALERT <br> The contact information entered have the email domain of a competitor!! <br> Please transfer caller to the Broker Queue: x8742

Does anyone have any advise on how I have the error message within the validateion rule display a message with line breaks / carriage returns? Thanks!

I am trying to create a SOQL Statement to get data from the last 30 days

For example, I would do this on SQL Server by writing:

Select * from case where createddate > getdate -30

Is there a similar way to keep this in place with SOQL.

I have tried GetDate()-30, Today()-30 but no luck.

I am looking to parse the email address from the user table to get the first part of the address. For example, if an email address is bgates@microsoft.com, I want to just get the bgates.  I can use substring to get the first part but don't know what value to put in where this would end. 

If this was in Excel, I would do the following =mid(email, 0, find(@)-1)

Is there a similar way in which I could utilize the find() functionality in excel and apply this in the trigger? Thanks.

Just now, i m developing the tool which can search some data from salesforce objects data by VBA.

I wanna join some tables, but we cannot join some object by SOQL.

So, I try to write the code like below

sid = "SELECT companyCode__r.Name, companyName__c FROM PaymentRequest__c"
    Set qr = sfApi.query(sid, False)
    For Each v In qr
        Set s = v
        Set sop = s.GetJoinResults("companyMaster__c")
        Worksheets("test").Range("A1").Cells(irow, 2 + (ci + ci - 1)).value = s("companyName__c ")
        Worksheets("test").Range("A1").Cells(irow, 2 + (ci * 2)).value = sop("Name")
        ci = ci + 1
        irow = irow + 1
 Next

companyMaster__c is refered from PaymentRequest__c  by companyCode__c.

But i couldnt get the value of "companyCode__r.Name", and get error message like "Did not set with block variables".

How do I get companyCode__r.Name value.

Is anyone figure out this?

Please help me...

To whom it may concern

I have recently downloaded the Office Toolkit 4.0  from  http://code.google.com/p/excel-connector/

There is no mention on where to download the XLA file ( sforce_connect.xla)

Where does one get this fiel? It appears not to have come with the Office Toolkit install. It also states that one has to configure the Office Toolkit. How does one do this? I can't find any documentation regarding this.

Regards

Stephen

I've setup several template emails that are the custom format.  I'd like to be able to choose this template from a lead and edit before sending.  Right now when I click the custom template it doesn't allow me to edit like I can when the template is Text or HTML (letterhead). 

I really just want to send an HTML email without a letterhead but that isn't an option and I don't want to send plain text. 

Is there a way to do this?   Any help would be great!

Hi,

any one knows how to copy data from one sandbox to other sandbox

I need to copy account,products, opportunity data to other sandbox.

please post me how to do that .

Thank you.

Hi,

  I have a list of account id's in excel and i want to use excel connect query table data to get a bunch of other columns from account table corresponding to the account id's i have. I tried using refresh

This is what I have in excel

    Account Account ID Account Refresh         

    Account ID Account ID Account Name Owner ID

0018000000dglatAAA 

0018000000dgHKLAA2

0018000000dgGXjAAM 

I get the below error

Salesforce: Query()

invalid Range, missing data type, or other error,

type is Account

Object variable or With block variable not set

I am new to using Excel connector. Any help is appreciated.

Thanks

On Friday night, over 400 records were deleted from Salesforce at the exact same time. Using SOQLXplorer, I can see the records when querying for deleted records and they all were deleted at the same time by the same username after hours. However they did not delete anything.

This occurred on a production install for a client and their recycling bin has not been emptied but the records do not show up in the recycling bin.

Is there any way to revert these deleted records? Apex undelete() doesn't work because they are not visible in the recycling bin.

I've put in a case with Salesforce but have not yet received a reply. The records deleted in question are used for tracking individuals and their health insurance, which as of Friday, the system believes they do not have insurance so this is a very important issue.

I have used SOQLXplorer to export the records to a csv, so that if i can't undelete them, I can at least reimport them. This will however cause the records to have new salesforce IDs, which I want to avoid if possible.

Any suggestions or alternatives?

Thank you.

Anybody knows who I should contact to enable that feature for my account : thomas.lai@fil.com?

Many thanks.

Atalantis

I am trying to create a SOQL Statement to get data from the last 30 days

For example, I would do this on SQL Server by writing:

Select * from case where createddate > getdate -30

Is there a similar way to keep this in place with SOQL.

I have tried GetDate()-30, Today()-30 but no luck.

I am getting the following error when I try to log in through the excel connector:

Error Generated by Request: Invalid username, password, security token or user locked out.  Exception code: 5078. 

I used excel connector for the first time a couple months ago.  It worked fine the first time.

Thank you!

Diane

I am looking to parse the email address from the user table to get the first part of the address. For example, if an email address is bgates@microsoft.com, I want to just get the bgates.  I can use substring to get the first part but don't know what value to put in where this would end. 

If this was in Excel, I would do the following =mid(email, 0, find(@)-1)

Is there a similar way in which I could utilize the find() functionality in excel and apply this in the trigger? Thanks.