Introduction
While many people may not be aware, the author personally loves sending and receiving QSL cards. They have sent QSL cards to almost all domestic communication providers that can be reached through their addresses.
Send 10-30 letters per month, with varying frequencies.
Recently, if you receive a QSL card from someone who has received my cards, you might notice that all my addresses are printed on labels. Given the number of labels, it's obviously not feasible to have created and printed them one by one.
Website
Proudly presenting my achievements at Vibe Coding. https://qso-print.wafer.li
A small website for Excel that can generate "labels for generating tags".
Simply enter the address of your radio station on this website, and then import the relevant QSOs you need to print from the printed page. It will then generate two Excel files.
What are the uses of Excel?
The current label printer software supports importing from Excel files, recognizing the content within, and enabling batch printing.
The apps used with label printers from different brands are different, but they all generally support this feature.
For example, "Small label printing"The app supports parsing and importing Excel files, selecting fields, and then editing and rearranging data in the label editor page.
Then, perform bulk printing from the printed page.
Data security issues
You don't need to worry about data security; this website is a purely front-end application, hosted on Cloudflare Pages.
In other words, all of the data and logic are run and stored on your Local browser Up
However, while ensuring security, it also sacrifices convenience. Therefore, the website provides an "address export function" to ensure the privacy of exported data, and also offers encryption functionality for this purpose.
Other convenient features
Search address
Sometimes you need to find the address of a friendly station, so how can there be no search function for that?
The address search function supports the following searches:
- Call sign search
- Pinyin search
- Full-text search
Check QRZ and supplemental addresses
Sometimes, I find that a contact's callsign doesn't have an address. What should I do?
Don't worry, the print page provides a "Scan QRZ.com" function.
Clicking this will take you to the corresponding QRZ page for that call sign.
Additionally, for callsigns without addresses, a quick add address button will be provided on the print page. Clicking this button allows you to add the corresponding address to the system.
Conclusion
Although it's a very small thing, using Vibe Coding to create it and also help myself out is quite impressive.
If anyone finds this useful, please feel free to use it. If you encounter any bugs, please report them in the following location: Here Please create an issue for me.
Some screenshots
闽ICP备2021006864号-7
闽公网安备35020602002794号