WadeSansing
MIS
I am using a little program named Aida32 System info tool to gather info on my networked computers. It saves out the info to where each of 6 items is listed and it's value is in the next field e.g.
Report, blank, computer, 256, computer name, Bob
Report, blank, computer, 257, OS, win2k
Report, blank, computer, 258, CPU, P-IV 1ghz
Report, blank, computer, 259, Ram, 256meg
And so on ... I really don't need the first 4 fields at all and would like to use the either 4th or 5th fields as a key. the programs generates a csv when the user logs in to each computers so I'll get 50 or so of these each day. My problem is that I want to import the data into a DB so that the 5th field is the column title and the 6th field would go into a single row. e.g.
Computer Name OS CPU RAM
Bob win2k PIV-1ghz 256meg
Sally win98 PII-250mhz 64meg
and so on ... so that each csv file gets imported as a record and not as a table of its own. The other problem I have with this is that sometimes there are multiples of a single number such as dual Hard drives, or dual video cards. When that happens the 4th and 5th fields of two different rows are the same, but need to either import as different fields or the value listed in the 6th row needs to merge into the value of the last one. e.g.
Report, blank, computer, 255, Hard Drive, 30 gig
Report, blank, computer, 255, Hard Drive, 10 gig
Report, blank, computer, 258, CPU, P-IV 1ghz
Report, blank, computer, 259, Ram, 256meg
so this needs to some out like
Computer Name OS CPU Hard Drive Hard Drive2
Bob win2k PIV-1ghz 30 gig 10 gig
or like
Computer Name OS CPU Hard Drive
Bob win2k PIV-1ghz 30 gig, 10 gig
Either way it doesn't matter to me. I just need to be able to do this for maintining an inventory of all the computers in my company. Aida32 is a free program and will run silently from a command line so by putting it in a shared directory and adding a command to the user login script I can keep up with CPU's and even installed software. I probably will not really do this more than a couple of times a year so it doesn't need to be super automated, I just need to know how I can import each of the csv files created as a record into the database. Even if I could do a normal import of each csv as a table and then have query or for or another table or something that will let me effectively view each computer as a record instead of each peice of the computer as an item on 50 different tables.
Any help I can get would be greatly appreciated.
Report, blank, computer, 256, computer name, Bob
Report, blank, computer, 257, OS, win2k
Report, blank, computer, 258, CPU, P-IV 1ghz
Report, blank, computer, 259, Ram, 256meg
And so on ... I really don't need the first 4 fields at all and would like to use the either 4th or 5th fields as a key. the programs generates a csv when the user logs in to each computers so I'll get 50 or so of these each day. My problem is that I want to import the data into a DB so that the 5th field is the column title and the 6th field would go into a single row. e.g.
Computer Name OS CPU RAM
Bob win2k PIV-1ghz 256meg
Sally win98 PII-250mhz 64meg
and so on ... so that each csv file gets imported as a record and not as a table of its own. The other problem I have with this is that sometimes there are multiples of a single number such as dual Hard drives, or dual video cards. When that happens the 4th and 5th fields of two different rows are the same, but need to either import as different fields or the value listed in the 6th row needs to merge into the value of the last one. e.g.
Report, blank, computer, 255, Hard Drive, 30 gig
Report, blank, computer, 255, Hard Drive, 10 gig
Report, blank, computer, 258, CPU, P-IV 1ghz
Report, blank, computer, 259, Ram, 256meg
so this needs to some out like
Computer Name OS CPU Hard Drive Hard Drive2
Bob win2k PIV-1ghz 30 gig 10 gig
or like
Computer Name OS CPU Hard Drive
Bob win2k PIV-1ghz 30 gig, 10 gig
Either way it doesn't matter to me. I just need to be able to do this for maintining an inventory of all the computers in my company. Aida32 is a free program and will run silently from a command line so by putting it in a shared directory and adding a command to the user login script I can keep up with CPU's and even installed software. I probably will not really do this more than a couple of times a year so it doesn't need to be super automated, I just need to know how I can import each of the csv files created as a record into the database. Even if I could do a normal import of each csv as a table and then have query or for or another table or something that will let me effectively view each computer as a record instead of each peice of the computer as an item on 50 different tables.
Any help I can get would be greatly appreciated.
