İçereği Atla
Bu soru işaretlendi
export7.0
1 Cevapla
6438 Görünümler
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
Vazgeç
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
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
sales export problem
export sale 7.0
Avatar
Avatar
1
Mar 15
4542
exporteren
export
Avatar
Avatar
1
Tem 25
2555
How can I list/export more than 80 items? Çözüldü
export
Avatar
Avatar
Avatar
3
Şub 25
16164
Export data organisations, contactperson, deals
export
Avatar
Avatar
1
Nis 25
2752
Export Import Çözüldü
export
Avatar
Avatar
1
Nis 25
2883