account_statement_base_import : permission denied on windows

[Alexandre Fayolle - camptocamp]

Hi:

I installed account_statement_base_import and xlrd Python module and when I try to upload the sample xls I get the error

IOError: [Errno 13] Permission denied: 'c:\\windows\\temp\\tmpmldz22'

Versión 7.0-20130721-231032
Windows 7

Thanks!

Mayte

[Alexandre Fayolle - camptocamp (alexandre-fayolle-c2c)]

Hello

We need more information on this :

1. can you post the full stack for the crash?

2. is there w c:\windows\temp directory on your computer?

Thanks

[Mayte Montano (mayte-l)]

Hi:

1.- Full stack:
Server Traceback (most recent call last):
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\web\session.py", line 89, in send
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\netsvc.py", line 292, in dispatch_rpc
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\service\web_services.py", line 626, in dispatch
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\osv\osv.py", line 188, in execute_kw
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\osv\osv.py", line 131, in wrapper
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\osv\osv.py", line 197, in execute
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\.\openerp\osv\osv.py", line 185, in execute_cr
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\account_statement_base_import\wizard\import_statement.py", line 109, in import_statement
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\account_statement_base_import\statement.py", line 168, in statement_import
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\account_statement_base_import\parser\parser.py", line 166, in parse
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\account_statement_base_import\parser\file_parser.py", line 94, in _parse
  File "C:\Program Files\OpenERP 7.0-20130721-231032\Server\server\openerp\addons\account_statement_base_import\parser\file_parser.py", line 129, in _parse_csv
IOError: [Errno 13] Permission denied: 'c:\\windows\\temp\\tmpsok2db'

2.- Yes there is a C:\Windows\Temp in the computer

Thanks!

Mayte

[Mayte Montano (mayte-l)]

Hello:

I manage to upload a csv file using the following code:

    def _parse_csv(self):
        """
        :return: list of dict from csv file (line/rows)
        """
        csv_file = tempfile.TemporaryFile('w+')
        csv_file.write(self.filebuffer)
        csv_file.seek(0) # this will send you to the beginning of the file
        reader = UnicodeDictReader(csv_file , fieldnames=self.fieldnames)
        return list(reader)

Can't do the same with xls as file is open inside xlrd.open_workbook method.

Hope this help.

Mayte