Data Loader

Hi #AwesomeAdmins

, 

I need to identify all Salesforce Reports (API Name) where a custom Case field is in use. I am not referring to the data in the custom field. I am focused on 

Reports

 that use the field. I also need the Report of Reports to return the Last Run Date. My goal is to present this to the business to justify why they no longer need the field, if they aren't even reporting on it. If I discover all their reports that have the field have not been run in a long time, that tells me they don't rely on this field anymore. Then I can have a conversation with them about it and provide proof that it is not being relied on. 

Hopefully I have worded this well. Does anyone know of a way to accomplish this? I've found in the Developer Guide an object called Report but I don't see that it allows to filter by Fields on the reports. Thanks in advance. 

I need to move a lot of records from one org to another.  Normally, I export the records from the source org with Data Loader, then insert them into the target org with Data Loader.  This involves starting with the Users, then the Acounts, but you have to use Excel/Xlookup to update the User ID's on the Accounts with the new ID's.  Then I insert the Contacts, after I use Excel/Xlookup to update the User ID's and Account ID's.  This takes a lot of time, and there's a decent chance of making an error.  I found a SF video explaining how to use an External ID field to upsert records.  I created a new External ID Account field called "Old_AccountID__c" and added that field to the Account file and copied the old Account ID to the column.  I created a new External ID Contact field called "Old_AccountID__c" and added that field to the Contact file.  Then I copied the old Account ID to that field.  I tried upserting the Contact file with Data Loader and using that field as the external ID reference, but it didn't work, I just got errors.   

Is there a way to do what I'm trying with Data Loader?  Am I missing a step? 

Thanks 

I tried to run this SOQL in Data Loader and got the error no nested queries. 

SELECT Name, ID, (SELECT ID.Name FROM Notes WHERE FileExtension = 'gif') FROM Account 

I am looking for the IDs of all GIFs that are attachments on Accounts. 

I don't have to do this in Data Loader. I can use any tool to get this done. Any suggestions welcome.  

PS Just figured out nested queries aren't allowed in Workbench either. 

PSS You also can't use a SF report to create a report of Notes created via "Notes & Attachments" related list. 

PSS to reiterate. I am looking for the Attachments on the Account Related List Notes & Attachments where image has gif file type.

@Admin Addicts  @* Sales Cloud - Best Practices *  @Formulas - Help, Tips and Tricks  @* Salesforce Developers * #Salesforce Developer #Sales Cloud #Data Management #Sales Cloud

Trying to insert about 50 records into the opportunity object within a sandbox using data loader and receiving the above error. I've made sure that this field contained active user IDs and then modified all the records to have my user ID listed under this field, but to no avail.  Any idea what I should be checking to get past this to successfully insert? ##Dataloader

Got this error on a dataload to Contact object for part of the file. Added 18-digit owner ID. Account ID also on file. Reloaded only the errors. Got the same error on all records:  | Owner ID: owner cannot be blank. I'm using v61, I could download the new version, but I've done 5 dataloads to the contact over the last 48 hours with no problem. I even cut and pasted the data into a new excel workbook then saved as csv.

Any thoughts?

Hello awesome admins,

I am trying to use data loader to identify profiles (not permission sets) that have view or edit access to a field. This is my data loader query so far:

SELECT Field, Id, ParentId, PermissionsEdit, PermissionsRead

FROM FieldPermissions

WHERE

    SobjectType = 'Opportunity'

    AND Field = 'Opportunity.Special__c'

    AND (PermissionsEdit = True

    OR PermissionsRead = true)

I would like the export to include the Profile Name. Also, my goal is to use the export to then update some of the Profiles so that PermissionsEdit and PermissionsRead = False.

1. How do I include Profile Name in my query?

2. When I do the Update, which object should I be updating... is it the FieldPermissions object again?

Thank you!

#AwesomeAdmins #Dataloader #SOQL Queries