Page 1 of 1

Problem with Custom Reports after upgrading to Win 8.1 Pro

Posted: Mon Jul 07, 2014 12:36 pm
by dimidimi
Hi everyone!

I have been using RC2 (64bit Portable) since it became available and in the mean time I upgraded from Windows 7 Pro (64bit)  to Windows 8.1 Pro (64bit). After the upgrading the literals of Payees and Categories in custom reports do not come out correctly. Specifically, I only get the colon ":" besides each description.

Could anyone help with this one? Thanks
Dimitrios

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Mon Jul 07, 2014 12:50 pm
by Nikolay
non Latin symbols?
Try to open %temp%\MoneyManagerEx_rep\index.html
in text editor or alter internet browser (not iexplore).
Is categories empty in this case as well?

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Mon Jul 07, 2014 5:05 pm
by dimidimi
Nikolay wrote:non Latin symbols?
Try to open %temp%\MoneyManagerEx_rep\index.html
in text editor or alter internet browser (not iexplore).
Is categories empty in this case as well?
I loaded the file in textedit and still I'm not able to see any category descriptions.

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Mon Jul 07, 2014 6:58 pm
by Nikolay
Could you please create empty DB, for example test.mmb, and insert one problem transaction the upload file for tests?

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Tue Jul 08, 2014 1:22 am
by dimidimi
Nikolay wrote:Could you please create empty DB, for example test.mmb, and insert one problem transaction the upload file for tests?
Here it is is. Please check the attached file.
test.mmb
(71 KiB) Downloaded 475 times

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Tue Jul 08, 2014 6:42 am
by Nikolay
I've reproduced this problem on my Win7X64.

I suggest workaround solution for Category Name.
Problem here in Lua code.Delete it.

Code: Select all

    local category = record:get("Category") ..":"..record:get("Subcategory");
    record:set("Category Name", category)
and add into SQL

Code: Select all

case (case ifnull(averages.subcategid, -1) when -1 then ifnull(averages.subcategid,-1) else ifnull(averages.subcategid, -1) end) when -1 then cat.categname
    else cat.categname ||':'||scat.subcategname end  "Category Name",

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Tue Jul 08, 2014 1:23 pm
by dimidimi
Nikolay wrote:I've reproduced this problem on my Win7X64.

I suggest workaround solution for Category Name.
Problem here in Lua code.Delete it.

Code: Select all

    local category = record:get("Category") ..":"..record:get("Subcategory");
    record:set("Category Name", category)
and add into SQL

Code: Select all

case (case ifnull(averages.subcategid, -1) when -1 then ifnull(averages.subcategid,-1) else ifnull(averages.subcategid, -1) end) when -1 then cat.categname
    else cat.categname ||':'||scat.subcategname end  "Category Name",
Thanks Nikolay! This workaround fixed the reporting part of the report. However, the category description on the graph are shown as "nil"

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Tue Jul 08, 2014 6:02 pm
by Nikolay
I think solution is to get data from html table directly.

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Tue Jul 08, 2014 7:37 pm
by dimidimi
Nikolay wrote:I think solution is to get data from html table directly.
I'm not really sure how to do that but anyway... Is the "problem" with the non-Latin symbols something which you're going to fix it in the final version?

EDIT:

All problems seem to be resolved after changing the "Language for non-Unicode programs" to Greek. I'm not sure if this is the proper way to solve this change took me back to where I was a far a reporting is concerned.

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Wed Jul 09, 2014 4:48 am
by Nikolay
seems it's solution. I've checked te report with curillic - working. Unfortunatly can't solve the problem on c++ side.

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Wed Jul 09, 2014 9:40 am
by dimidimi
Nikolay wrote:seems it's solution. I've checked te report with curillic - working. Unfortunatly can't solve the problem on c++ side.
Hmmm... Anyways I'm gonna keep the Windows setting to Greek cause it also seems to solve some problems with some other non-Unicode programs and Greek text. Thanks so much for looking into this! Just out of curiosity, isn't MMEX UTF-8 compliant?

Re: Problem with Custom Reports after upgrading to Win 8.1 P

Posted: Wed Jul 09, 2014 9:51 am
by Nikolay
dimidimi wrote: Just out of curiosity, isn't MMEX UTF-8 compliant?
mmex is UTF-8 compliant!