Recent Posts

3201

Skwire Empire / Re: Birthdays (simple birthday tracking app)

« Last post by Ath on March 21, 2011, 10:09 AM »

* Double-clicking a birthday will now edit it.

-skwire (March 21, 2011, 09:50 AM)

Could a Double-Click on an empty spot be turned into Add birthday, instead of an errormessage? That's a bit more intuitive, IMHO

For the rest it's just steady as a rock

3202

Screenshot Captor / Re: New pixelate effect for Screenshot Captor

« Last post by Ath on March 21, 2011, 08:24 AM »

Great feature! Got a planned releasedate yet?

3203

Found Deals and Discounts / Re: 48hrs Adept PDF to Word Converter

« Last post by Ath on March 20, 2011, 04:37 AM »

Nice find!

I tried it quickly on an invoice I received, and though the layout, when selected for most correct layout, is indeed a bit awkward to edit, it sure does look like the original pdf document.

Thanks.

3204

Official Announcements / Re: March 2011 DonationCoder.com Fundraiser Celebration -- Pledges?

« Last post by Ath on March 19, 2011, 03:57 PM »

I've released the Coding Snack I pledged for today in it's thread, over here

Please comment, so I can improve it further

3205

Finished Programs / DONE: HTML Mail Merge 2.0.1.2

« Last post by Ath on March 19, 2011, 03:53 PM »

Application Name	Excel2Html
Version	2.1.0.0
Short Description	Convert Excel data (row based) to html output, based on a template
Supported OSes	Windows, Linux (tested on Ubuntu with Sun/Oracle Java 6)
Web Page	This thread and This DCMembers page
Download Link	v2.x: Complete package from the DCMembers server v0.x: Attached to this thread (available but no longer actively supported)
System Requirements	Java Runtime Environment 6 (or newer) Microsoft Excel installed and working (v0.x only)
Version History	2.1.0.0: 2012-03-02: Added tags to loop over all rows, also in single-file mode 2.0.1.2: 2011-07-27: Added Linux .sh script like the Windows .cmd script 2.0.1.1: 2011-07-27: Added command-line options -sf and -dt 2.0.1.0: 2011-07-26: Resolved an issue with formulas not giving the expected result but the formula text instead (full re-download required) 2.0.0.0: 2011-07-25: Complete rewrite in Java, feature, config and command-line compatible Only one exception: the message timeout option (-et) isn't needed and so not implemented in v2.0 0.5.0: Bugfixes and a few extra features<br/>extra logging options<br/>Suppressible messageboxes on error, with timeout (60 sec) 0.4.0: First released version
Author	Ath

Description
A command-line tool to convert Excel data into html like the Mail Merge feature of Word. Created as a resolution to this until now unfinished Coding Snack, during the March 2011 fundraiser event.

Features
Convert Excel data into 1 big html table (singlefile mode) or each row into a single html file, or multifile mode where the names of the file can either be based on row number of column data (multiple columns can be used), and each column can be output anywhere the html based template allows. Startrow and Maxrow can be set by parameters.

Planned Features

• Remove the requirement of having Excel installed locally (involves rewriting in Java...) Now realized with v2.0
• Filtering of data, if requested by users.
• User request, anyone?

What's new

• v2.1.0.0 2012-03-02, Ath
• + Added 2 new tags for looping over all rows of the excel sheet (as defined by the -r/-s/-m parameters) (suggestion by DeVamp)
• + Added an xml example for looping
• * Readme updated for the new tags
• v2.0.1.2 2011-07-27, Ath
• + Added excel2html.sh after some testing with Excel2Html on Ubuntu linux (should be set to executable to run directly)
• * Updated readme accordingly for some linux differences
• v2.0.1.1 2011-07-27, Ath
• ! Documented -sf parameter to enable ShowFormula, displaying [formula text] with the result of the formula (for testing)
• + Added -dt parameter to Display all Tags supported in the template
• v2.0.1.0 2011-07-26, Ath
• ! Fixed issue with not handling formulas correctly, by replacing poi-ooxml-schemas-<version>.jar by ooxml-schemas-1.1.jar
• v2.0.0.1 2011-07-26, Ath
• * Improvements to the build scripts to automatically produce -nolib archive and publish.version archives
• * Sets errorlevel to 1 when an error occurs, so the batch file can jump to a pause to keep the message in sight
• * Sets errorlevel to 2 if something goes awry during processing of the Excel file to html file(s)
• * Some minor source and javadoc improvements

