Browse Blog Posts by Tags

All Tags » powershell » PowerShell V2 (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Using a colon with cmdlet parameters

Another question at Tuesdays PowerShell group revolved around using colons to link values to parameters. I’d not really thought about before. Thinking about it later I realised that you only really see it when passing booleans to –Confirm. If you don’t use a colon then you get this PS>...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sat, Jun 2 2012
Filed under: Filed under: Powershell, PowerShell V2, PowerShell V3
You are unique

Lets start with some data $data =@(1,1,1,1,12,23,4,5,4643,5,3,3,3,3,3,3,37,7,7,8,9,9,0,0,12 ) We now want to select the unique values out of this list if I’ve wanted only the unique values I’ve tended to do this $data | select –Unique there are other options. If you want the output sorted you...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Apr 21 2010
Filed under: Filed under: Powershell, PowerShell V2
Folder names without spaces

Problem How can I prevent the creation of folders with spaces in the name from within my script. Solution 001 002 003 004 005 006 007 008 009 010 function New-Folder { param ( [string] $path = "C:\Test" , [string] $name...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Mar 21 2010
Filed under: Filed under: Powershell, PowerShell V2, Modules
PowerShell pack: ISEpack

The ISEpack adds a number of commands to the Add-ons menu in ISE. The list of additional commands includes Add-ForeachStatement Add-IfStatement Add-InlineHelp Add-IseMenu Add-Parameter Add-PInvoke Add-SwitchStatement Close-AllOpenedFiles Colorize ConvertTo-ShortcutKeyTable Export-FormatView Get-CurrentFunction...

Posted to Richard Siddaway's Blog by on Mon, Mar 8 2010
Filed under: Filed under: Powershell, PowerShell V2, ISE
PowerShell in Practice – February update

The book is over half way through the author review process. This means that the editor has corrected my English and the technical reviewer has made his comments and I get to read all of this and revise as necessary. Soon be done at this rate Technorati Tags: PowerShell , Books

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Feb 28 2010
Filed under: Filed under: Powershell, PowerShell V2, Books
Excel 2010 and PowerShell

In this post http://msmvps.com/blogs/richardsiddaway/archive/2009/12/20/1702386.aspx I showed that for GB English locales we could open Excel just by adding a workbook to the workbooks collection – this is the way it has always worked for US locales. I had assumed that all non-US locales would now work...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Jan 3 2010
Filed under: Filed under: Powershell, PowerShell V2, Office 2010
Add a column to an Access Table

Now we have created our Table we can start adding columns 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Dec 10 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
New Access Table

I have already presented a function to create a new access table but I wasn’t very happy with it because we had to supply the full table creation SQL script. I have altered that function so it creates an empty table. We can then use the Add-AccessColumn function to add columns. This also means I have...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Dec 10 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Creating Objects

There is a post on the PowerShell Team blog about using New-Object - http://blogs.msdn.com/powershell/archive/2009/12/05/new-object-psobject-property-hashtable.aspx The –property parameter discussed in this post is something that I had only come across recently. In a number of recent posts I have...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sat, Dec 5 2009
Filed under: Filed under: Powershell, PowerShell V2
Access Bulk Load data

We have already seen how to load individual records into an Access Table. Sometime we require the ability to add multiple records. We can easily adapt the way we use our Add-AccessRecord function to accommodate a bulk load scenario. Lets create a csv file with the information FirstName,LastName...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Dec 4 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Working with Access dates

Following on from the previous post about updating records one data type that will be a little awkward to work with is dates. If you use a US locale or any other that uses a date format of Month/Day/Year you can more or less ignore this because your standard formats work OK. If I run PS> Get-AccessData...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 30 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Updating Access data

The last of of our data manipulation tasks is to update the data – we have already seen how to create, read and delete. 001 002 003 004 005 006 007 008 009 010 011 012 013 function Set-AccessData { [ CmdletBinding ( SupportsShouldProcess = $true ) ] param ( [string...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 30 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Testing Connection to Access database

Many of the functions we have created so far have taken a connection to an Access database as a parameter. At the time we pass in the connection we don’t actually know if the connection is open. Test-AccessConnection can be used to test the connection before we use it. All we do is test the...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 29 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Removing Access Records

So far we have seen how to add data to a table in an access database – now we want to delete some records. This is an action that can cause problems especially if we get the wrong records – ideally we want to a mechanism to check what we are doing. The PowerShell cmdlets that change system...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 29 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Add Access Record Pt III – parameter sets

Last time we added the option of inputting the table and values to our function but we needed a way to discriminate between that and using a full SQL statement. We can achieve this by dividing the parameters into parameter sets NOTE – This is a PowerShell v2 capability . 001 002 003 004 005 006...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Nov 27 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Export Access data to csv file

We already have all the functionality we need to achieve this. Import-Module accessfunctions $db = Open-AccessDatabase -name test03.mdb -path c:\test Get-AccessData -sql "select * from test1" -connection $db | Export-Csv -Path c:\test\test1.csv –NoTypeInformation Open the csv file in Excel...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Nov 27 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Reading Access records

Reading data from an Access database is similar to the functionality we have already seen. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 function Get-AccessData { param ( [string] $sql , [System.Data.OleDb.OleDbConnection...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Nov 26 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Add Access Record PtII

We have seen how to add a record to an Access table by passing in the whole SQL string. This is OK when we want to add a single record or possibly not fill all fields in a row. 001 002 003 004 005 006 007 008 009 010 011 012 function Add-AccessRecord { param ( ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Nov 26 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Set Background colour of Excel cell

I needed to set the background colour of a cell in an Excel spreadsheet recently. The way to do it is to set the ColorIndex property of the Interior properties of the cell as shown in line 14. The ColorIndex can be set to a number between 1 and 56. Use –4142 if you don’t want a coloured...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Nov 25 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010
Add Access record

We’ve seen how to create a database and a table. Now we need to know how to add a record to that table. 001 002 003 004 005 006 007 008 function Add-AccessRecord { param ( [string] $sql , [System.Data.OleDb.OleDbConnection] $connection ) ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 23 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access

Page 1 of 2 (33 items) 1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.