The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,862 other subscribers

Archive for July, 2011

« Previous Entries

WordPress Akismet needs some improvement

Posted by jpluimers on 2011/07/31

This week has been really busy, so only this weekend I found some time to go through the incoming comments.

I found quite a bunch of spam, which is unusual, because WordPress.com uses Akismet which is trying to trap this. Mostly it succeeds (like 99+% of the time), but sometimes it doesn’t, and this week there were more than normal.

So I marked them all as spam, and now the Askimet stats headline at https://wiert.wordpress.com/wp-admin/index.php?page=akismet-stats-display still says “0 missed spam”, and a “100% accuracy rate” but the tables there clearly indicated a bunch of missed spam.

Just in case you wonder too: The spam this week was all about low priced installation guides on getting old software installing on new operating systems.

–jeroen

 

Posted in Power User | 1 Comment »

Lots of Changes: Matt Waddell – Google+

Posted by jpluimers on 2011/07/30

Last week, Google+ improved a lot; Matt Waddell posted a list, including a reference to the “What’s new in Google+” page.

–jeroen

via: Matt Waddell – Google+.

Posted in G+: GooglePlus, Power User, SocialMedia | Leave a Comment »

Don’t forget to hug your System Administrator today

Posted by jpluimers on 2011/07/29

Don’t forget to hug your sysdadmin, as today is System Administrator Appreciation Day!

–jeroen

Posted in Opinions | Leave a Comment »

What was the last time you used a DVD drive? Apple updates Mac mini: Core i5 and i7, Thunderbolt, AMD Radeon HD, no SuperDrive — Engadget

Posted by jpluimers on 2011/07/29

Last week, this was big news in the Apple world: the new Mac mini will ship without a built-in SuperDrive DVD-drive leaving room for a 2nd HDD drive.

New Mac Mini has no SuperDrive, but room for a second HDD

New Mac Mini has no SuperDrive, but room for a second HDD - image courtesy of Engadget

This was in fact the main reason I bought a Mac Mini Server last year: it had 2 HDD drives built in and no SuperDrive.

The last time I used optical drives for storage media since was back when I bought a ThinkPad A20p early in 2000 (yes, I’ve lived in both the Mac and PC world for decades now).

One of the first things I did back then was buying an Ultrabay 2000 HDD Adapter, so I could fit in a second HDD and ditch the DVD-ROM player.
Since then, I loaded CDs and DVDs using ISO image files usingthe Daemon tools virtual DVD drive.

The Apple Mac lagged behind on this very much, I’m not sure at which Mac OS version they finally introduced support for ISO images in Disk Utility, no later than OS X in 2007 though.

Is this big news?

In the Mac world, apparantly so, but I have lived without optical drives for using data for over a decade now.

In fact, the only two reasons I still have DVD drives are:

  1. They are the only way to transfer recorded TV broadcasts from my Philips DVD/HDD and Medion DVD/HDD recorders to other platforms
  2. To help out foundations and voluntary organizations (like Stichting de Zevensprong that organizes activities for people with mental retardation) to distribute multimedia of their activities.

Looking around me, I’m certainly not alone.
Having two HDDs (or three, like the ThinkPad A31p in 2002, and the ThinkPad W70x in 2008) makes it so much easier to make backups or have more storage.
I’m glad I have being able to to that for a very long time, even on a Mac.

–jeroen

via: Apple updates Mac mini: Core i5 and i7, Thunderbolt, AMD Radeon HD, no SuperDrive — Engadget.

PS: Don’t forget to hug your SysAdmin today!

Posted in Apple, Power User | 1 Comment »

Excel XML Spreadsheet: Date.Type is mandatory :)

Posted by jpluimers on 2011/07/28

When you generate Excel XML Spreadsheets, and you load it in Excel, it will report some errors in your Temporary Internet Files directory.

For instance, when you forget to fill the Data.Type attribute, then you get a log file with a message like this:

XML ERROR in Table
REASON:	Missing Tag
FILE:	V:\export.xml
GROUP:	Cell
TAG:	Data
ATTRIB:	Type

Note that some errors won’t be reported. For instance if you forget to put your Data in a Cell.Data (and put it in Cell); then Excel just show empty worksheet.

There seems to be no XSD for the XML Spreadsheet format, so you have to get yourself familiar with the XML in Excel and the Spreadsheet Component documentation on MSDN.

You can view where to put your stuff in the XML Spreadsheet Tag Hierarchy. That list doesn’t have individual links to the tags, you need the XML Spreadsheet Reference for that.

To make things more practical for myself, I perfomed these steps:

  1. created a spreadsheet with all of the data variations I expected
  2. saved this spreadsheet as XML
  3. generated the XSD from that XML
  4. imported the XSD to generate wrapper classes and interfaces

Even with that, you will need to accommodate for many peculiarities.

Hopefully I will find some time to write more those down soon.

