Migrate Metadata into KM

[Former Member]

We have a large amount of MS Office documents and PDFs that we are plannning to move into our KM repository. These documents all have metadata stored within the document, i.e. Dublic Core metadata. We want to copy this metadata in the documents to the KM database. For example, we want to copy the Title metadata field of a MS Word document to the Name property of the corresponding document in KM.

Has anyone else done this? Could you recommend how?

[Former Member]

Hi Andrew,

I was involved in similar kind of activity in last year.

I followed below activities to mass upload the documents to KM and set metadata properties.

1) Design folder hierarchy on local system and moved respective documents to the folders

2) Manually collected all the meta data of those documents in an excel sheet.

(optional : I used VB script to convert these metadata into XML file )

3) Drag the Folder ( i.e. is created in local system) to the KM Folder using WebDAV.

4) Create KM Application which take XML/excel file and parse the XML/excel file and used KM API's to set meta data of those documents.

Hope this will give you some clue to your solution.

Regards

Sai Krishna Reddy