The mobile softphone clients are obnoxious to set up, but once setup have less points of failure in the talk path for the phones. Probably not worth it if you got the other issues working.
Many of our remote sales team (account reps/sales engineers/design engineers) use the Teams app to make outbound calls from their cells. Our internal IT people mostly use the Equinox app when on the road. Most of the project managers, project engineers and higher tier support engineers that aren't in the actual call queues use EC500. People who spend more time as actual contact center agents use VPN hardphones or have softphone apps on their laptops and gaming headsets.
Why wouldn’t you just have a Cisco VGR and then do Call Manager internally? We don’t do soft phones or remote apps so maybe I am not aware that this isn’t the way.
No, buy a Sonus (Ribbon) if you're doing anything Teams related with Avaya.
Having the SBC lets you add additional SIP trunks to Teams if you need more conference call capacity, something you can't do with the cloud version of Webex.
I just sort of fell into it because my career path inside Comcast had me learning the SIP shit to support our phone services. The layers of oddities and points of failure can be frustrating, but it does lead to a fairly resilient level of job security if you can master them. Or if you are dogged enough to be willing to chase at loose ends to root out what the actual cause is for things you might enjoy it. The company I work for now is a pastiche of multiple telecoms that got merged together a few years ago. Add to that a new TAS type for enterprise clients, and it makes for an ever changing environment. If you can read a call diagram/ladder and know SIP, you can pretty much walk into any telecom and get a decent paying job.
, from openpyxl.reader.excel import load_workbook
#add Windows UI file picker functionality
#add conversion of file: html wrapped .xls to .xlsx
wb = load_workbook('countsheet.xlsx')
ws = wb.active
ws1 = wb.copy_worksheet(ws)
ws1.title = "count sheet"
rowCount = len(ws1['A']) - 1
ws1['F2'].value = "Count"
y = rowCount
#create column to show on hand vs counted discrepancy or compare OnHand vs Counted
#clear rows where discrepancy = 0
for y in range(3, y):
if ws1.cell(row = y, column = 10).value == None:
ws1.cell(row = y, column = 10).value = 0
# ws1.cell(row = y, column = 8).value =
# ws1.cell(row = y, column = 9).value - ws1.cell(row = y, column = 10).value
if ws1.cell(row = y, column = 9).value - ws1.cell(row = y, column = 10).value == 0:
for row in ws1[y]:
for x in row:
cell.value = None
#Delete unneeded columns
ws1.delete_cols(7,8)
ws1.delete_cols(3,1)
#Sort data
ws1.auto_filter.ref = "A3:E" & rowCount + 3
ws1.auto_filter.add_filter_column(0,)
ws1.auto_filter.add_sort_condition("A3:A" & rowCount + 3)
#test filter
print(ws1.cell["B3"])
#Other functionality to add:
#Delete rows where OnHand != Counted
#Adjust formatting
#Save fileLooking for a little help.
I'm working on a little python script to automate some Excel workbook edits I have to do when processing physical inventory of my company's service techs.
I'm getting an error in the last for loop. Line 27: (for x in row
"Exception has occurred: TypeError
'Cell' object is not iterable"
Code:from openpyxl.reader.excel import load_workbook #add Windows UI file picker functionality #add conversion of file: html wrapped .xls to .xlsx wb = load_workbook('countsheet.xlsx') ws = wb.active ws1 = wb.copy_worksheet(ws) ws1.title = "count sheet" rowCount = len(ws1['A']) - 1 ws1['F2'].value = "Count" y = rowCount #create column to show on hand vs counted discrepancy or compare OnHand vs Counted #clear rows where discrepancy = 0 for y in range(3, y): if ws1.cell(row = y, column = 10).value == None: ws1.cell(row = y, column = 10).value = 0 # ws1.cell(row = y, column = 8).value = # ws1.cell(row = y, column = 9).value - ws1.cell(row = y, column = 10).value if ws1.cell(row = y, column = 9).value - ws1.cell(row = y, column = 10).value == 0: for row in ws1[y]: for x in row: cell.value = None #Delete unneeded columns ws1.delete_cols(7,8) ws1.delete_cols(3,1) #Sort data ws1.auto_filter.ref = "A3:E" & rowCount + 3 ws1.auto_filter.add_filter_column(0,) ws1.auto_filter.add_sort_condition("A3:A" & rowCount + 3) #test filter print(ws1.cell["B3"]) #Other functionality to add: #Delete rows where OnHand != Counted #Adjust formatting #Save file
File start:
View attachment 260114
File updated:
View attachment 260115
