.Net and SharePoint Resources.....

Things to do when a Umbraco site goes live

2011-12-16T12:22:00.001+11:00

1.    Set release mode in visual studio for any projects and then compile and deploy DLLs.
2.    Configure a 404 page. Set the ID of the error page in /config/umbracosettings.cofig file. The following section need to be modified –
<errors>
            
            
            
            <error404>1</error404>
</errors>
3.    Also change the notification section in the /config/umbracosettings.config file. This email address (from address) will be used by Contour as well.
<notifications>
            
            <email>info@barangaroo.com</email>
</notifications>
4.    Add google analytics for the site
5.    Add google mobile tracking for the site. To add the ga.aspx page in the root, the ga.aspx page need to be added to the following line in the web.config file (appSettings section). <add key="umbracoReservedUrls" value="~/config/splashes/booting.aspx,~/install/default.aspx,~/config/splashes/noNodes.aspx,~/ga.aspx" />
6.    Set umbraDebugMode to false in the web.config file (appSettings section)
<add key="umbracoDebugMode" value="true" />
7.    Set customerrors mode="RemoteOnly" in web.config file
8.    Set debug to false in the web.config file
9.    In the system.web/trace section set enabled to false
10.    Modify the connection string in web.config file according to the live server credentials
11.    To reset the ClientDependency cache, delete the ClientDependency folder from App_Data
12.    If there are any form built by Contour package, use the following regex to validate the email.
\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*
13.    Change the admin password to something very strong password.

Compare date in XSLT for Umbraco 4.5

2011-02-18T12:18:00.003+11:00

Simply compare dates in the XSLT (umbraco 4.5).

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp " "> ]>
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxml="urn:schemas-microsoft-com:xslt"
xmlns:umbraco.library="urn:umbraco.library" xmlns:Exslt.ExsltCommon="urn:Exslt.ExsltCommon" xmlns:Exslt.ExsltDatesAndTimes="urn:Exslt.ExsltDatesAndTimes" xmlns:Exslt.ExsltMath="urn:Exslt.ExsltMath" xmlns:Exslt.ExsltRegularExpressions="urn:Exslt.ExsltRegularExpressions" xmlns:Exslt.ExsltStrings="urn:Exslt.ExsltStrings" xmlns:Exslt.ExsltSets="urn:Exslt.ExsltSets" xmlns:CWS.Twitter="urn:CWS.Twitter" xmlns:umbraco.contour="urn:umbraco.contour"
exclude-result-prefixes="msxml umbraco.library Exslt.ExsltCommon Exslt.ExsltDatesAndTimes Exslt.ExsltMath Exslt.ExsltRegularExpressions Exslt.ExsltStrings Exslt.ExsltSets CWS.Twitter umbraco.contour ">

<xsl:output method="xml" omit-xml-declaration="yes" />

<xsl:param name="currentPage"/>



<xsl:variable name="source" select="/macro/source"/>
<xsl:variable name="numberOfItems" select="/macro/numberOfItems"/>
<xsl:variable name="datenow" select="umbraco.library:CurrentDate()" />

<xsl:template match="/">


<ul id="whatsOnButtons">
<xsl:for-each select="umbraco.library:GetXmlNodeById($source)/* [@isDoc][((eventFrom!='') and umbraco.library:DateGreaterThanOrEqual(eventFrom,$datenow))]">


<xsl:sort select="eventFrom" order="descending"/>
<xsl:if test="position() <= $numberOfItems">
<li>
<a href="{umbraco.library:NiceUrl(@id)}"><xsl:value-of select="eventHeading"/></a>
</li>
</xsl:if>
</xsl:for-each>
</ul>

</xsl:template>

</xsl:stylesheet>

Windows command

2011-01-09T11:55:00.001+11:00

Found a great link about commands in windows. Finds the link below -
http://en.kioskea.net/faq/403-command-prompts-for-windows#control-panel

Manual Umbraco installation (step by step)

2010-12-23T10:18:00.003+11:00

Note: I run the following to install Umbraco in IIS6 (Umbraco 4.5.2 for .Net 3.5)

