troubleshooting Question

csv design help

Avatar of notta3d
notta3dFlag for United States of America asked on
Windows XPVB ScriptProgramming Theory
2 Comments1 Solution366 ViewsLast Modified:
Hey guys, I currently have a script written in AutoIt that our team uses to run on every machine we work on. Basically the script prompts for information such as first name, last name, room, building,..... It also pulls some information in the background like model, serial number, IP address, and so on. Once the submit button is hit the file is copied to a share on our server in a computername.csv file. We have about 1000 computername.csv files on the server(1 for each machine.) This has been working really well and now I want to take it to the next level.
Now I want to start gathering some more info such as all the software installed on the machine and maybe the hardware information. The problem I'm having is that when I start gathering variable things like software installed or hardware I don't know the best way to format the csv file. What I mean is the current csv file is in the form of firstname,lastname,room,building,serial,ipaddress,model, and so on. It's really nice right now because all I have to do is open the file, read in the one line, split the line into an array and then I can access any element I want because I know each position is the same in each file. Meaning array[1] is always firstname.
With the amount of software being different on each machine I lose the ability to access each element. See what I mean? I know you guys are going to say use a database for this, but that is something for down the road, but right now I have to work with the csv files. Can you guys help me find the best way to design the file format? Thanks guys.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros