Thanks El jueves, 20 de junio de 2013 18:22:47 UTC+2, viniciusban escribió: > > The error says you have 2 records with same value in the column "title". > > On Thu, Jun 20, 2013 at 12:56 PM, peibol <pab...@gmail.com <javascript:>> > wrote: > > No, I don't think there are two columns labelled 'title'. > > I attach the csv... > > Thanks for your interest > > > > El miércoles, 19 de junio de 2013 17:55:27 UTC+2, Christian Foster Howes > > escribió: > >> > >> check your CSV file - that error looks to me like there are 2 columns > >> with the name "title" and therefore the DB does not know what data to > >> store where. > >> > >> On 6/19/13 8:38 , peibol wrote: > >> > Here is what I get: > >> > > >> > > >> > Error ticket for "myeducenter"Ticket ID > >> > > >> > 127.0.0.1.2013-06-19.17-34-43.e551a8f8-a45b-4b22-9e22-e76381dc5977 > >> > <class 'sqlite3.IntegrityError'> column title is not > >> > uniqueVersi�nweb2py�Version > >> > 2.5.1-stable+timestamp.2013.06.11.08.00.05PythonPython 2.7.5: > >> > c:\Python27\python.exe (prefix: c:\Python27)Traceback > >> > > >> > 1. > >> > 2. > >> > 3. > >> > 4. > >> > 5. > >> > 6. > >> > 7. > >> > 8. > >> > 9. > >> > 10. > >> > 11. > >> > 12. > >> > 13. > >> > 14. > >> > 15. > >> > 16. > >> > 17. > >> > 18. > >> > > >> > Traceback (most recent call last): > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\restricted.py", > >> > line 212, in restricted > >> > exec ccode in environment > >> > File "E:/My > >> > > Dropbox/myWebs/MyApps/myeduapps/applications/myeducenter/controllers/default.py" > > > >> > < > http://127.0.0.1:8083/admin/default/edit/myeducenter/controllers/default.py>, > > >> > line 116, in <module> > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\globals.py", > line > >> > 194, in <lambda> > >> > self._caller = lambda f: f() > >> > File "E:/My > >> > > Dropbox/myWebs/MyApps/myeduapps/applications/myeducenter/controllers/default.py" > > > >> > < > http://127.0.0.1:8083/admin/default/edit/myeducenter/controllers/default.py>, > > >> > line 97, in import_and_sync > >> > db.import_from_csv_file(form.vars.data.file,unique=False) > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\dal.py", line > 8046, > >> > in import_from_csv_file > >> > *args, **kwargs) > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\dal.py", line > 8737, > >> > in import_from_csv_file > >> > curr_id = self.insert(**dict(items)) > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\dal.py", line > 8579, > >> > in insert > >> > ret = self._db._adapter.insert(self, self._listify(fields)) > >> > File "E:\My Dropbox\myWebs\MyApps\myeduapps\gluon\dal.py", line > 1210, > >> > in insert > >> > raise e > >> > IntegrityError: column title is not unique > >> > > >> > > >> > > >> > El mi�rcoles, 19 de junio de 2013 17:31:49 UTC+2, Christian Foster > >> > Howes > >> > escribi�: > >> >> > >> >> I haven't used that code in a long time as my tables are too big. :( > >> >> > >> >> what's the traceback that you get? > >> >> > >> >> On 6/19/13 7:23 , peibol wrote: > >> >>> Bigtable. I don't have any other models but the standard auth ones > and > >> >> the > >> >>> builtin wiki ones and I'm using this code (just the one stated in > the > >> >> book): > >> >>> > >> >>> def import_and_sync(): > >> >>> form = FORM(INPUT(_type='file', _name='data'), > >> >> INPUT(_type='submit')) > >> >>> if form.process().accepted: > >> >>> db.import_from_csv_file(form.vars.data.file,unique=False) > >> >>> # for every table > >> >>> for table in db.tables: > >> >>> # for every uuid, delete all but the latest > >> >>> items = db(db[table]).select(db[table].id, > >> >>> db[table].uuid, > >> >>> orderby=db[table].modified_on, > >> >>> groupby=db[table].uuid) > >> >>> for item in items: > >> >>> > >> >>> db((db[table].uuid==item.uuid)&(db[table].id!=item.id)).delete() > >> >>> return dict(form=form) > >> >>> > >> >>> > >> >>> def export(): > >> >>> s = cStringIO.StringIO() > >> >>> db.export_to_csv_file(s) > >> >>> response.headers['Content-Type'] = 'text/csv' > >> >>> return s.getvalue() > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> El mi�rcoles, 19 de junio de 2013 15:14:57 UTC+2, Christian > Foster > >> >> Howes > >> >>> escribi�: > >> >>>> > >> >>>> Are you using BigTable or Google Cloud SQL for data storage? i'm > >> >>>> surprised that import to BigTable would give an integrity error. > >> >>>> > >> >>>> note that if you are import/export as a controller you will be > >> >>>> limited > >> >>>> by what you can do in 128MB of ram and 60 seconds of processing > >> >>>> unless > >> >>>> you use larger instance classes and/or backend instances. > >> >>>> > >> >>>> cfh > >> >>>> > >> >>>> On 6/19/13 4:05 , peibol wrote: > >> >>>>> Thanks Cristian. What I'm considering is use a export/import > >> >>>>> function > >> >> in > >> >>>>> the app, only visible to the administrator. Because I want to > >> >>>>> develop > >> >> a > >> >>>>> kind of wiki, with its content, on local. So I'll use > >> >> export_to_csv_file > >> >>>>> and import_from_csv_file. > >> >>>>> > >> >>>>> The export process is working for me right now, but the import > >> >>>>> process > >> >>>>> gives an integrity error. > >> >>>>> > >> >>>>> Reading the book, it must be some issue with the uuids... > >> >>>>> > >> >>>>> > >> >>>>> > >> >>>>> El mi�rcoles, 19 de junio de 2013 07:28:02 UTC+2, Christian > Foster > >> >>>> Howes > >> >>>>> escribi�: > >> >>>>>> > >> >>>>>> i wouldn't copy data personally, i consider localhost a test > >> >>>> environment, > >> >>>>>> and GAE proper production and i just make my production data > there. > >> >>>>>> > >> >>>>>> if you do want to copy data look at the GAE bulk loader: > >> >>>>>> > >> >> > https://developers.google.com/appengine/docs/python/tools/uploadingdata > >> >>>>> > >> >>>> > >> >>> > >> >> > >> > > > > > -- > > > > --- > > 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 web2py+un...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > >
-- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
