gephi.team team mailing list archive
-
gephi.team team
-
Mailing list archive
-
Message #00412
Re: [Question #115164]: Must the database tables have specific names?
Question #115164 on Gephi changed:
https://answers.launchpad.net/gephi/+question/115164
Status: Open => Answered
Mathieu Bastian proposed the following answer:
Yes columns must have names in order to be recognized. The most
important is to have the ID column set for nodes and the SOURCE and
TARGET columns for edges. The source and target values must be the ID
found for nodes.
For nodes:
Property ID = id Column
Property LABEL = label Column
For edges:
Property ID = id Column
Property SOURCE = source Column
Property TARGET = target Column
Property LABEL = label Column
Property WEIGHT = weight Column
I suggest:
SELECT domain_name AS id from FROM gephi.friendscout24denodes;
SELECT from_domain AS source, to_domain AS target FROM gephi.friendscout24deedges;
see also http://forum.gephi.org/viewtopic.php?f=4&t=292
--
You received this question notification because you are a member of
Gephi Team, which is an answer contact for Gephi.