REBELinBLUE's dashboard

Seems it still needs work account to/account from isn't right and title seems to be blank sometimes :| – REBELinBLUE, on February 07, 2010 21:39

I haven't finished testing it fully yet but this should work

sqlite3 -csv ~/Library/Application\ Support/Cha_Ching_2/Cha_Ching.2ccdb "select ZTRANS_TITLE, round(ZTRANS_AMOUNT, 2), strftime('%d/%m/%Y', ZTRANS_DATE,'unixepoch','+31 years'),ZTRANS_TO,ZTRANS_FROM,ZTRANS_KEYWORDSSTRINGVALUE,ZTRANS_NOTES,ZTRANS_CATEGORY,ZVAULT_TITLE FROM ZTRANSENTITY,ZVAULTENTITY WHERE ZTRANS_ACCOUNTID=ZVAULT_UNIQUEID ORDER BY ZVAULT_TITLE, ZTRANS_DATE;" > ~/Desktop/Cha-Ching.csv

You should get a CSV file on your desktop with the transaction title, amount, date (in d/m/y format), account from, account to (for transfers), comma separates tags, notes, category, account name.