Changing link records across portals - Simple SQL


Friday, November 21, 2008 Login \| Register

Please Read

FAQ

Forums

Licensing

Feature Requests

Are you listed in the DotNetNuke Directory?

To start or answer a thread you will need to login...

Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement.

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service.

We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

Forums DotNetNuke Simple SQL Changing link records across portals

8/18/2006 6:59 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Changing link records across portals (United Kingdom)

I have been looking for a way to easily update a link that is shared by multiple portals. For example if several sites are created using a template that includes content for a links module. I would like to know if there is a simple query that would allow me to update all sites if one of those links changes.

Thank you

Harisahmed Brown

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog

8/18/2006 7:01 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Changing link records across portals (United Kingdom)

Hello Harisahmed,

When you say a "link" shared by multiple portals - how do you mean it is shared? By nature the Links modules store there data in one portal only? Or do you mean multiple records in different portals that happen to have the same link?

ie. Portal 1 and P2 both have a hotmail link. This is stored in the Links module table in 2 different records, by Portal ID and module ID.

It would be easy to update all occurrences of a link across this table – is this what you meant?

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

8/18/2006 7:26 AM

	Harisahmed Brown
1 posts

Re: Changing link records across portals (United States)

The example situation would be for intranet sites created for different departments. Each department's site may have different content, but the basic template used to create each site includes a standard links modules with content included. Each portal has it's own copy of the module and content, but each uses a different portalID (and possibly a different moduleID?). I need to know if there is a way that I could update a link using SQL that would change yahoo to hotmail for example. The only issue with mass updating the link might be if another site has a yahoo link, but it wasn't made using the same template. I guess that problem could be resolved by not including the portalID of the site(s) that don't need to be changed.

I appreciate the help.

8/18/2006 8:16 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Changing link records across portals (United Kingdom)

Ok, I had a look at the Links table, it does not store portal ID (you'd need to get it through the DesktopModules table or similar using the ModuleID to work out which Portal each module belongs to, if required.

To get the ball rolling, this would update all the links across all portals and all links modules. Note that the Title could be useful here if they were all named the same - eg. "Ref site" and then a link you wanted to change.

--this is across all portals and modules
SELECT *
FROM Links
WHERE URL LIKE '%yahoo%'
AND Title = 'x'

--this is across all portals and modules
UPDATE Links
SET URL = 'xxxHotMailxxx'
WHERE URL LIKE '%yahoo%'
AND Title = 'x'

Does this help?

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Page 1 of 1

Forums

DotNetNuke

Simple SQL

Changing link records across portals

Top Threads

In the past 1 week, we have 29 new thread(s) and 70 new post(s)

The most popular thread has been Re: Multipaid Sponsored Enhancements

The most active thread has been Multipaid Sponsored Enhancements / Crowdsourcing to improve modules

Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke -