Importing CSV files to ELAN
Up one level
Importing CSV files to ELAN
I am trying to import csv files to Elan but it doesn't work well to me...
My csv files have information about specific moments in the video where something relevant for my investigation happens. And these points in time are registered in my CSV files like this: 669472.0-672472.0 or, a little bit later, 698574.0-701574.0. These are specific points in time in the video where something relevant happens. However, I see that Elan codes time differently, like this: 00:00:00.000
These CSV files were exported from a program called Phon that is used for the analysis of phonological data (http://phon.ling.mun.ca/phontrac/).
I suppose that the codification of points in time is the problem when importing the CSV files, but I don't know if this is easy to solve or if I cannot use my csv files with Elan. Do you know how can I solve my problema?
Thank you very much in advance!
Núria
Re: Importing CSV files to ELAN
I believe all time formats that ELAN can export can also be imported, that includes bare milliseconds, sec.ms, hh:mm:ss:ms etc. Important is to know that a value of 669472.0 is interpreted as sec.ms, not as milliseconds.
Is the problem that annotations are placed at the wrong location or aren't they imported at all?
-Han
Re: Importing CSV files to ELAN
In my CSV file, the time expression 669472.0 means 669 sec and 472 ms, so 00:11:09.72. <br>Do you think that I have to convert the time expressions in my CSV to sec.ms or to 00:00:00.000 before I import the CSV to Elan? or maybe Elan alone is able to understand the time expression I have now in the file? <br><br>In case I have to select any specific option in Elan when I import the CSV file, how can I do it?<br><br>Thanks in advance!<br>
Re: Re: Importing CSV files to ELAN
If all values end with ".0" you might do a find-and-replace to replace ".0" by "" (nothing). Or maybe your favorite spreadsheet application allows you to change 669472.0 to 669472?
After that, the values will be interpreted as milliseconds and importing should succeed.
-Han
Release of ELAN 4.3.0
