I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.
Please provide me the best approach to do this.
View Complete Post
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
Is there a way to upload multiple files to a SharePoint List Item in MOSS 2007? I can not use Doc Library because of the funcationality.
Is it possible to attach multiple files to a single item in a List Webpart. If So how?
We are using MOSS 2007 and the attachements will be word dorcuments.