Creating csv with timeline & geolayout

Hi,

Here are some tips to do that:

https://wiki.gephi.org/index.php/Import_Dynamic_Data
https://forum.gephi.org/viewtopic.php?f=23&t=2037

Thank you. I opened the empty-dynamic.gexf file and then imported my csv file. I am unable to get the Time Interval to work with Latitude and Longitude. From what I gathered from here (http://forum.gephi.org/viewtopic.php?t=1668), I should make my Year, latitude and longitude look like this?

"<[2004.0, 2008.0]; [2009.0, 2011.0]>" "<[2004.0, 2008.0, 50.701024]; [2009.0, 2011.0, 42.359242]>" "<[2004.0, 2008.0, 7.10364]; [2009.0, 2011.0, 42.359242]>"

Also, when I import the csv, I make the column Year as a time interval, but the column in Gephi comes up as blank?

I am very confused.

Hi,
Yes, your data should work fine, too.

At least a csv file like the following works right:
id year lat long
1 "<[2004.0, 2008.0]; [2009.0, 2011.0]>" "<[2004.0, 2008.0, 50.701024]; [2009.0, 2011.0, 42.359242]>" "<[2004.0, 2008.0, 7.10364]; [2009.0, 2011.0, 42.359242]>"

http://i.imgur.com/rfvl5.png

Make sure to choose space as separator and the year column type as Time Interval.
Also make sure to use latest Gephi version with updates.

I am using Gephi 0.8.1 beta, no updates needed.

If I choose space as a separator, it does not give me an option to separate the columns - only using comma as a separator lets me move forward in the way described. When I choose the options in the picture, all 3 fields (year, lat, long) come up as blanks and I cannot enable timeline.

Just so I can make sure I am doing the steps right:

Open Gephi, run empty-dynamic.gexf, import spreadsheet under data laboratory just like the pic you sent.

test csv file: http://i.imgur.com/9TBxX.png
after import: http://i.imgur.com/WZRfe.png

Oh, you use excel to create the file.

Then don't put double quotes in excel, it will put them for you where necessary.
Also, it uses semicolon as separator.

Make sure you see this in first step.
http://i.imgur.com/Npr2e.png

Again, the comma is the only option that will allow me to move forward the correct way. Removing the double quotes worked, but the lat and long columns cannot work with Geolayout as a DynamicFloat. When I changed it to DynamicDouble, it worked okay. I am able to run the Geolayout and enable timeline.

However, I cannot hit play in Timeline. Why would that be? The bounds and the time frame seem okay.

Thank you!

Nice. I guess then the separator depends on excel version/configuration.

To use play, you have to reduce the timeline window so it can move (drag the ends of it).

Yes! Great, thank you. It is working wonderfully now.

Thanks again!