Link rot stroke again: New link for Mastering the VI editor.
These are useful too:
–jeroen
via *nix – Mastering the VI editor « The Wiert Corner – irregular stream of Wiert stuff.
Archive for 2012
Link update because of rot (*nix – Mastering the VI editor)
Posted by jpluimers on 2012/09/17
Posted in *nix, Cygwin, Endian, Internet, link rot, Linux, Power User, vi, WWW - the World Wide Web of information | Leave a Comment »
6 Excel keyboard shortcut pairs I didn’t know yet: select row/select column and insert current date/time(via: The Best Shortcut Keys in Microsoft Excel)
Posted by jpluimers on 2012/09/17
Learned a few Excel keyboard shortcut pairs today:
| Shortcut | Action |
|---|---|
| Ctrl+Spacebar | Select columns |
| Shift+Spacebar | Select rows |
| Ctrl+; | Current date |
| Ctrl+Shift+: | Current time |
| Ctrl+Shift+2 | Format current cell as default date |
| Ctrl+Shift+3 | Format current cell as default time |
–jeroen
via:
- The Best Shortcut Keys in Microsoft Excel.
- keyboard shortcut for dates and Time – ExcelBanter.
- Adding the Current Date – Excel Keyboard Shortcuts.
- Adding the Current Time – Excel Keyboard Shortcuts.
- Discussion on A few Excel formatting keyboard shortcuts | TechRepublic.
Share this:
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
What is the best Report tool for Delphi? – Stack Overflow
Posted by jpluimers on 2012/09/14
Interesting question What is the best Report tool for Delphi? – Stack Overflow that hopefully leads to a nice list of current reporting tools before it gets closed as “question will likely solicit debate, arguments, polling, or extended discussion”.
–jeroen
Share this:
Posted in Delphi, Development, Software Development | 1 Comment »
Delphi, solutions for `while debugging with Environment Variable “The program can’t start because ….dll is missing”‘
Posted by jpluimers on 2012/09/14
Two days ago I ran into the bug below while porting some code from Delphi 2006 to Delphi XE2, posted on StackOverflow, and got solutions in very little time.
Thanks Andreas Hausladen, David Heffernan, Ken White, Sertac Akyuz, Rudy Velthuis, for answering, providing solutions and verifying!
Note that this worked up until Delphi XE, and has been fixed in Delphi XE3 (which for this project I can’t use as the client upgraded to XE2 without SA).
Problem
- I get the error mentioned further on error when debugging an executable in Delphi XE2 update 4 under these circumstances:
- that depends on mqic.dll from WebShpere that is in C:\Program Files \IBM\WebSphere MQ\bin\mqic.dll and C:\Program Files\IBM\WebSphere MQ\bin is on the system path (not on the user path).
- is being debugged with an override environment variable in the Run -> Parameters -> Debugger -> Environment Block -> User overrides
- Including System Variables on the same property page is checked
This is the error (it’s a Windows DLL load error marked “System Error”).
The program can’t start because mqic.dll is missing from your computer. Try reinstalling the program to fix this problem.
Solutions
- Install IDE Fix Pack from Andreas Hausladen it fixes the “Include System Variables” isn’t working issue.
- Use a batch file that sets the environment variables, then starts Delphi
(only usable when the environment variables are more or less fixed) - Copy all environment variables you need over from the system ones to the user ones in the Delphi IDE
(only usable when you don’t need that many system ones) - Upgrade to Delphi XE3
–jeroen
Share this:
Posted in Delphi, Delphi 2006, Delphi 2007, Delphi XE, Delphi XE2, Delphi XE3, Development, Software Development | Tagged: ibm websphere mq, software, stack overflow, technology | Leave a Comment »
Making RoboCopy silent (via: backup – How can I make robocopy silent in the command line except for progress? – Stack Overflow)
Posted by jpluimers on 2012/09/14
A while ago, I got a question from a colleague on how to silence RoboCopy.
The RoboCopy /? help is a bit awkward to read, so there is this nice SO answer by Ruben Koene:
So together with previous answer you get the following and it’s silent:
ROBOCOPY [target] /njh /njs /ndl /nc /ns /np /nfl
And there is the FIND way where I marked the relevant options with an asterisk (*):
C:\Users\jeroenp>robocopy /? | find /i "No"
/S :: copy Subdirectories, but not empty ones.
/NOCOPY :: COPY NO file info (useful with /PURGE).
/PURGE :: delete dest files/dirs that no longer exist in source.
/PF :: check run hours on a Per File (not per pass) basis.
n must be at least 1 and not greater than 128.
/XJ :: eXclude Junction points. (normally included by default).
/X :: report all eXtra files, not just those selected.
* /NS :: No Size - don't log file sizes.
* /NC :: No Class - don't log file classes.
* /NFL :: No File List - don't log file names.
* /NDL :: No Directory List - don't log directory names.
* /NP :: No Progress - don't display percentage copied.
* /NJH :: No Job Header.
* /NJS :: No Job Summary.
/NOSD :: NO Source Directory is specified.
/NODD :: NO Destination Directory is specified.
–jeroen
via: backup – How can I make robocopy silent in the command line except for progress? – Stack Overflow.
Share this:
Posted in Power User, RoboCopy, Windows, Windows 7, Windows 8, Windows Server 2000, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP | 4 Comments »
Don’t spam with OutputDebugString
Posted by jpluimers on 2012/09/13
A production version of an app should not spam using OutputDebugString.
Some apps do, for instance very couple of seconds the “TAM E-SSO AccessAgent” DataProvider.exe process spams stuff like this:
[1952] GRP_StubImpl Inside [1952] before deserializing the message [1952] GRP_StubImpl for Policy Id = pid_desktop_inactivity_mins ... [1952] GRP_StubImpl Inside [1952] before deserializing the message [1952] GRP_StubImpl for Policy Id = pid_aa_tray_menu_options_enabled [1952] GRP_StubImpl Inside [1952] before deserializing the message [1952] GRP_StubImpl for Policy Id = pid_automatic_sign_up_enabled [1952] GRP_StubImpl Inside [1952] before deserializing the message [1952] GRP_StubImpl for Policy Id = pid_desktop_inactivity_mins ...
It is in the chain of processes (yes, the tripple backslash is actually there, this is how IBM starts is):
- “C:\Program Files\Encentuate\AATray.exe”
- “C:\Program Files\Encentuate\\\DataProvider.exe”
- “C:\Program Files\Encentuate\Sync.exe”
- “C:\Program Files\Encentuate\\\DataProvider.exe”
All of them have version 8.1.0.130 and timestamp 20-12-2010 14:32.
You’d think that IBM knows how to do this right (:
–jeroen
Share this:
Posted in Debugging, Development, Software Development | Tagged: enterprise-it, software, technology, tray menu | Leave a Comment »
Things I tripped over when implementing the “Elf proef”: digit check for Dutch bank account numbers and social security numbers (bankrekeningnummer, BSN/Sofinummer)
Posted by jpluimers on 2012/09/13
It was a long time ago that I ever did something with the Elf proef.
It is the algorithm that is used to calculate the check digit for Dutch bank account numbers (bankrekeningnummers) and a variation for BSNs (Social Security Numbers).
I needed it (or more exactly: a variation of it) in order to support anonymization of customer data for the DTA/OTA portions of a DTAP/OTAP environment.
So, I started reading on the Elf proef, and getting some sample data to setup some unit tests.
Wrong and wrong:
- The 10 digit bank account number example at Wikipedia has the wrong algorithm.
- The 9 digit bank account number generator at Testnummers.nl generates bank account numbers – if the end digit is zero – are mostly wrong.
To start with the latter, they get it wrong because the check digit is modulo 11 (like the ISBN 10 check digit), but only numeric digits are valid. Their bank.js algorithm module tries to accommodate for that in the wrong way.
In addition they copy-pasted code between their other number generation algorithms which you can see form the variable SofiNr which is an abbreviation for SofiNummer, the old name for the Dutch Social Security Number (now called Burgerservicenummer aka BSN).
Their generated sample 290594880 is wrong because the check digit should be 10, and 10 is not a digit. Their generated number 936977590 is OK as the check digit should be zero (0) which it is.
More on their fault a bit further on. First lets concentrate on getting proper test data, and the right algorithm.
I will cover code for the bankrekeningnummer here. The complete code including BSN is at BeSharp.CodePlex.com. Read the rest of this entry »
Share this:
Posted in .NET, C#, C# 3.0, C# 4.0, C# 5.0, Development, JavaScript/ECMAScript, Scripting, Software Development | 4 Comments »
Pad Numbers with Leading zeros (0s) or trailing spaces – Fixed Width Number Display (via: SQL Server Journey with SQL Authority)
Posted by jpluimers on 2012/09/12
Every once in a while I need something like this, and I always forget the best way to do it: pad numbers so they start with leading zeros so they appear fixed with.
There is no ready made function in SQL Server which offers this solution but we can quickly write up something very simple.
SQLUSA has some more ways to do it, and all basically come down to this:
- Convert your number to VARCHAR (use CAST or CONVERT) .
- Prepend the converted number with the maximum number of zeros you require (either with a fixed length string like
'00000000', or use the REPLICATE function). - Take the right most characters of the required length using the RIGHT function.
You can do similar things with LEFT and padding (for instance with spaces to the right).
One example:
SELECT RIGHT('0000000000' + CAST(31415 AS VARCHAR(10)), 10) AS PaddedPiInteger
SELECT LEFT(CAST(31415 AS VARCHAR(10)) + ' ', 10) AS PaddedPiInteger
–jeroen
Share this:
Posted in Database Development, Development, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 7 | Leave a Comment »
When all you have is a Hammer^H^H^H^H^H RegEx tool, everything seems like a nail^H^H^H^H nightmare
Posted by jpluimers on 2012/09/11
For a good laugh when you are coding late at the evening: regex – Delphi PCRE – regExp string in INI section “range” – Stack Overflow.
–jeroen
Share this:
Posted in Delphi, Development | 5 Comments »
Crap: VersionInfo handling broken as of Delphi XE2
Posted by jpluimers on 2012/09/11
Today I found out the hard way that you really need a build integration system for managing VersionInfo in Delphi applications: as of Delphi XE2 it is broken in the IDE.
See these links:
- How to manage version information on Delphi XE2 across platforms – Stack Overflow.
- Embarcadero Discussion Forums: Xe2 and version info? ….
- Embarcadero Discussion Forums: Delphi XE2 – Application Version Info ….
This is the only workable workaround so far:
- DDevExtensions 2.6 | Andy’s Blog and Tools.
(with short PDF manual)
–jeroen
Share this:
Posted in Delphi, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 5, Delphi 6, Delphi 7, Delphi XE, Delphi XE2, Delphi XE3, Development, Software Development | Tagged: application version, computer, Delphi, delphi applications, education, embarcadero, integration system, stack overflow, technology | 14 Comments »
The Wiert Corner - irregular stream of stuff 