Country Names [FIXED]
Hi there, How's it going? Thanks a lot for your tool, very impressive effort. I am a software developer in an international organisation. I have developed a system that has a bunch of indicators associated with countries and we are looking at your great tool to help us visualize some of this stuff. Thing is, we need to use our country names. Not a problem I hear you say. I have already started 'building' a data.csv using my names (I wrote a small Java program to help me with the translation, as we too use iso3 codes). The problem is we have commas in some of our country names e.g. "Hong Kong, China SAR". This confuses StatPlanet somewhat. I tried the standard trick of putting the country name strings in quotes, but this just got interpreted literally. Any chance we might be able to encourage a fix on that? Also, some of the ISO3 codes you use are wrong. Not such a big deal, I have created a mapping file to help me translate e.g. your ISO3 -> our ISO3 -> our country name ... cheers, Andy |
Thanks for all the info.
Thanks for all the info. Don't worry about the source stuff on our account, we'll deal with it. Would be nice to have the option of commas, though.
Frank, can I email you privately to discuss something? You can get my email from my user account.
Cheers,
Andy
Hi Andy, It is written in
Hi Andy,
It is written in ActionScript3, I will look into 'commas in quotations' and see if it can be integrated into the next release.
I just removed your duplicate post, this one was indeed awaiting moderation. Moderation should now be removed.
(about your suggestion of using a Captcha - this site recently switched from a 'math' Captcha to an 'image' Captcha for registration, as the previous one failed to prevent spam. Now moderation for registered users may no longer be necessary.)
Hi Frank, Thanks for the
Hi Frank,
Thanks for the quick reply.
These are the codes I had to map (hope the bit of Java is okay). The first three seem like definites, the last four are more up for grabs I'd say as they are
ISO_3_EXCEPTIONS_MAP.put("FIJ", "FJI"); // Fiji
ISO_3_EXCEPTIONS_MAP.put("SEY", "SYC"); // Seychelles
ISO_3_EXCEPTIONS_MAP.put("TAN", "TZA"); // Tanzania
ISO_3_EXCEPTIONS_MAP.put("ZAN", "EAZ"); // Zanzibar (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("IMN", "IMY"); // Isle of Man
ISO_3_EXCEPTIONS_MAP.put("JEY", "GBJ"); // Jersey (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("GGY", "GBG"); // Guernsey(for future, maybe)
I took the info from http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3.
As for the other matter. I think comma separated is fine, but you probably just need to take quoted string as literals (so if a comma exists in the name it the name the country has to be quoted e.g. France, United Kingdom, "Hong Kong, China SAR". That is how Excel handles it. What language is the core of your system written in? I haven't done any Flash stuff and my Javascript skills are rudimentary but I could help out if it is Java or php (actually, I can recommend a library that takes care of this if you are using Java).
Cheers,
Andy
Hi Andy, Thanks for your
Hi Andy,
Thanks for your message. Could you met me know which ISO3 codes are incorrect? You are right, commas cannot be used. An earlier version of StatPlanet read data from a Tab Separated Value File Format (txt). However, it appears that on some servers the tab format is not read correctly by Flash. In the upcoming release I could re-introduce a version of StatPlanet that reads a 'tab' file instead, and you could give that a try.
If you can think of any other solution that could work with Flash, I'd be happy to give it a try.
Frank
Hi Frank, Thanks for the
Hi Frank,
Thanks for the quick reply.
These are the codes I had to map (hope the bit of Java is okay). The first three seem like definites, the last four are more up for grabs I'd say as they are
ISO_3_EXCEPTIONS_MAP.put("FIJ", "FJI"); // Fiji
ISO_3_EXCEPTIONS_MAP.put("SEY", "SYC"); // Seychelles
ISO_3_EXCEPTIONS_MAP.put("TAN", "TZA"); // Tanzania
ISO_3_EXCEPTIONS_MAP.put("ZAN", "EAZ"); // Zanzibar (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("IMN", "IMY"); // Isle of Man
ISO_3_EXCEPTIONS_MAP.put("JEY", "GBJ"); // Jersey (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("GGY", "GBG"); // Guernsey(for future, maybe)
I took the info from http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3.
As for the other matter. I think comma separated is fine, but you probably just need to take quoted string as literals (so if a comma exists in the name it the name the country has to be quoted e.g. France, United Kingdom, "Hong Kong, China SAR". That is how Excel handles it. What language is the core of your system written in? I haven't done any Flash stuff and my Javascript skills are rudimentary but I could help out if it is Java or php (actually, I can recommend a library that takes care of this if you are using Java).
Cheers,
Andy
Post new comment