I have a client using a customized version of OFBiz 10.04. I gather from tracing org.ofbiz.entity.util.EntityDataLoader.loadData through to org.ofbiz.entity.GenericValue.checkFks(boolean) that if a foreign key is missing during a xml import a dummy value is created. (checkFks javadoc comment "Checks to see if all foreign key records exist in the database. Will create a dummy value for those missing when specified.")
The requirement is to Instead of creating dummy values if FKs are missing they want to load the XML files in the correct sequence to avoid the foreign key relationships or other contraint issues. Has this type of problem already been solved in later versions of ofbiz? Are then any tools available in later versions of ofbiz that can report on backup/restore failures due to violated constraints? I've heard some say ofbiz is quirky, can the developers on the list give me some guidance on where the best place to implement such functionality would be?
