Hi there,
telenet to multiple device, taking host details (ip, username and password) from excel file. this excel file contains
ip username password
10.10.10.1 admin 1234
getting below error
Traceback (most recent call last):
File "zyxelmacport.py", line 37, in <module>
column3 = (worksheet.cell(x,2).value).decode('ascii')
AttributeError: 'float' object has no attribute 'decode'
some changes, telNetConnection function is not taking numeric password like 1234, when i changed, its started working.
telenet to multiple device, taking host details (ip, username and password) from excel file. this excel file contains
ip username password
10.10.10.1 admin 1234
getting below error
Traceback (most recent call last):
File "zyxelmacport.py", line 37, in <module>
column3 = (worksheet.cell(x,2).value).decode('ascii')
AttributeError: 'float' object has no attribute 'decode'
#!/usr/bin/python import paramiko import sys import os import xlrd import unidecode import telnetlib import time def telNetConnection(column1,column2,column3): host = [ (column1),] for host in host: print column1 user = (column2) password = (column3) telnet = telnetlib.Telnet(host) telnet.read_until('User name: ', 3) telnet.write(user.encode('ascii') + '\r') telnet.read_until('Password: ', 3) telnet.write(password.encode('ascii') + '\r') telnet.write(ena.encode('ascii') + '\r\n') telnet.write('statistics mac 1~48' + '\r\n') telnet.write('exit' + '\r') output=telnet.read_all() f = open(macportdetail, 'w') f.write(str(output)) os.chdir("/home/scripts") workbook = xlrd.open_workbook('zyxeldslams.xlsx') worksheet = workbook.sheet_by_name('Sheet1') for x in range(1,4): column1 = (worksheet.cell(x,0).value).decode('ascii') column2 = (worksheet.cell(x,1).value).decode('ascii') column3 = (worksheet.cell(x,2).value).decode('ascii') telNetConnection(column1,column2,column3)
some changes, telNetConnection function is not taking numeric password like 1234, when i changed, its started working.
#!/usr/bin/python import paramiko import sys import os import xlrd import unidecode import telnetlib import time def telNetConnection(column1,column2,column3): host = [ (column1),] for host in host: print column1 user = (column2) password = (column3) telnet = telnetlib.Telnet(host) telnet.read_until('User name: ', 3) telnet.write(user.encode('ascii') + '\r') telnet.read_until('Password: ', 3) telnet.write(password.encode('ascii') + '\r') telnet.write('statistics mac 1~48' + '\r\n') telnet.write('exit' + '\r') output=telnet.read_all() f = open(macportdetail, 'w') f.write(str(output)) os.chdir("/home/anna/scripts") workbook = xlrd.open_workbook('zyxeldslams.xlsx') worksheet = workbook.sheet_by_name('Sheet1') for x in range(1,4): column1 = (worksheet.cell(x,0).value).decode('ascii') column2 = (worksheet.cell(x,1).value).decode('ascii') column3 = (worksheet.cell(x,2).value).decode('ascii') telNetConnection(column1,column2,column3)