How to export keywords from Expressions Media (iView) to Excel
There are several different methods for exporting keywords from Expressions
media and here are a few that I have used.
1. A custom VBScript to export the keywords to a CSV file and then import them
into Excel. (Works only on PC)
2. Use the "MAKE" --> "XML DATA FILE" feature within Expressions Media. (Works
on both Mac and PC)
3. Use VBA in excel to import the keywords from the active Expressions
Media catalog. (Works only on MS Excel that is older than 2006)
1. Custom VB Script inside of Expression Media
Using Expression Media scripts may vary from PC and Mac (
Check Here)
Based on the instructions for your version of Expression Media, save this script to the "plug-ins" (C:\Program Files\Microsoft Expression\Media 2\en\Plug-ins\Scripts\) directory on your machine.
This script will have some issues if you use commas instead of semicolons in your keywords but can be re-written to eliminate this.... I just don't want to spend
any more time on it....
Download VBScript Sample
2. Use "XML DATA FILE" Within Expression Media
First you need to create an
XSL.
SAMPLE XSL
Now that you have an XSL open your catalogue in Expression Media and from the "Make" menu select "XML Data File...".
A new window will appear with various options.
The only one required is the "Annotations" tick box, which must be ticked.
I would recommend that you don't tick the others as it will speed the processing up.
Don't tick anything in the "Create Folders" section otherwise it will create some folders for you!
At the bottom of the window is a section for "XSL Transform".
There is a button with a "+" on it. Select this and it will display a Choose File dialog.
You now need to select the XSL file that you have just created.
Now select the "Make" button. This will now prompt you to enter a file name and location for the result of the XSL transformation.
You must specify the extension to the file name as it defaults to XML. You need to add ".csv".
Select the "Save" button and it will create the CSV file for you.
Source
3. Export using Excel VBA
Here is an example that uses VBA and macros within Excel to export keywords
to Excel. To use this excel sheet first you must down load it to your machine.
Next you will have to open it with Microsoft Excel (not Mac:Excel) that is older than 2006.
Macros must be enabled. Once the excel sheet is open, open your Expression Media catalog and select
the images that you would like to export the keywords. Go back the the excel sheet and press the big green button. From there'
just follow the directions.
Download Excel File