Hi! I am trying to import data from a CSV with timestamps into a template. I have 6 columns in the CSV that become 6 tiers when I import them, but I can’t figure out a way to get the annotations that generate into the tiers of my template.
The template has both parent and child tiers, so every method I try doesn’t really work to have the corresponding info go to the appropriate tiers. I am not able to copy tier to tier into the child tiers of the template.
Is there a way to do this? I see ‘Update Transcriptions with Template’ but that creates a .txt file rather than an .eaf that I can continue to work on.
Thank you for your reply!
My ELAN does not have either of the Import options you mentioned; I don’t see “Import” > “Annotations from Spreadsheet…” or “Import” > “Annotations from File…”
The closest I have to either would be “Import” > “CSV/Tab-delimited Text File.”
When I do this, I don’t get a “Mapping” step, only the wizard pop up you mentioned in the second step (delimeter, header row, etc.)
I just updated to the newest version (form 6.0 to 6.7) in case that would help, but it doesn’t look like it changed anything. I am on a Mac M1 if that makes any difference.
I tried to do the “Update Transcriptions with Template” as you described, but the .txt file does not look like a normal annotation file with columns and rows, it’s more of a report of the differences between the imported CSV to .eaf file and the template, so when I try to import it, it doesn’t really work as a file with data to import.
I’m also not able to find the “ELAN Spreadsheet Importer,” is it on Github or somewhere else?
Also I’m including a screenshot of part of the .txt file I get as an example. Am I doing that wrong somehow?
Hi,
The ‘standard’ ELAN indeed doesn’t have these options mentioned. Currently the data import from CSV does not support adding the data to a template. These is being discussed, because it would be useful, but not implemented yet (it is not trivial).
The text in your last screenshot just shows the logging messages, informing the user what has been attempted (with success or failure) when updating an .eaf with tiers and types and CV’s etc. from a template. The .eaf should have changed after this procedure finished, but it doesn’t enforce the tier hierarchy from the template on the existing tiers.
Currently, I guess, the only way to achieve what you want, in (the ‘standard’) ELAN, is to manually establish the tier hierarchy of those 6 tiers after importing them from the CSV, in accordance with the hierarchy in the template. By using either Tier->Change Parent of Tier... or Tier->Copy Tier... .
If you wish, you may send a/the CSV and the template to me (han.sloetjes AT mpi.nl) so that I can check if this is possible and what would be the best approach.
-Han
Hi Han,
Ahh, ok, I understand the log. I thought it was a log rather than meant to be a file to use within ELAN, but I didn’t realize it was also updating the actual .eaf.
Thank you so much for that offer! I will send you an email now.
