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

0
votes
1answer
16 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
21 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. ...
2
votes
2answers
1k 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
24 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
19 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 ...
6
votes
2answers
1k 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: ...
0
votes
1answer
22 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 = ...
2
votes
3answers
3k views

Stsadm - Avoid subsites while exporting a site

I am exporting a site using stsadm command. It is automatically exporting the subsites too. I need to take the current site only, how can I restrict the subsites being exported? For example I'm ...
0
votes
1answer
16 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
29 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 ...
2
votes
2answers
133 views

Export SharePoint Site

I am trying to export a site in SP 2010 with export site functionality in Central Administration but it fails. The error message in log is Progress: Exporting List ConvertWordToPDF - ListInstance1. ...
5
votes
3answers
11k views

How to export a list in SharePoint 2010 and import it into 2013

Is there a good free way of exporting a list in SharePoint 2010 and importing it into 2013. Need to keep structure, data, attachments and other data but revisions, permissions etc not necessary. ...
0
votes
1answer
1k 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 ...
0
votes
1answer
715 views

Export entire folder using SharePoint Designer?

I have a folder that contains many html, js, css and image files. I want to export the folder as a zip or in any possible way as long as it's in a bulk. Right now, the only option that I know of is to ...
0
votes
1answer
19 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
1k 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
34 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 ...
7
votes
5answers
26k 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
1k views

Export SharePoint list to Excel - How remove column Item Type and Path

When I export a SharePoint list to Excel using the built-in functionality, it also exports two columns called Item Type and Path. Is there a way OOTB or programatically to exclude these columns from ...
0
votes
0answers
49 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
27 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
22 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: ...
0
votes
1answer
44 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
18 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
3answers
16k 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 ...
0
votes
4answers
13k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...
0
votes
1answer
782 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
0
votes
2answers
33 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
42 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 ...
0
votes
1answer
26 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
26 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
27 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
89 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 ...
2
votes
3answers
2k views

How to export .wsp solution files from SharePoint 2007 Farm

I want to download/export all .wsp solution files from SharePoint 2007 farm in order to deploy them again on new environment. How can i export or download .wsp files? I don't want to extract .wsp ...
0
votes
1answer
39 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
32 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 ...
0
votes
1answer
39 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
23 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
20 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
23 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
25 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
102 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
307 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 ...
5
votes
0answers
424 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
6answers
14k views

How to preserve created/modified/createdby/modifiedby information while copying a subsite / list / library under another site collection?

It seems that with oob tools or using explorer view the modified/created/modifiedby/createdby information gets lost or changed to the time of copying the listitems/documents to another site ...
5
votes
2answers
140 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
95 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.
3
votes
3answers
33k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...