I might be missing something here....
XML Schema defines the structure of data, albeit in a heirarchical data
model.
Unless I've completely missed the mark, the OFBiz data model is
relational; certainly the entitydefs looks pretty relational to me
(tables, fields, pks, fks, cardinality contraints, and so on) - not to
mention the underlying implementation.
Generally, there is nothing in a hierarchical data model that can't be
implemented in a relational one. So assuming XML Schema has no nasty
features, then there is no reason you couldn't apply a mapping from one
to the other. At least, that's in theory :-)
I've have just stumbled across a tool that might do precisely what I
want - I'll report back if it works, in case anyone else is interested.
If it works, it'll generate the SQL DDL to create the tables - going
from there to OFBiz ought to be a doddle.
Thanks for the feedback.
Cheers, Iain
BJ Freeman wrote:
what chris said is correct.
The onix DTD or XSD describes how the actual data is formated in the
XML. it is not the data.
there is no way to automatically translate the onix DTD to ofbiz
entities. this has to be done by hand.
One way, if this is going to be a daily import, is to write a import
routine. One routine reads the onix data using the onix DTD and puts
in a map that is then used to put the map data into ofbiz.
Another way is to read the XML using Dom then write out xml format for
ofbiz entities and use the webtools services to import into ofbiz.
Iain Fogg sent the following on 8/7/2006 5:51 PM:
Chris,
Good question, and this probably exposes my ignorance of XST. Maybe
it's not the right technology. Maybe I need to find a tool that can
translate from XSD -> SQL. Then it would be straightforward to map
the relational table defs to the OFBiz entity def. My small brain
can't get round the mapping of the hierarchical XML Schema to a
relational one - at least not given it's size. Maybe when I was
younger :-)
In case anyone is interested, the schema I want to map is the ONIX
schema (used in the book trade).
Cheers, Iain
Chris Howe wrote:
Correct me if I'm wrong, but wouldn't you need to know
what the source elements are in order to make an XST
to entity def? Absent knowing the structure of your
source it wouldn't matter what someone else's XST
looks like, it wouldn't work with yours.
--- Iain Fogg <[EMAIL PROTECTED]> wrote:
That's my question...has anyone already buit an XST
to do the conversion to OFBiz Entity defs?
BJ Freeman wrote:
the XSD defines the layout.
the XML is where the Entities definitions are.
you can try using an XST file to convert.
Iain Fogg sent the following on 8/7/2006 7:53 AM:
I have a slightly complicated XML Schema (.xsd)
that I would like to
import into OFBiz.
Has anyone written a tool to convert XML schemas
into OFBiz entity
definitions?
Cheers, Iain
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.7/411 -
Release Date: 7/08/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.7/411 - Release Date: 7/08/2006
