How to Insert multiple data in django to django form?

Question

I want to insert multiple row into my database from form2. Below are my codes

first model.py

class DataPribadiSiswa(models.Model):
   SiswaID = models.AutoField(primary_key=True)
   WaliKelasID=models.CharField(max_length=5,blank=True,null=True)

second model.py

class RiwayatSekolah(models.Model):
   SekolahID=models.AutoField(primary_key=True)
   SiswaID_FK=models.ForeignKey(DataPribadiSiswa,blank=True, null=True)
   SekolahNama=models.CharField(max_length=50,blank=True,null=True)
   SekolahThMasuk=models.CharField(max_length=4,blank=True,null=True)
   SekolahThKeluar=models.CharField(max_length=4,blank=True,null=True)
   SekolahKet=models.TextField(blank=True,null=True)

views.py

def tambah_siswa(request):
   form = datasiswa(request.POST)
   form2 = riwayatsekolah(request.POST)
   FormSet2 = inlineformset_factory(DataPribadiSiswa, RiwayatSekolah, extra=2, fields=('SekolahID','SiswaID_FK','SekolahNama','SekolahThMasuk','SekolahThKeluar','SekolahKet'))
   if request.method == 'POST':
       if form.is_valid():
           siswa_instance = form.save()
           form2 = FormSet2(request.POST, instance=siswa_instance)
           if form2.is_valid():
               form2.save()
           return redirect('index')
   else:
       formall={}
       formall['form'] = datasiswa()
       formall['form2'] = riwayatsekolah()
   return render(request, 'siswa/tambah_siswa.html', formall)

and this is my template

<form action="" method="post">
{% csrf_token %}
<table >
    {{ form2.management_form }}
    {{ form2.as_table }}
</table>
</form>

How to insert multiple row from form2 into database? when i run this code, it just insert one row.

you can create object of model which is mapped with you form2 and put the field from form2.cleaned_data['field'] and saved the object. — Vivek
– Vivek, Commented Nov 30, 2016 at 2:43
modelobject.field = form2.cleaned_data['field'] and finally modelobject.save() — Vivek
– Vivek, Commented Nov 30, 2016 at 2:55
is field from form2.cleaned_data['field'] name from html code or field name from model? — Gusan
– Gusan, Commented Nov 30, 2016 at 3:19

neverwalkaloner · Accepted Answer · 2016-12-02 04:17:47Z

1

To simplify working with related objects you can use Inline formsets

You can implement it this way:

from django.forms import inlineformset_factory
FormSet2 = inlineformset_factory(DataPribadiSiswa, RiwayatSekolah, extra=2)

Now in view try this:

def tambah_siswa(request):
    form = datasiswa(request.POST or None)
    FormSet2 = inlineformset_factory(DataPribadiSiswa, RiwayatSekolah, extra=2, fields=('SekolahID','SiswaID_FK','SekolahNama','SekolahThMasuk','SekolahThKeluar','SekolahKet'))
    if request.method == 'POST':
        if form.is_valid():
            siswa_instance = form.save()
            form2 = FormSet2(request.POST or None, instance=siswa_instance) 
            if form2.is_valid():
                form2.save()
            return redirect('index')
    form2 = FormSet2(request.POST or None) 
    formall={}
    formall['form'] = form
    formall['form2'] = form2
    return render(request, 'siswa/tambah_siswa.html', formall)

And in template:

{{ form2.management_form }}
{{ form2.as_table }}

or

{{ form2.management_form }}    
{% for frm in form2 %}
    {{ frm.as_table }}
{% endfor %}

edited Dec 2, 2016 at 4:17

answered Nov 30, 2016 at 4:04

neverwalkaloner

47.6k7 gold badges101 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

neverwalkaloner Over a year ago

@Gusan can you show models, view and template code?

Gusan Over a year ago

When i run it i get this error Calling modelformset_factory without defining 'fields' or 'exclude' explicitly is prohibited, after i change like this

FormSet2 = inlineformset_factory(DataPribadiSiswa, RiwayatSekolah, extra=2, fields=('SekolahID','SiswaID_FK','SekolahNama','SekolahThMasuk','SekolahThKeluar','SekolahKet'))

and click input button i get this error [u'ManagementForm data is missing or has been tampered with']

neverwalkaloner Over a year ago

@Gusan try to add {{ form2.management_form }} before {{ form2.as_table }} in template.

Gusan Over a year ago

still not working @neverwalkaloner, i still get the same error [u'ManagementForm data is missing or has been tampered with']

neverwalkaloner Over a year ago

@Gusan did you add {% csrf_token %} before {{ form2.management_form }}? BTW please show template code with formset added.

|

Collectives™ on Stack Overflow

How to Insert multiple data in django to django form?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related