New interchange format
Posted: Sun Jul 21, 2024 5:40 pm
Hello,
I recently transferred my home financial data from Excel (actually LibreOffice) to MMEX. Since I was not fully satisfied with any of the available interchange formats, I developed my own tool to do the transfer:
* https://github.com/georgeef/mmexutil
This tool defines an XLSX interchange format, which is essentially a complete dump of the MMEX database, except that the ids are abstracted. It can be used to initialize an MMEX database with data coming from another source (which was the main purpose I developed this tool), after some manual editing in Excel, or to merge two MMEX databases, after exporting one of them to XLSX.
It would be nice to have native support for this or similar functionality, inside the MMEX application.
Although I have spent considerable time reading the internals of MMEX, I may have missed some important details. I would appreciate if I could get answers to a few technical questions (either in this forum or through email), in order to confirm or to correct my (numerous) assumptions.
Regards
George
I recently transferred my home financial data from Excel (actually LibreOffice) to MMEX. Since I was not fully satisfied with any of the available interchange formats, I developed my own tool to do the transfer:
* https://github.com/georgeef/mmexutil
This tool defines an XLSX interchange format, which is essentially a complete dump of the MMEX database, except that the ids are abstracted. It can be used to initialize an MMEX database with data coming from another source (which was the main purpose I developed this tool), after some manual editing in Excel, or to merge two MMEX databases, after exporting one of them to XLSX.
It would be nice to have native support for this or similar functionality, inside the MMEX application.
Although I have spent considerable time reading the internals of MMEX, I may have missed some important details. I would appreciate if I could get answers to a few technical questions (either in this forum or through email), in order to confirm or to correct my (numerous) assumptions.
Regards
George