Something went wrong while trying to load the full version of this site. Try hard-refreshing this page to fix the error.

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


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


Next Page »