Usage
Installation

• Unpack the contents of the zipfile into it's own directory
• Create a template with markers as documented in the readme file
• Optionally: Configure parameters in Excel2Html.ini

Using the Application
Specify any not yet configured parameters on the command-line to Excel2Html to produce the html file(s)

Uninstallation
Remove all files from the computer

Known Issues

• Date display is somewhat problematic, though usable

3206

General Software Discussion / Re: Best Text Expander software for Windows

« Last post by Ath on March 17, 2011, 05:44 PM »

I agree on regexes being an elegant solution to many problems, that would otherwise could be difficult to solve.

ppl scared of any regex, posted their opinion, that I quoted (without the quotes, sorry) above, that's the pessimistic group. I'm not in the pessimistic group...

3207

General Software Discussion / Re: Best Text Expander software for Windows

« Last post by Ath on March 17, 2011, 04:28 PM »

in one elegant expression

-timns (March 17, 2011, 04:24 PM)

Agreed, but the pessimistic still complaint that: You have a problem, you apply/throw a regex at it, then you have 2 problems...

3208

Found Deals and Discounts / Re: JetDrive Defragmentation Suite

« Last post by Ath on March 17, 2011, 03:10 PM »

And what was the brand of the harddrive in that machine? A Maxtor perhaps? These disco's are known to get slower and slower after several years of use, though I've not been able to do any measurements on them

3209

N.A.N.Y. 2011 / Re: NANY 2011 Release: JottiQ

« Last post by Ath on March 17, 2011, 03:02 PM »

Well, I've been behind a proxy (here, at home) for over 14 years now, and that was just because my ISDN connection could be turned of and off by the proxy software, and I sticked with it because all my e-mail configurations would have to be changed again and again. And for the extra security ofcourse, as there's also a firewall on that machine.

Not sure if I can configure it to do the authentication without messing things up big time, here, but I'll try, just for fun, or set up something in VMWare Will probably end up sometime next week, though (assuming you're ready before the weekend), got a busy weekend ahead.

3210

N.A.N.Y. 2011 / Re: NANY 2011 Release: JottiQ

« Last post by Ath on March 17, 2011, 07:03 AM »

That are the default 'Login credentials' pages of these browsers, so I'm afraid that JottiQ is going to need it's specific proxy authentication settings page

3211

Mini-Reviews by Members / Re: Bringing the computer into PnP RPGaming

« Last post by Ath on March 17, 2011, 02:47 AM »

Very impressive!

3212

Site/Forum Features / Re: Fundraiser ONE-A-DAY Planning Calendar, Please Volunteer

« Last post by Ath on March 16, 2011, 02:30 AM »

Ok, I'm working on another coding snack, that I can have finished & polished enough to be released on the 19th. No teaser screenshots, as it's a command-line utility.

3213

Mini-Reviews by Members / Re: Mini-Review: Clock-on-Desktop from Positbolt Software

« Last post by Ath on March 16, 2011, 02:19 AM »

Not that I'd buy an on-desktop-clock, for any particular reason, but I do like this Mini-review But would I need a multi-timezone clock, then this would be a likely candidate.

Thanks Tim.

3214

Living Room / Re: USB Madness With Cooked-Off Ports

« Last post by Ath on March 15, 2011, 06:24 PM »

i don't even know why these tech articles focus so much on those stupid performance graphs anyway.

-superboyac (March 15, 2011, 06:05 PM)

That's for good old marketing's sake: Bigger numbers are better, and they give great graphs to convince those manager types, deciding on what us, techies/mere users are 'allowed' to buy

3215

Adventures of Baby Cody / Re: Baby Cody arrives in Stuttgart, Germany

