From 134560a32d52329a59906de5392e69df9608368c Mon Sep 17 00:00:00 2001
From: Georg
Date: Sun, 2 Jan 2022 06:36:15 +0100
Subject: Init libvirt-xml2netbox-csv.py v1

Signed-off-by: Georg <georg@lysergic.dev>
---
 scripts/python/libvirt-xml2netbox-csv.py | 79 ++++++++++++++++++++++++++++++++
 1 file changed, 79 insertions(+)
 create mode 100755 scripts/python/libvirt-xml2netbox-csv.py

diff --git a/scripts/python/libvirt-xml2netbox-csv.py b/scripts/python/libvirt-xml2netbox-csv.py
new file mode 100755
index 0000000..f9ba866
--- /dev/null
+++ b/scripts/python/libvirt-xml2netbox-csv.py
@@ -0,0 +1,79 @@
+#!/usr/bin/python3
+import os
+import xml.etree.ElementTree as xmlet
+import pandas
+import math
+
+outfile = 'xxx.csv'
+
+columns = [ "name", "status", "role", "cluster", "tenant", "platform", "vcpus", "memory", "disk", "comments" ]
+rows = []
+
+domaindir = 'xmls/domains'
+diskdir = 'xmls/disks'
+
+status = 'Active'
+cluster = 'xxx'
+tenant = 'xxx'
+comment = 'Imported from libvirt. Manual verification pending.'
+
+for domainxml in os.listdir(domaindir):
+    domainparse = xmlet.parse(domaindir + "/" + domainxml)
+    domainroot = domainparse.getroot()
+
+    name = domainroot.find("name").text
+    vcpus = domainroot.find("vcpu").text
+    memory = int(domainroot.find("memory").text)
+    memorysize = round(memory*0.001024)
+    diskxml = diskdir + "/" + name + ".disk.export.xml"
+    diskparse =  xmlet.parse(diskxml)
+    diskroot = diskparse.getroot()
+    diskcapacity = int(diskroot.find("capacity").text)
+    disksize = round(diskcapacity / (math.pow(1024, (int(math.floor(math.log(diskcapacity, 1024)))))))
+    
+    while True:
+        role_choice = input ("Assign a role for " + name + ":\n1) Internal Client\n2) Internal Server\n3) ???\n4) ???\n> ")
+        if role_choice == "1":
+            role = "Virtual Machine (Internal, Client)"
+            break
+        if role_choice == "2":
+            role = "Virtual Machine (Internal, Server)"
+            break
+        if role_choice == "3":
+            role = "Virtual Machine (Customer)"
+            break
+        if role_choice not in ["1", "2", "3"]:
+            print("Invalid choice.")
+
+    while True:
+        platform_choice = input ("Assign platform for " + name + ":\n 1) openSUSE-x86_64\n2)OpenBSD-x86_64\n3)FreeBSD-x86_64\n> ")
+        if platform_choice == "1":
+            platform = "openSUSE-x86_64"
+            break
+        if platform_choice == "2":
+            platform = "OpenBSD-x86_64"
+            break
+        if platform_choice == "3":
+            platform = "FreeBSD-x86_64"
+            break
+        if platform_choice not in ["1", "2", "3"]:
+            print("Invalid choice.")
+
+    rows.append(
+            {
+                "name": name,
+                "status": status,
+                "role": role,
+                "cluster": cluster,
+                "tenant": tenant,
+                "platform": platform,
+                "vcpus": vcpus,
+                "memory": memorysize,
+                "disk": disksize,
+                "comments": comment
+            }
+    )
+
+convert = pandas.DataFrame(rows, columns=columns)
+convert.to_csv(outfile, index=False)
+
-- 
cgit v1.2.3