Page 1 of 1

Re: Automating CSV database

Posted: 05 May 2021, 09:11
by 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?

Re: Automating CSV database

Posted: 05 May 2021, 10:48
by BoBo
Geräte-ID/device-ID
Seriennummer/serial number

Re: Automating CSV database

Posted: 06 May 2021, 18:36
by 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?