Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Trouble with a CSV Import RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,
     
    I am wondering if there are any <g class="gr_ gr_19 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="19" id="19">powershell</g> gurus out there that can give me a hand.
     
    I am importing a CSV file into a <g class="gr_ gr_30 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="30" id="30">PScustom</g> object (that acts as an array), with 4 columns and need to add entries to the object further <g class="gr_ gr_31 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="31" id="31">along in</g> the script. When I try to do this and put the data in columns, I get the pleasant response of Cannot find an overload for "Add" and the argument count: "4".
     
    A simplified version of the code:
     
    $Localadmins = import-csv "c:\admins.csv"
$Local Admins

Scope  Admin      Server    Type      
-----  -----      ------    ----      
Domain John.Smith SRV-SQL01 LocalAdmin
Local  svc_sql    SRV-SQL01 LocalAdmin

$LocalAdmins.Add("Domain", "Frank.Zappa", "SRV-SQL01", "LocalAdmin")

Cannot find an overload for "Add" and the argument count: "4".
At line:1 char:16
     

    I have spent a couple hours researching this and am a bit stumped, happy to provide more info.

    Thanks,

     

    • Edited by Jester80 Tuesday, November 21, 2017 1:35 PM
    • Moved by Bill_Stewart Friday, March 9, 2018 7:38 PM Unreadable
    Tuesday, November 21, 2017 1:34 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    1. When you paste text here please make sure there are no crappy html codes included plaese. Your post is almost unreadable.

    2. When you want to "export" something to a CSV file you can use Export-CSV to do so  … that could be one way
    [PSCustomObject]@{
Scope = "Domain";
Admin = "Frank.Zappa";
Server = "SRV-SQL01";
Type =  "LocalAdmin";
} | Export-Csv -Path <path to your csv file> -Delimiter ',' -NoTypeInformation -Append

    Best regards,

    (79,108,97,102|%{[char]$_})-join''



    • Edited by BOfH-666 Tuesday, November 21, 2017 2:12 PM
    Tuesday, November 21, 2017 2:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Except for appending , as advised by BOfH_666, you can also use calculated properties:

    $LocalAdmins | select *, @{n="Scope";e={"Domain"}}, @{n="Admin";e={"Frank.Zappa"}}, @{n="Server";e={"SRV-SQL01"}}, @{n="Type";e={"LocalAdmin"}}

    The "n" (name) part of each calculated property reflects your column name from the csv, whereas the "e" (expression) part reflects its value. It's a useful method if you're looping through a number of objects with foreach, for example; you can then store your expression in a variable and call that variable while calculating properties.

    Tuesday, November 21, 2017 4:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The question, if the OP would fix the crappy post, seems to be how to add a row to an existing CSV.

    The answer is to clone a row and modify it then add it to the original.  Do you know how to "clone"?

    \_(ツ)_/

    Tuesday, November 21, 2017 5:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As an alternative we can use ConvertTo-DataTable to build an object that can be extended using and array.

    $dt = $csv | ConvertTo-Datatable
$dt.Rows.Add((@( .... values ...))
$dt | Export-Csv ...

    \_(ツ)_/

    Tuesday, November 21, 2017 5:22 PM