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

Export Web Page to PDF with css using JavaScript / jQuery

I know that, I'm re-posting this similar question, but the solutions that I found on the internet is not fulfill my need. I need to Export a web page (SharePoint online custom page) to a PDF with ...
0
votes
0answers
12 views

Conversion Sharepoint List or Library Items to Power Point File

I am trying to set up a sharepoint document library where excel files will be uploaded by users. Based on this data, i need to construct a couple of graphs for each collected excel file and insert all ...
0
votes
2answers
31 views

Export data from Sharepoint to excel

I have a little trouble with export data from SharePoint 2010 and Excel, i need get data from a SharePoint list, to do a sum of certain fields that are in the list. I prove the Power Query option for ...
0
votes
0answers
12 views

Exporting SharePoint Online Communication site

I have created a SharePoint site which contain (Lists,Documents..). I want to export this communication site to save it on my desktop for later use. There is any possible way to export the whole site ...
0
votes
1answer
15 views

Deleted? Items show up in Export

I export a list from my sharepoint and items in the excel show up that are not in the list, where are these coming from?
0
votes
1answer
17 views

Items showing up in export that aren't in the list

When I export my list from SharePoint, there are extra items showing up in the excel sheet that are not in the list. Why is this?
1
vote
1answer
34 views

Is there any way of exporting each entry in SharePoint list to PDF/word?

Is there any way of exporting each entry in SharePoint list to PDF/word. A scenario for example is "A SharePoint list contains the list of Participants for an event, I would like to export the each ...
0
votes
0answers
17 views

Is it possible to export a Sharepoint site to a format that another Wiki can use?

I am trying to export from Sharepoint to Confluence. When I use the Get-PnPProvisioningTemplate command I get XML that seems very SharePoint specific. The same can be said for the HTML source of any ...
0
votes
1answer
16 views

Is there a way to export ALL files attached to a SharePoint 2016 list at once?

I want to export all the files that are attached to all list items in SharePoint 2016. Is there a way to do this all at once, or does it have to be done one-by-one?
1
vote
1answer
170 views

How to export SharePoint Online list and import into a new tennant

Is there any way to export SharePoint Online lists and import into an another site? There was an option for that in on-prem installations but I did not find any in SherPoint Online. (I need ...
0
votes
0answers
29 views

Filtered, large list exporting

I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
0
votes
1answer
47 views

Export List of File Names and URLs

Using either Powershell or other method, I need to export a list of titles of files, their filenames with extensions, their locations, and their URLs into a text or Excel file. This is what I have ...
0
votes
2answers
60 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
0
votes
0answers
6 views

export from MsAccess(sharepoint) to Word form

I am looking for some days for a solution for my issue: - i have sharepoint list with more colums ( called "all items") - i have a word form ("format.doc") to complete with information from columns (...
0
votes
0answers
12 views

Export an enterprise wiki page using “Export File” option inside sharepoint designer is not working (the exported file will be empty!)

We have an enterprise wiki site collection inside our sharepoint 2013 enterprise farm. and i want to export some of the wiki pages as PDF or MS Word to send them to one of our customers. so i tried ...
1
vote
1answer
38 views

How to export content of blog posts for future migration?

I would like to export the content of all blogs (excluding personal blogs) in SharePoint 2013 on prems. The purpose of that is to migrate later in a different platform. Is there any out of the box ...
0
votes
0answers
35 views

What is the expected compression ratio for Export-SPWeb?

I have a site that I am attempting to move via the Powershell commands "Export-SPWeb" and "Import-SPWeb". However, I am concerned that the export is not working correctly. In Storage Metrics, the site ...
0
votes
0answers
12 views

Export OneNote page to Word Doc in SharePoint library

Trying to achieve a workflow where initial content would be captured in OneNote. Now I want to build out a document library on the same SP site in which the Notebook is stored. In OneNote Desktop I ...
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
177 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
949 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
32 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?
0
votes
1answer
616 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
103 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
593 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 ...
2
votes
1answer
266 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
84 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
88 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
71 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
412 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
77 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
1k 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
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 ...
1
vote
0answers
255 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 ...
1
vote
2answers
150 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
628 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
39 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
2k 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
844 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 ...
6
votes
2answers
328 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
607 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
333 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
116 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
192 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
420 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
554 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
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 ...