Which table controls the LINKS module Open in new window option?
Last Post 10/16/2014 11:45 AM by Joseph Craig. 3 Replies.
Author Messages
Franco
Nuke Newbie
Nuke Newbie
Posts:1


--
10/15/2014 5:10 AM  
I looked the forum over, tried searching but either I make the wrong question of the question is such that it generates too much "noise".

I'm trying to mass import a bunch of URL links in my Links module via SQL database. The process seemed pretty straightforward until I tried to set my links to open in a new window.
At that point I realised there was no BOOL switch in the Links table and even looking at the module code I could not figure out where in heavens you can set the flag Open link in a new browser window to true.

Anyone figured this out?

I tried googling it up but couldn't find anything either.



Thought of using the documents module instead (there is a handy tutorial on data mass import here) but it's kinda complicated since you have to pump data into three tables in order to do the job.

I'm officially stuck. Help please

Joseph Craig
DNN MVP
Posts:11667


--
10/16/2014 9:11 AM  
I took a quick look at the data provider for the module.

If you are brave enough to do things in SQL, it's often better to look for appropriate stored procedures ...

Now, I looked briefly, so this isn't an definitive answer, but it's a place to start. There is this store procedure created by the Links module:

CREATE PROCEDURE {databaseOwner}{objectQualifier}dnnLinks_AddLink

	@ModuleId    int,
	@UserId      int,
	@CreatedDate datetime,
	@Title       nvarchar(100),
	@Url         nvarchar(250),
	@ViewOrder   int,
	@Description nvarchar(2000),
	@RefreshInterval int,
	@GrantRoles nvarchar(500)


That seems to correspond to the screen shot of the Add Link part of the module, so you probably should be able to use it.

Joe Craig, Patapsco Research Group
Complete DNN Support
Franco
Nuke Newbie
Nuke Newbie
Posts:1


--
10/16/2014 10:47 AM  
Ok, thanks for the clue.
The stored procedure did not solve much but I got to see another one that helped me solve the problem.

It sets the Open in new browser window in the UrlTracking table
Joseph Craig
DNN MVP
Posts:11667


--
10/16/2014 11:45 AM  
Good.

Joe Craig, Patapsco Research Group
Complete DNN Support


---