GoPro SD card problems

Sunday, 30th April, 2017

Bit random for a spreadsheet blog I know…

I am putting this here because I found a fix, and I know from my own searches other people have exactly the same issue: disc full, no sd, sd err on gopro.

One of the kids deleted some files from the GoPro SD card on the mac, but didn’t empty the ‘trash’ before ejecting the card.

What a fookin pain in the arse!!! (Thanks Apple.)

Not sure exactly what misery Apple inflict on the card in this case but it really upset the gopro, really.

Initially the gopro just kept saying disc full (because macs don’t delete files, they just reclassify them – until you clear the ‘trash’)..

I reformatted the card in disk utility on the mac, then the gopro kept cycling through the above errors, either disk full, no SD or SD error.

I reformatted it in Linux, same crap, tried Windows (normally a good bet) same shit.

Of course the card was fine in other devices – I think the gopro is a bit sensitive, and a bit incapable of formatting the cards for itself. Nomally I clear the cards on a tomputer then put it in the device to format – the gopro wasn’t able.

The SD card seemed to have picked up a second partition somehow, but even after removing that the gopro wasn’t happy, a few resets didn’t help.

Then I saw a post suggesting this. A specialist SD card format tool from the SD Association. Its a free tool that does what it says – formats SD cards – but seemingly better than everyone else. It took about 5 mins, instead of the 30 secs with all the other things I tried. But IT ACTUALLY WORKED! Yay.

The whole episode cost me a good few hours of buggering around, and I was on the verge of just retiring the SD card or saving it for a gadget with better formatting capabilities. I hate it when technology beats me so I was pleased to get it sorted.

So anyone else having SD card problems with their gopro check out the SD card formatter from the SD Association (I am assuming it hasn’t opened up some GCHQ/NSA backdoor on my pc!)

cheers

simon

10 year birthday

Sunday, 12th February, 2017

I missed it obviously but one of the kids pointed out I have been blogging here for 10 years! ken ell!

(as of January just gone)

I can’t imagine dragging it out for another 10, unless some spreadsheet miracle happens and I am sucked back in. I still think spreadsheets are brilliant at a great many things, I have just given up waiting for numb nuts management to realise.

I built a random mental maths test generator for the kids the other day. I looked at doing it as an app, as a web thing,  but in the end I did it in a spreadsheet in about 10 minutes. The kids hate it!

I love it!

(it even has a bit of VBA in it – woo hoo)

cheers

simon

LinkedIn

Friday, 10th February, 2017

just a little FYI. If you are one of the few non-spammers trying to connect with me on LinkedIn, the site has been broken for me for months and months. So sorry for not accepting your invites – I couldn’t get on the site.

I have now fixed this and been on an accepted all the plausible sounding invites.

Bear in mind I don’t really use that site and I am not very active in Spreadsheets or Office dev anymore.

ie so if you read this don’t feel the burning desire to link up…

cheers

simon

Office 365 subscriptions

Sunday, 5th February, 2017

I saw this the other day. Not sure how come as I don’t think I was looking for Office stuff. Anyway the author is suggesting that Office 365 subscriptions fell off a cliff in 2016.

Obviously I have no idea as I have never used it, I have an old 2010 installation that I use occasionally (and a dusty old Classique on an old machine somewhere) and other than that I am on LibreOffice. Except for the odd Google sheets messaround.

Are any of you using Office 365?

I really hate renting software. really. I bought my house (with a little help from the bank of course – spreadsheeting was never THAT lucrative…), I bought my car, my clothes, my phone, my toys. I don’t like renting. Why would I rent software?

I looked at Adobe creative cloud for photos, even did a trial (they allow 7 days – WOW Adobe Generous – not), in the end I decided it was not worth 8 quid a month. Good call – they just put it up to a tenner a month.

The renters (of Adobe CC) seem to be in two clear camps: those that pay it and think its cheap, especially in relation to the thousands spent on camera equipment, and those that resent the lock-in and are just waiting for some viable buyable alternative.

Who rents Office 365 when they can buy a perpetual licence version? or get a web based office for the price of letting Google snoop through all your stuff to sell you shit?

cheers

simon

Google sheets

Monday, 19th December, 2016

We have been using Google sheets a fair bit recently as our spreadsheet of choice. The kids can use their phones for data gathering in the field (eg how many keepy uppyies they do) and then we can fire up the tomputers and do some proper data analysis on it. Again using Google sheets.

This has worked well for trivial stuff but the other day I decided to combine Maths, IT and spreadsheets and it didn’t end well.

