Recent Posts

576

N.A.N.Y. 2018 / Re: Mini Clip Mon

« Last post by Ath on December 05, 2017, 01:34 PM »

At the moment, iCloud is giving an error on the download. (It was my script blocker kicking in, sorry) You'd IMHO be better off attaching the zip to the post (and downloads are counted for you).

577

General Software Discussion / Re: Software timers and interrupts on a microcontroller

« Last post by Ath on December 05, 2017, 01:29 AM »

Any particular reason you choose such low-level hardware? A little more sazzy and easier programmable, IMHO, would be an ESP01 or ESP12 (ESP 8266 Wiki^w) or an Arduino^w or an even more high-level Raspberry Pi^w.

578

General Software Discussion / Re: Downloadable Office trial

« Last post by Ath on December 04, 2017, 01:54 PM »

MS is moving/pushing consumers to their subscription model by default. You might want to search for Office 2016 explicitly (try this MS link) that should be usable without registration for 30 days. Didn't try it myself though.

579

Post New Requests Here / Re: DONE: Single Application Instance

« Last post by Ath on December 03, 2017, 05:15 AM »

The code above (posted by Skwire) uses "MozillaUIWindowClass" (twice), but the current FireFox (v57.x) has the classname "MozillaWindowClass", so you might want to adjust the code, compile, then re-try.



And maybe it needs to be compiled for 64 bit, as FireFox by default is now installed in its 64 bit incarnation.

580

Post New Requests Here / Re: IDEA Data extraction and convert to CSV

« Last post by Ath on November 28, 2017, 02:26 PM »

I've updated Doc2CSV to version 1.1.0.0, adding command-line parameters for separator, delimiter and output filename, defaults same as v1.0.0.0.
Download above from the original release-post, including updated usage info.

581

General Software Discussion / Re: Cool Retro Music Devices

« Last post by Ath on November 28, 2017, 01:19 AM »

I've got a 30 year old Curtis Mathis stereo in my garage (for shop music) does that count?

-Stoic Joker (November 27, 2017, 10:56 PM)

Only if you share a picture of it

582

Post New Requests Here / Re: IDEA Data extraction and convert to CSV

« Last post by Ath on November 27, 2017, 12:54 PM »

should be able to do this (import a txt file, and parse to a table.query) directly using access

-Target (November 26, 2017, 11:46 PM)

Well, I haven't installed MS Access on any computer near me for many years, so that wasn't a viable option. I was almost going to ask if it wasn't supposed to read MS SQL instead of MS Access...
And being a Java/C# style programmer, VBA feels really awkward to me (though I've done small VB/VBA projects in the more distant past).

583

Post New Requests Here / Re: IDEA Data extraction and convert to CSV

« Last post by Ath on November 26, 2017, 03:17 PM »

So, I've written this in Java, and running it requires a Java runtime environment to be installed on your computer (Windows or Linux).

Doc2CSV
Version: 1.1.0.0
Released: 2017-11-28

Purpose
Convert a 'column@data' formatted file to a .csv file.

First column name found triggers a 'next record'.
Columns are in the order they are found in the file, so adding a complete first record gives you control over column ordering.
Empty lines, or lines without the @ separator are ignored.
Whats new:
Separator and delimiter can be changed using command-line parameters.
Outputfile can be specified from the command-line.

Installation

