Open full view…

Parent & child events specified in a CSV import file

Sat, 07 Jul 2018 17:33:46 GMT

A while ago I inquired whether parent and child events could be linked/specified in an .CSV file from which timeline data is imported. I was told at the time that that feature would be incorporated in the then-upcoming major update of Aeon TimeLine (I think that meant the tablet/iPad integration). Has the .CSV import process been changed to allow the specification of parent/child event linking?

Mon, 09 Jul 2018 00:54:36 GMT

Hi, Yes this has been included in the latest update. When you are importing from a CSV file, if you setup a column for each event which has a unique id number, then another column for the parent event, which then uses this unique id, then you can import the child/parent relationship. Let us know if you need anymore help with this. Jess

Wed, 12 Feb 2020 23:05:07 GMT

I've tried this - and cannot get it to work. Would you be kind enough to elaborate, please, Jess? What I've tried is a spreadsheet (which gets exported/imported as CSV) where Column 1 is what I take to be/think must be the Unique ID (1, 2, 3 etc); and then Column 2 is the text string corresponding to that Unique ID, what I want to be the Parent's name. But do I have to create parents in Aeon first which correspond to the text strings in Column 2? I tried it, but it didn't work. How do I denote that these as Parents, please? TIA!

Thu, 13 Feb 2020 00:27:44 GMT

Hi, The column that you are importing under "Parent" should be the unique id (eg. 1,2,3) of the event you want to use as a parent. You don't have to create the parent events in Aeon Timeline first, but they need to be listed in the csv you are importing. Here is an example Id,Event Title,Start Date, End Date,Parent 1,This is the parent event,1/1/2020,1/1/2020,, 2, This is the child event,1/1/2020,1/1/2020,1 This is importing two events, with the idea that event 2 is the child of event 1. As you can see, the Parent column is empty for the first event (as it doesn't have a parent), and has the unique id of the parent event for the second. If you try importing this it might help you understand how to format your own spreadsheet. Let us know if you need anymore help Jess

Thu, 13 Feb 2020 01:05:06 GMT

Thanks, Jess; I'll give that a try. One question about the ID, though: don't they typically get numbered: 1 1.1 1.2 1.2.1 1.2.2 1.2.2 2 Etc? In your example, they are all single digits. Is it up to me to number anything and everything as I want regardless of a nesting suggested by decimals in?

Thu, 13 Feb 2020 22:05:56 GMT

Jess, Having tweaked it a bit into a file, I did successfully get the lines you kindly suggested in your example to work. Now I see. Thanks! May I ask a supplementary, please: the timeline I'm building has both events on single dates/days and spans; when I'm importing, is it necessary/wise/advisable to enter (artificial) end dates into the relevant columns for those events in my raw data which do not have them and so make every single-date event the CSV file have both a start and and end date - just as the events spanning several weeks do? TIA!

Wed, 19 Feb 2020 02:04:30 GMT

Hi, If your events have 0 duration (ie. the start and end date are the same), then you can leave the end date column blank for these events when importing them. Jess