Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

External lists and attachments (MOSS 2010)

Posted on 2010-09-23
2
Medium Priority
?
992 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 44

Accepted Solution

by:
zephyr_hex (Megan) earned 2000 total points
ID: 33746629
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
ID: 33967210
Cleaning up.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Loops Section Overview

916 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