← Back to team overview

gephi.team team mailing list archive

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.