Re: Entering large chunk of data

Thanks guys, I think Ill go with .import filename tablename I have the table sqlite> .schema promo_new CREATE TABLE "promo_new" ( "id" integer NOT NULL PRIMARY KEY, "title" varchar(200) NOT NULL, "news_content" varchar(200) NOT NULL, "pub_date" datetime NOT NULL ); for news model s

Re: Entering large chunk of data

in sqlite3 (the sqlite3 shell), you can use .import to import data from a text file. It works great. You may need to change the separator. For a one time load, this is probably the easiest method. Dhruv Adhia wrote: > Hey, > > I would prefer second method as I am using sqlite3. > > Is this

Re: Entering large chunk of data

Hello Dhruv, On Jun 24, 11:03 am, Dhruv Adhia wrote: > Is this what you mean? > django-admin.py loaddata mydata.json , If so I how do I populate json file > such large amounts of data? The LOAD DATA was in reference too the LOAD DATA INFILE command < http://dev.mysql.com/doc/refman/5.1/en/load

Re: Entering large chunk of data

Hey, I would prefer second method as I am using sqlite3. Is this what you mean? django-admin.py loaddata mydata.json , If so I how do I populate json file such large amounts of data? Thanks, On Wed, Jun 24, 2009 at 10:48 AM, creecode wrote: > > Hello Dhruv, > > Two ways you can do this, that

Re: Entering large chunk of data

Hello Dhruv, Two ways you can do this, that I know. Use your databases' built in data import technique. For example with MySql you can use LOAD DATA. Alternately you could use manage.py shell to run python code to load your data. Read about manage.py shell and dbshell here < http://docs.django

Entering large chunk of data

Hello All, I have news field in django admin and I would like to enter 2000 news items at once. May I know how to do it in shorter way? Thanks, Dhruv --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" gr