The other day, Philip Storry wrote "A lack of training, or a lack of intelligence", about someone sending a death threat to a professor who happens to be an atheist. This person (mkroll, who later was identified as Melanie Kroll) sent the mail from her work address at 1-800-FLOWERS. If you look at the headers provided by Professor Myers, you can see that the address is not spoofed.

I contacted a journalist at IDG that I know from working there, and he did some investigating to see if he would be able to write a story about this. I just got a mail from him, informing me that Melanie was fired yesterday over this mail.

I say as the very funny Ron White: "You just can’t fix stupid"…

 Robert McMillan just wrote a story in PC World about a new laptop tracking system, which is free:

Lose your laptop these days and you lose part of your life: You say good-bye to photos, music and personal documents that cannot be replaced, and if it’s a work computer, you may be the source of a very public data breach.

But now, researchers at the University of Washington and the University of California, San Diego, have found a way to give you a shot at getting your life back. On Monday, they plan to launch a new laptop tracking service, called Adeona that is free and private.

Named after the Roman goddess credited with guiding children back to their parents, Adeona uses software that has been under development for the past year. 

Sounds interesting! Read the full article for more details.

You are Superman

Superman 75% Iron Man 70% Spider-Man 65% Green Lantern 65% Robin 57% The Flash 55% Supergirl 50% Catwoman 50% Batman 45% Hulk 45% Wonder Woman 35%

You are mild-mannered, good, strong and you love to help others.

Click here to take the Superhero Personality Test
 

 Bill Buchan just wrote about exporting data to Excel using a CSV file. There is actually a cool and surprisingly easy way to generate documents that show up in Excel as real spreadsheets, with formatting, colors, etc.

Simply create a file containing a HTML table. It may even work with multiple tables. You can use tags like <B> and <I> for bold/italic, and use the color attribute to set text color and background color. Use the colspan attribute to split a cell over multiple columns.

Save the file in Lotusscript as a regular text file, but with the extension XML XLS. Excel, as well as OpenOffice.org, will read the HTML and present as a nice spreadsheet.

 We all know that Notes let us create tabbed tables. But you have limits to how nice you can create the tabs.

In an application I am working on, I wanted full control of the tabs, and I found out it was actually pretty easy to create my own tabs. I just used a computed background, something I actually never used before.

By the way, I stoleborrowed the graphics from Yahoo Mail for now, until I get the final graphics created…

The application displays information about the (insurance) claim selected in the drop-down box. Each claim has one or more claimants (affected people/parties), and I display them in the tabbed section. You can see the tabs in the screenshot below.

What I simply do is to keep track of the currently selected claimant, the number of claimants, and then I built a table with 3 columns in the first row and one merged cell as the second row.

In the center cell in the first row, I set the background to the "active colored" (lighter) tab. I use @Formulas to set the background in the two other cells:

@If( @TextToNumber(CurrentClaimantNumber) > 1; "CCdb_InactiveTab.gif"; "" )

and

@If( @TextToNumber(CurrentClaimantNumber) < @TextToNumber(LNPClaimantCount); "CCdb_InactiveTab.gif"; "" )

The inactive tab is the darker one. Then it is just a question about writing code that trigger when the lables (computed-for-display fields) are clicked, to update the current claimant value, load the claimant data and refresh the form.

I hope you get some inspiration from this. Oh, and this is all Notes 5…

 The last month or so, I have been pretty busy at work and in my personal life. My sister came over from Sweden for a 10-day visit, and at work I been working on wrapping up a project we been working on for a while. I have been having some time to do private things, but I have not put a priority on computers/blogging. This coming weekend I am going to Austin for a friends birthday, but then I should have time to do some blogging again.

According to an article at boingboing.com, Paramount is dropping the sound in the new Indiana Jones movie, in order to trace where pirate copies are coming from.

While at the cinema yesterday, I read a notice posted by the box office that Paramount has intentionally silenced bits of the soundtrack of _Indiana Jones and the Kingdom of the Crystal Skull_ in order to deter and track piracy. The notice acknowledged that the momentary silences were annoying but that it was out of their control. Basically it said, please don’t bug the manager if the sound drops out, unless it lasts more than a minute. 

Repeat after vowe: DRM is bad for the customer

As many of you may know, I am originally from Sweden. A small, neutral country in northern Europe, who have not been in war since 1814. Sweden have been having a fairly strong defence force, at least until about 10 years ago, when budget cuts been reducing it to basically non-existant… Sweden always had a conscript army, like most European countries. All males must serve for about a year around the time they turn 20, and I served 11 months in the Air Force. There are pros and cons to this system, of course. The pros are that you have a huge army trained, and can call it up in case of war. The cons are that you need to pull the men out of their regular jobs every few years for additional training/repeat training. Due to budget cuts, that has not been done on a larger scale for the last 20 years or so.

