Thursday, 26 December 2013

SharePoint 2010: Format Form View date using xsl

Microsoft SharePoint Designer 2010:

<xsl:value-of select="ddwrt:FormatDateTime(string($thisNode/@*[name()=current()/@Name]) ,1033 ,'dd-MMM-yyyy ')"/>

Wednesday, 25 December 2013

Tip: Identifying Dropbox client version on Windows 7

Just by hovering with the mouse pointer over the Dropbox system tray icon.

Warning: Issue when using Dropbox on Windows 7 that can waste your file irreversibly

I have used a pdf file for this scenario.
1) Open your pdf from its original location.
2) Move the file to the destination folder on Dropbox by dragging and selecting "Move Here".
3) Ignore this first dialog box.
4) Close the pdf.
5) Repeat Step (2).

6) Select "Move and Replace" from the second dialog.
7) Select Cancel for the first dialog.

--> File disappeared without any trace for its existence!
And not in the Recycle Bin.

It is worth mentioning that I have tried the same procedure using non-Dropbox folder; however, the file was maintained in the destination folder.

Dropbox 2.0.22 (Identifying Dropbox Windows 7 client version)
Microsoft Windows 7 Professional SP1 64-bit

Tuesday, 24 December 2013

Microsoft Access: Error copying data to Sharepoint

Error Reproduction:
1) Open Excel file in Access
2) EXTERNAL DATA --> More --> SharePoint List

Error message:
There was an error copying data to a SharePoint list.Duplicate output destination 'Title'.

In my case that was a column with the title "title", just by removing it from the source Excel sheet, the export completed successfully, and even with the column title in the destination!

Another recommendation I read somewhere was to rename the Excel sheet filename to eliminate any special characters, which wasn't my issue.

Tuesday, 17 December 2013

Microsoft Outlook: Retain read status for message

Many of us consider our official mailboxes as our task lists. Without regard to whether that is a good or bad practice, and for those who adopt this habit; maintaining the messages status as un\read is crucial to identify whether as action has been taken or not.

To overcome the behavior of the messages status change while previewing the list of e-mails without the intention to actually consider this as read, the following option can be uncheck to transfer the responsibility of un\marking your messages statuses.