Re: Export OpenOffice XML to Mysql

2005-08-02 Thread J. David Boyd
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]



Export OpenOffice XML to Mysql

2005-07-29 Thread Alvaro Cobo
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. 

Thanks a lot and best regards.

Alvaro.