Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [export]

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.

Filter by
Sorted by
Tagged with
16
votes
2answers
23k 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 ...
13
votes
6answers
74k 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 ...
11
votes
5answers
16k 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, ...
10
votes
3answers
24k views

Move list from root site to subsite

We accidentally created a few lists at the root of our SharePoint 2010 site and need to move them to a subsite. How do you do this? We tried exporting as a template, but then the list became a library ...
10
votes
1answer
3k views

The remote server returned an error: (403) Forbidden when accessing office365 site through external APIs

We have built a desktop app that import/exports SharePoint lists into/from Office 365 sites. The app works perfectly, and we were able to do the import/export of Office 365 site pages for many clients ...
8
votes
3answers
21k views

How to export a site from SharePoint online?

I've got a publishing site (root site, with subsites) containing web pages and documents (as do the subsites). I'd like to export it and restore it to a local SharePoint instance - any ideas how to ...
8
votes
2answers
555 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
8
votes
3answers
2k views

Export table of all versions of list items

Using SharePoint 2007, and I only have client-side access. I can view all versions of each item in a list by using the IncludeVersions parameter as follows: http://wss/XYZ/sites/SomeSPSite/ThisList/...
7
votes
2answers
23k 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?
7
votes
1answer
149 views

Are there any risks of doing an Export/Import for a document library between 2 farms, where these 2 farms have different farm build numbers

I have two farms which are sharepoint on-premises 2013, that have the same license type which is "SharePoint Server with Enterprise Client Access License" license. but the farms' build numbers are ...
7
votes
2answers
7k views

Export a page with web parts and import to another site

I have a web page in the documents library configured in a certain way with all the web parts set up. I created this on a test team site. How can I export this page to a production team site?
7
votes
1answer
5k views

Is it possible to export a site workflow?

If I have a Site Workflow on my development machine, what's the best way to deploy it onto the production system which is hosted on Microsoft SharePoint Online? I have found a way of doing it which ...
6
votes
2answers
58k 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 ...
6
votes
2answers
320 views

Migrating our SharePoint 2013 on-premises farm to an Office 365

I have worked on many SharePoint 2013 & SharePoint 2016 on-premises farms. and currently one of our customer who uses SP 2013 on-premises, want to migrate SharePoint to Office 365 (SP online). now ...
6
votes
3answers
16k 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'...
5
votes
4answers
10k 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 ...
5
votes
6answers
20k 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....
5
votes
3answers
22k views

Move site between site collections

I have a sharepoint 2010 environment with a site collection with many subsites. I want to re-structure the sites in the site collection into multiple site collections i.e. I want to move a site from ...
5
votes
3answers
29k 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 ...
5
votes
2answers
11k 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 ...
4
votes
2answers
2k 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 ...
4
votes
5answers
11k views

Unable to find the export web part option

So I am in the process of trying to create and 'package' web parts for a client. Basically what this entails is taking a 'Content Search' web part, edit the query, edit the properties, and add the ...
4
votes
3answers
23k views

How can I export all attachments from a SharePoint 2010 list without code?

Is there any solution in exporting all the attachments from a list without code? I do not have Visual Studio installed on my machine and am looking for a way to just grab all the attachments and place ...
4
votes
1answer
1k views

Import throws “Could not load file or assembly”

We've exported a web site on SP2010 using this command: Export-SPWeb -Identity http://vmdev95/ -Path \\vmdev95\sp_backup\acm -NoFileCompression -HaltOnError -HaltOnWarning -IncludeUserSecurity Then ...
4
votes
1answer
6k 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 ...
4
votes
1answer
5k views

Add columns to export to Excel in Survey list

The survey list is always left of centre to other lists. I am using SharePoint 2007. I have recently been asked to include other columns when exporting a survey to excel (the modified field). The ...
4
votes
3answers
2k views

Export Import Library with Lookup column

I did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site. After exporting main library and all dependecie ...
4
votes
1answer
4k 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 ...
4
votes
3answers
1k views

Move specific folder in a document library

UPDATE 1: I have the following script, but it's not working correctly: Add-PSSnapin Microsoft.SharePoint.PowerShell #input = https://sharepoint.oshirowanen.com/sites/oshdev $websiteurl = read-host "...
4
votes
0answers
44 views

