{"id":4478,"date":"2012-12-12T00:01:00","date_gmt":"2012-12-12T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2012\/12\/12\/create-a-custom-powershell-object-to-simplify-appending-csv-files\/"},"modified":"2012-12-12T00:01:00","modified_gmt":"2012-12-12T00:01:00","slug":"create-a-custom-powershell-object-to-simplify-appending-csv-files","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/create-a-custom-powershell-object-to-simplify-appending-csv-files\/","title":{"rendered":"Create a Custom PowerShell Object to Simplify Appending CSV files"},"content":{"rendered":"

Summary:<\/strong> Microsoft Scripting Guy, Ed Wilson, shows how to create a custom Windows PowerShell object to simplify appending to CSV files.\n \"Hey, Hey, Scripting Guy!  Yesterday, you talked about creating two objects, exporting them to CSV files, and then manipulating the strings to combine the CSV files. Is there a cleaner way of doing this?\n—CS\n\"Hey, Hello CS,\nMicrosoft Scripting Guy, Ed Wilson, is here. This morning I am sitting on the lanai and sipping a cup of Assam black tea<\/a>. I brought the leaves back from Munich, Germany (by the way, if you bring back several bags of tea leaves, be prepared for additional customs screening when you return to your home country—at least that is what happened to me). The tea is a robustly flavored black tea. I added a few organic rose petals to the pot to give it a nice, mellow flavor.\nCS, of course, there are other ways of combining WMI objects and creating CSV formatted output. In Windows PowerShell, there are always multiple ways of accomplishing the same task.<\/p>\n

First create a custom object<\/h2>\n

Note<\/strong>   Today’s post is basically a continuation of yesterday’s blog post, Use PowerShell to Add Two Pieces of CSV Data Together<\/a>.<\/em> It might be a good idea to read that article first.\nThe first step is to create a couple of custom objects. The easiest way to create a custom object is to use the Select-Object<\/strong> cmdlet. This cmdlet permits easy conversion from one type of object to a custom object. In the custom object, the properties and values appear as noteproperty<\/strong> <\/em>data types, as shown here.<\/p>\n

PS C:> $osInfo = gwmi win32_operatingsystem |<\/p>\n

    select version, caption, serialnumber, osarchitecture<\/p>\n

PS C:> $osInfo | gm -MemberType NoteProperty<\/p>\n

   TypeName: Selected.System.Management.ManagementObject<\/p>\n

 <\/p>\n

Name           MemberType   Definition                                       <\/p>\n

—-           ———-   ———-                                       <\/p>\n

caption        NoteProperty System.String caption=Microsoft Windows 8 Pro    <\/p>\n

osarchitecture NoteProperty System.String osarchitecture=64-bit              <\/p>\n

serialnumber   NoteProperty System.String serialnumber=00178-10777-21922-AA381<\/p>\n

version        NoteProperty System.String version=6.2.9200        \nBecause I am already dealing with an object, I can easily extend that object by using the Add-Member<\/strong> cmdlet. The Add-Member<\/strong> cmdlet adds additional members to an existing object thereby permitting the extending of existing objects. I have my computer information stored in a custom object in a variable—just as I also have the operating system information stored in a custom object. The Windows PowerShell code to create the two objects is shown here.<\/p>\n

$computer = gwmi win32_computersystem |<\/p>\n

    select numberOfProcessors, NumberOfLogicalProcessors, HypervisorPresent<\/p>\n

$osInfo = gwmi win32_operatingsystem |<\/p>\n

    select version, caption, serialnumber, osarchitecture <\/p>\n

Extending an existing object<\/h2>\n

If I wanted to add only one or two properties to an existing object, I might do it manually. But because I already have an object—with an undetermined number of properties—I want an automatic way to add the members to the object. To do this, I use the Get-Member<\/strong> cmdlet to find the members of the object I wish to locate and to use. As illustrated earlier, the properties I am interested in obtaining are NoteProperty<\/strong> <\/em>member types. Therefore, I use the Foreach<\/strong> statement to walk through the members of the custom object stored in the $osInfo<\/strong> variable—but only if -MemberType<\/strong> is a NoteProperty<\/strong> <\/em>data type. <\/em>This line of code is shown here.<\/p>\n

Foreach($p in Get-Member -InputObject $osInfo -MemberType NoteProperty)\nNow, I need to use the Add-Member<\/strong> cmdlet to add the NoteProperty<\/strong> <\/em>member types to the custom object stored in the $computer<\/strong> variable. I use the object stored in the $computer<\/strong> variable for the InputObject<\/strong>, <\/em>and I add the new members to the object. This line of code is shown here (the back tick is line continuation—I broke the line for readability). The subexpression is required to obtain the value stored in each property.<\/p>\n

Add-Member -InputObject $computer -MemberType NoteProperty `<\/p>\n

  -Name $p.Name -Value $osInfo.$($p.Name) -Force\nOnce modified, the new object easily creates CSV output when piped to the ConvertTo-CSV<\/strong> cmdlet (or to the Export-CSV<\/strong> cmdlet).\nThe complete Get-OsAndComputerInfoAddMember.ps1 script is shown here.<\/p>\n

Get-OsAndComputerInfoAddMember.ps1<\/strong><\/p>\n

$computer = $osInfo = $null<\/p>\n

$computer = gwmi win32_computersystem |<\/p>\n

    select numberOfProcessors, NumberOfLogicalProcessors, HypervisorPresent<\/p>\n

$osInfo = gwmi win32_operatingsystem |<\/p>\n

    select version, caption, serialnumber, osarchitecture<\/p>\n

Foreach($p in Get-Member -InputObject $osInfo -MemberType NoteProperty)<\/p>\n

{<\/p>\n

 Add-Member -InputObject $computer -MemberType NoteProperty `<\/p>\n

  -Name $p.Name -Value $osInfo.$($p.Name) -Force<\/p>\n

}<\/p>\n

$computer | ConvertTo-Csv -NoTypeInformation<\/p>\n

 \nCS, that is all there is to using Windows PowerShell to create a custom object and append to CSV data. Join me tomorrow when I will talk about cool Windows PowerShell stuff.\nI invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.\nEd Wilson, Microsoft Scripting Guy<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy, Ed Wilson, shows how to create a custom Windows PowerShell object to simplify appending to CSV files.   Hey, Scripting Guy!  Yesterday, you talked about creating two objects, exporting them to CSV files, and then manipulating the strings to combine the CSV files. Is there a cleaner way of doing this? —CS […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[169,3,4,45],"class_list":["post-4478","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-csv-and-other-delimited-files","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy, Ed Wilson, shows how to create a custom Windows PowerShell object to simplify appending to CSV files.   Hey, Scripting Guy!  Yesterday, you talked about creating two objects, exporting them to CSV files, and then manipulating the strings to combine the CSV files. Is there a cleaner way of doing this? —CS […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=4478"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4478\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=4478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=4478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=4478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}