Skip to main content
Marco Duravia (3DZ SPA) 님이 #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개
  1. 2024년 5월 9일 오후 10: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