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
0
votes
0answers
11 views

creating a file made of different lists and then exporting to Excel

Is it possible to create a list in SharePoint which is made up of multiple different lists and then export them to Excel? So, for example, let's say I have 10 folders and within those folders, I have ...
1
vote
1answer
161 views

Permission Level Use Client Integration Features is not available

I have enabled the Client Integration Features like this: Central Admin > Manage Web applications > Select Web app > Ribbon: Authentication Providers > click Default Zone > Client Integration = "Yes" ...
0
votes
1answer
28 views

How do I move SharePoint Lists including metadata

on sharepoint 2013 on-prem, I would like to migrate a a few lists in the same site collection to a different subsite using powershell. I tried the following commands: Export-SPWeb "SiteURL" -ItemUrl "...
0
votes
2answers
825 views

How to export an Excel sheet automatically from a SharePoint list or library?

We have a SharePoint library on a central location. I would need to know if there is any way to export the Excel sheet automatically (without OOB solution)?
2
votes
1answer
28 views

How to move a document library with item level permissions from one site collection to other site collection?

I have a document library with item level permissions. how to export the complete document library with item level permissions from one site collection to another site collection?
1
vote
3answers
5k views

Export-Spsite but exclude subsites

Is there are way to run the Export-SPSite command without exporting sub-sites? I just want to export the parent site from a web app, but there are about 120 sub-sites in the site collection that I ...
2
votes
2answers
7k 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
575 views

Append to existing text - Exporting to Excel

I have been looking online and can't really seem to find any clear information relating to this so thought I would pick all of your brains. I have a custom list with a multiple lines of text column ...
0
votes
1answer
97 views

Extracting SharePoint data on daily basis

I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as "Dataname_yyyyMMdd". As per my below script, it need to export data from the ...
1
vote
2answers
550 views

extract data from SharePoint document library to CSV using powershell

i am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
1
vote
0answers
124 views

Can't export View Entries in a list to Excel

I have created a Project Tracker list with a custom column called "Status Updates." There will be many entries in this column as a project progresses. When you view the Project Tracker, you see a link ...
0
votes
1answer
594 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 ...
1
vote
1answer
542 views

Exporting a document set

I have a Powershell script that I am using to move SharePoint 2010 Document Sets from one document library to another document library in the same site. The script works fine for most of the document ...
2
votes
1answer
246 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
79 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
85 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
67 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 ...
2
votes
1answer
2k views

Exporting ALL fields and contents in a List to .CSV in Powershell

So I've been trying for the past 4 days now to write a full automated Powershell script that will connect to SharePoint Online, automatically login with credentials (with password located in a file), ...
2
votes
1answer
72 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)?...
0
votes
1answer
354 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. ...
1
vote
0answers
106 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 ...
2
votes
0answers
151 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 ...
1
vote
2answers
144 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). ...
1
vote
0answers
253 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 ...
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 ...
0
votes
1answer
38 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:)
2
votes
5answers
4k 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, ...
6
votes
2answers
318 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
49 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. ...
1
vote
1answer
589 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
327 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
114 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
189 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 -...
1
vote
1answer
406 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
542 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 ...
0
votes
1answer
630 views

In Calendar overlay “Export to Excel” showing blank

Export to Excel not showing any data for Calendar Overlays Page. How can i fix that?
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 ...
1
vote
0answers
32 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
47 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
990 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 -...
2
votes
1answer
241 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 ...
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 ...
1
vote
1answer
95 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
1answer
31 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 ...
2
votes
1answer
189 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/...
1
vote
0answers
197 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
115 views

the best way to export a community site

We need to remove the Sharepoint community site posts which are older than 2 years to free up some space. The old posts need to be exported into some other format (maybe Excel, CSV, html), so that ...
2
votes
1answer
683 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 ...
2
votes
1answer
72 views

Sharepoint 2010 issue with exporting certain combination of columns from a view

so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...
0
votes
1answer
98 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