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.
