Forgive if this is totally obvious, but I'm having a bit of trouble getting data into my first prototype with django.
I am prototyping an application called repository, syncdb builds my tables and all seems to work in the admin interface. However, I have 600 lines of data I want to use as the seed for my main table. I have a sql file with INSERT commands stored in sql folder named after the model (sql/date.sql) Immediately after running syncdb, I insert the data with either <python manage.py sqlall repository> or <python manage.py sqlcustom repository>. This seems to work, it reads through the SQL and ends with this: INSERT INTO repository_date (`labno`,`siteno`,`site`,`material`,`materialcomment`,`technique`,`d13`,`rcybp`,`error`,`ref`,`provtype`,`provenience`,`provenience2`,`generalcult`,`taxon`,`comments`) VALUES ('ISGS-4242','14CM406','','CHG','','CNV','-26.7','430','70','Bevitt 1999','','','','','WLM',''); INSERT INTO repository_date (`labno`,`siteno`,`site`,`material`,`materialcomment`,`technique`,`d13`,`rcybp`,`error`,`ref`,`provtype`,`provenience`,`provenience2`,`generalcult`,`taxon`,`comments`) VALUES ('unk','14RH301','','MAZ','','AMS','-25.3','600','40','','','','','','WLM',''); CREATE INDEX "repository_date_5b0c863a" ON "repository_date" ("siteno_id"); CREATE INDEX "repository_reference_6223029" ON "repository_reference" ("site_id");COMMIT; Problem is that when I try to access these data in the admin interface or do dumpdata, nothing is there. I'm at a loss for why the data aren't populating my database. I appollogize if this is completely obvious, it's my first hack at web development and as much as I love it, some things totally mystify my. Thanks! -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.