source: sap-budget/README @ 4cc9c2c

client
Last change on this file since 4cc9c2c was 4cc9c2c, checked in by Alex Dehnert <adehnert@…>, 14 years ago

Add parser for SAPGUI summary reports

  • Property mode set to 100644
File size: 959 bytes
Line 
1parser.py is designed to parse a summary report from SAPGUI, combine GLs into
2categories using a user-defined mapping, and produce a summary file with totals
3for each of the categories.
4
5parser.py takes three filename arguments:
6* summary: the SAPGUI summary report (exported using the "download" function)
7* accounts: account/category mapping file. The first column should be the category, and the second should be the account name (specifically, as it appears in the summary report --- which has a column of "     account number - account name" type elements). Additional columns may be included, but will be ignored. This may be useful for leaving notes for yourself about why an account is in a particular category.
8* output: CSV output file
9
10parser.py will read the first two files, write CSV output into the output file, and save some notes (e.g., summary rows that don't look like they have relevant info, accounts without a category, etc.) to stdout.
Note: See TracBrowser for help on using the repository browser.