Hot answers tagged

19

You can retrieve the schema of any list by using the owssvr.dll call from your browser. Following is the syntax: http://YOUR_SERVER_URL/PATH_TO_SITE_CONTAINING_LIST/_vti_bin/owssvr.dll?Cmd=ExportList&List={YOUR_LIST_GUID} By replacing the Server and List GUID in above url will return you the XML Schema of the list. This works on both 2010 and 2007. ...


14

Glyn Clough has a nice solution for exporting xsltlistviewwebpart Update 2014-09-19 I have found another way to easily export any web part from a SharePoint page, without needing to update web part properties: Export any web part from a SharePoint page Here is the most important text from the blog post: In SharePoint there is a hidden application page ...


12

I'm glad you included an image of the operation in progress, because it makes it easier to clear up some confusion and answer your question. I think previous respondents missed the fact that you're actually working in SharePoint Designer 2007 -- not Central Administration or the command line. First, let me clear up some confusion: the operation you're ...


10

Create a new content database (preferably in a new web application) Duplicate existing site collection (as its in a new content database, same internals guids/ids shouldn't clash) import/export backup/restore content deploy Trim areas from each site collection that you dont want If you create a new web application and have the new site collection at the ...


10

You can use the below code, Add-PSSnapin microsoft.sharepoint.powershell $web = Get-SPWeb -Identity "<URL of Site>" $list = $web.Lists["List Name"] $AllDuplicates = $list.Items.GetDataTable() | Group-Object title | where {$_.count -gt 1} $count = 1 $max = $AllDuplicates.Count foreach($duplicate in $AllDuplicates) ...


8

Go to "Site Settings -> Users and Permissions -> People and groups" Click on the "Settings" menu and "List Settings" Scroll to the bottom of the page and click on the view that you want to export. Copy the url and in particular the List and View IDs http://sitename/_layouts/ViewEdit.aspx?List=%7B64DAB4AC%2DD043%2D4DA4%2D85C7%2D9D4521C3F4CC%7D&View=%...


8

stsadm -o export -includeusersecurity seems to work actually. Export site: stsadm -o export -url http://sp2010/sites/sc/subsite/ -filename subsite.cmp -includeusersecurity Export list: stsadm -o export -url http://sp2010/sites/sc/subsite/Lists/mylist/AllItems.aspx -filename mylist.cmp -includeusersecurity


8

You can create a Site Template to create the copy. Go to the list settings of the list (ListA) Click save list template on the right list of links Save the template as something Click save list content if you want the same content in the new list Go to the All Site Content page and create a new list based on the saved template (ListB) This will create an ...


7

According to @ToniFrankola http://serverfault.com/questions/73677/disable-export-to-spreadsheet-in-sharepoint-custom-list you need to have permission: [x] Use Client Integration Features In OOTB premission levels this permission is not set only for Restricted Read level. So correct answer to your question is: Minimum OOTB permission level for users to ...


6

Instead of exporting as a template, rather use the Sharepoint Backup Tools. Browse to http://YOURCENTRALADMINURL:portnr/backups.aspx Click "Export a site or list" Select the List you want to backup. Import into correct location using : Import-SPWeb http://site -Path export.cmp


6

I found a way to do it finally via "The Internet". Here is what worked for me. Sub ImportSharePointList() Dim objMyList As ListObject Dim objWksheet As Worksheet Dim strSPServer As String Const SERVER As String = "mysite:8003/sites/the-sharepoint-thing/" Const LISTNAME As String = "{D1F1C2ED-81BA-41CC-A698-XXXXXXXXXXXX}" Const ...


6

You can map a drive to the List: http://community.office365.com/en-us/forums/154/t/5216.aspx The attachments will be under the Attachments folder.


5

There is just a subtle difference: Workflows are included when you use the Backup-SPSite cmdlet. If you backup a root web of a site collection the site collection recycle bin will obviously not be included.


5

You can even increase the maximum size of list templates up to 500 MB (I don't know if it is large enough for you) either via stsadm: stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 524288000 or via PowerShell as well: $webservice = [Microsoft.SharePoint.Administration.SPWebService]::ContentService $webservice....


5

Exporting and importing as html will not work in SharePoint as it refers lots of controls and files internally Thee best suggested option would be to open the page in designer and copy the content to target page** but make sure all the those web parts are already in the web part gallery and fully functional. To check all webparts are in the gallery,...


4

Did you use Get-SPFeature to verify that the feature was successfully deactivated before re-exporting? Maybe you need to use the -force parameter on Disable-SPFeature. Also, make sure the -url parameter is for the site and not the site collection, since this feature is web scoped.


4

If you look in your web.config you'll see which FBA SQL database is being used. This is a standard SQL Database that you can Query from using any SQL tool, Including Excel.


4

You're almost there, the next step is to create a new list choose the template you saved after list created delete the template from the library. (Broken link removed) Other ways include If it a simple list you can perhaps use the DataSheet view to copy and paste the data to the new list if you've already setup the structure. You can copy lists with ...


4

I think you mean Export-SPWeb: http://technet.microsoft.com/en-us/library/ff607895.aspx. It does not have a switch for excluding subsites. The other options for export are the SPExport class in the Microsoft.SharePoint.Deployment, but unfortunately the SPExportSettings object doesn't have a way to exclude subsites...not sure why it doesn't when the Sites ...


4

I needed to do this for one of my projects. Here are the steps I took. Generate an export for the data you want to share via the out of the box process (ie via the Action Menu). When prompted, name and save this file locally. This is the Excel Query File and it has information about the site, list and view that generates this data. Place the file in the ...


4

Since you removed DocAve already, the solutions bits were probably removed but it appears they were not un-registered with SharePoint. You need to ensure all the DocAve solution features are unregistered and removed from the farm. You can use CA, Powershell, or a tool like feature admin from codeplex to assist: http://featureadmin.codeplex.com/ Then re-...


4

Open the SharePoint 2010 Central Administration, Go to Application Management => Manage Web Applications and then select your web application. In the Ribbon, select the General Settings => Resource Throttling, There you can see the threshold limit 5000, edit the value as you need and save it.


4

Here is a trick I've tried in your situation: Change your view in SharePoint to only display like Maximum 1000 rows. (use the Limit in the bottom of the view definition screen) Attempt again to export to Excel - this should work without issues (if it doesn't the problem lies elsewhere in your SharePoint and then you should have a look in ULS) Change back ...


4

Using Export and Import, you can migrate list from SP 2010 to SP 2013 but you have to make some manual changes. Export the list from SharePoint 2010 using either the Central Administration or PowerShell (Export-SPWeb). In the Central Administration, go to Backup and Restore > Export a site or list. Choose your list, and click Start Export Copy the exported ...


4

With the script below you can easy export all column in a list a comma seperates file Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue -WarningAction SilentlyContinue | Out-Null $url = "<site url>" $listName = "<list name>" $path ="c:\Columns.csv" $web = Get-SPWeb $url $list = $web.Lists.TryGetList($listName) $list....


3

You need a slash at the start of the ItemUrl parameter. Your command should look like: export-spweb http://mysite -itemurl "/lists/mylist" -path "c:\temp\mylist.cmp" Reference


3

If you are looking at migrating an application, then what Wictor said is correct - package a deployment up as a WSP, and deploy to the other environments. However if you are looking at is entirely content based, and you currently have in one environment and are moving it all to another, either doing a content database move or a backup and restore is more ...


3

The best option is ALWAYS to create everything in WSP packages and deploy them to the respectively environments. Further down on the ladder you have the option to export a site as template (to a WSP package that is) import it and refactor in Visual Studio and then deploy it correctly. IMO there should be no other deployments of SharePoint artefacts/objects ...


3

Please check these technet documents Export list: http://technet.microsoft.com/en-us/library/ee428301.aspx Import list: http://technet.microsoft.com/en-us/library/ee428322.aspx Sample Export: Export-SPWeb -Identity http://site -Path c:\export.cmp -IncludeUserSecurity -IncludeVersions All -ItemUrl /lists/mylistname Sample Import (path to subsite, list ...



Only top voted, non community-wiki answers of a minimum length are eligible