• Download the zip file attached to this post
• Download and install an Oracle Java JRE (I've been testing with Java 8, but Java 9 should work AFAICS)
• Unzip the contents of the zipfile to it's own directory (keeping the directory structure intact, on upgrade: overwrite all files)
• On Linux: rename the start-run.sh script to start-run and make it executable

Running the conversion

• Open a command-prompt in the application directory
• Export the .doc file as text
• execute: start-run {exported-text-file} (a full path/filename can be used, see below for optional parameters)
• Wait for processing to complete (should be a few seconds)
• Check the output in the created file (same as the inputfile but with .csv appended, any previous outputfile will be overwritten)

Command-line parameters

• -s {separator character} : specifies the separator character used in the input file
• -d {delimiter character} : specifies the delimiter character used in the output file
• {input filename} : first non option (-s or -d) specified, required!
• {output filename} second non option (-s or -d) specified

NB: The separator or delimiter character support specifying \t for using the Tab character.
NB: If {output filename} is not specified or equal to {input filename} (name compare only!), then {input filename}.csv is used.
NB: The order of parameters is not important, except for the {input filename} and {output filename}.

Possible enhancements

• Make the column separator (,) configurable and/or a parameter
• Make the input-data separator (@) configurable and/or a parameter
• Do you need a GUI? It can be added but will take some time
• Process .doc files directly (rather easy, but because of response time not done yet)

584

Post New Requests Here / Re: IDEA Data extraction and convert to CSV

« Last post by Ath on November 26, 2017, 01:26 PM »

I've come to this, so far:
Input:

[Select]

fieldname1@data1
fieldname2@data2
fieldname3@data3
fieldname4@data4
fieldname1@data1
fieldname2@data2
fieldname3@data3
fieldname4@data4
fieldname1@data1
fieldname3@data3
fieldname4@data4

Output:

[Select]

fieldname1,fieldname2,fieldname3,fieldname4
data1,data2,data3,data4
data1,data2,data3,data4
data1,,data3,data4

And after adding a few commas in the field3 data:

[Select]

fieldname1,fieldname2,fieldname3,fieldname4
data1,data2,"data,,3",data4
data1,data2,"data,3",data4
data1,,"data,,,3",data4

Missing columndata sample:

[Select]

fieldname1@data1
fieldname2@data2
fieldname4@data4
fieldname1@data1
fieldname3@data3
fieldname4@data4
fieldname1@data1
fieldname3@data3

With this output: (attention: columns are in the order found in the input!)

[Select]

fieldname1,fieldname2,fieldname4,fieldname3
data1,data2,data4,
data1,,data4,data3
data1,,,data3

585

Post New Requests Here / Re: IDEA Data extraction and convert to CSV

« Last post by Ath on November 26, 2017, 11:54 AM »

A question (and more may follow)
- Is the data-part limited to a single line, or can it be multiple lines?

586

Screenshot Captor / Re: LATEST VERSION INFO THREAD - ScreenshotCaptor - v4.21.1 - May 7, 2017

« Last post by Ath on November 24, 2017, 01:34 AM »

FYI: After all these months of trying I was able to download the installer today

-dbareis (November 24, 2017, 01:18 AM)

Did you find what was preventing you to download it earlier?

587

DC Gamer Club / Re: Free Game on Humble Store

« Last post by Ath on November 24, 2017, 01:32 AM »

I kind of wish we could give "likes" or "thumbs up" to posts...

-Deozaan (November 24, 2017, 12:11 AM)

Check out the MARK TOPIC button, bottom right of each topic..., close enough?

588

Found Deals and Discounts / Re: VMware Workstation 14 Pro 40% off today

« Last post by Ath on November 22, 2017, 01:50 AM »

old versions of VmWare hold up just fine.

-mouser (November 21, 2017, 07:26 PM)

Well, compatibility with the newest Windows editions has been troublesome for older VMWare versions, and now especially the latest Win10 CU and FCU updates have proven to have lots of backward compatibility issues, upgrading could be important/useful.

589

Official Announcements / Re: Forum upgraded Nov 20, 2017

« Last post by Ath on November 22, 2017, 01:47 AM »

Current configuration is much better than before, but I guess I'm not much into that brown color. I'll get used to it, now that it's no longer hurting my eyes

590

Developer's Corner / Re: Tomato Custom Router Firmware question

« Last post by Ath on November 21, 2017, 02:28 PM »

This is merely an experiment to see how steep the learning curve is.

-jcase397 (November 21, 2017, 10:57 AM)

Ah, now it makes more sense.

IMHO, you either need to acquire the needed knowledge yourself, or find a colleague/hire someone that has or can get up to speed with this.

591

Official Announcements / Re: Forum upgraded Nov 20, 2017

« Last post by Ath on November 21, 2017, 03:45 AM »

We could put up a poll for that, maybe offering several available options (if any).

It may be caused by my age that I like the 'old' quote style more...

592

Developer's Corner / Re: Tomato Custom Router Firmware question

« Last post by Ath on November 21, 2017, 01:34 AM »

I am looking at possibly building custom firmware using Tomato OS for a custom router.

-jcase397 (November 20, 2017, 04:09 PM)

You are asking strange questions: If you know how to build a custom router, why don't you know/have investigated how to build the software for it?
It seems you are working backward here.

593

Official Announcements / Re: Forum upgraded Nov 20, 2017

« Last post by Ath on November 21, 2017, 01:30 AM »

Great to be up to date, but why do the quoted messages look so ugly (yes that's a personal preference, but still..., brown accent color?, larger font?, large cursive quoted name/date-time?, enormous upside-down-quote added?)

I just updated the forum ...

-mouser (November 20, 2017, 08:43 PM)

screenshot of the above:

594

Finished Programs / Re: FINISHED: Reopen file after Wifi reconnects

« Last post by Ath on November 16, 2017, 01:27 AM »

You might give the free tier of Trello a try

595

General Software Discussion / Re: New faster Firefox browser released

« Last post by Ath on November 15, 2017, 01:25 PM »

Well, I've been 'improving' the minimum tab-width on my updated FF installs, as the default of 76px is quite narrow, so IMHO quite a silly default value (read: not really backward compatible).
And I've been a bit disappointed that even popular add-ons like NoScript don't have their updates available yet, while the release-date of this breaking FF version has been announced many moons ago. But that may just be me, working in the software industry for 30+ years. Planning has been flawed/poor for many developers (including myself )

596

Finished Programs / Re: FINISHED: Reopen file after Wifi reconnects

« Last post by Ath on November 15, 2017, 01:25 AM »

Just to clarify, the source file is regularly updated by someone else on a different machine. The dashboard setup, with a query to the source file, is to avoid "Locked for editing by..." messages.
If there's a more painless way to do this, I'm all ears! My know-how is quite limited in regards to database/HTML, but I'm pretty computer-proficient in general and a fast learner. 

-wysiwyg125 (November 14, 2017, 11:14 PM)

I guess we'll need to have a little more insight into the type of information, and where it originates, stored in the Excel sheet, to help you further. (With a +1 to shades' reply )

597

Living Room / Re: Large yet compact storage

« Last post by Ath on November 12, 2017, 01:22 PM »

Get a larger ssd to replace the one already there, assuming you can access/replace the current drive. (newer consumer-laptops won't let you do that though)

Install a (large) SD carrd in the slot (most laptops have such a slot).

598

Living Room / Re: Looking for smartphone

« Last post by Ath on November 12, 2017, 01:16 PM »

Type it in another app using the standard keyboardlayout, like whatsapp, select and copy the number, then paste it where you need it.

599

Living Room / Re: Looking for smartphone

« Last post by Ath on November 10, 2017, 09:29 AM »

I would expect that your provider only allows local numbers, not international notation with a + in front. Many countries use the 0 instead of +<countrycode>, I'm not sure what your country/provider expects.

600

Screenshot Captor / Re: Sending PageDown command in Post Capture CommandLine option

« Last post by Ath on November 05, 2017, 02:33 AM »

The scrolling capture feature of Screenshot Captor should get you what you want to achieve, but it will produce 1 very long image file.

Combining the commandline version of Screenshot Capture (minicap) with my WinSendKeys could produce you a screenshot per page, it'll require some experimenting, but you'll get there