Articles about European Sharepoint Hosting Service
Posts tagged trick SharePoint 2013 Hosting Published 20
SharePoint 2013 Hosting – HostForLIFE :: How To Fix SharePoint Errors In A Few Minutes?
Jan 28th
SharePoint is a flexible server program available for use today. And the main motive of Microsoft for offering SharePoint is to help the organizations build a collaborative environment among the employees. Whenever a number of users work with an application for workflows, the amount of data also increases and demands more storage space to store it. This affects the SharePoint space configuration which eventually will badly affect its overall performance. Apart from this, SharePoint has a very dynamic nature due to which administrators and normal users, both, might face some issues. Therefore, in this blog, let us see how to fix SharePoint errors with ease. Along with this, a third party tool is also discussed for SysTools SharePoint to SharePoint Migration.
Common SharePoint Errors Encountered By Users, With Solutions
This section of the blog will let users know about SharePoint problems and how they can resolve these easily.
Problem #1 – Increase in Database Size
It is clear that the SharePoint database contains lots of documents, images, presentations, videos, etc. And, everybody knows media files are generally large or heavy in size, which increases the total database size also. This will somehow increase the browser timeout and have an adverse effect on the performance of the SharePoint application.
Solution
Now, to avoid this situation, it is always recommended to fix this SharePoint file size error. If there are multiple media files, then it is suggested to save or move them to an external storage device.
Problem #2 – Unnecessary Data Take Space
It is obvious that after some time, the data becomes useless and not required by the user. Therefore, to manage or create storage space for new data, a user has to remove the unnecessary data from time to time. If this is not taken care of at the time, then it will definitely start creating issues in SharePoint application.
Solution
To overcome this storage space issue, a user is advised to Shift + Delete the data that is not necessary to free up the storage space on the cloud for new data.
Problem #3 – Database Stored in SQL Server
SharePoint database is stored in an unstructured form on the SQL Server. However, the data is stored as the BLOB (Binary Large Objects) and in the case of SharePoint, the database becomes large in size. Moreover, it uses a large number of SQL resources and whenever a user works on SharePoint, each process takes lots of time.
Solution
In this case, a user can shuffle BLOB database to the SQL secondary storage such as NAS (Network Attached Storage).
Problem #4 – Missing Site Templates
This is one of the commonly faced errors by the users when they upgrade SharePoint from one version to another. Because sometimes while doing so, site templates get deleted, which generate an error.
Solution
Look for the site definition on the earlier server. After that, simply upgrade it to support the latest version, and install it on the upgraded server.
One Stop Solution to Overcome All Troubles of SharePoint
The above discussed errors are just highlights of the issues related to SharePoint problems whose main reason is storage limit. Now, to stop them from occurring in the future, one needs to look for some SharePoint Issues alternatives. There can be several possible reasons that result in issues in SharePoint and the worst case is data loss.
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?
Jan 22nd
This article will explain the PowerShell script that searches for files within document libraries in SharePoint (farm level, site collection level, web level etc.) based on the search parameters you provide. It can also be used for searching in SharePoint for any files with specified extension. The results are returned in .CSV format.
Examples of scenarios
Search the entire farm for files that have names like “Training Copy”.
Search the site collection http://sharepoint.mydreambox.com/sites/site1 for all PDF files, RDL files, etc.
Search the web http://sharepoint.mydreambox.com/sites/site1/web1 for the file named “AXL8rt.docx”, etc.
Usage of the Script
Replace the $webApp, $sites, etc. with appropriate values
Replace the $searchKey with the desired search queries or file extension that is to be searched for
Make sure the account that is running these scripts have necessary privileges in SharePoint
Script use cases
The code is presented for four different cases,
Searching for an entire farm
Searching within a web application
Searching within a site collection
Searching within a web
Output
The output will be in the form of a CSV file, as displayed below. It will contain all the file location URLs.
Case I – For searching within the entire farm
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $sites = Get-SPSite -Limit All $searchKey = ".rdl" $results = @() foreach ($site in $sites) { foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation Case II - For searching within a Web Application if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $webApp = "http://sharepoint.dreambox.com" $sites = Get-SPSite -WebApplication $webApp -Limit All $searchKey = "Self Improvement" $results = @() foreach ($site in $sites) { foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |
Case III – For searching within a Site Collection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1” $searchKey = ".docx" $results = @() foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |
Case IV – For searching within a Web
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1” $searchKey = ".pdf" $results = @() foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |