I have fixed *ETLPolitician.json* as follow:
{
> "config": {
> "log": "debug"
> },
> "begin": [
> ],
> "source": {
> "file": { "path": "./ETLPolitician.json", "lock": true }
> },
> "extractor": {
> "json": {}
> },
> "transformers": [
> { "document": { "class": "Politician"}}
> ],
> "loader": {
> "orientdb": {
> "dbURL": "plocal:../databases/AgentDatabase_Document",
> "dbUser": "admin",
> "dbPassword": "admin",
> "dbAutoCreate": false,
> "standardElementConstraints": false,
> "tx": false,
> "batchCommit": 1000,
> "dbType": "document",
> "classes": [{ "name": "Politician", "extends": "Agent" } ],
> "indexes": [{ "class": "Politician", "fields":
> ["name:string"], "type":"NOTUNIQUE_HASH_INDEX" }]
> }
> }
> }
And now having another error message,
<https://lh5.googleusercontent.com/-DAjNFCSyCwk/VPfQrswPKJI/AAAAAAAABO8/OL7-7aIyzdU/s1600/Error_msg2.PNG>
Is ETL only support 'graph' type database? Should I go for graph?
Best,
Ki
On Wednesday, March 4, 2015 at 7:06:02 PM UTC-5, Kiheung Park wrote:
>
> Hi,
>
> I want to load JSON formatted data into OrientDB. I have studied all the
> tutorial materials and sample codes that are provided by orient
> technologies teams.
> However, I am having a hard time to figuring what did I do wrong when
> importing JSON.
>
> I have already designed the document based database called
> "AgendDatabase_Document" and here is schema of Politician Class:
>
>
> <https://lh6.googleusercontent.com/-IHyrtq4yJko/VPebYoFoDFI/AAAAAAAABOg/JICwngLFb-M/s1600/Politician_Schema.PNG>
> And here is my sample json (input file / *source*):
>
> [{
>> "affiliatedCommittee": [
>> "국회운영위원회",
>> "안전행정위원회"
>> ],
>> "age": 0,
>> "birthPlace": "",
>> "birthday": "6/4/1960",
>> "class": "Politician",
>> "constituency": "경남 창원시성산구",
>> "contact": {
>> "address": null,
>> "class": "Contact",
>> "phoneNumber": null
>> },
>> "education": {
>> "class": "Education",
>> "degreeStatus": null,
>> "department": null,
>> "highschool": "마산공업고등학교",
>> "major": null,
>> "university": null
>> },
>> "experience": {
>> "class": "Experience",
>> "experience": [
>> "경남도의회 의원 (7대, 8대), 새누리당 경남도당 수석부대변인"
>> ]
>> },
>> "gender": true,
>> "group": [
>> "19"
>> ],
>> "military": "",
>> "name": "강기윤",
>> "nationality": "대한민국",
>> "partyName": "새누리당"
>> }]
>
>
>
> And here is my *ETLpolitician.json *on bin directory.
>
>> {
>> "config": {
>> "log": "debug"
>> },
>> "begin": [
>> ],
>> "source": {
>> "file": { "path": "./ETLPolitician.json", "lock": true } //have tried
>> ETLPolitician.json, but didn't work as well...
>> },
>> "extractor": {
>> "json": {}
>> },
>> "transformers": [
>> { "document": { "class": "Politician"}}
>> ],
>> "loader": {
>> "orientdb": {
>> "dbURL: "plocal:../databases/AgentDatabase_Document",
>> "dbUser": "admin",
>> "dbPassword": "admin",
>> "dbAutoCreate": false,
>> "tx": false,
>> "batchCommit": 1000,
>> "dbType": "document"
>> }
>> },
>> }
>
>
> When I run *oetl.bat ETLPolitician.json *, I got following error
> message...
>
>
> <https://lh6.googleusercontent.com/-wzd43DW69NE/VPedczNzhjI/AAAAAAAABOs/t628JRa8DHA/s1600/Error_msg.PNG>
>
> Can anyone help me on importing JSON? DEFINITELY NEED MORE
> DOCUMENTATIONS!!! :(
>
> Sincerely,
>
> Ki
>
>
--
---
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-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
