Showing posts with label document library. Show all posts
Showing posts with label document library. Show all posts

Tuesday, March 9, 2010

Rounding up minutes to nearest later hour

. Tuesday, March 9, 2010
1 comments

Suppose we need to round up the following data (in minutes) in a SharePoint Column to later hour: -
Time
10
30
60
90
140
Here's how one can go about it.Add a new calculated field and add the following Excel function - ROUNDUP(value, number of digits). Our formula would be - ROUNDUP([Time]/60,0). This would round up the minutes to nearest later hour. Hence result would be: -
Time
10 1
30 1
60 1
90 2
140 3

Wednesday, June 3, 2009

Error while moving documents across site collections, sites - cannot read from source file or disk

. Wednesday, June 3, 2009
0 comments

Using windows explorer one cannot drag n drop (cut-paste) documents across site collections.

If you try to cut-paste (drag-drop) documents across site collections or across sites in same site collection, you would get the following error: -

"cannot read from source file or disk"

WORKAROUND

1) Open the source and destination libraries as network places. (using add a new network place).

2) Browse to the document libraries in question.

3) Drag-drop the files.

4) There’ll be no error.

Things to check at client’s end: -

1) Check if Webclient service is running and is set to auto start in services.msc. Stop and restart it.