I have written a Python program which takes an MMEX JSON export and creates an Excel spreadsheet.
I am rewriting the program in Go. In the Go version I am not able to correctly describe the format of the MMEX JSON export, so I cannot import and unmarshall the MMEX export. I suspect my failure is due to me doing something silly missing something obvious.
If anyone has done this successfully I would love to know how.
[SOLVED] Processing MMEX JSON Export in Go/Golang
Moderator: Renato
-
- New User
- Posts: 19
- Joined: Wed Feb 26, 2014 9:32 am
- Are you a spam bot?: No
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Processing MMEX JSON Export in Go/Golang
Why don't you access the .mmb database directly in Excel.
What kind of evaluations do you do with it in Excel.
I solved my problem like this: viewtopic.php?f=10&t=9549&p=20427&hilit=odbc#p20427
What kind of evaluations do you do with it in Excel.
I solved my problem like this: viewtopic.php?f=10&t=9549&p=20427&hilit=odbc#p20427
Renato Forum Administrator
-
- New User
- Posts: 1
- Joined: Sun Oct 22, 2023 9:26 am
- Are you a spam bot?: No
Re: Processing MMEX JSON Export in Go/Golang
I also believe it is easier to connect Excel directly to the database.
I have done it using Power Query in Excel (Microsoft 365 version) through Data > Get Data > From Other Sources > Blank Query
That takes you to Query in Power Query. Once in Power Query , if you go to View > Advanced Editor, you can copy and paste the M query code:
This will load the Account List into Excel. Enter the path to your mmb file and changing the Name in the query you can get any other table you need.
I hope it helps.
I have done it using Power Query in Excel (Microsoft 365 version) through Data > Get Data > From Other Sources > Blank Query
That takes you to Query in Power Query. Once in Power Query , if you go to View > Advanced Editor, you can copy and paste the M query code:
Code: Select all
let
Source = Odbc.DataSource("database=C:\FullPathToYourMMBFileHere.mmb;dsn=SQLite3 Datasource", [HierarchicalNavigation=true]),
ACCOUNTLIST_V1_Table = Source{[Name="ACCOUNTLIST_V1",Kind="Table"]}[Data]
in
ACCOUNTLIST_V1_Table
I hope it helps.
-
- New User
- Posts: 19
- Joined: Wed Feb 26, 2014 9:32 am
- Are you a spam bot?: No
Re: Processing MMEX JSON Export in Go/Golang
Many, many thanks to Renato and Curcuma for the sensible and useful advice.
I have solved my immediate problem.
I have solved my immediate problem.
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Processing MMEX JSON Export in Go/Golang
Thank you, We are always happy to receive positive feedback.
Renato Forum Administrator