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.
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!