Because if appadmin were to give a ticket people would interpret this
as a web2py (appamdin) bug.
If you call
db.youtable.import_from_csv_file(open(....,'rb'))
and it fails, this will give you a ticket.
Massimo
On Apr 7, 1:19 pm, fredg <fred.galu...@gmail.com> wrote:
> > What error do you get?
>
> I don' t have any ticket just the red warning.
> Is there a log file where I can find something useful for you ?
>
> > Here are some other possible causes of errors:
> > - There are column names that do have a corresponding field in the
> > table
> > - field types do not match
> > - you have dates NOT in ISO format
> > - you have special characters in the strings (I see you have a "ê").
> > Strings must be UTF8 to be imported.
>
> I have changed string to text, remove special characters from desc.
> (stup** frenchies :P), remove the not null condition, no dates.
> Here is the new db .py
> <code>
> #!/usr/bin/python
> # -*- coding: utf-8 -*-
>
> db = SQLDB('sqlite://bddpackages.db')
>
> ## Table des Packages
> db.define_table("packages",
> SQLField("nom","text",length=32,notnull=True,default=""),
> SQLField("description","text",length=128,default=""),
> SQLField("url","text",length=64,default=""),
> SQLField("packager","text",length=64,default=""),
> SQLField("categorie","text",length=32,default=""))
> </code>
>
> The new CSV file looks like that :
> packages.nom,packages.description,packages.url,packages.packager,packages.categorie
> "AfterStep","desc","http://www.afterstep.org/","geanbrun","cat";
> "ICU","desc","http://www.icu-project.org/","","cat";
> "LibVNCServer","desc","http://
> libvncserver.sourceforge.net/","floreal.c at orange dot fr","cat"
> "MesaLib","desc","http://mesa3d.sourceforge.net","Thierry Nuttens,
> thierryn1 at hispeed dot ch","cat"
> ..
> ..
>
> I 've got the same warning "unable to parse CSV file", but this time
> only 51 packages were added to the db.
> I will check line by line if there is a special character
> somewhere ...
>
> Best regards.
>
> ++ fredg
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
