I started having problems with ods files located on my NAS today. The problem only occurs when I try to open them from Windows Explorer, any other method works fine. The bug seems to have been tracked down to the LibreOffice Explorer extensions just like an older bug that also caused excessive network reading on my NAS as a symptom. The easiest fix is the same as for a bug from a year ago that I blogged about at the time.
Rather than use text and screen shots I thought I’d try out the screen capture function of VideoStudio Pro X5.
Posted in Tech | Comments Off
There is a great web page by Trevor Andrew about working with 16:9 video in Corel VideoStudio 10. In particular I needed to use the section about 3/4 of the way down the page titled “Ok let’s change a 4:3 aspect ratio to 16:9”. I wanted to crop a 16:9 video that was captured in letterboxed 4:3 format and I’m using Corel VideoStudio X5, so the screen shots and some option locations are different. Here are screen shots and modified steps to make Trevor’s page match X5 exactly.
Differences are in parenthesis, my VSP X5 changes are in bold italics
- Change the project properties to use 16:9 aspect (File – Project Properties-Edit-General tab) (Settings – Enable Widescreen)
- With the 4:3 video in the top track select the (‘Attributes Tab’. Select the ‘Distort’ button.) (Open the Options panel, Select the Attributes Tab and check the Distort Clip checkbox)
- Right click the preview screen and select ‘Fit to screen’
- Right click the preview screen and select ‘Keep aspect ratio’
Jamming devices are not only illegal they put others at risk, e.g. jammers can prevent timely response to a medical emergency. In its never ending battle to keep the radio spectrum functional for all of us the FCC has taken the following actions.
FCC ENFORCEMENT BUREAU ROLLS OUT NEW JAMMER TIP LINE: 1-855-55-NOJAM.
FCC ENFORCEMENT BUREAU TAKES ACTION AGAINST CRAIGSLIST SELLERS FOR MARKETING ILLEGAL SIGNAL JAMMING DEVICES.
Warns Consumers to Immediately Remove Online Jammer Ads; Issues Consumer Alerts in Spanish and Mandarin Chinese.
FCC ENFORCEMENT ADVISORY (TRANSLATIONS): CELL JAMMERS, GPS JAMMERS, AND OTHER JAMMING DEVICES, CONSUMER ALERT: USING OR IMPORTING JAMMERS IS ILLEGAL, MONETARY PENALTIES CAN EXCEED $100,000 PER VIOLATION.
The Enforcement Bureau Releases Chinese and Spanish Language Versions of an Enforcement Advisory Warning that Signal Jamming Devices May Not Be Advertised or Sold in the United States.
I needed to pause for a varying amount of time in a batch file for a test today. Unfortunately WinXP has no built-in method of adding a time delay to a batch file. So I searched and found a commonly cited method of achieving a delay. Then I couldn’t remember how to increment a variable in a batch file, but again the answer was only a quick search away.
Putting them together I made this batch command file:
@REM Reset the target at a variable frequency starting @ 3 seconds
"C:\Program Files\Microchip\MPLAB IDE\Programmer Utilities\RealICE\RealICECMD.exe" -P18F87K22 -L
PING 184.108.40.206 -n 1 -w %milliseconds% > NUL
SET /A milliseconds=%milliseconds%+1
Each pass through the infinite loop adds 1 millisecond to the initial 3 second delay. To stop the batch file simply press Ctrl+C.
Posted in Tech | Comments Off
Most of the embedded systems I design output data in a CSV format for performance analysis, monitoring and debugging. So I add LibreOffice Calc to the CSV files “Open with…” Explorer option for convenience. When moving from OpenOffice, or upgrading LibreOffice versions, the file association is sometimes broken do to left over registry keys pointing to the wrong place for scalc.exe.
In the past I would manually delete the left over entries using RegEdit, a rather slow and boring task. This post on the OO forum points out the easiest method of fixing this issue, using CCleaner. I like to use the portable version because I rarely run the program so by the time I want to run it again I need to get the latest version anyway.
I really like LibreOffice so recently I upgraded to the 3.6 version on my Win7 64 Pro PC. Soon after upgrading I noticed some major slowdowns but since I was working on humongous data analysis spreadsheets I assumed it was my abuse of spreadsheets. The spreadsheets contain thousands of data points that are charted and have basic statistics calculated. Normally I’d take the time to do analysis and graphing in R but, since I don’t anticipate needing to re-run these analyses I got lazy and just used Calc.
Last night I noticed that when I opened one of the spreadsheets in Calc, Windows Explorer started continuously accessing my NAS file server. Even after closing Calc the network access continued and then Explorer crashed when I tried to use any explorer function (e.g. empty the recycle bin). After a re-boot Explorer was still doing the excessive network access but after a few minutes it stopped. So I tried just opening Calc without opening a spreadsheet from the file server. The problem started right up indicating that this was not a problem with massive spreadsheets as I had guessed.
This morning I decided to investigate more and discovered these two somewhat related problems in the LibreOffice bug list (weird, the bug list server went down as I was testing the links). It turns out there is a bug in the LibreOffice Explorer shell extensions DLL, some users recommended using the command line tool to un-register the DLL but, one user said he solved his problem by re-installing LibreOffice and disabling the shell extensions option. This made me think that the easiest way would be to use the change feature of the Windows Installer. I tried it out and it worked perfectly fixing the problem. Here are step by step screen shots of this easy way to fix this problem.
The rest of the steps should be obvious.
When you install an old version of Quicken on a new PC, Quicken wants to register itself and make online services available. It can’t actually complete the registration so it gives up and asks for permission to retry every time you open Quicken.
To disable this you need to execute a hidden command, hold down Ctrl+Shift while selecting the One Step Update menu item. Quicken responds with a dialog that says “You will no longer be prompted for registration.”. The One Step Update menu item is located in the Finance menu for Quicken 2001-2002 and in the Online menu for Quicken 2003-2005.
I found this information here.
Posted in Tech | Comments Off
Thanks to the Bad Astronomer I heard about the scheduled leap second yesterday before it happened. For most people on the planet this event should have been completely unnoticed. I however have been running timekeeping accuracy tests for a new product so it would affect the test results. Since I ‘m using a standard NTP time synch, not actually directly synching with an atomic clock, I wasn’t sure what the error would be like. In fact just looking at the basic statistics from the logged data I couldn’t see the error. So I graphed the errors and the leap second effect became clearly visible.
It looks like the NTP servers involved (there are multiple servers) changed the abrupt midnight UTC leap second adjustment into a gradual adjustment starting around midnight local time (EDT). Also note that leap second error fell within the already recorded error bounds which is why the basic statistics for the data didn’t show the leap seconds contribution. This reinforces my mantra when it comes to data analysis, simple graphing reveals far more about oddities of a data set than any numerical statistical analysis. Check out NIST/SEMATECH e-Handbook of Statistical Methods for many more examples of how graphs reveal more about data than numerical statistics.
Posted in Tech | Comments Off
I’ve been trying to break the strangle hold of Outlook PST files for years without much success. The problem has always come down to having thousands of archived messages dating back to 1997 in two large PST file archives (personal & work). I could have manually exported the emails into separate text files but that is a huge task and I’d be left with archives that aren’t easy to search. What I wanted was a way to extract all the emails into an open format that retained the folder structure and would be easily importable to a different email client. After much research and study I decided that the best format to use would be mbox primarily because it stores the mail as plain text. Although it comes in a few different varieties used by specific clients they are all well documented and conversion between the versions is not difficult.
Trying to read PST files is very difficult because Microsoft does not publish information on the format. Originally they did this with all the file formats used in their Office products but, do to consumer pressure and people cracking their formats, they eventually gave up and opened up many of them. The solution for PSTs is to use the open source libpst library on a *nix compatible OS. I installed libpst on my Ubuntu PC, copied the PST files to a subdirectory of my home directory and created separate lower subdirectories to receive the mbox files/directory structures. Now all I had to do was open a terminal, session change to the directory with the PST files and issue the following command once for each PST file (
readpst -u -o output-directory pstfilename). The output from the readpst program made me a bit concerned that some items had not been extracted, here’s an except of the output:
“Misc” – 2916 items done, 1 items skipped.
“Vendors” – 354 items done, 7 items skipped.
“Product Development” – 254 items done, 1 items skipped.
To see why some items were skipped I opened the PST file in Outlook and was pleasantly surprised to find that the item counts in Outlook matched the items done counts exactly. Thinking about this I came to the conclusion that the skipped items were simply blank or corrupted areas within the PST database that were left after deleting emails and compacting the PST. With everything extracted from the PSTs the next step was to choose a new mail client and import the old data.
I’ve been using Firefox and it’s predecessors for a decade so it was no surprise that my favorite of the clients I tried was Thunderbird. One of the most important features is one I use extensively with Firefox, multiple profiles. Here are some links to information about profiles, Profiles How to Thunderbird, Using Multiple Profiles How to Thunderbird, Run multiple copies of Thunderbird at the same time, Starting your Mozilla application with a specified profile. In Outlook I’ve always had to use one PST file and set of defaults for my work and personal email. I was able to have separate archive PSTs but I never found a useable way to have separate PST inbox and other folders to keep my personal and work email isolated. Another situation that is somewhat unique is that I work form home three days a week, so I need to have my work as well as my personal email available on my main workstation. This has led to occasionally getting work and personal emails filed in the wrong folders, which flows through to the archives, and occasionally using the wrong account for sending an email. Having separate profiles for my work and personal email eliminates the possibility of getting the emails or origination address wrong. I ended up using four profiles, work, work archives, personal and personal archives, I like to keep the archives separate from my current mail to not bog down the client when searching since it isn’t very often I need to find emails from last century. I figured I’d need to use the export/import functions for moving old emails to the archive but I tried and sure enough if I have both profiles open I can simply drag and drop old email to the archive profile. Note, even though as of this writing drag & drop works well, I do not believe this is a supported feature of Thunderbird so it could be removed in future versions and you can’t expect support.
With my new client chosen and the data extracted from the PSTs I was ready to import everything. While Thunderbird has very good import capabilities I found two extensions that gave me more powerful import capabilities, the ImportExportTools Add-on (ImportExportTools Homepage) and the MoreFunctionsForAddressBook Add-on (Allows import of multi-card vcd files). After importing my contacts I realized what a mess those had become over the years (these were not import errors, the data within Outlook was this way). The main problems were garbage characters in unused fields, addresses and phone numbers in the wrong place (work vs. home), inconsistent address, display name and phone formats. To rapidly fix these errors I exported the address books to csv files, imported them into LibreOffice Calc, made the corrections and then re-imported into Thunderbird. One detail to pay attention to if you do this, make sure you set the zip code fields to text when importing into Calc to avoid losing leading zeros.
A feature of Outlook that is not the default for Thunderbird is to have a single inbox for multiple email accounts. Thunderbird is like Outlook Express/Windows Mail and shows separate inboxes for each account. However there is a Global Inbox feature in Thunderbird that gives you the unified inbox like Outlook. The next feature from Outlook that is not in a default Thunderbird installation is the ability to use different automatic signatures for a single email account. This is a feature I use almost every work day to give me three different sig lines depending on the recipient. A formal one for customers/vendors I don’t know personally, a less formal sig for the customers/vendors I do know personally and the third is for co-workers (simply Paul). Of course as I would expect there’s an extension that gives this exact capability, the Signature Switch Add-on (home page). The next issue I needed to figure out was how to change the SMTP server depending on which office I’m sending mail from. While it’s possible to do this manually once again I found an extension that handles this task completely automatically, the SMTP Control Add-on (SMTP Control Overview). With everything running smoothly I started playing with more feature and hit a problem with the junk mail filter system, a little searching found the solution in a forum thread, Junk mail selections won’t stay checked (scroll down to the January 22nd, 2012, 2:39 am post from ss2115).
The last Outlook feature that I needed was to have an integrated calendar, for that the Lightning Add-on works great. I was able to import the extracted PST calendars easily but as I was scrolling through the future events I noticed that the time for recurring events was off by one hour after the DST/EST change date. Once again the answer was just a Google search away from a forum thread, Thunderbird calendar plugin and daylight savings. Looking at the imported calendar items, at first I couldn’t see any time zone setting for events, then I found that the Options menu in the Event editing window has that field off by default. Sure enough with the time zone field turned on I saw that my imported events where UTC, I changed them to EST and the problem was solved. The final issue I worked on was how to keep separate calendars for work and personal items but still be able to see both in each profile to avoid scheduling conflicts. For my work calendar I exported the calendar as an ICS file in the work profile directory and deleted the calendar from Lightning. Then I opened the ICS file in both my work and personal profiles (do not import the ICS, use the “file – open – calendar file” command), it works very well, both profiles can view edit and add events, see Exporting and sharing a calendar for more info. With my personal calendar I chose to import those events into a Yahoo calendar and then add the cloud based calendar to both profiles, this also works great see Thunderbird and Yahoo How To for more details.
It’s been a week since I completed the transition to Thunderbird and I’m very pleased with the results. I have all the capabilities of Outlook that I need while adding excellent separation of work and personal items and open data formats to make sure I can use the data easily in the future. On top of this I can install Thunderbird on any PC I need to use and on a portable Flash drive without having to think about if I have enough licenses to stay legal.
Posted in Tech | Comments Off
« Older Posts ·¦·