The error says you have 2 records with same value in the column "title".
On Thu, Jun 20, 2013 at 12:56 PM, peibol <[email protected]> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
