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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
