Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Matt Taylor 873 posts 2086 karma points
    Jul 23, 2011 @ 11:11
    Matt Taylor
    0

    Importing countries from XML file?

    I heard it mentioned that there was a way to import all the countries from an XML file.

    Do you have any further details?

    Thanks,

    Matt

  • Rune Grønkjær 1371 posts 3102 karma points
    Jul 23, 2011 @ 11:25
    Rune Grønkjær
    0

    Hi Matt,

    I have never done it from an xslt file, but i have done it from a csv. I have written this blogpost about dynamic VAT, and it also have a link to a csv containing all countries. The countries of the European Union is marked in the csv as well. The country list is made from ISO data and I have personally and carefully marked the EU countries as we are using the list in our own web shop on teacommerce.dk.

    What I did was to import the csv into a temp table and then "pump" the countries into the Tea Commerce countries table. I also created an auxillary table with all the id's of the EU countries, which I could use in my custom .NET code.

    That's the way I did it anyway. Hope it will help.

    /Rune

    p.s. If you have more questions it will be several hours before I can answer again as we are almost ready to drive to our vacation location. I will have some kind of internet there though :)

  • Matt Taylor 873 posts 2086 karma points
    Jul 23, 2011 @ 12:00
    Matt Taylor
    0

    Thanks Rune,

    No worries, I wasn't expecting an answer at the weekend anyway. :)

    I'll look at your method for sure. I remeber Anders saying something about this to me but I expect he was referring to your method.

    Cheers, Matt

Please Sign in or register to post replies

Write your reply to:

Draft