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.
