Time format

[ajn-gephi]

Hi everyone,
I have edge CSV file in the following format :

source;target;start;finish
node1; node2;05-07-2009 13:23:35;05-07-2009 14:07:05
node1; node3;06-07-2009 0:50:16;06-07-2009 1:07:51
node2; node4;19-06-2010 16:10:00;19-06-2010 17:30:00
node3; node5;27-06-2010 14:40:00;27-06-2010 15:16:56

I cannot make gephi understand the time format 27-06-2010 14:40:00 = day-month-year hour:min:sec
My questions are:

1- can gephi consider the following format 27-06-2010 14:40:00 = day-month-year hour:min:sec?
if not, what format does it understand? should I convert it to the new one?
2- how can I play the graph in time after importing the data?

If one of my questions is too vague, would you please give an orientation? Thanks for you time!

AJ

[admin]

In the datalab, you need to create a new Time Interval column by taking the start and finish columns (click on Merge Columns, merge strategy "create time interval"). You'll select the time format there.

[eduramiba]

Hi,
This is the accepted time format for one of your examples:
2009-05-07T13:23:35
And with milliseconds: 2009-05-07T13:23:35.000

Note that there is a T between the date and the time. Also, time is optional. 2009-05-07 will be accepted too.

The solution proposed by Sébastien would be right, but it doesn't offer the timeformat you need. I think I will add some more formats and custom format to that feature.

Eduardo