-
ChatterFeed
-
0Best Answers
-
1Likes Received
-
0Likes Given
-
20Questions
-
24Replies
Update using Dataloader_Vlookup
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.
- Vinny12
- June 10, 2013
- Like
- 0
- Continue reading or reply
- Vinny12
- June 02, 2013
- Like
- 0
- Continue reading or reply
URGENT-----SQL Query on salesforce objects
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
- Vinny12
- May 29, 2013
- Like
- 0
- Continue reading or reply
Dataloader
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.
- Vinny12
- May 28, 2013
- Like
- 0
- Continue reading or reply
SQL query for salesforce objects
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.)
- Vinny12
- May 10, 2013
- Like
- 0
- Continue reading or reply
Reports in CSV format?
Hi All,
I have reports ready and how to save this report as csv file??
Thanks
- Vinny12
- May 03, 2013
- Like
- 0
- Continue reading or reply
permission set
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
- Vinny12
- April 29, 2013
- Like
- 0
- Continue reading or reply
Audit
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.
- Vinny12
- April 29, 2013
- Like
- 0
- Continue reading or reply
- Vinny12
- March 21, 2013
- Like
- 0
- Continue reading or reply
Batch class vs dataloader
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
- Vinny12
- March 21, 2013
- Like
- 0
- Continue reading or reply
Ajax request??
Am new to salesforce,
Someone please help me with these terms,
Whats an ajax request?
What does calling asynchronously means??
- Vinny12
- March 16, 2013
- Like
- 1
- Continue reading or reply
Profiles and roles
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
- Vinny12
- March 15, 2013
- Like
- 0
- Continue reading or reply
Dupe Catcher ?
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
- Vinny12
- March 14, 2013
- Like
- 0
- Continue reading or reply
Issues in Data Integration
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.
- Vinny12
- March 13, 2013
- Like
- 0
- Continue reading or reply
Difference b/n data migration and data integration?
Hello All,
Can someone help me with differences between data migration and data integration.
Thanks
- Vinny12
- March 12, 2013
- Like
- 0
- Continue reading or reply
Why we use after triggers on cross objects??
Hello,
Why do we use after triggers especially for cross objects??
Any explanation would be appreciated
- Vinny12
- March 08, 2013
- Like
- 0
- Continue reading or reply
Webservice callouts? @future methods?
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
- Vinny12
- March 08, 2013
- Like
- 0
- Continue reading or reply
Escalation Rules,Assignment Rules,Approval Process,TimeBased Workflow
Can anybody explain me what
Escalation Rules,Assignment Rules,Approval Process,TimeBased Workflow means?
Please.
Thanks
- Vinny12
- March 07, 2013
- Like
- 0
- Continue reading or reply
Apexpages.currentPage().getParameters().get()
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
- Vinny12
- March 05, 2013
- Like
- 0
- Continue reading or reply
Migration
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.?
- Vinny12
- February 28, 2013
- Like
- 0
- Continue reading or reply
Ajax request??
Am new to salesforce,
Someone please help me with these terms,
Whats an ajax request?
What does calling asynchronously means??
- Vinny12
- March 16, 2013
- Like
- 1
- Continue reading or reply
URGENT-----SQL Query on salesforce objects
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
- Vinny12
- May 29, 2013
- Like
- 0
- Continue reading or reply
SQL Query on Salesforce objects
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
- neil12
- May 17, 2013
- Like
- 0
- Continue reading or reply
Dataloader
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?
- neil12
- May 08, 2013
- Like
- 0
- Continue reading or reply
Reports in CSV format?
Hi All,
I have reports ready and how to save this report as csv file??
Thanks
- Vinny12
- May 03, 2013
- Like
- 0
- Continue reading or reply
permission set
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
- Vinny12
- April 29, 2013
- Like
- 0
- Continue reading or reply
Audit
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.
- Vinny12
- April 29, 2013
- Like
- 0
- Continue reading or reply
- Vinny12
- March 21, 2013
- Like
- 0
- Continue reading or reply
Batch class vs dataloader
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
- Vinny12
- March 21, 2013
- Like
- 0
- Continue reading or reply
Ajax request??
Am new to salesforce,
Someone please help me with these terms,
Whats an ajax request?
What does calling asynchronously means??
- Vinny12
- March 16, 2013
- Like
- 1
- Continue reading or reply
Dupe Catcher ?
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
- Vinny12
- March 14, 2013
- Like
- 0
- Continue reading or reply
Webservice callouts? @future methods?
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
- Vinny12
- March 08, 2013
- Like
- 0
- Continue reading or reply