Importing 3000 records to sharepoint list causing requesting time out error
My requirement is to import a csv file data having around 3500 - 4000 records to SharePoint List. Implementation 1. Reading csv data to datatable 2. Checking some business condition whether already record exists then update 3. Else insert for new data looping through the datatable and inserting 3000 – 4000 records to List, getting request time out error. When I see the execution time out in my web.config is set to 3600. But I am getting the request time out after 2 mins only. Please suggest Web.config of my web application <location path="_layouts/UploadEx.aspx"> <system.web> <httpRuntime maxRequestLength="2097151" executionTimeout="3600" /> </system.web> </location> <location path="_layouts/ctdmsettings.aspx"> <system.web> <httpRuntime executionTimeout="3600" /> </system.web> </location> <location path="_layouts/policyconfig.aspx"> <system.web> <httpRuntime executionTimeout="3600" /> </system.web> </location> <location path="_layouts/metanavsettings.aspx"> <system.web> <httpRuntime executionTimeout="3600" /> </system.web> </location>
July 7th, 2011 4:25am

Hi Ghouse, Did you try to open the csv in excel Document and export to a List? or are you using server API/web services to do this? http://www.etechplanet.com/blog/how-to-import-an-excel-spreadsheet-in-sharepoint-and-save-it-as-a-custom-list.aspxAndr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 9:06am

Hi André Lage, Thanks for the reply. But i am doing this from a custom webpart.
July 7th, 2011 12:58pm

Give a look what came Out of the box can help you. What is the code for this custom webpart are you following the best pratices? http://msdn.microsoft.com/en-us/library/aa973248(v=office.12).aspx White paper: Working with large lists in Office SharePoint Server 2007 http://technet.microsoft.com/en-us/library/cc262813(office.12).aspxAndr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 1:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics