Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
export7.0
1 Odpovědět
6428 Zobrazení
Avatar
Vandermolt Jean-Claude

Hi,

Since the fix of the bug 1193563 (see bugs.launchpad)

It remains impossible to export any data from openerp V7.0 (5 october version).

After creating some customers (same bug with article, ...) and trying to export any data (name, address, bank account, whatsoever data field), nothing seems to happens. I think it can be related to this bug: openerp-web/+bug/1202154

Here is the messages I obtains in the console of Firefox 24: ` [20:23:39.387] POST IP:8069/web/export/xls [HTTP/1.0 200 OK 284ms] [20:23:39.433] [Exception... "Async version must be used" nsresult: "0x80040111 (NS_ERROR_NOT_AVAILABLE)" location: "JS frame :: resource://gre/components/nsHelperAppDlg.js :: <top_level> :: line 190" data: no] @

resource://gre/components/nsHelperAppDlg.js:190

[20:23:50.682] can't access dead object @ resource://gre/modules/DownloadLastDir.jsm:168 [20:23:50.682] [Exception... "'[JavaScript Error: "can't access dead object" {file: "resource://gre/modules/DownloadLastDir.jsm" line: 168}]' when calling method: [nsIContentPrefCallback2::handleCompletion]" nsresult: "0x80570021 (NS_ERROR_XPC_JAVASCRIPT_ERROR_WITH_DETAILS)" location: "JS frame :: resource://gre/modules/ContentPrefService2.jsm :: safeCallback :: line 797" data: yes] @ resource://gre/modules/ContentPrefService2.jsm:800 `

The log of Openerp remains silent. Even with the options: ./openerp-server --logfile=/var/log/openerp-server.log --log-handler=werkzeug:DEBUG --log-handler=openerp.orm:DEBUG

I tried it with two version of python werkzeug (8.3 and 9.1) and I obtain the same result. Does anybody knows how to avoid this export bug?

Thanks

Jean-Claude Vandermolt

Avatar
Zrušit
Mahmoud Naguib

Please try to backup the database from the old version and install the new version , restore the database and try to update the modules.

vandermolt

Unfortunately, I need the export capabilities in order to create a new database. I have some data coming from a home-made solution and I need to export some 'test data' in order to give Openerp to the 'good data' some values as it's expecting it (tables links etc).

Avatar
vandermolt
Nejlepší odpověď

Finally, I managed to avoid the bug by exporting the data in another csv file, before the web export:

file openerp/addons/web/controllers/main.py
```
openerp/addons/web/controllers/

--- main.py-old 2013-10-13 12:11:17.761159074 +0200
+++ main.py 2013-10-13 12:10:36.057178027 +0200
@@ -1643,9 +1643,10 @@
def from_data(self, fields, rows):
fp = StringIO()

writer = csv.writer(fp, quoting=csv.QUOTE_ALL)

  • ofile = open('test.csv', "wb")

  • test = csv.writer(ofile, delimiter=';')

    writer.writerow([name.encode('utf-8') for name in fields])

  • test.writerow([name.encode('utf-8') for name in fields])
    for data in rows:
    row = []
    for d in data:
    @@ -1658,10 +1659,11 @@
    if d is False: d = None
    row.append(d)

    writer.writerow(row)

  • test.writerow(row)
    fp.seek(0)
    data = fp.read()
    fp.close()

  • ofile.close()
    return data

```
This write the data in a file called test.csv placed in /opt/openerp in my case. It's not perfect but it's working.

Sorry for the formatting, markdown is not helping for diff writing.

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
sales export problem
export sale 7.0
Avatar
Avatar
1
bře 15
4540
exporteren
export
Avatar
Avatar
1
čvc 25
2549
How can I list/export more than 80 items? Vyřešeno
export
Avatar
Avatar
Avatar
3
úno 25
16153
Export data organisations, contactperson, deals
export
Avatar
Avatar
1
dub 25
2744
Export Import Vyřešeno
export
Avatar
Avatar
1
dub 25
2870