[arangodb-google] ArangoDB Graph Traversal for bank account number (money transfer)

[Mr Loke]

Hi
I have a csv file containing the following fields:

date,amount,name, from, to
25-02-2018,900.00,Ibrahim, 5196030001, 5196030002
26-02-2018,100.00,Angela, 5196030002, 5196030003
27-02-2018,100.00,Michael, 5196030003, 5196030004
28-02-2018,100.00,Tom, 5196030004, 5196030064

How do I build the graph which can automatically link from account
5196030001 to 5196030004 ? From the documentation, it said I need to define
the inbound and outbound vertex one by one which is not feasible to do when
I have over a million records.

Any idea that this can be done in ArangoDB ?

[Wilfried Gösgens]

Hi,
you edit the headline to have _from and _to, and then you use:

--from-collection-prefix <string> _from collection name prefix (will
be prepended to all values in '_from') (default: "")
--to-collection-prefix <string> _to collection name prefix (will
be prepended to all values in '_to') (default: "")

so set "vertexcollection/" in front of these numbers - which are your
vertex identifiers your edges should reference, right?

Post by Mr Loke
Hi
date,amount,name, from, to
25-02-2018,900.00,Ibrahim, 5196030001, 5196030002
26-02-2018,100.00,Angela, 5196030002, 5196030003
27-02-2018,100.00,Michael, 5196030003, 5196030004
28-02-2018,100.00,Tom, 5196030004, 5196030064
How do I build the graph which can automatically link from account
5196030001 to 5196030004 ? From the documentation, it said I need to define
the inbound and outbound vertex one by one which is not feasible to do when
I have over a million records.
Any idea that this can be done in ArangoDB ?

[Mr Loke]

Hi Wilfried,
I am using the Arangoimp to import the csv file.

I have renamed the csv file with the following headers:
date,amount,name, _from, _to

I use the following command in command prompt:

arangoimp --file "C:\ArangoDB\Deposit.csv" --type csv --collection
"CustomerFromTo" --server.username root --server.password 112233
--create-collection true

When I use the ArangoDB Web interface to build the graph, it ask for the
edge definition file which doesn't exist and I am not sure how to create it
.Refer to attachment.

Post by Wilfried Gösgens
Hi,
--from-collection-prefix <string> _from collection name prefix
(will be prepended to all values in '_from') (default: "")
--to-collection-prefix <string> _to collection name prefix (will
be prepended to all values in '_to') (default: "")
so set "vertexcollection/" in front of these numbers - which are your
vertex identifiers your edges should reference, right?

Post by Mr Loke
Hi
date,amount,name, from, to
25-02-2018,900.00,Ibrahim, 5196030001, 5196030002
26-02-2018,100.00,Angela, 5196030002, 5196030003
27-02-2018,100.00,Michael, 5196030003, 5196030004
28-02-2018,100.00,Tom, 5196030004, 5196030064
How do I build the graph which can automatically link from account
5196030001 to 5196030004 ? From the documentation, it said I need to define
the inbound and outbound vertex one by one which is not feasible to do when
I have over a million records.
Any idea that this can be done in ArangoDB ?