Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
14 views

Search Configuration Export getting Error

While trying to use the "Search Configuration Export" function on the root-site: https://intranet.com/_layouts/15/exportsearchconfiguration.aspx?level=sitecol Of my On-Premise Sharepoint 2016. I get ...
1
vote
1answer
38 views

Exporting item version check in comments

I have followed this answer to extract the list of versions in my document library to excel: However, while the table lists all the versions it only displays (and repeats) the most recent check-in a ...
0
votes
1answer
18 views

Scheduled Automated Data Export SharePoint Online

We are currently migrating our SharePoint 2010 site to SharePoint O365. We have a SharePoint list in our on prem solution that takes part numbers out of our ERP systems database. The users then can ...
1
vote
3answers
46 views

Export data from Excel to an existing list in SharePoint Server 2016

What is the best method in SharePoint to export data from Excel to an existing list in SharePoint Server 2016?
2
votes
0answers
22 views

Private view exported to excel— how can other users refresh the data

My problem is we are not allowed to create a public view that shows all the data since there are a lot of confidential items in that site. In order for me to make all data available in excel, I have ...
0
votes
1answer
24 views

How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?

I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list. ...
2
votes
1answer
18 views

View and/or Export all versions of a SharePoint List

I'm using SharePoint 2016 and need to analyze all the versions of a list. How do I export all the versions into an excel file or access the versions in another way to do some analysis (using PowerBI)?...
4
votes
3answers
156 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 "...
1
vote
0answers
27 views

InfoPath button for Excel export

I want to add a button in InfoPath that will allow me to export the form into Excel. Is this possible? This is a requirement that client needs, and I have no idea how to do it without just saving the ...
0
votes
0answers
10 views

SharePoint OnLine - Export all Versions

I have a SharePoint List that I am using with Minor and Major Versions, check in and check out applied, and content approval. Please can you give me advise on how to view the list with only major ...
0
votes
0answers
14 views

O365 site export as CMP

We are looking into creating a bunch of sites in Sharepoint Online (O365) but there seems to be no straightforward way to export a site or a site collection so it could be re-imported on another ...
0
votes
0answers
21 views

Export to PDF with Cross site content

I want to export my sharepoint list data into PDF form. I have entered data of following link in multi line text field in my list link: Wiki Pedia content Same data I'm displaying in my page using ...
1
vote
0answers
121 views

PowerShell to Export Sites and Subsides with security groups

I'm attempting to come up with a powershell script that would allow me to export a list of sites and subsides and the permission groups there in to a CSV. I'm familiar with using the cmdlts but not ...
0
votes
0answers
74 views

Content Export stuck on “Operation Initializing”

I'm trying to export a document library from SharePoint 2013 on-prem. After I start the export via Central Admin, the Granular Backup Job Status shows "Operation initializing" hours later. I can't ...
1
vote
2answers
58 views

Export/import SPWeb to rootweb of new SPSite results in empty + missing groups

We exported a SubSite using Export-SPWeb with IncludeUserSecurity and versions. Subsequently we imported the export to the root of a newly created SiteCollection on the same WebApp (SharePoint 2016). ...
0
votes
1answer
173 views

Choice field data contains # when exported to excel

I have a choice field(checkbox, multiple values) in a SharePoint List. In SharePoint values are displayed as Choice1, Choice2. When exported to Excel the format used in Excel is Choice1,#Choice2 I ...
0
votes
1answer
30 views

How to migrate 1000 list items from List1 in Site1 to List2 in Site2 Using Powershell

I'm using Microsoft.SharePoint.Deployment.SPExportSettings/SPImportSettings class to migrate 1 listitem successfully. But I need to migrate only 1000 listitems. Thanks in Advance:)
0
votes
1answer
681 views

Export Sharepoint List to MS SQL Database

We would like to export our SharePoint Content to MS SQL Database. Do you please know about any tool that allow so? The purpose of this is to use MS SQL DB in our reporting tool which is easier and ...
0
votes
3answers
218 views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
5
votes
2answers
217 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 ...
1
vote
1answer
41 views

Are there any risks or drawbacks if i Import the same Pages library inside 2 site collections

I have 2 farms which are of type sharepoint 2013 on-premises 2013 enterprise. and inside FarmA i have a wiki pages library which contain many wiki pages for policies and procedures for IT departments. ...
0
votes
1answer
237 views

SharePoint - Powershell - Export Rich Text content to CSV

Below is my code to export rich text content to a .CSV file. The content comes from a SharePoint list. I am using CAML to fetch the content and adding it to $Content. This code exports the data but ...
0
votes
1answer
99 views

SharePoint 2007 Export list to excel - 'person or group' column as domain\username

I have SharePoint 2007 list that has 'person or group' field, lets call it employee. When I export this list to excel, I get the column values as display name 'firstname + lastname (Joe Blog), what I ...
0
votes
1answer
46 views

When Importing a list which contain Managed Metadata columns will associate the Managed Metadata columns with the related term group

I am facing this inconsistency inside my sharepoint 2013 on-premises farms, when Importing a Pages library inside different farms. as follow:- Now i have 3 farms. our live serve + our test server + ...
0
votes
1answer
119 views

Is there a way to only Export certain wiki pages inside a Pages library using the Export-SPWeb

I usually export list and libraries using the following command:- Export-SPWeb -Identity "http://frontend2/commercial/" -ItemUrl "Pages" -Path "c:\exportfile.cmp" -nofilecompression -...
0
votes
0answers
54 views

Export/Import my Pages library from one farm to another. can not have it worked 100% correctly

