Quick way to convert CSV types to original types with PowerShell's Import-Csv cmdlet? -


i'm using powershell v2 , have custom type i've defined called material using code this:

add-type @" public struct material {     public string businessunit;     public string source;     public string primarysource;     public string legacymaterialnumber; } "@

...and i've got collection of objects of type i'm writing csv file using export-csv cmdlet. works fine , produces data original type specified this:

#type material           businessunit,source,primarysource,legacymaterialnumber bu1,nafo,nafo-fg,17502 bu1,nafo,nafo-fg,17504 bu1,nafo,nafo-fg,17739 bu1,nafo,nafo-fg,17837 bu1,nafo,nafo-fg,17841

the issue i'm running when import data using import-csv each line created type:

csv:material

...instead of original type started with:

material

in specific case issue because want pass each material function parameter typed material. parse each row , rebuild material objects data of course, there quick way import csv data original type?

import-csv wants create psobject based type. can create conversion function (or filter) convert material type. pipe output of import-csv function , target array:

filter convert-csvtomaterial([parameter(mandatory=$true,valuefrompipeline=$true)]$csvmaterial) {     $material = new-object -typename material      $material.businessunit = $csvmaterial.businessunit     $material.legacymaterialnumber = $csvmaterial.legacymaterialnumber     $material.primarysource = $csvmaterial.primarysource     $material.source = $csvmaterial.source     $material }  $importedmaterial = import-csv .\materiallist.csv | convert-csvtomaterial

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more