jayngin
asked on
How do I get information from a Business Data Catalog to be autopopulated into a list in SharePoint 2007?
Help Anyone!!
I have sucessfully created a Bussiness Data Catalog Application to connect to a SQL 2005 database and the information can be searched or put into a Bussiness Data List Web Part (Data View) I would like to actually use the BDC information in a Custom list so I can run query's, workflows, drop down boxes to use in other lists in the site. Does anyone have any idea how I would go about doing this? I have tried one sugestion but I could not figure out where i needed to go to do the code for the lists see here: http://www.codeproject.com/KB/sharepoint/WSSDatabaseSync.aspx?fid=1531864&select=3023307&fr=1
I left off at create custom sharepoint list.
I have sucessfully created a Bussiness Data Catalog Application to connect to a SQL 2005 database and the information can be searched or put into a Bussiness Data List Web Part (Data View) I would like to actually use the BDC information in a Custom list so I can run query's, workflows, drop down boxes to use in other lists in the site. Does anyone have any idea how I would go about doing this? I have tried one sugestion but I could not figure out where i needed to go to do the code for the lists see here: http://www.codeproject.com/KB/sharepoint/WSSDatabaseSync.aspx?fid=1531864&select=3023307&fr=1
I left off at create custom sharepoint list.
kitesurf
I created a piece of code that reads the bdc and populates a list, but I don't have a solution to update it. I use Visual Studio 2008, and the article you state probably uses the same. The book SP Unleashed Development may help you out in understanding the basics. The article you stated is more advanced with direct links to the database instead of using the bdc. a colleague of mine had some difficulty with the connections in the past, but if you can pull it off, that link on code plex is the way to go.
ASKER
Does the code you wrote only populate this list once? Or does it populate it with any new rows of data that come into the BDC from the SQL DB?
the console application runs once everytime you click it. however it will add the new rows with the old, and unless you delete the rows added from the previous run, it will add to those to.
ASKER
Thanks for the explantion. Can I get a copy of the code possiably? I am sure I can figure out how to delete it and recreate it every time it imports that way it is always the most current data.
:)
:)
I will put up a link tonight, that way we can add to it in a blog as we improve upon it.
ASKER
Thanks Kitesurf :).. I will look for it to night and let you know how it works
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.