On 6 Jul 2006, at 01:10, Ronaldo Raposo wrote:
Hello Arek,
My friends and I are trying to build our own mart using the
ideas described in the documentation file(in section 5.6). We created
a small database with one table, called human__cluster__name. After
that, we executed MartEditor program and configured the database
connection, and it was succeed. Then, we tried to create a naïve
configuration with dataset human and nothing happened. In the shell,
we noted that there were errors in it. So, we have some questions:
1- Do you know what happened and where did we make some mistake, or
what didn't we do? We are sending to you an attachment with the errors
and the table used and we didn't stored any data in it.
2- In the database connection, the program expects for a schema. What
is the meaning of it?
3- We are reading the user-docs, but we are having some difficulties
in this part of creating our own mart. Is there any other document,
help file or something that helps us?
I'm waiting for your reply.
Best Regards,
Ronaldo Raposo.
Hi Ronaldo,
This is possibly not mentioned in the documentation (apologies) but
you need to work with a table with at least one entry. So if you do
something
like
mysql> insert into human__cluster__main (Cluster_Id_key) values (1);
Query OK, 1 row affected (0.40 sec)
and then MEditor, 'naive' and 'export' and it will work. I tested
your table here locally with MExplorer and it worked fine.
I am cc'ing this email to mart-dev in case someone else got caught on
this.
a.
<error.txt><table.sql>
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
