Really, XML? I hope you bought stock in the makers of Tums & Pepsid.

The Latex table is easy, here's a single line from a Latex table:

 2011/05/20 &  TravelAgencyFee &  AGENT FEE &  \$40.00 &   \\ \hline

It's '&' separated.

Latex also links in all my receipt images seamlessly that I get via
Ledger metadata.

\includegraphics[scale=.6,angle=90]{./Receipts/PROJ3009/20110527_NJTransit_3_00.jpg}
 \\

Tada. All that and a fully function PDF with TOC to boot.

The perl script interrogates Ledger and parses the output to reformat
to Latex.

To get you started, here's a sample txn:

2011/03/13 (03/15/2011) HAMPTON INNS
    ; RECEIPT: Receipts/PROJ0000/hampton.jpg
    Source:Visa                                    $-246.34
    Dest:Projects
        ; ER: ER0001
        ; PROJECT: PROJ0000
        ; CATEGORY: Lodging

Then you can play with --pivot and ER, PROJECT, and use %ER=ER0001 to
see your expense.

Thanks.

On Wed, Aug 03, 2011 at 02:42:33PM -0400, Doug Philips wrote:
> On Wed, Aug 3, 2011 at 14:18, ed <[email protected]> wrote:
> > Another option is to massage the XML content of a docx or xlsx file
> > and produce the form that way .... Probably simpler (for me) than
> > messing about with Latex.
>
> OMG. Having to work with tools that take XML and build docx files as
> part of my day job, I weep for you if you go down that path. If LaTeX
> means a learning curve, then maybe going to CSV or Tab separated
> values and pulling into a spreadsheet would be simpler...
>
> -Doug
>


------------------------------------------------------------------
Russell Adams                            [email protected]

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Reply via email to