Fields seperated with \t sounds a bit like a CSV export right? I
needed to import CSV too, so I used the csv module to parse the file
and then django models to store it in the database, no custom sql
needed.
# set up django environment
[ ... ]
import csv
reader = csv.reader(open('file.csv', 'r'), delimiter=r'\t',
quotechar='"')
for row in reader:
myapp.mymodel.objects.create(
pk=row[0],
title=row[1],
...
)
On May 23, 4:04 am, Herta <herta...@gmail.com> wrote:
> The input file is a plain txt file with \t, I just want to know if
> there is a function to import data from the existing file, if i don't
> write a script with a sql='insert into table values(...) '
>
> On May 23, 8:43 am, George Song <geo...@damacy.net> wrote:
>
> > On 5/22/2009 5:07 PM, Herta wrote:
>
> > > I want to load data to database (sqlite3 ) from file. I have already
> > > connect django and my database, and build the tables but how can i
> > > load data from file?
>
> > What kind of files are these? If they are existing legacy data files,
> > you'll have to write some sort of de-serializer to translate them to fit
> > your model(s).
>
> > If the file happens to be one of the serialization formats that Django
> > already knows how to deal with, you might be able to use Django's
> > serialization somehow.
>
> > But some more specifics on your data format will allow us to help you more.
>
> > --
> > George
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
