There are various ways to resolve the issue with foreign keys, and
sorting files is not the easiest or most effective way to do this.
BTW, the import directory service can kind of figure out the file
order for you by trying a directory of files over and over and in each
pass removing the successful files until all are loaded (or hopefully
all are loaded). There is no need to do it manually (and on a side
note, there are easier ways to do it manually than setting up your
files as seed data).
A better approach is to just select the "dummy fks" checkbox and it
will resolve missing foreign keys by adding a dummy record with just
the pk. Use this only if you're pretty sure that all foreign keys will
eventually be satisfied, otherwise you end up with "hanging" records
that have no data and get around what foreign keys are meant to tell
you, ie that data is missing that your data depends on. Still, the
"dummy fks" approach is the only way to get around circular
dependencies.
Another option, that Jacques kind of mentioned, is to use the Check/
Update Database page to remove all fks and then load your data, then
use that page again to add all fks back (And it will tell you if any
fks are violated when they are added back).
-David
On Oct 16, 2008, at 10:50 AM, BJ Freeman wrote:
the problem, from my experience, is that there are relationships PFK
that do not get resolved.
the only way I have found to import is to make these all part of the
intial import through the build file, ofbiz-component.xml using the
seed
reader, so you explicitly state which files get imported in what
sequence.
then do an
ant run-install-seed
Todd Burdeinei sent the following on 10/16/2008 2:40 AM:
Hello All,
I hit a snag on importing the XML from an ofbiz install. I used the
webtools
to both generate the XML and attempt the import (import was called
from
webtools/control/EntityImportDir). On the destination machine I
uploaded the
exported files to a directory called xmlfiles. I used this as the
path for
the import.
This is what the screen said:
Results:
Failed /home/user/xmldata/ReturnReason.xml adding to retry list for
next
pass
<snip- lots of files listed here>
Failed /home/user/xmldata/ProdCatalogCategoryType.xml adding to
retry list
for next pass
Pass 2 complete
---------------------------------------
Succeeded: 7 of 367
Failed: 360 of 367
---------------------------------------
Failed Files:
/home/user/xmldata/ReturnReason.xml
<snip- lots of files listed here>
Any ideas? I tried markmail and the docs website. I appreciate any
help
Many thanks
