Category Archives: Blog News

News about me, my family and anything I comment on from the global news fronts.

TP-Link TL-WPA4220Kit

TP-Link, D-Link, Devolo with HomePlug AV are all compatible

I just bought a new TP-Link starter kit to replace my last Devolo device (since I’m not a fan of Devolo anymore). Cheap when compared to other devices, especially as it has 2 ETHernet ports, which is what I was looking for.

The title on the box of the TP-Link starter kit, however, is a bit misleading : 300Mbps AV500 Wifi Powerline Extender Starter Kit.

My eyes just skimmed over the first words (300Mbps) and I immediately went looking for another device than this, because I was searching for a *500* Mbps AV device. Not a 300 Mbps.

I took me a few times to actually completely read the description on the device (after looking at more expensive devices). Turns out that it is actually a 500Mbps AV device, and the 300Mbps is for the WIFI part of it !!

TP-Link, you might want to change that… Customers might think like me that this is a 300Mbps device and go for another device.

The devices itself are small. The plastic does not feel perhaps as sturdily made as Devolo or D-Link, both of them seem like big blocks compared to the TP-Link device. However, that is not what you buy it for… So far, the TP-link devices certainly work, with almost zero setup.

Using WPS on the router I activated the Wifi-Cloning at the TP-Link device, a few blinks, done, and then it automatically repeated my wifi. Where the wi-fi reception in the kitchen was guaranteed to be close to non-existant, due to the router being behind multiple walls with different angles all the way at the other side of the house, suddenly reception of my network is now between 3 and 4 bars ! ETHernet ports work as well, as I can stream video from my NAS to my tv.

I can also confirm that TP-Link, D-Link and Devolo all happily talk to each other – as long as it states on the box that they are AV Homeplug compatible they should work fine together !

logo

Importing a comma-separated csv file into Numbers Tool

I created this to scratch an itch of mine when reading a csv file into Numbers that contained commas. It turned out that Numbers puts each line into a single cell. It ignores the commas. And there’s no way to specify that the delimiter needs to be a comma, not a semi-colon.

Here’s a small tool made using a small python script and Platypus that will launch as a ‘droplet’ and will allow you to drop a csv file on it that has COMMA (meaning this , ) separated values.

It will accept any csv file and convert from commas (,) to semi-colons (;) and save the result out again as “filename2.csv” – Numbers should be able to open it correctly then. Your original csv file is only read.

It works on my smallish csv files, but please note :

! WARNING ! THERE ARE NO GUARANTEES THAT THIS WILL WORK FOR YOU – YMMV ! WARNING !

Please note there is NO feedback if something goes wrong.

It works on my 2 macs (using OS X Mavericks), so I figured I would throw it out in the wild for those people who also might need it.

You can download the (non-signed) app here : Com2DotCom.app – you’ll need to open it using RIGHT-CLICKING on the App the first time.

Feedback, comments, bug reports, etc are very welcome. If possible, I’ll try to respond and help you out.

Apple iWork updates : Numbers becomes slightly more useful

Some new iWork updates this morning on my Mac Mini : KeyNotes, Pages and Numbers can now save password protected documents, can now display charts based on time series, more compatibility with MS Office Documents.

iOs Keynote Apps have received similar updates.

You can now do some things with Numbers that Office Excel already can since ages : sort on multiple columns, chart on time series… Progress!

All in all a good update, but frankly, this is late in coming, and the updates should continue coming to get even more functionality in there. I understand that this is a from-the-ground-up-rewrite, but these functionalities are what people expect from the start, not delivered 6 months or more waiting for it.

Now if only with the new version I could figure out how to updating an existing chart line with a new entry that is in the same column as 4 other chart lines…

I have one column of numbers that has a monthly entry for each measurement. Multiple years in one column. I want to graph each year in this column separately. This works, but when I add a new monthly measurement at the end of the column and try to update the appropriate graph line, this results in a mess of graph lines.

So far, I haven’t found it, except redoing the whole thing from scratch. Somehow I expected a more intuitive process on doing this, but perhaps my intuition is failing me on this, or I have been brainwashed too much by Excel :-)

Also, what is really bothering me is importing a csv file that has “,” separated values instead of “;” separated values. This results in the whole line being imported into the first cell, as Numbers expects “;” for csv. Nothing else.

I can’t even *FIND* the “import” command, you can only OPEN a CSV file in the regular way, and there are no options possible to indicate HOW you want to open the file / import it. Very disappointing.

Apple, please keep the updates coming, and make Numbers something worthwhile to use. Meanwhile, I have to write little scripts to do my work for me.

Just updated to WordPress 3.8

I just updated to WordPress 3.8 – phew !! Sure are a handful of changes. Not too sure about the newest template, I’ll leave it activated for now, but it’s not how I want my site to look…

For example I have put all my widget elements in the right side container, so my blog posts can have a bit more space. Apparently this is not possible by default, as the text just stays centered in the middle instead of taking up all the space as intended. The theme as-is also seems not to be fully responsive, as it does not expand past a certain size… hmmm. Needs some investigation.

Sonos Play:1 is marvelous !

Sonos Play:1 speaker

Sonos Play:1 speaker : great sound for a (relatively) small price

I just bought 2 Sonos Play:1 speakers for my living room, with the free bridge included (the offer lasts till the end of 2013, so you people who want to start with collecting Sonos speakers should hurry). Sonos speakers have been on my wish list for quite some time, ever since Vowe mentioned them on his blog, but they were always too expensive. Till now, with the Play:1 speaker coming out for a relatively cheap price of 199 euros. Still ‘ouch’ but it’s doable.

I was originally going to start out with one speaker, but due to circumstances I ended up with 2…

One speaker I originally bought from MediaMarkt.be, but at that moment they were out of stock. So I reserved one and paid an advance, hoping it would soon turn up. After 2 weeks they still didn’t have new stock, so I got a bit unhinged and in a fit I ordered from an online shop : bol.com and promptly got it delivered the next evening ! Kudos to Bol.com for their shopping experience and followup !

Then the same week I went back to MediaMarkt on other shopping needs, and guess what I found : a delivery just arrived from sonos, so I caved in and bought another one :-)
(Two Play:1 speakers can be grouped as a stereo pair)

I had a hard time believing all the sonos hype about the setup and usage, but in my case it was all true : plug the Bridge in, plug the speakers in, install the app, follow the instructions on the app to link everything, and I was playing music in about 10 minutes (unwrapping included) !!!

A further 10 minutes I had my iTunes library linked to it (it should have been 5 minutes, but apparently you can’t have an apostrophe in your mac’s name for sonos to link up your library, and I had to look it up and rename my mac – no biggie).

You can really hear the difference to my other bog-standard Pioneer DVD 5.1 surround system when playing Jazz – when listening to Dianne Krall I could -for the first time- hear the individual sounds, even the champaign popping sound she makes !

I’m pretty happy with my Sonos setup, and I’ll guess I’ll start saving up for some other speakers in the future…