Export of data is the automated or semi-automated output of data sets between different software applications. It involves "translating" from the format used in one application into that used by the other.

learn more… | top users | synonyms

3
votes
3answers
34k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
5
votes
3answers
11k views

How to export a list in SharePoint 2010 and import it into 2013

Is there a good free way of exporting a list in SharePoint 2010 and importing it into 2013. Need to keep structure, data, attachments and other data but revisions, permissions etc not necessary. I'...
3
votes
4answers
9k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
1
vote
3answers
1k views

Exporting SPList

I'm iterating SPWebs and SPLists. When those lists fulfil specific requirements, I would like to export the lists in code, and later import them to another SharePoint environment (using code). How ...
13
votes
2answers
15k views

How can I export a schema.xml file for a list from a SharePoint site?

I've been troubleshooting my schema.xml file for a list definition and getting more and more frustrated. So I thought, "Hey, I'll just get it to look right in the UI and then export that and compare ...
8
votes
5answers
28k views

Is there a way to duplicate or copy a list into the same site

So here is my problem. I have a site collection. In this site I have a list (ListA) that has lots of columns and lots of attachments and lots of items and over the threshold. I would like to create a ...
2
votes
4answers
8k views

SharePoint 2010: What is the difference between backing up a Site Collection and exporting a Site Collection?

Lectori salutem, I am reading into backup and restore operations in SharePoint 2010. I have noticed that in Central Administration > Backup and Restore > Granular Backup there is the possibility to ...
4
votes
2answers
1k views

Exporting sites to a new content database

I have one site collection and it has grown to almost 500GB, i want to move one of our departments to a new site collection. It contains 5 sub-sites and in total about 200GB of content, so the end ...
3
votes
1answer
5k views

export / import spweb problem with DataConnectionLibrary feature

I'm attempting to export a subsite from staging to production using powershell and export-spweb and import-spweb. This worked just fine from staging to development. When we try to run this on ...
1
vote
3answers
2k views

How do I migrate a document library (and just the documents) with PowerShell

I need to migrate the documents of an existing library to a new library. The requirements of the migration is that I maintain versions and audit data (who/when created the document and last modified ...
8
votes
5answers
12k views

Missing export option for SharePoint 2010 webparts

I am trying to export a list view webpart as a .dwp file so I can have a look at the XML. However, the export option is missing. My initial thought was to try something like the this link However, ...
5
votes
2answers
13k views

Permission levels for user exporting list into excelsheet sharepoint 2010

What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
3
votes
3answers
4k views

How long does it take to backup a Sharepoint site

I started a backup at 5pm yesterday evening and it is now 9.15am the following day and the backup is still running. That's over 16 hours! I don't believe the site to be too large, there are 10 sites ...
2
votes
2answers
2k views

Export custom list to excel

I'm using SharePoint 2007. I have created custom-list. The list contains one column from "Person and group" type, show field: E-mail. I fill in data in the list column and export this list to excel ...
2
votes
4answers
3k views

Best way to migrate a site collection from Enterprise to Foundation?

I have a site collection on an Enterprise server that I need to migrate to a server that only has Foundation on it. I have disabled all Enterprise-only features, and attempted a backup and restore, ...
0
votes
3answers
2k views

Identifying duplicate items in a large list (>250000 items)

I have a list with ~250,000 items in it and I know that I've a lot of duplicates which I need to identify then clear out. I don't want to write Server Side code so looking for a imaginative solution. ...
0
votes
5answers
6k views

Export List in SharePoint 2007 to List in SharePoint 2010

I have a SharePoint 2007 list that I want to copy over to an existing SharePoint 2010 list. Both of them have the exact same columns. What is the best way to do this? I tried opening both of them in ...
5
votes
6answers
15k views

How to preserve created/modified/createdby/modifiedby information while copying a subsite / list / library under another site collection?

It seems that with oob tools or using explorer view the modified/created/modifiedby/createdby information gets lost or changed to the time of copying the listitems/documents to another site collection....
4
votes
1answer
4k views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
3
votes
3answers
16k views

Export all the columns from Sharepoint list via Powershell

While exporting the data from Sharepoint via Powershell into a txt/csv file, I started to think, is there a way to choose all of the columns than writing all of the columns down to the code? because ...
3
votes
1answer
2k views

Export a page and import using SP2013 designer. all webpart missed

I am using SP2013 Designer to export a page from site collection A and then import to site collection B. The page contain custom layout and two webparts (search result and refinement panel). Before ...
2
votes
1answer
253 views

Get all documents from subsite with Powershell

I want to get all documents (and only documents) from a site with a Powershellscript and save the result in an .csv I need this because a lot of documents are stored in a bunch of subfolders in the ...
2
votes
1answer
11k views

Copy of same content database running on two web applications

I have a backup of content database (*.bak) file. I have one web application running it now. However I have restored it again under different name on my SQL Server. I would like to create another ...
2
votes
3answers
2k views

Export a joined view

I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it (ideally to Excel)?
2
votes
3answers
2k views

How to export .wsp solution files from SharePoint 2007 Farm

I want to download/export all .wsp solution files from SharePoint 2007 farm in order to deploy them again on new environment. How can i export or download .wsp files? I don't want to extract .wsp ...
1
vote
1answer
1k views

Export to Excel - no data besides column headers

When we try to use the OOB feature of exporting to Excel from a default view in a list, or a view created in the UI, it works as expected. But when we create a new view, using list view web parts, of ...
0
votes
1answer
1k views

Export people and groups from one sharepoint site to another

I have 5 groups with many users in Sharepoint site A. Using SP Content Deployment Wizard tool, I exported site B and imported in site A. Though it has taken all the lists and pages successfully, it ...
0
votes
2answers
4k views

Export-Spsite but exclude subsites

Is there are way to run the Export-SPSite command without exporting sub-sites? I just want to export the parent site from a web app, but there are about 120 sub-sites in the site collection that I ...