DotNetNuke Hosting with ASPHostPortal.com

BLOG about DotNetNuke CMS, latest technology and Special DotNetNuke Hosting Package with ASPHostPortal.com

DotNetNuke Hosting With ASPHostPortal :: How To Setting up the DotNetNuke Blog Module

clock Maart 12, 2015 06:06 by author Mark

This article will walk you through this module and how to successfully configure it on a page within your DNN portal.This article assumes that you have downloaded and installed this version of the module in your website.  This article also discusses creating a blog that is to be used only by the individual configuring the blog, so you will want to login as the blog owner before continuing with this tutorial.  For this example we will be creating a blog for use by the “Admin” of the site.

Creating the Blog!

To get started we will add a new page and call it “Blog”, you complete this step by clicking the   icon in the control panel.  Input the following information for the blog page, or feel free to input your own specific information.
This creates a page that is visible to all users that will contain our blog.  Now, we will want to add an instance of the blog to this newly created page.  Select “Blog” from the list of available modules in the control panel and then select “Add”

Now right away you will notice that the blog module has now added a total of 5 new module displays to your page; most recent blog entries, blog list, new blog, search blog and blog archive.  We will work with each of the controls individually to properly configure the blog for display.

Lets start with the “New Blog” module, this is an administrative module that is used to manage the blogs that are part of the module so we will first want to change the display properties of this module to disable viewing by all users.  Hover over the action menu and select “Settings” to enter the module settings.  In the permissions section, uncheck the “Inherit View Permissions from Page” and ensure that no values are selected, then click “Update”.  The module should now show that it is only available for administrators.

This view control is the one that you will use to create and manage the properties for your blog and sub-blogs.  Once you have the view listed above click on “Create My Blog” to start the configuration of the blog module.  You will be presented with a “Create new Blog” page that will prompt you for various bits of information; each of these will be discussed below.

  • Title – This is the display title for your blog, it is displayed at the top of the entry listing and in the blog directory.  For this example we will call our blog “Test Blog”
  • Description – This is a short description to the purposes of the blog.  This content is displayed on RSS feeds and as general blog information..  For this example we will use the text “Demonstration blog description text”.
  • Blog Options – This section is a collection of checkboxes and looks like this, each setting will be discussed below.
  • Make this blog public – This option is used to make the blog visible to the public
  • Allow users to post comments – This allows registered users to post comments to your blog
  • Approval for user comments required – This option is only enabled for selection if user comments are allowed.  If enabled this option will prevent any comments from displaying publicly until they are approved
  • Allow anonymous users to post comments – this allows anonymous users to post comments to your blog
  • Approval for anonymous comments required – Just like the rule for user comments this adds an approval processes to the anonymous comments.
  • Allow Trackback Comments – This option allows users of other blogs to link back to your blog inputting a comment automatically
  • Approval for trackback comments – Just like the other items this will enable an approval process flow
  • Trackback auto discovery – This is a mode that will allow trackbacks to be discovered automatically
  • Send mail notifications - This option will send an e-mail notification to the blog owner after each blog comment and/or trackback
  • Use CAPTCHA for comments – This option will require the completion of a visual CAPTCHA before a comment can be submitted.

The final option in this section is the “When displaying your identity use” option.  This allows you to use either your username or full name as the identifying name for blog postings.
Typically when configuring modules we would enable comments for registered users without approval and for anonymous users with approval.  These will be the options that are selected for this tutorial.

  • Syndication Options – This collection of settings relates to RSS feeds and if/how they will be created.  Each option will be described below.
  • Syndicate this blog – If this is enabled the content for this blog will be introduced into an RSS feed
  • Syndicate independently – If this is enabled the blog will be syndicated as its own separate RSS feed.  You can use this with child blogs to prevent them from all being listed in 1 feed.
  • Managing Editor - This textbox is where you can put an e-mail address that should be listed as the managing editor for the RSS feed.  This is something that should be populated with a valid e-mail address as it provides a method for feedback and questions from consumers of the RSS feed.
  • Date and Time Options – These options are used to control how the dates and times are displayed in the blog.  This is where you select the time zone for your postings as well as your desired date format.  Below is an example of the default setting for US Central time.

Once you have gone through these settings you can skip past the “Child Blogs” section as this section is outside the scope of this article.  After clicking on “Update” your blog will be created.

Configuring your page layout

Now that we have created a blog it is a bit easier to see what each of these individual modules on our page are used for.  Lets take a bit of time to organize and discuss each of these modules.  The following steps will take you through a process to provide you meaningful information for each control as well as will give you instructions on how to rename the components to be more descriptive.

New_Blog

This control is the first control that we worked with an serves as an administration module, initially used to create the blog and eventually used to modify blog settings and to add new blog entries.  Typically renaming this module to “Administration” is helpful as it makes it easy to remember what its purpose is.  You can click in the module title to use the inline editor to change the name of the module.
It is also very common to move this module to the left pane to condense it’s display.  The module display provides you with three options.

