March 2020

Filename issues when moving from Dropbox to SharePoint

Submitted by aaron.axvig on Tue, 03/31/2020 - 16:47

I was recently helping someone with a transition from Dropbox to SharePoint/Teams/OneDrive for Business.  They were running into issues with filenames.  As an all-Mac business there were many files they had created with colons in the file or folder name.  Windows doesn't allow those characters and SharePoint does not appreciate them either.

Some Googling suggested that downloading a ZIP of the Dropbox folder might solve the problem.  I found that when I extracted the ZIP the offending files were just missing.

I ended up creating a droplet on Digital Ocean and syncing the Dropbox folder to it.  Even though it was 20GB and 14,000 files, the sync only took three or four minutes!

Then I set about carefully renaming things.  Thanks to StackOverflow I mainly worked with variations of this command: find . -type f -name "*:*" -exec rename -n 's/:/-/g' {} + It renames all files that contain a colon by replacing that with a dash.  If you have directories that contain a colon then it will fail to rename those.  Run again with -type d to rename those.  Remove the -n to actually make the changes; with -n it just tells you what it would do.  Append | wc -l on the end if you want to count how many issues you have.



Submitted by aaron.axvig on Wed, 03/25/2020 - 10:45

I first played Minecraft ten years ago, while I lived in my apartment in south Fargo.  I lived there from January 2010 until mid-2011 so I'm going with 10 years...close enough!

It was loads of fun back then as I played on a server with a group of people that I knew at Microsoft.  A few years after that I played for a couple months on a server that I ran, with my brother and a few of his friends joining in.  And a couple months ago I decided to give it another try, with the goal of hunting down some achievements (hence Bedrock edition on PC) and beating "the end".


Submitted by aaron.axvig on Wed, 03/25/2020 - 10:41

I tried to play this for about an hour but I just couldn't figure it out (on mobile).  It is like a joke to control this kind of game with a touchscreen, and that was a sufficient obstacle to figuring out how to build a house that I just gave up.

Maybe five years ago I played Terraria some on PC, maybe 10 hours?  From memory I would rate it OK.  Not sure why I expected it to be better on mobile.  I guess I should try with a controller of some sort.

Microsoft Solitaire

Submitted by aaron.axvig on Wed, 03/25/2020 - 10:32

I have played this a lot!  The Star Challenges are what appeal to me the most--I have 1026 stars currently.  For some of the themes I have trouble distinguishing between whatever two colors they choose to swap for red and black; usually I can fix that by playing with the Android color-blindness compensation settings.  I think I have all the achievements too, except for the Daily Challenge ones.

Microsoft Sudoku

Submitted by aaron.axvig on Wed, 03/25/2020 - 10:27

While I have long been familiar with Sudoku puzzles, this is my first experience doing them at a rate of more than one per several years.  I cannot imagine a more helpful UI that wouldn't feel like plain cheating.  Which is to say that the UI is very helpful but I am still convinced that I am really good at solving.  Doing puzzles on paper would surely be a slow and frustrating experience for me.

NYT Crossword

Submitted by aaron.axvig on Wed, 03/25/2020 - 10:16

Anna plays the new puzzles as they come out and I play from the archives.  I have completed May and April 2019 and almost completed March 2019.

For Monday and Tuesday I can usually finish the puzzle after revealing 1 to 5 squares that stump me.  For all the other weekdays I play with autocheck on, which helps a lot because I can guess.  Then I still usually have to reveal ~5 squares, and often more on harder Friday puzzles.  I often play in the evening when I have had a few drinks or in bed while falling asleep so not when my mind is the sharpest.

Trivia via VHF

Submitted by aaron.axvig on Fri, 03/20/2020 - 20:15

For entertainment tonight we played trivia via the VHF radio. There were about 15 teams playing.

The host read four questions for each round on the radio and we submitted our responses for each of the five rounds in a Google Docs form. At 5 points per question and a bonus point for signing up early we were in the middle of the pack with 31 points going into the final question. We wagered two points!

The final question asked who performed the song that was played at the beginning of the cruisers net this morning.  The cruisers net is also a VHF affair which consists of announcements, comings and goings, buy/sell/trade, and requests for help.  The host typically plays snippet of a song at the beginning of the program.  Of course no one knew that it would be a question in trivia that night, and based on the scores we heard I don't think anyone got it right.  It was '39 by Queen.  Pretty interesting that Queen wrote a folk song like that.  Betting only two points paid off and we tied with one group for third place!


The Rothschilds: A Family Portrait by Frederic Morton

Submitted by aaron.axvig on Wed, 03/18/2020 - 13:39

Fairly interesting book about the Rothschilds family.  I'm writing this up maybe six months after I stopped reading it, and I made it about 2/3 of the way through.  I guess now I know that there was a father and five sons, they were into banking, had a lot of nice houses/castles, etc.  To many names to remember though!

Seawater Pro watermaker install on our Hunter 376 sailboat

Submitted by aaron.axvig on Mon, 03/09/2020 - 09:33

In this post I will document the Seawater Pro watermaker that we installed one year ago.  It currently makes 15 gallons per hour here in the Bahamas at about 850 PSI membrane pressure while consuming about 850 watts.

I ordered and installed the system in March 2019, probably total installed cost was about $3,100 and a solid week+ of learning, working and running to hardware stores.


The Three-Body Problem by Liu Cixin

Submitted by aaron.axvig on Sat, 03/07/2020 - 13:24

Overall good.  I read reviews for the sequel and some of them said that reading this is a necessary slog and the sequel is the big payoff.  One of the best sci-fi books of all time I guess.  I do plan to read it.

This itself is still a good book though.  I found it hard to keep track of the characters, I think because they all have Chinese names.  Maybe I don't have anything to visualize for names that I am unfamiliar with, or maybe my brain just isn't wired to track those "words" as characters.  Otherwise the Chinese setting and cultural influences are interesting.