« Last post by Ath on March 15, 2011, 03:29 PM »

... Strasse 255 (aka 0xff) ...

-gjehle (March 15, 2011, 03:14 PM)

LOL

3216

N.A.N.Y. 2011 / Re: NANY MUGs

« Last post by Ath on March 15, 2011, 12:49 PM »

Nice kid, looks like he can hardly lift that big mug

You could have asked him to make a picture of you, there

3217

Skwire Empire / Re: Release: sWeather (tray-based weather app)

« Last post by Ath on March 15, 2011, 12:46 PM »

Nice table of useful information that you added, thanks.

1 request: Can the column widths be saved? The window size and position seem to be saved, but all adjusted columns are back to default width when re-opening the view.

3218

Found Deals and Discounts / Re: JetDrive Defragmentation Suite

« Last post by Ath on March 14, 2011, 02:11 PM »

And do remember that Windows Vista and 7 have their own kind of defragger, to place applications and associated stuff in optimum locations, when it's idling.

Source: msdn blog

So many folks came to know that if your machine is slow you had to go through the top-secret defrag process. In Windows Vista we decided to just put the process on autopilot with the intent that you’d never have to worry about it. In practice this turns out to be true, at least to the limits of automatically running a process (that is if you turn your machine off every night then it will never run). We received a lot of feedback from knowledgeable folks wanting more information on defrag status, especially during execution, as well as more flexibility in terms of the overall management of the process.

3219

Finished Programs / Re: DONE: On Screen Button That Sends Keyboard Commands

« Last post by Ath on March 13, 2011, 03:47 PM »

A minor WinButtons update to 2.0.1

I've removed the restrictions of top and left being confined to the width/height of the main monitor. Any position checking should be done by the user, most of them are old enough

Updated download in the original release post

3220

Post New Requests Here / Re: IDEA: A Custom Page for Inno Setup showing DoCo info and donation benefits

« Last post by Ath on March 13, 2011, 12:54 PM »

Well, pending this discussion, I'm inclined to postpone the release of this add-on/plug-in thingy for a bit.

Comments welcome, as always.

3221

General Software Discussion / Re: original win98 games

« Last post by Ath on March 13, 2011, 12:36 PM »

Ok, so I'll stop searching for my old Win 98 Plus CD I thought I had laying around somewhere, seems I didn't keep it during one of the bigger clean-ups I did during the last 10 years

3222

Living Room / Re: Interesting calming essay about nuclear power plan situation in Japan

« Last post by Ath on March 13, 2011, 12:34 PM »

I fully agree. A clear and concise write-up of how and why things happened.

Didn't get to read it completely yet, but I'll continue later.

3223

General Software Discussion / Re: original win98 games

« Last post by Ath on March 13, 2011, 11:33 AM »

I recently setup a virtual 98 and am wanting to find the games.

-techidave (March 12, 2011, 02:50 PM)

Do you have a special purpose for that virtual? I can't see much use for it, besides the quick boot-time on modern hardware, but usually more modern virtual machines, like those running WinXP, revive from paused state quick enough and have a bigger feature-set and matureness over W98.

3224

General Software Discussion / Re: Simple Commandline to send Keystrokes (WinSendKeys)

« Last post by Ath on March 13, 2011, 11:26 AM »

Now you need a web page and a pad file so others can discover this.

-mouser (March 13, 2011, 11:23 AM)

The pad file I can take care of myself, but a site... If you could help out with that...

3225

General Software Discussion / Re: Simple Commandline to send Keystrokes (WinSendKeys)

« Last post by Ath on March 13, 2011, 11:08 AM »

if we could pass in the window HANDLE.

-mouser (March 13, 2011, 10:49 AM)

I can take care of that

Another feature request taken care of: WinSendKeys 3.0.3

Latest release & download moved to separate thread

The small changelog since 3.0.2:
; 2011-03-13, version 3.0.3
; * Improvement: A numeric WindowName is now treated as a WindowHandle (HWnd), as requested by mouser

Source, exe and readme included the attachment