API
Version 7.x > API > Store the metadata of a MS Office document when uploading as an attachment View modes: 
User avatar
Member
Member
m.kreltszheim-rocksolid.com - 12/9/2012 6:17:27 PM
   
Store the metadata of a MS Office document when uploading as an attachment
Hi,

I am looking for some assistance on how I can go about chaning Kentico so that it stores the metadata of a MS Office document (e.g. MS Word) when in the Description field.

My end goal is that I would like to be able to search on the metadata of attachments which are MS Office Documents.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 12/14/2012 2:03:44 AM
   
RE:Store the metadata of a MS Office document when uploading as an attachment
Hi,

As I mentioned in the ticket:
You can configure the Kentico search to search in files using the full text search configuration. However, this index covers the documents content - but in the index configuration, the binary data column is used, so this may include the metadata too. This is the easiest and the fastest way.

As the second possible option, you can create your own solution if you want to work just with the metadata of Office files. You are able to work with Open XML in the last version of office documents. However this is general question and you will need also the advanced knowledge of programming in C# (eventually in VB.NET).

You can take a look at the following articles:
1. http://msdn.microsoft.com/en-us/library/bb656295%28v=office.12%29.aspx
2. http://wditot.wordpress.com/2012/05/10/extracting-metadata-from-ms-office-docs-programmatically/
3. http://code.msdn.microsoft.com/Setting-Custom-Properties-2f20414d
4. http://stackoverflow.com/questions/5826067/read-and-write-office-document-custom-properties-without-automation
5. http://wditot.wordpress.com/2012/05/10/extracting-metadata-from-ms-office-docs-programmatically/
6. http://bytes.com/topic/c-sharp/answers/757466-c-app-reading-modifying-ms-office-document-meta-data