DNN "How to..."

09

After going through a lot of pain trying to enable the unique email I realized that I had to get rid of the duplicated email address from the past first. Here is what I did to get things done:

Preparation: before getting started I had several widows open:

the Admin "User Account" search window

the Host sql window

the database table window

 

Step 1: Find the duplicated emails and do the soft delete

Open the database table either from the server or using remote connection

There are several tables related to users:

UserProfile
UserRoles
users
aspnet_membership
aspnet_users

Just open one table to work with. I found "aspnet_membership" is the easiest one to work with since it sort the users by email address. Quickly scan the list and you can find the duplicated email addresses easily this way. Once you see a duplicated email, copy  and paste it into the already opened member search window and do a search by email. You will then get a list of users that using the same email account, keep one and delete the rest.

Repeat this process until you find all of them.

 

Step 2:  After the soft delete, you need the hard delete

The above soft delete does not really remove all the users with duplicated email account from the db. You need to do a hard delete. It's almost impossible to manually delete all of them since each single user account lives in multiple tables. There is a script from this site , run this script on your "Host" sql window. Note, each time it only delete 1 record, so you may just repeatedly run this script until you get rid of all of them from all the related tables. It is pretty easy to hit the run button even 100 times.

 

Step3: Enable the unique email

Go to web.config and find "requiresUniqueEmail="false", make the false into "true".

Note: unless it's a brand new site otherwise you need to ensure there is no duplicated email first before changing the web.config file.

[Read the rest of this article...]

06

Google apps email is free, fast and offers a lot of cool features. It also allows more smtp relays. Here are the steps of setting up a google apps email account and using google's smtp server for your dnn site. The standard account is free with up to 50 email accounts.

1. Go to: http://www.google.com/a/cpanel/domain/new

2. Enter your domain and follow the steps

3. Verify your account

4. Under Dashboard page, go to the Email -> Click "Activate email"

5. Change MX records

6. Click "I have completed these steps". You will be redirected to the Dashboard page. You will see "Updating... We are checking MX records for your domain. This may take 48 hours to complete." In fact it often only takes a few minutes.

7. Once the email is active, click the email account you have, under settings, go to "Forwarding and POP/IMAP, by default, pop is enabled, you need to enable "IMAP".

