How to make sense of the dates when Exporting to JSON

Jjournalbabyb · May 22, 2023

I have exported all my entries to JSON. The date entries are in a weird format that I cannot make sense of. I no longer have my journey entries. Can someone explain to me how I can demystify them?

Thanks. Additionally I do not understand the weather (if someone knows the breakdown for that too, please let me know.

Here's a sample, in JSON:

{
    "id": "1478578900463-3fea0f2eebc96e46",
    "date_modified": 1478580546280,
    "date_journal": 1478578900463,
    "timezone": "",
    "weather": {
        "id": 800,
        "degree_c": 2.38,
        "description": "clear sky",
        "icon": "01n",
        "place": "South Riding"

tiffanying · May 23, 2023

journalbabyb The date and time are in milliseconds since the UNIX epoch (January 1, 1970 00:00:00 UTC). If you convert 1478580546280, it will be Tue Nov 08 2016 04:49:06 UTC. You can use the online conversion tool here.

Jjournalbabyb · May 23, 2023

Thank you! I also found this resource which does the same thing yours does: https://www.online-toolz.com/tools/date-functions.php

tiffanying

Is there any simple way to convert these files to .md (markdown)?

tiffanying · May 24, 2023

journalbabyb It is possible but tedious.

You will need to convert the text key in json file to plain text.

https://onlinejsontools.com/convert-json-to-text
Once you have plain text of the journal entry in html, convert it from html to markdown
https://codebeautify.org/html-to-markdown

For the metadata of the entry such as date, time, location, weather and etc, you can store it in the YAML of the Markdown file.

The Markdown file should look something like this:

---
date: 08-11-2016
time: 1249
weather: clear sky
temperature: 2.39
place: south riding
---
This is the content of the entry in *Markdown*.
* List1
* List2
* List3