Tag Info

Hot answers tagged

12

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. ...


11

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 ...


7

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 ...


7

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


5

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 ...


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

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

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 ...


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

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) ...


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 ...


3

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


3

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. Full tutorial (this is talking about between SharePoint servers, but its the same process between siets) Other ways include If it a simple list you can perhaps use the DataSheet view to copy and paste the ...


3

You can save the list in SharePoint 2007 with content - you can then save the .stp to the file system and you'll need to open up the .stp file (rename it to cab). You then need to update the version number within the manifest file from 3 to 4 and recab it. You can then upload the new .stp to SharePoint 2010 and create your list.


3

After migration lookup columns lost relations because list GUIDs they are using are different. This cannot be avoided and this is main disadvantage of using export/import based migration. Here you can find known issues when using import/export: Migration Ugliness - SharePoint 2010 Content Migration Limitations


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

The actual time of a backup will depend on a few things Size of the database Hard drives being backed up from, are they fragmented, older, slower, etc. Existing activity on the server during the backup Backup destination, library vs network share vs SAN, etc. The first one is easy to find out, and is really the biggest factor. There will be a difference ...


3

The way I would do this is to move the site collection into its own content database. Then copy that database and attach it to the new farm. In Central Admin add a new content database to the web application Use the Move-SPSite CMDLET in PowerShell to move the site collection to the new content database Make a SQL backup of the content database Restore ...


3

Backup-SPSite will move all your data and rights and create corresponding records in the content DB. Import-Export is not so good way for you, you can use it only for web, not for site collection, but it also will move all your data and security, if you will set corresponding flags, it has a lot of options. Previous approach is also possible, you can attach ...


3

Here is the quick summary of upgrade: Verify the hardware requirements first. Try to back up the database from SharePoint 2007 using the SQL Server Management studio. Move the backup file to SharePoint 2010 environment and restore the backup file in SQL Server in a New Database (say DB1_2010) Before you attach the DB to web app, run the following ...


3

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 ...


3

The content migration framework should be able to migrate document library while keeping the created/modified info. Since you are looking for a tool, have you already tried to use the Content Deployment Wizard by Chris O'Brien? It should work without particolar problem for simple migration, but be aware that the migration framework has some limitations (for ...


3

You need to define a custom permission level for employees. The easiest way is to copy from one of the default ones. Once you create your permission level uncheck the following option: [] Use Client Integration Features Create a group that has this permission level, and and your users to this group. Hope this helped :) for more information you can ...


2

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 ...


2

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


2

It is very easy to create a control or a web part and place it on the page. The control would contain a button with code behind that uses OpenXML to generate the Word document. I've done similar things and it's very easy. Just create a Word document using Word and format it as you like, then use the Document Reflector from the OpenXML SDK v2+ to generate a ...


2

stsadm cannot do what you are asking unfortunately, however you can achieve the same functionality using SharePoint Designer, which will create a .cmp (which is a cab file by another name) file which you can import using either stsadm or SharePoint Designer as you prefer. Here are some links to SharePoint Designer as well: SharePoint Designer 2007 (works ...



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