Word Docs

[1999jd]

I am having problems getting word documents to import into the MYSQL database. I want to be able to import these docs in and then allow these docs to be searchable by any keyword.

Any suggestions are appreciated.

 

[audiopro]

Word documents are notorious for being hard to decode due to the complex formatting codes they contain. I would suggest storing a .txt version (no formatting just words) in the database and link it to the .doc file stored as a file. This way, you can easily search for anything and still supply the original doc to the user.
How many documents are you working with?

Keith

http://www.studiosoft.co.uk

 

[1999jd]

All the records will likely have a word doc for reference, or maybe text. The problem is these docs will likely come in .pdf or .doc format then it would be nice to be able to automate the import to the MYSQL db and allow it to be searchable. The entire database will be structured around these documents, although I can add fields for manual data entry as well.

 

[johnwm]

To get the best from these forums read faq222-2244 carefully, as it will show you how to get (and recognise) the best answers.

As Keith said, store the data as text in a text field that you can index and store the file name in another field so you can serve the actual document when requested. Looks like you are a MS shop if you use word, so run an instance of Word on your server and use ASP or ASP.NET to open the doc and save it as text as each one is uploaded.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints