Out Of My Mind – MadMike

Thoughts, Facts and Interesting Finds by Michael

I have found now that on a number of occasions that I cannot power my machine off when I wanted to as it is still running a script or something, but I also don’t just want to leave it on just because I cannot sit and wait for it to finish. 

Ever experience something similar?  I also didn’t want to just download another application just to hibernate my machine on a schedule so I decided to look if there was a more “old-school” command line method that I could use that may be able to do it for me…

After some searching I found a post over at howto-connect.com that used the command TIMEOUT at the command line. It uses the number of seconds to wait until the command is run.

timeout /t xx /NOBREAK > NUL && shutdown /h

So running the above command and replacing the xx with 60 (for 1 minute) or 1500 (for 25 minutes) will let the computer “wait” for that period of time before running the command to the RIGHT of the && – so in the above example: shutdown /h

Now all that is good and well, but having to try and work out how many seconds 48 minutes is requires a calculator for me. So I got to thinking… what if I could create a batchfile that would prompt me how many minutes I wanted to wait for, then automatically multiplied it by 60 and then put that result in as the value in the timeout section of the command…

Step #1 would have to be to set a variable called minutes. This would be for the user to type in how many minutes to wait for.

set /p minutes=Enter Minutes To Wait: 

OK now to take that %minutes% variable and multiply it by 60 (seconds).  After looking around I found an interesting article by Rob van der Woude about doing calculations at the command line. In this case a new variable would be created called Result, this from taking the %minutes% and multiplying it by 60. The command I was looking for was:

set /a Result = %minutes% * 60

And then finally to use the %Result% variable in the timeout command:

timeout /t %Result% /NOBREAK > NUL && shutdown /h

So finally we had all the bits of the code, time now to create a batchfile and bring it all together. I decided to name the file HIBERNATE.CMD Here is the contents of the batchfile:

@echo off
set /p minutes=Enter Minutes To Wait: 
echo.
echo Counting down the time...  Please Wait...
set /a Result = %minutes% * 60
timeout /t %Result% /NOBREAK > NUL && shutdown /h

I am pleased to say that although not a pretty GUI or any fancy bells or whistles, it works like a charm for me! Till next time…

So I had an interesting request come past me the other day.  A client had very old (as in created in 1995 and last printed or saved in 1998) PowerPoint files that he wanted to open…however Office 365 was not interested in opening it at all.

When attempting to open the file, PowerPoint 365 would throw up an error stating that “PowerPoint can’t read <filename.ppt> because the PowerPoint 95 file format is no longer supported”  Seriously Microsoft?!?  So much for backward support

After Googling a bit it seemed that Microsoft had a valid reason for it – it was no longer a “safe” format, so they canned support for it…anyway back to the request. There is an online service that one can upload these files to that will do it for free however there is a limit to the number of conversions done a day and I am not to comfortable uploading potentially sensitive (even though it is old) files to a server that I don’t know what will happen to it. There had to be a better solution…

I found a post somewhere that said that OpenOffice / LibreOffice used to be able to open the older formats….hmmmm…maybe if it could open it then it could save it as as newer format then also… So I went off to the LibreOffice website looking for a “portable” version of the app. Now for those of you who do not know what a “portable” version means, it means a version that you can download and run without having to install the application to your machine. Found the page and downloaded it – link here. It was a 160Mb download that I extracted to my C:\TEMP folder.

Running the application for the first time takes a while for it open and set itself up in the temporary environment, but once up and running it worked like a charm. I opened LibreOffice Impress (the equivalent program of PowerPoint) and then attempted to open the file…this is what I was greeted with:

OK so at least we could open it, now to try save it as something newer that Office 365 PowerPoint could open. File, Save As, File Type… Wow we have some formats to choose from!

Great! Now to find out if we can somehow convert files in bulk instead of doing the whole File, Save As process. I then stumbled upon another site where the members discussed how to have OpenOffice \ LibreOffice open up without showing a window (GUI) and then convert from a specific format to another AUTOMATICALLY!

So under my C:\TEMP folder I had the Portable LibreOffice version in its folder (C:\TEMP\LibreOfficePortable). I created another folder called PPT (C:\TEMP\PPT) where I placed the PowerPoint 95 test file (and made multiple copies of it to simulate a bulk conversion), and another folder below that PPTX (C:\TEMP\PPT\PPTX) where the converted files would go.

I then created a batchfile (convert2pptx.bat) that had the following in it:

for %%f in (*.ppt) do (
C:\temp\LibreOfficePortable\App\libreoffice\program\soffice.exe --headless --convert-to pptx --outdir "C:\temp\PPT\PPTX" "%%f"
)

To to breakdown what the above was doing:
1. In the current folder, any file that ends with .ppt, do the following
2. Run the soffice.exe file
2.1 as “headless” (so don’t open up and show the GUI)
2.2 convert the format to PPTX format
2.3 use the following folder as the output folder
2.4 keep the existing filename when saving it as PPTX

Finally a solution for the client to bulk convert all his PowerPoint 95 files to a compatible version that PowerPoint 365 could open.

Pretty impressed (and thankful) that LibreOffice could do that…