Dynamic Export

Discussions specific to Windows version of AceMoney
Post Reply
liederman
Posts:4
Joined:Fri Sep 05, 2014 2:54 am
Dynamic Export

Post by liederman » Sat Mar 28, 2020 6:22 pm

hello
I'm performing advance reporting on my data with excel. To do that I'm now manually exporting amj file to csv and then elaborate the file with power query and excel.
Is there any way to access the .amj file from external program in order to perform a dynamic reporting on the acemoney data? Amj file is encrypted so there shall be a way to input the password and decrypt data.

This would be from my side a very important feature as I consider reporting within Acemoney quite limited.

User avatar
RLebeau
Posts:274
Joined:Tue Jan 08, 2013 2:45 am
Location:California, USA
Contact:

Re: Dynamic Export

Post by RLebeau » Mon Mar 30, 2020 7:45 pm

liederman wrote:
Sat Mar 28, 2020 6:22 pm
Is there any way to access the .amj file from external program in order to perform a dynamic reporting on the acemoney data?
An AMJ data file is encrypted, and the exact encryption format is not documented publicly*.

Even if you were to export the data to the older non-encrypted MMW format (which AMJ still uses internally), the MMW format is still a proprietary format that no other program knows how to work with, as the format was never documented publicly*.

(* There is actually documentation available, but you would have to request it from MechCAD directly, as I did many years ago for a project I was working on. But there is no guarantee that MechCAD will provide it anymore. I was able to get a copy of the documentation for the MMW format before Alex Simanov died, and the documentation for the AMJ format shortly after ownership moved to his surviving family. The AMJ format probably hasn't changed much since the last time I got a copy of the docs, but I'm sure the MMW format has evolved as new features have been added to AceMoney. The last time I got updated docs was before AceMoney Receipts was added.)
liederman wrote:
Sat Mar 28, 2020 6:22 pm
Amj file is encrypted so there shall be a way to input the password and decrypt data.
It is more involved than that. There is not just encryption involved. And also, the encryption key is not always just a password.
liederman wrote:
Sat Mar 28, 2020 6:22 pm
This would be from my side a very important feature as I consider reporting within Acemoney quite limited.
In what way? What kind of reporting do you want to do that you can't do inside of AceMoney itself? Have you submitted any feature requests to MechCAD Support about what you need?
Remy Lebeau
Lebeau Software

User of AceMoney since 2004.

Post Reply