.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to connect text file data to native SharePoint lists with auto update?

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint

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???):

Any other idea? BDC-based? Thanks.

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

View Complete Post

More Related Resource Links

how can we easily update sharepoint lists data


We have data from our business systems in a report which need to be updated automatically. How can a sharpoint list pick's up this data automatically from a local file directory?

Update Profile Database from text file using BDC



I have a requirement to import the profile properties from a text file in sFTP to update the MOSS Profile Database. The objective is to create a single repository for the Staff Directory in MOSS.

Can I use BDC to connect and update the Profile database?

What is the alternate approach?


SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

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

Video: SharePoint 2010 Lists, List Data, and CAML

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

Data loading from text file

Hi, I am loading the data from a flat file into a sql table. The values in one of the column have spaces at the end of the value. I want to remove those spaces and load into the table. I am thinking of using derived column and use rtrim on that column, how can I use that as an expression. Thanks.sqldev

Invalid data has been used to update the list item in sharepoint 2010.

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

saving a text file in ms access data base

i have to read a text file in a text box then have to save it into ms access data base in column format how could i do this....

How to connect 2 Lists Sharepoint site through Designer

Hello to all I am siddiqali new to sharepoint 2010,I want to know how can i connect 2 lists in sharepoint 2010 without using code ,look ups and visual webpart. I am guessing that it can be posibble through designer,but as i am new to sharepoint i am not able to do it  Example If in 1 list student number,name,class,section is existed ,In other list if we enter student number in text box we should get the student information   Thank You, MD.SIDDIQALI

How to update JavaScript in SharePoint Ribbon Elements.xml file?


I created Elements.xml file that added button to Ribbon of Web Part page.
I created <CommandUIHandler tag and put JavaScript into CommandAction.
Everything works.

I inserted changes to JavaScript and built and deployed project in VS2010.
The button function was not changed the previous JavaScript was used. I uninstalled feature and rebuilt and redeployed project. The button functionality was not changed again.

What I have to do that JavaScript changes work in CommandAction?

Thank you in advance for any help.

Boris Nossov

Unable to load data from txt file with text delimiter specified, if the data has the same character


Have come across a strange scenario and seeking your ideas/thoughts.

I'm using a ssis package to load a txt file. The txt file is text delimited by double quote (") and column delimited by tilde (~). It works fine in most scenarios and strips the enclosing "" from the columns -no problems there. However, in a specific scenario where the last column has double quote in the data as well being the text delimiter, the package throws the following exception indicating that it's missing a column delimiter

 The column delimiter for column "COL_NAME" was not found

This behaviour was not observed when double quotes were present as data in any other column in the file. Was able to workaround by disabled text delimiter only for the last column, but that isn't a perm solution. Also observed that if the " was replaced by escape sequence /" the file loaded successfully. Wondering if this a known issue ?


update list text or date value via sharepoint designer using JAVA


Hi All,

Bit of a noob question - but tried all sorts and can't get this to work - also first time i've ever used sharepoint.

(I'm using sharepoint designer 2007) I have a form, on the form i select a type (drop box choice) and it hides or displays a related field, I want to auto populate the field when it displays, below is the java i have currently. 

Please advise how to populate (date field) with tommorows date, and also if it was a text field with the word "testdre"

<script type="text/javascript">
  function hideFieldsOnStart()
   //hide the control at start
   var control = getTagFromIdentifierAndTitle("input","TextField","Urgent Change Justifacation");
   //add an onchange event to the dropdown
   getTagFromIdentifierAndTitle("select","DropDownChoice","Change Type").onchange = function() {ChangeEvent()};
  function ChangeEvent()
   //get the dropdown

Search data from sharepoint list and populate repeating table (Seach text should be entre in first f


Hi All,

I am newbie to infopath.

I have assignment to search data from sharepoint list and display it to repeating table. Below is the case in detail.

i. User enter search text in first textbox of repeating table.

ii. After text enter you will Enter or click tab button.

iii. As user press Tab /Enter, the other textboxes of repeating table will populate with data automatically.

iv. If searched data rows are more then one, then dynamically add new row's in repeating table and  show searched data.

I am working at offical assignment and it's deadline is very tough. i had made extensive search at google and msdn forum but unable to accomplish. I would appreciate and thanks is some provide me solution in form to a small infopath application and code snippet.




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


Can some one help me to achieve below task

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

onchange retrieve data from SQL and update text fields


I have tried to search web regarding my query but couldn't find what I actually require, I was about 70% near but couldn't achieve what i'm looking for.


To put it simple, below is my query:


I have an ASP page which has a select box (input box) in which I'm adding request numbers through SQL database.

Below are some empty text fields, check boxes.

Whenever any user selects any of the request numbers from the select box, I want to query the database and update the below text boxes and check boxes according to the request number.

I don't want user to press any button or refresh or another frame.

That's it, if i get any example on how it's done, I will construct it the way i need, hope someone will help me here.


Thanks in advance.




Surface data in external lists in Sharepoint Foundation 2010



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?

SharePoint tool - update metadata, permissions of sites, lists,listitems


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




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend