I have data like this in a csv file....
"Color Name", Base, Colorant, Amount, Colorant, Amount, Colorant,
Amount, Colorant, Amount, Colorant, Amount
"10 PORDRR",G,fo1,76,da1,32,ro1,111,yi1,1,,
It is for a paint database.
Is it at all possible to import that into this model?
Normally I would just take a few minutes and do it by hand. But I have
14,000+ entries, so that's out of the question. Any ideas? In
particular, how do you handle the variance in how many kinds of
colorants are added. Notice in this example that is only 4 colorants,
and 5+ could be in the page. (Currently from this extraction, only 5
colorants and their amounts.
db = SQLDB('sqlite://paint.sqlite')
db.define_table('paint',
Field('name', length=30, requires=IS_NOT_EMPTY(), unique=True),
Field('base_coat', length=3, requires=IS_NOT_EMPTY()),
Field('hex_color', length=6))
db.define_table('colorant',
Field('name', length=3, requires=IS_NOT_EMPTY()))
db.define_table('paint_colorants',
Field('paint_id', db.paint),
Field('colorant_id', db.colorant),
Field('units', 'integer'))
db.paint_colorants.paint_id.requires=IS_IN_DB(db, 'paint.id',
'%(name)s')
db.paint_colorants.colorant_id.requires=IS_IN_DB(db, 'paint.id',
'%(name)s')
Best Regards,
Jason Brower
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
