Data import from Oracle database ... again ?

[muemi03]

Hi. I am trying to use the oracle driver to access data. Unfortunately, I am not successful. It seems, that my nodes gets imported with id values starting from 1 and incremented by 1, even though I my node select statement selects an id columns with different values. That lead to the issue, that Gephi will not import any edges, as the source and target values will not be found in the nodes list... For example, here are my queries: node: select dbms_utility.get_hash_value(own_resource_uuid,10, 98 ) as id , to_char(resource_name) as label from mdbadmin.ca_owned_resource where resource_name like 'S%'

edge: select dbms_utility.get_hash_value(hier_child,10, 98 ) as source, dbms_utility.get_hash_value(hier_parent,10, 98 ) as target from busmgt

Any idea what I am doing wrong ? Thank you

[eduramiba]

Hi, Are you using Gephi 0.9.2?

[muemi03]

Thanks for responding. Yes. Gephi 0.9.2. I just realized , that I might need to use integer (oracle column type 'number') id's only. I did that. But even then. Only my nodes gets imported, but no edges. And the imported id's do not match to the selected ones....strange somehow. Hmm. I am puzzled

[muemi03]

hmm. it really seems, that my id's gets ignored. If I am importing 56 nodes, they get the id's 0-55 If I do the same import again to a new worksheet. they get id's 56-111. and so on....

[muemi03]

This might be the wrong place to ask questions like these. Shall I go to http://forum-gephi.org ? Thanks

[eduramiba]

Hi, I think what you are doing should work but I can't investigate it right now, sorry. The forum is quite inactive and might become read-only. But I suggest you ask for help in the Facebook Gephi group: https://www.facebook.com/groups/gephi/ Usually there are replies.

[mbastian]

Closing old issue. As of now, I advice to use the Q&A section in https://github.com/gephi/gephi-toolkit/discussions for those kind of requests.