How to import thousands of log entries

import

#1

This is a support question on if it is possible for me to import a large number of work log entries into Agenda. Essentially, I need a way to import multiple notes that each have a date associated with it. Does Agenda use SQLLite? If so, maybe I can import directly into the database.

What I did: Created a daily work log using various other software for the last 10+ years. I can export into a csv with the date in one column and content in another. The content contains line breaks.

What happened: As I move through different jobs and computers, I export/import my entries to different software. I would like to try Agenda as my daily work log, but would like to import all my previous entries (~3,000). I don’t see a way to import each entry en mass while maintaining the date for each entry/note.

What I expected: An import mechanism to import notes with a date associated to each, such as a csv.

Things that might be helpful to know (Agenda version, OS and model, etc): macOS 10.13.4, Agenda 2.2.1


#2

This is definitely a very advanced request, so we haven’t got any nice import menu to do it. But we do have a structured JSON file format called Agenda Archive. What I would recommend is that you export a note as Agenda Archive (File > Export), change the file extension from .agenda to .zip, and unzip the file. You should find the JSON data in there, and you should be able to see the structure of a note.

You could also export a whole project with some notes, and do the same trick as above.

The idea would be to write a script that takes your data, and generates JSON files, which you can then zip up, change the file extension to .agenda, and import.

Not trivial, but it sounds like you have the skills to do this sort of thing.


Documentation for JSON for importing notes
#3

Yes, this sounds like it will work. It’ll take some scripting to get my current data to JSON. I’ll update this topic with my results. It may be a few days or the weekend until I can get to it.

Thanks!


#4

Also interesting to see how Agenda works with +/- 3.000 notes


#5

Did this end up working at all?

I’m in a similar situation, but with personal journalling I’ve been doing with Ulysses. No way I’m manually importing hundreds of entries, though…

Also interested to hear how Agenda does with a large database.

thanks!