SanitationUtils.safePrint("ERROR IN SFTP: " + str(e))
finally:
sftpClient.close()
except Exception, e:
SanitationUtils.safePrint("ERROR IN SSH: " + str(e))
finally:
sshClient.close()
maParser = CSVParse_User(
cols = colData.getImportCols(),
defaults = colData.getDefaults(),
contact_schema = 'act',
)
maParser.analyseFile(maPath, maEncoding)
def printBasicColumns(users):
# print len(users)
usrList = UsrObjList()
for user in users:
usrList.append(user)
# SanitationUtils.safePrint( "BILLING ADDRESS:", repr(user), user['First Name'], user.get('First Name'), user.name.__unicode__(out_schema="flat"))
cols = colData.getBasicCols()
SanitationUtils.safePrint( usrList.tabulate(
cols,
tablefmt = 'simple'
))
'charset': db_charset,
'use_unicode': True,
'tbl_prefix': tbl_prefix,
}
print SSHTunnelForwarderParams
print PyMySqlConnectParams
with UsrSyncClient_SQL_WP(SSHTunnelForwarderParams, PyMySqlConnectParams) as client:
client.analyseRemote(saParser, limit=global_limit, filterItems=filterItems)
saParser.getObjList().exportItems(os.path.join(inFolder, s_x_filename),
ColData_User.getWPImportColNames())
else:
saParser.analyseFile(saPath, saEncoding)
# CSVParse_User.printBasicColumns( list(chain( *saParser.emails.values() )) )
#########################################
# Generate and Analyse ACT CSV files using shell
#########################################
maParser = CSVParse_User(
cols = ColData_User.getACTImportCols(),
defaults = ColData_User.getDefaults(),
contact_schema = 'act',
filterItems = filterItems,
limit = global_limit
)
