Yep, you read right - it's available.
Go grab it and give it a thrashing.
All previous Bugs should have been addressed.
http://www.open-audit.org/OAv2_03.zip
Thursday, June 10, 2010
Import / Export in OAv2
I have the import and export routines working for Devices, Locations and Organisations. Excel only at this stage.
One interesting aspect was the need to alter the network group creation routine. Think of a network device that you know about, but don't know specific IP details. IE - you know it's IP Address, but what about it's configured subnet ? What about it's MAC Address ? A lot of people will not know the details. So now network group creation has to account for IP Addresses in the system table - not just the sys_hw_networkcard_ip table. Interesting, but all good and working.
Any report type page (ie - a list of "All Devices") now has a shiny little button (an Excel icon). Click it and you can download & open the resulting Excel spreadsheet. At the moment it's a straight data dump, so things like column headings come direct from the DB. I will have to make another option that removes certain columns and alters the column headings (IE - man_ip_address would become IP Address, system_id would disappear altogether, etc). This would make two styles of output - a dump and a report. Will address this later on.
I think that's good enough for a release. Give me a few hours (when I get home from work) and I'll post again with release details.
Any help debugging would be appreciated.
One interesting aspect was the need to alter the network group creation routine. Think of a network device that you know about, but don't know specific IP details. IE - you know it's IP Address, but what about it's configured subnet ? What about it's MAC Address ? A lot of people will not know the details. So now network group creation has to account for IP Addresses in the system table - not just the sys_hw_networkcard_ip table. Interesting, but all good and working.
Any report type page (ie - a list of "All Devices") now has a shiny little button (an Excel icon). Click it and you can download & open the resulting Excel spreadsheet. At the moment it's a straight data dump, so things like column headings come direct from the DB. I will have to make another option that removes certain columns and alters the column headings (IE - man_ip_address would become IP Address, system_id would disappear altogether, etc). This would make two styles of output - a dump and a report. Will address this later on.
I think that's good enough for a release. Give me a few hours (when I get home from work) and I'll post again with release details.
Any help debugging would be appreciated.
Monday, June 7, 2010
Nearly ready for another release
What have I been doing on OAv2 ?
Well, for one thing, creating routines so you can import your devices / locations / organisations from a spreadsheet. Most places can easily conjure up a listing of relevant data - most often in a spreadsheet. The import routines for Locations and Organisations are complete, I just need to finish off Devices (which I have working in test code).
I also have nearly finished the routine to export any Report to Excel, PDF or CSV. Thanks PHPExcel !
I've also completed the Group Edit pages so they don't break auto-created Groups.
Give me a couple of days to finish up and another release will be available.
Well, for one thing, creating routines so you can import your devices / locations / organisations from a spreadsheet. Most places can easily conjure up a listing of relevant data - most often in a spreadsheet. The import routines for Locations and Organisations are complete, I just need to finish off Devices (which I have working in test code).
I also have nearly finished the routine to export any Report to Excel, PDF or CSV. Thanks PHPExcel !
I've also completed the Group Edit pages so they don't break auto-created Groups.
Give me a couple of days to finish up and another release will be available.
Subscribe to:
Posts (Atom)
Posts
