been looking around some more. turns out this is a duplicate of this open
item - https://github.com/web2py/web2py/issues/2013
Have looked more closely at the 3.x docs for csv and open as well as the
code for export_to_csv_file in pydal.
- the csv docs say 'w' only as Leonel suggested (not surprising), and say
to specify "newline = ''.
- adding the encoding as suggested by Dave results in
with open(session.db_backup_name, 'w', encoding='utf-8', newline='')
as backup_file:
which results in - SUCCESS at least so it seems. The claim is that the
backup is successful. I haven't yet tried to restore the saved backup
On Friday, March 1, 2019 at 1:41:25 PM UTC-8, Dave S wrote:
>
>
>
> On Friday, March 1, 2019 at 12:43:21 PM UTC-8, jim kaubisch wrote:
>>
>> Thanks, Leonel,
>>
>> In a different app (not web2py) I hit this issue pickle and the change
>> you suggest solved the problem
>> Unfortunately, in the web2py and db.export_to_csv_file context, when I
>> make the change you suggest, the error message just changes to
>>
>> 01/Mar/2019-12:32:27: INFO : backups : 303 | backing
>> db up as
>> "applications/MFMCurrAssetMgr/private/_backups/bup_010319_123226/MFMCurrAssetMgr-db.csv"
>> 01/Mar/2019-12:32:27: WARNING : backups : 309 | - db backup
>> Failed: exception: "'ascii' codec can't encode character '\u2019' in
>> position 12: ordinal not in range(128)"
>>
>
>
> You probably need to specify an encoding in the open(), look at
> <URL:https://docs.python.org/3/library/functions.html#open>
>
> (which is also where the 'wb' -> 'w' is really explained)
>
> /dps
>
>
>>
>> On Friday, March 1, 2019 at 11:43:26 AM UTC-8, Leonel Câmara wrote:
>>>
>>> You actually have to open it using only 'w' instead of 'wb' in python 3
>>> so change it to:
>>>
>>> with open(session.db_backup_name, 'w', newline=''):
>>>
>>> See:
>>> https://docs.python.org/3/library/csv.html?highlight=csv#csv.writer
>>>
>>>
>>>
--
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.
