1. hleofxquotes-team Avatar hleofxquotes-team
  2. open
  3. dist-sunriise

Wiki

Clone wiki

dist-sunriise / sunriise-export CSV

View History

sunriise-export CSV

Download the jar file from: this Download link

See also: Field Guide to parsing the CSV files

Usage

UI mode

Double-click on the jar file to start

Or 

java -jar sunriise-export-0.0.2-SNAPSHOT-exec.jar

  • Drag and drop your *.mny into the tool to start exporting
  • Select menu 'File -> Open exports directory' to view the list of exported files

Command-line mode

java -jar sunriise-export-0.0.2-SNAPSHOT-exec.jar export.csv2 in.mny [password] outDir

For example, to export the msmoney sample.mny file and put the results into directory exportOut directory 

java -jar sunriise-export-0.0.2-SNAPSHOT-exec.jar export.csv2 sample.mny exportOut
2019-09-28 08:09:33,231 [INFO  ] ExportToCsv2Cmd.export(ExportToCsv2Cmd.java:54) – dbFile=sample.mny
2019-09-28 08:09:33,235 [INFO  ] ExportToCsv2Cmd.export(ExportToCsv2Cmd.java:55) – outDir=exportOut
...
2019-09-28 08:09:34,295 [INFO  ] AbstractExportTo.visitAccount(AbstractExportTo.java:270) – > 22/23 accountName=Woodgrove Investments (Cash)
2019-09-28 08:09:34,300 [INFO  ] AbstractExportTo.visitAccount(AbstractExportTo.java:270) – > 23/23 accountName=Woodgrove Platinum Card
2019-09-28 08:09:34,573 [INFO  ] MnyDb.close(MnyDb.java:223) – Closing dbFile=sample.mny
2019-09-28 08:09:34,614 [INFO  ] ExportToCsv2Cmd.export(ExportToCsv2Cmd.java:71) – < DONE

Now if you take a look at the content of the export directory you should see the following files

  1. accounts.csv: list of accounts
  2. categories.csv: list of categories
  3. currencies.csv: list of currencies
  4. filteredTransactions.csv: list of transactions that does not contribute to balances (such as definitions of recurring transactions)
  5. payees.csv: list of payees
  6. securities.csv: list of securities (stocks, mutual funds ...)
  7. transactions.csv: list of transactions (This list is probably the MOST IMPORTANT one)

You can download the sample output from the Download link

Sample accounts.csv

"id","name","accountType","currency","startingBalance","relatedToAccountId","relatedToAccountName","closed","retirement","investmentSubType"
"2","Woodgrove Investments","INVESTMENT","USD","0.00","3","Woodgrove Investments (Cash)","false","false","NOT_APPLICABLE"
"3","Woodgrove Investments (Cash)","BANKING","USD","0.00","2","Woodgrove Investments","false","false","NOT_APPLICABLE"
"66","Woodgrove Bond Account","INVESTMENT","USD","0.00","67","Woodgrove Bond Account (Cash)","false","false","NOT_APPLICABLE"

Sample categories.csv

"id","name","parentId","level","classificationId"
"131","EXPENSE","","0","0"
"130","INCOME","","0","0"
"132","Investment Income","130","1","0"
"133","Dividends","132","2","0"

Sample currencies.csv

"id","name","isoCode"
"1","Argentine peso","ARS"
"2","Australian dollar","AUD"
"3","Austrian schilling","ATS"
"4","Belgian franc","BEF"

Sample filteredTransactions.csv

"id","date","number","amount","categoryId","category","memo","payeeId","payee","splitsCount","splits","splitParentId","accountId","account","void","cleared","reconciled","unaccepted","transfer","xferAccountId","xferTransactionId","investment","invActivity","invSecId","invSecName","invSecSymbol","invTxPrice","invTxQuantity","recurring","frequency","classification1Id","classification1Name","fiTid"
"4956","2008/05/02","","64.67","","Transfer from Woodgrove Bank Checking","401k withdrawl","19","AUTOMATIC DEPOSIT -- PAYROLL","0","","-1","17","Charlie's 401(k) (Contributions)","true","false","false","false","true","42","","false","ACTIVITY_UNKNOWN","","","","","","true","Twice a month","-1","",""
...

Sample payees.csv

"id","name","parentId"
"106","Forth Coffee",""
"107","Woodgrove Credit Card",""
"108","Humongous Insurance",""
"109","School of Fine Art",""

Sample securities.csv

"id","name","symbol"
"18","Dow Jones Industrial Average","$INDU"
"30","NASDAQ Composite Index","$COMPX"
"38","Standard & Poor's 500","$INX"
"41","Standard & Poor's Healthcare",".HCX.X"

Sample transactions.csv

"id","date","number","amount","categoryId","category","memo","payeeId","payee","splitsCount","splits","splitParentId","accountId","account","void","cleared","reconciled","unaccepted","transfer","xferAccountId","xferTransactionId","investment","invActivity","invSecId","invSecName","invSecSymbol","invTxPrice","invTxQuantity","recurring","frequency","classification1Id","classification1Name","fiTid"
"2771","2006/01/30","","-4300.00","","Transfer from Charlie & May’s Joint Investment","","-1","","0","","-1","73","Charlie & May’s Joint Inv (Cash)","false","false","false","false","true","72","2770","false","ACTIVITY_UNKNOWN","","","","","","false","Non-recurring","-1","",""
"2769","2006/07/15","","-1524.40","","Transfer from Charlie & May’s Joint Investment","","-1","","0","","-1","73","Charlie & May’s Joint Inv (Cash)","false","false","false","false","true","72","2768","false","ACTIVITY_UNKNOWN","","","","","","false","Non-recurring","-1","",""
"2761","2007/01/01","","-623.50","","Transfer from Charlie & May’s Joint Investment","","-1","","0","","-1","73","Charlie & May’s Joint Inv (Cash)","false","false","false","false","true","72","2760","false","ACTIVITY_UNKNOWN","","","","","","false","Non-recurring","-1","",""
"2763","2007/01/01","","-717.75","","Transfer from Charlie & May’s Joint Investment","","-1","","0","","-1","73","Charlie & May’s Joint Inv (Cash)","false","false","false","false","true","72","2762","false","ACTIVITY_UNKNOWN","","","","","","false","Non-recurring","-1","",""
...

Transaction Columns

See the Field Guide to parsing the CSV files

Updated