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
1
vote
2answers
4k views

Import-SPWeb error: “The file xxx.cmp does not exist.”

I have a strange issue with Export-SPWeb and Import-SPWeb for SharePoint 2013. I want to export one of my sites, so I type this command: Export-SPWeb https://test.mywebsite.com/site -Path "export....
1
vote
2answers
327 views

Export all lists to excel

I have three different list seperated by Area (NY, NJ, and CT) is there a way to build a report in the database that will pull all records from all lists? I exported all three to excel one by one, but ...
-1
votes
1answer
1k views

Export SharePoint Online List to Excel using C# Console Application

I am trying to export SharePoint online list to excel 2007 using C# console application. I have got the code from the following url (https://gallery.technet.microsoft.com/Alternate-to-Timer-Job-...
3
votes
0answers
295 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) ---------------------------------...
4
votes
3answers
23k views

How can I export all attachments from a SharePoint 2010 list without code?

Is there any solution in exporting all the attachments from a list without code? I do not have Visual Studio installed on my machine and am looking for a way to just grab all the attachments and place ...
1
vote
3answers
1k 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 ...
11
votes
5answers
16k views

Missing export option for SharePoint 2010 webparts

I am trying to export a list view webpart as a .dwp file so I can have a look at the XML. However, the export option is missing. My initial thought was to try something like the this link However, ...
0
votes
1answer
2k 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
233 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
45 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",...
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
254 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
107 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
141 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. ...
6
votes
3answers
16k 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. I'...
0
votes
1answer
37 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
0answers
428 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
1k 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
319 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
2answers
183 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, original ...
2
votes
3answers
26k 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
2k 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
288 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 &...
0
votes
1answer
59 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
1answer
2k 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 ...
3
votes
3answers
5k 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
199 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
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) ...
0
votes
1answer
573 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
1k 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 ...
2
votes
2answers
3k 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
6answers
20k 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 collection....
7
votes
2answers
7k 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
1k 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.
6
votes
2answers
58k 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 ...
0
votes
1answer
41 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. ...
8
votes
2answers
554 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"); ...
0
votes
1answer
260 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 column ...
0
votes
0answers
71 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
1answer
918 views

Export(or map) List data to external MSSQL table

There are many references about External Lists, where you make a Sharepoint list from SQL database table. In my case, I need to do the opposite - I have SharePoint list, and I want to map it to an ...
0
votes
0answers
810 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 ...
4
votes
1answer
448 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
3answers
3k views

How do I migrate a document library (and just the documents) with PowerShell

I need to migrate the documents of an existing library to a new library. The requirements of the migration is that I maintain versions and audit data (who/when created the document and last modified ...
2
votes
1answer
2k 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
1answer
230 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
70 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 ...
2
votes
2answers
873 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
4k 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 ...