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

7
votes
2answers
9k 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 ...
7
votes
3answers
6k 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 ...
5
votes
5answers
8k 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 ...
4
votes
3answers
12k 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 ...
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 ...
4
votes
3answers
8k 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 ...
4
votes
2answers
7k 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?
4
votes
1answer
987 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
3answers
5k 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. ...
4
votes
1answer
1k 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 ...
4
votes
0answers
51 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"); ...
3
votes
3answers
3k 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
3answers
19k 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 ...
3
votes
4answers
5k 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
1answer
3k 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
2answers
496 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
300 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
2k 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 ...
3
votes
3answers
1k 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 ...
3
votes
2answers
2k 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
3k 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 ...
3
votes
1answer
61 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
149 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
1answer
381 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 ...
2
votes
4answers
5k 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 ...
2
votes
1answer
3k 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.
2
votes
2answers
1k views

Powershell backup/restore or import/export to keep all document versions?

I need to move a test SharePoint 2010 site collection and database to a new server (and new database). I want to make sure that I keep user security and all document versions. Does backup/restore keep ...
2
votes
3answers
7k 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 ...
2
votes
2answers
304 views

How best to export objects to prodution from test

We're trying to move some of the objects we've created on our test environment to production SharePoint 2010 Server. These include custom lists, custom content types, site columns, sites, images, ...
2
votes
4answers
2k 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, ...
2
votes
1answer
514 views

How to export entire FBA users database to Excel?

I have migrated from WSS 3.0 to SharePoint 2010 and we use FBA. I need to export the entire user database to Excel. I need to know how to do it?
2
votes
2answers
1k views

Sharepoint Page - Add button for exporting a list on the page to excel

There was a similar question but all of the answers did not seem to answer the question. I am using sharepoint 2010 and I have created a Custome Page that includes a webpart of a list from the ...
2
votes
3answers
2k views

Stsadm - Avoid subsites while exporting a site

I am exporting a site using stsadm command. It is automatically exporting the subsites too. I need to take the current site only, how can I restrict the subsites? For example I'm exporting the site, ...
2
votes
2answers
2k 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 ...
2
votes
2answers
565 views

Powershell script to schedule daily backup of Sharepoint Sites and Subsites?

I have one site collection at root level and which contains more than 50 subsites. I am planning to schedule a daily job to take the backup of sharepoint subsites. I also want to check the size of the ...
2
votes
1answer
642 views

Exporting the Organizational Chart

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

SharePoint List Export to Excel All Columns!

As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
2
votes
1answer
7k 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
1answer
374 views

Export Large Lists from SharePoint 2007 C#

I want to create a application to export Large Lists to csv in 2007 where the threshold is 2000 items. What is the best approach? i need to export 1.000.000 items in the end. I know when you delete ...
2
votes
4answers
6k 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 following link: ...
2
votes
1answer
88 views

Unable to export all the data from Share Point list

In my Share Point list has 23072 records, but I am able to exports only 2000 records. It has multivalued, Lookup, Yes/No & Calculated type columns and around 64 columns are there. Any ideas, How ...
2
votes
1answer
45 views

how do i publish a chart built in bis to another sharepoint site

I have been playing around with creating dashboards and charts using Performance Point services in the Dashboard Designer. I got the documentation on how to create them and built a couple in my BI ...
2
votes
1answer
149 views

Most effiecient method of checking/veryfing identical/missing content between 2007 and 2010?

We are currently migrating from sharepoint 2007 to 2010 on a dozen servers, due to technical reasons we cannot employ the usual methods and instead we are using the webservices and requests to ...
2
votes
1answer
689 views

Document Library containing Managed Metadata when exported to Excel has weird characters

We have document library for storing assets in it. Document Library contains some of Managed Metadata lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the ...
2
votes
1answer
1k 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 ...
2
votes
1answer
1k views

How to import a library from Export-SPWeb outputs?

I am trying to understand how to restore an arbitrary library to an arbitrary site in an arbitary site collection - inspired by some future user announcing he accidentally deleted a document from the ...
2
votes
3answers
1k 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
1answer
808 views

Exporting Workflow (and not to Visio)

Have you ever designed a workflow in SharePoint Designer? If so, then you'll know what they look like in SharePoint Designer. I am looking for a way to export my worflow. Not to Visio either. I ...
2
votes
2answers
2k views

Can I export a list from SharePoint 2007 and then import to SharePoint 2010?

I have a user that has requested we copy her Shared Documents library from SharePoint 2007 team site to an existing SharePoint 2010 team site. Can this be accomplished with OOB STSADM export/import ...
2
votes
1answer
379 views

Using the Content Deployment API, how to delete items from destination?

Inside a custom developed timer job, we're doing a selective list migration between an internal and external farm based on list item attributes, e.g. only copy to external if "Is Public" is checked. ...