Skip to main content

#Data Management87 discussing

Have you ever had to reconstruct a Salesforce Setup Data Export after it was already downloaded?

 

I’m looking at a very specific post-export problem:

 

You already have the Salesforce Data Export ZIPs on disk — sometimes dozens of them — with Attachments / Documents / ContentVersion files named by IDs and split across multiple folders.

 

At that point, have you ever had to manually:

 

merge or search through multiple ZIPs,

 

rename ID-based files,

 

match them back to CSV rows,

 

deal with duplicate filenames,

 

identify missing/orphaned files,

 

or reconstruct a usable archive for a migration or handoff?

 

 

If yes, I’d love to know:

 

1. What did you actually do to solve it?

2. Roughly how long did it take?

3. Would you pay around US$69 once for a local tool that accepts the untouched export ZIPs, processes them together, reconstructs what can be safely reconstructed, and gives you readable files plus an audit report — without Salesforce login or API access?

 

I’m specifically interested in people who have already dealt with this problem, not general opinions about the idea.

 

 

 

#Data Management

2 answers
  1. Aug 23, 3:12 AM

    @Shura Elizabeth 

    Yeah, It's always the same headache. The export names everything by ID, and the only place the real mapping lives is the CSVs. So the whole job is really just joining those ID-named files back to their metadata.  

    Another solution is, rather than reassembling ZIPs you already have, to re-extract using a tool that queries ContentVersion joined to ContentDocumentLink and downloads the VersionData with names applied on the way out. Data Loader can pull the CSVs, a Bulk API script or a tool like Salesforce Inspector Advanced can pull the binaries already mapped. This solution is only viable if the org is still accessible, which it often isn't in an offboarding scenario.

0/9000
When a new user is added manually, you have the option to check the box that says "Generate new password and notify user immediately".  If you don't want to do that initally and then later, say the next day, you want to notify the user of their login and password how do you do that?  Besides choosing password reset for the user.

 

Its confusing for a user if their first email is a password reset email vs the welcome message notifiying them of new account and login information.

 

Can anyone assist with this...Theres got to be a way
13 answers
  1. Aug 24, 7:15 PM

    More than 10 years later is there a workaround for this? We regularly enter users and then delay sending the reset password emails before a user training day and it would be nice to have the welcome email for user adoption.

0/9000
For my org, I have the Weekly Data Export scheduled for every Sunday so I can download the backup data on Monday at work. However, I noticed there isn't a "download all" button, but a "download" button near each folder. So far the export has only been 22 zip files, but I'm worried for the future when the amount gets bigger.

 

Right now, I'm using Google Chrome and hitting "download" for each file, but I have to wait for one file to reach a certain download amount before I can start the next file download. For example, I start download zip file #3, but have to wait for it to be 315 of 512MB before I can start zip file #4. If I try to save/download #4, I get the error message, "There are no more files."

 

Has anyone been able to download all the files at once? Is it a web browser issue, is there an app, or an idea to vote on?
10 answers
  1. Jan 27, 2020, 4:56 PM
    Hi Tamlyn,

     

    Unfortunately, there's no way to mass download all the zip files for data export.

     

    Please see below posts from other developers and customers on how to do this.

     

    Automate the downloading of Data Export zip files

     

    http://salesforce.stackexchange.com/questions/295/automate-the-downloading-of-data-export-zip-files

     

    Auto download Data Export zip file

     

    https://developer.salesforce.com/forums/?id=906F00000008ykxIAA

     

    Automated Backup Downloader

     

    https://success.salesforce.com/answers?id=90630000000h2yNAAQ

     

    You can also upvote this idea:

     

    https://success.salesforce.com/ideaView?id=08730000000Dr9qAAC

     

    Hope that helps.

     

    Regards,

     

    Jayson
0/9000
I'm trying to delete an Account record type, but it says that one of my user profile has it selected as the default. The user profile is called "External Who." When I try to click on it from the screen where it notifies me that it's using that record type as a default, Salesforce says I have insufficient privileges to view that user profile. I'm a System Administrator.

 

When I go to the "Profiles" section under "Manage Users," I don't see a user profile called "External Who." It's as if it doesn't exist. I also can't select that profile when editing a user. I can't see who created it or how. The biggest issue is that it is tied to the record type I want to delete.

 

Has anyone run into this before? How do I fix it?
25 answers
  1. Feb 4, 2016, 6:51 PM
    Here is an update on how to do this if you use the new Enhanced Profile User Interface.

     

    First thing to do is **disable** the Enhanced Profile User Interface checkbox in the User Interface

     

    Setup> Customize> User Interface> Setup Section> Deselect  Enable Enhanced Profile User Interface> Save

     

    Proceed with the following Steps:

     

    1)Follow this click path:

     

    Setup> Manage Users> Profiles> System Administrator> Navigate to Record Types> Click the Edit Link on the Object in question's Section

     

    At this Point you will be at the Edit Record Type Settings Page for the Object.

     

    2)Copy the URL from the address bar on your browser and paste it into note pad:

     

    https://naX.salesforce.com/setup/ui/profilerecordtypeedit.jsp?id=xxxxxxxxxxxxxxx&tid=Opportunity&pn=System+Administrator&retURL=/xxxxxxxxxxxxxxx

     

    3)Now follow this click path

     

    Open the external who profile, (or any others you need to update)

     

    You might get an insufficient privileges, that is fine we just need the ID from the profile.

     

    4)Copy the 15 digit Salesforce Id from the URL in the Address bar of your Browser:

     

    yyyyyyyyyyyyyyy

     

    5)You are now going to replace the id in the Edit Record Type Settings Opportunity Page ( the first id number right after the "jsp?id=" in the URL ) with the Id from the Chatter Free User.

     

    This:

     

    https://naX.salesforce.com/setup/ui/profilerecordtypeedit.jsp?id=xxxxxxxxxxxxxxx&tid=Opportunity&pn=System+Administrator&retURL=/xxxxxxxxxxxxxxx

     

    Should now look like this:

     

    https://na5.salesforce.com/setup/ui/profilerecordtypeedit.jsp?id=yyyyyyyyyyyyyyy&tid=Opportunity&pn=System+Administrator&retURL=/xxxxxxxxxxxxxxx

     

    xxxxxxxxxxxxxxx was replaced with yyyyyyyyyyyyyyy

     

    6)Now copy the modified Url and paste it in the Address bar of your browser and hit enter.

     

    7)You will now be able to remove the value by highlighting it and selecting remove. Switch the Default record type to whatever you like and hit save.

     

    NOTE - If no Record Type is wanted the default will HAVE to be "-Master-"

     

    Once you are finished you can turn Enhanced Profile User Interface back on.
