search

iilab / openoil

Open Oil Corporate Network Navigator
GNU General Public License v3.0
14 stars 6 forks source link

Import Financials #34

Closed jmatsushita closed 9 years ago

antnrueh commented 9 years ago

as far as i can see, that also applies to company details in general (except OC ID), i.e. shareholders and directors for Nigerian companies?

antnrueh commented 9 years ago

found some of the details, i.e. for contracts, but faced a bug: not enough space for contract details (using this query: MATCH p=(k)-[:HAS_JURISDICTION]-(a:Company)<-[hc:HAS_CONTRACTOR]-(c:Contract)<-[i:AWARDS]-(b:Company)-[:HAS_JURISDICTION]-(j) WHERE TOINT(c.value_usd) > 10000000 UNWIND nodes(p) as nodes UNWIND relationships(p) as links RETURN {nodes: [ x in collect(DISTINCT nodes) | {node: x, label: labels(x), id: id(x)}], links: collect(DISTINCT links)} as result image

jmatsushita commented 9 years ago

Hey @antnrueh Please start an issue for each different problem. I've started a new issue for the lack of space for contract details (#35). Please start a new issue with details if your previous comment about missing company details is confirmed.

jmatsushita commented 9 years ago

@antnrueh What is the currency of the CSV file and is it consistent for all rows?

antnrueh commented 9 years ago

@jmatsushita it is GBP, in all cases and yes, it is consistent. hope that answers your question

antnrueh commented 9 years ago

@jmatsushita please ignore my comment about shareholders/directors. seems like i just made that up - sorry :)