Oracle data into Moss 2007 List

I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.

Please provide me the best approach to do this.

Thanks

I need to access the Oracle data and insert into the sharepoint (Moss 2007) List.

Please provide me the best approach to do this.

Thanks

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

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

We have several problems with our MOSS 2007 installation and operation and since we found out that two identical sharepoint servers (production and test) that had same updates applied have different Search_DB databases (they have same name function with different number of parameters, for ex.) we have a single idea of what can be the cause: Somehow, windows update or other quirk, an update or hotfix got applied to one of the servers.  Strange thing is, noone of our employees seems to know, neither google seems to know, how do we exactly get a list of installed updates on the MOSS 2007 installation.   So, simple question: HOW? How do we get a complete list of changes (hotfixes, servicepacks, patches) done to an installation of MOSS?

Hi, My requirement is that I have some excel sheets on server and i want to import those data into MOSS2007 site custom list. what is the best approach to achieve this?

Hi all, My end goal is to display a list in SharePoint2010 .... but the list actually originates from SharePoint2007. I thought it could be as easy as creating BCS to the SP2007 list web service (/_vti_bin/Lists.asmx) but BCS has issues with the complex data types and based on other threads this isn't possible.  We've been able to create a data source to the web service and display the list contents on a custom aspx page, but this isn't exactly our end goal. Is there a best practice for this type of thing?  Or do we have to go down the path of creating a custom web part while consuming the web service directly or the SOAP data source we've created?+ Note: Migration is not an option at this point... integration is our current path. Any help is appreciated. Thanks, Eric

Hi, Actually right now there is Newform.aspx of the list in MOSS 2007 through which we are collecting the data from the user.Now our customer is planning to migrate the application to SharePoint 2010 so i just want to know so that can we get a easy support to implement in InfoPath 2010 compared to the list of MOSS 2007 Thanks & Regards, Sudheer

Hi, I have a list in MOSS2007 and I want to save it as a template to use it in SharePoint 2010. But, the problem we can't use stp file in SP2010. So, did you have idea about creating wsp package in 2007 for existing List ? I have seen this article but it talk about Discussion List Feature. Thanks 

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

Dear Expert, My user always report that some data that have been key-in by them (sharepoint web form) was missing during the WF is routing to (verifier & approval). FYI the verifier & approval only have a permission as a "View" anybody here have a same experience with me?? Isit the issue is because of sharepoint itself or human (i've try to create dummy record but work fine) ??

Hello,

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.

Thank you,

Kishore

---

Kishore

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.