[arangodb-google] How to add Indexdata in _to and _from field in CSV file

[Lasse Kay]

Hello,

Hello together i am new in learning ArangoDB. I have following problem with
importing a csv file as edges:
i have 2 CSV files with same and unique IDs. They can be imported as
collections without any error.


Example:

CSV 1:

ID,company,status
...
12342,Google,activ
...

CSV 2:

ID,name,surname,
...
12342,adkins,scott
...


so i can change CSV 1 manually to:

CSV 1:

*_key*,company,status
...
12342,Google,activ
...

and can perfectly import it as maybe "companys" into my database, but i
want to change CSV 2 to that:

CSV 2:

_from,name,surname,_to
...
*12342*,adkins,scott,...
...

In the new _from would be the right _key of his vertex object but arangoDB
needs the full ID, so i need something like that:
CSV 2:

_from,name,surname,_to
...
*companys/12342*,adkins,scott,...
...

So what i need is preferably a arangoimp option or some other solution with
shell thats automaticly generated that lost index data while importing.
Or a script for manipulating the csv file before importing. I use ubuntu.
Hope someboy can help me thanks in advance :)