Hi, first post so go easy on me!
I have two tables setup as shown below. I have a lot of data
(thousands of lines) that I'd like to import, but I can't seem to
figure out an easy way to relate the players.team field back to a team
in the teams table without modifying thousands of lines in excel, one
by one, to have the matching ID for a team rather than the matching
text (both csv files contain teams.name).
db.define_table('teams',
Field('name', unique=True),...)
db.define_table('players',
Field('team', 'reference teams'),...)
db.players.team.requires = IS_IN_DB(db, db.teams.id, '%(name)s')
So my question is...is there a way to csv import my players and have
w2p or sql recognize the matching team name and assign the
corresponding teams.id in the table? It seems to work this way if I
add one at a time from the interface, but obviously that would be
impractical with such a large number of items.
Thanks for you help and let me know if that wasn't clear enough!
Brad