8. To set up the email client, use the following info ( or refer to google's page to use IMAP instead of POP3):

POP3: pop.gmail.com
SMTP: smpt.gmail.com

SMTP PORT: 465
POP3 PORT: 995

Check SSL for both

======================
To configure dotnetnuke smtp server

smtp.gmail.com
SSL enabled

======================


 

[Read the rest of this article...]

Posted in: DNN "How to..."
02
Create a js file "pop-up.js". Place the "pop-up.js" file into the "js" folder you created under the skin folder. Add "< script type="text/java...

[Read the rest of this article...]

Posted in: DNN "How to..."
14
1. For html type of pages, you can set up the 404 redirect from the iis. Just point the "CustomeErrors" page to the file you would like to use. But th...

[Read the rest of this article...]

02
1.  DNN daily cleanning:   Go to host>SQL (run as script) ==================================================== truncate table {databa...

[Read the rest of this article...]

26
16

I found this article to be very useful for people who is building multiple language based portal.

http://declic-video-fx.com/language/en-US/DNN.aspx

[Read the rest of this article...]

05

For any new dotnetnuke installation you have a default dotnetnuke logo look favicon showing on your web page's brower tab. To change it:

1. Create a new icon (any size) you would like to use;

2. Go to http://www.chami.com/html-kit/services/favicon/  and upload your new icon image and your new favicon will be created;

3.  Download the newly created "favicon.ico", save it to your dnn root folder or any other sub folders if you prefer.

4. Open Default.aspx page, add the following line within<head></head>:

<link rel="SHORTCUT ICON" href="/Portals/_default/favicon.ico" />  
(the path is where you saved the icon)

5. Upload the new favicon.ico; upload the updated Default.aspx.

Refresh your page and you should be able to see the change.

[Read the rest of this article...]

Posted in: DNN "How to..."
07

The easiest way to get rid of the sitelog is to turn it of in the Host settings and then run from the Host Menu -> SQL:

(1) truncate table Eventlog
(2) truncate table SiteLog
(3) truncate table ScheduleHistory
(4) truncate table SearchItemWordPosition

[Read the rest of this article...]

23

I have sucessfully used the following script to change the dnn username (by going to host -> SQL):

================================================

update users set username='newusername' where username='oldusername'

update aspnet_Users set username='newusername' ,loweredusername='newusername' where username='oldusername'

================================================

[Read the rest of this article...]

Posted in: DNN "How to..."
18

Since you can not use forms in DotNetNuke, a good way of achieving this is to use iFrame where you can place a html module in.

 

# Solution1:

 

by calabresi from this post.

 

Create a .txt file with the code you get in adsense or Co-op, Im using Co-op and I ask to go results in search results page of my site, so...

 

.TXT file start:

<table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
        <td>
<!-- Google CSE Search Box Begins -->
  <form id="searchbox_003708503336895402913:pcj68nrrmcq" action="
http://www.visflux.dyndns.org/SearchResults/tabid/37/Default.aspx/">
    <input type="hidden" name="cx" value="003708503336895402913:pcj68nrrmcq" />
    <input type="hidden" name="cof" value="FORID:11" />
    <input name="q" type="text" size="30" />
    <input type="submit" name="sa" value="Search" />
  </form>
  <script type="text/javascript" src="
http://www.google.com/coop/cse/brand?form=searchbox_003708503336895402913%3Apcj68nrrmcq"></script>
<!-- Google CSE Search Box Ends -->
</td>
    </tr>
</table>

Then, create your iFrame module and go edit iFrame, the source is file, upload it and set it, adjust width heigth (mine is 240,65), no scroll, no border, and there you go, you can check on my site if you like.

 

#Solution 2:

 

From this post.

 

Use iFrame and put the following code into html module:

<form method="get" action="http://www.google.it/custom" target="google_window">
<table border="0" bgcolor="#ffffff">
<tr><td nowrap="nowrap" valign="top" align="left" height="32">
<a href="http://www.google.com/">
<img src="http://www.google.com/logos/Logo_25wht.gif" border="0" alt="Google" align="middle"></img></a>
<br/>
<input type="hidden" name="domains" value="www.gruppovoloolbia.it"></input>
<input type="text" name="q" size="31" maxlength="255" value=""></input>
<input type="submit" name="sa" value="Cerca"></input>
</td></tr>
<tr>
<td nowrap="nowrap">
<table>
<tr>
<td>
<input type="radio" name="sitesearch" value="" checked="checked"></input>
<font size="-1" color="#000000">Web</font>
</td>
<td>
<input type="radio" name="sitesearch" value="www.gruppovoloolbia.it"></input>
<font size="-1" color="#000000">www.gruppovoloolbia.it</font>
</td>
</tr>
</table>
<input type="hidden" name="client" value="pub-XXXXXXXXXXXXXXXX"></input>
<input type="hidden" name="forid" value="1"></input>
<input type="hidden" name="channel" value="1785095909"></input>
<input type="hidden" name="ie" value="ISO-8859-1"></input>
<input type="hidden" name="oe" value="ISO-8859-1"></input>
<input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#336699;VLC:663399;AH:center;BGC:FFFFFF;LBGC:336699;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:1;"></input>
<input type="hidden" name="hl" value="it"></input>
</td></tr></table>
</form>

 

 

[Read the rest of this article...]

Posted in: DNN "How to..."
15
1) Go to: Host / Languages
2) Click on Language Editor
3) Scroll (all the way) down the page and locate "MESSAGE_PORTAL_PRIVACY.Text" and  "MESSAGE_PORTAL_TERMS.Text".

[Read the rest of this article...]

Posted in: DNN "How to..."
05

1. Admin -> Skins then select "Restore Default Skin"

 

2. If you know your way around SQL you could use the SQL box in the host menu. The skin setting is in the table Tabs, you need to nullify the column SkinSrc for all the pages in the portal you wish to reset.

 

There is an easy way to clear all of these assignments IF you have database access. You can run the following query:-
 
