Javier Antó

Te voy a explicar en este caso, como agregar a la lista de regiones todas las provincias de España de forma que al seleccionar el país Spain, aparezca automaticamente una lista de provincias de las cuales el usuario puede seleccionar la suya. Lo vamos a hacer utilizando SQL ya que mediante el interface de DNN no sería tan rápido…

¡ Como siempre que se trabaja con consultas SQL existe el riesgo de estropear algo !

Haz una copia de seguridad antes por si necesitaras volver atrás…

Lo primero es entrar como host y acceder a Host SQL … ejecutaremos esta consulta que nos devolverá el ID que tiene ‘Spain’ en la base de datos

SELECT [EntryID]
FROM {databaseOwner}[{objectQualifier}Lists] Where Text = 'Spain'

(Normalmente el ID devuelto será el 64, pero en tu caso podría ser otro…)

En este momento sería sencillo ejecutar una consulta que renombrara ‘Spain’ a ‘España’ sin embargo he detectado que al renombrar este elemento deja de funcionar la geolocalización IP y el elemento España no se selecciona por lo que no te recomiendo cambiar esto.

A continuación se trata de hacer un Insert con todas las provincias de la siguiente forma. (Recuerda que si tu ID es distinto a 64 deberás cambiarlo)

INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Alava',N'Alava',64,1,1,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Albacete',N'Albacete',64,1,2,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Alicante',N'Alicante',64,1,3,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Almeria',N'Almeria',64,1,4,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Asturias',N'Asturias',64,1,5,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Avila',N'Avila',64,1,6,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Badajoz',N'Badajoz',64,1,7,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Barcelona',N'Barcelona',64,1,8,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Burgos',N'Burgos',64,1,9,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Cáceres',N'Cáceres',64,1,10,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Cádiz',N'Cádiz',64,1,11,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Cantabria',N'Cantabria',64,1,12,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Castellón',N'Castellón',64,1,13,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Ceuta',N'Ceuta',64,1,14,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Ciudad Real',N'Ciudad Real',64,1,15,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Córdoba',N'Córdoba',64,1,16,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Cuenca',N'Cuenca',64,1,17,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Girona',N'Girona',64,1,18,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Granada',N'Granada',64,1,19,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Guadalajara',N'Guadalajara',64,1,20,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Guipúzcoa',N'Guipúzcoa',64,1,21,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Huelva',N'Huelva',64,1,22,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Huesca',N'Huesca',64,1,23,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Islas Baleares',N'Islas Baleares',64,1,24,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Jaén',N'Jaén',64,1,25,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'La Coruña',N'La Coruña',64,1,26,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'La Rioja',N'La Rioja',64,1,27,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Las Palmas',N'Las Palmas',64,1,28,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'León',N'León',64,1,29,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Lleida',N'Lleida',64,1,30,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Lugo',N'Lugo',64,1,31,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Madrid',N'Madrid',64,1,32,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Málaga',N'Málaga',64,1,33,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Melilla',N'Melilla',64,1,34,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Murcia',N'Murcia',64,1,35,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Navarra',N'Navarra',64,1,36,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Orense',N'Orense',64,1,37,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Palencia',N'Palencia',64,1,38,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Pontevedra',N'Pontevedra',64,1,39,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Salamanca',N'Salamanca',64,1,40,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Santa Cruz de Tenerife',N'Santa Cruz de Tenerife',64,1,41,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Segovia',N'Segovia',64,1,42,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Sevilla',N'Sevilla',64,1,43,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Soria',N'Soria',64,1,44,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Tarragona',N'Tarragona',64,1,45,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Teruel',N'Teruel',64,1,46,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Toledo',N'Toledo',64,1,47,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Valencia',N'Valencia',64,1,48,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Valladolid',N'Valladolid',64,1,49,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Vizcaya',N'Vizcaya',64,1,50,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Zamora',N'Zamora',64,1,51,-1,'',-1,0)
INSERT INTO {databaseOwner}[{objectQualifier}Lists] ([ListName], [Value], [Text], [ParentID], [Level], [SortOrder], [DefinitionID], [Description], [PortalID], [SystemList]) VALUES ( N'Region', N'Zaragoza',N'Zaragoza',64,1,52,-1,'',-1,0)

A continuación accede a tu perfil de usuario y comprueba que la lista de regiones se llena con las provincias de España cuando está Seleccionado Spain en el país…