How to add DotNetNuke localization for a country.

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 @ Friday, January 20, 2006 6:49 AM
Print

Comments on this entry:

# re: How to add DotNetNuke localization for a country.

Left by Felix at 2/8/2006 11:56 AM
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

Your comment:



(not displayed)

 
 
 
 
 

Live Comment Preview:

 
«April»
SunMonTueWedThuFriSat
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910