Import from text file

walterwu

Same question , I used orange diary for years, I have more than 2000+ entries, it is impossible to copy&past one by one.

Waters

Hi,

Thanks everyone for comments here. Thanks timo for the excellent suggestion. With help from stackoverflow I imported large part of the journal (and looking optimistic on the rest) from a doc file to the app using the Daylio format. Thoguht I'd share what I did for anyone who might have same issue. Please note my journals have same format, first line is the date, then title and then undetermined number of paragraphs, final static paragraph and finally empty line.

with open("journal tomes 1 and 2.txt", "rt",encoding="utf-8") as f:
entries = f.read().split("\n\n")
entry_records = []
for entry in entries:
lines = entry.split("\n")
date = lines[0]
title = lines[1]
body = lines[2:-1] # Ignore first two lines, and last line.
body = "\n".join(body) # Join list of strings into single string.
entry_records.append({
"date": date,
"title": title,
"body": body
})
import pandas as pd
df = pd.DataFrame(entry_records)
df.to_excel("output_journal_tome_1_2.xlsx")

Please also see below format that is accepted by the Diarium app if saved as CSV.

full_date,date,weekday,time,mood,activities,note_title,note
05/09/2022,09-May,Monday,0:00,good,,Journal 1388,"K, today we are having early journal TPeace out"

Hope someone finds this useful.

MikeWrob

I have the same issue. I want to import from Momonote. It exports data in a csv format into 3 columns,; date/time, note, tags. I have 4194 entries, so copying and pasting individual entries is not feasible. Which of the other apps could I imitate to get the data imported?

timo

MikeWrob Which of the other apps could I imitate to get the data imported

Daylio uses CSV so maybe this would be your best bet

Bluecatz

timo I too am trying to migrate from Momonote. I tried importing the CSV file using the Daylio option as you suggested, however it results in an error message stating "Error. If the problem persists, please contact the developer."

The CSV format output by Momonote is shown in the following text, exported from my journal. How should this be formatted so that it can be used for the Daylio migration option? Thanks!

year date time mood activites note
2000 November 15 14:04 "This is the information entered into the first entry."

2000 December 23 9:54 "This is the second entry."

2001 January 15 14:00 "This is the third entry."

sombra888

Hi All ...
I have entries in my current Journal (The Journal - Davidrm Software) Going back to 1998. It only exports in XML format. Are there any options open to me?

Thanks

MaryHarris

sombra888 I have the same issue.

timo

You can try to get the Daylio app and see how they format the CSV export.
If you format your export exactly like that but still get the error, please send me an example CSV via mail

EdHaren

full_date,date,weekday,time,mood,activities,note_title,note

05/09/2022,09-May,Monday,0:00,good,,Journal 1388,"K, today we are having early journal TPeace out"

The above is the sample from the forum listed as an example of the .csv format.
I tried saving and going to IMPORT DIARY and bringing as a .ZIP file got the error message:
ERROR: DILE IS NOT A DATABASE
Tried to bring in the file via MIGRATE FROM ANOTHER APP.
I chose DAYLIO and got the error msg

ERROR NO .CSV FILE IN .ZIP FILE FOUND

Assuming the format of the sample .csv file is correct - would appear the problem is how to save the file, what suffix to use and what method [IMPORT DIARY or MIGRATE FROM OTHER APP or ??}]
Any help you can give would be appreciated.
Ed

timo

EdHaren Had no problem importing your example in the Windows version of Diarium. You don't need to put the CSV file in a zip, you can also select the CSV directly.
You need to use "migrate from other app" if you want to import data from another app.

Dana

I get "0 entries have been imported successfully" on the Android app. Below is a sample

full_date,date,weekday,time,mood,activities,note_title,note
08/29/2021,29-August,Sunday,2:30 PM,good,Adrien|morning meds|woke up ,,"He got up and took his morning meds"
08/28/2021,28-August,Saturday,9:12 PM,good,Adrien|night meds ,,"He took his night meds"
08/28/2021,28-August,Saturday,2:47 PM,good,Adrien|morning meds ,,"He took his morning meds"

timo

Dana Also had no issues importing that data. Please note that entries aren't imported multiple times - perhaps you have already imported that file

Dana

timo it looks like I got a partial import at one point, does it skip the whole file or just entries that are already imported?

Dana

Dana I deleted the entries that already imported from my csv and the rest imported. I wish there was a way to bulk delete entries so I can reimport the ones that are missing tags, but that's minor

EdHaren

sorry if i caused confusion. the app I was using has no way to export data. It is no longer in the app store so when i update my phone - i lose daily data since mid 2019. So i entered all data in a spreadsheet and formatted the date to duplicate your example.
What i need is the format so that I can import into your app and do i save as a .txt file or ,csv. also do i import using
-- IMPORT DIARY
or
-- MIGRATE FROM ANOTHER APP [i don't have another app that exports...]
tks much / Ed

Peter

Does anyone know if there is a way to convert an xml to csv?

LotharKappen

Just bought the app. Still need do move many years from EfficientDiary to Diarium. I can export a csv and convert it to any given format with small Python script. However, a good specification for some csv format would be very helpful. Since i have none of the supported diaries, i did trial and error. A bit tedious. So far i found out that the following works quite well for me using Daylio import:

except that it appears in Diarium as a single line. So what would be the newline markup in the Daylio csv?

timo

LotharKappen You can install the Daylio app, make an entry with a newline, do an export and have a look at it 😉

giuse-boccia

Hello everyone,
I used another journaling app called Writeaday for more than 5 years. I managed to move all my 4000+ entries to Diarium by exporting all my Writeaday entries from the app and then parsing the .txt file it gave me to a .csv file with the same format used by Daylio. I then opened Diarium > Settings > Diary > Migrate from other app > Daylio, selected the .csv file and... all my entries are imported correctly!

I'll leave the Python script I wrote here so it can be used by other Writeaday users who wish to migrate to Diarium:
https://github.com/giuse-boccia/writeaday_to_diarium

Cheers,
GB