Solved

External lists and attachments (MOSS 2010)

Posted on 2010-09-23
2
922 Views
Last Modified: 2012-05-10
Hi ,

The new external lists are great but quite limited in their uses. The relation data application I'm about to build will contain a lot of custom logic and will make use of a plain ol' database connection.

Some external database tables will be exposed in SharePoint as external lists and allow all CRUD operations. Some pages will however contain custom webparts to actually edit the data while it looks like as if it is normal SharePoint functionality.

One requirement of a few of those external lists are attachments. My tests indicated that attachments are not working on external lists (just like workflows and event handlers). Has anybody thought of a way to allow attachments on an external list? Will I need to handle this requirement in my custom logic?

Cheers and thank you in advance

0
Comment
Question by:CJ_S
2 Comments
 
LVL 42

Accepted Solution

by:
zephyr_hex earned 500 total points
Comment Utility
i'm not sure you need a custom web part to show external data in sharepoint.  Data View web part does that.

Data Form web part is similar, except it can also be configured to allow editing of the data.

regarding attachments, you can add attachment functionality to a web part using custom code.  here is an example:
http://www.pointsharepoint.com/2008/12/list-attachments-in-webpart-solution.html

you can likely use the DVWP for DFWP as a basis, and add attachment functionality.
0
 
LVL 22

Author Closing Comment

by:CJ_S
Comment Utility
Cleaning up.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
This video discusses moving either the default database or any database to a new volume.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now