importing currency from xml source

[Osman]

Hi,

I want to import currency from http://www.tcmb.gov.tr/kurlar/kurlar.xml

but filemaker returns an error.

The error is sourced by bank or should i do somethink to prevent this error.

Thanks in advance

Adam

[Martin Brändle]

When I click on this link I get a page not found error.

[Osman]

sorry,

http://www.tcmb.gov.tr/kurlar/today.xml

[Fenton]

Basically you need to write an xsl stylesheet, to transform the xml into something you can import into FileMaker. This is not a trivial task, but it is not all that hard. You may also need to tweak the xml a little first, because of the "iso-8859-9" (Turkish), which FileMaker may or may not like. (I'm no expert on languages, being from southern California).

You might want to read this thread:

http://www.fmforums.com/forum/showtopic.php?tid/168465/post/170458/hl/Hebrew/#170458

where we had much the same problem, but with Hebrew. In that case the user was on a Mac. We used a "curl" command line to download the xml data to a local file, then switch the encoding to "utf-8". We then Imported into FileMaker, using an xsl file written specifically for his xml data. I believe similar could be done on Windows, but I wouldn't know the exact syntax.

Your data is similar to his; but different. It also has more elements. And it has many "records", many currencies. So, questions would be: "Which elements do you want, or all?" and "Which currencies do you want, or all?" It's pretty easy to get just some elements. It's a bit more tedious to get most, but not all currencies. It's easiest (by far) to just get all currencies, then delete the ones you don't want in FileMaker.

This is what a general xml record looks like, within the "Tarih_Date" root element. As you can see, there are several types of rates. Which do you want?

1

AMERİKAN DOLARI

US DOLLAR

1.3422

1.3487

1.3413

1.3507

1