diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/load_intex_collateral.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index aa6c793a..e6d170c5 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -38,7 +38,7 @@ def upload_data(dealnames, workdate, conn, cursor): #dealname, updatedate = line.rstrip().split() # updatedate = datetime.datetime.strptime(updatedate, '%m/%d/%Y') #dealname = dealname.upper() + ",AD.txt - with open( os.path.join(common.root, "data", "Collaterals_" + workdate, dealname.upper() + ",AD.txt"), "r") as fh: + with open( os.path.join(common.root, "data", "Collaterals_" + workdate, dealname.upper() + "_AD.txt"), "r") as fh: dr = csv.DictReader(fh, dialect = 'excel-tab') missingfields = set(fields) - set(dr.fieldnames) if "LoanX ID" in missingfields: @@ -155,7 +155,7 @@ if __name__ == "__main__": if len(sys.argv) > 2: dealnames = sys.argv[2:] else: - dealnames = [d.split(",")[0].lower() for d in os.listdir(os.path.join(common.root, "data", "Collaterals_" + workdate))] + dealnames = [d.split("_")[0].lower() for d in os.listdir(os.path.join(common.root, "data", "Collaterals_" + workdate))] upload_data(dealnames, workdate, common.conn, common.cursor) common.cursor.close() common.conn.close() |