data import and auto-incrementing id columns

2010-07-20 Thread Mike Dewhirst
The data I want to import is in Paradox tables and that can be easily exported in any format. However, I believe the id columns in Paradox are gunna have to be used to re-establish relationships (1:n and n:m) in PostgreSQL. How is this going to work when django models specify auto-incrementin

Re: data import

2008-03-04 Thread sector119
On 4 Бер, 13:33, "Ben Ford" <[EMAIL PROTECTED]> wrote: > How about setting a default value on all of the database tables the you are > specifying in the dict that you're doing the update with? Hi, Ben, those values can't be set as default value for the table column. Each model may have not only o

Re: data import

2008-03-04 Thread Ben Ford
How about setting a default value on all of the database tables the you are specifying in the dict that you're doing the update with? On 04/03/2008, sector119 <[EMAIL PROTECTED]> wrote: > > > Hi ALL! > > I need to import data in CSV format into my models everyday ~ 500.000 > rows. But my CSV files

data import

2008-03-04 Thread sector119
Hi ALL! I need to import data in CSV format into my models everyday ~ 500.000 rows. But my CSV files are uncomplite, I have to append some data to every row. I use something like this to import data into my model: for d in csv.DictReader(...): d.update(my_data) MyModel.objects.create(**d) B

Re: Problem importing models in custom data import scripts

2007-03-21 Thread ScottB
Hi Nathan. On Mar 21, 12:37 am, "Nathan Harmston" <[EMAIL PROTECTED]> wrote: > My Project is called pynomics and the app alignments. > ~/pynomics/alignments/models.py > > so in my "Parser.py", I try to import the models file > from pynomics.alignments.models import * > > but I get the following e

Problem importing models in custom data import scripts

2007-03-20 Thread Nathan Harmston
Hi Guys and Gals, I am currently trying to import a large amount of data held in flatfiles into a database so that it can be displayed through Django. I am using the most recent development version of Django. I found that a new method called get_or_create, however I cant seem to get it to work as