ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jayansh Shinde (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10966) JSON entity data import and export utility
Date Mon, 24 Jun 2019 02:18:00 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-10966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16870752#comment-16870752

Jayansh Shinde commented on OFBIZ-10966:

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!



> 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

View raw message