Richard Cote | 3 Sep 2010 15:11
Picon
Picon
Favicon

Configuring attribute visibility

Hi Damian

I did exactly that but it appeared in martview. It's not the end of the world if 
that attribute is visible, but it represents an internal ID and makes no sense 
to anybody else but us so it really shouldn't be there.

What's the difference between 'hidden' and 'hideDisplay' and how can I get that 
attribute to not appear in martview?

Cheers,
Rc

 > Hi Richard,
 >
 > I am fairly certain if you use hideDisplay in MartEditor they should still be 
 > available for a martservice query and not appear in martview.
 >
 > Cheers
 > Damian
 >
 >
 > On Tue, Jul 20, 2010 at 8:34 AM, Richard Cote <rcote <at> xxxxxxxxx> wrote:
 >
 >     Hi all
 >
 >     I want to expose some attributes via the martservice only, not through 
the > martviewer. What are the marteditor configuration settings to achieve this
 > goal?
 >
 >     Cheers,
(Continue reading)

Arek Kasprzyk | 3 Sep 2010 15:15
Picon

FW: [BiO Jobs] Opportunity: FlyBase InterMine/BioMart developer <at> Indiana University--Bloomington, IN (US)


FYI,
Forwarding on behalf of Dave Clements

a


Arek Kasprzyk
Director, Bioinformatics Operations and Principal Investigator

Ontario Institute for Cancer Research
MaRS Centre, South Tower
101 College Street, Suite 800
Toronto, Ontario, Canada M5G 0A3
            
Tel:                        416-673-8559
Toll-free:             1-866-678-6427
www.oicr.on.ca
 
This message and any attachments may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. If you have received this message in error, please contact the sender and delete all copies. Opinions, conclusions or other information contained in this message may not be that of the organization.
 



------ Forwarded Message
From: Dave Clements <clements <at> nescent.org>
Date: Fri, 3 Sep 2010 01:47:20 -0400
To: Richard Smith <richard <at> flymine.org>, Arek Kasprzyk <arek.kasprzyk <at> oicr.on.ca>
Subject: Fwd: [BiO Jobs] Opportunity: FlyBase InterMine/BioMart developer <at> Indiana University--Bloomington, IN (US)


Hi Richard, Arek,

I want to post this to the BioMart and InterMine mailing lists.  Is that appropriate?

Dave C

---------- Forwarded message ----------
From:  <jobs <at> bioinformatics.org>
Date: Wed, Aug 25, 2010 at 2:23 PM
Subject: [BiO Jobs] Opportunity: FlyBase InterMine/BioMart developer <at> Indiana University--Bloomington, IN (US)
To: clementsnescent <at> gmail.com


