.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

Business Data linking to Document Library

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :SharePoint
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 :)

View Complete Post

More Related Resource Links

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.  

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 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)

Inconsistent data with DateTime values in Word Document Library



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

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?

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 ?


Linking to Reports in Document Library from .net web application


I have a document library that contains some SQL Reports.  I have crearted a .net web application and I have a page that has links to the reports.  I got the following error message:

Reporting Services does not support anonymous user from a SharePoint site. To view Reporting Services reports, choose a SharePoint site that does not have Anonymous access enabled or sign in on an anonymous site.


So, I turned on Anonymous access for the site, and gave the document library view for anonymous access.  Now I can access the applications without an error message, but others are still getting this error message when they try to access from the link.  Does anyone know why this would happen?  Thanks.

Bulk Import Documents and Meta Data to Document Library SP 2007


RE: SharePoint 2007


I have an excel file with rows and rows of META data and one column is a file name. This filename column maps to a physical file I have as well.

There are 1000's of rows with matching files.

Is there a bulk import tool for free or minimal cost?

I understand I may need to build a document library and create the same column names as the META data, but manually adding these will take me years!

Thanks Daren 

How to automatically resolve external business data in a MOSS 2007 document list


Here's what I have so far...

1.      I have a document list in MOSS 2007.

2.     Each document in the list may be sent to an external system for further processing.  This was done by adding a custom feature to the document libraries actions menu in SharePoint.

3.     The external system uses it's own SQL Server database.  A table in this database references the SharePoint document’s GUID.  Additional columns in the table are updated during external processing data such as status.

The problem I'm trying to solve is this:

1. I would like the see the external processing status for a document in the original SharePoint document list.  This status will change and needs to be updated for each document automatically.

I tried setting up a business data column in the document list.  I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition.  I added the business data column to the list

Upload a File to a SharePoint Document Library - Part I

The following helper class demonstrates a few techniques that allow documents to be uploaded to a SharePoint document library programmatically without using the API or a custom web service. You don't need to specify a document library name, and it will create any folders specified in the URL as required. File meta data will be updated if any properties are passed.

Data Truncation issue with Enterprise Library Logging WriteLog stored Proc


Hi ,

I'm using Enterprise Library Logging  feature for logging. The issue i am facing is when the Logging message is too large(more than 65534 chars) ,complete data  is not logged in the Formatted Mesage column which is  of data Type nText .

I am able insert complete data if i try inserting from Sql insert Query from sql management studio. Do i need to add any attributes to data base listener or do i need to change the sp.

 Is there any way to increase the WriteLog stored proc param size in EnterpriseLibrary.Logging config file ? . Please let me know.


Thanks In Advance.

data access library v4.1


Ive just started a project that will use the enterprise library 4.1 data access code blocks.  Its been years since ive used them, can anyone tell me what assemblies I need to reference in my project in order to use them ?  Ive referenced 


are there any others I need ?

Input Validation: Enforcing Complex Business Data Rules with WPF


Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.

Brian Noyes

MSDN Magazine June 2010

Cutting Edge: ASP.NET Ajax Library and WCF Data Services


This month Dino takes a look at the JavaScript components coming in the ASP.NET Ajax Library and explains how they can be used for effective client-side data access.

Dino Esposito

MSDN Magazine March 2010

Data Points: The Enterprise Library Data Access Application Block, Part 3


E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.

John Papa

MSDN Magazine October 2005

Data Points: The Enterprise Library Data Access Application Block, Part 2


Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).

John Papa

MSDN Magazine August 2005

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