It's working do I need to do every time db.Questions.drop() in shell ????????
On Thu, Aug 6, 2015 at 7:16 PM, Selman Kocael <[email protected]> wrote: > 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 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.
