Archive for Uncategorized

How to export data from NITEA without merged cells.

I’ve not had much to do with NITEA, but was asked to extract some data from it for use in a different system. This proved to be a bit challenging at first because NITEA exports very nice looking reports to Excel, but with lots of merged cells in positions that can change for no obvious reason. (Seems to be a way to maintain column width rather than setting an explicit column width.)

After much head scratching, I found a way to import this data. My trick is to save the NITEA export as a CSV file from Excel, then using another spreadsheet select the Data –> From Text option to import said CSV file. The trick is to tick the ‘treat consecutive delimiters as one” option.

This isn’t perfect as it will mean empty cells are ignored, which will affect alignment of data if there are empty values for some records. Depending on the layout of your exports this may or many not be an issue. A workaround is to highlight the cells in the original NITEA report and use a find and replace to replace the empty cells with a character. A bit laborious but could be automated. (Doing the entire worksheet will likely generate some heat!)

Of course, a real programmer will likely be able to do something clever like create an array in a programming language or some such. I’m not a full time programmer, so I just use the tools I know to get the job done if I can.

There’s more fun to be had if you’re trying to get multiple tables into one recordset. This might at least give you a start 🙂

How to replace Laser Assembly in Numark MP-103

Hopefully the above steps help you out 🙂 Here’s the PDF version….

Bushnell Neo Golf Rangefinder broken after April 2019 (Can’t find GPS)

I have a customer with two of these, and they’ve both stopped working. I suspect they’re affected by the GPS Week 10 bit rollover issue.

I’ve emailed Bushnell but not expecting to get a reply given these are over ten years old I think.

https://www.theverge.com/2019/3/8/18255847/gps-week-rollover-issue-2019-garmin-tomtom-devices-affected

Windows 10 VirtualBox virtual machine spinning dots MacOS host Fusion Drive

Ok so this isn’t definite, but I have a suspicion that in the above configuraton, the presence of a Mac Fusion Drive on the host causes a long (two minutes of spinning dots) delay when starting a Windows 10 guest. This suspicion is based on the same VM opening much faster on a similar mac with a standard drive.

I don’t have a solution; this is just an observation.

Don’t buy the Nokia 6 (TA-1003) if you want dual SIM support.

This handset appears to have a bug where it randomly changes the default SMS SIM. There are no apps to monitor this, and no solutions available.

Winfast PVR2 creates 1.99GB or 2GB files / splits files to 2GB

So, my ancient copy of Leadtek’s Winfast PVR2 usually works fine, then one day it decides it’s going to split recordings at 1.99GB no matter what you ask it to do.

Reading some ancient forum posts, someone else mentioned that it will do this if it thinks it might be on a FAT16 (or FAT32?) drive. It isn’t in my case, but still it’s been known randomly to switch into this state of mind.

The solution is unknown, but switching to another physical drive seems to resolve it.

Review of the Aldi Stirling Black Label Air Purifier – EPI208

This is a fairly cheap unit at $129 – does the job but even on low it is quite loud compared to units such as the “Mi Air Purifier”. Had they given it a ‘quiet; setting it would be better in my opinion.

When I bought it there was zero information on the Internet about it, but now the manual has shown up at http://www.stirlingappliances.com.au/LiteratureRetrieve.aspx?ID=195680

Still no idea where to get replacement filters – but really there isn’t much complexity to this product and you can probably make your own.

Video of the product: https://www.youtube.com/watch?v=HMCpbbrqnXA (Recorded in Portrait)

Handle broke on Breville glass kettle

If the handle breaks off, undo all the screws, remove the spring from inside the lid, remove the unlocking pin, drill small hole, slide in cable tie. Done

 

 

Spotify Web Player loads then goes to a blank page

Alternatives: Spotify Web Player loads then goes to a black page

Spotify Web Player black screen. Spotify web player black page.

I think this situation is caused if you attempt to use the Web Player from more than one device, or several times without using the app. The solution appears to be simply to open the Spotify app on your phone or PC, play one song, then try the web player again.

 

Found this solution at https://community.spotify.com/t5/forums/v3_1/forumtopicpage/board-id/desktop_windows/message-id/59221

Free Clueless Crosswords PDF

I’ve created some free Clueless Crosswords / Code Crackers at https://drive.google.com/drive/folders/1GfWEy184kowfL1sErC9iHvV-kxfKAhow?usp=sharing

These were created via the great online website http://cluelesscrosswords.com/play.php