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