Fail of export of unchanged view due to unexpected error reported by Excel

A view, which has several times successfully been exported to Excel suddenly fails due to unexpected error reported by Excel. Creating a new view omitting some fields solves the problem, however ...
4
votes
1answer
450 views

Exporting a list with lookup fields

I'm in a situation where I need to export 2 lists from site Site A to Site B. The lists I'm exporting have a lookup relation. List X has a lookup to List Y. List Y gets imported to the new location ...
3
votes
3answers
6k 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 ...
3
votes
1answer
7k views

How can I export to file the User Information List for a site collection?

I would like to export the User Information List to a file including the ID of each user. It doesn't matter if the solution is in C#/PowerShell/SharePoint UI.
3
votes
3answers
5k 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 ...
3
votes
3answers
13k views

create button that export custom list to excel file

I'm using sharepoint 2007, custom list. from the datasheet view I can export the list into excel/access file. is it possible to create a button that proposes to export the list to excel. (in order to ...
3
votes
2answers
7k views

Export-spweb / Import-spweb leaves the lookup columns empty

The export / import operations seems to be working quite well except for lookup columns. The lookup columns and other columns associated with the lookup are all empty. Is this a limitation? Is there ...
3
votes
4answers
15k 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 ...
3
votes
8answers
31k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
3
votes
2answers
736 views

Content Deployment and Migration API not importing no error thrown

The following http://blogs.technet.com/b/stefan_gossner/archive/2007/08/30/deep-dive-into-the-sharepoint-content-deployment-and-migration-api-part-4.aspx provides the follwoinf code to import and ...
3
votes
1answer
3k views

Move an Item between lists maintaining version history

I wish to move/cut a item from list in SharePoint to another list. I can copy the item across to a list and delete the original. Sadly version history is lost. I want a way to be able to copy an item ...
3
votes
3answers
3k views

How can I use Powershell to move a list from a development to a production Sharepoint 2010 box?

I'd like to copy a list (and its contents) onto our production server. I've been trying to use the Export-SPWeb cmdlet, using this article as a reference, but I can't seem to get it to cooperate. I've ...
3
votes
1answer
5k views

Powershell script to get all Sharepoint user id and user login

I am importing data into a SharePoint list. One of the columns is the user's login/name which links to their profile via their SharePoint user id. FARMURL/userdisp.aspx?ID=56 In order to import ...
3
votes
1answer
327 views

Migrate from 2007 to 2010 without access to database

one of our customers has a sharepoint 2007 environment in a shared environment. Now they want us to move there sharepoint to 2010 on another server in another domain. Because i'm not very ...
3
votes
1answer
4k views

Export list to Word

Is there a way to easily export a list to Microsoft Word 2010 from SharePoint 2010 via a button on the page? We'd like to have the data plugged into a Word template so the list values get formatted/...
3
votes
3answers
4k views

Sharepoint 2010 how to export item URL to Excel?

I have a list of 8 items in SharePoint 2010 and I export them to Excel. How can I export item's URL so that when clicking the link on Excel spreadsheet, it can bring me back to the item in ...
3
votes
1answer
2k views

Exporting the Organizational Chart

Is there a way to export the organizational chart located in the mysites to excel or another program?
3
votes
2answers
3k views

Move documents from SharePoint 2007 to SharePoint 2010

I have an old sharepoint site containing around 50 document libraries with subfolders and files. No these document libraries should be moved to a new SharePoint 2010 site. I've tried this using the ...
3
votes
1answer
177 views

Export Enterprise Search from SP2010Server to SP2010Server

Is there a way to export Enterprise Search settings(Scope, managed properties, etc...) from one SP2010 server to another? For example from a Development server to a Production Server.
3
votes
2answers
190 views

Is there a way to detect if a content deployment is ready?

I need to detect if a content deployment between two different sharepoint 2010 farms is finished. Is there a way to achieve this programmatically? I've been looking around for some days now but ...
3
votes
3answers
2k views

Object Reference Not Set Error in SPImport.Run()

I'm trying to move my site from a server to another. I exported my site using Export-SPWeb, moved the data to destination server and ran the function below: (Taken from here.) function import-spweb($...