Bioinformatics.Org Career Center
---------------------------------------------------------------------
Opportunity: FlyBase InterMine/BioMart developer <at> Indiana University--Bloomington, IN (US)
---------------------------------------------------------------------
BACKGROUND:
FlyBase (http://flybase.org/) is an online database of Drosophila genes and genomes.

RESPONSIBILITIES:
FlyBase is looking for a qualified software engineer to undertake a project to deploy the InterMine and BioMart data management systems. The developer will be responsible for the web and database aspects of these technologies, which will be hosted at the Indiana University FlyBase site in Bloomington, IN. This includes the initial setup and configuration of these two systems, setting up and automating update cycles in sync with the existing FlyBase release cycle, evaluating the capabilities of each, aiding in the integration of these services with existing FlyBase reports and tools, and coordinating these efforts with other model organism databases (MODs). Loading and preprocessing of data for these systems will be performed at the Harvard University FlyBase site so close coordination with developers there will also be required.

REQUIREMENTS:
- BS/MS degree in Biology or related fields
- Other fields acceptable with sufficient biological experience
- 2+ years of software development experience

- Experience with the following technologies:
-- Perl programming
-- Java programming (knowledge of JSP a plus)
-- Linux development environment (system administration skills a plus)
-- MySQL and PostgreSQL databases
-- Apache web server
-- Tomcat Java web application server
-- InterMine and/or BioMart experience a plus

LOCALE:
Department of Biology at Indiana University Bloomington, IN, USA

COMPENSATION:
Salary commensurate with qualifications and experience; full benefits included.

HOW TO APPLY:
To apply send a cover letter, CV/resume, and contact information for 3 individuals willing to serve as a reference, to flybase.jobs <http://flybase.jobs>  [at] gmail.com <http://gmail.com>  using "FlyBase RA" in the subject line or send hard copy to 1001 East Third Street, Bloomington, IN 47405.

POLICY:
Indiana University is an equal opportunity/affirmative action employer.

DEADLINE:
Applications will be accepted until a suitable candidate is identified.

---------------------------------------------------------------------
Unsubscribe from this group (login required):
http://www.bioinformatics.org/jobs/subscribe.php





--
http://gmod.org/wiki/GMOD_News
http://gmod.org/wiki/GMOD_Europe_2010
http://hinv.jp/biocuration2010/
http://gmod.org/wiki/Help_Desk_Feedback


------ End of Forwarded Message
Richard Holland | 3 Sep 2010 15:17
Favicon

Re: Configuring attribute visibility

In theory, hidden means that it won't appear in either martview or martservice. This is better than just
deleting it because if you delete it and later do an update in MartEditor, it'll come back again. 

hideDisplay means it won't show up in martview, but it'll still appear in martservice.

At least, in theory. MartEditor is a bit temperamental in actually exporting settings sometimes.
Hopefully the soon-to-be-announced 0.8 will be a big improvement on this.

cheers,
Richard

On 3 Sep 2010, at 14:11, Richard Cote wrote:

> Hi Damian
> 
> I did exactly that but it appeared in martview. It's not the end of the world if that attribute is visible,
but it represents an internal ID and makes no sense to anybody else but us so it really shouldn't be there.
> 
> What's the difference between 'hidden' and 'hideDisplay' and how can I get that attribute to not appear in martview?
> 
> Cheers,
> Rc
> 
> 
> > Hi Richard,
> >
> > I am fairly certain if you use hideDisplay in MartEditor they should still be > available for a
martservice query and not appear in martview.
> >
> > Cheers
> > Damian
> >
> >
> > On Tue, Jul 20, 2010 at 8:34 AM, Richard Cote <rcote <at> xxxxxxxxx> wrote:
> >
> >     Hi all
> >
> >     I want to expose some attributes via the martservice only, not through the > martviewer. What are the
marteditor configuration settings to achieve this
> > goal?
> >
> >     Cheers,
> >     Rc
> >     --
> >     Richard Cote
> >     Software Engineer - PRIDE Project Team (Sequence Database Group)
> >     European Bioinformatics Institute
> >     Wellcome Trust Genome Campus                 rcote <at> xxxxxxxxx
> >     Hinxton, Cambridge CB10 1SD                  Phone: (+44) 1223 492610
> >     United Kingdom                               Fax  : (+44) 1223 494468
> 
> -- 
> Richard Cote
> Software Engineer - PRIDE Project Team (Sequence Database Group)
> European Bioinformatics Institute
> Wellcome Trust Genome Campus                 rcote <at> ebi.ac.uk
> Hinxton, Cambridge CB10 1SD                  Phone: (+44) 1223 492610
> United Kingdom                               Fax  : (+44) 1223 494468
> 

--
Richard Holland, BSc MBCS
Operations and Delivery Director, Eagle Genomics Ltd
T: +44 (0)1223 654481 ext 3 | E: holland <at> eaglegenomics.com
http://www.eaglegenomics.com/

Damian Smedley | 3 Sep 2010 15:18
Picon
Picon
Favicon

Re: Configuring attribute visibility

Hi Richard,

If hideDisplay is set to true in the MartEditor XML then it definitely should not appear in MartView but it is still available for for the API, MartService calls etc. The difference from hidden is that setting this to true stops the attribute appearing in MartView and being available to the BioMart API/Services. The only point of hidden attributes and filters is to stop them reappearing everytime you do a config update in MartEditor.

If the attribute definitely has hideDisplay set to true (note it should be true and not 1) and is still appearing in MartView after running perl configure.pl --clean -r conf/reg.xml and restarting the server then this is probably a MartEditor bug. Let me know and I can come and find you and fix it.

Cheers
Damian


On Fri, Sep 3, 2010 at 2:11 PM, Richard Cote <rcote <at> ebi.ac.uk> wrote:
Hi Damian

I did exactly that but it appeared in martview. It's not the end of the world if that attribute is visible, but it represents an internal ID and makes no sense to anybody else but us so it really shouldn't be there.

What's the difference between 'hidden' and 'hideDisplay' and how can I get that attribute to not appear in martview?

Cheers,
Rc


> Hi Richard,
>
> I am fairly certain if you use hideDisplay in MartEditor they should still be > available for a martservice query and not appear in martview.
>
> Cheers
> Damian
>
>
> On Tue, Jul 20, 2010 at 8:34 AM, Richard Cote <rcote <at> xxxxxxxxx> wrote:
>
>     Hi all
>
>     I want to expose some attributes via the martservice only, not through the > martviewer. What are the marteditor configuration settings to achieve this
> goal?
>
>     Cheers,
>     Rc
>     --
>     Richard Cote
>     Software Engineer - PRIDE Project Team (Sequence Database Group)
>     European Bioinformatics Institute
>     Wellcome Trust Genome Campus                 rcote <at> xxxxxxxxx
>     Hinxton, Cambridge CB10 1SD                  Phone: (+44) 1223 492610
>     United Kingdom                               Fax  : (+44) 1223 494468

--
Richard Cote
Software Engineer - PRIDE Project Team (Sequence Database Group)
European Bioinformatics Institute
Wellcome Trust Genome Campus                 rcote <at> ebi.ac.uk
Hinxton, Cambridge CB10 1SD                  Phone: (+44) 1223 492610
United Kingdom                               Fax  : (+44) 1223 494468


Richard Cote | 3 Sep 2010 15:19
Picon
Picon
Favicon

Re: Configuring attribute visibility

Richard Holland wrote:
> 
> hideDisplay means it won't show up in martview, but it'll still appear in martservice.
> 
> At least, in theory. MartEditor is a bit temperamental in actually exporting settings sometimes.
Hopefully the soon-to-be-announced 0.8 will be a big improvement on this.
> 

Riiiiiiiiight. So is there a way I can kick it in the pants and make it behave 
like it should?

Cheers,
Rc
--

-- 
Richard Cote
Software Engineer - PRIDE Project Team (Sequence Database Group)
European Bioinformatics Institute
Wellcome Trust Genome Campus                 rcote <at> ebi.ac.uk
Hinxton, Cambridge CB10 1SD                  Phone: (+44) 1223 492610
United Kingdom                               Fax  : (+44) 1223 494468

Gabriel Berriz | 3 Sep 2010 21:03
Picon
Favicon

possible biomart bug

Hi.  The following queries result in the server-side errors shown:

<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="merops"/>
  </Dataset>
</Query>

Query ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'


<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="pdb"/>
  </Dataset>
</Query>

Query ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_PDB__dm.translation_id_1068_key' in 'where clause' (drosophila_melanogaster/pdb)


Other similar queries work fine.  E.g.:

<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="embl"/>
  </Dataset>
</Query>


Similar errors arise if one attempts the same query through the web interface.  E.g., for MEROPS:

Serious Error: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'
ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'
If you repeatedly get directed to this error page, there may be a problem with your current session parameters. To clear your session and start with a clean slate, please click the New button below.
Stacktrace:
Exception::Class::Base::throw /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Web.pm:2461
(eval) /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Web.pm:2213
BioMart::Web::handle_request /ensemblweb/wwwmart/www_59/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/wwwmart/www_59/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_wwwmart_www_59_biomart_2dperl_cgi_2dbin_martview::handler /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0


Thanks!
Gabriel



=============================================================
Gabriel F. Berriz, PhD
Senior Bioinformatics Developer
Roth Lab
Biological Chemistry and Molecular Pharmacology -- Harvard Medical School
250 Longwood Avenue
Seeley G. Mudd Building 322B
Boston, MA 02115-5701
Telephone: 617.432.3555
Fax: 617.432.3557





Junjun Zhang | 3 Sep 2010 21:44
Picon

Fwd: possible biomart bug

Forward to Ensembl team that is responsible for the Ensembl marts.



Begin forwarded message:

From: Gabriel Berriz <gberriz <at> hms.harvard.edu>
Date: September 3, 2010 3:03:27 PM EDT
Subject: [mart-dev] possible biomart bug

Hi.  The following queries result in the server-side errors shown:

<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="merops"/>
  </Dataset>
</Query>

Query ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'


<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="pdb"/>
  </Dataset>
</Query>

Query ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_PDB__dm.translation_id_1068_key' in 'where clause' (drosophila_melanogaster/pdb)


Other similar queries work fine.  E.g.:

<Query completionStamp="1" virtualSchemaName="default" uniqueRows="1" requestId="biomart-client">
  <Dataset interface="default" name="dmelanogaster_gene_ensembl">
    <Attribute name="embl"/>
  </Dataset>
</Query>


Similar errors arise if one attempts the same query through the web interface.  E.g., for MEROPS:

Serious Error: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'
ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'ensembl_mart_59.dmelanogaster_gene_ensembl__ox_MEROPS__dm.translation_id_1068_key' in 'where clause'
If you repeatedly get directed to this error page, there may be a problem with your current session parameters. To clear your session and start with a clean slate, please click the New button below.
Stacktrace:
Exception::Class::Base::throw /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Web.pm:2461
(eval) /ensemblweb/wwwmart/www_59/biomart-perl/lib/BioMart/Web.pm:2213
BioMart::Web::handle_request /ensemblweb/wwwmart/www_59/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/wwwmart/www_59/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_wwwmart_www_59_biomart_2dperl_cgi_2dbin_martview::handler /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/ensembl_web/apache/lib/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0


Thanks!
Gabriel



=============================================================
Gabriel F. Berriz, PhD
Senior Bioinformatics Developer
Roth Lab
Biological Chemistry and Molecular Pharmacology -- Harvard Medical School
250 Longwood Avenue
Seeley G. Mudd Building 322B
Boston, MA 02115-5701
Telephone: 617.432.3555
Fax: 617.432.3557






Arek Kasprzyk | 4 Sep 2010 03:10
Picon

Recent sequence problems - rectified


Hi everyone,
This is  just to let you know that the recent  “slow sequence” problems should now be hopefully rectified


a


Arek Kasprzyk
Director, Bioinformatics Operations and Principal Investigator

Ontario Institute for Cancer Research
MaRS Centre, South Tower
101 College Street, Suite 800
Toronto, Ontario, Canada M5G 0A3
            
Tel:                        416-673-8559
Toll-free:             1-866-678-6427
www.oicr.on.ca
 
This message and any attachments may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. If you have received this message in error, please contact the sender and delete all copies. Opinions, conclusions or other information contained in this message may not be that of the organization.
 


a.hassan | 8 Sep 2010 11:01
Picon

Command Based marteditor


Hi,

I am working at Medical Research Council, Harwell, UK. We provide the
biomart interface to Europhenome database. We are trying to automate the
process of re-building biomart with new data. At the moment we need to run
marteditor manually and update the dataset in previously created mart. Is
there a command based marteditor tool available that allows us to script
everything for updating mart with the new data?

Thanks.

Europhenome Team
MRC, Harwell

This email may have a PROTECTIVE MARKING, for an explanation please see:
http://www.mrc.ac.uk/About/Informationandstandards/Documentmarking/index.htm

Joachim Baran | 8 Sep 2010 12:00
Picon
Favicon

Re: Command Based marteditor

Hi!

  You might be interested in MartScript,
http://github.com/joejimbo/MartScript, which can be used to
automatically create Ensembl (and related) marts.

  I do not know your database structure, but perhaps it would work for
you with some minor modifications as well. The major downside of using
MartScript right now is obvious: I have been too lazy to document it
properly yet. If you have a go at it, please let me know and perhaps
we can figure out to get it working together. Are you around at Genome
Informatics next week? We could have a chat about it too.

Best Wishes,
Joachim

--

-- 
B.1079 Michael Smith Building
Faculty of Life Sciences
The University of Manchester
Oxford Road
Manchester
M13 9PT
United Kingdom


Gmane