[jira] [Assigned] (OFBIZ-810) Improve export/import services

["Adam Heath (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Heath reassigned OFBIZ-810:
--------------------------------

    Assignee: Adam Heath

> Improve export/import services
> ------------------------------
>
>                 Key: OFBIZ-810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-810
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>            Reporter: Chris Howe
>            Assignee: Adam Heath
>            Priority: Minor
>         Attachments: ArrangeSelfRelation.patch
>
>
> In postgres (and likely other databases), relational integrity is handled by the database and therefore dummy keys that don't get written to the database will fail with referential integrity issues if records aren't entered in a specific order.  To solve this dilemma, Andrew handled the import issue when the referential record in question would eventually exist by marking failed files for retry  OFBIZ-757.  Two additional scenarios would make it difficult to do straight export/import and thus serve as a true backup service.
> 1)  foreign keys may not match the referenced record's case correctly (admin != ADMIN != AdMiN )
> 2)  the necessary referenced record may be read later in an xml file and therefore will always fail referential integrity regardless of how many times it is retried
> 1 can be solved by allowing a check/correct service
> 2 can be at least partially solved by writing the xml file in an order where the referenced record gets written before the fk



--
This message was sent by Atlassian JIRA
(v6.2#6252)