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.

128 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
8
votes
2answers
555 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"); ...
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/...
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 "...
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 ...
4
votes
1answer
449 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 ...
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,...
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 ...
3
votes
0answers
296 views

Apply filters to a list view placed on a page as webpart based on loggeed in user, also how to export the current view to excel

Given below my scenario, I have a list named User Configuration which stores user and country detail User (People or group field) | Country (Dropdown choice field) ---------------------------------...
2
votes
1answer
29 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?
2
votes
0answers
68 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
74 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)?...
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 ...
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 ...
2
votes
0answers
22 views

Old modifications appears when importing my site template

Environment : SharePoint 2010 Foundation Actually I want to import my site from a site collection (named SC1) to another one (named SC2). What I do : Export my site as a template Download the ...
2
votes
0answers
115 views

SharePoint Online Export Managed properties

Is there a way to access all managed properties in your search schema. The only option i did find was to export search configuration, but doesn't seems to take the managed properties with it? Does ...
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
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 ...
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
0answers
216 views

Display Site Collection Web Analytics Report from multiple site collections on a page

I have a requirement to display the Site Collection Web Analytics reports for several site collections in one place. How can I do this, as it seems SharePoint doesn't allow for much in the way of ...
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 ...
2
votes
0answers
121 views

Move Sharepoint Site and Maintain Word Document Hyperlinks

My client currently has a Sharepoint site that they need to move to a completely different server. This site has quite a few pages, and also several Word documents that have embedded hyperlinks to ...
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 ...
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 ...
1
vote
1answer
164 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" ...
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
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 ...
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 ...
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
1
vote
0answers
177 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 ...
1
vote
0answers
172 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?
1
vote
1answer
636 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 ...
1
vote
0answers
2k views

SharePoint List - Export to Excel only downloads owssvr.dll not .iqy

Office 2016 SharePoint 2013 For any SharePoint list, when I click on the 'Export to Excel' button on the 'List' ribbon, I am prompted to download the owssvr.dll file. When it download it will ...
1
vote
1answer
33 views

Create a list that stops after a certain amount of entrants

tl;dr - need to create an image that hyperlinks to an add item form for a list that stops after 15 entrants have been added. So I have been tasked with creating 4 sign up boards that stop after 15 ...
1
vote
1answer
32 views

Lookup list in SharePoint 2010 workflow show XXXXX when imported

Am exporting a Sharepoint site and importing. But the workflow lookup list does not appear instead an ID is displayed. And therefore its not working, Check the screen shot above! Have tried many ...
1
vote
1answer
953 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 ...
1
vote
1answer
106 views

Survery - Export to spreadsheet - shows all responses to contribute permission user

I am quite new to SharePoint. I created a survey with below settings; I have user who has contribute permission to this list. However when the user does 'Export to spreadsheet' from his account, he ...
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 ...
1
vote
1answer
893 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 ...
1
vote
1answer
546 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 ...
1
vote
1answer
707 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 ...
1
vote
0answers
120 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 IncludeUserSecurity....
1
vote
0answers
67 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 ...
1
vote
0answers
58 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) ...
1
vote
1answer
71 views

Error while importing Sharepoint site in SP 2010

I am trying to export a Sharepoint site from one environment to another. The steps I followed are as below created the site collection with web application from Sharepoint central admin in the new ...
1
vote
2answers
775 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 ...
1
vote
1answer
39 views

Excel Service Not Work after Import an Exported Application

my Excel service is not working.My Excels opening in my Client MSExcel but not open in Browser.its happen after after my application has problem and I have to Export and import again to work fine....
1
vote
0answers
546 views

Export users from User Profile

Is there a way to export all user profiles from SP using something other than powershell? I need a list of all synchronized users from SharePoint.
1
vote
0answers
466 views

Error on exporting design package

I'm Trying to Export Design Package via Design Manager after "Working on it..." screen i got error which i took the correlation ID and used ULS viewer and i found the following error Design Package ...
1
vote
1answer
280 views

Save SharePoint list item view form as a word document

I have a view form in SharePoint 2013, and I am trying to create a button that will export the form into a MS word document. So really I am trying save a SharePoint form to a word file. Is that ...