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

Posted by Nicolas Malin (Jira) on Mar 12, 2007; 8:02am
URL: http://ofbiz.116.s1.nabble.com/jira-Created-OFBIZ-810-Improve-export-import-services-tp179160.html

Improve export/import services
------------------------------

                 Key: OFBIZ-810
                 URL: https://issues.apache.org/jira/browse/OFBIZ-810
             Project: OFBiz (The Open for Business Project)
          Issue Type: Improvement
          Components: framework
            Reporter: Chris Howe
            Priority: Minor


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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.