forum.opsi.org

opsi support forum
https://forum.opsi.org/

csv Import von Clients

https://forum.opsi.org/viewtopic.php?t=14540

Seite 1 von 1

csv Import von Clients

Verfasst: 27 Mär 2025, 12:37
von holgy58
Hallo zusammen,
ich habe eine größere Menge an Clients die ich gern per csv importieren möchte.

Eine Vorlage habe ich exportiert und zum Test befüllt
Screenshot 2025-03-27 123414.png
Screenshot 2025-03-27 123414.png (8.15 KiB) 4775 mal betrachtet
Leider bekomme ich eine Fehlermeldung
Screenshot 2025-03-27 123127.png
Screenshot 2025-03-27 123127.png (19.59 KiB) 4775 mal betrachtet
Was mache ich falsch?

Hier noch der log Eintrag

Code: Alles auswählen

[3] [2025-03-27 14:10:37.982] [AWT-EventQueue-0] Es ist ein unerwarteter Fehler aufgetreten. Index 13 out of bounds for length 13 
 Bitte die Logdatei überprüfen. 
java.lang.IndexOutOfBoundsException: Index 13 out of bounds for length 13
	at java.base/jdk.internal.util.Preconditions.outOfBounds(Unknown Source)
	at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Unknown Source)
	at java.base/jdk.internal.util.Preconditions.checkIndex(Unknown Source)
	at java.base/java.util.Objects.checkIndex(Unknown Source)
	at java.base/java.util.ArrayList.get(Unknown Source)
	at de.uib.opsidatamodel.serverdata.dataservice.HostDataService.createClients(HostDataService.java:106)
	at de.uib.configed.ServerActionManager.createClients(ServerActionManager.java:56)
	at de.uib.configed.gui.NewClientDialog.createClients(NewClientDialog.java:449)
	at de.uib.configed.gui.NewClientDialog.importCSV(NewClientDialog.java:619)
	at de.uib.configed.gui.NewClientDialog.lambda$createNorthPanel$2(NewClientDialog.java:394)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
	at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.desktop/java.awt.Component.processEvent(Unknown Source)
	at java.desktop/java.awt.Container.processEvent(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
	at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 09:23
von holgy58
Hat hier wirklich noch niemand eine Clientliste per csv importiert ??

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 10:29
von fheithausen
Hallo holgy58,

Ich bekomme beim versuchten Import den gleichen Fehler.

Code: Alles auswählen

[1] [2025-03-31 10:09:13.174] [main           ] Configed version 4.3.6.5  ( 2025-02-24 ) starting 
[4] [2025-03-31 10:09:23.424] [AWT-EventQueue-0] setting file savedStatesDir writable failed
[4] [2025-03-31 10:10:29.121] [AWT-EventQueue-0] Error in thread  Thread[#33,AWT-EventQueue-0,6,main] 
java.lang.IndexOutOfBoundsException: Index 13 out of bounds for length 13
	at java.base/jdk.internal.util.Preconditions.outOfBounds(Unknown Source)
	at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Unknown Source)
	at java.base/jdk.internal.util.Preconditions.checkIndex(Unknown Source)
	at java.base/java.util.Objects.checkIndex(Unknown Source)
	at java.base/java.util.ArrayList.get(Unknown Source)
	at de.uib.opsidatamodel.serverdata.dataservice.HostDataService.createClients(HostDataService.java:106)
	at de.uib.configed.ServerActionManager.createClients(ServerActionManager.java:56)
	at de.uib.configed.gui.NewClientDialog.createClients(NewClientDialog.java:449)
	at de.uib.configed.gui.NewClientDialog.importCSV(NewClientDialog.java:619)
	at de.uib.configed.gui.NewClientDialog.lambda$createNorthPanel$2(NewClientDialog.java:394)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
	at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.desktop/java.awt.Component.processEvent(Unknown Source)
	at java.desktop/java.awt.Container.processEvent(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
	at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 10:35
von fheithausen
So ist die .csv bei mir formatiert. Die Daten habe ich durch Platzhalter ersetzt.

Code: Alles auswählen

"id","domain","depotId","description","inventoryNumber","hardwareAddress","groups"
"rechnername1","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0001","00:0000:00:00:01","ainstalliert win10"
"rechnername2","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0002","00:0000:00:00:02","ainstalliert win10"
"rechnername3","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0003","00:0000:00:00:03","ainstalliert win10"
"rechnername4","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0004","00:0000:00:00:04","ainstalliert win10"
"rechnername5","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0005","00:0000:00:00:05","ainstalliert win10"
"rechnername6","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0006","00:0000:00:00:06","ainstalliert win10"
"rechnername7","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0007","00:0000:00:00:07","ainstalliert win10"
"rechnername8","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0008","00:0000:00:00:08","ainstalliert win10"
"rechnername9","domain.rz.de","opsidepotid.rz.de","Neu AP","000.0.0009","00:0000:00:00:09","ainstalliert win10"

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 10:36
von holgy58
Danke für die Rückmeldung, also wird das ja ein Bug im opsi sein...

Wir bekommen in den nächsten 2 Wochen 180 neue Rechner und Laptops die wir installieren müssen und da möchte ich nicht alle per Hand einzeln anlegen.

Habe die Frage mal in den Abschnitt Bugs verlinkt

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 11:08
von n.vidziunas
Hi,

der Fehler in CSV Import ist schon in Version 4.3.8.1 behoben.

Viele Grüße
Naglis Vidziunas

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 11:15
von holgy58
Die Aktuellste von letzter Woche ist die 4.3.7.3
Screenshot 2025-03-31 111403.png
Screenshot 2025-03-31 111403.png (22.97 KiB) 4445 mal betrachtet
Wann kommt die 4.3.8.1 ?

Re: csv Import von Clients

Verfasst: 31 Mär 2025, 11:54
von m.radtke
Hi

die Version 4.3.8.1 ist aktuell in experimental zu finden

zb hier: https://tools.43.opsi.org/experimental/

Gruß
Mathias
Alle Zeiten sind UTC+02:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de