16 April 2015

There are other search engines

Google's excellent response to the EC moan about promotion of their own areas in searches, the Android-Google tie-in and other stuff, is on their general blog. (You may need to look back to 15 April). There are other search engines and phones and Brussels bureaucrats need to understand that most people are not stupid. Even if they are stupid there's no reason to impose massive fines on Google. If I were in charge of the algorithms I might be tempted to make some obscure organisations appear first in searches for European Commission or similar. Maybe something to do with cucumber research or techniques for calculating the length of an island shoreline.


Whilst I am quite happy using Google, DuckDuckGo is pleasantly different and may provide some alternative top results of interest.


12 March 2015

Repairing Windows when you don't have the Windows DVD

Win8.1: A setup-disc or flash drive creation tool

Microsoft's Installation Media Creation Tool can download a complete set of Windows 8.1 installation files to your hard drive; it can then automatically set up the files on a bootable DVD or flash drive. Note: Although you're creating Win8.1 setup files, you don't have to run the easy-to-use tool on a Win8.1 machine; you can use a Win7 or Win8.0 system to build the bootable disc or drive.

To start, go to the aptly named Microsoft page, "Create installation media for Windows 8.1." Read the introductory material and then find and click the Create media button. (It's about halfway down the page.) A small file (mediacreationtool.exe) will download and run. (If it doesn't run automatically, locate the file in your browser's download folder and click it.)

The tool will present you with several options for the setup files, including choices for language, Windows 8.1 edition, and architecture (i.e., 64- or 32-bit). Your choices should match the version of Windows you're currently running. For example, if you have an English-language version of Win8.1 Pro, 64-bit installed, then you should choose "English," "Windows 8.1 Pro," and "64-bit (x64)" (see Figure 1).

Figure 1. The Win8.1 Installation Media Creation Tool starts with your selection of language, edition, and architecture.

You'll then be given a choice of installation medium. If you want your setup files on a bootable flash drive — and you have a USB flash drive with at least 4GB of free space — select USB flash drive. If you wish to create a bootable installation DVD, select ISO file (see Figure 2).

Figure 2. The Win8.1 installation tool can automatically create a bootable DVD or flash drive.

Once you've made your selection, the proper installation files will then download to your hard drive, as shown in Figure 3.

Figure 3. The Win8.1 setup files are approximately a 3.25GB download — for either the DVD-based ISO or the flash-drive version.

When the download completes, the Media Creation Tool then burns the ISO to a blank DVD disc or sets it up on a flash drive — depending on which option you selected. (Keep in mind that any data left on the flash drive will be deleted.) Just read and respond to the onscreen prompts. No other tools are needed; the Media Creation Tool handles it all!

When you're done, you'll have a bootable installation DVD or flash drive. You'll also have a copy of the ISO or flash-drive setup files on your hard drive — usually in the C:\Users\{username}\Downloads folder. You may wish to make additional, archival copies of these files for safekeeping.

Booting from Windows-setup DVDs or flash drives

As mentioned at the top of this article, these Windows setup discs and drives are free of OEM-added software. On the plus side, that means no crapware. But the potentially bad news is that there also are no OEM drivers.

That's not necessarily a show-stopper: Your PC might boot and run fine with the generic drivers built into Windows. But the safe and smart thing to do is to download copies of your PC's specific drivers from your vendor's support site. Save the driver files on a disk or drive, and store them with your setup disk or drive.

A final note: Newer PCs sometimes make it hard to boot from anything other than their main drive, making it difficult to actually use a bootable setup/installation DVD or drive to repair, refresh, or reinstall Windows.

The April 17, 2014, Top Story, "Emergency repair disks for Windows: Part 2," covers how to use any bootable medium — even on PCs that are locked down with Win8's Secure Boot and related features.
This excellent information comes from the Windows Secrets people.

03 October 2014

Failure configuring Windows updates reverting changes...

At 2pm I started tidying up a new Windows 8 laptop that I had bought for a friend in the village. After getting rid of a few trial programs that manufacturers insist of including, presumably in the hope that they'll get some commission when people forget that their trial has ended and the payments have started to kick in, I got Windows update under way.

It's now nearly 9pm. For several hours, and by several I mean at least five, possibly six, I was staring at a screen which told me first that x out of 96 updates were being downloaded and then installed. That was reasonably bearable at first but when the next ominous message appeared I felt a chill in the air.

Failure configuring Windows updates reverting changes. Do not switch off.

That's scary. Especially as there was little help from Microsoft on their site which suggested that it might take up to 30 minutes! I read quite a few other posts from people who had had similar problems and it seems that when you have a really really large number of updates then there's an awful lot to download and install and things can go wrong. The sensible suggestions were, if you could ever get back to a normal screen, to pick and choose essential updates only and do them a few at a time. Indeed there may well have been loads in those 96 I was doing that weren't necessary at all. Unfortunately, unless you're prepared to bite the bullet and do what you're not told and switch off there's no way back to a normal screen. So I decided to leave it to it for a while. One chap on a forum post had said that his had taken 4 hours and all had been well at the end so I decided that I would leave it all night if need be and see what had happened in the morning, assuming that some power settings hadn't chipped in and turned the damn thing off anyway!

So it was with some relief that after the five or six hours the display changed and finally I was back with a start screen and what seemed a working laptop!

If you're starting off on something similar then be patient, and hope. You may also be able to download all the updates but be selective in what you actually install if you feel happy taking control of what is normally automatic. As soon as you can, install Windows 8.1 which has significant improvements. You try turning 8 off or switching from those full screen applications! It's all pretty much trial and error but 8.1 adds a bit more control.

09 July 2014

Help needed for iframe code for embedding a spreadsheet

I need help. After days of trying to edit some <iframe> code, hopefully someone out there will come to my rescue before I need psychiatric help as well!

I want to display a section of a Google Sheet on a web page where someone can enter something in one cell and view some data related to that entry.

The Google publishing suggestion provides this code

<iframe src="https://docs.google.com/spreadsheets/d/1AxmM43iugG3eAViyK_ip_I0Z9gSFxLI4BfUuHkT8ouY/pubhtml?widget=true&amp;headers=false"></iframe>

which produces this result.

That is neither editable nor displays any results either. Basically it's not much better than a picture! I suppose it might update as and when I change the source sheet but that's it.

Looking around (and believe me I have looked around) I discovered some alternative code. So I tried this:

<iframe width=500 height=437 src="https://docs.google.com/spreadsheet/ccc?key=1AxmM43iugG3eAViyK_ip_I0Z9gSFxLI4BfUuHkT8ouY"></iframe>

which produces this result and I have used something like this in the past (but annoying people kept fiddling with the formuale) :

That is 'live' and you can put either AH or AH2 in the box and get different displays which is what I want. However, this also shows the toolbar so anyone can mess around with formulae or lose it completely if they're that way inclined.

I am sure there must be a way to display just a selection of cells but none of the &range=A1:K10 type additions to the code have worked. I am pretty sure I am merely missing something obvious or just not entering the extra bit of code correctly but I can't figure out what is correct. If someone out there has a few minutes I would very much appreciate some code that works.

I think I have set permissions so that only B2 can be edited but even that was a lot more complicated that in needed to be. Basically, I had to protect ranges column A, Row 1, B3:J100 and K1:Z100 individually. That still leaves a pile of columns and rows that people can get at but I can extend the 100 to something bigger. While anyone can just add a new row column from the menu, though, there's not much point!

So I do hope someone has some bright ideas.

13 June 2014

Photos, photos everywhere but none to drop just here

I have just posted about this on Google+ but something else occurs to me and so I thought I'd write here too - sort of a frequently asked question that I can't answer!

I have a Google+ My Business Page about Corgi Toys and would like too add pictures to the Photos section. Even though it has the text 'Photos of you' which I think is a hangover from the normal user-type page it is clearly a sensible idea to show people who drop in on a business page something relevant to your business.

Now, you can upload photos from your computer in the usual way. That's OK but nowadays photos are massive - 4000 by 3000 pixels is a pretty common camera size as standard and I've seen plenty bigger too. Even though people have larger resolution displays than the old 640 days I am quite content with images around the 1600 x 1200 size which are still going to fill best part of a great many monitors and these will show plenty of detail too.

So the process would involve first resizing the original, renaming it and saving it somewhere, then uploading to the Google+ page. That's OK for a few images but I have nearly 2000. That's not all - why should I spend what could be many hours uploading them all when copies are already uploaded! Google Photos Auto Backup service has one or two things that annoy me but they're fairly trivial and the important thing that it does really well is upload everything almost as soon as it finds it. Indeed, as the more observant may spot, the screenprint below shows Picasa adding the 1600 versions of 1434 photos that Irfanview is batch editing from 4000x 3000 originals in one hit. Just out of shot is Google Photo's Auto Backup busily uploading the new 1600 size files.

Now, if the new 1600 size files were being uploaded to a place I could get at them from my Corgi Toys Business Page that would be brilliant but they're not. I can get at them as me but not as the me editing my Business Page.

Just to make this all even crazier - and you may have already appreciated this and smiled ruefully - Google Photos Auto Backup has already backed up the originals (well a slightly reduced size version which makes a zero impact on my file storage space but more than enough for web use). So there are now two perfectly usable image files up there and neither can be simply transferred to my Business Page. It's not as if I am asking for something impossible here; Google's Blogger makes this simple - using an image from a Picasa Web Album.

I suppose someone may write to me and say that I am missing something really obvious but I suspect that there are actually many others out there who have several Pages on Google+ and would like to be able to share images more sensibly.

I first wrote about this in connection with articles bout American Idol and X Factor where I had albums of contestant photos on my hard drive but had to upload to each place separately. That was bearable as there were usually just 20 or so at the most. With 2000 and counting Corgi Toy images this is a serious business!

I am presently using Irfanview to change the dimensions and save new files and will then upload a few at a time and see how that goes. It is such a drag but, until someone comes to my assistance, that's how it has to be. Or, I suppose, I could just not bother and just have a blog post about each model and the post and one photo will get automatically added by Blogger to the Corgi Toy page. That works well ad I am at a loss to know why it cannot work within Google+.

Oh well.

29 May 2014

Blue Screen Of Death prompts me to change

I have finally made the move to Windows 8. Well, I am about to; the machine is ordered and will be on its way in a couple of weeks. Several things made me go for the change. Seeing the good old Blue Screen Of Death was one!

I honestly can't remember when I saw that last on one of my own machines. It really must be very many years ago and I am not sure I have ever seen it on this desktop which has been going well since 2008. No idea what that particular message means but obviously something isn't as it should be, or wasn't last week.

That alone wouldn't have made me change, though. The machine had been shutting itself down from time to time but since I changed a web site so that it didn't need to process so many hundreds of images each time I changed something that hasn't happened more than once or twice.

It's probably several little things that have made me make the move now. My keyboard is not good and can be a bit of a nightmare to type on. I bought one with backlit keys which was great in many ways when my desk was positioned in shadow in quite a dark part of a room. After a while the key graphics wore away so many were just a blue blur and my son bought me a new one. That was nice but some keys are very sticky, sort of scruntchy and usually the A doesn't appear unless I make a specific effort to check and hit it hard. That has been quite a drag and almost every piece of text has had lots of errors, massively increasing the time it has taken to perform many tasks. It is also now located in a bright place and the back lighting is simply not needed. In fact, the key graphics are now very difficult to read! So I need a new keyboard. Not exactly the best of reasons for a new system but it did contribute.

I managed to make XP read my new XD card in a new camera some time ago but it has never wanted to delete images from the card so, after copying, I have had to run through them on the camera itself and delete through a quite laborious process involving each being selected individually. As I take photographs almost every day that has been a big drag. However, I don't know if Windows 8 will change that so it's more a hope than a reason!

It does take an age to get going. That is a good reason to change. I have tried all sorts of cleaning, removing stuff but all to little avail. I switch it on in the morning and then go and make breakfast. Even then some programmes take a good time to load. That's been getting increasingly annoying and I am sincerely hoping Windows 8 will transform that part of my life. The morning wait was OK but not the minutes' wait while something decided to start up.

Quite a big reason is Google Photos' refusal to edit my images in XP. That's annoying so, amusingly in a way, Google have sort of promoted a Microsoft product there.

Although Microsoft Security Essentials does continue to protect from viruses and is, presumably, updating virus definitions every day, that ruddy red castle icon and the messages every morning that I am at risk did get annoying. I had installed Avast but probably didn't need to and that is always suggesting this or that in an effort to wean me off the free version. All in all a bit tiresome. And you do tend to feel just a little bit more vulnerable, even if there is no real reason for that.

So that lot all adds up to time to change. Desktops are very cheap and, I guess, going out of fashion but a box on the floor is fine for me. I have a tablet and Chromebook for wandering around with. I've ordered a system from Mesh, who have given me equipment that has stood the test of time and my and my children's pretty intense activities since the late 1990s. I am sticking with an AMD processor, a quad core A8 this time with a 2GB Radeon graphics card to give me some future-proofing as I'm likely to use this to watch tv and films. Apart from Windows 8 Pro and 8GB RAM the computer itself isn't that much different but I won't be nagged about upgrades and I have a feeling it will be a lot quicker! The cost is almost exactly the same as 2008. Fascinating, and that includes a 24" monitor. That will be nice but, with a 1920 resolution compared to my current 1440 I have a feeling I shall need my glasses even more and sites will look tiny!

I am also intrigued to see how few programmes I will need to install compared to six years ago. 


Admittedly, the full list does have some duplications but it looks a lot tidier after all the green deletions of things I am not going to need. I used to experiment a lot with alternative software and, in particular, Office and web design tools. Now, Google Documents handle all my day-to-day 'Office' requirements and Serif's WebPlus my site editing. I have several sites, though, for which I'll need Dreamweaver so it'll be interesting to find out if my ancient MX version will still function! If not, then I may be firing up an old machine again for that as there's no way I'll spend as much as a system on the latest Adobe software. In fact, I am looking seriously hard at Wix and others. Maybe even I'll give Google Sites another chance. My lovely CSS code sites were interesting to develop and have some advantages over the somewhat ponderous Serif product but the future is code that is written by the program not me.

Looking at what I need more closely,

Media programs
Total Recorder
Amazon Cloud Player

Design programs
Serif DrawPlus
Serif Photo Plus
Serif WebPlus

Nuance PDF Reader
7 Zip
G Drive
G+ Auto back-up
Tom Tom

No doubt there'll be games and some other odd bits and pieces but that is a significantly shorter list than the one I would have made six years ago.

One matter troubling me slightly is how I can transfer the huge amount of photos and music I have accumulated. Need to give some thought to that. I used a little cable six years ago which worked a treat but I have a feeling it might not work with Windows 8.

I shall write again with progress on the move. As almost everyone else in the world will have moved ages ago this may not be the most vital of articles but I just want to store all this for the record. In years to come we'll look back and grin. Or grimace.

09 April 2014

XP and from one scary message to another

OK. I admit it. I am still using Windows XP on a desktop. There, it's out now. I am so bad / lazy / unconcerned / old-fashioned / stupid [delete as appropriate to fit whichever news article you read]. Microsoft's support for the operating system stopped yesterday. I now get a warning when it starts and the Microsoft Security Essentials flag icon in my tray has turned red. Add to that a mass of articles and it is difficult to ignore the fact that XP is no longer 'supported'.

So, all credit to Microsoft in a sense for a massive increase in their name being mentioned everywhere. It is quite remarkable just how many people have stuck with Windows XP over the years. Vista really did not appeal and the press were critical at the time, Windows 7 initially seemed like a slightly fresher version of Vista (although it was a considerable improvement) but didn't seem that big a deal when XP was still managing fine and, having used both a lot over the years, I genuinely didn't see much difference in performance and decent protection kept systems running and free from nasty bugs etc. The years passed and Windows 8 definitely didn't appeal visually. I have had lots of clients, friends and colleagues call me up to ask for help with quite simple things with Windows 8 where, basically, they couldn't figure out what to do whereas they had been quite adept in earlier versions. That put me off upgrading too. I would have liked the more efficient system and anything that's faster and more secure is welcome but the interface had no appeal whatsoever and I dreaded the thought of being a beginner again!

So here I am. Still running XP on my desktop, which I use daily for all sorts of stuff. I do have Windows 7 on an ancient laptop but that is so slow and clunky in many ways that it's not a pleasant to use at all and it hasn't moved for many months. The main alternative machine is a Chromebook. That's is brilliant but I still need quite a few bits of software for drawing and web design that I can't do on the Chromebook. There are apps and they're improving all the time but I would struggle without my Serif, Dreamweaver and one or two other bits of software.

I will have to take the plunge into the Windows 8 ocean soon and have been looking at some new kit but, in the meantime, I thought I should do something about the dire warnings of imminent disaster. Microsoft do say that they'll keep updating the virus stuff in Security Essentials for another twelve months but that doesn't stop the flag being red or the warnings bout the 'system' not being updated. I think that means that if there is another hole discovered in the operating system code that allows people to wander around inside your files and steal data then Microsoft will not be fixing it. I understand that. It's fair enough. You buy an old car and accept that it may not do everything it should. Once the guarantee's up, you're on your own, even if they made a mistake when manufacturing it. You do get the feeling though that Microsoft are not so bothered and might not put much of an effort into protecting us old XP folk. They may update virus definitions or they may leave them for a while. Who knows? There may be more income-generating things to do. Now, I'm sure they won't deliberately put my files at risk but I don't feel comfortable and that damned red flag keeps reminding me of the fact.

So, as an interim solution for my nerves if nothing else, I downloaded Avast! a free anti virus programme that I remember using years ago. There are a few alternatives out there. AVG gets good reviews too as do some others. As with many free programmes, though, you need to be alert. Attempting to download from one quite reputable news site, I find a screen where I have to choose some add-on on the way. I cancelled that and went direct to Avast!'s own site. That was better and avoided the extra programmes. On the way you may need to untick some browser extensions or add-ons but there's nothing significant to worry about. I am not at all sure this will give me any more security at all, just more system resources being used up and an occasional scary message from some woman coming through the speakers, but I feel a bit better.

Now, back to deciding between a Shuttle and traditional desktop...