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

6 months later
4 months later

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 replied to this.

    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.

    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 replied to this.

      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 replied to this.

        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 replied to this.

          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

          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

          3 months later

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

          4 months later

          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?

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

            15 days later

            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