Blog Settings

Clicking on this link will return you to the blog settings page that we used above to create your blog; you can use this to administer the various configuration elements of your blog.

View My Blog

Clicking on this link is the same as clicking your specific blog form the “Blog_List” module; it simply updates the “Most recent blog entries” window to show your blog listing.

Add Blog Entry

This is where you can make a new post to your blog.  You will be presented with an input screen that will provide you with fields for entry date, blog, title, summary, and blog.  Each of these fields are fairly self explanatory you can use these fields to control the CONTENT of your blog post.  You additionally have an “Entry Options” section where you can set options for your blog.  These items exist to allow you to “publish” a blog, to allow comments, and/or to display a copyright notice at the bottom of your blog posting.  Below is an example of these settings under their defaults
After you populate all values for the fields you may press “update” to actually make your new blog post!  It is that easy!

Blog_Archive

This module is a simple calendar that shows days that have blog posts and allow users to navigate the blog based on a date range.  Typically this module is renamed to “Archive” or something of that nature.  This is another control that for both space and usability is typically moved to the “RightPane” to allow it to display alongside the blog postings.  An example of the interface after modifying this control and the previous control is below.
As you can see we are starting to create something that looks more like a blog that you might expect to see.

Blog_List

This module is a control that allows users to select the various views from your blog.  They are presented options for “View All Recent Entries” which will display recent entries from any and all blogs and child blogs.  They are also given the ability to click on each individual blog and they will be displayed that information.  This is another control that condenses display very nicely and is deserving of a new name and location.  Typically this is found on the “LeftPane” of a site and is called “Navigation” or “Blogs” something a bit more descriptive to your users.
The action menu for this module provides you access to the “Blog Settings” page and “Add New Blog” pages.  This makes the “Administration” module unneeded for administration purposes now that you have created your blog.  Some individuals remove the module entirely but most just leave it for administration display.

Search Blog

This module is the search feature for the blog module itself allowing users to search for desired content, again this is a module that can condense to display in smaller areas and is typically located near the “Archive “ control as they are similar in function.  For this example we will rename it to “Search” and place it directly below the “Archive” module.
This module has no configuration options and provides users basic searching of blog content.

Most Recent Blog Entries

This module is the actual display control for the module that will show your blog posts to your users and allow them to view/leave comments.  The view of this specific module changes depending on how the other modules are configured.  You can view summary information for you blog postings and then drill down into the full detail display.
This module does have a configuration element that is accessible via the action menu by selecting “Module Options”.  These options apply to the blog module as a whole and will be discussed in two separate sections.

Basic Settings

These settings are basic settings that control the display of the blog and the input of content for the module.  Below are the default settings for this module.  They are all fairly self explanatory and are used to mostly limit the content to ensure that you have a proper display on your site for content length, search results length, and RSS feed length.

Advanced Settings

These settings are more advanced topics and relate to integration and other elements of the blog module.  Each of these values will be discussed below.

  • Allow Upload Options – Can blog posters upload items to their posting?
  • Show Blog Summary – Is the summary displayed when viewing the single blog detail?  Typically this is disabled as your summary is the first portion of your full blog post and it wouldn’t make sense to display it before the blog content.
  • Show unique title – If enabled this module will use a blog specific title to describe the content of the page.  For SEO this is a very good practice!
  • Personal Blog Page – If you want to display 1 and ONLY 1 blog on the page you can select the blog that is associated with the module here.  This essentially disables the function of the “Navigation”/”Blog_List” module discussed earlier and selects the given blog directly.
  • Enable DNN Search – This option is disabled by default.  If selected the module will use the ISearchable interface to provide the core DNN search engine with information about your blog postings.

Summary

After walking through this example you should now have a blog page that looks something like the following.

Best DotNetNuke 7.4 Hosting Recommendation

ASPHostPortal.com

ASPHostPortal.com is the leading provider of Windows hosting and affordable DotNetNuke Hosting. DotNetNuke Hosting from ASPHostPortal.com provides a safe, reliable and performance-driven foundation for your DotNetNuke website. DotNetNuke is the perfect Content Management System for managing and developing your website with one of ASPHostPortal’s Hosting plans. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability



DotNetNuke Hosting With ASPHostPortal :: Step by Step Process to Install The DotNetNuke (DNN)

clock Januarie 26, 2015 06:05 by author Mark

