02 May 2015

Please Google. It's time to update Picasa / Photos to make what should be simple tasks less awkward.

After all this time Google Photos and Picasa are still not working terribly well together. For many tasks, I adore Picasa and find it suits so many of my day-to-day storage, editing and publishing needs.

I would like to see some updating of the slideshow feature which is very old-fashioned now and doesn't display on some mobile or tablet browsers but there are simpler things which just annoy me and could be changed quite easily if someone could get their act together in San Francisco or wherever the teams are based.

Actually some bright sparks could probably recode it from a beach anywhere if they felt that way inclined. Here's an example that might encourage them to get the laptops, sorry, Chromebooks, out.

I maintain a site that catalogues and describes Corgi Toys from the 1950s to 1970s. On each model page I include photographs of items I have or have had in stock. These are Picasa web albums. I tried putting images on the pages but that made the whole site amazingly heavy and was also  pain to update. The album, whilst not displaying everywhere as I'd like, is, at least, a nice simple solution and it doesn't look too bad. If I get different models, I just take fresh pictures and tweak the album set and the changes are automatically shown on the page.

For various reasons, including finding the pictures to upload somewhere like Ebay for example, I need the filename of a photo displayed. Here's the rpocess we have to follow... first, click on the web album...

That takes you to a Picasa Web Album page for that photo. Great, you think, just note the file name. It must be there somewhere. Er, no. It's not. You need the Photo Details page.... click on the link...

Now we're in Google Photos. Same photo, slightly different surroundings. But still no filename!! Heavens, this getting crazy. There's a link on the right to Photo Details. Let's click that...

Hurray!!! Let's jump up and down with delight! It has only taken three or four clicks and several periods of waiting for pages to appear to get here. I am absolutely sure that it ought to be feasible for the filename to be stored within the slide show or, at the very least, be easily accessible at the first web album page that appears when you click the image.

This would save me so much time. Of course, Ebay could help matters no end by permitting us to add images via urls instead of having to upload up to twelve big files every time. But that's another story.

For now, please Google Photo folk, or Picasa folk, make this a bit simpler. And while you're at it, can we please, please have some simple editing tools and better size control for images imported to Blogger? It's not much to ask nowadays. It almost seems like the Blogger, Picasa and Photos teams have been on holiday or maybe they were staffed totally by interns who are now elsewhere.

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.