Geeks With Blogs

Michael Freidgeim's Blog MS .Net Development

I've created an SQL to add australian regions and australian currency to DNN Lists table. The task is discussed on DNN Forum.

-- =============================================
-- Create procedure basic template
-- =============================================
-- creating the store procedure
IF EXISTS (SELECT name
    FROM   sysobjects
    WHERE  name = N'{databaseOwner}{objectQualifier}Localization_AddAustralia'
    AND    type = 'P')
    DROP PROCEDURE {databaseOwner}{objectQualifier}Localization_AddAustralia
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}Localization_AddAustralia
AS
declare @CountryId integer
SELECT @CountryId=[EntryID] FROM {databaseOwner}[{objectQualifier}Lists]
where  [Text]='Australia'
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','ACT','Australian Capital Territory', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','NSW','NEW SOUTH WALES', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','NT','NORTHERN TERRITORY', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','QLD','QUEENSLAND', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','SA','SOUTH AUSTRALIA', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','TAS','TASMANIA', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','WA','WESTERN AUSTRALIA', @CountryId, 1)
INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
 VALUES('Region','vic','Victoria', @CountryId, 1)

INSERT INTO {databaseOwner}[{objectQualifier}Lists]( [ListName], [Value], [Text], [ParentID], [Level]) --, [SortOrder], [DefinitionID], [Description])
  VALUES('Currency','AUD','Australian Dollars (AUD)', 0, 0)


/*-- =============================================
-- example to execute the store procedure
-- =============================================
EXECUTE {databaseOwner}{objectQualifier}Localization_AddAustralia
*/
GO

Update:cathal has a script here with additional regions for DNN3 for about 30 countries.

 

Posted on Friday, January 20, 2006 6:49 AM | Back to top


Comments on this post: How to add DotNetNuke localization for a country.

# re: How to add DotNetNuke localization for a country.
Requesting Gravatar...
Great! Found this just after I coded the SQL myself. Two suggested improvements:
1) Consider using Propercase for the State
2) Consider to have each entry surrounded by

IF not exists ( SELECT 1 FROM {databaseOwner}[{objectQualifier}Lists] WHERE ListName = 'Region' AND ParentID = @CountryId AND [Value] = 'ACT') BEGIN

-- insert ACT here ...

END

Left by Felix on Feb 08, 2006 11:56 AM

Your comment:
 (will show your gravatar)


Copyright © Michael Freidgeim | Powered by: GeeksWithBlogs.net | Join free