Ah okay, this is best done via metadata rather than comments. Simply define a build_metadata() in your importer, and return a dictionary of metadata values you want for each transaction. It should just be a line or two of code. See build_metadata() in investments.py, which you will override.
On Monday, January 30, 2023 at 9:28:09 PM UTC-8 fin wrote: > Red S wrote: > ... > > I'm not sure I understand. What is the current output, and what would > you > > like it to be? > > ok, i get sidetracked sometimes... :) > > thanks for getting this far! > > > the fields are originally fed in as: > > DATE,TRANSACTION > ID,DESCRIPTION,QUANTITY,SYMBOL,PRICE,COMMISSION,AMOUNT,REG FEE,SHORT-TERM > RDM FEE,FUND REDEMPTION FEE, DEFERRED SALES CHARGE > 12/29/2000,1,CASH ALTERNATIVES DIVIDENDS (ACCTNUMBER1),,,,,1.51,,,, > 12/29/2000,2,CASH ALTERNATIVES PURCHASE (MMSWEEP1),1.51,MMSWEEP1,,,0.00,,,, > 12/29/2000,3,CASH ALTERNATIVES PURCHASE,,,,,-1.51,,,, > 12/29/2000,4,CASH ALTERNATIVES PURCHASE (MMSWEEP1),4.54,MMSWEEP1,,,0.00,,,, > 12/29/2000,5,CASH ALTERNATIVES PURCHASE,,,,,-4.54,,,, > 12/29/2000,6,CASH ALTERNATIVES INTEREST (MMSWEEP1),,MMSWEEP1,,,4.54,,,, > ***END OF FILE*** > > > here's the current output: > > ;; -*- mode: beancount -*- > **** /home/me/fin/beancount/testing/test-trans.csv > > 2000-12-29 * "dividends" "dividends" > Assets:SB:TDA:CASH 1.51 USD > Income:SB:TDA:MM:Dividends:USD -1.51 USD > > 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" > Assets:SB:TDA:MMSWEEP1 1.51 MMSWEEP1 > Assets:SB:TDA:Pass-Through -1.51 MMSWEEP1 > > 2000-12-29 * "transfer" "transfer" > Assets:SB:TDA:CASH 0 USD > Assets:SB:TDA:Pass-Through -0 USD > > 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" > Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 > Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 > > 2000-12-29 * "transfer" "transfer" > Assets:SB:TDA:CASH 0 USD > Assets:SB:TDA:Pass-Through -0 USD > > 2000-12-29 * "income" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" > Assets:SB:TDA:CASH 4.54 USD > Income:SB:TDA:MM:Interest:MMSWEEP1 -4.54 USD > > > **** /home/me/fin/beancount/testing/test-trans.csv > ;; -*- mode: beancount -*- > > > i'd like to take the TRANSACTION ID and DESCRIPTION fields > and put them on one line as a comment or something and then > i'd like the entire contents of the input data for that line > put on the next line. > > > so that this: > > 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" > Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 > Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 > > > ends up looking something like: > > 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" > ; > ; TrID Desc: "4 CASH ALTERNATIVES PURCHASE (MMSWEEP1)" > ; > ; Raw Data: "12/29/2000,4,CASH ALTERNATIVES PURCHASE > (MMSWEEP1),4.54,MMSWEEP1,,,0.00,,,," > ; > Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 > Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 > > > fin > > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/6844d8ff-fdf6-4260-a853-a7fca083f5c9n%40googlegroups.com.
