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 :)
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
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 :)
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
is working on a reply...