Great for converting tab separated data (for instance when copied from Excel) into HTML:
[Wayback/Archive] Convert TSV to HTML Table Online | WTOOLS
–jeroen
Archive for the ‘Power User’ Category
Convert TSV to HTML Table Online | WTOOLS
Posted by jpluimers on 2024/02/20
Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | Leave a Comment »
Many links about free modem/router choice and their configurations for the Dutch KPN internet/VoIP provider
Posted by jpluimers on 2024/02/19
I wrote this post because the xs4all->KPN transition was messy, especially on the VoIP side.
Emails and letters were incomplete lacking some essential information for manual configuration; 2nd line help desk did not return calls; pointers to where to find correct information were lacking.
This kind of is a catch all post with most of the links I found without much of their content so I can refer to them later when writing a more detailed post on how I did get VoIP to work.
So: for my link archive, almost all posts in Dutch.
Found posts
Share this:
Posted in Internet, ISP, KPN, Power User, Telephony, VoIP, xs4all | Leave a Comment »
thuddevort on Twitter: “You can disable the extra confirmation under System > FRITZ!Box Users > Additional Confirmation”
Posted by jpluimers on 2024/02/16
My ISP did auto-update the Fritz!Box, but did not send release-notes, so I was not aware this feature had been added eons ago:
[Wayback/Archive] thuddevort on Twitter: “@jpluimers @wijnands @b0rk @xs4all You can disable the extra confirmation under System > FRITZ!Box Users > Additional Confirmation”.
I know a second factor is better for security, but doing that on both sites at the same time when setting up LAN2LAN VPN is tough (Fritz!Box names this either “LAN-LAN coupling” or “VPN Connections between the FRITZ!Box and Other Networks”.
A better feature at the same configuration page is instead of disabling, enabling to confirm using apps like Google Authenticator and Authy:
Share this:
Posted in Fritz!, Fritz!Box, Hardware, Network-and-equipment, Power User | Leave a Comment »
« The same people who say it’s too hard to write alt text are now suddenly “prompt engineers” who literally write alt text to generate images » – Thomas Fuchs
Posted by jpluimers on 2024/02/14
As an alt-text advocate, I appreciate [Wayback/Archive] Thomas 🔭✨: “The same people who say it’s t…” – Hachyderm.io
The same people who say it’s too hard to write alt text are now suddenly “prompt engineers” who literally write alt text to generate images.
#inclusion #a11y #accessibility
In case you missed it, this is indeed a thing: Prompt engineer – Wikipedia.
--jeroen
Share this:
Posted in accessibility (a11y), AI and ML; Artificial Intelligence & Machine Learning, ChatGPT, Development, GPT-3, HTML, Power User, SocialMedia, Software Development, Web Development | Leave a Comment »
For older Excel versions that do not have the =ISOWEEKNUM(date) function, use =WEEKNUM(date,21)
Posted by jpluimers on 2024/02/14
Calculating an ISO-8601 based WEEKNUM
From [Wayback/Archive] ISOWEEKNUM Function – How to Get the Week Number in Excel:
- If we are using an older version of MS Excel, we can use the function
WEEKNUM. By default, theWEEKNUMfunction uses an arrangement where Week1begins onJanuary 1, and Week2begins on the nextSunday(when thereturn_typeargument is omitted, or supplied as1).However, with MS Excel 2010 for Windows and MS Excel 2011 for Mac, we can generate an ISO week number using21as thereturn_type:=WEEKNUM(date,21).- There is no built-in worksheet function for ISO weeks before MS Excel 2010.
I tested that ISO-8601 week number calculation in with Excel 2011 on MacOS and Excel 2010 on Windows: the workaround works well for the dates mentioned in ISO week date – Wikipedia.
Share this:
Posted in Excel, Office, Office 2010, Office 2011 for Mac, Power User | Leave a Comment »
Excel 2011/2010: Conditional formatting of TRUE / FALSE values in an Excel range
Posted by jpluimers on 2024/02/13
The conditional formatting feature in Excel is so cool!
If you use FALSE and TRUE expressions to check validity, you can easily make these red and green.
[Wayback/Archive] Conditional formatting of TRUE / FALSE values in an Excel 2010 range – Super User (thanks [Wayback/Archive] tbone for asking and [Wayback/Archive] digitxp for answering):
Share this:
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, Office, Office 2010, Office 2011 for Mac, Power User, Windows | Leave a Comment »
The death of ESXi finally confirmed by Broadcom
Posted by jpluimers on 2024/02/12
Quite a few people already bumped into this the last two days (will add those links later), so today’s confirmation by Broadcom – who have a similar modus operandi as companies like Computer Associates and Symantec were and Idera is now – as of the ESXi death does not come as a surprise.
- [Wayback/Archive] End Of General Availability of the free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)
Symptoms
VMware vSphere Hypervisor (free edition) is no longer available on the VMware website
Resolution
Along with the termination of perpetual licensing, Broadcom has also decided to discontinue the Free ESXi Hypervisor, marking it as EOGA (End of General Availability).
Regrettably, there is currently no substitute product offered. For further details regarding the affected products and this change, we encourage you to review the following blog post: https://blogs.vmware.com/cloud-foundation/2024/01/22/vmware-end-of-availability-of-perpetual-licensing-and-saas-services/
[Wayback/Archive] VMware End Of Availability of Perpetual Licensing and SaaS Services – VMware Cloud Foundation (VCF) Blog
Share this:
Posted in Internet, InternetArchive, Power User, Virtualization, VMware, VMware ESXi, WayBack machine | Leave a Comment »
Reminder that the Fritz!Box IKE error 0x1C is still barely documented: crucial places like the built-in help page point to non-existing URLs
Posted by jpluimers on 2024/02/12
A while ago, I had to redo all of the existing Fritz!Box LAN2LAN VPN connections.
It was a pain for many reasons, reminding me of the pain
This is why it was so painful:
Share this:
Posted in Fritz!, Fritz!Box, Hardware, Network-and-equipment, Power User | Leave a Comment »
jilles.com on Twitter: “Question for Dutch HAM radio amateurs, what frequencies are interesting to monitor for digital data? EG IoT/SSTV/Pocsag”
Posted by jpluimers on 2024/02/08
Some links around a question that Jilles posted in 2022: [Wayback/Archive] jilles.com on Twitter: “Question for Dutch HAM radio amateurs, what frequencies are interesting to monitor for digital data? EG IoT/SSTV/Pocsag”
Share this:
Posted in ADS-B receivers, Development, Hardware, Power User, Software Development, USB | Leave a Comment »
Walls and Ladders when pasting e-mail on account sign-up forms: Paste It – Chrome Web Store
Posted by jpluimers on 2024/02/06
In a game of Walls and Ladders (similar to Arms Race), the Ladders usually win, see the references at the end of the post.
The actual “game” in this case is more and more sites trying to build walls prevent pasting credential related information like user IDs (often e-mail addresses) or passwords often citing “more safety” or “less security risks”, and users get taller ladders wanting to do just that because of their own security concerns:
[Wayback/Archive] Stef 🎈 on Twitter: “Dear mobile/web-apps, please never never disable copy and paste “due to security reasons”. -everybody with a password manager.”
The walls will always loose so it is better to invest the money for the walls into other security measures.
Given that most of the risks are web-sites getting that information exfiltrated, I wish they put more energy into bolting down that side of the security risk side than the hampering legitimate users entering that information in the first place.
Since so many of these sites have leaked my information in the past, any email address I use for activating an account is like 50 characters long. Something I am not going to type once (because of typing mistakes) and definitely not twice (to confirm I did not make typing mistakes).
Share this:
Posted in Authentication, Chrome, Clipboard, Development, Google, HTML, JavaScript/ECMAScript, Power User, Scripting, Security, Software Development, Web Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 