Generating a voucher based on a database
IS it possible to configure Captive Portal to, instead of generating a voucher based on an algorithm, generate a voucher using an excel file or mySQL database? For example, generating a voucher for the guest of a specific hotel room, with the voucher consisting of the guest's name and the room number?
This information should be pulled from said database.
No. The vouchers are generated mathematically based on a cryptographic algorithm.
You might be able to do what you want by rigging up something with RADIUS authentication pulled from a database like you want, but that's outside the scope of pfSense.