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

0
votes
1answer
1k views

Export subsite and Import in another web app (means another db)

I have one web application with site collections. Then I have a subsite inside. I want to export this subsite (and only this one), and import it in a new web app I will create. Question is : Is this ...
2
votes
2answers
861 views

How to get my deleted columns back in an Excel file, that were exported from SharePoint lists

I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I ...
0
votes
1answer
1k views

Export SharePoint list to Excel - How remove column Item Type and Path

When I export a SharePoint list to Excel using the built-in functionality, it also exports two columns called Item Type and Path. Is there a way OOTB or programatically to exclude these columns from ...
1
vote
0answers
14 views

Import-SPWeb not importing Custom Person / Group Column Values

I have a SharePoint 2013 Multi-Tenant farm configured to use FBA. I tried exporting a site in one of the site collections of the tenant using Export-SPWeb. I did include the option ...
6
votes
2answers
1k 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: ...
0
votes
1answer
18 views

how can I export List content to Excel when list view exceeds list view threshhold

users are used to export the list content using "export in excel" functionality, but now I'm reaching my list view threshold and would like to prepare my solution to be able to export the list content ...
1
vote
0answers
16 views

Need to export a publishing page programmatically including layout and images

I have a client requirement in which content on a publishing page is extracted and sent to a translator for translation. The client would like the translator to see what the page looks like in order ...
0
votes
1answer
913 views

Slow Query Execution in Export Site

I have a site that contains several lists with look up columns also. One of the lists contains > 800000 items in it. and when I try to Export the Site, Site gets locked and Export gets hung. After ...
2
votes
0answers
15 views

Sharepoint to WordPress migration - Public Site

What are my options for export content of public site from SharePoint db into usable form for WordPress? I found some tools, but i would rather hear expirienced advice from someone who already done ...
0
votes
0answers
13 views

Missing Recommendations Displayed and Recommendations Clicked in Usage Reports

My SharePoint 2013 is up and running for 4 months. When I click on Site settings -> Popularity and Search Reports -> Usage. The report has "Views" sheet only. And I wonder where are the ...
1
vote
0answers
21 views

Speed up indexing a column when rows > 5000

I've got a large list (>75,000 items, 41 columns) and therefore have to follow all the rules for handling large lists. If a new column needs to be filtered on (and therefore needs to be indexed) ...
0
votes
3answers
13k views

Exporting SharePoint Members into Excel

Is there a proper way to export a group of sp group members into excel? I have been able to select a group from permissions and export them into excel. The problem I face was that even when I ...
0
votes
1answer
22 views

Network Error when export zip file

I implement a function to allow users to download multiple selected files as one zip file. I use Ionic.Zip library for this function. On my local machine, there is no problem, works well on Firefox, ...
1
vote
1answer
43 views

Export and Import a Site Page using PowerShell

I am familiar with how to export/import a site using PS. My question is, is it possible to do the same operation with a Site Page? For example, SiteA/default.aspx contains 2 Site Pages called ToDoList ...
1
vote
2answers
66 views

How to use PowerShell script to copy document library with meta data to other site collection?

I need to migrate a document library includings all its documents and all meta data to another site collection. I did some research and quickly found a script that would seem to do the job, see source ...
2
votes
2answers
60 views

Export a custom Document Library using PowerShell

I would like to know how to export a document library (SharePoint 2010) using PowerShell and also saving metadata about content. I need to repopulate the document library with items coming from ...
5
votes
0answers
173 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 ...
5
votes
6answers
13k 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 ...
5
votes
2answers
88 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?
2
votes
1answer
48 views

how to export in csv format instead of .iqy

By default export to spreadsheet showing owssvr.iqy , we need to have owssvr.csv Please help.
3
votes
3answers
31k 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 ...
2
votes
6answers
16k 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 ...
0
votes
1answer
21 views

Export to CSV on custom application results in that nothing works on the page anymore

i have a simple custom application which fetches records from a lists by a caml query and through an export button the user is able to get a csv file with the data. Generally the export works fine. ...
0
votes
0answers
33 views

function to export mappings and crawled / managed properties

I’m running this script I found on sharepointspace.com. http://andersrask.sharepointspace.com/Lists/Posts/Post.aspx?ID=36 Why am I receiving the following error below? .\FuncRunExportSPESMM.ps1 ...
7
votes
2answers
321 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"); ...
0
votes
1answer
30 views

