Re: xml to mySQL

2007-09-26 Thread Rob Wultsch
Hi Adhiraj, I am going to assume that the keys and values are not static. If they are, then this is just a matter of parsing XML into key, value combinations. A simple, but often less than ideal way of solving a problem like this is to use several tables: # The entries table is the equivilant of

xml to mySQL

2007-09-26 Thread Adhiraj Joshi
Hi All, I wanted to know the possible ways in which an xml document can be stored in the mysql database. So the keys in an xml are the columns in the database and the key values in xml go as the values for columns. I dont want to use java if thats possible. Thanks in advance, Adhiraj Joshi.

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 > databa

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

Converting XML to MySQL DB

2005-07-12 Thread reality
Hello, I'm just looking at implementeing the DMOZ open directory into a mysql DB, and having had a quick look notice its in XML format. Does anyone have any insight into go about this - is it even a good idea?(I want to use mysql fulltext search on the data). I'm sure there must be some resource

XML to Mysql

2004-11-08 Thread gunmuse
This may just sound stupid but I am going to ask anyway.   We run a search engine and we bring in 3+ XML feeds from other search engines  Via perl and PHP.   So we can end up with 300 results listed for EACH SEARCH.  They are only valid for that ONE SEARCH but we need to track every click f

XML to MySQL

2004-03-17 Thread Boyd E. Hemphill
Are there any open source (or other) to load an XML document directly to a MySQL table or set of tables? Any recommendations would be greatly appreciated. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body,