Archive for the ‘Development’ Category
Posted by jpluimers on 2020/04/06
I found this in one of my logs a a while ago:
Error when executing EHLO command for domain mail.com on SMTP server mx00.mail.com.
(554, 'mail.com (mxgmxus007) Nemesis ESMTP Service not available\nNo SMTP service\nBad DNS PTR resource record.\nFor explanation visit http://postmaster.gmx.com/en/error-messages?ip=37.153.243.242&c=rdns')
It means that gmx.de / mail.com are among the strictest email handling providers I know. I don’t blame them: EHLO is at the start of an extended SMTP session.
At [WayBack] Error messages | GMX Postmaster it indicates:
5xy Bad DNS PTR resource record
Emails from your email server were rejected because the PTR Resource Record (PTR-RR) of your IP address does not follow our guidelines. Possible reasons for this can be:
–jeroen
Posted in Communications Development, Development, eMail, Internet protocol suite, Power User, SMTP, SocialMedia, TCP | Leave a Comment »
Posted by jpluimers on 2020/04/02
According to [WayBack] Hightlight active row/column in Excel without using VBA? – Stack Overflow: no, but you do not need much code.
On my list of things to try is to combine both answers there into one.
–jeroen
Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/04/02
The article is dense but goes way deeper than straightforward sys.argv[1:] handling: [WayBack] 10.6. Handling command-line arguments.
–jeroen
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/04/02
The IDE already owns and modifies your .dproj and .dpr files (of which many users complain, but I think it is a good thing), so this is a great suggestion: [WayBack] Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I… – Walter Prins – Google+
Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I encountered this morning):
While the IDE will automatically adjust form/pas file paths for files included in the project in the .dpr for you, what it will not however do is also adjust the project “Search path” in a similar fashion, even though moving the project is guaranteed to break the project if it has project relative search paths and hence they would require adjusting.
That is to say, if you have project relative search folders specified in the “Search path” (and indeed the output folders), you will need to manually go and edit these paths in the project by hand when you change the project’s location.
(I’d argue that the IDE ought to update relative paths in the project options automatically given that it does so already for the .dpr; it would be the intuitive and graceful thing to do.)
–jeroen
Posted in Delphi, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2020/04/01
It is important to look beyond your own comfort zone to see what other languages can support: [WayBack] Forde’s Tenth Rule, or, “How I Learned to Stop Worrying and ❤ the State Machine”.
The article is about implementing finite state machines in JavaScript with as little usage of string literals as possible.
Via: [WayBack] How I Learned to Stop Worrying and Love the State Machine – Adrian Marius Popa – Google+
–jeroen
Posted in Development, JavaScript/ECMAScript, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/31
Since the Git output by default is not shown, here is how to enable it:
[WayBack] Version Control in Visual Studio Code: Git output window
You can always peek under the hood to see the Git commands we are using. This is helpful if something strange is happening or if you are just curious. :)
To open the Git output window, run View > Output and select Git from the dropdown.
Or shorter on MacOS:
- Press
Cmd–Shift–P
- Type
show git output
- Press enter
–jeroen
Posted in .NET, Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
–jeroen
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/31
Cool example, which requires dnspython and might need an update of the DNS record type list (maybe dnspython has that list built in?):
[WayBack] Printing all DNS records using DNSPython in Python 3 · GitHub
–jeroen
Read the rest of this entry »
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/30
Improving your designs with tactics instead of talent: weight and colour. But be careful with the variation in meanings of colours for different cultures and mind about colour-blind people. Also ensure information workers can optimise your UI for information density.
Source: [WayBack] 7 Practical Tips for Cheating at Design – Refactoring UI – Medium
Via: [WayBack] 7 Practical Tips for Cheating at Design #webdev – ThisIsWhyICode – Google+
–jeroen
Posted in Usability, User Experience (ux) | Leave a Comment »
Posted by jpluimers on 2020/03/27
- While 32-bit applications can run on 64-bit machines, they cannot use 64-bit ODBC drivers. A 64-bit application must use a 64-bit ODBC driver, and a 32-bit application must use a 32-bit ODBC driver.
- ODBC.INI registry paths for the various permutations:
- User DSNs for for 64-bit and 32-bit applications
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
- System DSNs for 64-bit applications on 64-bit Windows and 32-bit applications on 32-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
- System DSNs for 32-bit applications on 64-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI
Via: [WayBack] Windows registry on 32 and 64 bit windows, which also explains ODBCINST.INI to define drivers.
–jeroen
Posted in Database Development, Development, ODBC, Power User, Windows | Leave a Comment »
The Wiert Corner - irregular stream of stuff 