1. Download Umbraco (http://umbraco.org/download). Download the manual installation one.
2. Unblock it by clicking the properties of the zip file and unblock it
3. Copy files from the build folder from the zip file and paste those to the web folder in the IIS
4. Set permission of the folders (Create a batch file with the following script and copy it to the root folder of the site)
(get the below script from the location below - http://our.umbraco.org/wiki/install-and-setup/set-umbraco-folder-permissions-from-command-line )

:: Hope you enjoy this one
:: Sets up the right folder permissions for Umbraco to run
:: Inspired by http://blog.mattbrailsford.com/2010/08/01/adding-a-windows-context-menu-item-to-set-umbraco-folder-permissions/
:: from the boys at Offroadcode.com
ECHO OFF
SET which_user="%computername%\ASPNET"
ECHO ON
cacls "%CD%" /E /G %which_user%:C
cacls "%CD%\app_code" /E /G %which_user%:F
cacls "%CD%\app_browsers" /E /G %which_user%:F
cacls "%CD%\app_data" /E /G "%which_user%:C
cacls "%CD%\bin" /E /G "which_user%:R
cacls "%CD%\config" /E /G "which_user%:C
cacls "%CD%\css" /E /G "%which_user%:C
cacls "%CD%\data" /E /G "%which_user%:C
cacls "%CD%\masterpages" /E /G "%which_user%:C
cacls "%CD%\media" /E /G "%which_user%:C
cacls "%CD%\python" /E /G "%which_user%:C
cacls "%CD%\scripts" /E /G "%which_user%:C
cacls "%CD%\umbraco" /E /G "%which_user%:R
cacls "%CD%\usercontrols" /E /G "%which_user%:R
cacls "%CD%\xslt" /E /G "%which_user%:C
cacls "%CD%\web.config" /E /G "%which_user%:C
::Uncomment below if testing
::PAUSE

5. Run the batch file to set the permission to the folder (For IIS 7 see the section “Setting Permission for AppilcationPoolIdentity” - http://our.umbraco.org/wiki/install-and-setup/set-umbraco-folder-permissions-from-command-line )
6. Create a website in IIS (not virtual directory).
7. Create a separate application pool for Umbraco
8. Click website properties in the IIS and click on the ASP.NET folder and make sure that the ASP.NET version
9. 2.0.50727
10. Create a database in SQL server
11. Set a username and password for the database
12. Run the default.aspx file from the root folder now
13. User the same database name and user credentials that you created in the SQL server
14. Now follow the instruction on screen to complete the installation

Happy Installing :)

Add a identity column in the table in a database

2010-02-14T23:08:00.001+11:00

alter table CustomersTest add ID int identity

CustomerTest is the table name and ID is the column name

Generate random numbers in SQL (any digit number)

2009-11-19T17:38:00.000+11:00

declare @val as bigint

Set @val =(Select ABS(CAST(CAST(NEWID() AS VARBINARY(6)) AS Bigint)))

Select substring(cast(@val as varchar(15)),1,14) as Rand_id

14 – to control the number length

List of development tools for SharePoint Server 2007

2009-08-19T18:24:00.001+10:00

http://www.mossgurus.com/adnan/Lists/Posts/Post.aspx?ID=21

Free traffic builder tools for website

2009-08-18T16:40:00.001+10:00

Follow the link below -

http://www.trafficzap.com/

and

http://www.trafficrank.com/

Improve Web Application Performance

2009-08-18T16:14:00.000+10:00

Follow the link below -
http://dotnetslackers.com/articles/aspnet/ImproveWebApplicationPerformance.aspx

PowerCommands for Visual Studio 2008

2009-07-18T02:02:00.000+10:00

http://code.msdn.microsoft.com/PowerCommands

Sharepoint link

2009-07-05T22:48:00.002+10:00

Seems to me a good SharePoint link but didn't test yet.

http://programmingsharepoint.blogspot.com/2008/02/sharepoint-interview-questions.html

Resources for learning the ADO.NET Entity Framework

2009-06-30T12:38:00.000+10:00

Follow the link below -
http://misfitgeek.com/blog/resources-for-learning-the-ado-net-entity-framework/

MVC Tutorial Links

2009-06-27T03:33:00.001+10:00

http://www.asp.net/learn/mvc/tutorial-33-cs.aspx

http://www.asp.net/learn/mvc/?lang=cs

http://www.asp.net/mvc/learn/

How to auto indenting in visual studio?

2009-01-18T15:38:00.002+11:00

Simply press

Ctrl + K
Ctrl + D

How to test XPath expression in an easy way

2009-01-14T03:38:00.003+11:00

Want to test your XPath expression on the fly. Download the XPath tester from the following link

Download the Tool

Load your XML file into this XPath tester and start writing your XPath expression and to test the expression, click Evaluate in the top.

It's that simple. Enjoy.

WCF: The underlying connection was closed. The connection was closed unexpectedly

2008-12-26T03:50:00.000+11:00

When I was playing with WCF and consuming my first WCF service, I got an error like this "The underlying connection was closed. The connection was closed unexpectedly". The error message is not in very detail and so it is bit hard to guess the actual error in first glance. After doing some research, I have found out that the problem in fact in the serialization. There was a field in the datacontract of being System.Type which you cannot serialize.

Hope this helps.

How to update properties (summary and custom properties) of a word document without using the word API?

2008-12-09T18:30:00.000+11:00

With the help of Dsofile.dll provided by Microsoft, you can easily modify properties of a document when Microsoft Office is not installed in the machine. The link is below -

http://support.microsoft.com/kb/224351

For your convenience, I am putting some code below. I worte the code for a sharepoint project to remove document properties. Hope it helps.

Imports System.IO
Public Class RemoveAllProperty

Private m_oDocument As DSOFile.OleDocumentPropertiesClass

Public Function RemoveProperties(ByVal oStream As Stream) As MemoryStream

‘get the temporay file name along with the path
Dim sFileName As String = Path.GetTempFileName()

Dim oFileStream As System.IO.FileStream
oFileStream = New System.IO.FileStream(sFileName, System.IO.FileMode.Create, FileAccess.ReadWrite)

‘copy the stream
CopyStream(oStream, oFileStream)

oStream.Close()
oFileStream.Close()
oFileStream.Dispose()

Dim oSummProps As DSOFile.SummaryProperties
Dim oCustProp As DSOFile.CustomProperty

Dim sFile As String

sFile = sFileName

m_oDocument = New DSOFile.OleDocumentPropertiesClass
m_oDocument.Open(sFile, False, DSOFile.dsoFileOpenOptions.dsoOptionDefault)
oSummProps = m_oDocument.SummaryProperties

Try
‘remove all the summary properties value
oSummProps.Title = “”
oSummProps.Author = “”
oSummProps.Subject = “”
oSummProps.Manager = “”
oSummProps.Company = “”
oSummProps.Comments = “”
oSummProps.Category = “”
oSummProps.Keywords = “”

Catch ex As Exception
Microsoft.Office.Server.Diagnostics.PortalLog.LogString(”Exception Occurred: {0} || {1}”, ex.Message, ex.StackTrace)
End Try

Dim oRmProp As DSOFile.CustomProperties

oRmProp = m_oDocument.CustomProperties

‘remove all the custom properties value
For Each oCustProp In m_oDocument.CustomProperties
Try
oCustProp.Remove()
Catch ex As Exception
Microsoft.Office.Server.Diagnostics.PortalLog.LogString(”Exception Occurred: {0} || {1}”, ex.Message, ex.StackTrace)
End Try
Next oCustProp

m_oDocument.Save()
m_oDocument.Close()
m_oDocument = Nothing

‘After removing the properties, read the file from the temp directory and read the file into a byte array and return
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(sFile)
‘oFileStream = New System.IO.FileStream(sFileName, System.IO.FileMode.Open)
Try
oFileStream = New System.IO.FileStream(sFileName, System.IO.FileMode.Open, FileAccess.Read, FileShare.Read)
Catch ex As Exception
Microsoft.Office.Server.Diagnostics.PortalLog.LogString(”Exception Occurred: {0} || {1}”, ex.Message, ex.StackTrace)
End Try

Dim oMS As New System.IO.MemoryStream()

‘copy stream to memory stream
CopyStream(oFileStream, oMS)

oFileStream.Close()
oFileStream.Dispose()

‘after the read the temporary file into a byte array, delete the temporary file from temp directory

oFile.Delete()

Return oMS

‘Return oFileStream

End Function

‘copy stream from one stream to another
Private Sub CopyStream(ByVal readStream As Stream, ByVal writeStream As Stream)
Dim Length As Integer = 256
Dim buffer As Byte() = New Byte(Length - 1) {}
Dim bytesRead As Integer = readStream.Read(buffer, 0, Length)
‘ write the required bytes
While bytesRead > 0
writeStream.Write(buffer, 0, bytesRead)
bytesRead = readStream.Read(buffer, 0, Length)
End While
‘readStream.Close()
‘writeStream.Close()
End Sub

End Class

Must Know Visual Studio Shortcuts

2008-12-09T18:29:00.000+11:00

The following links are very useful to learn Visual Studio shortcuts.

http://weblogs.asp.net/stephenwalther/archive/2008/10/21/essential-visual-studio-tips-amp-tricks-that-every-developer-should-know.aspx

and

http://fernandof.wordpress.com/2007/03/16/visual-studio-keyboard-shortcuts-every-developer-should-know/

Learn Design Patterns

2008-12-09T18:28:00.000+11:00

The following links are very useful to understand design patterns

http://www.dofactory.com/Patterns/Patterns.aspx

http://www.designpatternsfor.net/

Useful website for connection string

2008-12-09T18:27:00.000+11:00

The following site is very useful for defining connectionstring

http://www.connectionstrings.com

How to create a business data catalog for sharepoint server 2007

2008-12-09T13:17:00.000+11:00

To create a business data catalog, follow the link below -

http://msdn.microsoft.com/en-us/library/bb410048.aspx

In the article above follow all the stpes described there except the following block -

After uploading the BDC, you can easily modify the permissions.
I am not describing anything about how to upload or how to create BDC as it is described in the above article.

Apart from this, you can also use the tools named “bdcmetaman” to create a BDC application definition file. You can download the tool from the link below -

http://www.lightningtools.com/bdc-meta-man/default.aspx

you can create a BDC application definition file on the fly with this tool :). Also watch the video availble in the link above to know how to use the tool.