OpenERP 6.1 - Export of users data fails

[Kenneth Andresen]

Server: OpenERP 6.1 (OpenERP Server 6.1-20120325-233047)

1) setup clean system and install a module such as Sales or Warehouse as admin
2) go to Settings -> Users -> Users
3) go to Other Options -> Export
4) Add all fields and select "Export to File"

You will never get a file to download.
The web interface will indicate it is working for some time, then disappear whereas the page will load forever.

In the server log you will see a Error message similar to this:
ERROR:openerp.netsvc:Field 'sel_groups_13_14_15' does not exist in object 'browse_record(res.users, 1)'

The above error is assuming the you attempted to export "Accounting & Finance".

Fields that cause similar errors on export:
Accounting & Finance
Administration
Analytic Accounting
Extended View
Human Resources
Knowledge Management
Multi Companies
Partner Manager
Product UoS View
Product Variant
Purchase Management
Sales Management
Technical Features
Warehouse Management

[Kenneth Andresen (kandresen)]

I did before submitting this bug also test on http://6_1_6522.runbot.openerp.com:9410 using database 6_1_6522_all

The Export fails the same way there, so it has not been fixed in any recent build.

[Kenneth Andresen (kandresen)]

Notice, I had the following modules installed when trying to export:

Name Category/Name Installed version State
account_accountant Accounting & Finance 6.1.1.1 Installed
sale Sales Management 6.1.1.0 Installed
stock Warehouse Management 6.1.1.1 Installed
purchase Purchase Management 6.1.1.1 Installed
account Accounting & Finance 6.1.1.1 Installed
document Knowledge Management 6.1.2.1 Installed
edi Tools 6.1.1.0 Installed
email_template Marketing 6.1.1.1 Installed
product Sales Management 6.1.1.1 Installed
web_process Uncategorized 6.1.2.0 Installed

Assuming other modules add elements to user export, those will likely fail the same way.

[Lucas P (lucas33-3)]

I wrote some explanation about this bug and a temporary workaround on the forum:
http://www.openerp.com/forum/topic32293.html?uid=46155&sid=3fb06f44c5d746a8692e09afffcbd8bb

[Ray Carnes (rcarnes)]

We have been given the following patch, which works for us:

=== modified file 'openerp/osv/orm.py'
--- openerp/osv/orm.py 2012-08-26 20:26:55 +0000
+++ openerp/osv/orm.py 2012-08-28 11:38:10 +0000
@@ -1124,7 +1124,10 @@
                     elif f[i] == 'id':
                         r = _get_xml_id(self, cr, uid, r)
                     else:
- r = r[f[i]]
+ if f[i].startswith('in_group_') or f[i].startswith('in_groups_') or f[i].startswith('sel_groups_'):
+ r = self.read(cr, uid, row.id, [f[i]], context)[f[i]]
+ else:
+ r = r[f[i]]
                         # To display external name of selection field when its exported
                         if f[i] in self._columns.keys():
                             cols = self._columns[f[i]]

[Kenneth Andresen (kandresen)]

Thanks for the patch! I have tested it and it is working fine for me!

[Martin Bramwell (martinhbramwell)]

I have adapted this patch for use with OpenERP V7 and posted it here.

However it is NOT a real answer to this bug.

Further discussion here : http://help.openerp.com/question/12789/whats-the-correct-way-to-access-technical-features/

[Martin Bramwell (martinhbramwell)]

View the patch here: https://gist.github.com/martinhbramwell/5443701