Is there a way to extract information from a Sharepoint document library (Word documents) to a MySQL database?

Question

The Sharepoint document library is running off of a MS Small Business Server 2003. It is full of Word documents (order forms), with fields inside the documents. I am looking to extract information from the fields in those Word documents and import that data into a MySQL database. If that is not possible, is there a simple way to install a search function into Sharepoint? Thanks for your help.

Answer 1

If your looking for a straight up code from me to do this, that's not what your going to get.

Is it possible?

Absolutely, you probably need to write the code to extract what you want, make it into a easy to use function. I would continue looking on the internet, because looking for a answer on yahoo answers for something so specific would be very rare to have somebody give you the actual code. But if you do get it, then thats great. good luck.

Answer 2

Using PHP, you could use this library: http://www.badblue.com/helpphpo.htm

Consult the library documentation.

With this, you can load an entire Word document into a PHP string and manipulate it with other standard PHP functions and reinsert it back into MySQL or anything else you might need to do. PHP is a very versatile scripting language. Good Luck.

Answer 3

You could use a streamreader. In this way you divide the entire document to a stream. This stream you can manipulate and extract the items you need to your database

Helmut