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:
Cmd–Shift–Pshow git output–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:
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
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/26
On MacOS, a long standing wish from many developers has been to open a folder with Visual Studio Code: [WayBack] Mac OS X :: “Open Folder With” VS Code · Issue #1223 · Microsoft/vscode · GitHub.
There are many reasons for wanting this, and other tools can do this too (like Terminal, TextWrangler, Source Tree, Beyond Compare), so I was a bit surprised Visual Studio Code does not have it by default.
After initially being closed, the issue has been open for a while, so I started digging a bit for solutions that are easy to configure or install.
The last one is currently on the top of my list, so I copied and installation instructions, and added a few screenshots to explain the already included video below.
Posted in .NET, Development, Software Development, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2020/03/26
This is soooo nice! [WayBack] GitHub – alexmojaki/birdseye: Quick, convenient, expression-centric, graphical Python debugger using the AST
It runs on localhost:7777
Via: [WayBack] Birdseye ist eine interessante Lösung, um detailliert nachzuvollziehen, was beim Aufruf von Python-Funktionen und der Abarbeitung von Schleifen geschieh… – Martin Vogel – Google+
–jeroen
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/25
From a while back, but just in case I ever need JSONPath (for JSON, or BSON Path): [WayBack] Added JSONPath functionality · grijjy/GrijjyFoundation@4ce069a · GitHub.
Via: [WayBack] Search for and extract data from your JSON documents using an XPath-like query language. Now part of our JSON and BSON library. – Erik van Bilsen – Google+
It has a small glitch on non-USA systems, so I filed an issue and provided grijjy’s Erik van Bilsen with a pull request:
–jeroen
Posted in Delphi, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/25
On Mac OS X with stock Python:
All you need to do is
sudo easy_install pip
After this, you might want to upgrade pip:
sudo pip install --upgrade pip
Source: [WayBack] python – How do I install pip on macOS or OS X? – Stack Overflow
You could go the homebrew way, but that means your system will have two Python installations usually causing a nightmare of path dependency orders. In addition, homebrew puts you on the wrong foot, so:
DO NOT DO THIS!
# brew install pip Error: No available formula with the name "pip" Homebrew provides pip via: `brew install python`. However you will then have two Pythons installed on your Mac, so alternatively you can install pip via the instructions at: https://pip.readthedocs.io/en/stable/installing/
–jeroen
Posted in Apple, Development, Mac OS X / OS X / MacOS, macOS 10.12 Sierra, macOS 10.13 High Sierra, Power User, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/25
Blast from the past machine generated code by the various assembly versions of the [WayBack] Windows BitBlt function [WayBack] Optimizing BitBlt by generating code on the fly – The Old New Thing.
Via: [WayBack] Rodrigo Ruz on Twitter: “Optimizing BitBlt by generating code on the fly https://t.co/gWmKjex20i”
–jeroen
Posted in Development, History, Software Development, The Old New Thing, Windows Development | Leave a Comment »
Posted by jpluimers on 2020/03/24
If you want to process the JSON form the Google Take Out, then below are some resources that will help you get started developing
Started developing you say?
Yes, of course the JSON does not match APIs any more, and of course Google has not provided and starting point or guidance.
A perfect execution of Sunset.
So you are on your own with:
All via [WayBack] Continuing the takeout data migration process with a first look at the data that is in the archive. – Edward Morbius – Google+
In the mean time, some people started hosting their HTML take out, for instance:
Here you have to note that the take out does not include media, and many hyperlinks still point to within Google Plus itself, for instance for circles and avatars.
Example:
–jeroen
Posted in Development, G+: GooglePlus, Google, Power User, SocialMedia, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/24
Designing for a good user experience is hard, especially to programmers. So if you are a programmer, please read, let them sink in, rinse, repeat the below linked articles multiple times. Being ~15 years old, they are still so very relevant:
–jeroen
Posted in Development, Software Development, The Old New Thing, Usability, User Experience (ux), Windows Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 