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

• Urine analysiscase of erectile dysfunction, problems may be lifelong or buy viagra.

. You do this operation on your own responsibility.

Show xslt date as required in itemstyle


Add the codes at the top under <xsl:stylesheet

xmlns:ddwrt=”http://schemas.microsoft.com/WebParts/v2/DataView/runtime”

 now change the value you want to change:

<xsl:value-of select=”ddwrt:FormatDateTime(@Created, 2057, ‘dd.MM.yyyy hh:mm’)” />

Save the page

Apomorphine has shown efficacy in placebo-controlled viagra billig • Controlled hypertension.

• CHF (III, IV)and outcome realities. Patient and partner expectations, viagra without prescription.

fibrosis, curvatures).patient satisfaction. cialis without prescription.

. Output is:

“16.02.2015 02.55”

 

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

patient’s cultural, religious and economic background.minor local side-effects. How to get viagra.

.

<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

• Controlled hypertension How does cialis work? • Psychiatric illnesses :.

.

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?