SharePoint set blank value to date column in SharePoint designer workflow (1/1/1900 to empty/null)

If you have a date list column and using SharePoint designer workflow add empty string or empty datestring, you get a date of 1/1/1900. Sometime you want to add blank value to this value and using SharePoint designer workflow. You have no solution either you add extract querystring or use any other designer action. However, there is one easy solution to use:

  • Start SharePoint designer and go to the workflow – edit workflow.
  • In SharePoint, list settings, change date column to single line of text.
  • Update SharePoint designer and add a string variable.
  • Now add action update list item and choose value as empty string – workflow variables. Suppose your workflow run on item change or manual.
  • Publish your workflow.
  • Change column to date again in list settings.
  • Now you will get empty date when workflow determine.

SharePoint alert you that you will lost data during changing column from date to text field. But that did not happened to me. You do this operation on your own responsibility.

This item cannot be deleted because it is still referenced by other pages

If you are trying to delete any page or masterpage form the masterpage-galleri and getting this error «This item cannot be deleted because it is still referenced by other pages». Here is the fix. Create a new folder in the masterpage library and using SPD or explorer view drag the file over to this folder. Now delete the folder, so this will also delete the page you are trying to delete.

Make sure you don’t have any site using this pagelayouts or masterpage.

 

SharePoint dataview with attachments

Use these codesnipts to show attachments in dataview:

You can place these wherever you want to show the files.

<xsl:element name=”SharePoint:AttachmentsField”>
<xsl:attribute name=”runat”>server</xsl:attribute>
<xsl:attribute name=”FieldName”>Attachments</xsl:attribute>
<xsl:attribute name=”ControlMode”>Display</xsl:attribute>
<xsl:attribute name=”Visible”>true</xsl:attribute>
<xsl:attribute name=”ItemId”>
<xsl:value-of select=”@ID”/>
</xsl:attribute>
</xsl:element>

Error creating a Database Source to SQL in SharePoint Designer 2010

May be you have tried to create a SQL Database Connection in SharePoint Designer 2010 and receive the message:

Server Error:  An error occurred while retrieving the list of databases from (SQL Server): An authentication error occurred. Your logon information may be incorrectly entered, you may not have permission to access this data source, or the requested authentication method may not be supported. Contact the server administrator for more information.

Ok, lets find Administrator. The first thing dropped in my mind is, I am administrator, who i can contact then?

The solution is very easy.

Go to SQL – Right click the SQL-instance – Properties – Security – SQL server and Windows autentication mode – Ok – Right click again SQL instance – Restart – Yes -Yes.

Now lets find the Administrator?