Recent Posts

3201

Living Room / Re: Android tablets to rival iPad

« Last post by Ath on March 22, 2011, 05:07 AM »

but it needs to be about 1/2 the price.

-Deozaan (March 21, 2011, 09:27 PM)

Isn't that true for all the real good stuff

3202

Finished Programs / Re: SOLVED: New Folder by F-key for Windows 7

« Last post by Ath on March 22, 2011, 05:06 AM »

Just installed v1.2, and the F8 function, when specified on the command-line, works as expected in Windows Explorer, but I can't seem to get it to work on the plain Desktop. And <Ctrl-Shift-N> does work there, so maybe the filtering is a bit too tight?

I'm on Win7 Ultimate, Euro-English language but locale (number- and date- formats etc.) set to NL.

3203

Finished Programs / Re: SOLVED: New Folder by F-key for Windows 7

« Last post by Ath on March 21, 2011, 07:06 PM »

Euhm, maybe a bit blunt, but as an Explorer2 user, I'd favor <F8> (New folder) over <F7> (New file). Would there be a possibility to either include the source so I can change that myself, or add a command-line parameter to specify the (function)key to use?

3204

Finished Programs / Re: DONE: HTML Mail Merge: Update

« Last post by Ath on March 21, 2011, 05:23 PM »

Well, I found a few bugs, related to the speed of release, that obviously cut some corners in the testing department

Also added a -m maxrow option, made any error messageboxes autoclose after 60 seconds and completely suppressible by -q parameter.

Download from my original release-post, above

3205

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

« Last post by Ath on March 21, 2011, 04:25 PM »

Well, as an Android user, I'm interested

3206

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

« Last post by Ath on March 21, 2011, 12:30 PM »

Thanks

3207

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

3208

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?

3209

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.

3210

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

3211

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

3212

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...

3213

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...

3214

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

3215

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.

3216

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

3217

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

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

Very impressive!

3218

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.

3219

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.

3220

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

3221

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

3222

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

3223

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.

3224

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.

3225

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