no. i don't know its reason, if you edit a table (ie. to delete a validator), it doesn't edit table in sqlite. you must delete the table for one time.
2015-08-06 16:49 GMT+03:00 Sai Harsh Tondomker <[email protected]>: > 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. > -- 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.
