Active_prgs/Ledger/LedgerFromCSV.py

"""
LedgerFromCSV

Created by
Emanuel Borges
11.28.2017

This will simply convert a CSV, fixed by us and from numbers, to something that I can then save into the Journal file

"""

import os,csv


if __name__ == '__main__':
    mainPath = '/home/nino/Nextcloud/Nino And May/Fin/Amanda To-Do'
    mainCSV = 'Done 45.csv'

    outputFile = open(os.path.join(mainPath,"DoneLedger.txt"),'w')
    #contents = open(os.path.join(mainPath,mainCSV)).readlines()
    ##  Removing headder row
    #contents = contents[1:]
    with open(os.path.join(mainPath,mainCSV), 'rt', encoding='ASCII') as csvfile:
        reader = csv.DictReader(csvfile)
        for row in reader:
            outputFile.write(row['Posted_Date']+ " * "+row['Payee'] + "\n")
            if row['Other_Notes']:
                outputFile.write("    ; " + row['Other_Notes'] + "\n")
            outputFile.write("    "+row['Category']+ "                  "+row['Amount']+ "\n")
            outputFile.write("    Liabilities:Personal Visa"+"\n\n")
    outputFile.close()
Revision:	768
Committed:	Sat Apr 16 15:07:07 2022 UTC (3 years, 11 months ago) by nino.borges
Content type:	text/x-python
File size:	1030 byte(s)
Log Message:	Updated LedgerFromCSV to auto mark everything as cleared.
#	User	Rev	Content
1	nino.borges	644	"""
2			LedgerFromCSV
3
4			Created by
5			Emanuel Borges
6			11.28.2017
7
8			This will simply convert a CSV, fixed by us and from numbers, to something that I can then save into the Journal file
9
10			"""
11
12			import os,csv
13
14
15			if __name__ == '__main__':
16	nino.borges	656	mainPath = '/home/nino/Nextcloud/Nino And May/Fin/Amanda To-Do'
17	nino.borges	768	mainCSV = 'Done 45.csv'
18	nino.borges	644
19			outputFile = open(os.path.join(mainPath,"DoneLedger.txt"),'w')
20			#contents = open(os.path.join(mainPath,mainCSV)).readlines()
21			## Removing headder row
22			#contents = contents[1:]
23	nino.borges	768	with open(os.path.join(mainPath,mainCSV), 'rt', encoding='ASCII') as csvfile:
24	nino.borges	644	reader = csv.DictReader(csvfile)
25			for row in reader:
26	nino.borges	768	outputFile.write(row['Posted_Date']+ " * "+row['Payee'] + "\n")
27	nino.borges	656	if row['Other_Notes']:
28			outputFile.write(" ; " + row['Other_Notes'] + "\n")
29	nino.borges	644	outputFile.write(" "+row['Category']+ " "+row['Amount']+ "\n")
30			outputFile.write(" Liabilities:Personal Visa"+"\n\n")
31			outputFile.close()