.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Inconsistent data with DateTime values in Word Document Library

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :SharePoint


I am new to SharePoint (2010), and my company has recently migrated a Document Library from a different Content Management System. The Doc. Lib has been set up with Content Types and custom Word (2010) Templates to provide a specific structure to the documents. There is a requirement that the Metadata Columns be embedded into the content of the Word Documents, which we have done. However, we are an international company, so we are spread through several time zones.

Two of the fields in the documents are date-only datetime fields, but these fields must contain non-time zone aware dates. In other words, regardless of which timezone the document was created in or added to SharePoint, all users world-wide must see the same date.

When we create the documents by using the "New Document" menu in SharePoint, and fill in the Document Information Panel in Word, the dates work as required. However, if we use the "Upload Document" option, and then fill in the properties in the Default Edit List window, then the dates are time-zone aware, and users in an earlier (further west) time zone see the date as one day earlier.

After some investigation, it seems that Word stores the dates in the format yyyy-mm-dd hh:mm:ssz, with no offset information, and SharePoint then doesn't apply an offset when displaying/storing the data. However, when

View Complete Post

More Related Resource Links

Default Column Values in a Document Library (SP2010) do not show up in word 2010 until you save and


when you create a document in a SP 2010 document library (of a particular content type, by clicking new, letter (content type name) in sharepoint for example) which has default values set on in in the library (set by using library settings -> change default column values), the default values do not show up until you create the document , save it and reopen it again.  Is this a bug or by design.  If it is by design, it is horrible since if some of the column default values are mandatory in the content type then you actually have to type them in before you could possibly save the file which defeats the whole point of having default column values.  Also it is tremendously clunky for a user to have to create file, save it , close it, and reopen it just to view the default metadata in the document information panel that is supposed to be there.

Anyone have any thoughts/solutions to this problem?


External Data Fields in a Word Template saved as a content type in a document library with multiple


I have created a Word Template for a Document Library that has an External Data Column in it of Client Name which also adds Client Address1, Client Address2, Client City, Client State, & Client Zip.  Now this works fine for a Document library with that template as the Template.dotx file. 

I want to be able to make a bunch of Templates and have them all as Content Types in one Library.  When I do this I cannot get the External Data Quick Parts to work.

Anyone have any ideas?

Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

Replace text in a word document stored in a Document Library


Hi to all,

im tying to replace some text introduced in a word document stored in a document library.

Exactly i need a web part with a button that change a key in a word template <list> (for example) and replace <list> with a text in another list.


I think that it would works with the Microsoft.Office.Word.Interop; namespace but when i call the function :

