Re: Mapping Derby Sample Data Foreign Keys

2017-06-10 Thread stimits
if this will need an outside script). Thanks! - Original Message -From: G.W. Haywood <of...@jubileegroup.co.uk>To: user@ofbiz.apache.orgSent: Sat, 10 Jun 2017 11:25:26 - (UTC)Subject: Re: Mapping Derby Sample Data Foreign Keys Hi there, On Sat, 10 Jun 2017, stimits.comcast.net wrote: &g

Re: Mapping Derby Sample Data Foreign Keys

2017-06-10 Thread G.W. Haywood
Hi there, On Sat, 10 Jun 2017, stimits.comcast.net wrote: So far as just loading data from sample into PostegreSQL goes, I still need to do the same mapping of foreign keys and columns to foreign tables which are allowed to be null. If it's of any interest I might be able to help you with

Re: Mapping Derby Sample Data Foreign Keys

2017-06-09 Thread stimits
can't do that from within the existing interfaces (due to WebPOS requirements). Thanks! - Original Message -From: Mike <mz4whee...@gmail.com>To: user <user@ofbiz.apache.org>Sent: Fri, 09 Jun 2017 15:56:07 - (UTC)Subject: Re: Mapping Derby Sample Data Foreign Keys

Re: Mapping Derby Sample Data Foreign Keys

2017-06-09 Thread Mike
tanding how to > set up a new business. Right now I'm basically reverse engineering this > when all I really wanted to do was set up the existing features and get it > running (modification could come later). > > > > So I'm back to finding ways to map table relationships in Derby...

Re: Mapping Derby Sample Data Foreign Keys

2017-06-08 Thread Michael Brohl
existing features and get it running > (modification could come later). > > So I'm back to finding ways to map table relationships in Derby...it looks > like a simple SQL query won't be possible, I'm going to have to use the JDBC > interface. > > Thanks! > > - Original Message

Re: Mapping Derby Sample Data Foreign Keys

2017-06-08 Thread stimits
: Thu, 08 Jun 2017 07:31:52 -0000 (UTC)Subject: Re: Mapping Derby Sample Data Foreign Keys Hi stimits, I agree with Taher about the most productive way to solve your problem. For an overall understanding of the data model, seehttps://cwiki.apache.org/confluence/display/OFBIZ/Data+Model . Ther

Re: Mapping Derby Sample Data Foreign Keys

2017-06-08 Thread Paul Foxworthy
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

Re: Mapping Derby Sample Data Foreign Keys

2017-06-07 Thread Taher Alkhateeb
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

Mapping Derby Sample Data Foreign Keys

2017-06-06 Thread stimits
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