[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 583: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 639: sizeof(): Parameter must be an array or an object that implements Countable
Gephi forumsPlease post new questions on facebook group too (https://www.facebook.com/groups/gephi) 2012-05-05T12:33:42+01:00 https://mail.forum-gephi.org/app.php/feed/topic/1852 2012-05-05T12:33:42+01:002012-05-05T12:33:42+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6366#p6366 <![CDATA[Re: Netflow Data and Gephi]]> You can write this <[2.0, Infinity]> for example.

Eduardo

Statistics:Posted by eduramiba — 05 May 2012 12:33

]]> 2012-05-04T21:50:24+01:002012-05-04T21:50:24+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6361#p6361 <![CDATA[Re: Netflow Data and Gephi]]> Statistics:Posted by phreakocious — 04 May 2012 21:50

]]> 2012-05-04T16:56:54+01:002012-05-04T16:56:54+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6359#p6359 <![CDATA[Re: Netflow Data and Gephi]]>
Final question: I don't really want to use a time interval, I would rather use a 'first seen' datetime. In the example below I achieve this by converting first seen datetime to unix timestamp and then add a big time offset to make sure the node stays - creating an artificial interval.

Can I use just a first seen datetime instead of interval? If not this will do.
Thanks
eduramiba wrote:No, it accepts strings.
I guess the problem is your CSV header is:

CODE: 

'source','target','weight','time interval'
Try to change it to:

CODE: 

source,target,weight,time interval
In CSV you use double quotes to make sure some text is correctly recognised, but not single quotes.

Eduardo

Statistics:Posted by bob_the_web — 04 May 2012 16:56

]]> 2012-05-04T12:46:45+01:002012-05-04T12:46:45+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6357#p6357 <![CDATA[Re: Netflow Data and Gephi]]> I guess the problem is your CSV header is:

CODE: 

'source','target','weight','time interval'
Try to change it to:

CODE: 

source,target,weight,time interval
In CSV you use double quotes to make sure some text is correctly recognised, but not single quotes.

Eduardo

Statistics:Posted by eduramiba — 04 May 2012 12:46

]]> 2012-05-04T12:24:19+01:002012-05-04T12:24:19+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6355#p6355 <![CDATA[Re: Netflow Data and Gephi]]>
They are unique strings (representing an IP address) but is the edge table expecting an integer?

bob_the_web wrote:Here is the first two lines of the CSV file:
'source','target','weight','time interval'
11.11.11.11,22.22.22.22,1,"<(1335972406,1336577206)>"

Statistics:Posted by bob_the_web — 04 May 2012 12:24

]]> 2012-05-04T12:10:15+01:002012-05-04T12:10:15+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6354#p6354 <![CDATA[Re: Netflow Data and Gephi]]>
Well the import of the CSV file for the node table worked just fine.
I did 'import spreadsheet' and selected 'node table' set the data times and it all worked. I have a node table with all of my data, and with 'node id' added.

Problem is that I can't see how to add the 'edge' table as per your list below. When I try to repeat the above and select 'edge table' and load the spreadsheet it complains:
"Edges table needs a 'Source' and 'Target' column with node ids

The node ids were added to the node table when I did the first import, but they are not in the spreadsheet?

Here is the first two lines of the CSV file:
'source','target','weight','time interval'
11.11.11.11,22.22.22.22,1,"<(1335972406,1336577206)>"



Thanks for any help.

eduramiba wrote:Hi,
Steps for import are:
  • Create new project
  • Go to data laboratory
  • Optionally import nodes data to nodes table, before edges
  • Import spreadsheet to edges table, making sure your columns are named 'Source', 'Target' and 'Weight' (optional). Case insensitive. Also remember to select types for your columns, specially TimeInterval for your 'Time interval' column.

Statistics:Posted by bob_the_web — 04 May 2012 12:10

]]> 2012-05-03T13:05:30+01:002012-05-03T13:05:30+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6347#p6347 <![CDATA[Re: Netflow Data and Gephi]]> Cheers

Statistics:Posted by bob_the_web — 03 May 2012 13:05

]]> 2012-05-03T12:40:30+01:002012-05-03T12:40:30+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6346#p6346 <![CDATA[Re: Netflow Data and Gephi]]> Yes, Spreadsheet supports weights and dynamic attributes like Time intervals.

Your CSV file like that should be fine.

Steps for import are:
  • Create new project
  • Go to data laboratory
  • Optionally import nodes data to nodes table, before edges
  • Import spreadsheet to edges table, making sure your columns are named 'Source', 'Target' and 'Weight' (optional). Case insensitive. Also remember to select types for your columns, specially TimeInterval for your 'Time interval' column.
If you did not import nodes data, check create missing nodes option when importing edges.

Eduardo

Statistics:Posted by eduramiba — 03 May 2012 12:40

]]> 2012-05-03T11:34:03+01:002012-05-03T11:34:03+01:00 https://mail.forum-gephi.org/viewtopic.php?t=1852&p=6343#p6343 <![CDATA[Netflow Data and Gephi]]> A while back you helped me get my netflow data working on Gephi, with weights. As a reminder I ended up using DL format :
<src_ip>, <dst_ip>, <number of packets>

This all works beautifully :-)

Now I would like to add time to the picture. In netflow there is a start_time and an end_time for the flow. I would like to use this to get a timeline dynamic graph.

I don't think my DL format will do this, and I have seen some examples for spreadsheet CSV format but that does not include weight. Here is my question: what is the best data input format for my netflow data? There is a lot of it so I would prefer not to have a markup format, but would prefer a CSV format if possible.

Like this??
<src_ip>, <dst_ip>, <number of packets>, <start_time>, <end_time>

From the spreadsheet CSV example I can see "<(1,10]>" as an example of time but used with a node.

Can I do a spreadsheet like this:
Source, Target, Weight, Time Interval
<src_ip>, <dst_ip>, <number of packets>, "(start_time, end_time)"

Can I do a normal CSV format (as opposed to a spreadsheet) ?
Thanks

Statistics:Posted by bob_the_web — 03 May 2012 11:34

]]>