The first is ss:Data:

  • It contains the actual data of a cell
  • It has a required ss:Type attribute, which is an enumeration of Number, DateTime, Boolean, String, and Error.
  • When it is String, then x:Ticked should be 1 (meaning True) when the string can be parsed as non-String type (and you would type the value into excel starting with a Tick mark (‘ aka single quote or apostrophe)

–jeroen

Posted in .NET, Development, Software Development, XML, XML/XSD, XSD | 3 Comments »

Marco Cantu’s Delphi XE Handbook Available in print and electronically

Posted by jpluimers on 2011/07/27

Having proofread, I’m really glad that Marco Cantu recently announced that Delphi XE Handbook to be Available in both print and electronic forms.

Note that since the announcement, you can also get the Handbooks Collection in PDF form for something like EUR 55.

His books are always a pleasure to read, so: Great work Marco!

–jeroen

Posted in Delphi, Development, Software Development | 2 Comments »

WebSphere MQ: SYSTEM.DEFAULT.MODEL.QUEUE

Posted by jpluimers on 2011/07/26

What started out as viewing Help – WebSphere MQ: System and default objects to see if SYSTEM.DEFAULT.MODEL.QUEUE is a good model queue to use (and generate dynamic temporary queues named AMQ.* or MQAI.*), ended up into a lot of reading on security and such:

  1. Allowing access to SYSTEM.DEFAULT.MODEL.QUEUE
  2. Using WebSphere MQ Explorer as a read-only viewer
  3. The Deep Queue – Episode #8: The good news and the bad news
  4. Help – WebSphere MQ – Access Control

In the mean time, I added some of the blogs to my Google Reader and learned that one of the blogs moved, and moved again.

  1. http://hursleyonwmq.wordpress.com/
  2. http://www.ibm.com/developerworks/mydeveloperworks/blogs/messaging/
  3. https://www.ibm.com/developerworks/mydeveloperworks/blogs/messaging/?lang=en (slow!)

Oh, and the Diagnosing Probmems with Data Conversion post, WMQ, Channel Security and  WebSphere MQ Security heats up posts will sure come in handy soon.

–jeroen

Posted in Development, MQ Message Queueing/Queuing, Software Development, WebSphere MQ | Leave a Comment »

Handig voor kapotte huishoudelijke apparaten: EuroPart.nl; Onderdelen en accessoires online bestellen | ophalen in de winkel of thuisbezorgd

Posted by jpluimers on 2011/07/24

Dus als je wasmachine stuk is: Onderdelen en accessoires online bestellen | ophalen in de winkel of thuisbezorgd | Europart, goed gefikst.

–jeroen

Posted in Power User | Leave a Comment »

Extensions to force HTTPS in your browser

Posted by jpluimers on 2011/07/22

About 9 months ago I posted about HTTPS Everywhere | Electronic Frontier Foundation hoping someone would port the HTTPS Everywhere extension for Firefox to force HTTPS in other browsers like Google Chrome, Microsoft Internet Explorer et cetera.

In the mean time, I found out about HSTS (HTTP Strict Transport Security), which is supported by FireFox 4, and Chrome 12.

Also in the mean time I found about a few HTTPS enforcer extensions for other browsers.

For instance, there are two similar Google Chrome Extensions to HTTPS Everywhere:

Internet Explorer does not have such an extension.

Opera has the Security Enhancer extension.

Next to HTTPS Everywhere, there are the ForceHTTPS and NoScript extension for FireFox (NoScript also supports HSTS).
FireFox 4 supports HSTS out of the box.

So now you have a choice!

–jeroen

Posted in Chrome, Firefox, Internet Explorer, Power User, Web Browsers | Leave a Comment »

WebSphere MQ and Delphi

Posted by jpluimers on 2011/07/21

On my research list: WebSphere MQ and Delphi.

The funny thing is that this Delphi MQ Series question on StackOverflow that I answered actually helped me to get going :)

A few interesting links:

The research actually is focussed to replace a APPC/CPI-C session based solution that runs on top of SNA using LU 6.2 endpoints and has round-trip response times between 50 and 150 milliseconds with a WebSphere MQ based solution having similar performance characteristics. It binds multiple client applications to multiple function entries on the AS/400 systems at the client.

The current APPC/CPI-C part is written either both a DLL and EXE in Delphi (depending on how it is used), hence the Delphi part of the research.

In many organizations, WebSphere MQ (aka MQSeries) is part of their Enterprise Service Bus. In that regard, the SNA solution was far a ahead of its time.

BTW: Back then (almost 15 years ago), the SNA solution started out as solution using AS/400 Data Queues. Even after months of trying, that didn’t work well because the mixed environment of NetSoft Router, AS/400, SNA Server and Windows NT 4 in a pretty big WAN had huge problems.
Somehow, one of the layers forced sessions to always use 2 connections at a time, which was causing huge problems when those were routed through different SNA servers. That routing was unpredictable (and it was not possible to disable/force it to use stick to one SNA server). In addition, it was memory and CPU hungry on the PC side (when you were glad to have a Pentium MMX based CPU with 32 MB RAM, it ate 20+% of the CPU power, and 25+% of the memory per session, peaking to 100% CPU and 50% of RAM per session).
Specialists from all involved parties weren’t able to pinpoint the actual cause, so we went a few steps down on the OSI layer to the APPC leve.

–jeroen

Posted in .NET, Delphi, Development, Software Development | 5 Comments »

« Previous Entries