Anyway, the mobilisation is supposed to take 72 hours. To protect the mobilisation, as well as important locations and object (bridge, air fields, TV towers/buildings and other infratructure sensitive to early attacks and/or sabotage), a volonteer unit called the Home Guard was established in 1940.

I joined a youth company in the Home Guard when I was 15, and served there for 13 years, until I moved to the US. Yes, we could join at age 15. The first year we did basic stuff: marching, erecting tents, recon, operating radios, target practice with bolt action rifles, using map and compass, etc. At age 16 we started learing assault techniques, ambushes, and combat skills, still with bolt action rifles. At age 17 we got full automatic weapons (sub-machine guns and assualt rifles). I spent many weekends out in the field on manouvers, while other kids at school were out partying or having fun. I did not expect any thanks, I did it because I cared about my country and was willing to make sacrifices to protect it. People were actually sometimes making fun of us.

Later, after my miltary service, I transferred to a regular unit of the Home Guard, and continued my training. We actually got paid, the same amount as a conscript soldier. That meant about 5 dollar a day back in 1991/92, for each 8 hours of service. A weekend manouver counted as 4 or 6 hours… So nobody did this for the money.

Last spring, I went to a Nascar race here in Texas. I went to watch a movie about the US Air Force with my son, and a female soldier came in and wished us welcome. She asked "is anybody here in the service or a former service man/woman". A couple of people raised their hand, and I did too, even if I did not serve with the US military. I thought she was just going to see how many were military/ex-military. She then said "Thank you for your service" to each of us. That was amazing. In 13 years, nobody in Sweden said a word of thanks. Here in the US, people respect your soldiers in a way you should be proud of. You may not support the war, but I feel the soldiers are supported and rightly so. I have to admit, I was choking up when I was standing there. I think I actually teared, it was a very emotional moment for me.

On my mother’s side of the family, I have a long tradition of soldiers. My mom was from Germany, and grew up during WWII. She was 19 when the war ended, and she had to run from her hometown to avoid the advancing Red Army troops. My grandfather, who also served in WWI, became a POW with the Russians after he served on the Eastern front.

My uncle, Karl-Heinz (whom I am named after) served as a glider pilot in the Luftwaffe, taking part in the airborne invasion of Crete in 1941. Later in the war, when Germany was pretty much out of fuel, he was assigned to a anti-aircraft regiment who was part of the Luftwaffe. On February 26, 1945 he was shot through the left lung. On March 10 he arrived to a hospital ship in Denmark, but on March 16, he died from his wounds and infections. My mother also lost a sister a year later, due to Diphteria.

My aunt in Germany married a veteran from the French Foreign Legion. He served for 9 years (1951-59) in several parachute regiments, in Indochina (Vietnam) and North Africa. He jumped over Dien Bien Phu and was a POW for 2 years.

No matter what politics you support, and what you think about the government, you have to respect the soldiers doing the fighting.

So, for all the soldiers, in all countries: Thank you for your service to your country.
 

The other day I saw a posting in comp.groupware.lotus-notes.programmer, where the poster said that he have been defending Lotus Notes from people that dislike it and want to get rid of it.  I asked what problems the users had, and this is the response:

This is the only application we have in Notes – we do use notes mail –
but it is the application that is giving Notes a bad name.
It is the result of a extremely bad design and implementation of an
application 12 years ago in Notes 4.5.

The application – a customer order configurator – was created by
someone else in a branch of the
company which sold us off so the designer/programmer is no longer
available to us..

This has been compounded by massive changes over the last 6

years. I have added 2 new databases  (6 databases now) and possibly

140,000 lines of code to the application over the last 6 years. However
this has been hampered by the original bad design.

 This results in users getting annoyed rather frequently.

So basically, one badly written application, probably developed by someone that was not a programmer or did not understand Lotus Notes, then patched over 12 years is giving Notes a bad name… What can be done about things like this? There are some (old) best practices out there, but perhaps it would be a good idea to write some new ones.

The other day I was writing some code where I had to check a value against a list of potential values. I was importing a file as XML, and checking a number of transactions, each in their own node. If the Trans-ID tag had one of several values, the whole node was supposed to be discarded and not used.
I am sure many already use this method, but hopefully someone will learn something new.
In my example below, I am reading a field in a Notes document instead of data from an XML file, but the principle is the same:

tranType = Ucase(doc.GetItemValue("txn-type"))
If Instr("PD;DR;RP;NSFNF;RD;CRT;RCT;VCK;TPD;RCK;", tranType & ";") Then

End If

What I do is to use Instr() to check a string (the first argument) for the presence of a particular string (the second argument). To make sure I don’t get any false matches, I add a semicolon to the end of the tranType as well as use the same character to separate the values in the first argument.

The Instr() function returns the position of the string found (1 or higher if found, 0 if not found). Since 0 is "False" and everything else is "True", if the tranType string is found, a value greater than 0 is returned, which is considered "True".