Thank you very much! For the answer and for web2py!
Best regards,
Marian
W dniu poniedziałek, 28 maja 2012 użytkownik Massimo Di Pierro napisał:
> If there are empty rows in the CSV files they will perceived as end of
> data.
>
> On Sunday, 27 May 2012 12:08:21 UTC-5, Marian Siwiak wrote:
>>
>> Hi, I try to populate database defined below:
>>
>> db.define_table('t_yeast',
>> Field('f_gene_id', type='string',
>> label=T('Gene Id')),
>> Field('f_oid', type='string',
>> label=T('Other IDs')),
>> Field('f_l', type='integer',
>> label=T('transcript length [codons] - L')),
>> Field('f_x', type='double',
>> label=T('transcripts per cell - x')),
>> Field('f_bs', type='double',
>> label=T('number of proteins produced from a single transcript
>> during its lifespan - b')),
>> Field('f_g', type='double',
>> label=T('ribosome density in number of ribosomes per 100 codons
>> - g')),
>> Field('f_w', type='double',
>> label=T('number of ribosomes attached to a single transcript -
>> w')),
>> Field('f_i', type='double',
>> label=T('translation initiation time [ms] - I')),
>> Field('f_a', type='integer',
>> label=T('total protein abundance - A')),
>> Field('f_e', type='double',
>> label=T('translation elongation time [ms] - E')),
>> Field('f_em', type='double',
>> label=T('mean codon elongation time [ms] - ē')),
>> Field('f_m', type='datetime',
>> label=T('transcript mean lifetime [ms] - m')),
>> Field('f_gene_desc', type='string',
>> label=T('Gene Description')),
>> Field('f_q', type='text',
>> label=T('FASTA sequence')),
>> format='%(f_gene_id)s',
>> migrate=settings.migrate)
>>
>> db.define_table('t_yeast_**archive',db.t_yeast,Field('**current_record','reference
>> t_yeast',readable=False,**writable=False))
>>
>>
>> with following data from csv file:
>> "t_yeast.id","t_yeast.f_gene_**id","t_yeast.f_l","t_yeast.f_**
>> x","t_yeast.f_bs","t_yeast.f_**g","t_yeast.f_w","t_yeast.f_i"**
>> ,"t_yeast.f_a","t_yeast.f_e","**t_yeast.f_em","t_yeast.f_m","**
>> t_yeast.f_gene_desc","t_yeast.**f_q","t_yeast.f_oid"
>>
>> "1000","YAL001C",1161,1.3,89,**0.491,5.7,49.477,,282.084,243,**1:13:21,"Largest
>> of six subunits of the RNA polymerase III transcription initiation factor
>> complex (TFIIIC); part of the TauB domain of TFIIIC that binds DNA at the
>> BoxB promoter sites of tRNA and similar genes; cooperates with Tfc6p in DNA
>> binding","ATG","TFC3 SGDID:S000000001 Verified ORF"
>>
>> "1001","YAL002W",1275,0.4,149.**6,0.715,9.12,34.276,,312.664,**
>> 245.2,1:25:28,"Membrane-**associated protein that interacts with Vps21p
>> to facilitate soluble vacuolar protein localization; component of the
>> CORVET complex; required for localization and trafficking of the CPY
>> sorting receptor; contains RING finger motif","ATG","VPS8 SGDID:S000000002
>> Verified ORF"
>>
>> I get information "data uploaded" but nothing happens.
>>
>> Any help, please?
>>
>> best regards,
>> Marian
>>
>>
