Powershell: Add lines to a custom objects

Question

I have the following code.

$strProjectPath="C:\temp\mps.xls";
$strServersExtr= @()
$strOSExtr= @()
$objServersList = New-Object PSObject
$objServersList | Add-Member -MemberType NoteProperty -Name ServerName -Value "" -PassThru | Add-Member -MemberType NoteProperty -Name OSType -Value ""

I read an Excel file (through a loop) to put 2 specific columns to these two members. The problem is that I can't add "Values" one after the other. += doesn't work with objects. I had try also to collect to and array and then to the object but it didn't work also. How is it possible to add lines to an already existing object?

Example:

ServerName                                                  OSType
----------                                                  ------
blabla1                                                     Windows XP
blabla2                                                     Windows 7 Professional

PS1.The $strServersExtr and the $strOSExtr was an attempt to collect the 2 columns in the 2 arrays and then put them in to the object.

PS2. I work with PS 3.0 but any solution will be preferable as I try to make the code easy to work on PS 2.0.

Your question remain unclear, do you want to add a third column to all your objects stored in $objServersList variable? What do you mean by "..I can't add "Values" one after the other.." ? — Raf
– Raf, Commented May 20, 2014 at 10:07
No, I think is clear. I don't speak about columns. That is easy to add members. The object is empty and I want to be like the example. No columns, rows. — Alex
– Alex, Commented May 20, 2014 at 10:26
We clearly(sic!) have a different version of clarity in mind. Do you mean adding more than one object to $objServersList? — Raf
– Raf, Commented May 20, 2014 at 10:51
@Raf, Not all people know terminology. If you want to help them, you need to be open minded and deduce what they really need. — majkinetor
– majkinetor, Commented May 20, 2014 at 11:12
Here are some useful tips for the future: stackoverflow.com/questions/how-to-ask msmvps.com/blogs/jon_skeet/archive/2010/08/29/… — Raf
– Raf, Commented May 20, 2014 at 11:23

majkinetor · Accepted Answer · 2014-05-20 11:00:48Z

6

As I see it u want array of objects (not 'lines'). So

$serverList= @() 
$serverList+= @{ServerName= 'blabla1'; OSType='Windows XP'}
$serverList+= @{ServerName= 'blabla2'; OSType='Windows XP Profesional'}

#display as table
$serverList | % { new-object PSObject -Property $_}

edited May 20, 2014 at 11:00

answered May 20, 2014 at 10:51

majkinetor

9,1229 gold badges56 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alex Over a year ago

So the 'objServersList = New-Object PSObject $objServersList | Add-Member -MemberType NoteProperty -Name ServerName -Value "" -PassThru | Add-Member -MemberType NoteProperty -Name OSType -Value ""' are useless?

majkinetor Over a year ago

Yes, the older syntax (perhaps there are more options to set using it, couldn't say from head). See improved answer

Alex Over a year ago

I will accept the answer as it seems to match my needs. Thanks

Raf · Accepted Answer · 2014-05-20 11:18:47Z

0

EDIT: To add more than one element to array use the +=, notation:

...
$objServer = New-Object PSObject 
$objServer | Add-Member -MemberType NoteProperty -Name ServerName -Value "" -PassThru | Add-Member -MemberType NoteProperty -Name OSType -Value ""
$objServersList +=,$objServer

edited May 20, 2014 at 11:18

answered May 20, 2014 at 9:44

Raf

10.2k1 gold badge34 silver badges42 bronze badges

2 Comments

Alex Over a year ago

nope. I have already created the object. I want to add values. I will rephrase my question to be more clear.

Alex Over a year ago

It doesn't work. Correcting the $objServersList with $objServer I have this:

Method invocation failed because [System.Management.Automation.PSObject] doesn't contain a method named 'op_Addition'. At line:1 char:1

Collectives™ on Stack Overflow

Powershell: Add lines to a custom objects

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related