Automating CSV database

[braunbaer]

What data are on the barcode? If it's only the serial number, how do you know the corresponding Geräte-Id?
If it's both serial number an Geräte-Id, what do you need the Masterlist.xlsx for?

[BoBo]

Geräte-ID/device-ID
Seriennummer/serial number

[braunbaer]

[

then i need to search the first digits of the barcode to see what printer it is and find the correct id in $PrinterIDMasterlist := "Masterliste.xlsx"

That is what I still don't understand.
When you have the first digits of the barcode, how do you get the Geräte-id for that printer. I don't see a connection between the serial number and the Geräte Id.
In your masterlist you have lots of printers with their Geräte-Id, but when you scan a new serial number, how can you find the correct Geräte-Id?