rieneke44

Hi,

We are using an external application to verify the physical tickets with the shop data.
For that we exported the tickets from the system.
In that export there is a field that contains a QRcode value or URL.
For some tickets this value is equal to the content of the physical QR code.
For many others however, they are different.

We tried decoding the Base64 value in the URL to derive the “order number” from it. For some URLs that worked, but others seem to use an extra security coding.

So our question is, can a list be exported containing QR codes that are 100% match with the physical printout?
Just like the tickets we can query and reprint from the system.
Then we can make a perfect match by scanning the QR code and comparing the content from the database.

URL code report (downloaded csv) from ticket 25147:

http://knitenknot.nl?qsot-event-checkin=1&qsot-checkin-packet=YmE2NjkyYjRlOGZkfDQyMjo2NDhhNzNiZTI1MDg0YzI3ZTM3MzU5ZDQ2NTg2ZGQzNDopPm5hcHMvPDA1LDg7cHNibiY-bmFwcy88O29ydWUmPiJsb2JteVN5Y25lcnJ1Yy1lY2lyUC1lY3JlbW1vY29vdyI9c3NhbGMgbmFwczw-InRudW9tYSB0bnVvbWEtZWNpclAtZWNyZW1tb2Nvb3ciPXNzYWxjIG5hcHM8KCB0ZWtjaXRnYUQ7MDUuOC42Mjg0Mjs3MjkxMTs3NDE1Mg__

URL code after scanning the qr code from ticket 25147:

http://knitenknot.nl?qsot-event-checkin=1&qsot-checkin-packet=YzU3Njg3NDkxYTM2fDE6MzRjNDJmYzFmYTRjYTI5YzhlNTNhZDgwNzQ0YmVmZjc6KT5uYXBzLzwwNSw4O3BzYm4mPm5hcHMvPDtvcnVlJj4ibG9ibXlTeWNuZXJydWMtZWNpclAtZWNyZW1tb2Nvb3ciPXNzYWxjIG5hcHM8PiJ0bnVvbWEgdG51b21hLWVjaXJQLWVjcmVtbW9jb293Ij1zc2FsYyBuYXBzPCggdGVrY2l0Z2FEOzA1LjguNjI4NDI7NzI5MTE7NzQxNTI_