search

chemmalion / EIDBEditor

Evil Islands database editor.
MIT License
10 stars 0 forks source link

Codepage issues #3

Closed burner1024 closed 5 years ago

burner1024 commented 6 years ago

I can't figure out correct codepage settings for generated xlsx files. Should be cp1251, right? Both LibreOffice and Gnumeric show garbage: captura de pantalla de 2018-03-22 13-39-23

koteyur commented 6 years ago

What did you do? On your screenshot I see zip signature, so it looks very strange. It isn't a codepage issue, but file format recognition error. I tried to open generated file in Calc and it works fine.

burner1024 commented 6 years ago

Just load res and then save to xlsx. So this is zip... actually xlsx is supposed to have zip signature, isn't it?

koteyur commented 6 years ago

You're right, but I meant a little different. On the screenshot I see the libreoffice tried to open xlsx (zip) as raw data and ask you about encoding. It's pointless. So I think it's not recognize a format.

May you try to just drag&drop database.res to dbeditor.exe?

burner1024 commented 6 years ago

No, I didn't drag and drop. I've tried uploading to google drive, though, and sheets open the file just fine. So it must be some local issue. I'll try to get down to this.

burner1024 commented 5 years ago

Returning to this, still not able to resolve. Both Libreoffice and Gnumeric refuse to recognize the format generate by EIDBEditor (example: database_not_working.xlsx) But once the same file is uploaded to Google Sheets and then downloaded back in xlsx format, it's working just fine (see database_working.xlsx)

Maybe something about updating the relevant library?

koteyur commented 5 years ago

What version of LibreOffice did you try? LO 6.2.1 works fine with xlsx generated by EIDBEditor.

burner1024 commented 5 years ago

I used 6.0.7.3, now upgraded to 6.2.1.2 - no difference.

chemmalion commented 5 years ago

Hello and welcome, burner1024. In other issues you have said you're running under Wine. There is no ".rels" file in the problem database "database_not_working.xlsx". When I append it manually (unpack->append->pack) the database becomes valid. The problem file ".rels" name starts with a dot. A dot is an attribute for hidden files in Linux. So I can suppose the QtZipWriter can't find hidden files while temporary directory iteration.

Maybe it is Wine configuration. Try to enable show hidden files in Wine: (from google):

In the Wine configuration window (winecfg), under the Drives tab, there's a checkbox for "Show dot files"

I have not tested this trick yet.

burner1024 commented 5 years ago

Hmm I was 99.99% sure that wouldn't work... showing files and accessing them are two absolutely different things. But it actually did. At least the file opens. Thanks, @chemmalion.

Anyway, I'm thinking about building a native version. Do I understand correctly that this requires QT4? Any plans to upgrade to 5?

chemmalion commented 5 years ago

I think it is a QtZipWriter feature :)

You are right. You need Qt4-dev package. You can try to install it in your system using package manager. Note you need a development package version (-dev). Or you can download it manually.

This project has very low quality of coding. It is pain to make big changes on it. It is more concise to make new project from scratch, maybe just converter (xlsx<->res or ods<->res) using more affordable programming language for novices. Maybe using just Python :) It should include autotesting to prevent new regression bugs while fixing other bugs.

burner1024 commented 5 years ago

A simple converter probably wouldn't be too hard to write, but for now I don't see a pressing need. It'd be great to allow a format that has some support for source control, not sure if that's an option with multi-sheet table data. For the time being, I'm using a hook to export into csv - still better than nothing.