examples of ETL json, any way to create more than one type of vertex from a single source file

[sck2015]

Hi, I am  new to orientDB but have been perusing the ETL/orientDB json examples. Is there any way to create multiple classes of vertices from the same json fetch in a given source file....  so supposing my json file had records that I wanted to create json vertices of  classes:  Person, Occupation, Nationality in a single file, would there a way to identify this in the json, supposing, off the cuff, json as follows: 

[   { name: "mark anthony",

      occupation: "roman general",

      nationality: "roman"

     },

     { name: "aurangzeb",

       occupation: "emperor",

       nationality: "indian"

      },

      { name: "cleopatra",

        occupation: "queen",

        nationality: "egyptian"

      }

  ]

and then create edges of type: "hasOccupation", "isNationality",

my question is there anyway to do this in a single json etl, I think I would have to have separate source files with just the occupation and just the nationaltiy.

ty, Sonu

[Luca Garulli]

Hi Sonu,

Have you looked at edge transformer? It does exactly what you need. Take a look at:

http://www.orientechnologies.com/docs/last/Import-from-CSV-to-a-Graph.html

Lvc@

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[sck2015]

hi Lvc, yes, I had looked at this. I think that you can only have one type (or "class") of vertex from a single source file from the examples I've seen...

is it possible to have more than joinfield name on an edge (so create an edge that joins on postid as well as some other attribute common to post and

 comment in your example) and supposing one wanted attributes in the json to be part of the edge (so more than one property per edge)... I guess I am looking for a more detailed example. ty, Sonu

[Luca Olivari]

Hi Sonu,

I work for OrientDB as Lvc@ does. We're happy to continue supporting you using this forum, but If you need more help feel free to send us a note via the contact us page on orientechnologies.com. We can assign some of the technical guys to provide more help if needed.

Thanks,

Luca