UPDATE dnn_Tabs SET SkinSrc = null (WHERE PortalID = [PortalID)*
 
* Notes
  • Optional clause to be used to only apply on a specific portal.
  • Watch for the objectQualifier, the default is dnn_
The same concept can be applied to contains and the ContainerSrc column of dnn_Tabs.
 
From source1 and source 2

 

 

]

[Read the rest of this article...]

19

Steps I took for upgrading ( using webhost4life):

 

1. Make a back up of db;

2. Make a copy of the entire website folder and upload the upload the DotNetNuke_4.4.1_Upgrade files by doing the followings:

 

   a) Create a new root folder on webhost4life;

   b) Zip the current working web folder (the folder which has the entire dnn installation);

   c) Unzip the zipped folder into the newly created root folder;

   d) Upload the dnn 4.4.1 upgrade files ("DotNetNuke_4.4.1_Upgrade", unzipped) to the server's newly created folder.

3. Point the site directory to the newly created folder.

 

That's it. This way you don't need to change any keys or anything on web.config file. And if there is anything goes wrong, you can change the path to the old folder immediately.

 

Note:

Remove all the unnecessary modules before the process. Make sure module versions would work with the new dnn installation.

 

dnnskin.com

[Read the rest of this article...]

18

Creating a new user which I know the password.

 going into the SQL database into the asp membership table

Finding both rows of data I need. The host entry and the "new user" entry.

Then copy the password and the password salt of the "new user" to the host entry.

 

[Read the rest of this article...]

Posted in: DNN "How to..."
18

Change the users email address to your own email address. Request a password reminder and after that set the email address back to the users email address.

[Read the rest of this article...]

Posted in: DNN "How to..."
12
 

They are coded as buttons:
<asp:button id="cmdLogin" resourcekey="cmdLogin" cssclass="StandardButton" text="Login" runat="server" width="100%" />

BUT you can style them to almost look like text links by setting the StandardButton class in your skin.css file:
.StandardButton {
background: #ffffff none;
border: 0px;
color: black;
text-decoration: underline;
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: normal;
}
Adjust the colors, font, etc. to match your skin.  I wasn't able to set a different style for hover, etc...

[Read the rest of this article...]

08

Q:

Sure there is a LIST data type but how do I customize that list.  If I enter a new list in the LIST tool that does not appear in the available data  types of the USER tool.

 

 

A:

The List data type works with the Host "Lists" module.

 

To use a List, select the List data type, and remember the name you use for the List based property.

Go to the Host Lists page and create a list with the same name you used above.  Then add List Entries to the List in the Host Lists module.  The value will be stored in the database for the profile while the "text" will be used as the text in the drop-down list.

[Read the rest of this article...]

Posted in: DNN "How to..."
23
  • Calendar view is the only view that appears (to best of my knowledge) to allow you to enter new events.  If you want to display events on your site you will need to have at least on event module in calendar view so you can add events.  As I'll describe later, this calendar view of the event module need not be visible to anyone but administrator.
  • List view is a view-only mode for am event module, so you can't add new events directly in this view.  You configure it to reference the calendar (this is the fifth one) and call it something like "Our Family Calendar".  In the Master section of the settings for "Our Family Calendar" check the box to indicate this a Master Event Module.  From the drop down list labeled Add Event Module to Master: select each of the 4 family member calendars and click the Add link.  This will add them as sub-event modules to this master calendar.  You can now see events from all of the four family events calendars on this one "Our Family Calendar".  So it aggregates all of the other calendars into one convenient single view.  As you add to each of the sub-event calendars it will be reflected automatically on the master calendar.

 

  1.  
    1.  

[Read the rest of this article...]

Posted in: DNN "How to..."
19

Try this sample xsl with your feed on your site.  It should work, and you can tweak it to get what you feel you need in terms of appearance and such.

 

 

[Read the rest of this article...]

Posted in: DNN "How to..."
07
07
07

1.  You can just take HTML snapshots using any of a number of programs and services which do that.  Here are a few examples:

 

[Read the rest of this article...]

Posted in: DNN "How to..."
07
07

It could be done by using a simple javascript:

 

[Read the rest of this article...]

Posted in: DNN "How to..."
 
LatestArticles