Mass Export Images and Files from Design Studio

[Mel_Dadoly]

It would be great to be able to perform a mass export of files from the Design Studio. This is a request I run into with regularity and I think it would be very useful. Right now, the only option is to download files one by one which is rather time consuming.

[Grant_Booth]

For customers who are expiring an old instance, being acquired, etc., this would be a very handy tool to have! We continue to get cases requesting it frequently.

[Anthony_Dykstr1]

This needs to be implemented or at least something that should be available from support. We're planning on implementing a new naming convention for all of our assets while also planning to purge old unused assets. Being forced to tackle this task on a one-by-one basis is the furthest thing from an efficient use of time.

[Anthony_Dykstr1]

Since Marketo Support was unable to offer any help with this I was able to come up with my own workaround with the help of a scraper chrome extension and Excel. The entire process takes about 10 minutes.

Here's what you'll need

• Google Chrome
• ​Scraper Chrome Extension - Download
• Microsoft Excel ***With the developer tab enabled*** - Learn how to enable the developer tab here
  

Step 1

• Download and install the scraper chrome extension.
  
  

Step 2

• Log into marketo and go into the design studio.
• Click on Images and Files to display your asset library
• Then click on this button to open your library in it's own window.
  
  
  

Step 3

• With the new window open, right-click in the white space to the right of your list of assets and select "Scrape similar..."
  
• Set the selector options in the scraper tool to the following and the click the "Scrape" button. You should see a list of all your asset file names on the right side of the scraper tool. Click on "Copy to clipboard" and paste the file names into column A in your spreadsheet.
  
  **Note the scraper will only copy the file names that are visible on that page so you will have to repeat the Scrape / Copy / Paste process for every page of assets that you have.**
  

Step 4

• After you've successfully completed Step 3, tidy up your spreadsheet to remove all the cells that don't contain a file name.
  
  

Step 5

• In Excel we'll use a Concatenate function to prepend your marketo URL path to all of your file names.
  Example: "http://info.yourdomain.com/rs/555-ABC-777/images/"
  
  
• In cell B1 type =CONCATENATE("insert your url path here", A1 then press ENTER. You should now see the complete URL path and file name like so. Example: "http://info.yourdomain.com/rs/555-ABC-777/images/header.jpg"
  

• Select cell B1 and click the little square handle in the bottom right corner of the cell and drag it down to the bottom of your list which will apply the formula to the rest of your list.
  
  
• Now select / copy (Ctrl+C) everything in column B, then right-click cell A1 and choose "Paste Values".
  
  
• Delete all contents from column B and you should be left with all of the URLs to all of your image assets in column A.
  
  

Step 6

• Create a folder on your C: drive or somewhere on your computer that you want to save all of your assets from Marketo
  Example: "C:\MyImages"
  
  

Step 7 - This is where the magic happens

• In the Developer tab click on Visual Basic
  
• In the Visual Basic window navigate to Insert > New Module
  
  
• Write the following Macro script into the Module window.
  **Be sure to replace all of the highlighted areas with the path to the folder you created in Step 6.
  **Also be sure to change the number circled in red with the total number of URLs in your spread sheet
  
• Click File > Save, name your file and **be sure to change "Save as type" to Excel Macro-Enabled Workbook** and close out of Visual basic.
  
  

Step 8

• Go back to the developer tab in your spreadsheet and click on Macros
  
• Select the Macro that you just created and click Run. If you typed the script correctly Excel will begin to download all of the files in your spread sheet to the folder that you specified and alert you when the download is complete.

Hope this helps. Enjoy!

[Steve_Carlton]

Just wanted to say thank you! This saved hours of work!