Solved

Delphi 6 XML import into MySQL

Posted on 2008-06-22
5
1,072 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:dinilud
ID: 21844171
0
 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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