Solved

External lists and attachments (MOSS 2010)

Posted on 2010-09-23
2
948 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 (Megan) earned 500 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 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