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!