0/9000

We are currently building notification framework to monitor Data Stream errors in Slack.  

 

On the DataStream object we can identify records with the ImportRunStatus field having a value of FAILURE. However, we cannot find where the error message content is stored (likely a related object looking up to this DataStream)   

 

When failures occur, the error message is visible to be previewed while on the Refresh History tab as shown in screenshot. This is the text content we are trying to find within SF schema.  

According to this link: a DLO exists for Problem Records, but in Query Editor or Data Explorer cannot find nor query this DLO, for example PR_DLO_<DataStreamName> - in Query Editor we receive an Insufficient Access error. In data explorer that DLO is not able to be seen in the lookup.  

 

Has anyone else managed to find where this error message is stored?  

Thanks in advance! 

 

How to access Data Stream Refresh History Error Message

 

 

image (4).png

 

image (5).png

 

 

 

7 answers
  1. Aug 24, 3:25 PM

    Hi Emma, did you identify whether it is possible to access the error details message? We have the same use case and need to access the message if possible.

0/9000

Hi Experts,

I want to do a mass exporting files or attachments specifically related to Salesforce objects such as Accounts, Contacts, Opportunities, etc. 

 

Could you please provide guidance and suggestions on the potential methods to accomplish this?

@Nonprofit Hub @Nonprofit User Group, Atlanta, US @Salesforce.org System Administrators @Salesforce Administrators & Developers 

8 answers
  1. Feb 11, 2024, 2:56 PM

    Hi Manjula Rajaram, 

     

    Recently I worked on the Data Migration- Attachements Of Contacts (Export:10,000 and Import:7,000 Attachments) by using Data loader  and also I used third party tool both were working fine. 

     

    Please fallow the below steps for Export:   

    1.Prepare the Soql and apply the export operation.

     

    Select  FieldsALL()  FROM Attachment where Parent.Type = 'Contact' order by createddate limit 1000

0/9000
Hi all,

 

I have a requirement to send set of PDF pages to a user as a single pdf.Can anybody help me to get an apex code to combine multiple PDF (Visualforce render as PDF) into one?

 

Pardon please, consider if any apex developers available here. I have added the post in developer community too .

 

Thanks in advance.
5 answers
0/9000

Hi all, 

 

I'm trying to make my life easier by updating our revenue schedules in Salesforce for 2027. Instead of doing it manually, I wanted to try using Dataloader for each of our products. However, I'm not sure how to go about it, as when I tried using the Opportunity Line Item object, it didn't have anything useful (account name, opportunity name, schedule date, etc).  

 

Is there a different way I should be going about this? 

 

#Data Management

2 answers
  1. Aug 20, 4:20 PM

    Hi Stephanie - you are on the right track, just the wrong object. Revenue schedules do not live on Opportunity Line Item; they are their own object: Opportunity Line Item Schedule. Each product line (Opportunity Line Item) has multiple schedule rows, and those rows are what you load. 

     

    Steps with Data Loader: 

    1. Prereq: scheduling must be enabled - Setup, Products, Schedule Settings (turn on Revenue scheduling), and enable revenue scheduling on each Product. Without this you cannot create schedules. 

    2. In Data Loader click Insert and pick 'Opportunity Line Item Schedule'. If you do not see it, turn on 'Show all Salesforce objects' in Data Loader settings. 

    3. Your CSV needs: the parent Opportunity Line Item Id, Schedule Date, Revenue, and Type (Revenue). Use Quantity + Type Quantity instead if you schedule by quantity. 

    4. To get those parent Ids, first export the Opportunity Line Item object filtered to your opps/products - that gives you the Ids (and the opportunity/product context) to build your schedule file against. 

     

    That is why the Opportunity Line Item export had no schedule dates - the dates and revenue split live one level down on the schedule object. Heads-up: if a line already has schedule rows, new inserts add to them, so you may want to delete the existing 2027 rows first. 

     

    If this helps, please mark it as the Best Answer so it helps the next person - thanks :)

0/9000
I came here after did configuration of Files Connect feature for sharepoint integration with salesforce but what i am getting is only i can see sharepoint files in salesforce.

 

but what i need is i want to upload file to sharepoint from salesforce, Is it possible ? i also gone through the different application but they all are paid services by the provider.

 

Is there any chance to upload a file to sharepoint from salesforce using apex code ?

 

please guide.

 

Thanks a ton 
21 answers
0/9000

      What would be the best way to complete a Mass export of all Attachments, Files and Notes and keep the related opportunity and account number? We need to physically move the PDF, Excel, and images files to our hard drive. Appreciate any assistance you can provide.    

4 answers
0/9000