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 )