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__':
    fileNumber = '202205'


    mainPath = '/home/nino/Nextcloud/Nino And May/Fin/Amanda To-Do/_Ready'
    mainCSV = 'Done-%s.csv'%fileNumber

    outputFile = open(os.path.join(mainPath,"DoneLedger%s.txt"% fileNumber),'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:	770
Committed:	Mon Jul 18 22:56:37 2022 UTC (3 years, 8 months ago) by nino.borges
Content type:	text/x-python
File size:	1090 byte(s)
Log Message:	cleaned up the code so that it marks it as cleared by default and upated paths.
#	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	770	fileNumber = '202205'
17	nino.borges	644
18	nino.borges	770
19			mainPath = '/home/nino/Nextcloud/Nino And May/Fin/Amanda To-Do/_Ready'
20			mainCSV = 'Done-%s.csv'%fileNumber
21
22			outputFile = open(os.path.join(mainPath,"DoneLedger%s.txt"% fileNumber),'w')
23	nino.borges	644	#contents = open(os.path.join(mainPath,mainCSV)).readlines()
24			## Removing headder row
25			#contents = contents[1:]
26	nino.borges	768	with open(os.path.join(mainPath,mainCSV), 'rt', encoding='ASCII') as csvfile:
27	nino.borges	644	reader = csv.DictReader(csvfile)
28			for row in reader:
29	nino.borges	768	outputFile.write(row['Posted_Date']+ " * "+row['Payee'] + "\n")
30	nino.borges	656	if row['Other_Notes']:
31			outputFile.write(" ; " + row['Other_Notes'] + "\n")
32	nino.borges	644	outputFile.write(" "+row['Category']+ " "+row['Amount']+ "\n")
33			outputFile.write(" Liabilities:Personal Visa"+"\n\n")
34			outputFile.close()