database columns for direct import in Gephi, esp node colour

Once it's running
Post Reply [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
richie.kavanagh
Posts:8
Joined:10 Jan 2012 21:23
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
database columns for direct import in Gephi, esp node colour

Post by richie.kavanagh » 10 Jan 2012 21:29

Hi all,
I've been piloting Gephi at work for financial transaction visualization. Folks are really impressed so a big thanks to the Gephi team for such great work.
Currently I'm successfully importing nodes and edges from a postgres database, including edge weights from a column called 'weight' and nodes sizes from a column called 'size'.

I would be grateful for some help on all the column names (and types if relevant) I can use to import into Gephi.

In particular, I am really keen to know how I can import node and edge colours as the users wish to avoid doing that mark up manually once data has come into Gephi.
I tried having a column called 'color' with content "[123,55,66]" and "123,55,66" but neither of these works.

Thanks
Rich

User avatar
mbastian
Gephi Architect
Posts:728
Joined:10 Dec 2009 10:11
Location:San Francisco, CA
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable

Re: database columns for direct import in Gephi, esp node co

Post by mbastian » 11 Jan 2012 02:59

Hi,

I think the color should be supported in the format '123,12,255' with 'color' as the name of the column. If this doesn't work please open a issue on GitHub and we'll fix it.

richie.kavanagh
Posts:8
Joined:10 Jan 2012 21:23
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable

Re: database columns for direct import in Gephi, esp node co

Post by richie.kavanagh » 11 Jan 2012 16:38

Hi,
Thank you for the quick reply. Bug submitted

Best regards,
Enda

Post Reply
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable