.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

Import Word docs with Metadata into SharePoint 2010 from Windows Server 2003

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint

I need to import 700 Word docs (2003 & 2007) from Windows Server 2003 into a SharePoint Server 2010 library.  I only have a test server to work with right now and want to do as much pre-work before we launch the actual server. 

My goal: When we launch the shpt server, import all docs into a library so that columns propagate with metatdata automatically.

I'm not sure what the best approach is...

Can I can open each doc and add custom properties (maybe with InfoPath) to import as metadata, then import managed metadata through the term store tool and have it associate with the manually entered custom properties? I don't fully understand managed metadata, which might pose a problem.  And before I start importing terms, I thought I should find out if I've completely misunderstood how taxonomies work.

Or I have an excel spreadsheet with info about each doc in columns that can act as metadata. I could upload this as a list then associate each doc with the list.  But it seems wiser to enter the metadata into the documets.  

Is it possible to update my docs in advance so that uploading goes smoothly? I have help now for data entry that I won't have later.

I have no resources to spend on tools, and have to figure out and build this&nbs

View Complete Post

More Related Resource Links

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

Deployment of SharePoint Server 2010 on Windows 2003 Server Std Ed


After reviewing http://technet.microsoft.com/en-us/library/cc262485.aspx document on hardware/system requirements it appears that I will need to upgrade my Windows 2003 Server Std Ed to at least Windows 2003 Enterprise Ed in order for SharePoint Server 2010 Ent to be able to address more than the 4 GB (I believe) Windows 2003 Std only allows or addresses.  I have 32GB RAM on my Windows 2003 Std which also hosts the SQL Server 2005 Std Ed databases for other apps and will host SharePoint's database, as well--single platform install.  I also have two CPUs on this box which SQL (32 bit) uses.

So my question is:  can I easily upgrade Windows 2003 Std Ed to Enterprise without having to reinstall Windows 2003 and subsequently all other apps in Windows?
Kerry Jensen IT/Network Admin

SharePoint Server 2010 - API to convert word docs to FILTERED HTML


Using word automation services, we cannot convert a doc/docx to FILTERED html, which can be done on client side using "saveas".

Is there any unexposed API through which one can achieve this using SharePointServer2010 + c# programatically.

or any alternative way to get FILTERED HTML format file from doc/docx?

I knew the way to do this as a client side application. This can be acheived simply by recording macros.

Ref: http://tudorstoian.blogspot.com/2008/02/word-automation.html

I want sharepoint 2010 server side way to do this task.

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Converting Word Documents to PDF using SharePoint Server 2010 and Word Services (Visual How To)

Watch the video and explore code as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.

Sample: Converting Word Documents to PDF using SharePoint Server 2010 and Word Automation Services

Explore the code in this visual how-to article as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.

Video: Converting Word Documents to PDF Format Using SharePoint Server 2010 and Word Services

Watch this visual how-to video as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010. (Length: 6:15)

A Brief Introduction to Enterprise Metadata Management for SharePoint Server 2010 Developers

Learn about some basic developer tasks that you can use as basic building blocks for more powerful and complex metadata solutions.

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Can WEBDAV be disabled in Sharepoint 2010 on a Windows Server 2008 R2?

Hello, we had some issues with WEBDAV use with Sharepoint 2010 placed behind WEBSeal proxies. We decided to only use FPSE (front page server extensions) for an external access to this portal. I cannot find a way, how to disable WEBDAV, or how to force clients to only use FPSE with this portal. It is fair, to say, that we would like to make such configuration on a server side, rather then configure client computers. We are running Sharepoint 2010 on a Windows Server 2008R2 server (i.e. IIS 7.5) thank you in advance for help/ideas Roman Cernovsky

Opening Word 2003 document from sharepoint site in word 2010.


When using sharepoint services with word 2003 on an XP machine, everything works fine. We bought some new computers where we now have windows 7 and office 2007/2010. These work perfect too. Even the 64-bit computers.

We are very happy with the new office version, so we decided to upgrade the entire company. As a test, we upgraded 1 PC. But this is not working. So we upgraded office, later we reinstalled it. But nothing helps. This is the problem: I surf to the document click it to open it, and then Word hangs. "contacting server". This is not always the case, sometimes it works, sometimes it doesn't. This even with the same document.

We would really like to upgrade to office 2010 entirely. But we're not going to buy licences we cannot use. Anybody got a solution?

Search for people in Sharpoint Server 2003 from Sharepoint Server 2010.


Anyone know how to setup so that Sharepoint 2010 crawls Sharepoint 2003 people?

We have tested adding a new content source called People with a content source type of sharepoint and used sps://site.domain.com/site$$$people as the start address.

When trying to SAVE/OK we get the following error.

The start address "sps://site.domain.com/site$$$people" is not valid for this content source type.


Windows 7/Server 2008 R2 + Office 2010 cannot connect to SharePoint 2010


I have a Windows 7 x64 machine, with Office 2010 x86 installed.  I also have (2) Server 2008 and (2) 2008 R2 machines with Office 2010 x86 installed on them. On all of these machines I can not connect to SharePoint 2010 using Office.  The following occurs:

  • From the browser, browse to a doc lib. 
  • Click on an Office document, select "Edit in Microsoft ..."
  • An "Open Document" dialogue box appears, indicating that "Some files can harm your computer. If the file information below looks suspicious, or you do not fully trust the source, do not open the file.  File Name: Whatever.docx  From: SPServer2010.  (This is the first clue that something is not working properly.  I don't think this would appear otherwise)
  • Click OK.
  • The document opens, but with a [Read-Only] in the title bar. 
  • If I click save, it tries to save to a default location on my desktop computer.

Another example of the problem:

  • Open an Office 2010 application. 
  • Click File>Open
  • In the Open dialogue box, type in the URL of a document lib on the server. 
  • The error message: You can't open this location using this program. Please try a different location.

Final example of the problem:

  • Click Upload Multiple

Error installing SharePoint Server 2010 Prerequisites - Namely Windows Identity Foundation


Good day to all

i am trying to install Sharepoint server 2010 on my server, i have a windows server 2008 sbs sp2 pc. i have manually downloaded the Prerequisites and installed all except the windows identity foundation which just hangs. i have downloaded the file from the windows site namely: Windows6.0-KB974405-x64.msu, please can someone assist me in this matter i am at a lost.

Unable to import from Excel on 64-bit Win 7 workstation to a 32-bit Windows 2003 Server running SQL



I recently moved from Windows XP to Windows 7 on my primary workstation, and since then I'm unable to import from Excel to SQL from any of my SSIS scripts when I run them Locally.  The one instance I'm running into now is importing from Excel 2010 on my system (64-bit Windows 7) to SQL Server 2008 running on 32-bit Windows Server 2003. 

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

I even tried creating the import through SSMS and saving it as an SSIS script to get the same results.  The only thing I can think of is the change of architecture on my workstation.  I'm running 64-bit Windows 7 and the server is 32-bit Windows Server 2003 and SQL Server 2008.  Below is the Validation text SSIS returns:

Validation has started
[SSIS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
[Source - Sheet1$ [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC00F9304.  There may be error messages posted before this with more

import filtered sharepoint 2010 list data into a word document

i want my filtered list data in sharepoint and export the data into a word document with some relevant fields not all the fields. how can i acheive this ?  
e.g i want to show all items related to "taskname" in word document.

New Content on Excel Services and Word Automation Services Development for SharePoint Server 2010 (B

Check out the new visual how-to videos and articles that showcase how to create interactive solutions around Excel Services in SharePoint 2010, as well as book excerpts for Excel Services and Word Automation Services.
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