Hi,

Can you please help me with this?

I have a csv file,

CampaignId      CampaignLocation               Location Id              Location  

100009090                                121                   00001                       121

200000789                                122                   00002                       122

309088877                                 122                           

400007890                                 121  

Campaign and Location are 2 objects. am trying to get campaign location's location id based on location.

Location is the child object for campaign.

In the result, I want this

CampaignId      CampaignLocation                Id               

100009090                                121                   00001          

200000789                                122                   00002          

309088877                                 122                  00002        

400007890                                 121                   00001

am looking for campaign location corresponding value Id.

Please help me this.

 how to apply vlookup for this

Thanks.

Hi,

Are the user id's same in sandbox and prod??

Thanks

Hi All,

I have 2 objects.

Contacts

Donations

Donations is the child object and have the foreign key contact id in Donations.

Each contact may donate any number of times. 

Contact to Donation have one to many relationship. So one contact has many donations.

I want to pull all contact records who donated for past 5 years from now. such that contact should have atleast one donation in each and every year.

Ex: 2009,2010,2011,2012,2013

I want the contact records who donated atleast once in 2009 and 2010 and 2011 and 2012 and 2013

If contact missed to donate in any one of the year , i dont want that record in my result.

Please help me with sql query.

Its urgent

Thanks

Hi ,

I am very new to salesforce.

Can someone help me with this

I created a new sandbox and now want to remove access for few users in that particular sandbox.

Can anyone help me with step by step procedure using dataloader.

If i remove user's access from this sandbox, will users be able to access other sandbox and production?

Please let me know

Thanks.

Hi,

I have a Contact and Opportunity(Donations) objects.

Opportunity is child obj for Contact.

In our case,  for one contact there may be several opportunity( donation) records. 

Close date and Amount are two fields in opportunity.

How to query for a condition in sql, most recent close date and most recent amount ? for a given date range and given amount range.

select  name,max(date),amount

from donations

where closedate> '2011-3-4' and closedate < '2012-2-4' and amount>10 and amount<100

group by name

but it throws me an error on amount field as it is not in aggregate function.

how to modify this query such that for each contact record, it pulls donation's recent close date and recent amount. ( Consider for 1 contact we have 10 donations. so we need to pull 10th donation details.)

Hi All,

I have reports ready and how to save this report as csv file??

Thanks

Hi,

There is a permission set with a field "Enable email notification" (check box) . Am supposed to set this field to be true for all the user records.

Do we need to use dataloader for this to update?

Can someone help me with this.?

Thanks

Hi,

Can anyone help me with this..

Do Audit on customizations and configurations between QA Sandbox and Production sandbox.

What am supposed to do for this?

Please respond.

Thanks.

Can someone provide me an example of validations using triggers?

Hello,

Can someone tell me,

what's the difference or feature between Data Loader and apex batch class??

Why to use batch class when we are able to do it with dataloader settings (i.e migrating the data in batches)

Thanks in advance

Am new to salesforce,

Someone please help me with these terms,

Whats an ajax request?

What does  calling asynchronously means??

Hello,

Can anyone please tell me how this roles and profiles are used in real time.

I am good with the defination part and i have clear idea what those terms means. but want to know how they are applied in real time?

Help would be appreciated 

Thanks

Hello,

Can you please explain what dupe catcher is? What are the uses ? Please give me a scenario

Can we upload a batch of loads and still make the dupe catcher working?

Help would be appreciated 

Thanks

Can anyone please share what kind of major  issues you faced while integrating the two applications.

and also,

What kind of steps we need to keep in mind before integrating?

Please do help me.

Hello All,

Can someone help me with differences between data migration and data integration.

Thanks

Hello,

Why do we use after triggers especially for cross objects??

Any explanation would be appreciated 

Hello,

What does this webservice callout means? Where and why do we use it?

( I know that webservice is a form of communication b/n the systems)

@future methods:

What does resources available means?( resources here mean memory,database resources and all) but i didnt get what exactly it meant.  why do we use this annotation?  what is running asynchronously in this context? 

Can someone explain a general idea what exactly happens with this external systems,webservice callouts, invoking the future methods from trigger and all and why do we use it. am not able to get a clear idea

Thanks 

Can anybody explain me what 

Escalation Rules,Assignment Rules,Approval Process,TimeBased Workflow means?

Please.

Thanks

Please help me with this,

ApexPages.currentPage().getParameters().get();

What it actually does? whats the purpose of it?

Can somebody give an example for this?


Thanks

I am new to salesforce . Can anyone help me with what exactly migration does?  how to migrate  Data ( Function migration as well)  from a SF (live environment) org to another SF (live environment) org.?

Am new to salesforce,

Someone please help me with these terms,

Whats an ajax request?

What does  calling asynchronously means??

Hi All,

I have 2 objects.

Contacts

Donations

Donations is the child object and have the foreign key contact id in Donations.

Each contact may donate any number of times. 

Contact to Donation have one to many relationship. So one contact has many donations.

I want to pull all contact records who donated for past 5 years from now. such that contact should have atleast one donation in each and every year.

Ex: 2009,2010,2011,2012,2013

I want the contact records who donated atleast once in 2009 and 2010 and 2011 and 2012 and 2013

If contact missed to donate in any one of the year , i dont want that record in my result.

Please help me with sql query.

Its urgent

Thanks

Hi All,

I have two objects.

Contacts and Funds.

I want all the contact records who didn't fund any to the organization.

This can be determined by the id's

select * from contact,Funds

where contact.id=funds.contactid----> this means there are funds from this contact.

select * from contact,Funds

where contact.id not exists in Funds.contactid--> this means there are no funds from this contact.

This means that there are contact records who gave same funds also who didn't give any funds. We want 2 diff files.

Can someone help me with the SQL Query?

Thanks

Hi,

I have Opportunity object and contact object. I have to pull the data using salesforce dataloader from contact obj. for this obj i have opportunity as the child object. Can i write a query by joining these two objects?

Ex:

select contact.id,opportunity.id

from contact,opportunity

where opportunity.fieldname='text'

Is it possible in salesforce dataloder export?

or we can write a query only for one object at a time?

Hi All,

I have reports ready and how to save this report as csv file??

Thanks

Hi,

There is a permission set with a field "Enable email notification" (check box) . Am supposed to set this field to be true for all the user records.

Do we need to use dataloader for this to update?

Can someone help me with this.?

Thanks

Hi,

Can anyone help me with this..

Do Audit on customizations and configurations between QA Sandbox and Production sandbox.

What am supposed to do for this?

Please respond.

Thanks.

Can someone provide me an example of validations using triggers?

Hello,

Can someone tell me,

what's the difference or feature between Data Loader and apex batch class??

Why to use batch class when we are able to do it with dataloader settings (i.e migrating the data in batches)

Thanks in advance

Am new to salesforce,

Someone please help me with these terms,

Whats an ajax request?

What does  calling asynchronously means??

Hello,

Can you please explain what dupe catcher is? What are the uses ? Please give me a scenario

Can we upload a batch of loads and still make the dupe catcher working?

Help would be appreciated 

Thanks

Hello,

What does this webservice callout means? Where and why do we use it?

( I know that webservice is a form of communication b/n the systems)

@future methods:

What does resources available means?( resources here mean memory,database resources and all) but i didnt get what exactly it meant.  why do we use this annotation?  what is running asynchronously in this context? 

Can someone explain a general idea what exactly happens with this external systems,webservice callouts, invoking the future methods from trigger and all and why do we use it. am not able to get a clear idea

Thanks