[
https://issues.apache.org/jira/browse/OFBIZ-10966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16870752#comment-16870752
]
Jacques Le Roux edited comment on OFBIZ-10966 at 6/24/19 10:38 AM:
-------------------------------------------------------------------
Hi Jacques,
This is my mistake, I should have uploaded screenshots, what's included in this
patch, currently we have only 2 pages Import Json and Export Json as we have
for xml, I will try to complete "JSON Data Export All" and "JSON Data Import
Dir" by this week. what else is missing, do you thing its worth adding "JSON
Data Import Readers".
I am on ubuntu, I will check this on windows today. There we can use
File.separator instead of "/" or "\\" to avoid platform specific issues.
was (Author: jayansh):
Hi Jacques,
This is my mistake, I should have uploaded screenshots, what's included in this
patch, currently we have only 2 pages Import Json and Export Json as we have
for xml, I will try to complete "JSON Data Export All" and "JSON Data Import
Dir" by this week. what else is missing, do you thing its worth adding "JSON
Data Import Readers".
I am on ubuntu, I will check this on windows today. There we can use
File.separator instead of "/" or "\\" to avoid platform specific issues.
!importJson.png!
!exportJson.png!
> JSON entity data import and export utility
> ------------------------------------------
>
> Key: OFBIZ-10966
> URL: https://issues.apache.org/jira/browse/OFBIZ-10966
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Reporter: Jayansh Shinde
> Assignee: Jayansh Shinde
> Priority: Minor
> Attachments: OFBIZ-10966.patch, exportJson.png, importJson.png
>
>
> Currently, we support import/export entity data in XML format.
> Nowadays JSON is widely used in industry, we can have support for JSON
> format which looks quite similar to XML support.
> Here is example of XML data and it's JSON version
> {code:java}
> <Party partyId="123456" partyTypeId="PERSON" statusId="PARTY_ENABLED"/>
> {code}
> {code:java}
> {“Party”:
> {"partyId":"123456","partyTypeId":"PERSON","statusId":"PARTY_ENABLED”}}
> {code}
>
> *Design Proposal*
> We can write *entityImportJson* and *entityImportDirJson* services for
> importing JSON from screen and directory respectively.
> And the *entityExportAllJson* service for exporting entity data in JSON.
>
> *Import Design*
> The import service will perform following operations:
> 1.) Validate the input JSON data (I am in process of exploring the way for
> this)
> 2.) On successful validation, convert JSON to OFBiz's entity model
> (GenericValue)
> 3.) The GenericValue will be inserted in database by some handler class for
> e.g we can write JsonDataHandler, it will convert given JSON to
> List<GenericValue>, and finally write it to database (Similar pattern is used
> in XML import).
>
> *Export Design*
> Based on existing XML pattern the writeXmlText method of GenericEntity class
> write the exported data in XML format.
> In the similar way, we can implement writeJsonText to export data in JSON
> format.
> Please free feel to share your thought.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
