DotNetNuke 6,7 - client scripting

Some tips for DNN 6,7 client resource managment.
How to properly deal with custom javascripting:

http://stackoverflow.com/questions/15769131/dotnetnuke-how-do-you-add-javascript-or-css-file-to-content-resource-management
http://www.dnnsoftware.com/wiki/page/client-resource-management-api

DotNetNuke 6,7 - researching, estimating

Small researching whether is DotNetNuke dead or still kicking?

Are there true alternatives in ASP.NET CMS arena.

Just some hints:

http://w3techs.com/technologies/details/cm-dotnetnuke/all/all

Good objective review :

http://inspectorit.com/cms/what-a-cms-matrix-wont-tell-you-about-dotnetnuke/

Clear Pro & Con:

http://www.latitudecg.com/software-blog/latitude-insights/2013/05/03/dotnetnuke-(dnn)-7.0-review

Is Community Edition crippled in favor of PRO ?

http://stackoverflow.com/questions/4888720/dotnetnuke-pro-vs-community-versions

DotNetNuke Community vs Professional Edition:

http://www.clarity-ventures.com/resources/dotnetnuke-cms-resources/dotnetnuke-community-vs-professional-edition

Integration with Social networks from version 6:

http://www.cmswire.com/cms/social-business/dotnetnuke-goes-social-with-version-62-015844.php

DotNetNuke 6.2 also exposes a full RESTful social API that enables users to create unique applications using social content from DotNetNuke. The API leverages new client-based web development techniques using popular JavaScript frameworks like  jQueryUI and Knockout.js.

DNN Evoq pricing

http://www.clarity-ventures.com/articles/article/721/a-costbenefit-analysis-of-dnn-professional-dnn-enterprise-and-dnn-community-dot

DNN 7 raises minimum requirements for hosting !

http://blog.powerdnn.com/index.php/dotnetnuke-7-the-modern-cms-for-windows-arrives/

What's new in DNN 7?
http://www.arrowtechsolutions.com/whats-new-in-dotnetnuke

 With support for Active Directory and SharePoint Lists, DNN 7.0 can also be seamlessly integrated with popular enterprise applications.

MS SQL Server - Configuring MS SQL Server for Remote Access

This is repost of this:

Configuring MS SQL Server for Remote Access

Extra info from my experience:

1. If you have more then one SQL server instance make sure that they use different ports.
   Leave first one on 1433 and assign your new one 1434.
2. In IP addressess section IPAII make sure to clear TCP Dynamic ports on the bottom.

When trying to connect using SSMS if you had to use different port from 1433 and have some named instance here is naming convention for SQL server address:

vs2008develop,1434\MSSQLSERVERR2

DotNetNuke - Skins - How to reuse parts of page - using custom control inside skin custom control

Inside your Skins package folder you have number of different skins:

root\_default\Skins\NewSkin\HomeSkin.ascx
root\_default\Skins\NewSkin\ProductsSkin.ascx

You want to reuse repeated functionality, no matter static HTML or server side oriented with DNN expressions.

Create blank ASCX and place your func. in it. You don't need .vb or .cs code file.

Key point is that your header should have attributes like this:

<%@ Control Language="vb" AutoEventWireup="true" %>

DotNetNuke Efficion Articles module - Tips & tricks

Efficion Articles modules

• Article list - articles/items are displayed but cannot be selected
• Go to Article details of article that cannot be selected and under section "Detail Type" make sure to choose something different from None like "Text/HTML"

Tips for Articles module :

http://www.efficionconsulting.com/home/all-articles/categoryid/30

This was for old version 3.2.6

ASP.NET Url parts

Just reposting from here:

http://stackoverflow.com/questions/40680/how-do-i-get-the-full-url-of-the-page-i-am-on-in-c-sharp

Request.ApplicationPath :   /virtual_dir
Request.CurrentExecutionFilePath :  /virtual_dir/webapp/page.aspx
Request.FilePath :  /virtual_dir/webapp/page.aspx
Request.Path :  /virtual_dir/webapp/page.aspx
Request.PhysicalApplicationPath :   d:\Inetpub\wwwroot\virtual_dir\
Request.QueryString :   /virtual_dir/webapp/page.aspx?q=qvalue
Request.Url.AbsolutePath :  /virtual_dir/webapp/page.aspx
Request.Url.AbsoluteUri :   http://localhost:2000/virtual_dir/webapp/page.aspx?q=qvalue
Request.Url.Host :  localhost
Request.Url.Authority : localhost:80
Request.Url.LocalPath : /virtual_dir/webapp/page.aspx
Request.Url.PathAndQuery :  /virtual_dir/webapp/page.aspx?q=qvalue
Request.Url.Port :  80
Request.Url.Query : ?q=qvalue
Request.Url.Scheme :    http
Request.Url.Segments :  /
    virtual_dir/
    webapp/
    page.aspx

MS SQL server administration tips

When you backup DB on SQL server A and restore it on SQL server B you may encounter problems.

Here is some tips that have helped me.

User that you have put in your connection string must be:
1. Delete it from Security / Users of your Database
2. If does not exists in SQL Server B Security / Users create it
3. DO NOT MAKE any user mapping of this user in step 2. Just create user
4. Go to Properties of SQL Server B and select Files. Change DB owner to your conn.str. user.

This should work now.

Generally you should have dbo owner & Public rights for your user in user mapping in Security tab of your database.

Step 1 is obligatory ! Proven ...




http://www.mssqltips.com/sqlservertip/2620/steps-to-drop-an-orphan-sql-server-user-when-it-owns-a-schema-or-role/