Skip to main content
Marco Duravia (3DZ SPA) ha fatto una domanda in #Service Cloud

Hi to all,

In our org we have a lot of cases with internal and customer files that can be too big (around 1GB) and now we are out of file storage limit.

I’m trying to download old and large files but I can’t download it manually because they are a lot.

I paid for the app in the app exchange “Files Downloader” but with the large file it’s so slowly and sometimes crashes. It don’t allow me to download multiple files simultaneously (only the small one can download simultaneously) and it’s so boring.

I tried to export file from Salesforce setup with a scheduled export but it download binary files and it’s not a solution for us.

Anyone have a solution for my problem? I read a lot of articles and I watched a lot of video but without a solution! Thanks

#Service Cloud
10 risposte
  1. 9 mag 2024, 22:32

    Yes here is how you do it:

     

    1). Use DataLoader and export all of the 'ContentDocument'

    2). In the CSV file that gets extracted, look for the 'LATESTPUBLISHEDVERSIONID' Column

    3). Add another column to the Excel file on the right of 'LATESTPUBLISHEDVERSIONID' and use the formula =CONCATENATE("URL",R2)

     

    Basically what we are trying to do is fill this next column with urls like : 

     

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/LATESTPUBLISHEDVERSIONID

     

    So at the end of it all you should have rows and rows that look like this:

     

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/SOMEVERSION

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/SOMEVERSION

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/SOMEVERSION

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/SOMEVERSION

    https://YOUR_INSTANCE_URL/sfc/servlet.shepherd/version/download/SOMEVERSION

     

    Now all you have to do is get a chrome extension called 'TAB SAFE' which is listed here: 

     

    Tab Save (google.com)

     

    And whatever block of urls you put there, it will down load all of the files. 

     

    If you dont like dealing with excel and are more excel savvy, you can write custom Apex to export the URL's. As long as you can copy paste those URL's in that Chrome extension, it should be able to download all those files.

     

    Let me know if this works for you.  

0/9000