Cannot retrieve all items from large SharePoint list via Excel data connection

Question

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset of the total number of items. Sometimes, refreshing the data connection will return 4,000 records to Excel. Sometimes it will return 20,000, etc. There doesn't appear to be any consistency in this, so my assumption is there there is some sort of network interruption happening.

Can anyone suggest some troubleshooting methods for this problem? I'm stuck.

Karthik Jaganathan · Accepted Answer · 2013-12-10 05:34:26Z

1

For test purpose, can you please try exporting using the below script, which creates a csv file with the values in SharePoint List.

$MyWeb = Get-SPWeb "http://sitename"
$MyWeb.Lists["ListName"].Items |
     ForEach-Object{
          New-Object PSObject -Property @{
                                          Column1=$_["Column Name in SharePoint"]
                                          Column2=$_["Column Name in SharePoint"]                  
                                         }
     } | Export-Csv -path 'C:\FilePath\Filename.csv'

Source

answered Dec 10, 2013 at 5:34

Karthik Jaganathan

7,8784 gold badges36 silver badges51 bronze badges

Hi, Karthik. Provided that this script retrieves all of the data, I don't see how it would be relevant since it needs to run on the server whereas exporting to Excel is client-side.

bgw
– bgw

2013-12-16 15:02:34 +00:00
Commented Dec 16, 2013 at 15:02

Add a comment |

Stack Exchange Network

Cannot retrieve all items from large SharePoint list via Excel data connection

1 Answer 1

Your Answer

Hot Network Questions

Cannot retrieve all items from large SharePoint list via Excel data connection

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions