-
Excel Export does not give us the purchase date and age of devices. Can I modify this or can I query the database directly?.
2009-12-17 03:11:31 UTC by tdiponio
-
Attached is a small Perl script that I use for bulk importing devices. I've tried to comment it, at least in a basic way, but it is *NOT* bulletproof. It works for me. See the file for full details.
The program takes a tab separated input file and prints SQL INSERT statements that can be used for importing data into your database of choice.
2009-12-08 16:17:18 UTC by hawson
-
The database schema is pretty simple, and a DBA should be able to make quick work of a CSV file.
That said, a generalized import script is tricky to write (but not impossible), since various tables have to be populated before the actual devices can be entered. For example, you have to define the racks and hardware type in two separate tables before you can add a specific device.
2009-12-08 16:13:58 UTC by hawson
-
The database schema is pretty simple, and a DBA should be able to make quick work of a CSV file.
That said, a generalized import script is tricky to write (but not impossible), since various tables have to be populated before the actual devices can be entered. For example, you have to define the racks and hardware type in two separate tables before you can add a specific device.
2009-12-08 16:13:08 UTC by hawson
-
Hi
As for today we've got a MS Excel table with all our racks and devices. Now since there are around 600 devices in our data center, it'd be way too much work to list them all again. So my question: is there a possible way of importing those data from like a csv file?
Greetings.
2009-12-04 09:14:07 UTC by nobody
-
Hi
As for today we've got a MS Excel table with all our racks and devices. Now since there are around 600 devices in our data center, it'd be way too much work to list them all again. So my question: is there a possible way of importing those data from like a csv file?
Greetings.
2009-12-04 08:02:27 UTC by nobody
-
I think, if you add some virtual type of rack, many people can use this like store management software. I thing its good idea.
2009-11-24 12:18:25 UTC by nobody
-
Hi Will,
We are using rackmonkey to keep track of all our data centers' hardware.
I've modified some of your code to add power consumption information to the hardware class. I can see my modifications to the html templates but I'm not seeing any modification to engine.pm reflected in the web application's behavior. Do you think I need a full apache restart? I though touching files only...
2009-11-18 12:26:00 UTC by gbandoni
-
Can you add more fields for the devices like IP, Mac Address... etc.
2009-11-09 13:31:46 UTC by nobody
-
I know you're working on adding power records as a feature and I hope you're close to completing it! We're using an old in-house application and we love yours. However, we can't completely switch over to yours until power is added because we can't create our power reports without it.
I've attached a screenshot of where power is applied through the hardware in our app. We also have another...
2009-10-13 15:01:17 UTC by nobody