SPListItemCollection.GetDataTable() , For choice fields its adding extra string “;#” in the datatable

SPListItemCollection collListItems = list.GetItems(query); dataTable = collListItems.GetDataTable(); I am using above for getting listitemcollection into datatable. In the list I have choice ...
0
votes
0answers
24 views

How to email csv file to Owners group using powershell

I have a script that exports data to a csv file listed below: $url = "http://portal.contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($url) $web = $site.OpenWeb() $list = $web.Lists ...
0
votes
1answer
205 views

Export(or map) List data to external MSSQL table

There are many references about External Lists, where you make a Sharepoint list from SQL database table. In my case, I need to do the opposite - I have SharePoint list, and I want to map it to an ...
0
votes
0answers
41 views

Export to excel not showing all rows

We have a very large list and a user is exporting a filtered view to Excel, the view has 18,000 items, give or take, and he is only getting 16,000 items exactly I want to know if it is a problem with ...
1
vote
5answers
2k views

How to export List settings

I have several lists in my SharePoint 2010 and I'm seeking how to export the list settings - mainly the columns name and type (e.g. Name which is single line of text). How can I do this? (this ...
0
votes
0answers
63 views

export specific columns/fields of list to Excell and not the whole list. How?

End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns. I've created "another ...
2
votes
1answer
42 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 ...
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 ...
2
votes
1answer
129 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 ...
0
votes
0answers
61 views

A question about relative URLs during site collection export

I plan on exporting a large sub-site into a separate site collection, one that has its own content database. Currently I'm using relative URLs where possible. As far as I know, a relative URL begins ...
0
votes
1answer
45 views

How to export all list data from Web Scope to an excel file?

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked ...
1
vote
1answer
25 views

Error while importing Sharepoint site in SP 2010

I am trying to export a Sharepoint site from one environment to another. The steps I followed are as below created the site collection with web application from Sharepoint central admin in the new ...
1
vote
2answers
50 views

Can I extract a Solution (WSP File) from my site level?

We have a Feature located on one of our SharePoint sites how can I export this feature (wsp) so that I can import it into another site?
0
votes
1answer
203 views

Export SharePoint Search results to Microsoft Excel

I need a functionality to export search results to Excel for SharePoint. I've researched a lot and found many answers though no blog provides end to end solution. Best I could find is: Catch search ...
1
vote
2answers
119 views

Using Export to excel in list which has exceeded threshold limit

I have a requirement to export all items to excel in a list which has exceeded the threshold limit. I've already tried using power query but since I have some null values in people picker fields in my ...
1
vote
1answer
12 views

Excel Service Not Work after Import an Exported Application

my Excel service is not working.My Excels opening in my Client MSExcel but not open in Browser.its happen after after my application has problem and I have to Export and import again to work ...
2
votes
2answers
6k 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.
0
votes
1answer
58 views

SharePoint Online to FTP

Is it possible to export documents or other content from SharePoint online using a workflow (or other method) to an external location? The recipient will likely be an ftp location, and won't be an ...
1
vote
0answers
44 views

Export users from User Profile

Is there a way to export all user profiles from SP using something other than powershell? I need a list of all synchronized users from SharePoint.
4
votes
1answer
3k 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 ...
0
votes
2answers
137 views

How export list in excel file

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error: Error List does not exist. The page you selected contains a list that does ...
0
votes
1answer
468 views

What is the best practice to move/copy termset from global to local?

I am using sharepoint 2010. I have 1 webapplication with many site collections. In one of my site collection I have some specific site with a list with a managed metadata column. I have setup this ...
0
votes
1answer
28 views

Transfering Data from Calendar to New Calendar

I have a calendar in SharePoint 2013 and created a new calendar but I would like to have the data from the old calendar in the new calendar. One solution I thought of was exporting the information ...
0
votes
1answer
96 views

How to export sharepoint management scripts' result to csv/text file

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null function EnumerateUserRolesPermissions ([string]$webURL){ $site = new-object ...
0
votes
1answer
22 views

Surveys with Export to Excel option

How do I ensure that once I create a survey in SP 2010 that I'm able to export the resposes to Excel?