DNN Installation Process

  • Unzip the DNN file.
  • Rename
  • Make Two Folders in side UnZip folder
    • SQLExpress_DBFile
    • Website
  • Move all files inside the Website Folder except SqlExpressFolder.
    • Modify WebConfig.
  • Host it to IIS
    • Open IIS
    • Add new website (exp: DNNDEV.ME)
      • Site name :DNNDEV.ME
      • Provide physical path of dnn(Mark it to website folder under dnn folder)
      • Host name:DNNDEV.ME(same as site name)
  • After adding site you have to provide it permission:
    • Right click website folder > Edit permission > Security
    • Under Security click Edit > ADD > iis apppool\DC700X_DEV5 (your site name)
    • Allow it to All permission
  • Now add it to Host sites
    • Open notepad as Administration > File > Open > Brows (C > Windows32 > Systems > Drivers > host(Select all files) remove Read only permission
    • Now open Host and add 127.0.0.1 DNNDEV.ME (as per your ip and site name)
    • Now save and give it Read only Permission.

Make Data Base for dnn

  • Open SqlServer > Database(right click) >Add new DB > Paste here DNNDEV.ME(original site or host name as in IIS)
  • Open Database > Security > Logins (Create new user)
    • Login Name :DNNDEV.ME
    • Check Sql Server Authentication (nt Windows Auth)
    • Pas :Database,Confirm pass:Database
    • Make Enforce Password Policy Uncheck Then cilck > OK
  • Open DNNDEV.ME > Security > USers (right click) > New USer
    • User Name :DNNDEV.ME
    • Default Scheme : dbo
    • Select both chk to db_owner then click ok

Run DNN from IIS

  • Fill all field as per your back entrys.
  • Change Custom.

Now its running
Template Modify Process

Best Recommended DotNetNuke Hosting

ASPHostPortal.com

ASPHostPortal.com is the leading provider of Windows hosting and affordable DotNetNuke Hosting. DotNetNuke Hosting from ASPHostPortal.com provides a safe, reliable and performance-driven foundation for your DotNetNuke website. DotNetNuke is the perfect Content Management System for managing and developing your website with one of ASPHostPortal’s Hosting plans. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability.



DotNetNuke Hosting with ASPHostPortal :: How to Add jQuery To Your DNN Skin

clock Januarie 19, 2015 05:39 by author Mark

This Article will explains How to Add jQuery to your DNN Skin. At this point you’ll be hard pressed to find a site that does not use jQuery. It has become a requirement for many to bring flash like experience in the form of photo sliders or fast responding ajax applications.
Over that time adding jQuery to DotNetNuke (DNN) has not always been straight forward. DNN ships jQuery as part of the core framework and you might assume that it’s always available. But one of the most widely unknown issues is that it must be requested on every page in order for it to be available.

Common Symptoms:

  • Main menu does not show sub items.
  • Homepage slider does not rotate.
  • Layout is malformed.
  • Works fine when logged in but not when logged out.

"When you login as an administrator jQuery will always be available since the control panel bar request it. However if you logout on that same page it might not have been requested by any module or skin object on that page".

Not Recommended Ways To Add jQuery

Do Not: Add script tag into page settings or in your skin file.
Why? This will potentially add multiple jQuery reference to your page. The real issue is if any plugins are registered between the first reference and the second reference they won’t be available after the second reference is instantiated.

<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

Recommended Way To Add jQuery

In your skin file you you can reference and add the control for jQuery. This will ensure that jQuery is available on every single page and that it will only be referenced one time. You also get the benefit of the Client Dependency Framework (CDF).

<%@ Register TagPrefix="dnn" TagName="jQuery" src="~/Admin/Skins/jQuery.ascx" %>
<dnn:jQuery runat="server"></dnn:jQuery>

You can optionally add public properties to register jQuery UI, DNN jQuery Plugins and Hover Intent.

<dnn:jQuery runat="server" jQueryUI="true" DnnjQueryPlugins="true" jQueryHoverIntent="true"></dnn:jQuery>

TOP Recommended DotNetNuke 7.3.4 Hosting

ASPHostPortal.com is a windows-based hosting service provider. ASPHostPortal.com offers the most reliable and stable DotNetNuke 7.3.4 web hosting infrastructure on the net with great features, fast and secure servers. DotNetNuke 7.3.4 Hosting from ASPHostPortal.com provides a safe, reliable and performance-driven foundation for your  website. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability. 



DotNetNuke Hosting with ASPHostPortal :: Step by Step Perform a Global Find / Replace on the Text / HTML Module in DotNetNuke

clock Januarie 14, 2015 07:49 by author Mark

How to Perform a Global Find/Replace on the Text/HTML Module in DotNetNuke

Today I will explains how to perform a global find/replace on the text/html module in DNN. If you need to replace content that is stored in the Text/HTML module in your DotNetNuke installation you could manually edit every text/html module, but you can also perform a global find/replace on all the content stored in that module through your database using the script below.

Before starting this process, you should make a complete backup of your website and database.
These steps require you to have Microsoft SQL Server Management Studio installed on your computer. 

declare @FIND as nvarchar(MAX)
declare @REPLACE as nvarchar(MAX)
set @FIND = 'ORIGINAL'
set @REPLACE = 'NEW'
update HtmlText set Content = cast(replace(cast(Content as nvarchar(max)),@FIND, @REPLACE) as ntext)

  • Open Microsoft SQL Server Management Studio and connect to your database.
  • Click on the New Query button.
  • Copy and paste the following script into the New Query window replacing ORIGINAL with your original value and NEW with the new value, please see the note below for information on these values.
  • Click Execute.

Notes
When you are deciding what you want to find and replace, it is best to always be as exact as possible in order to avoid making unintended replacements.  For example, let's say that you recently moved a DotNetNuke website from a virtual directory named /DotNetNuke into the root.    
                                                                                     

You want to update all links so that they remove DotNetNuke.There are a couple different ways that you may be tempted to do this:

Bad
@Find = 'DotNetNuke'
@Replace = ''

The problem with this is that it will find all copies of the word 'DotNetNuke' and replace it with nothing.  With this script, it will replace all instances of 'DotNetNuke', not just ones that are in URLs, so if you have content on your page about DotNetNuke, you'll lose this content.

Acceptable
@Find = '/DotNetNuke/'
@Replace = '/'

This script is better, however, it is not perfect.  Most likely, anywhere that /DotNetNuke/ is listed, it will be part of a URL, however, it won't necessarily be completely accurate.  For example, let's say that you have a URL such as /DotNetNuke/AreasOfExpertise/DotNetNuke/DotNetNukeProjects.aspx when the script above is run, the URL will be shortened to /AreasOfExperties/DotNetNukeProjects.aspx which is most likely not what you would have wanted.

Best
@Find = '&quot;/DotNetNuke/'
@Replace = '&quot;/'

This script is much better because it has the &quot; at the beginning. (This is the encoded version of the double-quote charater).  This is the best is because all URL references are going to follow a pattern similar <a href="/DotNetNuke/Page.aspx">Link</a> or <img src="/DotNetNuke/images/MyImage.gif" /> so we can safely assume that all URLs start with a quote followed by /DotNetNuke/.

TOP Recommended DotNetNuke 7.3.4 Hosting

ASPHostPortal.com is a windows-based hosting service provider. ASPHostPortal.com offers the most reliable and stable DotNetNuke 7.3.4 web hosting infrastructure on the net with great features, fast and secure servers. DotNetNuke 7.3.4 Hosting from ASPHostPortal.com provides a safe, reliable and performance-driven foundation for your  website. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability. 



DotNetNuke 7.3 Hosting - ASPHostPortal.com :: How To Fixing PortalSettings issue on multilingual Websites in DNN 7.3.2

clock Desember 5, 2014 08:33 by author Ben

How To Fixing PortalSettings issue on multilingual Websites in DNN 7.3.2

Today I will share about How to fixing issue on multilingual website in DNN 7.3.2.
DNN 7.3.2 enhanced the stored procedure for saving Site Settings to add multilanguage support, unfortunately it missed to include proper handling of language specific settings within the business layer and some other aspects. As effect, DNN 7.3.2 fails to load site settings for multilingual sites and renders an error message.
I created a full solution to add localization support for website settings, which is scheduled to be included with DNN 7.4.0, meanwhile you may run the script below from Host > SQL, in order to fix this issue.

"NOTE: DO NOT APPLY TO DNN 7.4.0 OR LATER"

This fix is also included in TurboDNN 0.9.3 ff. - the solution to improve database performance of DNN, which might be downloaded for free from here. (Please take the time to read instructions enclosed.)

-- ensure, last modified is not Null (should not exist)
UPDATE {databaseOwner}[{objectQualifier}PortalSettings]
 SET   LastModifiedOnDate = '2000-01-01'
 WHERE LastModifiedOnDate is Null
GO
IF OBJECT_ID(N'{databaseOwner}[{objectQualifier}GetPortalSetting]', N'P') IS NOT NULL
    DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSetting]
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSetting]
    @PortalID    Int,     -- Not Null
    @SettingName nVarChar(50), -- Not Null
    @CultureCode nVarChar(50) -- not Null
