Re: Loading csv data in database

try the below way. Its simple

Writing custom django-admin commands | Django documentation | Django

Writing custom django-admin commands | Django documentation | Django

Regards,

Amitesh

On Friday, 30 April, 2021, 08:28:07 pm IST, Derek <gamesbook@gmail.com> wrote:

Someone has an example of doing just this:

https://arshovon.com/blog/django-custom-command/

On Thursday, 29 April 2021 at 19:39:36 UTC+2 Ryan Nowakowski wrote:

Typically you would write a custom management command for this kind of thing:

https://docs.djangoproject.com/en/3.2/howto/custom-management-commands/

On April 29, 2021 11:05:29 AM CDT, 'Muhammad Asim Khaskheli' via Django users <django...@googlegroups.com> wrote:

Hi,

I wanted to ask how to load CSV data into the model. What steps do we have to follow?

I have made this function but how exactly to run this code because, python manage.py load data won't work.

def import_data():
with open('sample-dataset.csv') as f:
reader = csv.reader(f)
for row in reader:
if row[0] != 'user_id':
_, created = Funnel.objects.get_or_create(
user_id=row[0],
event=row[1],
timestamp=row[2],
session_id=row[3]
)

Now, how to run this script?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/django-users/137aee79-07e6-40e1-badd-671ae3b0c87cn%40googlegroups.com

.