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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 

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


View Complete Post


More Related Resource Links

Oracle data into Sharepoint (Moss 2007) List

  

I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.

Please provide me the best approach to do this.

Thanks


Oracle data into Moss 2007 List

  

I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.

Please provide me the best approach to do this.

Thanks


Oracle data into Moss 2007 List

  

I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.

Please provide me the best approach to do this.

Thanks


External List Error - Access denied by Business Data Connectivity

  

Hello Community,

Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all operations, and I filtered the return by limiting it to a 100 items.  Using the Create List and Form wizard I then created an External List from the ECT. 

Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.

I have read several blogs about this issue (which seems to be common) but I still can't resolve it.  Can anyone help?

Thanks!

Tom


Tom Molskow - SharePoint Architect -

Unable to open pdf from document library MOSS 2007

  

When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.

 

 


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open

  

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.

Help.. 


Moss 2007 Document check out and check in errors

  

Users are receiving errors when trying to check in documents.

Specifically,

"The Web server is busy. Try again later."

and

"This document was checked out to your local drafts folder but the local copy could not be checked in to the site. Close any application that is editing the document and try to check in again, or discard the checkout."

and

"There is a problem with the Web server. Try again later, or contact the server administrator."

Workstation has office 2007, upgraded from 2003. Documents are being checked out, edited, and checked in properly. Any help appreciated. Thanks.


Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

  
This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

  
Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

  
Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

  
SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Importing SharePoint List Data into Project Server 2007 Custom Fields

  
Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Exporting MOSS 2007 List to Excel 2007

  
When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

DOCUMENT WORKFLOW IN MOSS 2007

  

Hi,

We are using Office 2003 standard edition SP3 in our work place in which we are not able to edit documents with workflow .

Any suggestions or alternative option to use this feature is most welcome.

 

Regards,

Garima


Authentication for External Users to Access MOSS 2007 Resources

  
Our MOSS 2007 supports users from two domains that authenticate using windows.  Our clients WindowsXP in domain#1 and WindowsVista in domain#2 (which has presented problems authenticating to MOSS 2007.  I would like to give access to external users outside of those two domains.  However, our management does not want to establish trusts between domains.  What would be the best practice to accomplish this?  Additionally, will MOSS 2010 or Forefront resolve these issues?

Seperate out the Document Libraries to individual Sites in MOSS 2007

  
We are using the MOSS 2007 with SP2. We are having three different Document Libraries for three different projects under same site. We have the requirement to migrate each library to shift to the individual sites. We need to do this with all the content, settings and and the permissions. It's fine to migrate the database and settings individually i.e. content database seperately and site settings seperately. Is anyone have this kind of migration?
Categories: 
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