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
2answers
13 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 ...
1
vote
2answers
771 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 ...
0
votes
0answers
10 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 ...
1
vote
2answers
588 views

Export/Import Large SharePoint 2013 Site

I want to export a large subsite (about 80 GB) and import as a site collection. I'm using Export-SPWeb such operations and it is working perfect on small sites, but in this large site it didn't work ...
13
votes
6answers
73k 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
722 views

List view threshold exceeded: How to export List to Excel

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
1answer
884 views

Export to Excel only exports a few columns - SharePoint 2013

I created a survey with over 70 questions. The defualt view "All Responses" has the option to export a spreadsheet. When I created a new view with the initial view sorted, only about 7 columns are ...
0
votes
2answers
769 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
2answers
1k views

How to push an export from SP List to Sql Server

I would like to export a Sharepoint 2013 Standard list to a Sql Server table regulary without the need of SSIS. In best case they should stay in sync (with some latency of course) but it's just needed ...
2
votes
2answers
1k views

hosting an iqy file on a sharepoint

I want to export a list from sharepoint into excel. I can do this export easy with an iqy file. Once I have this iqy file (which by default is saved in my temporary area but I will save it to my ...
2
votes
2answers
3k 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
1answer
614 views

Export SharePoint List to Excel with Images and not their URL

I have created a 2013 SharePoint List and need to be able to export / report on it using Excel (or any other output format). However, we have Excel 2010 and the current post below looks very ...
1
vote
1answer
952 views

how to export workflow template in sharepoint designer 2013?

We have one test site in my environment workflows is deployed in that site and those workflows are saved as "Save As Template". We want to add those save as template to another site. Give me ...
0
votes
1answer
1k views

SP2013 Export-SPWeb and Import-SPWeb preserve meta data

I want to move a list / library from one site collection to another. I tried to use Export-SPWeb and Import-SPWeb PowerShell commands, however the imported list items doesn't not preserve metadata ...
3
votes
1answer
1k views

Export to excel missing data

When I export a custom list to excel, some of the data in one particular column does not show up. I have a "comments history" column that is created by workflow. Whenever a user enters a new comment,...
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
15 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
2answers
959 views

Export-SPWeb error list template not installed

I am getting below error I am trying to export from sharepoint 2010 foundation server. Is there anyway I can ignore these kind of errors and export simply? PS C:\> Export-SPWeb -Identity http://...
1
vote
1answer
1k views

Export all Site Collection Usage Reports in one click

My manager wants me to export the every Excel and PDF file from the Site Collection Usage Reports every month. Is there a way to download or export the data in one click?
0
votes
1answer
626 views

Add Title field after import from Access

I was imported some list from ms asscess table and I see that dosn't create Title field and user cant watch list item on click in record. How I can fix that without created simular list and transfer ...
8
votes
3answers
2k 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: http://wss/XYZ/sites/SomeSPSite/ThisList/...
10
votes
1answer
3k 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 clients ...
1
vote
2answers
3k 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
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 ...
2
votes
1answer
2k 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 52'...
2
votes
2answers
2k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
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 "...
3
votes
1answer
2k views

export to excel 2016 from sharepoint 2013 custom list in windows 10 using IE 11

I have windows 10 os on my machine and I am trying to export sharepoint 2013 custom list in excel 2016 using IE 11 but it shows me below error: "cannot connect to the server at this time.Changes to ...
1
vote
1answer
1k 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 ...
2
votes
1answer
2k 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 ...
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 ...
1
vote
1answer
634 views

Exporting InfoPath directly to a Word document

I am not a programmer! The company I work for has been developing a CRM and quoting program using SharePoint and InfoPath. I have been struggling because I am familiar and successful with quoting ...
0
votes
2answers
967 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 ...
0
votes
3answers
765 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 ...
1
vote
1answer
736 views

miiskmu export: no access to the MIIS database

I am trying to export my encryption key for the 'User Profile service' application in SharePoint 2010 but I keep getting the following error: 'The credentials do not have access to the MIIS database' ...
1
vote
1answer
706 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 ...
5
votes
2answers
11k 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
0answers
16 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
122 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
26 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
39 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 ...
1
vote
6answers
4k 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 isn'...
0
votes
2answers
48 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 ...
2
votes
6answers
75k 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 ...
1
vote
1answer
36 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
31 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 ...