We can import Database File in MS-EXCEL in our ARANGODB using its tool 'arangoimport'. arangoimport --file DIR-path\airports.csv --collection airports --create-collection true --type csv
On Wednesday, January 29, 2020 at 5:06:33 AM UTC+8 [email protected] wrote: > Is there any possible way to import data with only a singular csv? From > what I have found the typical means of import with arangoimp has you import > the nodes as separate document csv and a to/from edge csv. > > For context, imagine I have the below dummy data in a csv. Student, Major, > and Class are labels for nodes each with respective name properties of the > below data. Graduation date is a property of the student node as well. A > given student node has relationships with the major node and the class > nodes. Bonus if you can figure out how it could handle variable number of > "class" columns. > > Student| Graduation | Major |Class | Class2 | Class3 | Class4 | Class5 | > ... > Jack | 2021 | IT |Math | Science| History| Coding | > John | 2023 | Finance |Math | Science| History| English| Spanish| > Jake | 2020 | Finance |French| English| Spanish| | | > > > Is there any way that this can all be imported efficiently into arangodb. > I know I can obviously perform data transfomation to get it into the proper > format, but is that takes time and sometimes I want quick imports for > testing purposes. > > Taboo to mention them here maybe, but in Neo4j I was able to get an import > cypher query written up real easy to handle this, where I can map out the > values and it even handles repeat nodes. I am looking to maybe switch from > neo to arango but this issue is kinda bugging me. > -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/arangodb/f773e7cf-00d5-4684-aab7-ac5ce8198a4dn%40googlegroups.com.
