-
ChatterFeed
-
1Best Answers
-
0Likes Received
-
0Likes Given
-
11Questions
-
15Replies
login Notification message/bulletin message
Hello All,
Is there any way to create a popup messages on home page when the users first login to salesforce?
The popup message should appear only when the users login for the first time in a day and one of the user should have ability to customize the messages every day. These messages should appear only to a particular group of users.
Any help on this is greatly appreciated.
Thanks in Advance.
- Aaron2010
- January 24, 2011
- Like
- 0
- Continue reading or reply
Error: Failed to invoke future method
System.DmlException: Update failed. First exception on row 0 with id a1H80000000LzOyEAK; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record: []
Can anyone of you help me resolving this issue. Everyday i receive 15 emails about this error from ApexApplication [info@salesforce.com].
Thanks in advance.
- Aaron2010
- November 28, 2010
- Like
- 0
- Continue reading or reply
RE: Data Migration from Netsuite to Salesforce
Hello All,
Can any one suggest me a way to migrate data from netsuite CRM to salesforce CRM. I have no idea about netsuite CRM.
I tried exploring netsuite CRM and tried to export data using the "Full Export" functionality that is in netsuite but, unfortunately it does not export complete data from netsuite.
Is there any was to extract all the netsuite data with relationships? Can any one suggest me on the ways to migrate data from netsuite to salesforce?
Any help is greatly appreciated.
Thanks.
- Aaron2010
- November 15, 2010
- Like
- 0
- Continue reading or reply
RE: Data loader stops every 50k - 100k records insert
I am using data loader to upload 900K records. During this process it stops for every 50k - 100k records. Then i have to look back into success file, start the data loader again from a particular row.. It took me almost 8 hours to load all the data. Does any one know why data loader stops during this process? Is there any work around for this?
Any kind of help would be greatly appreciated!
Thanks
- Aaron2010
- October 04, 2010
- Like
- 0
- Continue reading or reply
Parsing MailingStreet
Hello all,
I have a requirement where i have to parse the Mailingstreet with the delimiter as newline (Carriage return) and populate the parsed lines into other custom fields.
For eg:
MailingStreet: Central park Residency
Suite: 410
123 N West Drive
I want to parse the mailing street into 3 different lines and place those 3 parsed lines into 3 different custom fields.
Address line 1: Central park Residency
Address line 2: Suite: 410
Address line 3: 123 N West Drive
Can any one suggest how to start with this?
Thanks.
- Aaron2010
- September 24, 2010
- Like
- 0
- Continue reading or reply
RE: pdf / text file/ jpeg etc upload
Can we upload a file from visualforce sites into salesforce? Can anyone tell me the procedure / provide the sample code.
Thanks.
- Aaron2010
- September 13, 2010
- Like
- 0
- Continue reading or reply
SOQL: Using Like -- {URGENT}
Hello everyone,
In the following piece of code I am unable to fetch the rows if the groupName consists of left open paranthesis '(' and right open paranthesis ')'.
for Eg: if groupName = Assisted Health program (AHP) Japan
If i remove (AHP) then it is working fine. like if i have my groupname as 'Assisted Health Program'. I am able to fetch the rows.
So, how to fetch the rows even if it consists of paranthesis in the groupName?
this.groupName = ApexPages.currentPage().getParameters().get('group');
if (groupName != null) {
evs = [Select Time_Zone_Offset__c, Start_Time__c, Start_Date__c, Name, Id, End_Time__c From Offmax_cal__c where Business__c like :(groupName + '%')];
- Aaron2010
- August 02, 2010
- Like
- 0
- Continue reading or reply
Emails to "TO" and "CC"
Hello All,
We have a registration system where the user receives Registration email upon registration. Here we used Visualforce email Template. Is it possible, if the registrant do not want to receive email after the registration and he wants email to be sent only to CC address.
Here is code that is used to send emails.. I m posting only the part of code that is used for emails...
Here before calling sendEventConfirmation i am changing the email of the contact to cc emailaddress and after email is sent i am resetting back to old email. But still the email is reaching both To and CC addresses...
private void sendConfirmation() { if (this.contact.IsPersonAccount || this.registrantIsDoctor) { this.oldemail = this.email; this.account.PersonEmail = this.reg.CC_Email__c; this.contactId = RegistrantPersister.persistAccount(this.account); } else{ this.oldemail = this.email; this.contact.Email = this.email; this.contactId = RegistrantPersister.persistContact(this.contact); } RegistrationEmailSender.sendEventConfirmation(this.eventId, this.reg.Id, this.contactId, this.reg.CC_Email__c, this.event.Planner_Email__c, testingEmail); if (this.contact.IsPersonAccount || this.registrantIsDoctor) { this.account.PersonEmail = this.oldemail; this.contactId = RegistrantPersister.persistAccount(this.account); } else{ this.contact.Email = this.oldemail; this.contactId = RegistrantPersister.persistContact(this.contact); } } }
webservice static Boolean sendEventConfirmation(Id eventId, Id registrantId, Id contactId, String ccEmailAddress, String plannerEmailAddress, Boolean testing) { Boolean emailSent = false; // Have to query to get the Id of the template and From address EmailTemplate et = [select Id from EmailTemplate where DeveloperName = 'Event_Registration_Confirmed' limit 1]; OrgWideEmailAddress oe = [Select Id From OrgWideEmailAddress where DisplayName = 'Events' and Address = 'gem.meetings@events.com' limit 1]; // Load attachments Integer totalAttachmentSize = 0; Attachment[] atts = [select id, name, body, bodylength from attachment where parentid = :eventId and name not in ('header', 'footer')]; List<Messaging.EmailFileAttachment> fileAttachments = new List<Messaging.EmailFileAttachment>(); for(Attachment a : atts) { totalAttachmentSize += a.bodylength; Messaging.EmailFileAttachment fileAttachment = new Messaging.EmailFileAttachment(); fileAttachment.setFileName(a.name); fileAttachment.setBody(a.body); fileAttachments.add(fileAttachment); } string email1 = [select id,email from contact where id = :contactId][0].email; system.debug('this is email id that is changed------------------>>>>>>>'+email1); // Build mail sending object Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); // Sender //mail.setSenderDisplayName('Events'); //mail.setReplyTo(plannerEmailAddress); mail.setOrgWideEmailAddressId(oe.id); // Recipient(s) and Content mail.setTargetObjectId(contactId); mail.setWhatId(registrantId); mail.setTemplateId(et.id); if (ccEmailAddress != null && ccEmailAddress != '') { List<String> ccAddresses = new List<String>(); ccAddresses.add(ccEmailAddress); mail.setCcAddresses(ccAddresses); } if (fileAttachments.size() > 0 && totalAttachmentSize < 10485760) { mail.setFileAttachments(fileAttachments); } // Other misc options mail.setBccSender(false); mail.setUseSignature(false); mail.setSaveAsActivity(false); if (!testing) { List<Messaging.SendEmailResult> results = Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail }); if (results.get(0).isSuccess()) emailSent = true; } return emailSent; } }
So is there any other way to stop emails to "TO" address and send only to cc address.
Any help would be appreciated.
Thanks
- Aaron2010
- July 21, 2010
- Like
- 0
- Continue reading or reply
Uploading Attachments to Records
Hello all,
Is there any easier way to upload one attachment to multiple records at a time.
Here is how my requirement goes... In our organization users want to add a attachment to a group of accounts (the group may vary depending on their criteria). Is it possible for them to select an attachment and add it to the notes and attachments section of all the accounts.
Is it possible to add an attachment by a report to all those accounts?
Any help would be appreciated.
Thanks in advance.
- Aaron2010
- July 21, 2010
- Like
- 0
- Continue reading or reply
Uploading Attachments to Records
Hello all,
Is there any easier way to upload one attachment to multiple records at a time.
Here is how my requirement goes... In our organization users want to add a attachment to a group of accounts (the group may vary depending on their criteria). Is it possible for them to select an attachment and add it to the notes and attachments section of all the accounts.
Any help would be appreciated.
Thanks in advance.
- Aaron2010
- July 21, 2010
- Like
- 0
- Continue reading or reply
Bulkify
Hello all,
I am a newbie to apex development. Can any one help me in bulkifying this trigger.
trigger PopulateRegistrantGroup on Event_Registrant_zem__c (before insert, before update) {
String s;
Id id1;
for (Event_Registrant_zem__c e :Trigger.new)
{
id1 = e.registrant_type__c;
s = [select id,name from Registrant_Type_zem__c where id = :id1].name;
if(e.Registrant_type_group__c == NULL)
{
e.Registrant_type_group__c = [select epz.Id from Event_permission_zem__c epz where epz.zimmer_event__c = :e.zimmer_event__c and epz.type__c = 'Event Capacity' and epz.Registrant_Types__c INCLUDES (:s)][0].id;
}
}
}
Any help is appriciated. Thanks in advance.
- Aaron2010
- July 20, 2010
- Like
- 0
- Continue reading or reply
login Notification message/bulletin message
Hello All,
Is there any way to create a popup messages on home page when the users first login to salesforce?
The popup message should appear only when the users login for the first time in a day and one of the user should have ability to customize the messages every day. These messages should appear only to a particular group of users.
Any help on this is greatly appreciated.
Thanks in Advance.
- Aaron2010
- January 24, 2011
- Like
- 0
- Continue reading or reply
Record visibility based on opportunity stage
Is there a way to control a record's visibility to a user based on the Opportunity Stage? For my organization, I want to have Opportunities that are Closed Won visible to all, but if they are still in the potential stages (prospecting, etc), only the Opportunity Owner and their superiors should be able to view that. Happy to code whatever I need to make this happen, but would love some pointers on whether it is even possible and if so, strategy to achieve that.
Thanks!
- etess
- January 18, 2011
- Like
- 0
- Continue reading or reply
Error: Failed to invoke future method
System.DmlException: Update failed. First exception on row 0 with id a1H80000000LzOyEAK; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record: []
Can anyone of you help me resolving this issue. Everyday i receive 15 emails about this error from ApexApplication [info@salesforce.com].
Thanks in advance.
- Aaron2010
- November 28, 2010
- Like
- 0
- Continue reading or reply
RE: Data loader stops every 50k - 100k records insert
I am using data loader to upload 900K records. During this process it stops for every 50k - 100k records. Then i have to look back into success file, start the data loader again from a particular row.. It took me almost 8 hours to load all the data. Does any one know why data loader stops during this process? Is there any work around for this?
Any kind of help would be greatly appreciated!
Thanks
- Aaron2010
- October 04, 2010
- Like
- 0
- Continue reading or reply
RE: pdf / text file/ jpeg etc upload
Can we upload a file from visualforce sites into salesforce? Can anyone tell me the procedure / provide the sample code.
Thanks.
- Aaron2010
- September 13, 2010
- Like
- 0
- Continue reading or reply
Switching From Netsuite to Salesforce
Does anyone have an Idea on the best method for migrating data from netsuite into salesforce. I am fimiliar with Salesforce but I have never worked with a Netsuite demo account. What tools would you recommend when transferring data from netsuite to salesforce? This would include all activities, notes, and attachments associated with defualt objects such as accounts, contacts, leads, and opportunites? Is infomatica the best solution for data migration? Any useful information would be helpful. Thanks
- CloudAlly
- August 18, 2010
- Like
- 0
- Continue reading or reply
SOQL: Using Like -- {URGENT}
Hello everyone,
In the following piece of code I am unable to fetch the rows if the groupName consists of left open paranthesis '(' and right open paranthesis ')'.
for Eg: if groupName = Assisted Health program (AHP) Japan
If i remove (AHP) then it is working fine. like if i have my groupname as 'Assisted Health Program'. I am able to fetch the rows.
So, how to fetch the rows even if it consists of paranthesis in the groupName?
this.groupName = ApexPages.currentPage().getParameters().get('group');
if (groupName != null) {
evs = [Select Time_Zone_Offset__c, Start_Time__c, Start_Date__c, Name, Id, End_Time__c From Offmax_cal__c where Business__c like :(groupName + '%')];
- Aaron2010
- August 02, 2010
- Like
- 0
- Continue reading or reply
Embedded Calculation in select statement using aggregate
I am trying to write a select statement like this:
[select ID, sum(field1) sum1, sum(field2) sum2, (sum1/sum2) from Account Group by ID]
Is it possible to embed a calculation like (sum1/sum2) in a select statement when I'm using aggregate functions? Or can someone recommend how you could so this in an SOQL statement? Thanks.
- duke1
- July 23, 2010
- Like
- 0
- Continue reading or reply
Emails to "TO" and "CC"
Hello All,
We have a registration system where the user receives Registration email upon registration. Here we used Visualforce email Template. Is it possible, if the registrant do not want to receive email after the registration and he wants email to be sent only to CC address.
Here is code that is used to send emails.. I m posting only the part of code that is used for emails...
Here before calling sendEventConfirmation i am changing the email of the contact to cc emailaddress and after email is sent i am resetting back to old email. But still the email is reaching both To and CC addresses...
private void sendConfirmation() { if (this.contact.IsPersonAccount || this.registrantIsDoctor) { this.oldemail = this.email; this.account.PersonEmail = this.reg.CC_Email__c; this.contactId = RegistrantPersister.persistAccount(this.account); } else{ this.oldemail = this.email; this.contact.Email = this.email; this.contactId = RegistrantPersister.persistContact(this.contact); } RegistrationEmailSender.sendEventConfirmation(this.eventId, this.reg.Id, this.contactId, this.reg.CC_Email__c, this.event.Planner_Email__c, testingEmail); if (this.contact.IsPersonAccount || this.registrantIsDoctor) { this.account.PersonEmail = this.oldemail; this.contactId = RegistrantPersister.persistAccount(this.account); } else{ this.contact.Email = this.oldemail; this.contactId = RegistrantPersister.persistContact(this.contact); } } }
webservice static Boolean sendEventConfirmation(Id eventId, Id registrantId, Id contactId, String ccEmailAddress, String plannerEmailAddress, Boolean testing) { Boolean emailSent = false; // Have to query to get the Id of the template and From address EmailTemplate et = [select Id from EmailTemplate where DeveloperName = 'Event_Registration_Confirmed' limit 1]; OrgWideEmailAddress oe = [Select Id From OrgWideEmailAddress where DisplayName = 'Events' and Address = 'gem.meetings@events.com' limit 1]; // Load attachments Integer totalAttachmentSize = 0; Attachment[] atts = [select id, name, body, bodylength from attachment where parentid = :eventId and name not in ('header', 'footer')]; List<Messaging.EmailFileAttachment> fileAttachments = new List<Messaging.EmailFileAttachment>(); for(Attachment a : atts) { totalAttachmentSize += a.bodylength; Messaging.EmailFileAttachment fileAttachment = new Messaging.EmailFileAttachment(); fileAttachment.setFileName(a.name); fileAttachment.setBody(a.body); fileAttachments.add(fileAttachment); } string email1 = [select id,email from contact where id = :contactId][0].email; system.debug('this is email id that is changed------------------>>>>>>>'+email1); // Build mail sending object Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); // Sender //mail.setSenderDisplayName('Events'); //mail.setReplyTo(plannerEmailAddress); mail.setOrgWideEmailAddressId(oe.id); // Recipient(s) and Content mail.setTargetObjectId(contactId); mail.setWhatId(registrantId); mail.setTemplateId(et.id); if (ccEmailAddress != null && ccEmailAddress != '') { List<String> ccAddresses = new List<String>(); ccAddresses.add(ccEmailAddress); mail.setCcAddresses(ccAddresses); } if (fileAttachments.size() > 0 && totalAttachmentSize < 10485760) { mail.setFileAttachments(fileAttachments); } // Other misc options mail.setBccSender(false); mail.setUseSignature(false); mail.setSaveAsActivity(false); if (!testing) { List<Messaging.SendEmailResult> results = Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail }); if (results.get(0).isSuccess()) emailSent = true; } return emailSent; } }
So is there any other way to stop emails to "TO" address and send only to cc address.
Any help would be appreciated.
Thanks
- Aaron2010
- July 21, 2010
- Like
- 0
- Continue reading or reply
Bulkify
Hello all,
I am a newbie to apex development. Can any one help me in bulkifying this trigger.
trigger PopulateRegistrantGroup on Event_Registrant_zem__c (before insert, before update) {
String s;
Id id1;
for (Event_Registrant_zem__c e :Trigger.new)
{
id1 = e.registrant_type__c;
s = [select id,name from Registrant_Type_zem__c where id = :id1].name;
if(e.Registrant_type_group__c == NULL)
{
e.Registrant_type_group__c = [select epz.Id from Event_permission_zem__c epz where epz.zimmer_event__c = :e.zimmer_event__c and epz.type__c = 'Event Capacity' and epz.Registrant_Types__c INCLUDES (:s)][0].id;
}
}
}
Any help is appriciated. Thanks in advance.
- Aaron2010
- July 20, 2010
- Like
- 0
- Continue reading or reply
- rpapegowda
- November 10, 2009
- Like
- 0
- Continue reading or reply