From: EdTheDev Date: Sun, 19 Nov 2023 04:02:57 +0000 (-0600) Subject: WIP Add-Addresses X-Git-Url: https://us-delaporte.pagekite.me/gitweb/dotfiles.git/commitdiff_plain/0da19501333ce0b24970b1c065a54ed6f24e487b WIP Add-Addresses --- diff --git a/files/Microsoft.PowerShell_profile.ps1 b/files/Microsoft.PowerShell_profile.ps1 index 04d9c45..e3d7719 100644 --- a/files/Microsoft.PowerShell_profile.ps1 +++ b/files/Microsoft.PowerShell_profile.ps1 @@ -28,6 +28,7 @@ $env:psmodules = "$env:dotfiles\psmodules" Import-Module "$env:psmodules\dash.psm1" Import-Module $env:PSModules\file_management.psm1 Import-Module "$env:psmodules\fix_vpn.psm1" +Import-Module $env:PSModules\house_shopping.psm1 # Let's face it, I'm about to cd into my source directory if((Get-Location).Path -eq $HOME){ cd $env:src } diff --git a/psmodules/house_shopping.psm1 b/psmodules/house_shopping.psm1 index 33ad6a2..c9f58d7 100644 --- a/psmodules/house_shopping.psm1 +++ b/psmodules/house_shopping.psm1 @@ -1,22 +1,30 @@ function Add-Addresses(){ Param( - [string]$addressFile = "Addresses.csv" + [string]$addressFile = "Addresses.csv", [string]$outFile= "Address_Details.csv" ) + Copy-Item $outFile "$outFile.backup" $addressList = Get-Content $addressFile | ConvertFrom-Csv $details = Get-Content $outFile| ConvertFrom-Csv + $results = [System.Collections.ArrayList]@() + $details | ForEach-Object { + $idx = $results.Add($_) + } $addressList | ForEach-Object { if($details -NotContains $_.Address) { - $details.Address = $_.Address - $details.SqFt = $_.SqFt - $details.Cost = $_.Cost + $idx = $results.Add($_) + Write-Host "Aadded " + $_.Address } } - $details | Export-Csv -NoTypeInformation -Path $outFile - Write-Host "Updated $outFile" + $results | Format-Table + $answer = Read-Host -Prompt "Write updated file? y/N" + if($answer -Eq "y") { + $results | Export-Csv -NoTypeInformation -Path $outFile + Write-Host "Updated $outFile" + } } @@ -24,6 +32,7 @@ function Add-AddressLocations(){ Param( [string]$outFile= "Address_Details.csv" ) + Copy-Item $outFile "$outFile.backup" $details = Get-Content $outFile| ConvertFrom-Csv $details | ForEach-Object { @@ -34,7 +43,8 @@ function Add-AddressLocations(){ $_.Lon = $posit.Lon } } - $details | Export-Csv -NoTypeInformation -Path $outFile + $details | Format-Table + # $details | Export-Csv -NoTypeInformation -Path $outFile Write-Host "Updated $outFile" }