Internationalization of FP Application

Don Bush don at caffco.com
Fri Aug 24 06:33:28 PDT 2007


here is a copy of  the country codes I download from the internet and 
put into filepro a few years ago.
I just zipped the entire filepro structure.


At 06:59 PM 8/23/2007, fp at casabellagallery.com wrote:
>Scott posted:
>
> >
> > I'm just starting to think about internationalization of my application.
> > Most of our customers/orders/ship to location stuff is in the US but
> > occasionally we have to handle something outside US.  Typically Canada,
> > Mexico, Latin/South America, Carribean, but occasionally somewhere else.
> > Has anyone gone through this process and come up with a to-do list?
> >
> > So far I have thought of a few items that I would like to ask for
> > comments on (and anything else you can share).
> >
> > Country Code:  Is there an official list of these (like the state codes
> > in US).  Where do I get it and or is it already a part of fp edits (I
> > don't think so).  Would this be well handled as an edit or are there so
> > many potential country codes that it would be better handled as a fp
> > file that we lookup to?
> >
> >
> > Phone#:  Can we use a phone edit for international numbers or do we need
> > a different or modified edit.  Or do we need a field with no edit at
> > all?
> >
> >
> > Zip Code: I know fp has US & Canada handled.  What are the international
> > condiderations?
> >
> >
> > State:    Is this a field that we just would not use for an
> > international address?
> >
> >
> > Any guidance would be appreciated.
> >
>
>Scott,
>
>I am not sure if you are ONLY concerned with mailing address
>or all things possible.  If mailing address is your primary
>concern, I'll say you have nothing to worry about but the integrity
>of the personnel typing the information.  You just cannot have
>a standardized address system for all Central American, South American
>and the Caribean countries.  You will find that most of these countries
>do not have a standard system themselves.  This is due to massive
>development without preconceived studies or control.
>
>That said, for addresses in these countries your best shot would be
>a group of fields (free hand text) of 5 or 6 lines ...
>
>If your concern goes beyond a mailing address, you then need to look
>into LAW, Language, Currency, etc.
>
>LAW because you will find that throughout these countries, invoices
>are government controlled and often forms are sold by government agencies.
>Depending on your target industry, you'll find volumes of regulations
>and "red tape" procedures that must be followed or else ... Countries
>such as Brazil, Guatemala, Ecuador, Bolivia, Nicaragua, Mexico, etc. all
>have enough variations in how invoices are handled to drive a programmer
>crazy.
>
>Language, of course, this is a given.  It is closely attached to LAW.
>Some of these countries will NOT accept an invoice as valid unless it is
>fully spelled out in its native language.  I can understand that!  Can you?
>
>Currency.  Uh, a beautiful nightmare!  As moneys and invoices exchange hands,
>you need to keep track of their currencies UP/DOWN so that you can properly
>report balances.  In the same token, you MUST be able to accept payment in any
>currency as some companies are "International" and will gladly take anything
>for as long as they get paid.  Which brings you back to LAW ...
>
>As you can see, it is a LOT easier to write applications for the good old USA
>market where most people have plenty of business within their immediate cities
>and when they billed to a foreign country, they will NOT accept anything but
>$US$ and leave all the legal stuff to brokers or lawyers for hire and uncle
>SAM is simply happy to collect its share and wish you well.  :)
>
>I could go on but I do not want to scare you out of your idea.  I think it
>is great that you are looking at the rest of the world as a potential market
>for your application.
>
>Good luck!
>
>
>Jose Lerebours
>954-559-7186
>http://www.fpgroups.com
>
>
>
>
>
>
>
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: country.zip
Type: application/zip
Size: 8682 bytes
Desc: not available
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20070824/ae505d30/attachment.zip 


More information about the Filepro-list mailing list