?
Solved

Delphi 6 XML import into MySQL

Posted on 2008-06-22
5
Medium Priority
?
1,155 Views
Last Modified: 2013-11-23
Hi,

have a problem, I have created a connection to web service that sends me back offical current exchange rates. I get back the results that I have to import into a mySQL database, the resulting XML is attached to this question.

I have tried various approaches to import data, but all have failed. Is there something wrong with a response?!
Or I just didn't find the right solution? If so, what should I do?

I use Delphi 6 and mySQL 5. something.

Thnx,
The_Player
xml-response.txt
0
Comment
Question by:The_Player
  • 3
  • 2
5 Comments
 

Author Comment

by:The_Player
ID: 21845134
@dinilud:
Ok... So, what the article is telling me is that there is no easy way of importing data from XML into database and that I have to parse and "walk" XML tree myself? (I hope I didn't got it right :( )

If this is the case, is there at least any XML parser to create a tree from XML?
0
 
LVL 10

Accepted Solution

by:
dinilud earned 1000 total points
ID: 21845967
0
 

Author Closing Comment

by:The_Player
ID: 31469544
Thanks... :)
0
 

Author Comment

by:The_Player
ID: 21870841
Actually, when I continued the way you mentioned, I found this very useful guide: http://www.agnisoft.com/white_papers/SOAP1.asp :)

After doing a step by step procedure I had a convertor up and running in no time! :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question