AS
BEGIN
 SELECT TOP (1)
 SettingName,
 CASE WHEN Lower(SettingValue) Like 'fileid=%'
 THEN {databaseOwner}[{objectQualifier}FilePath](SettingValue)
 ELSE SettingValue
 END   AS SettingValue,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate,
 CultureCode
 FROM  {databaseOwner}[{objectQualifier}PortalSettings]
 WHERE PortalID    = @PortalID
   AND SettingName = @SettingName
 ORDER BY LastModifiedOnDate DESC
END
GO
IF OBJECT_ID(N'{databaseOwner}[{objectQualifier}GetPortalSettings]', N'P') IS NOT NULL
    DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSettings]
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSettings]
    @PortalId    Int,            -- not Null!
    @CultureCode nVarChar(20)    -- not Null!
AS
BEGIN
 SELECT
 SettingName,
 CASE WHEN Lower(SettingValue) Like 'fileid=%'
 THEN {databaseOwner}[{objectQualifier}FilePath](SettingValue)
 ELSE SettingValue
 END   AS SettingValue,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate,
 CultureCode
 FROM  {databaseOwner}[{objectQualifier}PortalSettings] P
 JOIN  (SELECT PortalID, SettingName SN, Max(LastModifiedOnDate) MD
        FROM {databaseOwner}[{objectQualifier}PortalSettings]
 WHERE PortalID = @PortalId
 GROUP BY PortalID, SettingName) S
   ON P.PortalID = S.PortalID AND P.SettingName = S.SN AND P.LastModifiedOnDate = S.MD;
