DGardiner

https://www.papercut.com/kb/Main/WhatAreDotUCFiles/

oh it might have issues with the noreply sender, not sure how that works in practice! if you flip the noReply: true in the sendmail that may help but the emails will go from your account that said, ive checked ours and it seems to be passing dmarc and stuff ok

you can change the script propertied freely without a redeployment, any code changes and you need to click manage deployment, edit, new version and deploy for it to update what gets ran

if you go to the menu on the sheet you can press force sync and send email to do a manual run - it will flip the session key and invalidate an already emailed url

if you want it to clear the vouchers already on the controller be sure to set the purebeforcesync to true

my bad, probably should have explained where to find that....

Hey everyone, I manage multiple sites, and easily one of the most annoying little admin tasks on my plate was constantly dealing with guest Wi-Fi vouchers. You know the drill: receptionists lose the printed sheets, visitors show up unannounced, nobody else in the office can be bothered (or knows how) to log into the UniFi portal to generate fresh ones, and old printed voucher sheets end up lying around desks like confetti. So, to save my own sanity, I built a lazy-proof script that runs completely free inside Google Sheets to handle the whole circus automatically. What it actually does: Automated Weekly Top-Ups: Fires off every Monday morning and automatically tops up your site inventory (e.g. keeps a steady supply of 20x 8-hour passes and 5x 3-day extended passes for inspectors/VIPs). Stops Voucher Hoarding: Tired of staff leaving months-old voucher slips lying around? You can enable a "purge" option that wipes all unused codes from the UniFi controller every week before issuing the new batch—meaning old paper slips instantly become useless trash. Hands-Off Emailing: Automatically emails your office managers or receptionists their site's fresh codes every week so they stop bugging IT. Foolproof Print Dashboard: The email includes a live link to a clean web page where staff can just click "Print Tickets" if needed. As visitors use codes, they vanish off the screen in real-time. so they dont get handed out multiple times Handles multiple controllers: Built specifically to handle multi-site UniFi setups from a single master sheet. Zero Hosting Costs: Runs 100% on free Google Apps Script—no virtual machines, Docker containers, or servers required. I've made the script and setup guide open-source on GitHub. Feel free to grab it, fork it, or use it to automate yourself out of the guest Wi-Fi business: https://github.com/DG-WISE/Unifi-Hotspot-Voucher-Generator Hope this saves a few of you from the endless "Can you send over some Wi-Fi codes?" let me know if ive missed anything And yes the sheet is probably defunct, but it started as a i want an easy list myself and turned into hey it can do all the work for me instead...

i mean, outside of the android thing being dead the panels still perfectly fine as a 75" touchpanel. doesnt help that viewsonic use a proprietry ops slot...

hopefully promethian follow soon... the viewsonics are a slassic drop and forget job so not much hope of that happening

Were haaving this with viewsonic and promethian that i know of, i think its all the 3rd party ones

weve used cloudm in the past to merge stuff when we take over 365/google schools into our trust google tenancy it works well. id like to see how the new google migration stuff works though as that would save a nice chunk of money and we have 2 365 schools coming up to do and from memory the local authority have a single tenancy for the whole area so its a bit of a drama to get sorted...

can you ping the smoothwall? have you setup a proxy for the vlan?

you can forward to another number but the app would work better

not but it applies your policies regardless of login state

setup chrome managed browsers to stop this - its only a registry entry, key for the base ou to place the browser

not entirely relatedbut if you can get onto the switches weve had issues in the pass with smoothwall auto negotiating link speed which led to poor performance - they had to be set on each device to 1g

for quic: block port UDP 443/80 on the firewall as for doh/etc you will need to check with your filter/firewall for things to try as its usually a layered approach

is the json payload set on the user ou? in in chrome://policy is it saying that the policy is coming from cloud or local? if these conflict unless you have set the policy to set who wins i cant remember the default

Google workspace is free anyway, if theyre using it - sign up for the basic edu thing then youre atleast covered under the edu data not being used for training the model

weve piped our reports into haloitsm and then have a ticketing/approval flow that makes the school conduct an investigation and then closes/escalates to IT as required. Weve built some basic reports off the back of it but its helped us alot

how are ou distributing the ip? are you using an ip helper on the router to forward to your server on another vlan? or do you have a dhcp server in that vlan?

Permissions: you dont (there was a beta a few months back with per folder permissions, not sure if thats out now or requires a licence tier) the drive is the permission, just split it into multiple drives with the access as required. Make yourself the manager to get going add the groups with the relevant access levels and take it from there and remove yourself in admin if you feel the need.

Just skip the first formula is papercut is already hex the first cells is dec the second cell converts that to hex judging from the formula (im assumign by the name)

im assuming he means like this: https://docs.google.com/spreadsheets/d/1qSenmbT3_g8CBTq2y2yvC1Wwdw2qfiT1GdYL_0lVcJ8/edit?usp=sharing

if you have it globaly can you not detect pii and add the egress gateway stuff to send it via egress gateway