how can we easily update sharepoint lists data

I have to pull external data from a text file to a SharePoint list on a daily base. Additional column content (e.g. attachments) in SharePoint should be kept during update. There should be RSS feeds, email notifications or workflows on external data change (so delete all items and import new will not work).

I've found this codeless 3rd party solution with automatic background update (and write-back???):
http://www.layer2.de/en/community/FAQs/BDLC/Pages/How-to-connect-text-file-to-sharepoint-list.aspx

Any other idea? BDC-based? Thanks.

---

Thanks, SharePointFrank http://www.layer2.de/en/products/

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

I have created a custom list definition with one lookup field <      Field ID="{865CD714-7DF6-4F65-9DBC-5FE910B10BC5}" Name="CompanyName" DisplayName="Company Name" Group="Custom contents" Description="Select Company" Type="Lookup" ShowField="CompanyName" Required="FALSE" FieldRef="CompanyName" List="Lists/LookupListDefinition-ListInstance1" ReadOnly="FALSE"></Field>   <nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. My solution is perfectly get deployed on site. I can see the list instance created on site its also appears on quicklaunch. When i am trying to add the item into the custom list using UI then i am getting the input form correctly i can see the lookup values in dropdown list but when i click on save button then its give me an error as mention above. For debugging purpose i have created the event reciver class for list item adding event. In that i have check the column status and

Can some one help me to achieve below task

Save/Update/Delete Sql Server data base table using Sharepoint Designer.

Hi,

I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it. 

I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List.  When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database names and click OK with the Connect with User's Identity radio button still selected and I get the error message: login failed for user ''. The user is not associated with a trusted SQL Server connection.  I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services.  Can anybody help with this?

Hi All,

 

I am setting a SharePoint test environment with loads of data.

I could some how manage to use tools to populate data in Sharepoint.

But I couldn't find a way to

1) Modify the sites/lists/listitems in an easy way without me havng to manually perform that

As I had 200GB of data with some thousands of sites and lists, I am not able to manage this data manually.

For my testing to run smoothly, I need to be able to add/delete/modify the metadata, permissions of many objects easily

 

Can someone suggest me  a tool which allows me to do this kind of functionality

 

Thanks

Carol

Hi,

I am looking to import data from  a Relational SQl Server Database that is hosted externally by a 3rd Part vendor. My task is to import all the data that is entered by the external customers into the Sharepoint lists. The external users are presented with a free form Registration page where they enter their data. For the internal users, we want to pull that data in real time and display in lists.

So inother words as soon as the data is entered on the form and user submits it, the database and the sharepoint list should reflect changes simultaneously.

Please give direction as to how can this possible.

Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

---

Mohammad Siddiqali