Solved

Delphi 6 XML import into MySQL

Posted on 2008-06-22
5
1,047 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
 
LVL 10

Expert Comment

by:dinilud
Comment Utility
0
 

Author Comment

by:The_Player
Comment Utility
@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 250 total points
Comment Utility
0
 

Author Closing Comment

by:The_Player
Comment Utility
Thanks... :)
0
 

Author Comment

by:The_Player
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
generate a dynamic mysql query 2 36
PHP and Soap 3 26
XSL-FO - show results in 2 columns 5 23
ASP.NET reading ATOM 2 22
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now