Cannot import from CSV file

[Phyo Arkar]

Hello all;

Any one tried importing from CSV file?

I got the error unable to parse but when i try it directly via csv module in normal python it parses well.

[mdipierro]

Do you have the first row with the column names?

[Phyo Arkar]

Thanks! its ok now

[somebody]

hi are u creating a new module/controller which allow you to export
SQL table value and save them as text file? I know that web2py has
build in CSV but i want to create a new controller which allow you to
export choosenSQL table value and save them as text file?

can you help?
thanks

[mmstud]

Was it only column names? I tried to import csv file, got parse errors
althought i had column names... Finally i got tired of trying to
import with web2py and did import data with Navicat. Same csv file and
it worked well. But now my character encodings are wrong...

Actually i did one test, where i tried to put only column names plus
one line / row with corresponding empty values (,,,,,,,,) to csv file
and it was imported well. As said navicat understood file without
problems and i could find any errors or false amount of commas from
csv file neither.

-Marko

On Nov 5, 9:54 pm, "Phyo Arkar" <phyo.arkarl...@gmail.com> wrote:
> Thanks! its ok now
>

> On Wed, Nov 5, 2008 at 4:03 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > Do you have the first row with the column names?
>
> > On Nov 5, 6:50 am, "Phyo Arkar" <phyo.arkarl...@gmail.com> wrote:

> > > Hello all;Was

[voltron]

I am still having problems with CSV import just like the poster of
this thread. All the colum headers are ok, and the file imports well
usíng SQLite manager, Sqliteman , MS Excel and other tools. Is there
anyone that has had some success?


Thanks

[mdipierro]

Can I see the model and the file?

Massimo