@barioucha
-
IT Consultant replied to the topic Create Folder based on CSV file with PowerShell in
PowerShell Forum 1 week, 6 days ago
Thank you 🙂
I didn’t express myself correctly, I’m sorry.
the CSV folder is created for each customer as it will contain additional data.
My basic CSV file includes key information on all customers.
for instance, each client file must have subdirectories named, [CSV], [Excel], [HTML]…etc.for sure if the subdirectorie if it’s already created it should not be created again 🙂
-
-
IT Consultant replied to the topic Create Folder based on CSV file with PowerShell in
PowerShell Forum 2 weeks, 1 day ago
First of all, I would like to thank you very much, because not only is the problem solved, but I learned from these few lines, Thank you.
I know those two values are tied to $Customer.Customer, $Customer.Info, and besides this allowed me to go further and it allowed me to identify errors in my CSV by adding more values.
The parameter “- f” I did not understand what it corresponds to:).
I would like to take advantage of your level and experience and I wanted to have your opinion to add folders “- CSV- EXCEL-…” for each client what is the best way to proceed?
-
IT Consultant replied to the topic Create Folder based on CSV file with PowerShell in
PowerShell Forum 2 weeks, 5 days ago
with test-path is not working 🙁
$Names = Import-Csv -Delimiter "," -Path "$PSScriptRootInfo.csv" | Select-Object customer, info $Folders = Set-Location -Path "$PSScriptRootCollection" foreach($customer in $Names){ if (-not (Test-Path $Folders)) { New-Item -Path $Folders -Name ($($customer.customer)+" "+$($customer.info)) -ItemType Directory Write-Host -ForegroundColor Green "`tfolder $($client.client)" "$($client.cluster) created" } else { Write-Host -ForegroundColor White "`tfolder $($client.client)" "$($client.cluster) exist" } }
-
IT Consultant started the topic Create Folder based on CSV file with PowerShell in
PowerShell Forum 2 weeks, 6 days ago
I have a CSV file and I would like to create folders based on 2 columns from that CSV file.
$Folders = Import-Csv -Path ".data.csv" -Delimiter ";" | Select-Object info1, info2
I’m able to get info1 and info2 but not able to test if the folder already exists or not.
If not then the script should create it like this *info1 info2*
-
IT Consultant replied to the topic Export CSV to one Excel file with separate worksheets in
PowerShell Forum 3 weeks, 1 day ago
Hi @figueroa2david
Thank you for your help it’s working 🙂I have another question 🙂
My CSV file is named like this :
$csvInfo = "$($clients)" + " " + $dateFormat + "_Info.csv"
Is there any way to split that name and just use “_Info.csv” as worksheetname?
-
IT Consultant replied to the topic Export CSV to one Excel file with separate worksheets in
PowerShell Forum 1 month, 2 weeks ago
Yes 🙂
In my script I generate like 6 CSV data files and I would like to find away to export them direct in one Excel file each CSV in separate spreadsheet 🙂
Maybe some help from experience one that can collaborate with me to achieve this 🙂
-
IT Consultant posted a new activity comment 1 month, 2 weeks ago
Thank you for your reply, I will give a try, because my idea is to add a script in my current one in order to export all CSV generated
-
IT Consultant started the topic Export CSV to one Excel file with separate worksheets in PowerShell Forum 1 month, 2 weeks ago
I have a script that allows me to collect information in CSV. I need the result to be exported to a single Excel file each in a separate worksheet. I’m not sure where to start someone could help me.
-
IT Consultant posted an update in the group
PowerShell 1 month, 2 weeks ago
I have a script that allows me to collect information in CSV. I need the result to be exported to a single Excel file each in separate worksheet. I’m not sure where to start someone could help me.
-
Better post questions in the forum. More people will see it there.
-
Download the ImportExcel module by Doug Finke. You can export your CSV directly to an Excel file (no Excel is actually needed). You literally just $CSV | Export-Excel -path [path] -worksheetname [name]
Coralon
-
-
IT Consultant replied to the topic Format PowerShell parameters with colors in
PowerShell Forum 1 month, 2 weeks ago
Thank you for your help.
As I’m new in powershell and I’m trying to learn more 🤗🤗
-
IT Consultant started the topic Format PowerShell parameters with colors in
PowerShell Forum 1 month, 2 weeks ago
Hi Folks;
Maybe it’s a stupid question but I would like to format the below param with colors, not sure if it’s possible or not 🙂
param(
[parameter(Mandatory)]
[String]$Server,
[parameter(Mandatory)]
[string]$Report
) -
IT Consultant posted an update 2 months, 2 weeks ago
Hello community 😊
I’m new here and I would like to know more about powershell and powercli.Not sure from where I can start can someone help me with the best way to learn this program
Thank you in advance
-
Welcome to the community. I would say you first need to start with PowerShell since PowerCLI uses the concepts and syntax of PowerShell. To get started, you could use the below MVA link, where Jason and Jeffrey explained everything in detail:
https://learn.microsoft.com/en-us/shows/getting-started-with-microsoft-powershell/Additionally, you can also follow PowerShell forum and PowerShell group at 4sysops.com, where you can ask questions and get help from experts:
https://4sysops.com/groups/powershell/forum/
https://4sysops.com/groups/powershell/
https://4sysops.com/groups/powershell/wiki/Happy learning 🙂
-
-
-
-