@Denes, I know referential integrity would not result, but I just wanted to
get a lot o f the lookup tables transferred to the the db
@Anthony, yes that would be by far the best solution but when tried, I
couldn't find which files were causing the error.
web2py Shell 2.9.5-stable+timestamp.2014.03.16.02.35.39
In [1] : db.import_from_csv_file(open('somefile.csv', 'rb'))
Traceback (most recent call last):
File "/home/alexglaros/web2py/gluon/contrib/shell.py", line 234, in run
exec compiled in statement_module.__dict__
File "<string>", line 1, in <module>
File "/home/alexglaros/web2py/gluon/dal.py", line 8519, in
import_from_csv_file
*args, **kwargs)
File "/home/alexglaros/web2py/gluon/dal.py", line 9345, in
import_from_csv_file
curr_id = self.insert(**dict(items))
File "/home/alexglaros/web2py/gluon/dal.py", line 9114, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File "/home/alexglaros/web2py/gluon/dal.py", line 1360, in insert
raise e
DataError: value too long for type character varying(512)
--
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.
