12 June 2015

If you have a problem deleting PDF files

This may seem a silly little problem but it confused me for a while and may bother you one day. In the good old days if you wanted to delete a file you just found it in the folder and either hit the Delete key or found Delete on a right click menu. That seemed to work for just about everything as I recall. In the course of tidying up some files today, though, I couldn't get rid of any of the PDFs.

There's no way they were being 'used' in the normal sense of the word and Trying again didn't make any difference.

As with just about any problem these days, you'll find the answer on a forum somewhere on the net! The reason it wouldn't delete was because I had a Preview pane showing the document and that, technically in Windows 8 at any rate, means the document was 'in use'. Odd. I would have thought I would have encountered that before and can only assume that there is a different bit of code being utilised to display the document which interferes with the delete command whereas before it didn't.

So, all you have to do is change the display in the View menu to Details pane instead of Preview pane. Then you can delete to your heart's content.

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.