473,320 Members | 1,802 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Migrate XML to MySQL?

Hi all! I have a problem with xml-data. My small enterprice is asked to
renew one car reseller company's (Comp.) websites. This company uses
national dataservice (NServ.) about used cars and their pricing, and
it wants to keep that service going on.

I contacted NServ system operator and he provided me with four links,
three to their xml -feed concerning Comp:s data, one to relating DTD
-file.

Is it possible to transfer XML-data to Mysql-tables??? We have a fully
functioning Php-Mysql -program with configurable tables. If I could
automatically include Nserv data to my tables, problems would be
solved.

Please advise. I am newcomer in XML, so basic information, focused on
the problem - good manuals, good but reasonable cheap softwares etc
are also more than welcome.

Feb 16 '06 #1
4 1733
i use postgresql, but this should be possible.

you need to extract the xml data that you want to go into the mysl db
and then import the data into the db.

i'm also just learning xml manipulation. php.xpath offer some
functionality. there ar emany others, depending on your needs and
programming experience.

my initial thought would be to extract the data, put it in an OO.org
spreadsheet and then export as a csv file that can be read into mysql.

a google search or two should help a lot.

best of luck.

Feb 16 '06 #2
Yes this is possible. Just remember that parsing XML to input the data
is a bit slower than generating XML. And this is possible in more than
just PHP. Skeets, in a case like this, PHP would work, but I don't
think it is the best solution IMHO.

Feb 16 '06 #3
Pasi wrote:
Hi all! I have a problem with xml-data. My small enterprice is asked to
renew one car reseller company's (Comp.) websites. This company uses
national dataservice (NServ.) about used cars and their pricing, and
it wants to keep that service going on.

I contacted NServ system operator and he provided me with four links,
three to their xml -feed concerning Comp:s data, one to relating DTD
-file.

Is it possible to transfer XML-data to Mysql-tables??? We have a fully
functioning Php-Mysql -program with configurable tables. If I could
automatically include Nserv data to my tables, problems would be
solved.

Please advise. I am newcomer in XML, so basic information, focused on
the problem - good manuals, good but reasonable cheap softwares etc
are also more than welcome.


The XML FAQ is at http://xml.silmaril.ie/

///Peter
Feb 16 '06 #4
Has anyone tried parsing example 3 at www. php.net/xml and then
str_replace() -function.

In my example at http://www.icrea.fi/temp/test3.php I am at half way
through - Hopefully The parser works fine with external http://...
-link. My goal is to create install or update -clauses for each key
/ value -pair by having registration number (here sos_security) as
unique key at MySQL-table . The program first tries to install data. If
data already exists, the program updates that information.

Does this make sense?

Feb 19 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Phil Powell | last post by:
I've read some online resources that utilize various MySQL command-line actions to migrate data from Access to MySQL. The situation is this: a group of co-workers of mine will be using an Access...
1
by: Bruno BAGUETTE | last post by:
Hello, Where is the tool to migrate a mysql db to a PostgreSQL db ? The only thing I can find is an empty projet in the Gborg http://gborg.postgresql.org/project/mysql2psql/projdisplay.php ...
5
by: Fabio Benavides Murillo | last post by:
> Hello > > I have a problem, I want to migrate the data of a postgres' database to a > mysql's database, this because i need to move to a windows. > > I tried making a postgres' backup using...
6
by: Shimon Sim | last post by:
Hi I am working on application that need to hold custom user information - Last and first name, email, some other domain related information. I used to create Base class for all my pages. The base...
4
by: Roy | last post by:
Hi, Can anyone tell me how to migrate data from MySQL to DB2? Does DB2 offer such migration tools? Thank you. Roy
9
by: Algonquin J. Calhoun | last post by:
I've developed an application that exceeds the Access 2GB limit. This application was developed as a prototype and the users have found it very useful. Approximately 45,000 records are added to...
2
by: hebollozos | last post by:
Can anyone help me by giving me instructions how to migrate my MySQL Data for Windows to MySQL for Linux. I tried to find Sqlporter software by Realsoft Studio, but I failed. Hope somebody out can...
2
by: princelindie | last post by:
How do I migrate (copy) mysql database to another server/machine.
0
by: SLauren | last post by:
Hi friends, Are there are any guidelines for migrating mysql stored procedures to sql server manually? Please suggest. Regards, SLauren
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.