wDoc = wordApp.Documents.Open(ref fileName, ref missing,
                                ref readOnly, ref missing, ref missing, ref missing,
                                ref missing, ref missing, ref missing, ref missing,
                                ref missing, ref isVisible, ref missing, ref missing,

Converting Word Documents library to PDF document library in SharePoint Server 2007

My project requires me to create an event reciever such that when a word file is added to one library the same content pdf file should be added to other library also when a word file is updated,edited or checked in the respective pdf file in other document library should be replaced by a new pdf file with the edited word content . Can we do this in Sharepoint 2007 I have seen this can be done in Sharepoint 2010 http://msdn.microsoft.com/en-us/library/ff181518.aspx

Document Library Not Refreshing External Data

I have a Document Library which has a column connected to an external list (BCS).  I have serveral columns that are displaying data from the External List.  When selecting the refresh icon on the column, I get the following message: Refresh successful. 0 item(s) were refreshed. 0 item(s) could not be refreshed. Contact your system Administrator. So after the refresh is completed,  the external data is not refreshed with the latest data in the database.  The only way I can get the data to refresh is by editing the item and the document library.  This seems to force the external data to refresh.  When viewing the external list, the data is refreshing like it should.  What do I need to do to get the external data to refresh in the Document Library? Also is there a way to make the Document Library refresh automatically without hitting the refresh icon.  

Importing Data from Excel into SQL Server using SSIS: some datetime values appear as NULLS How to Re

I created a Package in the Business Intelligence studio to Import data from Excel file  into SQL Server 2005 using a Excel Source and a OLE DB Destination that uses a data convertion transformation before it reaches the destination a mjority of the data is copied over. However i am having 2 Issues. 1. In the Date field some of the values appear as Null in SQL Server 2. I need to change the format of the date in Excel from dd/mm/yyyy to mm/dd/yyyy before inserting into SQL Server if Possible. I am not sure of the solution for Ques 1 but i attempted using a script task for #2 It did not work. Please Advice what the best way to proceed Thanks.

Multiline text field in document library and item update from Word trouble

Hi I have faced a bit of odd problem. Here is the scenario: I have document library with text columns (multiple lines of text) that are set to unlimited length. I have a workflow that runs with Word documents (.docx) that stores information in XML to this field. Everything works perfectly until document is edited in Word and saved back to document library. After Word saves my document in document library, the multiline text field is "cutted", only 7 rows of text is saved to my field. I have tried hiding my text field, making it sealed or readonly, but still Word breaks my field. Funniest thing is that when editing document in Word, this field should not have any changes (meaning that I dont show my "long text field" in document information panel back in Word). I have tried also creating event handler to handle itemupdating event in document library where I switch spweb.parserenabled property to false and in itemupdated event I switch it back on. Also I have tried to remove all line changes from XML with no luck. This XML saving to long text field works perfectly with many other places but in this one environment this does not seem to work :( I am looking forward to any suggestions what to try next. I have been wondering about using the eventhandlers and trying to "protect" my text field with some logic but that is still just a thought.   T

Workflow data missing from Document Library

Hi, We have this strange situation where the workflow status is missing from document library views. Here is the situation: I have a Document Library with 3 OOTB approval workflows configured to start manually. Process is that user uploads a doc, start the first workflow, once it gets completed starts the second, and so forth. Now if I check the All Documents view of this Document Library, I can see these three workflows have 3 columns and that shows the status of the workflow - say "In progress", "Completed" etc. Now our users who use this document library and workflow complains that they cannot see these status of the workflow after some days. If a workflow is completed and status shows completed there, but after some days that column is blank. I've checked the modified data for the documents and this issue according to the user happens to documents that was uploaded 2 weeks back too, which means this doesn't happen to old document only. This document library has Major and Minor versioning enabled. Why does this happen, does SharePoint remove data for completed workflows? I checked the document's workflow page and its empty; nothing under running workflows and nothing under completed workflows. In Doc Library settings - Workflow settings I could not find an option View Workflow reports. That page has the following details: Use this page to view or

how to merge contents of a form library and picture library into a report (word or pdf) document

Hi all           I want to generate a report  containing data from a form library and pictures from a picture library. I am able to generate ms word report from data filled in form library using http://www.bizsupportonline.net/infopath2007/convert-infopath-form-into-word-2007-document-xslt-c-sharp.htm . . But now actually i need to merge images from a picture library into that word  document . thnxs 

Business Data linking to Document Library

I have setup my BCS and have working on a page a BCS Connectivity Filter which returns the correct data in my BCS list web part.  I also have a document library with an External Column using the same BCS, my question is on my page can i show the relevant documents that are tagged with the same Unique ID as the data showing in my BCS list web part? Any help would really be appreciated :)

How to move or migrate document library with all data from one web application to another web applic



We have created one document library in a web application and also added some documents in it.

Now we want to copy same document library to another web application with all content.

We have tried list template option but it is not working as document library is exceeding size quota(greater than 50 MB)

Please help.

Thanks in advance.



Document Library and Data View - New Item


I want to add a Data View WebPart to upload a new document to a SharePoint Document Library.

What I'm aiming to do is to have a list item displayed on a page and then upload related files to a document library rather as list item "attachments".  So the user would come on to the page, see the list item and have an upload box underneath with all the document's metadata next to the upload  Can this be done using SPD?

I've had a quick look around and I'm suspecting the answer to this is "NO" but I thought I'd ask anyway.

(I'm thinking custom webpart)

SPD Workflow Associated with a Document Library Deletes all Date Values


A client has encountered an issue where they created an SPD workflow, associated with a document library, set it to start manually,  that updates one of the metadata columns using the "Set Field in Current Item" activity.  Once that step completes all the date values in the metadata columns are missing.

Upon further inspection, we determined that this is only occurring for office documents.  It deleted the dates for word and excel documents and did not for text and pdf documents.

We are able to duplicate ths on 2 different servers that are both on service pack 2.

We have tried different version settings on the document library and making the date metadata columns required.  No luck.

To recreate this issue:

1.  Create a new document library and added additional metadata columns to it.  Make some of these columns dates. 

2.  Create a new SPD workflow associated with the newly created document library 

3.  Add a "Set Field in Current Item" activity to the workflow and set one of the non date columns to a different value.

4.  Upload a word document and make sure to fill out the date fields.

5.  Kick off the workflow manually.

6.  Once the workflow

Reading data from document library excel workbook



I am having Sharepoint 2010 Enterprise RTM Trial on windows Server 2008 SP2. 

I have Document Library in my site. I want to display the contents of excel workbook placed in that library in a webpart (webpart like List webpart not Excel Web access webpart). If workbook is updated then the webpart should also update....

Can it be done through workflows ? or any other webpart that provide me the desired behaviour ?


The alignment for the data in the Word document is missing when preview generated for it



we are using RichTextBox to create Word document in our application.It is working as MS word document in most of the situations.But,we are facing a problem in one scenerio.That is

Reproduce steps

1) Copied the document/data (E.g.: SRS document) and pasted it in the Word document.
2) Clicked on save and clicked on preview, in the preview the alignment for the data is missing.

for Ex.

1 Purpse of the document....................................................3(content color is in black)

we pasted it,but it is appearing in preview like this.

1 Purpse of the document       3(content color is in blue)

We are not getting why it is happening like this,Please provide a solution.



Passing Calculated Columns from Sharepoint into Word Document Library Template


Hi all...

Another noob question.  I have been able to figure out how to pass single line text, date, etc. data from a Sharepoint List into a Word Template, but I am still trying to figure out how to pass a calculated column.  Is there a workaround?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend