Hi stimits, I agree with Taher about the most productive way to solve your problem.
For an overall understanding of the data model, see https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model . There's a mention there of the Data Model Resource Book by Len Silverston, which inspired much of OFBiz's data model, and links to diagrams. The diagrams are a few years old but still substantially correct and relevant. Cheers Paul Foxworthy On 8 June 2017 at 06:43, Taher Alkhateeb <[email protected]> wrote: > Hi, > > I might be wrong, but I think you're trying to do this the hard way. The > problem is really simple in that you have some missing data that is not > loading correctly. To fix this issue I would suggest the following steps: > > 1- Copy the XML data file contents > 2- Paste it into the XML data import window (i.e. > https://localhost:8443/webtools/control/EntityImport) > 3- Click Import Text > 4- Observe error message (it will tell you which foreign key is violated > and how) > 5- fix the data accordingly > 6- Repeat 1 to 5 as needed > > That would be much faster and easier than going down to the SQL level to > try to investigate. I recommend that you use the entity engine to your > advantage instead of bypassing it completely. > > HTH > > On Wed, Jun 7, 2017 at 1:42 AM, <[email protected]> wrote: > > > Hi, > > > > There are 861 tables in the ofbiz Derby database under ofbiz-16.11.02 for > > demo data. I'm trying to learn to load this data manually using SQL > > queries, and thus making a dependency list of tables with foreign key > > requirements (or even references to other tables which are allowed to be > > null). Basically, no table referencing another table's data can be loaded > > without first loading that parent table. With 861 tables and some tables > > having more than one foreign key I wanted to automate this with a SQL > query > > (I'm using SQuirrel-sqL to explore now). As such I'm looking at system > > tables describing constraints and keys. > > > > Through system tables I can find a list of tables and the ID of > > constraints which are foreign keys. However, I seem to be losing the > battle > > to find the name of the foreign table and foreign column name to which > the > > constraint points (only the table with the originating constraint is easy > > to find and automate a listing for). I see this may be possible to find > > through JDBC; SQuirrel-sqL itself shows imported and exported keys with > no > > apparent means to export the information. Can anyone tell me if it is > > possible to use an ordinary SQL query to find all foreign keys of a table > > and print the list of the child table and the parent foreign > table.column? > > If I can do this I can get around the missing WebPOS setup functionality > > and edit/load SQL directly (I'm using PostegreSQL so I can't edit a Derby > > database directly...it needs to be copied over to PostgresSQL first in > the > > proper order). > > > > If you think I need to write a JDBC app instead to map table load order > > dependencies, please let me know. I don't believe there is any other way > to > > use the WebPOS without doing it this way. I hate to think I may have to > go > > through all of those tables and hand write a spreadsheet with the > > dependencies. > > > > Thanks! > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
