1. delete notnull=True,unique=True in models. 2. in shell write: db.Questions.drop() and enter. 3. import csv file.
2015-08-06 16:21 GMT+03:00 Sai Harsh Tondomker <[email protected]>: > I have did same thing which you have shown me in video it show the error > message > unable to parse csv file > "UNIQUE constraint failed: Questions.quesno" > > What I need to do for these. > Please help me to solve the problem. > Waiting for your response. > > On Tue, Aug 4, 2015 at 9:31 AM, Sai Harsh Tondomker <[email protected] > > wrote: > >> Thanks a lot man that video is very helpful. >> Could you do last favor, I want to add more question types for now it's >> only multiple options. >> Could you say how can I ass true or false type ? Like if answer is true >> or false display true/ false type else multiple answer type question. >> >> On Mon, Aug 3, 2015 at 11:39 PM, Selman Kocael <[email protected]> >> wrote: >> >>> you must delete"notnull=True,unique=True". >>> >>> 2015-08-03 10:32 GMT+03:00 Sai Harsh Tondomker <[email protected]>: >>> >>>> How it will store the data. We need to give pattern to csv file right. >>>> Please could you give one csv file for my data base >>>> >>>> On Mon, Aug 3, 2015 at 12:16 PM, Selman Kocael <[email protected]> >>>> wrote: >>>> >>>>> you can also import csv file with code. but i have not try it. >>>>> >>>>> >>>>> 2015-08-03 8:55 GMT+03:00 Sai Harsh Tondomker <[email protected]>: >>>>> >>>>>> No need to write code to store in db. >>>>>> >>>>>> On Mon, Aug 3, 2015 at 11:07 AM, Selman Kocael <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> simple way: >>>>>>> >>>>>>> in http://127.0.0.1:8000/[your-app-name]/appadmin/select/db?query=db >>>>>>> .Questions.id%3E0 page: >>>>>>> browse your csv file and click import csv button. >>>>>>> >>>>>>> >>>>>>> if an error displayed, you must edit yoru csv file. >>>>>>> >>>>>>> 2015-08-03 8:28 GMT+03:00 Sai Harsh Tondomker <[email protected] >>>>>>> >: >>>>>>> >>>>>>>> Here is my db.py >>>>>>>> db.define_table("Questions", >>>>>>>> Field('quesno','integer',notnull=True,unique=True), >>>>>>>> Field('question', 'text'), >>>>>>>> Field('qupload','upload',label='Upload Image'), >>>>>>>> Field('optionA', 'string'), >>>>>>>> Field('optionB', 'string'), >>>>>>>> Field('optionC', 'string'), >>>>>>>> Field('optionD', 'string'), >>>>>>>> Field('True1', 'string'), >>>>>>>> Field('False0', 'string'), >>>>>>>> Field('answer', 'string'), >>>>>>>> ) >>>>>>>> >>>>>>>> Were and how to right the code to store data from .csv or .xml in >>>>>>>> data base I am struggling for it please help me to solve the problem. >>>>>>>> >>>>>>>> -- >>>>>>>> Resources: >>>>>>>> - http://web2py.com >>>>>>>> - http://web2py.com/book (Documentation) >>>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "web2py-users" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>> send an email to [email protected]. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Selman Kocael >>>>>>> İsabet Yayınları >>>>>>> >>>>>>> -- >>>>>>> Resources: >>>>>>> - http://web2py.com >>>>>>> - http://web2py.com/book (Documentation) >>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>> --- >>>>>>> You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "web2py-users" group. >>>>>>> To unsubscribe from this topic, visit >>>>>>> https://groups.google.com/d/topic/web2py/d38qTLOsOnE/unsubscribe. >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> [email protected]. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>>> Resources: >>>>>> - http://web2py.com >>>>>> - http://web2py.com/book (Documentation) >>>>>> - http://github.com/web2py/web2py (Source code) >>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "web2py-users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Selman Kocael >>>>> İsabet Yayınları >>>>> >>>>> -- >>>>> Resources: >>>>> - http://web2py.com >>>>> - http://web2py.com/book (Documentation) >>>>> - http://github.com/web2py/web2py (Source code) >>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/web2py/d38qTLOsOnE/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Selman Kocael >>> İsabet Yayınları >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/web2py/d38qTLOsOnE/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Selman Kocael İsabet Yayınları -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
