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
>
>
