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
17 views

SharePoint 2013 - Export site error

I have a problem by exporting a SharePoint Site by using Export-SPWeb on my SharePoint 2013 server. The error code is: Export-SPWeb: These columns don't currently have unique values. Is it ...
7
votes
5answers
25k 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 ...
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 ...
0
votes
0answers
41 views

Export-SPWeb : Object reference not set to an instance of an object

I cannot export a library. This is the command I execute: Export-SPWeb -Identity $sourceUrl -Path $filecmp -ItemUrl "Documenti Condivisi" -Verbose -UseSqlSnapshot -Force with the following ...
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: ...
2
votes
3answers
23 views

Copying sites / site collections with workflows

I have copied a site in order to create a test environment of it in a different web application. The process has finalized without no issues and all the lists, documents, and items are there. ...
0
votes
1answer
18 views

How to migrate a team site with publishing infrastructure enabled under another publishing subsite

We are using SP2013 standard on-premise. There are 2 existing site collection. Both are built with team site template with publishing infrastructure enabled. The URLs are: ...
2
votes
2answers
1k 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
26 views

Are there list view url parameters to export to Excel?

I would like to automatically export a list view to Excel as a single click process. Are there parameters I can add to the list view url that will accomplish this? The list view is currently provided ...
0
votes
2answers
17 views

Export libraries and documents into filesystem preserving fields

I'm exporting some DOCX documents from site and subsites to filesystem, I would like to preserve: the site/library/file structure in the form of subfolder hierarchies fields (latest version, ...
0
votes
3answers
15k 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
1k 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 ...
0
votes
4answers
13k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...
0
votes
1answer
646 views

Export entire folder using SharePoint Designer?

I have a folder that contains many html, js, css and image files. I want to export the folder as a zip or in any possible way as long as it's in a bulk. Right now, the only option that I know of is to ...
0
votes
1answer
739 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
0
votes
2answers
27 views

How can you minimize export time on a large site collection?

I'm attempting to perform triage on a 1.5TB subsite in SP2013. I've reduced content as much as the business unit will allow, and my next step will be to move the site into its own site collection ...
2
votes
1answer
33 views

Export list to Excel - 50'000 limit

We have a user that has a SP2013 list with nearly 100'000 items. In a previous SP2007 environment, they could export the entire list to excel. In SP2013, they are hitting a hard limit in Excel of ...
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 ...
0
votes
1answer
25 views

Best way to pull data from list for .net app

We are fairly new to SharePoint 2013. We need to pull some data from a List Library and use it in a .net application. How is the best way to do this? Examples would be greatly appreciated! Thanks in ...
0
votes
0answers
26 views

New page in Pages Library failing on SharePoint 2013

I have recently migrated a SharePoint 2013 site collection with publishing enabled. After the migration, everything looks fine, except for When user clicks on creating a new articles page in Pages ...
0
votes
0answers
23 views

Expose list or document through ODBC connection

I've seen a few things on Data Connection Libraries and BCS on how to bring content from external databases into SharePoint, but what I am looking for is the other way around. We have a SAP server ...
0
votes
1answer
61 views

How to Export SharePoint 2013 list images to Excel as Image?

I made a list in SharePoint 2013 which contains a picture/hyper link column. The Users need to export the excels but when they do they do not have pictures any more but they have links. I looked after ...
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 ...
0
votes
1answer
35 views

Automatic email Survey statistics in SharePoint 2013

I have made a satisfaction survey in SharePoint 2013. I am asked to get automatic email send every week with graphical summary. Is it possible ? should I use workflow option ?
1
vote
0answers
27 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 ...
0
votes
1answer
30 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
22 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 ...
2
votes
0answers
20 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
22 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
23 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
1answer
24 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
80 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
200 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
65 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
365 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
14k 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
124 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
81 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
32k 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
18k 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
26 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
44 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
345 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
40 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
29 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
273 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
54 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
89 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
60 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 ...