Skip to main content

Adding Header Data to CSV Files

By
Don’t you just hate it when you get partial information?  With information systems, you would think that you would get everything you need.  It is like when I ask one of my Sailors why they are late and I have to ask a half dozen more questions before I get the full story. (Insert rolling eyes).

A neat thing that I do to demonstrate to my advance PowerShell classes is how to make a GUI using SAPIEN PowerShell Studio.  Yes, I know. PowerShell was not supposed to be ran in a GUI.  Try asking a non-technical user to execute something at the command line.  I would rather visit the dentist.  Placing a pretty GUI on top of the code fools them into wanting to use it.

For our stock application, We download information from Yahoo Finance.  Go ahead and execute the code below.

$Sym = "Msft"
$URL = "http://finance.yahoo.com/d/quotes.csv?s=$Sym&f=snl1ghjkvw4P2"
Invoke-RestMethod -Uri $URL


"Msft","Microsoft Corporation",72.58,72.49,73.42,55.61,74.42,22184949,N/A,"-0.17%"


As you can see from the output, this is comma delimited information. You also may notice is that we are missing information.  Do you see what is missing? We are missing the header information that tells us the property names.  It is not part of the data received.  No problem.  We are free to create our own property names.  To do this, we are going to use ConvertFrom-CSV and use its parameter –Header.  Reading the help file for ConvertFrom-CSV, we see that we need to provide a comma separated list of property names.  The order of the names need to match the order that the data is received. Just remember that these names are the values of the -Header parameter.  Do not place the entire string in quotes. Provide a normal comma separated.

$Sym = "Msft"
$URL = "http://finance.yahoo.com/d/quotes.csv?s=$Sym&f=snl1ghjkvw4P2"
$Data = Invoke-RestMethod -Uri $URL
$Data | ConvertFrom-csv -Header Symbol,Name,Ask,Low,High,Low52,High52,Volume,DayChange,ChangePercent

        
Symbol        : Msft
Name          : Microsoft Corporation
Ask           : 72.58
Low           : 72.49
High          : 73.42
Low52         : 55.61
High52        : 74.42
Volume        : 22185420
DayChange     : N/A

ChangePercent : -0.17% 
Labels:

Comments

Post a Comment

Popular posts from this blog

How to list all the AD LDS instances on a server

By
AD LDS allows you to provide directory services to applications that are free of the confines of Active Directory.  To list all the AD LDS instances on a server, follow this procedure: Log into the server in question Open a command prompt. Type dsdbutil and press Enter Type List Instances and press Enter . You will receive a list of the instance name, both the LDAP and SSL port numbers, the location of the database, and its status.
Post a Comment
Read more

How to run GPResult on a remote client with PowerShell

By
In the past, to run the GPResult command, you would need to either physically visit this client, have the user do it, or use and RDP connection.  In all cases, this will disrupt the user.  First, you need PowerShell remoting enabled on the target machine.  You can do this via Group Policy . Open PowerShell and type this command. Invoke-Command –ScriptBlock {GPResult /r} –ComputerName <ComputerName> Replace <ComputerName> with the name of the target.  Remember, the target needs to be online and accessible to you.
Post a Comment
Read more

Error icon when creating a GPO Preference drive map

By
You may not have an error at all.  Take a look at the drive mapping below. The red triangle is what threw us off.  It is not an error.  It is simply a color representation of the Replace option of the Action field in the properties of the drive mappings. Create action This give you a green triangle. The Create action creates a new mapped drive for users. Replace Action The Replace action gives you a red triangle.  This action will delete and recreate mapped drives for users. The net result of the Replace action is to overwrite all existing settings associated with the mapped drive. If the drive mapping does not exist, then the Replace action creates a new drive mapping. Update Action The Update action will have a yellow triangle. Update will modify settings of an existing mapped drive for users. This action differs from Replace in that it only updates settings defined within the preference item. All other settings remain as configured on the ma...
1 comment
Read more