END
GO

UPDATE: this fix has been included with DNN 7.3.4, you shouldn't need it, if you upgraded to 7.3.4 and don't apply it to DNN 7.4.0 or later.



DotNetNuke Hosting with ASPHostPortal.com :: GetTab Method without DNN Context

clock November 30, 2014 20:22 by author Mark

GetTab Method without DNN Context

As you know, the simple method GetTab(int tabid) was obsolete and has been replaced by GetTab (ByVal TabId As Integer, ByVal PortalId As Integer, ByVal ignoreCache As Boolean). If you want to call the new method, we have to pass the additional parameter “PortalId”.
In common,  the object PortalSettings can be easy to get with DNN context, such as special dnn module & page; however, it may be inaccessible in some sceneries, such as separate aspx page or handler. Then is there any way to get the correct tab info with this new method? Now there is a simple trick to do it with passing into Null.NullInteger as the parameter PortalId. So the coding looks like that:

var tabController = new TabController();
var blogPage = tabController.GetTab(tabID, Null.NullInteger, false);

Deeping into the source code, you will find out that it always tries to get the correct PortalId for this tab/page object:

//if we do not know the PortalId then try to find it in the Portals Dictionary using the TabId
portalId = GetPortalId(tabId, portalId);
//if we have the PortalId then try to get the TabInfo object
tab = GetTabsByPortal(portalId).WithTabId(tabId) ??
        GetTabsByPortal(GetPortalId(tabId, Null.NullInteger)).WithTabId(tabId);

Hope this trick & tip helps if someone has the same issue.

 



DotNetNUke 7.3 Hosting with ASPHostPortal.com :: TIPS Getting rid of spam users

clock November 18, 2014 06:14 by author Mark

Quick tips : Getting rid of spam users

After getting a couple of questions, I'd like to provide options for getting rid of spam users, which is cumbersome via UI, if thousands of registration have been added by a bot.
Unfortunately, it is not as easy as just deleting items from a single table, as user Information is distributed in multiple tables inside the database, therefore we need.
You are in a comfortable situation, if your site is using verified or private registration - in this case all spam users are unauthorized and you simply need to hit "delete unauthorized users" in Admin > User Accounts.
In all other cases, you will need to identify the users to delete from the database and mark as "deleted", in order to use "remove deleted users" (hard-delete) those users from all tables.

ALWAYS START WITH A DATABASE BACKUP!!

