Hi Damian,
I managed to solve the earlier problem, I simply deleted all existing
the configurations using martj then started again by selecting 'naive'
and the web site was able to use the naive configuration well. I then
opened the xml in a text editor and modified portions to include
portions of xml I had generated using xsl from my table database schema.
But a new problem arised, using two main tables where one main table
inherits the all the fields of the other table and uses the other
table's PK as it's FK, and having dimension tables from both the main
tables (each dm table referenced only one of the main tables), very
many records were being returned in the output section, perhaps a
cartesian product was being returned.
So I reverted to using only one main table (by combining the main
tables), for the dimension table that referenced only the main main
table and now only a subset of the new main table, for each row in the
main table that matched a given row in this dm table, I created a
duplicate row for it in the dm, that way each similar record in the main
table is represented in the dm table.
Allan.
Damian Smedley wrote:
On Sat, 1 Jul 2006, allank wrote:
Hi all,
Is there any XML schema or dtd for biomart 0.4 xml configuration
document I would use to validate the configuration document I am
generating against.
The DTD we had was pretty basic so not that useful for validation.
MartEditor does a lot of validation checks when you export the XML to the
databases such as checking the tables and fields exist, internalNames are
not duplicated etc.
Are you still having the same error - send us your XML if you want me to
take a look at it
cheers
Damian
Allan.
