LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MS-Word Documents into MySQL (https://www.linuxquestions.org/questions/linux-software-2/ms-word-documents-into-mysql-192401/)

dkroft 06-11-2004 01:45 PM

MS-Word Documents into MySQL
 
I am exploring making the content of MS-Word documents more useful by scrapping the MS-Word format, importing the contents into MySQL, adding Search capability, and having the users access this through a website.
The intent is to collocate forums, wiki, polls, and this document content to consolidate this shared real-time knowledge into a truly usable portal.

i have installed XOOPS (love it), and Wiki (love the idea, but it still isn't working right ;-(
I have a MySQL server, apache, php, odbc, MyODBC, and OpenOffice loaded and working.

I really think these "documents" will be better used in a format other than a classical document.
Sections and Tables that can be searched and assembled next to similar sections and tables from other documents, with the ability to annotate new cases, oversights, exceptions, unconsidered details, politically contentious points, new viewpoints, new tchnologies, etc. . . now that sounds like fun ;~)

I am attempting to open the Word docs in OpenOffice, save them in the OOffice native xml formats, then to load these XML objects into MySQL tables.

I have NOT written an XML-MySQL loader, or created the MySQL tables yet.

I briefly considered a different db like Postgresql - but MySQL seems like it predominates this arena (open to reconsideration).

Any Ideas? Already existing solutions, modules, packages? Flames? (ok, hold those for the moment)

Thanks,
d-


All times are GMT -5. The time now is 10:46 PM.