UK Cor Data GeoZones

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
1/23/2013 6:25:32 AM
crippsy
Gravatar
Total Posts 167
View Posts

UK Cor Data GeoZones

Hi,

I have just shared a file in my news article that will help with adding UK counties to your core data.

The article is located at http://smartcowmarketing.com/mojoportal-globalisation-for-uk-counties.aspx

but if you want the script file direct it is at http://smartcowmarketing.com/Data/Sites/1/SharedFiles/ukcounty-example.txt

It is a very simple script that we can change for adding other regions.

Cheers

Simon

1/23/2013 9:34:51 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: UK Cor Data GeoZones

The script looks incorrect to me, it does not have the correct CountryGuid. The correct guid for UK is 1fcc4a89-0e8f-4fa2-b8d0-4ff5ec2277df

​Note that the country guids and state guids are the same in every database and every database platform for the data that comes with mojoPortal.

The only problem is for data added manually after installation it will get a new random guid for the states/geozones just as they will with your script that uses newid().

Unfortunately this makes it difficult for me to add this data you have provided because others may have keyed it in already so if I were to add this data in an upgrade script it could result in  duplicates since we have no way of knowing what data may have been keyed. Possibly I could add it into the old script so that at least new installations will have the data for UK going forward without having to add it manually or by script.

Best,

Joe

​

1/24/2013 7:48:47 AM
crippsy
Gravatar
Total Posts 167
View Posts

Re: UK Core Data GeoZones

I didn't realise that the country GUID stay the same across installations. I have amended the script accordingly.

I fully understand that it would be a nightmare for some current installations to include the script in a future release.

This script can just be separately for developers wanting to add UK counties.

You must sign in to post in the forums. This thread is closed to new posts.