Import from text file

StephanBavaria

Android 10, app version 2.7.2
Migrating to this app from a not supported other app I would love an option to import from text file.

I have a bunch of diary entries in my previous app which I would like to import. The most simple method would just import date and body text. I imagine an option to choose a delimiter (string) that contains the date, the following text to be added automatically as body for the singular entry. Of course this delimiter could also be predefined, like /date/ or something similar.

Would this be much effort to implement?
Great app btw! 🙂

Cheers,
Stephan

RobertSpencer

Hi StephanBavaria & Andriy, which apps are you wishing to migrate from?

I may be able to figure out a solution.

Andriy

Hi. I have the same question.
I'm abou to migrate from non-popular app. I was using it for 10 years. So, I'd like to move all entries. I can upload them to: a) its own data base, b) word (as signle file), c) html (as signle file). Also I have bulk of another entries - word file per each entry.
Is it possible to do it somehow?

timo

Currently it is only possible to migrate from the apps that are listed in the app settings.
Every app has it's own export/backup format (and sometimes the same app decides to change their format) so it is always a lot of work for me to implement such a feature.
Also a txt file import with a delimiter string isn't as simple as it may sound: What is the date/time format to be used? What if the delimiter string is used inside a journal entry?
When you have to manually adjust the date format from your old app to one that Diarium would support to import, then it might just be faster to copy paste the entries...
You could also just check the format of one of the supported options (e.g. Daylio is a CSV format) and then just create a file accoring to that format

Alejandro

RobertSpencer Hi, Robert I’m trying to export from MacJournal. But I think I can tranform the file to csv and then the data to a format that would enable to import it to Diarium if that is possible.

RobertSpencer

Alejandro That should be possible.

Unfortunately I no longer have a Mac that I can test with. What export formats does MacJournal support? App backups and database dumps are also worth looking at if you can determine the format used?

What are you planning to use to transform the export format to CSV?

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