Add Metadata To Excel Manual To Get

Statement: Articles reproduced or quoted on this site involve copyright issues, please contact the webmaster to handle.

But if I download the file from the internet, automatically the creation date and modify date are set to current time and date.

I looked upon the files properties, and found that in section Details, under personal information, there is a section called Source and there, it has a property called Content Created with the original date file.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged java excel properties ms-office metadata or ask your own question.

You will find one named 9780749460969.jpg in the archive. Now, go to the Insert tab and click on the Picture icon.

With this in hand, you could transmit your precious information about your books and ebooks to your trading partners.

But could you use your metadata for another purpose What if you want to produce a catalog of your titles Do you need to do it from scratch Of course not This step by step guide will show you how to create a complete titles catalog with your day to day tools: ONIXEDIT and Microsoft Word.

The ONIX file came from one of our client, the Australian distributor Woodslane.

You will find all the required files, links and scripts used by this tutorial here.

For this tutorial, I used the file Woodslane1104repkit.xml from Woodslane included in this archive.

I open it with ONIXEDIT version 2.4.0.

Then I select a few titles and press F5 to call the export function.

Then I create an export script that will contains all the data elements I need for my catalog.

You will find that script named Export Catalog Feed.import in the archive.

From the Export dialog, click on FileOpen and open the script.

Add Metadata To Excel Manual To Get

See the Export to a Flat File or Excel topics in the How to section of the user manual to get more information about Export script.

Then click on the Display Conversion button to see the resulting table.

Next, click on Convert and Export ONIX to Flat File or Excel File button to generate the Excel file.

You will find the resulting Excel file named Catalog Feed.xls in the archive.

Here is a picture of the resulting file.

But if you used 2007 or 2010 version, you should save your template in Word 2003 because data binding with dynamic pictures will work only under Word 2003 document (with extension.doc).

Choose the File Type Word 97-2003 if you are using Word 2007 or 2010.

We are going to use the Mail Merge function of Word to create our Catalog.

Click on OK. Now, using the Insert Merge Field dropdown menu, you can insert placeholders for your data.

Here, I just place the title, the ISBN, the price, the author and a text box with the Resize AutoShape to fit text option to place the description of my books.

Close the resulting document without saving it and get back to your template.

Now that its done, we will modify our template to automatically create front cover of our books.

In our Excel file created in step 1, there is a column named MediaFile1ImagefrontcoverMediaFileLink.

That column contains url of books front cover like this one.

To allow Word to bind a placeholder to those pictures, it is a little bit tricky.

You will find one named 9780749460969.jpg in the archive.

Now, go to the Insert tab and click on the Picture icon.