"Alvaro Cobo" <[EMAIL PROTECTED]> writes:

> Hi guys:
>
> I have the following problem:
>
> In the organization I work for, we have several standard formats which
> we have to write for each project we manage (for example:
> reports). These are MS-Word documents, for which I have created a
> database and several forms to store this information. The problem is
> that it is very time consuming to insert manually each one of this
> documents.
>
> I think the solution is to create a OpenOffice Template for the
> document, with specific tags, to recover and export the file
> "contents.xml" (which is part of the *.sxw zip file) 'automagically'
> to the MySql database inserting each part of the XML to their specific
> field in the database. So the users only have to write the document,
> upload the file and the server does the job.
>
> The questions are:
>
> a) Is it possible to do that? Somebody has tried something like that?.
>
> b) What do you think about the idea? Could it be too complicated? Am I
> in the wrong path?.
>
> I will appreciate any clue or comment about these questions.
>

I would go from the other direction.  I would use OpenOffice.org to create a
data entry template, where the user would enter the field information that
goes into the database, then I would have an OpenOffice.org macro/template
that would create the document out of the database fields.

It seems conceptually easier to build the document from the data than to
create the data from out of the document.

Dave in Largo, FL


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to