Insert data to powershell

Question

Im doing an archive process and I want to insert the results to a CSV file. The process will looks like,

$source_path="D:\backup"
$destination="E:\backup"
$start_datetime=date
copy source target
$end_datetime=date

CSV file looks like

Date | Start | end | Source | Destination

I want to insert the below data.

DATE = today's date.
Start = $start_datetime
end = $end_datetime
Source = $source_path
Destination=$destination

I tried some ways to write data into CSV, but I couldn't reach the exact thing.

Can anyone help me on this?

G42 · Accepted Answer · 2018-08-16 17:51:56Z

1

Look into psobjects - Example guide

For example:

[array]$myObject = [pscustomobject]@{
    DATE = today's date.
    Start = $start_datetime
    end = $end_datetime
    Source = $source_path
    Destination=$destination
}

$myObject | Export-Csv C:\temp\myfile.csv

Edit - I'm not sure how you'll be using Export-Csv. So I will give a couple of examples. However, this really goes beyond the scope of just exporting CSVs as asked. I would recommend rewriting it with more detail about the requirements, or breaking it into several questions.

foreach($thing in $things){

    # increment array with multiple rows
    [array]$myObject += [pscustomobject]@{
        DATE = today's date.
        Start = $start_datetime
        end = $end_datetime
        Source = $source_path
        Destination=$destination
    }
}

# add data to an existing csv, which has the heading DATEM Start, end, Source, Destination
$myObject | Export-Csv C:\temp\myfile.csv -Append

# if/else logic
if($end_time -gt $somevariable){
    [array]$myObject = [pscustomobject]@{
        DATE = today's date.
        Start = $start_datetime
        end = $end_datetime
        Source = $source_path
        Destination=$destination
    }         
}else{
    [array]$myObject = [pscustomobject]@{
        DATE = someotherdate
        Start = $start_datetime
        end = $end_datetime
        Source = $source_path
        Destination=$destination
    }
}

edited Aug 16, 2018 at 17:51

answered Aug 16, 2018 at 17:13

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

3 Comments

TheDataGuy Over a year ago

Thanks, But every execution, this CSV file is replaced with the new data, I want to keep upto date.

G42 Over a year ago

Do you mean you want to add to the csv each time the script is ran? So keep old data and add new data?

TheDataGuy Over a year ago

Because, the sync file sometimes < 1GB sometimes > 30GB, so based on the end_time, I can come up with which date synced more data. For this I need to track it. Like wise, one more sync scripts with different Export to CSV i'll prepare

Bacon Bits · Accepted Answer · 2018-08-16 18:03:36Z

1

You've provided few specific details and only sparse pseudocode, so it's difficult to tell exactly what you're doing or exactly what you want. However, if you just want to append a record to a CSV file, Export-Csv has an -Append switch. You can pipe a custom object to Export-Csv as you go.

[PSCustomObject]@{
    DATE = today's date.
    Start = $start_datetime
    end = $end_datetime
    Source = $source_path
    Destination=$destination
} | Export-Csv -Path $CsvFile -Append -NoTypeInformation

answered Aug 16, 2018 at 18:03

Bacon Bits

32.5k6 gold badges64 silver badges79 bronze badges

1 Comment

TheDataGuy Over a year ago

Thanks for sharing, it helps

Collectives™ on Stack Overflow

Insert data to powershell

CSV file looks like

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

CSV file looks like

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related