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 🙂
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.
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.
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.
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