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.

learn more… | top users | synonyms

2
votes
0answers
28 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) ---------------------------------...
0
votes
1answer
29 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?
0
votes
1answer
24 views

Import-SPWeb command not working

Trying to import one subsite from one site to other exported the site successfully using Export-SPWeb –Identity http://sitename -Path E:\backups\site.cmp but when trying to import using the below ...
0
votes
1answer
26 views

User issues when opening the owssvr Exporting a List to Excel

I have created a List and Exported that list to Excel via owssvr. I have one User in our 15 person group that when she opens the owssver. One of the columns is supposed to show Last Name, First Name. ...
0
votes
1answer
40 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' ...
0
votes
0answers
21 views

Retaining the document version with “Export to Excel” delivers a runtime error

We have been working for a kinda long time now with a vba script for retaining the document version in an exported Excel spreadsheet. It was working pretty well, however, since a few days it delivers ...
0
votes
1answer
17 views

Collecting and editing data using SharePoint Online

I need some guidance on the best way to collect and edit data on a SharePoint Online Office 365 system. There will be multiple users entering and updating the data online. The company does not want ...
0
votes
1answer
23 views

SP07 - Export to word, problem with Response-encoding

I have a button-event where exports data from SharePoint(unicode format) to Word(unicode format). The problem is with encoding. this is my code: string filename = String.Format("Results_{0}_{1}.doc",...
0
votes
1answer
32 views

SharePoint List export and import

I want to export a SharePoint 2010 List and import it into another site. This list has 2500+ items in it and a Workflow attached to it. Workflow gets triggered on adding a new item. If the List is ...
0
votes
1answer
23 views

SP - Foreach Gridview cells before export in Excel to change TextFont

I want to change text in gridView cells before export in excel, because the text is big after export. This is my button to export in Excel: void btnToExcel_Click(object sender, EventArgs e) { ...
0
votes
1answer
58 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 ...
0
votes
0answers
62 views

Export-SPWeb : Object reference not set to an instance of an object

I cannot export a library. This is the command I execute: Export-SPWeb -Identity $sourceUrl -Path $filecmp -ItemUrl "Documenti Condivisi" -Verbose -UseSqlSnapshot -Force with the following ...
2
votes
3answers
31 views

Copying sites / site collections with workflows

I have copied a site in order to create a test environment of it in a different web application. The process has finalized without no issues and all the lists, documents, and items are there. ...
0
votes
1answer
37 views

How to migrate a team site with publishing infrastructure enabled under another publishing subsite

We are using SP2013 standard on-premise. There are 2 existing site collection. Both are built with team site template with publishing infrastructure enabled. The URLs are: http://sharepoint.com/sites/...
0
votes
3answers
61 views

Are there list view url parameters to export to Excel?

I would like to automatically export a list view to Excel as a single click process. Are there parameters I can add to the list view url that will accomplish this? The list view is currently provided ...
0
votes
2answers
19 views

Export libraries and documents into filesystem preserving fields

I'm exporting some DOCX documents from site and subsites to filesystem, I would like to preserve: the site/library/file structure in the form of subfolder hierarchies fields (latest version, ...
0
votes
2answers
36 views

How can you minimize export time on a large site collection?

I'm attempting to perform triage on a 1.5TB subsite in SP2013. I've reduced content as much as the business unit will allow, and my next step will be to move the site into its own site collection &...
2
votes
1answer
60 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'...
0
votes
1answer
27 views

Best way to pull data from list for .net app

We are fairly new to SharePoint 2013. We need to pull some data from a List Library and use it in a .net application. How is the best way to do this? Examples would be greatly appreciated! Thanks in ...
0
votes
0answers
28 views

New page in Pages Library failing on SharePoint 2013

I have recently migrated a SharePoint 2013 site collection with publishing enabled. After the migration, everything looks fine, except for When user clicks on creating a new articles page in Pages ...
0
votes
0answers
36 views

Expose list or document through ODBC connection

I've seen a few things on Data Connection Libraries and BCS on how to bring content from external databases into SharePoint, but what I am looking for is the other way around. We have a SAP server ...
0
votes
1answer
137 views

How to Export SharePoint 2013 list images to Excel as Image?

I made a list in SharePoint 2013 which contains a picture/hyper link column. The Users need to export the excels but when they do they do not have pictures any more but they have links. I looked after ...
0
votes
1answer
50 views

Automatic email Survey statistics in SharePoint 2013

I have made a satisfaction survey in SharePoint 2013. I am asked to get automatic email send every week with graphical summary. Is it possible ? should I use workflow option ?
1
vote
0answers
42 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....
0
votes
1answer
41 views

how can I export List content to Excel when list view exceeds list view threshhold

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
0answers
24 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 ...
2
votes
0answers
23 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 ...
0
votes
0answers
24 views

Missing Recommendations Displayed and Recommendations Clicked in Usage Reports

My SharePoint 2013 is up and running for 4 months. When I click on Site settings -> Popularity and Search Reports -> Usage. The report has "Views" sheet only. And I wonder where are the "...
1
vote
0answers
26 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) ...
0
votes
1answer
26 views

Network Error when export zip file

I implement a function to allow users to download multiple selected files as one zip file. I use Ionic.Zip library for this function. On my local machine, there is no problem, works well on Firefox, ...
1
vote
1answer
134 views

Export and Import a Site Page using PowerShell

I am familiar with how to export/import a site using PS. My question is, is it possible to do the same operation with a Site Page? For example, SiteA/default.aspx contains 2 Site Pages called ToDoList ...
1
vote
2answers
431 views

How to use PowerShell script to copy document library with meta data to other site collection?

I need to migrate a document library includings all its documents and all meta data to another site collection. I did some research and quickly found a script that would seem to do the job, see source ...
2
votes
2answers
72 views

Export a custom Document Library using PowerShell

I would like to know how to export a document library (SharePoint 2010) using PowerShell and also saving metadata about content. I need to repopulate the document library with items coming from itself....
5
votes
0answers
474 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 ...
5
votes
2answers
170 views

Export a page with web parts and import to another site

I have a web page in the documents library configured in a certain way with all the web parts set up. I created this on a test team site. How can I export this page to a production team site?
2
votes
1answer
114 views

how to export in csv format instead of .iqy

By default export to spreadsheet showing owssvr.iqy , we need to have owssvr.csv Please help.
0
votes
1answer
30 views

Export to CSV on custom application results in that nothing works on the page anymore

i have a simple custom application which fetches records from a lists by a caml query and through an export button the user is able to get a csv file with the data. Generally the export works fine. ...
0
votes
0answers
48 views

function to export mappings and crawled / managed properties

I’m running this script I found on sharepointspace.com. http://andersrask.sharepointspace.com/Lists/Posts/Post.aspx?ID=36 Why am I receiving the following error below? .\FuncRunExportSPESMM.ps1 ...
0
votes
1answer
49 views

SPListItemCollection.GetDataTable() , For choice fields its adding extra string “;#” in the datatable

SPListItemCollection collListItems = list.GetItems(query); dataTable = collListItems.GetDataTable(); I am using above for getting listitemcollection into datatable. In the list I have choice ...
0
votes
0answers
29 views

How to email csv file to Owners group using powershell

I have a script that exports data to a csv file listed below: $url = "http://portal.contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($url) $web = $site.OpenWeb() $list = $web.Lists ...
0
votes
0answers
63 views

Export to excel not showing all rows

We have a very large list and a user is exporting a filtered view to Excel, the view has 18,000 items, give or take, and he is only getting 16,000 items exactly I want to know if it is a problem with ...
0
votes
0answers
118 views

export specific columns/fields of list to Excell and not the whole list. How?

End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns. I've created "another ...
2
votes
1answer
73 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 ...
2
votes
1answer
248 views

Get all documents from subsite with Powershell

I want to get all documents (and only documents) from a site with a Powershellscript and save the result in an .csv I need this because a lot of documents are stored in a bunch of subfolders in the ...
0
votes
0answers
67 views

A question about relative URLs during site collection export

I plan on exporting a large sub-site into a separate site collection, one that has its own content database. Currently I'm using relative URLs where possible. As far as I know, a relative URL begins ...
0
votes
1answer
64 views

How to export all list data from Web Scope to an excel file?

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked ...
1
vote
1answer
30 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
78 views

Can I extract a Solution (WSP File) from my site level?

We have a Feature located on one of our SharePoint sites how can I export this feature (wsp) so that I can import it into another site?
0
votes
1answer
556 views

Export SharePoint Search results to Microsoft Excel

I need a functionality to export search results to Excel for SharePoint. I've researched a lot and found many answers though no blog provides end to end solution. Best I could find is: Catch search ...
1
vote
2answers
173 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 ...