CSV import

stuart · October 19, 2025, 3:54pm

Couple of questions re: importing records from a csv file…

What value is the app expecting in a column for ‘Ongoing’ (i.e. still alive)? i have tried Yes and true with no success. I see no advice around this on the import help page.
When importing a location is it possible for it to auto-nest? i.e. if a value of town, county, country is provided in the csv then I would love for these to be added as a nested hierarchy (Country > County > Town). I am guessing not but it leaves a lot of tidy up work when they are all imported as un-nested locations.

Peter_T · October 19, 2025, 6:15pm

Have you tried figuring it out the other way around by entering the desired state in Aeon and then looking at the exported CSV file? That might work with a minimal project.

stuart · October 19, 2025, 6:30pm

Ah! Good thinking. It looks like it is ‘True’ (with a capital T!)

AeonRob · October 22, 2025, 2:18am

You may have worked this out already after exporting a timeline to CSV to solve your first point above, but you can use the parent column in your CSV to set up nesting for locations and events etc.

Currently, both Compact Display and Internal ID are OK to use (as shown in the example below), but it’s only supposed to work with Internal ID – It’s the most unique way to reference an item.

I’d recommend that stick with Internal ID if this is a workflow you want to keep using. Compact Display probably won’t be valid from v3.5 onwards.