diff options
Diffstat (limited to 'python/load_intex_collateral.py')
| -rw-r--r-- | python/load_intex_collateral.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index 3df9facd..79b2a41d 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -51,10 +51,11 @@ def upload_data(workdate, conn, cursor): line[f] = None if line['Fixed or Float']: line['Fixed or Float'] = line['Fixed or Float'].upper() - if line['LoanX ID'] and len(line['LoanX ID']) > 8: - print "dubious id found: {0}".format(line['LoanX ID']) - line['LoanX ID'] = line['LoanX ID'][:8] - line['LoanX ID'] = line['LoanX ID'].upper() + if line['LoanX ID']: + line['LoanX ID'] = line['LoanX ID'].upper() + if len(line['LoanX ID']) > 8: + print "dubious id found: {0}".format(line['LoanX ID']) + line['LoanX ID'] = line['LoanX ID'][:8] try: # make sure the string is utf8 safe line['Issuer'] = line['Issuer'].decode('windows-1252') |