Import metadata from excel spreadsheet

I have just been saddled with the following requirements;

Provide a means to automatically update image metadata from an Excel file;

The requirement includes;

1. Creating an interface to select a mediaBin folder to apply import of metadata against.

Any one know how I can accomplish this using vb with the script model API.

The environment is MediaBin 4.6 on Win 2003

Find more posts tagged with

Comments

msrinivas

I had a similar request recently. We ended up dumping the excel sheet into Sharepoint lists and querying it and applying metadata. The business user ongoing will update the Sharepoint list vs. excel spreadsheet.

You wouldn't have to do the same but my suggestion is to move away from excel into a DB and then do it. It provides more scalability.

If there is no other way then you can interact with excel using VB and you can do that.

HTH

rabs

thanks for your reply.

They do not want to go with the DB option(which makes more sense to me)

Additional requirements include;
An interface to
1. display metadata for a folder
2. display the type of metadata displayed in (above)
3. display a drop down which will contain a list of column values from a excel spreasheet.
4. display the value of selected field from 3 (above)

They then want to be able to map the excel fields with the metadata.

Right now I am working on using some existing functionality in the web client asp code to do this.

Any advise from anyone who has done this would be appreciated.

msrinivas

The web client code will help you with the MB API calls to do your work. Google to get stuff on working with excel spreadsheets and VB/ASP. There is a lot out there.

rabs

Thanks for the advice.