Hyper-V VMs crash when any SAN volume is expanded
I'm managing a two-node Windows Server 2022 Hyper-V failover cluster connected to an HPE MSA SAN over iSCSI. We have roughly 40 virtual machines. The VM roles and…
csv
Hyper-V VMs crash when any SAN volume is expanded
I'm managing a two-node Windows Server 2022 Hyper-V failover cluster connected to an HPE MSA SAN over iSCSI. Around 40 virtual machines use the SAN for storage. We've…
How do I keep commas inside names from splitting CSV columns in AWS?
I'm uploading a CSV file to AWS so I can query it with SQL, but names that contain commas are being split across multiple columns. For example, a…
Can Someone Help Me Review My PowerShell Script?
I'm learning PowerShell scripting and I'm hoping someone could check the syntax and functionality of my script so I can nail my job performance. The script imports the…
How to Fix Get-ADComputer CSV Output Showing as Multiple Lines in Excel?
I'm having some trouble with the output from the Get-ADComputer command when exporting it to CSV. Most entries look fine, like this: mot.sz0144/WinServ Backup Server/Z001S001LBS01 [10.1.1.71](http://10.1.1.71) 10/7/2023 15:52,…
How can I process 50 rows from a large CSV file daily without repeating?
I'm working with a large CSV file that has 10,000 rows and I need to run some PowerShell commands on 50 rows each day. Once I process those…
How can I import contacts into a new Yahoo account from a CSV file?
I used to be able to import and export contacts through CSV files in the old Yahoo interface. However, a friend of mine recently created a new Yahoo…
How do you usually clean up messy CSV and JSON data before processing?
I often find myself dealing with messy data, especially when working with third-party exports and API responses. Issues I frequently encounter include CSV files that have inconsistent column…
How can I import users from a CSV file using PowerShell?
I'm working on a script to import users from a CSV file that contains columns like Firstname, Lastname, Group, and OU, separated by semicolons. However, I'm having trouble…
How to Find Microsoft Visio and Power Apps Usage in PowerShell?
Hi everyone! I'm looking for some assistance with scripting in PowerShell to track the usage of Visio and Power Apps within our Microsoft 365 tenant. We have licenses…
How to Effectively Use a CSV File as a Backend for a Machine Learning Project?
I'm currently working on a machine learning project where I'm using a CSV file as a makeshift database. I have products and their attributes, like price, description, and…
How Can I Compare Two CSV Files with Slightly Different Key Fields?
I'm trying to compare two CSV files using the command line, but there's a bit of a catch. In one file, the key field (PartNo) sometimes ends with…
How can I bulk rename multiple folders using a CSV file?
I'm looking for a way to bulk rename hundreds of folders based on a CSV file I have. The CSV contains the full paths for the original and…
How Can I Export User Group Memberships in Bulk?
I'm looking for a way to provide a list of groups that each user is a member of from a CSV file. Is there a method to do…
How to Parse Hierarchical CSV Data for University Departments?
Hey everyone! I've been trying to figure out how to parse a CSV file that contains a hierarchical list of departments at my university. Each department has sub-departments…
What’s this strange script doing in my GitHub repo?
I was going through one of my GitHub repositories when I stumbled upon this script at the top of my index.html file, which I definitely don't remember adding:…
What's the Best Data Storage System for Fast Random Access to Tabular Data?
I've been using CSV files to store tabular data in my projects, but with a new project that includes thousands of tables with about a million rows each,…
How to Compare Substrings from Two CSV Files in PowerShell?
I'm new to PowerShell and I'm working on a project involving two CSV files. One CSV is imported from ConfigMgr, containing "SerialNumbers, Name". The other is from our…
Looking for Advice on Courthouse Lobby Signage Setup
Hey everyone, I work at a Clerk of Court office and I'm working on a project to help visitors easily find their way when they enter the courthouse.…
How can I convert a PDF file to a CSV for my wedding place cards?
I'm trying to get a large PDF file converted into CSV format for my wedding place cards, as my printer requested it that way. I'm not very tech-savvy…