Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ArangoDB Import csv to edge (Graph)

I have a csv file that I want to import into a graph in ArangoDB. I'm using ArangoDB3-3.1.24 community version.

Here are the first three rows of the csv file

id,_from,_to,score
1,568703.1,568703.2,282
2,568703.1,568703.31,183
3,568703.1,568703.91,238

And here is what I tried

arangoimp --file "C:\Users\M\Desktop\file.csv" --server.username root --type csv --collection "Col_edge_L"

I think I'm missing something.

like image 951
Muna arr Avatar asked Jul 09 '17 09:07

Muna arr


1 Answers

If the edge collection doesn't already exist then you'll need to also pass the params --create-collection true --create-collection-type edge.

It could also be that the file may not be accessible to arangoimp - it may not have sufficient permissions to access the user's desktop. Try moving it to somewhere like c:\temp and see if that helps.

like image 91
K Scandrett Avatar answered Nov 04 '22 03:11

K Scandrett