Export design studio assets.

Version 3
    Issue Description
    I would like to export design studio assets (images and files). Can support do that for me?

    Issue Resolution
    Unfortunately support doesn't have an option to export design studio assets (images and files). However, when reviewing few community discussions, we were able to see an workaround with the help of a scraper chrome extension and Excel. It looks like the entire process takes about 10 minutes. We would also like to mention that this isn't recommended by Marketo support and support will not be able to assist you on this if you face any error. 

     

    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.

     User-added image

    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..."

      scrape-capture.jpg

    • 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.

      scraper.JPG

      **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.** 

      pages.JPG


    •  



      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.

      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

      visual-basic.JPG

    • 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

      MacroScript.JPG

    • 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

      macrosbutton.JPG

    • 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.


    Who This Solution Applies To
    Everyone.

    Is this article helpful ?

    YesNo