[SOLVED] Drupal relation module (mysql)
Posted: 02 Jun 2012 23:06
Big shoutout to the Gephi team for this mindblowing application!
Hopefully someone can help me out with this one:
I´m importing node relations from Drupal that I created using the amazing Relation module. Gephi and Drupal are my new friends now I successfully imported all the nodes but I´m having difficulties importing the edges.The Relation module stores the source and the target them in the same column.
Here is the db schema used by the Relation module:
relation table
field_data_endpoints table
In this schema the source is "14" (index=0) and the target "7" (index=1). If the relationships are multi-dimensional I would get another row with an incremented index.
So.... I need help with the SQL query to pull this into Gephi. Please let me know if you can help.
Thanks in advance,
Hlussa.
Hopefully someone can help me out with this one:
I´m importing node relations from Drupal that I created using the amazing Relation module. Gephi and Drupal are my new friends now I successfully imported all the nodes but I´m having difficulties importing the edges.The Relation module stores the source and the target them in the same column.
Here is the db schema used by the Relation module:
relation table
Code: Select all
rid - relation_type
6 - works_for
Code: Select all
entity_id - endpoints_entity_id - endpoints_r_index
6 14 0
6 7 1
So.... I need help with the SQL query to pull this into Gephi. Please let me know if you can help.
Thanks in advance,
Hlussa.