• Sunny G
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 37
    Questions
  • 36
    Replies

Hi,

 

I have some users from Japan using single Salesforce application. Means that i have lots of data in Japanees Language also. But when i try to take the backup of the data using data loader. My Japanees data gets distorted & appears something like "?????" . please suggest the way should i take the backup sucessfully with no data lost.And if required i should be able to get it restored.

Hi,

 

I have one .csv file on Server, which has few fields. I simply want to insert that .csv file data to SFDc twice in a week.

 

Please let me know how can i achieve this functionality. And that is ofcourse should be very practical.

 

 

Thanks

Hi,

 

I have one custom owner field (i.e. a lookup to the user) . Where some user can manually select the owner of the record. I have another custom status field (i.e. a picklist field). Now, i want to send an email alert to the custom owner field, whenever the custom status fields gets updated.

 

please guide how can i achieve this functionality??

 

Thanks

Hi,

 

I have one custom owner field. Where user can manually select the owner of the record. I have another custom status field. Now, i want to send an email alert to the custom owner field, whenever the custom status fields gets changed.

 

please guide how can i achieve this functionality??

 

Thanks

Hi,

 

Please help me to write the test class for the following trigger that has more then 75% code coverage.

 

 

trigger change_opps on Pre_Sales_Request__c (before update) 
{
for(Pre_Sales_Request__c a:Trigger.new)        
{            
if(system.trigger.OldMap.get(a.Id).Opportunity__c != system.trigger.NewMap.get(a.Id).Opportunity__c)            
{                                               
a.Previous_Stage__c = a.stage__c;                     
}                                       
}
}

 

 

 

Thanks

Hi,

 

I have a trigger and a test class... the code coverage for trigger is 100% in sandbox.. but when i tried deploying it to production.. it gives an error saying that minimum 1% code coverage for the trigger??? I am noty able to understand why is it so...

 

 

Although i tried deploying test class first but it says that the custom object is missing???

 

I am using Eclipse as well as Setup -> Deploy... for deployment.

Hi,

 

I have some very simple trigger in sandbox. Something like to update a particular field value to another value for custom objects.

 

Now, i want to deploy my custom object to production.. but it is giving me an error saying that "Test coverage of selected Apex Trigger is 0%, at least 1% test coverage is required"

 

I am not able to understand why is it coming up??Since my trigger is working fine in sandbox.

 

what to do in that case?? please help.

 

If i need to write an some apex class and all.. then i am not totally aware of how to go about and it and where and what has to be written in that class. Please see the following trigger:

 

trigger updaterequestowner on Pre_Sales_Request__c (before insert)
{
        Profile auth_profile = [select id from profile where name='HS_StandardUser_Presales'];         
        Id v_User = UserInfo.GetProfileId();   
    for(Pre_Sales_Request__c ob : Trigger.new)
        {   
            if(v_User !=  auth_profile.Id)      
                {   
                   ob.Request_Owner__c =  Userinfo.getUserId();  
                }  
        }                
}

can somebody please help in this....

Please provide any test class that will cover atleast 75% code area for the following trigger

 

trigger Duplicate on Account (before insert, before update)
{

    Map<String, Account> accountMap = new Map<String, Account>();
   
   
    for (Account account : System.Trigger.new)
    {
        //expected to execute when converting leads to account
        String tempAccountSite = '';
        if (account.Site == null || account.Site == '')
        {
            account.Site = account.Lead_Site__c;
           
            //force the formula of Account_Site_c since mapping of Lead Site to Account Site
            //occurs after this trigger
            tempAccountSite = account.Name + account.Lead_Site__c;
        }
       
        // Make sure we don't treat an Account_Site that is
        // not changing during an update as a duplicate.
        if ((account.Account_Site__c != null) && (System.Trigger.isInsert ||
            (!account.Account_Site__c.EqualsIgnoreCase(System.Trigger.oldMap.get(account.ID).Account_Site__c))))
        {
            // Make sure another in the batch is not a duplicate
            if (accountMap.containsKey(account.Account_Site__c.ToLowerCase()))
            {
                account.addError('A Account is a duplicate - Account Name and Account Site already exists');
            }
            else if (tempAccountSite != '')
            {
                accountMap.put(tempAccountSite.ToLowerCase(), Account);
            }
            else
            {
                accountMap.put(account.Account_Site__c.ToLowerCase(), Account);
            }
        }
    }

    // With a single database query, find all the accounts in
    // the database that have the same name and site as any
    // of the accounts being inserted or updated.
    for (Account account : [SELECT Account_Site__c from Account WHERE Account_Site__c IN :accountMap.KeySet()])
    {
        Account newAccount = accountMap.get(account.Account_Site__c.ToLowerCase());
       
        if (newAccount != null)
        {
            newAccount.addError('B Account is a duplicate - Account Name and Account Site already exists');
        }
    }
}

 

 

Hi,

 

Relatively new at customizing SF.com and have been able to acheive most modifications but have been stumped with this one ...

 

I currently have a  custom field at the Account level that is a checkbox. I am looking to create a View under the Opportunities tab that only lists accounts that have the Account level checkbox ticked.

 

I can't seem to do it as a the veiws onlyhave fields from the Opportunity object level.

 

You assistance is appreciated.

 

Cheers,

 

Mariano.

Hi

 

I have a Custom lookup field "Assigned to User" which assignes to user's list. When I select a user in that field, automatically an email will sent to that corresponding user. How can we get it?

Hi,

I have a spreadsheet that I would like to import into salesforce.  I am saving the spreadsheet as a csv data file then using the Apex Data Loader to get this into salesforce.  My problem is that I have data from different languages and these seem to appear as question marks (e.g. ???? ???) in salesforce.  If I copy and paste the data straight into salesforce it appears with no problems.

I don't however want to copy and paste 300+ records to get them showing properly.  Is there some way to get these special characters importing correctly using the apex data loader?
Hello.  Apologies in advance if this is the wrong forum for my question ...

I'm a newbie and using the free Class Enrollment app from AppExchange.  There are two custom objects, Class and Enrollment.  I've added Enrollment to my Contact page layout as a related list.  It works fine, except that once I've created an Enrollment for the Contact, I would like to display the Date Offered field (read only) next to the Class name field in the Enrollment layout.

The Date Offered field is in the Class custom object, and I can't figure out how to build a formula in the Enrollment custom object to pull this value as I need it.  If this were SQL, I would write something like SELECT Date_Offered FROM Classes WHERE ClassID = Enrollment.ClassID.  Is there a way in the formula builder to refer to a field in a related custom object?  I've searched help and the forums but haven't found anything.

In Enrollment, the Student Name field has a Master-Detail lookup to Contacts, and the Class name field has a Lookup relationship to Class.  Do I need a Master-Detail with Class to accomplish what I want?  But only one Master-Detail is allowed ...

Any suggestions on how I can go about this?

Thanks
David