This is about dying but not about death. It is about the word “dying”:
That’s how you can remember which of dying/dyeing/dieing you want. The irregular verb death is the irregular activity which cuts life (and the word) short.
;-)
I wanted to migrate my data from TiddlyWiki to Joplin. This documents how I got there. You will not like the results if you follow my steps exactly. You may find this document helpful if you use it as a guide in creating your own migration process.
See this: https://davidalfonso.es/posts/migrating-from-tiddlywiki-to-markdown-files and this: https://gitlab.com/davidalfonso/tiddlywiki-migrator/tree/master
select title, count(*) from notes group by title having count(*) > 1
and title != "DefaultTiddlers"
and title != "MarkupPreHead"
and title != "PageTemplate"
[!field:type[text/x-markdown]!prefix[$:]!tag[OkNotMd]]jsonml.unshift.apply( jsonml, this.processBlock( m[ 1 ], [] ) ); // if there's a leading abutting block, process it
if ( m[ 1 ] ) {
console.log('m1');
console.log(m[1]);
console.log('block');
console.log(block);
jsonml.unshift.apply( jsonml, this.processBlock( m[ 1 ], [] ) );
}
----- has a blank line before and after.const fs = require('fs');
if (process.argv.length != 3) {
console.log("Wrong parameters. Directory name expected.");
process.exit(1);
}
const PATHNAME = process.argv[2].endsWith('/') ?
process.argv[2] : process.argv[2] + '/';
// List all filenames in dir received as argument
fs.readdir(PATHNAME, (err, files) => {
if (err) throw err;
files.forEach((filename) => {
let newFilename = decodeURIComponent(filename);
// Clean filename (CUSTOMIZE THIS)
newFilename = newFilename
// Remove accents/diacritics
.normalize('NFD').replace(/[\u0300-\u036f]/g, "")
// Convert separators to low line
.replace(/\s+/g, '_')
// Remove any non-safe character
.replace(/[^0-9a-zA-Z-._]/g, "");
fs.rename(PATHNAME + filename, PATHNAME + newFilename, (err) => {
if (err) throw err;
});
});
});
The original puts YAML front matter on the .md files, and Joplin cant handle it, so edit the Makefile and remove these lines:
@echo "---" > "$@"
@cat "$(^:html=meta)" >> "$@"
@echo "---" >> "$@"
make
* If it crashes on content, make sure evey Tiddler has valid syntax. (Using regular TW, open each tiddler without a JS crash.)make convert
[[Title]]
\[\ so it is safe to sed the Markdown.<code></code>backtick both at the begining and at the end of the code block. Sometimes. I think the standard Markdown plugin cannot deal with single backtick inline code. Screw it. The MD converter plugin handles only Gruber MD, where triple backtick means something screwy. I’m just going to copy the Markdown tiddlers (where they exist) from TW into the output folder.# Rename files without the underscore so the names match the TW names
cd markdown_tiddlers
rename -v -e 's/_/ /g' *
cd ..
# For all the files created by the other guy's migration...
for f in markdown_tiddlers/*.md ; do
# f2 = the node.js Tiddlywiki MARKDOWN file name
f2="/data/tiddlywiki-sites/tw-node/pkb/tiddlers/`basename \"$f\"`"
# Some older Tiddlers maybe got converted to Markdown, so they still have a .tid file type
f3="${f2%%.md}.tid"
# If TW has a .md file then use it.
if [ -r "$f2" ] ; then
echo cp "$f2" "$f"
cp "$f2" "$f"
else
# if TW has no .md but it has a .tid, copy that IFF it is markdown format
if [ -r "$f3" ] ; then
echo "found $f3"
if grep "type: text/x-markdown" "$f3" 1>/dev/null ; then
echo "replace $f with $f3"
# .tid files begin with metadata. The Markdown begins after a blank line.
# Count how many lines to the first empty line
var=`sed '/^$/q' "$f3" | wc -l`
# Skip the empty line too
var=$((var+1))
tail -n +${var} "$f3" > "$f"
fi
fi
fi
done
cd markdown_tiddlers
rename -v -e 's/_/ /g' *
cd ..
tar -czvf markdown_tiddlers.tgz markdown_tiddlers/
scp kevin@boxtop:~/tiddlywiki-migrator/markdown_tiddlers.tgz markdown_tiddlers.tgz[[Title]] but Joplin insists on using [Title](:/b9d7acbfa256439c8e92e018d0ebb1b7) as internal links.tw-to-joplin-links.py (code is shown below)
#!/usr/bin/env python
import re
import sqlite3
# Converts TiddlyWiki [[Link]] to Joplin's [Link](:/GUID]
JOPLINDB = '~/.config/joplin-desktop/database.sqlite'
def no_commas(s):
return s.replace(',', '')
# Some Titles look like Word%20With%20Spaces.
def decode_title(s):
s2 = s.replace('%20', ' ') # string.replace is a global replace-all-occurrences
return s2
conn = sqlite3.connect(JOPLINDB)
c = conn.cursor()
c.execute("DELETE FROM notes where title = 'favicon.ico' or title = 'DefaultTiddlers' ")
c.execute("DELETE FROM notes where title = 'MarkupPreHead' or title = 'PageTemplate' ")
c.execute('SELECT title, id FROM notes')
rows = c.fetchall()
title_id = dict(rows)
# These may convert poorly. Mabe the [[foo]] is like this and should not be converted: ```[[foo]]```
c.execute("SELECT id, body, title from notes where body like '%```%[[%```' order by title")
rows = c.fetchall()
for r in rows:
print("WARNING:", r[2], "has [[ INSIDE ``` and may convert poorly")
# replacing [[AltTitle|Title]] with [AltTitle](:/ID)
c.execute("SELECT id, body, title FROM notes WHERE BODY LIKE '%[[%]]%' ORDER BY title")
rows = c.fetchall()
# Non-backtick, followed by [[blahblah]]
# This will fail to convert if the first 2 characters in the document are [[
reg1 = r"[^`]\[\[(.*?)\]\]"
for r in rows:
matched1 = False
body = r[1]
my_title = r[2]
print("Current story:", my_title)
match = re.search(reg1, body)
while match:
print("Processing Markdown wiki link:", my_title)
matched1 = True
m = match.group(1)
m2=re.search(r"(.+)\|(.+)",m) # This one should be greedy because m contains only the content between [ ond ]
if m2:
# [alt_title|real_title]
alt_title = m2.group(1)
title = decode_title(m2.group(2))
print("DEBUG processing alternate name wiki link. visible name=", alt_title, "internal name=", title)
else:
# [real_title]
title = m
alt_title = decode_title(title)
#print("DEBUG lookup ID for title", title)
if no_commas(title) in title_id:
guid = title_id[no_commas(title)]
else:
guid = "LINK_TARGET_MISSING"
print("WARNING:", my_title, "has a wiki link to missing document", title )
# replace match.group(0) in r with [alt_title](:/GUID-of-title)
s = match.group(0)[0] # The 1-character not-backtick before the [
newstring = s + "[" + alt_title + "](:/" + guid + ")"
body = body.replace(match.group(0), newstring , 1)
print("DEBUG replaced", match.group(0), "with", newstring)
match = re.search(reg1, body)
if matched1:
escaped_body = body.replace("'", r"''")
cmd = "UPDATE notes SET body = '" + escaped_body + "' WHERE id = '" + r[0] + "'"
c.execute(cmd)
# replacing [Title](#Blah%20Blah) [Title](:/ID)
# You get these when the other guy's code exports tiddlywiki classic wiki links.
c.execute("SELECT id, body, title FROM notes WHERE BODY LIKE '%[%](#%)%' ORDER BY title")
rows = c.fetchall()
# Not backtick, followed by...
# This will fail if the first characters in the document are [
reg1 = r"[^`]\[.+?\]\(#(.+?)\)"
for r in rows:
matched1 = False
body = r[1]
my_title = r[2]
print("Current story:", my_title)
match = re.search(reg1, body)
while match:
print("Processing TW wiki link:", my_title)
matched1 = True
m = match.group(1)
title = decode_title(m)
#print("DEBUG lookup ID for title", title)
if no_commas(title) in title_id:
guid = title_id[no_commas(title)]
else:
guid = ""
# replace match.group(0) in r with [alt_title](:/GUID-of-title)
# The other guy's export forces CamelCase wiki links, even if not enabled in TW.
# That leads to a lot of link-not-found. Just remove the hyperlink if link-not-found.
s = match.group(0)[0] # The 1-character not-backtick before the [
newstring = s + "[" + title + "](:/" + guid + ")"
if guid == "":
body = body.replace(match.group(0), s + title)
print("DEBUG replaced", match.group(0), "with", s + title)
else:
body = body.replace(match.group(0), newstring , 1)
print("DEBUG replaced", match.group(0), "with", newstring)
match = re.search(reg1, body)
if matched1:
escaped_body = body.replace("'", r"''")
cmd = "UPDATE notes SET body = '" + escaped_body + "' WHERE id = '" + r[0] + "'"
c.execute(cmd)
conn.commit()
conn.close()
print("FINISHED")
Done.
if [ `uname` = Darwin ] ; then
cd ~/temp
scp dtl.html kevin@boxtop3.home:dtl.html
scp pkb.html kevin@boxtop3.home:pkb.html
fi
First - BOXTOP BOXTOP BOXTOP!
if [ `uname` = Linux ] ; then
cd ~/tiddlywiki-migrator
cp ../dtl.html wiki.html
rm -rf tmp_wiki markdown_tiddlers
make
make convert
./kpk-fixup.sh
fi
Second
if [ `uname` = Linux ] ; then
cd markdown_tiddlers
rename -v -e 's/_/ /g' *
cd ..
tar -czf dtl_tiddlers.tgz markdown_tiddlers/
fi
Third
if [ `uname` = Linux ] ; then
cp ../pkb.html wiki.html
rm -rf tmp_wiki markdown_tiddlers
make
make convert
./kpk-fixup.sh
tar -czf pkb_tiddlers.tgz markdown_tiddlers/
fi
if [ `uname` = Darwin ] ; then
rm -rf dtl_tiddlers pkb_tiddlers dtl_tiddlers.tgz pkb_tiddlers.tgz
scp kevin@boxtop3.home:~/tiddlywiki-migrator/dtl_tiddlers.tgz dtl_tiddlers.tgz
scp kevin@boxtop3.home:~/tiddlywiki-migrator/pkb_tiddlers.tgz pkb_tiddlers.tgz
fi
if [ `uname` = Darwin ] ; then
tar zxvf dtl_tiddlers.tgz
mv markdown_tiddlers dtl_tiddlers
tar zxvf pkb_tiddlers.tgz
mv markdown_tiddlers pkb_tiddlers
fi
. python-choosertw-to-joplin-links.pyI wanted to turn off notifications for text messages from some senders. This has changed over the years. Here’s how it works on my phone today. I think I’m on Android 8 (Oreo).
Dear Marie Kondo,
Clothes do not bring me joy. I simply do not give a damn about socks, shirts, pants, briefs. Following your advice to retain only items which spark joy, I am now nude and unemployed. Of course, since I was the breadwinner for my family, my wife and children have left me. They brought me joy, but discarding my clothing was important to reducing my clutter, and now I’ve certainly reduced my clutter.
Oh, and thank heavens I got rid of those clothes. I saw many pictures of drawers full of folded clothing stored vertically. That really does work well for a drawer full of clothing. But my drawers were full of clothing only immediately after I washed. By mid-week, they were only half full! Of course, whenever I opened a half full drawer of shirts stored vertically, they fell over. It was so much bother to stand them up each time I opened the drawer. I considered using bookends to keep them tidy, but bookends do not bring me joy.
I had many tools which I’ve discarded. I really didn’t get joy from my lawn mower or the table saw and other tools. Now the city mows my lawn for me. They fine me only $2500 each time they mow it, so I’m getting rid of the clutter of cash too! Of course, without the table saw and other tools, there are some home repairs I can’t perform. But that’s OK. My home has been condemned by the city, so it too will be discarded.
Oy! Don’t get me started about eating utensils. Is there really someone who derives joy from a fork or a spoon? But now that I’m losing my home, I won’t really have to bother with utensils. Chez Dump lets one eat with one’s fingers.
Camping used to bring me joy, but it has so many items one must store. There really isn’t any way to store 432 items vertically. I used to store them in stacked containers. Of course they overflowed the available space. When I looked at each individual item, I had to admit that most of them did not bring me joy in and of themselves. Picking up my nifty little camp stove does bring me joy because it is so well designed. Fuel bottles – not so much joy. So now I go camping in the nude with just my stove and no fuel. I’ve certainly reduced my clutter.
I used to enjoy ham radio as a hobby. I really, really love my Elecraft KX3 radio. It is epically well designed. But to be honest, things like batteries to run it, wires to connect it to the batteries, antennas, microphones… not so much. Now that I got rid of all of those critical accessories, I do still love my radio. Do you have any advice on how I can use my radio without power or a microphone? No? Well, I’ll just appreciate what it used to do for me.
Frankly, problems with the whole Kondo method include
The Kondo method seems well suited to someone with clothing and housewares fetishes, no hobbies, and no responsibilities.
I wanted to use a podcast client which would sync across devices. i.e. I could be playing a podcast on my phone while walking, pause it on my phone, resume it on my laptop, pause it on my laptop, and resume it on Alexa.
My other unusual usage pattern is that I sometimes listen while on my daily walk, but I mostly binge-listen while on occasional long trips (e.g. vacations).
I use Android, Mac, Windows, and occasionally Linux.
I’d been using Podcast Addict. It doesn’t work on Alexa or on the desktop.
Features I wanted to carry forward from Podcast Addict:
I started by searching for multi-platform podcatchers, including platforms Android, IOS, and web/HTML5. Alexa is a nice-to-have because I’m willing to use Bluetooth to stream from my phone.
Here’s what I looked at:
I want:
GMail has a helpful import-from-POP3 function, to bring your old email when you migrate to GMail. But I wanted to import from a server which supports only webmail and IMAP. Here’s how:
Since we can’t go directly from the old server into GMail, we’ll pass through an intermediate step. We’ll set up a desktop email client to fetch messages from the old server. This will make a copy of the messages on the desktop. Then, in step 2, we’ll push the messages from the desktop into GMail.
Note: If you’re about to lose access to your old server, the step of copying the messages to your desktop is URGENT. Step 2 can be done at your leisure.
I’m going to describe how to do this using the Thunderbird email client. If you already use a different desktop email client, you can probably do something similar using it.
I use Nirvana from nirvanahq.com for my tasks list. On an Android phone, it has a nice Sync icon. On a Kindle Fire Android tablet, there is no Sync icon. Here’s how to make it refresh.
I’ve heard this is a general issue with Kindles – that the pull-down area for an app has a very narrow activation area. This is reportedly because Android apps expect you to be able to pull down from the main title bar but Kindle uses the title bar in a non-Android-standard way.
Many Alexa skills want you to “link accounts.” Often, this involves connecting to your Amazon account via OAuth. Later, you may wish to revoke this access.
For no apparent reason, most of my Office 365 apps started ticking about once per second. Tick, tick, tick. The ticking would stop several seconds to minutes after I exited the app. It happened even when I launched the apps in “safe mode.” It affected Word, Excel, Access, and Powerpoint, but not Outlook. (I didn’t try Publisher or the other, lesser Office apps.)
I went into Control Panel and set the Windows sound scheme to “No Sounds” and the sound went away. So I drilled down to the “Windows Explorer” grouping and discovered that I could just disable the “Start Navigation” sound, and that silenced it.
That led me to run Fiddler to see what the navigation was. It was loading some Microsoft authentication URLs, over and over.
That led me to notice my name on the Office (Word, Excel, Powerpoint, Access) title bar. Office 365 wants you to be logged in to Office. There was an exclamation point next to my name, indicating some sort of error. I logged out of my Office 365 account and back in. The exclamation point was still there, but clicking it gave me a complaint about the status of my account (which disappeared too quickly for me to capture it).
Eventually I clicked on a message about re-authenticating. That displayed a blank dialog, which eventually loaded and told me I was re-logged in. THAT cleared the exclamation point. A few seconds later, the ticking (and URL loading) stopped.
So tick, tick, tick from Office apps is telling you that you’re not successfully logged into Office 365. Microsoft says you have to login to Office 365, even if all you wanted to do was to view a Powerpoint.