I have two sharepoint on-premises farms 2013. as follow:- on FarmA i have an enterprise wiki site collection, with around 300 wiki pages created. on FarmB i created a new enterprise wike site ...
1
vote
1answer
95 views

Export-SPWeb - Fails after a few minutes / Turn Sub Site into Site Collection

We have an Intranet SharePoint 2013 farm with 4 servers (2x WFE, 2x APP). Within our Intranet we have a 'Video Center' (~37GB) which at this point unfortunately is a sub-site. We want to turn it into ...
1
vote
1answer
292 views

Export sharepoint list with lookup values using powershell

I need to export the SharePoint list in CSV format for which I am using following code. It works fine except the "Project Name" Field which gives "microsoft.sharepoint.client.fieldlookupvalue" output ...
4
votes
0answers
42 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 ...
1
vote
0answers
26 views

Export then Import a list between 2 farms, when there are users who are no longer exists inside Active directory

I have 2 sharepoint on-premises farms 2013, which are inside the same domain (are integrated with the same Active directory and users), as follow:- FarmA which is an old farm, and it contain a lot of ...
2
votes
1answer
37 views

SharePoint Online - Search results from exported custom list don't match the results from the list quick search box

I've been trying to find an answer, but no luck on this issue yet - For reference, we use SharePoint Online (G3). We have a custom list that serves as a complaint tracking log. When we use the built-...
2
votes
1answer
148 views

Sharepoint 2013 - Export Excel with external lists

I can't export to excel from external lists. The button is disabled in the ribbon. It works fine for other lists on the same site with the same user, but for external it is disabled. Is there a ...
2
votes
1answer
362 views

Import-SPWeb can not find my .cmp folder

I have exported a document library from Farm A as follow:- Export-SPWeb -Identity "http://famrA/***" -ItemUrl "Our Library" -Path "c:\16.cmp" -nofilecompression -IncludeVersions All -...
6
votes
1answer
128 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 ...
1
vote
1answer
81 views

Requirements and effect of Export/Import lists and documents from one farm to another

I want to export a list from one farm and import it inside another farm. using these commands:- Export-SPWeb -Identity "http://****/subsitename/" -ItemUrl "Sales" -Path "c:\export4.cmp" Import-SPWeb ...
0
votes
0answers
115 views

Missing web parts in a new site created from template + sharepoint 2013

Anyone know what can be the reasons because Web Part doesn't load when i create a subsite from a template? We have a custom site, then I export it but when, i create a site from that template, the ...
0
votes
1answer
30 views

Export form with domain name association to new SharePoint site

I have a form on SharePoint 2010 that I would like to transfer over to SP2016. In 2010 we currently have over 300 forms filled out. They all have a domain name associated with them. How do I go about ...
1
vote
0answers
141 views

Export to excel - document library

Is it possible to download an excel or csv (both options necessary) file instead of query.iqy file out of sharepoint online? - document library
2
votes
1answer
391 views

Multi-line text box Bullet points

I have some multi line text boxes in custom lists I have developed. These are rich text to allow the users to format the text such as changing the font colour. The list is then exported to excel and a ...
1
vote
0answers
140 views

Export all items of a content type across a site collection into Excel

I have a custom content type based on the default task content type with a couple of additional columns. Within my site collection I have a number of sub sites which all inherit this content type. I ...
2
votes
1answer
117 views

Export document library. Are content types included?

We need to recreate a site from scratch, however we need to keep the data in some document libraries and custom lists. Therefore, we study the possibility of doing and export-import of the libraries/...
0
votes
1answer
59 views

On exporting SharePoint 2010 to Excel File Unable to export the Date Modified Column

On Exporting SharePoint Document Library to excel file able to export all the columns except the Modified date column
0
votes
1answer
50 views

Lost “edit item” form after exporting to excel

When I export a list from a SharePoint site to Excel and then import this list to another site, the list content is untouched, but all columns change to "single line of text" only. It is a problem ...
2
votes
1answer
95 views

Audience Targeting web part property missing while exporting the content search web part?

I customized the CSWP then I exported that web part, After Exporting the CSWP web part the Audience targeting property is missing Which is from the Advanced section. I am not sure why that property is ...
0
votes
1answer
82 views

Trying to export a list with “stsadm -o export” throws “Invalid high surrogate character”

I am trying to export a Sharepoint list with forlders with the next commands: Export-SPWeb -Identity https://webapurl.com -ItemUrl /Lists/ListName/ -Path D:/Folder/file.cmp -IncludeVersions All or ...
1
vote
2answers
403 views

Error when exporting list to Excel by clicking Export to Excel

I'm trying to export a list by clicking "Export to Excel" in the List ribbon on Internet Explorer 10. I am getting error: "To export a list, you must have a Microsoft SharePoint Foundation-...
1
vote
0answers
68 views

Exporting and importing promoted results in SharePoint 2013

We have a SharePoint search site collection I want to export our promoted results (query rules.) Does anyone have a script to do this?
2
votes
2answers
1k views

How to populate sharepoint list with excel data?

I have a excel sheet whose columns and my sharepoint list columns are same. But when i try to export from excel this doesn't works. I have some specific column types which cant be altered because i ...
1
vote
1answer
2k views

Disable Export To Excel Option (Lists, Sharepoint Online)

How can be "Export to Excel" button (or option) disabled within lists in SharePoint Online? I have tried disabling "Use Client Integration Features" in the definition of the permission level, but the ...
0
votes
0answers
437 views

exporting a sharepoint web pages content to pdf?

I want a button in a SharePoint page and on the click of the button I want to export some div to pdf? please, guys, tell me how this is possible? I tried with jspdf library but it's not working in my ...