Skip to content

Instantly share code, notes, and snippets.

@rogatty
Last active June 11, 2023 12:59
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save rogatty/8a65ebc01062ebc48fac7473792ae993 to your computer and use it in GitHub Desktop.
Save rogatty/8a65ebc01062ebc48fac7473792ae993 to your computer and use it in GitHub Desktop.
Convert Journey.Cloud (Diary) JSON Export to Evernote Export (ENEX) which can be imported into Joplin
#!/usr/bin/env python3
# Converts the JSON export of Journey.Cloud diary entries into an Evernote Note Export format (ENEX) for easy import into Joplin.
# Create/update date, journal text, location, photos and tags are preserved in the resulting Evernote Note.
# Based on https://gist.github.com/mbafford/2c18f5c4d7b0dab673fddb1af2126680
import sys
import os
import json
import base64
import hashlib
import codecs
from datetime import datetime
from xml.sax.saxutils import escape
def md5sum( file ):
m = hashlib.md5()
m.update( file )
return m.hexdigest()
def load_photos( journal_id, files ):
ret = {}
for file in files:
try:
with open(file, "rb") as f:
ret[ file ] = f.read()
except:
print("Journal %s - Unable to find photo file %s" % ( journal_id, file ) )
sys.exit(1)
return ret
def get_note_xml( journal ):
created = datetime.fromtimestamp( journal['date_journal']/1000 )
updated = datetime.fromtimestamp( journal['date_modified']/1000 )
print("%s: Converting journal from %s (modified %s)" % ( journal['id'], created.strftime("%Y-%m-%d %H:%M:%S"), updated.strftime("%Y-%m-%d %H:%M:%S") ) )
photos = load_photos( journal['id'], journal['photos'] )
print("%s: Loaded: %d photos" % ( journal['id'], len(photos) ) )
resources_xml = ""
images = ""
for photo in photos:
mime = ""
if photo.lower().endswith( "jpg" ): mime = "image/jpeg"
elif photo.lower().endswith( "sticker" ): mime = "image/gif"
elif photo.lower().endswith( "png" ): mime = "image/png"
else:
print("Unable to determine MIME mime from filename: %s" % photo)
sys.exit(1)
resources_xml += """
<resource><data encoding="base64">
%(base64)s
</data><mime>%(mime)s</mime>
<resource-attributes>
<source-url>file://%(filename)s</source-url>
<file-name>%(filename)s</file-name>
</resource-attributes>
</resource>
""" % {
"base64": base64.b64encode(photos[photo]).decode(),
"filename": photo,
"mime": mime,
}
images += """ <div><en-media hash="%(hash)s" type="%(mime)s"/></div> """ % { "hash": md5sum( photos[photo] ), "mime": mime }
tags = ""
for tag in journal['tags']:
tags += """<tag>%(tag)s</tag>""" % { "tag": tag }
return """
<note>
<title>%(title)s</title>
<content>
<![CDATA[<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE en-note SYSTEM "http://xml.evernote.com/pub/enml2.dtd">
<en-note>
<div>
%(text)s
</div>
%(images)s
</en-note>
]]>
</content>
<created>%(created)s</created>
<updated>%(updated)s</updated>
%(tags)s
<note-attributes>
<latitude>%(latitude)s</latitude>
<longitude>%(longitude)s</longitude>
</note-attributes>
%(resources)s
</note>""" % {
"title": created.strftime("%Y-%m-%d %H:%M"),
"text": escape( journal['text'] ).replace("\n", "<br/>"),
"created": created.strftime("%Y%m%dT%H%M%SZ"),
"updated": updated.strftime("%Y%m%dT%H%M%SZ"),
"latitude": journal.get('lat', ""),
"longitude": journal.get('lon', ""),
"resources": resources_xml,
"images": images,
"tags": tags,
}
def find_and_convert():
xml = """
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE en-export SYSTEM "http://xml.evernote.com/pub/evernote-export3.dtd">
<en-export export-date="%(export_date)s" application="Evernote/Windows" version="6.x">
""" % {
"export_date": datetime.now().strftime("%Y%m%dT%H%M%SZ")
}
for fn in [fn for fn in os.listdir(".") if fn.endswith(".json")]:
with open(fn, "r") as f:
journal = json.loads( f.read() )
xml += get_note_xml( journal )
xml += "</en-export>"""
out_file = "journey.enex"
with codecs.getwriter("utf8")(open( out_file, "w" )) as f:
f.write( xml )
print("Wrote %s" % ( out_file ))
find_and_convert()
@eharvey71
Copy link

I was getting this traceback:

Traceback (most recent call last):
  File "journey_cloud_json_to_evernote_enex.py", line 136, in <module>
    find_and_convert()
  File "journey_cloud_json_to_evernote_enex.py", line 132, in find_and_convert
    f.write( xml )
  File "C:\Users\Eric\AppData\Local\Programs\Python\Python368-64\lib\codecs.py", line 377, in write
    self.stream.write(data)
TypeError: write() argument must be str, not bytes

Updated opening the export file as "wb" instead of "w" and that fixed the problem.

@je1980
Copy link

je1980 commented Jun 8, 2020

Some pictures are JPEG
So please insert:
elif photo.lower().endswith( "jpeg" ): mime = "image/jpeg"

in line 49

@jonaswouters
Copy link

Updated the file with html support and .jpeg files..
Date format changed to my preference. https://gist.github.com/jonaswouters/e22b9eef5dad29edc8557b3bc602756a

@JoelGotsch
Copy link

Great work, I fixed an issue with importing text containing special characters. The codecs library is not necessary:
https://gist.github.com/JoelGotsch/faefe55318c97d4eee94e1afbd5a2050

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment