Hello, If the loading fails then OFBiz would give you an error message. Trace it to debug what is missing. Just go to webtools, load the XML files and observe the error message. It should tell you exactly what's wrong. Usually it is foreign key violations which means missing data somewhere.
On Tue, May 23, 2017 at 2:05 AM, <[email protected]> wrote: > Hi, > > I'm still trying to find a way to load Web POS data for non-sample/real > world, and it seems the actual SQL tables are not too complicated for this > purpose (at least under PostgreSQL). I had been going through load logs > when loading sample data and then trying to recreate by manually loading > xml files under PostgreSQL, but have never been able to find a way to > successfully load sample data this way (Web POS never works). I am thinking > that if I can browse and query the Derby database, then perhaps I can > manually export/edit data and then use SQL through psql to load a > customized version of that data. To that extent I found application "ij" > for browsing Derby in a similar way as psql. > > When using ij to browse a Derby database is there a particular file or > other method where I could use ij for an ofbiz server loaded with demo > data? I have the browse application, but I'm not sure about how to connect. > Or perhaps there is a better way to dump a Derby database as SQL data and > tables other than ij? > > Thanks!
