I've had to do this exact same method of populating Zenoss data. I'm sure your excel layout is vastly different from mine, but I can share the process I went though to do this.
This process may be a bit convoluted, but I was making it up as I went along. :wink: First, I convert the Excel spreadsheet to an Open Office format. Once I have the .ods file, I unzipped it to expose it's component files. The content.xml file that's extracted had all the original table data in XML format. I ran xml_pp on the xml file to pretty it up some while I hacked around on a script to parse it. I wrote a perl script with the Twig module to parse and extract all of the field data I needed to feed into Zenoss. It produced a nice flat csv file that I used to feed Zenoss from a zendmd script. I've been learning Python as I go, that is why I started with a perl script to parse the XML. If I were to do it again, I'd write the zendmd script to parse the OO files XML data directly. -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=34723#34723 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
