Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

External lists and attachments (MOSS 2010)

Posted on 2010-09-23
2
Medium Priority
?
988 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

722 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