I have to ask, just to be sure:
Opening the csv file with an editor (or MS Excel). Is it fine, containing
all data, not empty? Does the export works correctly?
And a second question:
Where is the csv stored? Is it really in the same location as the web2py.py
file? If not you have use the full path to the csv file and not only the
filename?
Regards
Clemens
On Wednesday, November 25, 2020 at 9:14:30 PM UTC+1 gaelpri...@gmail.com
wrote:
> Thank you Clemens.
>
> I'm using Python2.
> I was thinking about moving from PosgreSQL to MariaDB becuse the
> 'import_from_csv_file' don't works.
> I was thinking that is was a Psycog2 library problem, but it's the same
> with mariaDB.
>
> Now I have a MariaDB DB, and for achieving your suggestions I must use
> import_from_csv_file.
> And it don't works, there's not any error.
>
> [user@server web2py7]$ source env/bin/activate
> (env) [user@server web2py7]$ cd web2py
> (env) [user@server web2py]$ python web2py.py -S myapp -M -P
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2020
> Version 2.20.4-stable+timestamp.2020.05.03.05.18.50
> Database drivers available: sqlite3, psycopg2, pyodbc, pymysql, imaplib
> Python 2.7.16 (default, Nov 1 2020, 19:29:00)
> [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
> >>> filename = 'myfile.csv'
> >>> db.import_from_csv_file(open(filename, 'rb')); db.commit()
>
> After that there's no feedback and the DB still empty.
>
> What could affect like that the import_from_csv_file function?
> Il giorno mercoledì 25 novembre 2020 alle 20:29:00 UTC+1 Clemens ha
> scritto:
>
>> I'm using the csv export in a simple controller, thus the user (admin)
>> can have a db backup on one click:
>> (the path and filename in my app is dynamic and not fixed as follows,
>> simplified for better understanding)
>> if sys.version_info[0] == 2:
>> db.export_to_csv_file(open('<path_to_your_backup>/<filename>.csv',
>> 'wb'))
>> else:
>> db.export_to_csv_file(open('<path_to_your_backup>/<filename>.csv',
>> 'w', encoding='utf-8', newline=''))
>>
>> To recover a database I'm using the console as follows:
>> python <your_path_to_web2py>/web2py/web2py.py -S
>> <your_application_by_name> -M -P
>> >>> filename = '<path_to_your_backup>/<filename>.csv'
>> >>> db.import_from_csv_file(open(str(filename), 'r', encoding='utf-8'));
>> db.commit()
>> or for python2
>> >>> db.import_from_csv_file(open(filename, 'rb')); db.commit()
>>
>> Regards
>> Clemens
>>
>>
>>
>>
>> On Wednesday, November 25, 2020 at 6:53:45 PM UTC+1 gaelpri...@gmail.com
>> wrote:
>>
>>> Hello.
>>>
>>> After the migration from Webfaction to Opalstack I'm still having some
>>> troubles with PostgreSQL.
>>> In a first time I was unable to run he scheduler workers, but now
>>> installing the Psycog2 library like that this problem is resolved.
>>> pip2 install uwsgi psycopg2-binary http://effbot.org/downloads/
>>> Imaging-1.1.7.tar.gz
>>>
>>> My scheduler tasks import in tables some csv files.
>>> Depending of the functions I have:
>>> No errors, but the tables still empty.
>>> This ticket: <class '_csv.Error'> line contains NULL byte
>>>
>>> That's quite difficult to understand where's the problem.
>>>
>>> I was thinking to clone the PostgreSQL db to a MariaDB one.
>>>
>>> How can I do that?
>>>
>>> Thanks.
>>>
>>
--
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/a8d125d9-fc04-4af1-b00c-252a7a0e9ee0n%40googlegroups.com.