If your site only has a host and admin user you would run the following statement inside Host > SQL (check "run as script" in all DNN versions prior to 7.3):
UPDATE {databaseOwner}[{objectQualifier}UserPortals]
 SET   isDeleted = 1
 WHERE UserID NOT IN (SELECT UserID FROM  {databaseOwner}[{objectQualifier}Users
                                    WHERE isSuperuser = 1 OR UserName Like 'Admin')
If you may identify all users by registration date, e.g. since first of November, you would run
UPDATE {databaseOwner}[{objectQualifier}UserPortals]
 SET   isDeleted = 1
 WHERE UserID NOT IN (SELECT UserID FROM  {databaseOwner}[{objectQualifier}Users]
                                    WHERE isSuperuser = 1 OR UserName Like 'Admin' or CreatedOnDate < 2014-18-11)

Of course, this will become more difficult, if regular users registered the same time. You may consider creating a role "verifiedUsers" and move all regular users manually into this group. Now the command would look like


UPDATE {databaseOwner}[{objectQualifier}UserPortals]
 SET   isDeleted = 1
 WHERE UserID NOT IN (SELECT UserID FROM  {databaseOwner}[{objectQualifier}Users]
                                    WHERE isSuperuser = 1 OR UserName Like 'Admin' or CreatedOnDate < 2014-18-11)
   AND UserID NOT IN (SELECT UserID FROM {databaseOwner}[{objectQualifier}vw_UserRoles]
                                    WHERE RoleName Like 'verifiedUsers')


Afterwards you may use "Remove Deleted Users" link in Admin > User Management, to delete all rows.
For DNN Versions prior to DNN 7.3.1, you need to delete user folders manually, which reside nested inside users subfolder of the portal folder. Unfortunately, it is difficult to identify all folders from deleted users, but you may delete all empty folders without subfolder and files inside, as the folder for a still existing user will be re-created, once the user logs in again for the first time. You may use the following command (sing a command line on the server, while being inside the users folder)
for /f "delims=" %i in ('dir /ad /s /b') do @rd "%i"
Finally, you should enter file manager in DNN Admin menu and perform a recursive sync to get rid of all folder entries and folder permissions in the database



DotNetNuke 7.3 Hosting with ASPHostPortal.com :: Skinning Responsively The DDR Menu with Bootstrap for DotNetNuke

clock Oktober 7, 2014 06:01 by author Ben

With all the introduction of the DDRMenu to DotNetNuke, we've experienced much more manage above what is rendered from the menu. This has authorized for a a lot more semantic menu and custom made styling for easy menus to mega menus. There are numerous methods to create the template that the DDR makes use of but we'll be using the token primarily based templating because it is quite easy.


Menu Template (Bootstrap Nav)

I copied the easy folder from your Gravity pores and skin that will come with DNN 7, which incorporates a manifest file “menudef.xml” and the “SimpleToken.txt” file. I updated the SimpleToken.txt file as follows:
Notice: this isn’t a tutorial on DDRMenu, just how to apply Bootstrap.

<ul class="nav nav-pills">
    [*>NODE]
    </ul>
    [>NODE]
        <li class="[?NODE]dropdown [/?][?SELECTED]active[/?]">
        [?ENABLED]
            <a href="[=URL]">[=TEXT] [?NODE]<b class="caret"></b>[/?]</a>
        [?ELSE]
            <a href="#">[=TEXT] [?NODE]<b class="caret"></b>[/?]</a>
        [/?]
        [?NODE]
            <ul class="dropdown-menu">
            [*>NODE]
            </ul>
        [/?]
        </li>
    [/>]

  1. Add the classes nav and nav-pills to the outer ul. Individually, I favor the simplicity in the Simple tablets nav that bootstrap gives. This appears to be the easiest to override with my own custom design and style as I have a tendency to use more flat UI’s in my style.
  2. Include the category “dropdown” for the list merchandise if it's youngsters using the [?NODE] examination.
  3. Add the category “active” for the listing product whether it is selected utilizing the [?SELECTED] examination.
  4. Add a caret to the merchandise if it's a baby item.

Up coming, we are able to include the HTML and pores and skin object within the pores and skin as follows:


Logo and Menu pores and skin objects (Bootstrap Navbar)

<div class="navbar">
        <div class="navbar-inner">
            <span class="brand">
                <dnn:LOGO runat="server" id="dnnLOGO" />
            </span><!--/Logo-->
            <dnn:MENU MenuStyle="Simple" runat="server"></dnn:MENU>
        </div><!-- END navbar-inner -->
    </div><!-- END navbar -->


  1. add link with class “btn” and btn-navbar”. Also, requires markup for collapse. You are able to use either JavaScript or information attributes.
  2. Wrap dnn:MENU pores and skin item using a div using the adhering to class
    “nav-collapse” and “collapse” - this permits the menu to break down at smaller display screen sizes
    “pull-right” to drift the menu to the correct side, if you so desire.

 

Note: making use of this process will disable a menu merchandise which has children. In order that this is a click to open up motion. This can be to make things function much better for contact units.



DotNetNuke 7.3 Hosting with ASPHostPortal.com :: The Simple Way to Install DotNetNuke

clock September 17, 2014 09:18 by author Kenny

The Simple Way to Install DotNetNuke

DotNetNuke is a Web-content management platform for those who use the Microsoft ASP.NET framework. Based on your company needs, whatever version of DNN you choose, it will be a significant cost saving venture over other options. Installing DotNetNuke is not a task well-suited for beginners to this sort of website framework. If you are familiar with websites, databases, and ASP.NET, you can use these instructions to learn how to install DotNetNuke.

Check the DotNetNuke installation requirements before getting started. To install DotNetNuke, you need a database with either Microsoft SQL Server 2005/2008 or SQL Express. If you have an older version of DotNetNuke 5.2 or earlier, you can use SQL Server 2000. You should also have a Microsoft IIS (Internet Information Services) with version 5 or higher, and the Microsoft .NET 3.5 SP1 framework. This service pack is available through the Windows Update feature.

Download the latest version of DotNetNuke to your computer, and unzip the file.

Use the FTP software of your choice to connect to your website, and upload the installation files into the directory of your choice. If necessary, create the directory where you want to install DotNetNuke on your server.

Select the folder where DotNetNuke is located. Click "Properties," choose the "Security" tab, and add the necessary user permissions. Use either the local ASP.NET service (for Windows 2000 and XP) or the local Network Service account (for Windows 2003, Vista, 2008, or 7). You should have permission to modify the folder.

  • Open the IIS server console. Go to "Start" > "Run" > INETMGR. Click on the "websites" node, and select the "Default website" node.
  • Right click on the DotNetNuke folder. Click "Convert to Application." If this option is not available, select "Properties" and add the application.

Install DotNetNuke with SQL Express.

  • Open your web browser, and go to: http://yoursite.com/dotnetnuke.
  • Walk through the installation wizard as presented on the screen. The database information should already be configured, and you should not need to change it.
  • Look for the default login information for the "host" and "admin" users, which is shown when installation is complete.
  • Log in immediately, and change the passwords to protect against hacking.

Install DotNetNuke with SQL Server 2005/2008 for your database server.

  • Open SQL Management Studio, and connect to your database server.
  • Walk through the installation wizard as presented on the screen.
  • Create a new database by expanding the server node, then the databases node, and filling in necessary values for all the database properties.
  • Set up the SQL user and security account, and choose the appropriate integrated-security or user-security setting under the "server/security" node.
  • Open your web browser, and go to: http://yoursite.com/dotnetnuke.
  • Walk through the installation wizard as presented on the screen. Choose SQL 2000/2005/2008, and follow the security steps according to the option chosen in the previous steps. Test the database connection.
  • Finish the installation wizard, and look for the default login information for the "host" and "admin" users.
  • Log in, and immediately change the passwords for those accounts to protect against a hack.

Best and Cheap DotNetNuke Hosting Provider

Are you looking for best and cheap DotNetNuke Hosting Provider? ASPHostPortal is the answer. ASPHostPortal.com is a windows-based hosting service provider. ASPHostPortal.com offers the most reliable and stable DotNetNuke 7.3 web hosting infrastructure on the net with great features, fast and secure servers. Our hosting can be done via USA, Amsterdams or Singapore based server. Depending on your requirements, we can scale so we can deliver the right service for the right price. All of our windows hosting plan supports DotNetNuke 7.3 and you can install DotNetNuke 7.3 with just one click.



DotNetNuke Hosting with ASPHostPortal.com :: Cart Viper is The Best DotNetNuke eCommerce Solution

clock September 5, 2014 08:09 by author Kenny

Cart Viper is The Best DotNetNuke eCommerce Solution

If you read this article, of course you interest with ecommerce. In this article, we will tell you that you now you will develop your online store easily with DotNetNuke platform. If you are already using DotNetNuke then you will know what a great platform it is to build rich and engaging websites but what if you could use the same platform to run an online DNN shop?

Why you should using Cart Viper?

Cart Viper is an ecommerce solution built for DNN providing a PCI compliant online store for your business. You will start to sell online today using the simple to use ecommerce store easily. From now you will sell anything; physical products, digital downloads and events. Using Cart Viper you can create a fully functioning online shop within 30 minutes.

Is Cart Viper The Best DotNetNuke Store?

The answer absolutely is YES. In their official website, they said that, “Since starting Cart Viper we've added hundreds of new features and improvements all with the aim of making the best dotnetnuke store available on the market. A great product is no good without great support so we are dedicated to providing help and support so that you can get the best out of our product. Take a look at the feedback we have received from our satisfied customers.”

Features of Cart Viper

There are some features of Cart Viper:

  • Categories and Sub-Categories – You can create and manage an unlimited number of product categories. In here you also can find SEO optimized product categories page - define the category URL, META description and title tags.
  • Products – You can create an unlimited number of products. Automatic re-sizing of product images (small, medium, large) based on your predefined image size.
  • Product Variants - Choose the variant option display e.g. dropdown list, checkbox, radio button, textbox, multi-line textbox or image uploader. Track stock quantities for each product variant, so you know exactly how many of each product variation you have in stock.
  • Catalog Localization - Ability to enter categories and products in multiple languages. Categories and products will fully localize to the current language that is being viewed by the user.
  • Product Offers - Create and manage product offers. Define start, end date and offer price. Offer is applied and removed from a product without any user interaction.
  • Coupons - Define rules for each coupon. e.g. minimum subtotal, can be used multiple times, start date, end date, customer email address, etc. Offer a monetary or percentage discount.
  • Promotions - Create store wide promotions, so every product has a specific discount during the given period. Create category wide promotions, so every product in the category has the specific discount during the given period.
  • Product Discount Bundles - Create product discount bundles where a user receives a discount if they purchase 2 or more items at the same time. Promote up-selling and maximise each sale via product discount bundles.
  • User Specific Pricing - Define a product price for a specific user of your DNN site. Define a product price for a specific role of your DNN site. When browsing the store the individual user price is displayed to that user.
  • Digital Downloads - Define which products have a digital download. Digital downloads now support PDFs as a valid file type. Allow admin to define how long / how many times a user can download a digital download after they have purchased it.
  • Product Comparison - Allow users to select up to 4 products then compare them side by side! Store admin defines the product details they can compare e.g. weight, size, model number etc. Allow the user to quickly and easily see the advantage of 1 product over another.
  • Wishlists - Wish list automatically updated if admin deletes / edit a product in a user’s wish list. Anonymous users can create wish lists, and then they will automatically be transferred into their user account if they then sign in to your store. Customers can make their wish list public and send friends a link to view the wish list.
  • Product Visualizer - Allow a user to see a mockup of what their product will look like once they have made their specific choices. e.g. select text or upload an image.
  • Product Reviews & Ratings - Enable / disable product reviews. Product average rating calculated from customer reviews. Product reviews approved by admin before appearing on site.
  • Shipping - Enable / disable shipping to be calculated on an order. Support an unlimited number of shipping providers so customer can select when they checkout e.g. FedEx, UPS, default, etc
  • Tax & VAT - Based on stores location and the users billing address Cart Viper automatically works out if you need to charge VAT or tax. Define VAT rates for: Zero rated product,Reduced rate products & Standard rate products. Assign each product to a VAT rate.
  • Payment Methods - Let customer pick between online or offline payment methods at the point of checkout. Real time credit card payments (Mastercard, VISA, Solo, Switch, Amex and Discover). Accept offline payment methods (cash on delivery, cheque, purchase orders, etc) with or without Real time payment method as well.
  • Payment Gateways - Optional ability to apply a percentage or fixed amount surcharge to an order placed with Paypal Standard. Recurring billing support when using Authorize.net payment gateway, manage subscriptions directly from Cart Viper, recieve notifications when card declined.
  • Cart & Checkout - Advanced jQuery add / edit / delete items shopping cart functions. Separate mini-cart control that can be added to any content pane. User friendly wizard style checkout screen.
  • Store Administration - Quick Install for Creating a New Store. Simple intuitive administration UI. Optionally assign DotNetNuke roles to admin tasks as product management, order management etc. Product moderator feature - create a new setting that allows the a DNN role to be entered users with this role can add products however they need to be moderated before appearing in the store front.
  • Catalog Workflow and Version History - Define if that all changes to the store catalog requires moderation. Ability to accept / decline changes, with email notifications.
  • QuickBooks Integration - Automatically transfer orders from Cart Viper into QuickBooks.
  • Order PDF - Store admin or customer can download a PDF receipt of any order that has been placed. Admin can define an image along with header and footer text to brand the PDF as per your needs.
  • Sales Reporting - Cart Viper automatically calculates your sales data for the current day and at a glance allows you to see how that compares to yesterday and the average of the last 30 days. View sales data by product or category for specific date you enter. Export sales data to .XLS format.
  • My Account Module - Separate my account module included. Edit their account profile settings - billing / shipping address etc. Users can view / search through their order history.
  • Product News Letter - Separate product newsletter module, allow users to sign up to your store product newsletter. Product newsletter automatically sent with no human interaction.
  • Product Widget Module - Separate product widget module that can be used to display products anywhere on your DNN portal. Select products to display in product widget module by: random, top sellers, by category, individual selection, products currently on special offer and newly added.
  • RSS 2.0 Feeds - Optionally expose RSS 2.0 feeds based on the product data in your store. 3 different RSS 2.0 feeds: top selling products, newly added products and featured products.
  • HTML Email Templates - All emails that the store sends are HTML based so you can customize then to suit your needs. Fully HTML enabled so you can brand the emails as per your needs using CSS and images.
  • Define the Store Currency - The following currencies are supported by Cart Viper: United States Dollar (USD) , Great British Pound (GBP), Euro (EUR), Australian dollars (AUD), Canadian dollars (CAD), Mexican peso (MXN) Swiss francs (CHF), Singapore dollar (SGD), Thailand Baht (THB), New Zealand Dollar (NZD), Phillipine Peso (PHP), Czech Koruna (CZK) and Mexican Peso (MXN).
  • Donations - Optionally allow customers to place donations. Define predetermined amounts with the customer able to select or enter their own donation amount. Allow the customer to enter a name associated with the donation.
  • Multi-language Support - They currently have the resource files translated into English, French, German, Spanish and Dutch. However Cart Viper can be translated into any language you require!
  • Multiple Portals Supported - Cart Viper can be installed on multiple parent and child portals. Each portal would need to have its own license.
  • Advanced Templating - Razor Template Support. Responsive store template, create a great store experience for desktop, tablet and mobile users. Data and presentation kept separate allowing you to create your own templates without any programming knowledge.
  • Google Analytic eCommerce & Event Tracking - Full eCommerce & event tracking support integration into Google analytics. Track 25 different events inside your store. Provides detailed statistical analysis how customers are users your store. Quickly and easily find customer trend and shopping habits!
  • DotNetNuke Versions Supported - Cart Viper requires version 5.x, 6.x, or 7.x of DotNetNuke. Works in both Full Trust and Medium Trust environments.

Best and Cheap DotNetNuke Hosting for Your DotNetNuke Site

ASPHostPortal.com is the best and cheap windows-based hosting service provider. ASPHostPortal.com offers the most reliable and stable DotNetNuke 7.3 web hosting infrastructure on the net with great features, fast and secure servers. Our hosting can be done via USA, Amsterdams or Singapore based server. Depending your requirements, we can scale so we can deliver the right service for the right price. All of ourwindows hosting plan supports DotNetNuke 7.3 and you can install DotNetNuke 7.3 with just one click.



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions

Author Link


 photo ahp banner aspnet-01_zps87l92lcl.png

Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Tag cloud

Sign in