In maths we have been doing equations, in IT, programming – so name a couple of variables x and y, create a scary looking equation, loop through a load of numbers and print out x and y, copy and paste into Google sheets and draw a nice chart. Well that’s what happened on the macbook, on the Android tablet the Google sheets app appears so completely hobbled that it does not offer the choice to parse a string into multiple columns. And I could find no way to use the more powerful browser version.

I wouldn’t claim to have done an exhaustive search but initial indications are that the app versions of google apps offer only a fraction of the features of the browser versions (bit weird if you ask me – but hey, I’m old school). And you can’t seem to keep the browser version on android devices. As soon as you click anywhere you are launched into Google drive and its game over, shit versions only. As far as I can tell??

If anyone has a solution to this I would be very interested. I would like to use the more powerful browser versions of google apps on an android tablet please.

ps the Excel app has the same limitation as far as I can tell.

Or if you have a suggestions for a better spreadsheet for Android I’m all ears…

cheers

simon

New Project

Thursday, 17th November, 2016

Its been a while since I posted, plenty has been happening, but very little to do with spreadsheets.

The latest thing is due to certain factors I don’t want to discuss here, we have decided to home school some of our kids this year, or maybe just this semester, maybe.

Anyway its good fun and quite a challenge, but we have the benefit (??) of teaching/learning the stuff I think is important.

So plenty of spreadsheets and IT generally, but also lots of creative stuff and physical stuff. Because I am one of the cool kids we are doing javascript as the programming language. Because they will be back in ‘normal’ school next year we do do have to grind through most of the standard curriculum stuff too.

They are blogging about it, partly so all the rellys can see partly as part of their revision notes.

Their blogs are here and here.

At the moment its pretty much a full time occupation for me so keeping me from my Android developer dream.  But I am hoping to palm them off with loads of brightly coloured worksheets so I can get back on track (or put my feet up and finish reading the internet).

cheers

simon

appbuilders.ch

Tuesday, 3rd May, 2016

I went here last week. (In my quest to be a mobile developer).

It was very good.  Zurich last week, down the road in Lausanne in 2017.

I’m not going to compare and contrast to the Microsoft and or Excel/Office events I have been to. But if you are into mobile and near Lausanne next spring (for example after a bit of skiing) you might consider it.

cheers

simon

Leicester City. Champions of England.

Monday, 2nd May, 2016

Get in!

 

Vetting pantomime

Thursday, 24th March, 2016

Hopefully you have heard the phrase coined by Bruce Schneier ‘security theatre’ to refer to a lot of the recent changes in travel security etc. The basic inference is that it looks like security but isn’t really.

I know this because I have had all sorts of things confiscated while trying to board a plane, but have never been arrested. Too much of a threat to take my plastic clamp on the plane but not enough for a life sentence at gitmo. At least I can take comfort knowing that none of the other passengers has a small plastic clamp with which to take over the plane (or the world).

I am now living through a vetting pantomime. I have been offered a (short term) contract at a UK bank, and now ‘just need to go through the security vetting process’.

I need a disclosure Scotland, can’t get one on line as I don’t have a uk address. One suggestion was that I use someone I knows’ address in the uk as my current residence. Hmm – false information?

They want a 5 year work history, which I have provided, but now they want the gaps explaining. Well derrr I’m a contractor, sometimes there are gaps…

No, they want me to send them bank statements for all the gaps! What the fuck for??? They haven’t specified which account so I guess I shouldn’t use the one with all those NSA/KGB payments for leaking vital information? Or at least I should ensure those payments do not fall in a month when I am not in a contract.

Someone suggested it is to see if I have ‘been away’, ie looking for lack of transactions whilst held at her Royal Britannic Majesty’s pleasure. Its a joint account – there are transaction all the time (me putting money in, wife taking it out :-))

What are they going to do with my bank information? How can it help their vetting? it can’t. its stupid. If they came to me with a list of all my accounts then maybe, but thats SC level stuff not mickey mouse 10 week contract stuff.

Why are banks wanting to recruit people that think its ok to spaff personal confidential information all over the interwebs??

That’s right they want me to email them my bank statements, no mention of a sFTP secure upload facility, no details on the usage of the information, the storage, or the expiry/deletion. they just want people who don’t give a shit about information security, incredible.

Leaving aside of course the irony that between me and this bank, only one of us has ever been found guilty of any fraud or criminality. and I don’t (mis) sell PPI or fix Libor rates.

I’m know I am too old and battle scarred for this shit but really…

You’re the bad guy, oh no I’m not you’re the bad guy, oh no I’m not etc etc. He’s behind you…

Aaaanyway if you need a grumpy old fart with just enough knowledge about security to be cantankerous then let me know. It looks like I may be having a gap opened up in my agenda for me…

March 17

Thursday, 17th March, 2016

raise a glass…