Article archive
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
02/08/2013 17:40
When using OleDb12 provider to read excel file from powershell, following error occured.
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Even Office 2010 was installed, script was not working.
Download following installer (even if its for 2007 Office, it works...
Internet Explorer cannot display the webpage
02/08/2013 17:31
Refers to Sharepoint site collections
Following error for host named site collection with url:
https://myserver.bla.com
Following error in IE browser:
Internet Explorer cannot display the webpage
1. Check if your site collection host is present in hosts file on:...
The HTTP service located at https://localhost:1547/SecurityTokenServiceApplication/securitytoken.svc is too busy
02/08/2013 17:28
get-spsite : The HTTP service located at https://localhost:1547/SecurityTokenServiceApplication/securitytoken.svc is to
o busy.
Go to IIS, application pool and start/restart (if stopped) SecurityTokenApplicationPool
Unable to load assembly group. The user assembly group provider was unable to provide any user assemblies for the specified assembly group.
25/06/2013 18:11
Unable to load assembly group. The user assembly group provider was unable to provide any user assemblies for the specified assembly group.
Error above was caused by coding error or typo:
- all receivers in elements.xml has to have definition in codebehind
- namespace and class must be the...
Set Web Part properties in loop
25/06/2013 18:05
Add web part to the page as instance of custom class, set its properites
Script reads *.webpart file and sets properties for webpart instance in a loop. Only string, bool and int type are set, because values are casted. Other properties are skipped. Web part in example is standard...
Import test cases with Powershell
07/06/2013 11:51
#Script imports Test Cases with steps and expected results from Excel file to Test Manager (and TFS). Filename, sheet name and column names are input parameters. AreaPath, TestPlan and TestSuite are common for all imported Test Cases.
Use e. g. following structure for Excel...
Create or open Excel file in powershell
25/05/2013 03:20
function CreateOrOpenExcelFile()
{
param
(
[Parameter(Mandatory = $true, HelpMessage = "Excel file path.")]
[string] $ExcelFilePath,...
Get all Test Cases from Test Plan
09/05/2013 18:11
Get all Test Cases from Test Plan in Powershell
script was created from C# code and inspired by https://ddasankaindrajith.blogspot.sk/2013/04/how-to-create-test-plans-and-cases.html
One additional 'WindowsBase' reference was needed.
$ProjectName = "YourProjectName"
$TfsServerUrl =...
Query TFS work items
07/05/2013 12:17
Use Query to get work items from TFS
https://get-powershell.com/post/2008/11/14/PowerShell-and-TFS-Work-Items.aspx
#link to query syntax
https://msdn.microsoft.com/en-us/library/bb130198(v=vs.90).aspx
tfs database field...
Issues with DataFormWebPart in SharePoint Designer
02/05/2013 12:43
I had to add DataFormWebPart in SharePoint Designer and had lot of struggling with this simple task. Here are some points I found out. Complete step by step manual is in attached file. How to add DataFormWebPart to the page in Sharepoint Designer 2010.docx (1,6 MB)
Ispired by:...
Items: 181 - 190 of 384