Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/abd9374373f3a34e#
Have have came across major improvement and at the same time feature
that will benefit all users.
We need to refactor how we currently store and use Countries and
States so it's:
1. All data (countries/states/cities) and their translations are
stored in it's own table - independent from current Phrases table
(quite big) in order to escape table JOINs.
2. Add functionality to include States/Provinces and Cities for all
Countries world wide - not only US and Canada as we have now.
3. New Sections to Manage all of it (Countries/States/Cities),
including relations and translations.
4. Connect all 3 fields (country, state, city) to ALL forms that are
using these now + add auto-complete drop-down for the City field for
selected Country/State combination.
5. Create the ability to import States and Cities data for selected
Countries right in the In-Portal Admin via web-service running on In-
Portal.com. This is quite critical since initially we'll be shipping
only US and Canada States and Cities. While complete database is about
3 million records.
Let me know if I am missing anything here!
PS.
By th way, we are already in the process of working on In-Portal 5.1.0
which will include lots of good stuff.
You can checkout the list blow. While it's not final, I think it's
most of it, though
DA.