-
ChatterFeed
-
1Best Answers
-
0Likes Received
-
0Likes Given
-
34Questions
-
65Replies
Email to case issues
Hello,
We are running a email to case agent, behind our firewall, with around 12 support email addresses. The agent will look for new email every 5 minutes.
Sometimes we receive a lot of messages in one mailbox (with heavy attachments). Since it takes a few minutes to scan all those emails the other mailbox keep stacking up. It takes a few minutes or hours to get a normal flow of email in to salesforce.
We are thinking of splitting the email addresses in several email to case agents.
Does anyone have another solution we could try?
Thanks!
- MiguelGuerreiro
- April 26, 2010
- Like
- 0
- Continue reading or reply
several languages in the web form
Hello,
I have created a web form for an object. The field in this object are translated into several languages.
How can I, using one web form only, have it display several languages?
Thanks!
- MiguelGuerreiro
- April 09, 2010
- Like
- 0
- Continue reading or reply
Create a test class for trigger
Hello,
I have developed a trigger on Attachments. My idea is to update a case field when a new attachment is insert on a case. It works OK, not perfect.
I can't deploy it to production because I'm not able to create a test class for it... I tried but I'm only starting with Apex now. The code is below, can someone help me build a test class for it?
trigger NewAttachment on Attachment (before insert) {List<Case> CasesToUpdate = new List<Case>();for (Attachment t: Trigger.new){try{Case c = new Case(Id = t.ParentId);c.HasAttachments__c = true;CasesToUpdate.add(c);}catch (Exception e) {}}update CasesToUpdate;}//end
Thanks!
- MiguelGuerreiro
- March 31, 2010
- Like
- 0
- Continue reading or reply
CMSForce and web form
Hello,
I'm using CMSForce to create a web form for a custom object (which has a look up field for Contacts). Is there a way to automatically link the custom object to the correct contact when he saves the record in the web form? Maybe using his email address?
Thanks!
- MiguelGuerreiro
- March 24, 2010
- Like
- 0
- Continue reading or reply
web-to-anything app?
Hello,
Is there anything in appexchange to simply create HTML code for any kind of object (standard or custom)?
I've looked up without success but hopefully I'm missing something.
Miguel
- MiguelGuerreiro
- January 28, 2010
- Like
- 0
- Continue reading or reply
Trigger on CaseComment
hello,
im trying to create a trigger to prevent users from adding comments on closed cases.
this is my code:
trigger CloseComment on CaseComment (before insert) {
for (CaseComment t: Trigger.new)
{
Case c = new Case(Id = t.ParentId);
if(c.Status == 'Closed' && c.Process__c == 'Payroll')
{
t.addError(c.Process__c + 'case closed' + c.Status);
}
else
t.addError(c.Process__c + 'case open' + c.Status);
}
}
but i can't get the values of any case fields. I guess im missing something simple.
Any ideas?
- MiguelGuerreiro
- January 13, 2010
- Like
- 0
- Continue reading or reply
archive email messages
- MiguelGuerreiro
- January 11, 2010
- Like
- 0
- Continue reading or reply
Case Age In Business Hours
Hello,
Anyone using Case Age In Business Hours package from appexchange is having problems with Email2Case?
We're getting a lot of errors because of too many SQL queries...
Thank you for any help!
Log file:
2009-09-23 13:45:36,770 145373 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:0: CalculateBusinessHoursAges: execution of BeforeUpdate caused by: System.Exception: Too many SOQL queries: 21 Trigger.CalculateBusinessHoursAges: line 20, column 32 2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:1: CalculateBusinessHoursAges: execution of BeforeUpdate caused by: System.Exception: Too many SOQL queries: 21 Trigger.CalculateBusinessHoursAges: line 20, column 32 2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:2: CalculateBusinessHoursAges: execution of BeforeUpdate caused by: System.Exception: Too many SOQL queries: 21 Trigger.CalculateBusinessHoursAges: line 20, column 32 2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:3: CalculateBusinessHoursAges: execution of BeforeUpdate caused by: System.Exception: Too many SOQL queries: 21 Trigger.CalculateBusinessHoursAges: line 20, column 32 2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:4: CalculateBusinessHoursAges: execution of BeforeUpdate caused by: System.Exception: Too many SOQL queries: 21 Trigger.CalculateBusinessHoursAges: line 20, column 32 2009-09-23 13:45:36,792 145395 [Timer-0] INFO com.sforce.mail.GenericClient - Copying 5 messages to error mailbox 2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:0 ID=02s20000002VbynAAC Success=true 2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:1 ID=02s20000002VbyoAAC Success=true 2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:2 ID=02s20000002Vc2DAAS Success=true
The line that gives the error is:
for (CaseStatus status:[Select MasterLabel From CaseStatus where IsClosed=true]) { closedStatusSet.add(status.MasterLabel); }
- MiguelGuerreiro
- September 24, 2009
- Like
- 0
- Continue reading or reply
Case Age In Business Hours
Hello,
Anyone using Case Age In Business Hours package from appexchange is having problems with Email2Case?
We're getting a lot of errors because of too many SQL queries...
Thank you for any help!
2009-09-23 13:45:36,770 145373 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:0: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:1: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:2: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:3: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:4: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] INFO com.sforce.mail.GenericClient - Copying 5 messages to error mailbox
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:0 ID=02s20000002VbynAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:1 ID=02s20000002VbyoAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:2 ID=02s20000002Vc2DAAS Success=true
- MiguelGuerreiro
- September 23, 2009
- Like
- 0
- Continue reading or reply
Error on Contact Trigger
Hello,
I'm really new to Apex so I request once more the community help!
I've done this trigger below to prevent duplicete contacts (based on the email). Does anyone see a big flaw in it?
trigger PreventDuplicates on Contact (before insert, before update) { Contact[] contacts = [select Email,Id from Contact]; for(Contact c: Trigger.new) { for(Integer i = 0; i < contacts.size(); i++) { if(contacts[i].Email == c.Email) { c.Email.addError('Duplicated email address.'); } } } }
- MiguelGuerreiro
- August 11, 2009
- Like
- 0
- Continue reading or reply
Create link on trigger
Hello,
I've created a trigger to prevent duplicated entries on contacts. How can I additionally create a link (on the error message) to the existing contact?
Thanks!
- MiguelGuerreiro
- August 10, 2009
- Like
- 0
- Continue reading or reply
Trigger on Case - Error when Owner is a Queue
Hello,
I have a trigger (before insert, before update) to update some number fields. The field to update depends on the case owner role. This is the code that is getting the error:
for (Case updatedCase:System.Trigger.new) { Case oldCase = System.Trigger.oldMap.get(updatedCase.Id); User usr = [select Id,UserRoleId from User where Id =:oldCase.OwnerId]; UserRole role = [select Id,Name from UserRole where Id =:usr.UserRoleId];
Is errors when the owner is a Queue. Is there a easy way to solve this?
thanks!
Miguel
- MiguelGuerreiro
- August 05, 2009
- Like
- 0
- Continue reading or reply
PHP date field
hello,
I have a web page written in PHP with several fields so that my customers can created cases. One of the fields should be a data type but we're getting error messages so we switched to string. How does one define a data type field so that the case is correctly created in salesforce?
thank you
- MiguelGuerreiro
- July 20, 2009
- Like
- 0
- Continue reading or reply
checking if "future" owner is in the office
hello,
I have a user field (checkbox) that indicates if the users is Out of the Office.
Is it possible that when a user assign a object (case) to that user the system would prevent this (via validation rule or with another method?
Maybe an trigger?
thank you!
- MiguelGuerreiro
- July 07, 2009
- Like
- 0
- Continue reading or reply
email2case large attachment alert
hello,
is there any way to be alert (via email) when a email message did not generate a case because the attachment is over 5Mb?
thank you!
- MiguelGuerreiro
- July 02, 2009
- Like
- 0
- Continue reading or reply
email2case: reply to non case contact bug
Hello,
As anyone noticed that when you reply, in a case, to a received email sent by someone other than the case contact that the email "TO" or "Addiitional to" fields don't get populated?
Miguel
- MiguelGuerreiro
- July 01, 2009
- Like
- 0
- Continue reading or reply
salesforce to salesforce
Hello,
We currently have several instances of salesforce mainly to use Call Center. We have enabled email2case in both instances.
We have now come across a problem with the email exchange between the two systems. When you email to another instance salesforce places a reference in the subject. When you reply, from the other instance, salesforce does not place a reference at all (probably because he finds one there).
Salesforce-to-salesforce could be the solution but it doesn’t support cases.
Anyone had this situation before? How to overcome it?
Thanks!
Miguel
- MiguelGuerreiro
- May 08, 2009
- Like
- 0
- Continue reading or reply
email2case error
Hello,
We've been getting this error in the log file since this morning, probably something that was changed in our Exchange server but we haven't figured outwhat it is:
"Message: Logon failure: unknown user name or bad password."
The username and password are correct and everything is correct in our email2case settings.
Any ideas? Our email provider seems to be out of solutions...
Thank you!!
- MiguelGuerreiro
- March 30, 2009
- Like
- 0
- Continue reading or reply
documents available externally
I would like to create an email template containing a link to a document stored in our salesforce documents. This email will be sent to non salesforce users but they are prompted with a login page. How can I do this?
Thanks!
- MiguelGuerreiro
- March 18, 2009
- Like
- 0
- Continue reading or reply
case validation rule
I have a question here that I could not solve with a simple validation rule:
I have a picklist field and a text field. I want to stop users (customer portal users) from creating cases when this condition/formula is not true:
IF picklist value contains text value = true
Is it possible?
- MiguelGuerreiro
- June 18, 2008
- Like
- 0
- Continue reading or reply
Help with workflow - Using ISCHANGED(OwnerID)
Hello,
I am trying to create a workflow on object "Cases". I have a look up field on Cases called Internal_Originator_c. I want to notify this person whenever the case ownership changes. In the workflow formula, I am writing ISCHANGED(OwnerID) but I am getting the following error.
Error: Function ISCHANGED may not be used in this type of formula
Why? Can someone sugget a better solution, please? I really appreciate the help.
- Shariq Abbasi.ax705
- May 31, 2010
- Like
- 0
- Continue reading or reply
case read
- Sarifka
- May 29, 2010
- Like
- 0
- Continue reading or reply
several languages in the web form
Hello,
I have created a web form for an object. The field in this object are translated into several languages.
How can I, using one web form only, have it display several languages?
Thanks!
- MiguelGuerreiro
- April 09, 2010
- Like
- 0
- Continue reading or reply
Create a test class for trigger
Hello,
I have developed a trigger on Attachments. My idea is to update a case field when a new attachment is insert on a case. It works OK, not perfect.
I can't deploy it to production because I'm not able to create a test class for it... I tried but I'm only starting with Apex now. The code is below, can someone help me build a test class for it?
trigger NewAttachment on Attachment (before insert) {List<Case> CasesToUpdate = new List<Case>();for (Attachment t: Trigger.new){try{Case c = new Case(Id = t.ParentId);c.HasAttachments__c = true;CasesToUpdate.add(c);}catch (Exception e) {}}update CasesToUpdate;}//end
Thanks!
- MiguelGuerreiro
- March 31, 2010
- Like
- 0
- Continue reading or reply
CMSForce and web form
Hello,
I'm using CMSForce to create a web form for a custom object (which has a look up field for Contacts). Is there a way to automatically link the custom object to the correct contact when he saves the record in the web form? Maybe using his email address?
Thanks!
- MiguelGuerreiro
- March 24, 2010
- Like
- 0
- Continue reading or reply
Problem with Workflows and Triggers
Hi,
we have a problem in our company that i dont know how to resolve.
Step 1: We have to modify a field in all the new lead that comes, its working.
Step 2: This modification will fire a trigger that create documens asociated to the lead,
working but when are more than 10 documents the next error fire: "Too many SOQL queries: 21"
Then next step work but only if we do it throught a independient workflow but we dont know how to do that the last trigger do it:
Step 3: We need that the process create 4 based timed WorkFlows that will send an email to the lead, working.
Any suggestion??
Thanks a lot
- IGL
- February 12, 2010
- Like
- 0
- Continue reading or reply
Self-Service Portal: Ability to discern difference between cases (Projects vs. Support)
I am unable to find a solution that allows me to determine whether a case is related to Support or Services. Both our Support teams and a services team use SFDC for case management (project related cases and support related cases).
Internally I can track whether this is a Support case or a service case based on Record Types but when a client logs into the self service portal to log a issue or view a issue I am unable to display the ticket 'group'owner. How can they select whether the case being submitted is a Support case or a service case so the correct teams are notified and the issue worked?
- NIKAL
- January 13, 2010
- Like
- 0
- Continue reading or reply
Trigger on CaseComment
hello,
im trying to create a trigger to prevent users from adding comments on closed cases.
this is my code:
trigger CloseComment on CaseComment (before insert) {
for (CaseComment t: Trigger.new)
{
Case c = new Case(Id = t.ParentId);
if(c.Status == 'Closed' && c.Process__c == 'Payroll')
{
t.addError(c.Process__c + 'case closed' + c.Status);
}
else
t.addError(c.Process__c + 'case open' + c.Status);
}
}
but i can't get the values of any case fields. I guess im missing something simple.
Any ideas?
- MiguelGuerreiro
- January 13, 2010
- Like
- 0
- Continue reading or reply
archive email messages
- MiguelGuerreiro
- January 11, 2010
- Like
- 0
- Continue reading or reply
How can I hide the "Send notification email to contact" checkbox in Case object?
Hi,
We have enabled cases for Partner Portal. But during a new case creation, we want to hide the option "Send notification email to contact" checkbox that appears at the bottom of the new Case page lyout.
How can we do this without having to convert the page to visualforce?
Thanks
- sfdcdev.ax551
- December 15, 2009
- Like
- 0
- Continue reading or reply
Help With Workflow Rules and Dates
I am looking for a solution: I have a workflow rule setup to send an email when a date field is changed. The problem is it sends the alert when the date is entered as well as when it is changed. Any idea how to suppress the the email alert when the date is initially entered?
Thanks for any guidance you may be able to offer.
- thollywood
- December 09, 2009
- Like
- 0
- Continue reading or reply
Case Age In Business Hours
Hello,
Anyone using Case Age In Business Hours package from appexchange is having problems with Email2Case?
We're getting a lot of errors because of too many SQL queries...
Thank you for any help!
2009-09-23 13:45:36,770 145373 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:0: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:1: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:2: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:3: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:4: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] INFO com.sforce.mail.GenericClient - Copying 5 messages to error mailbox
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:0 ID=02s20000002VbynAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:1 ID=02s20000002VbyoAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:2 ID=02s20000002Vc2DAAS Success=true
- MiguelGuerreiro
- September 23, 2009
- Like
- 0
- Continue reading or reply
'Currency Exchange Rate Updater' fails to connect to http://download.finance.yahoo.com
Hello Team,
After downloading and installing the AppExchange package 'Currency Exhcange Rate Updater' into my SandoBox account, and configuring it according to the Configuration Guide, it fails to connect to http://download.finance.com. As such, I have contacted SalesForce.com support who informed me that this was the place to get help with this issue. Has anyone here run into this same problem, and if so, is there a solution that you can share? Thanks in advance,
Daniel Orrego
Finance Technical Director
Cornerstone Information Systems
812.345.3425
- incrediblechap
- June 10, 2009
- Like
- 0
- Continue reading or reply