def get_call_durations(filename, destnum, phone_num_filter=False, date_start=False, date_end=False, quiet=False, transfer_calls=False):
durations = {}
current_week_start = 0
open_calls = {}
f = open(filename)
while(True):
line = f.readline()
if not line:
break
try:
#################################################
## Use the calls here to determine what pieces
## of data must exist for the line to be valid.
## All of those below should probably always be.
phone_num = otalo_utils.get_phone_num(line)
current_date = otalo_utils.get_date(line)
dest = otalo_utils.get_destination(line)
##
################################################
current_time = otalo_utils.get_time(line)
if phone_num_filter and not phone_num in phone_num_filter:
continue
if date_start:
if date_end:
if not (current_date >= date_start and current_date < date_end):
continue
if current_date > date_end:
break
else:
if not current_date >= date_start:
continue
if destnum.find(dest) == -1:
continue
# A hacky way to test for transfer call
# In the future you want to compare this call's
# start time to a time window related to the end
# of the survey call (in which you can keep the flag
# false and give a more targeted start and end date)
if transfer_calls:
if transfer_calls == "INBOUND_ONLY" and len(dest) == 10:
continue
elif transfer_calls == "TRANSFER_ONLY" and len(dest) < 10:
continue
if not current_week_start:
current_week_start = datetime(year=current_date.year, month=current_date.month, day=current_date.day)
delta = current_date - current_week_start
if delta.days > 6:
#flush all open calls
flush_open_calls(durations, open_calls, current_week_start)
open_calls = {}
current_week_start = datetime(year=current_date.year, month=current_date.month, day=current_date.day)
if not current_week_start in durations:
durations[current_week_start] = []
if line.find("Start call") != -1:
# check to see if this caller already has one open
if phone_num in open_calls.keys() and current_time > open_calls[phone_num]['last']:
# close out current call
call = open_calls[phone_num]
del open_calls[phone_num]
dur = call['last'] - call['start']
#print("closing out call pre-emptively: " + phone_num + ", "+otalo_utils.date_str(current_date) + ", "+otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
durations[current_week_start].append([phone_num,dur])
# add new call
#print("adding new call: " + phone_num)
open_calls[phone_num] = {'start':current_time, 'last':current_time }
elif line.find("End call") != -1:
if phone_num in open_calls.keys():
# close out call
call = open_calls[phone_num]
dur = current_time - call['start']
#print("closing out call: "+phone_num + ", "+otalo_utils.date_str(current_date) + ", "+ otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
durations[current_week_start].append([phone_num,dur])
del open_calls[phone_num]
elif phone_num in open_calls:
#print("updating call dur: " + phone_num)
# this makes things conservative. A call is only officially counted if
# it starts with a call_started
open_calls[phone_num]['last'] = current_time
#print("open_calls: " + str(open_calls))
except KeyError as err:
#print("KeyError: " + phone_num + "-" + otalo.date_str(current_date) + " " + otalo.time_str(current_time))
raise
except ValueError as err:
#print("ValueError: " + line)
continue
except IndexError:
continue
except otalo_utils.PhoneNumException:
#print("PhoneNumException: " + line)
continue
#flush the last week
flush_open_calls(durations, open_calls, current_week_start)
if not quiet:
if phone_num_filter:
print("Data for phone numbers: " + str(phone_num_filter))
print("Average call duration, by week (s):")
dates = durations.keys()
dates.sort()
secs = 0
calls = 0
for date in dates:
durs_by_call = durations[date]
durs = [dur[1].seconds for dur in durs_by_call]
secs += sum(durs)
calls += len(durs)
print(date.strftime('%Y-%m-%d') +"\t"+ str(sum(durs)/len(durs)))
if calls > 0:
print('Overall Average: ' + str(secs/calls))
return durations
def get_online_time(filename, destnum=False, phone_num_filter=False, date_start=False, date_end=False, quiet=False, daily_data=False, transfer_calls=False):
online_time = {}
current_day = 0
open_calls = {}
f = open(filename)
while(True):
line = f.readline()
if not line:
break
try:
#################################################
## Use the calls here to determine what pieces
## of data must exist for the line to be valid.
## All of those below should probably always be.
phone_num = otalo_utils.get_phone_num(line)
current_date = otalo_utils.get_date(line)
dest = otalo_utils.get_destination(line)
##
################################################
current_time = otalo_utils.get_time(line)
if phone_num_filter and not phone_num in phone_num_filter:
continue
if date_start:
if date_end:
if not (current_date >= date_start and current_date < date_end):
continue
if current_date > date_end:
break
else:
if not current_date >= date_start:
continue
if destnum and destnum.find(dest) == -1:
continue
# A hacky way to test for transfer call
# In the future you want to compare this call's
# start time to a time window related to the end
# of the survey call (in which you can keep the flag
# false and give a more targeted start and end date)
if transfer_calls:
if len(dest) < 10:
continue
elif len(dest) == 10:
continue
if not current_day:
current_day = datetime(year=current_date.year, month=current_date.month, day=current_date.day)
delta = current_date - current_day
if daily_data:
days = 0
else:
days = 6
if delta.days > days:
#Don't flush, assume it's rarely needed
#flush_open_calls(online_time, open_calls, current_day)
open_calls = {}
current_day += timedelta(days=days+1)
if not current_day in online_time:
online_time[current_day] = 0
if line.find("Start call") != -1:
# check to see if this caller already has one open
if phone_num in open_calls.keys() and current_time > open_calls[phone_num]['last']:
# close out current call
call = open_calls[phone_num]
del open_calls[phone_num]
dur = call['last'] - call['start']
#print("closing out call pre-emptively: " + phone_num + ", "+otalo_utils.date_str(current_date) + ", "+otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
online_time[current_day] += dur.seconds
# add new call
#print("adding new call: " + phone_num)
open_calls[phone_num] = {'start':current_time, 'last':current_time }
elif line.find("End call") != -1:
if phone_num in open_calls.keys():
# close out call
call = open_calls[phone_num]
dur = current_time - call['start']
#print("closing out call: "+phone_num + ", "+otalo_utils.date_str(current_date) + ", "+ otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
online_time[current_day] += dur.seconds
del open_calls[phone_num]
elif phone_num in open_calls:
#print("updating call dur: " + phone_num)
# this makes things conservative. A call is only officially counted if
# it starts with a call_started
open_calls[phone_num]['last'] = current_time
#print("open_calls: " + str(open_calls))
except KeyError as err:
#print("KeyError: " + phone_num + "-" + otalo.date_str(current_date) + " " + otalo.time_str(current_time))
raise
except ValueError as err:
#print("ValueError: " + line)
continue
except IndexError:
continue
except otalo_utils.PhoneNumException:
#print("PhoneNumException: " + line)
continue
#flush the last week
#flush_open_calls(online_time, open_calls, current_day)
if not quiet:
if phone_num_filter:
print("Data for phone numbers: " + str(phone_num_filter))
print("Total online time, by time period (s):")
dates = online_time.keys()
dates.sort()
tot_secs = 0
for date in dates:
online_secs = online_time[date]
tot_secs += online_secs
print(otalo_utils.date_str(date) +"\t"+ str(online_secs))
print('Average online time per period: ' + str(tot_secs/len(online_time)))
return online_time
def get_online_time(filename,
destnum=False,
phone_num_filter=False,
date_start=False,
date_end=False,
quiet=False,
daily_data=False,
transfer_calls=False):
online_time = {}
current_day = 0
open_calls = {}
f = open(filename)
while (True):
line = f.readline()
if not line:
break
try:
#################################################
## Use the calls here to determine what pieces
## of data must exist for the line to be valid.
## All of those below should probably always be.
phone_num = otalo_utils.get_phone_num(line)
current_date = otalo_utils.get_date(line)
dest = otalo_utils.get_destination(line)
##
################################################
current_time = otalo_utils.get_time(line)
if phone_num_filter and not phone_num in phone_num_filter:
continue
if date_start:
if date_end:
if not (current_date >= date_start
and current_date < date_end):
continue
if current_date > date_end:
break
else:
if not current_date >= date_start:
continue
if destnum and destnum.find(dest) == -1:
continue
# A hacky way to test for transfer call
# In the future you want to compare this call's
# start time to a time window related to the end
# of the survey call (in which you can keep the flag
# false and give a more targeted start and end date)
if transfer_calls:
if len(dest) < 10:
continue
elif len(dest) == 10:
continue
if not current_day:
current_day = datetime(year=current_date.year,
month=current_date.month,
day=current_date.day)
delta = current_date - current_day
if daily_data:
days = 0
else:
days = 6
if delta.days > days:
#Don't flush, assume it's rarely needed
#flush_open_calls(online_time, open_calls, current_day)
open_calls = {}
current_day += timedelta(days=days + 1)
if not current_day in online_time:
online_time[current_day] = 0
if line.find("Start call") != -1:
# check to see if this caller already has one open
if phone_num in open_calls.keys(
) and current_time > open_calls[phone_num]['last']:
# close out current call
call = open_calls[phone_num]
del open_calls[phone_num]
dur = call['last'] - call['start']
#print("closing out call pre-emptively: " + phone_num + ", "+otalo_utils.date_str(current_date) + ", "+otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
online_time[current_day] += dur.seconds
# add new call
#print("adding new call: " + phone_num)
open_calls[phone_num] = {
'start': current_time,
'last': current_time
}
elif line.find("End call") != -1:
if phone_num in open_calls.keys():
# close out call
call = open_calls[phone_num]
dur = current_time - call['start']
#print("closing out call: "+phone_num + ", "+otalo_utils.date_str(current_date) + ", "+ otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
online_time[current_day] += dur.seconds
del open_calls[phone_num]
elif phone_num in open_calls:
#print("updating call dur: " + phone_num)
# this makes things conservative. A call is only officially counted if
# it starts with a call_started
open_calls[phone_num]['last'] = current_time
#print("open_calls: " + str(open_calls))
except KeyError as err:
#print("KeyError: " + phone_num + "-" + otalo.date_str(current_date) + " " + otalo.time_str(current_time))
raise
except ValueError as err:
#print("ValueError: " + line)
continue
except IndexError:
continue
except otalo_utils.PhoneNumException:
#print("PhoneNumException: " + line)
continue
#flush the last week
#flush_open_calls(online_time, open_calls, current_day)
if not quiet:
if phone_num_filter:
print("Data for phone numbers: " + str(phone_num_filter))
print("Total online time, by time period (s):")
dates = online_time.keys()
dates.sort()
tot_secs = 0
for date in dates:
online_secs = online_time[date]
tot_secs += online_secs
print(otalo_utils.date_str(date) + "\t" + str(online_secs))
print('Average online time per period: ' +
str(tot_secs / len(online_time)))
return online_time
def get_call_durations(filename,
destnum,
phone_num_filter=False,
date_start=False,
date_end=False,
quiet=False,
transfer_calls=False):
durations = {}
current_week_start = 0
open_calls = {}
f = open(filename)
while (True):
line = f.readline()
if not line:
break
try:
#################################################
## Use the calls here to determine what pieces
## of data must exist for the line to be valid.
## All of those below should probably always be.
phone_num = otalo_utils.get_phone_num(line)
current_date = otalo_utils.get_date(line)
dest = otalo_utils.get_destination(line)
##
################################################
current_time = otalo_utils.get_time(line)
if phone_num_filter and not phone_num in phone_num_filter:
continue
if date_start:
if date_end:
if not (current_date >= date_start
and current_date < date_end):
continue
if current_date > date_end:
break
else:
if not current_date >= date_start:
continue
if destnum.find(dest) == -1:
continue
# A hacky way to test for transfer call
# In the future you want to compare this call's
# start time to a time window related to the end
# of the survey call (in which you can keep the flag
# false and give a more targeted start and end date)
if transfer_calls:
if transfer_calls == "INBOUND_ONLY" and len(dest) == 10:
continue
elif transfer_calls == "TRANSFER_ONLY" and len(dest) < 10:
continue
if not current_week_start:
current_week_start = datetime(year=current_date.year,
month=current_date.month,
day=current_date.day)
delta = current_date - current_week_start
if delta.days > 6:
#flush all open calls
flush_open_calls(durations, open_calls, current_week_start)
open_calls = {}
current_week_start = datetime(year=current_date.year,
month=current_date.month,
day=current_date.day)
if not current_week_start in durations:
durations[current_week_start] = []
if line.find("Start call") != -1:
# check to see if this caller already has one open
if phone_num in open_calls.keys(
) and current_time > open_calls[phone_num]['last']:
# close out current call
call = open_calls[phone_num]
del open_calls[phone_num]
dur = call['last'] - call['start']
#print("closing out call pre-emptively: " + phone_num + ", "+otalo_utils.date_str(current_date) + ", "+otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
durations[current_week_start].append([phone_num, dur])
# add new call
#print("adding new call: " + phone_num)
open_calls[phone_num] = {
'start': current_time,
'last': current_time
}
elif line.find("End call") != -1:
if phone_num in open_calls.keys():
# close out call
call = open_calls[phone_num]
dur = current_time - call['start']
#print("closing out call: "+phone_num + ", "+otalo_utils.date_str(current_date) + ", "+ otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
durations[current_week_start].append([phone_num, dur])
del open_calls[phone_num]
elif phone_num in open_calls:
#print("updating call dur: " + phone_num)
# this makes things conservative. A call is only officially counted if
# it starts with a call_started
open_calls[phone_num]['last'] = current_time
#print("open_calls: " + str(open_calls))
except KeyError as err:
#print("KeyError: " + phone_num + "-" + otalo.date_str(current_date) + " " + otalo.time_str(current_time))
raise
except ValueError as err:
#print("ValueError: " + line)
continue
except IndexError:
continue
except otalo_utils.PhoneNumException:
#print("PhoneNumException: " + line)
continue
#flush the last week
flush_open_calls(durations, open_calls, current_week_start)
if not quiet:
if phone_num_filter:
print("Data for phone numbers: " + str(phone_num_filter))
print("Average call duration, by week (s):")
dates = durations.keys()
dates.sort()
secs = 0
calls = 0
for date in dates:
durs_by_call = durations[date]
durs = [dur[1].seconds for dur in durs_by_call]
secs += sum(durs)
calls += len(durs)
print(
date.strftime('%Y-%m-%d') + "\t" + str(sum(durs) / len(durs)))
if calls > 0:
print('Overall Average: ' + str(secs / calls))
return durations
def get_online_time(filename, destnum=False, phone_num_filter=False, date_start=False, date_end=False, quiet=False):
online_time = {}
current_day = 0
open_calls = {}
f = open(filename)
if phone_num_filter:
# every phone number has an entry
for num in phone_num_filter:
online_time[num] = 0
while(True):
line = f.readline()
if not line:
break
try:
#################################################
## Use the calls here to determine what pieces
## of data must exist for the line to be valid.
## All of those below should probably always be.
phone_num = otalo_utils.get_phone_num(line)
current_date = otalo_utils.get_date(line)
dest = otalo_utils.get_destination(line)
##
################################################
current_time = otalo_utils.get_time(line)
if phone_num_filter and not phone_num in phone_num_filter:
continue
if date_start:
if date_end:
if not (current_date >= date_start and current_date < date_end):
continue
if current_date > date_end:
break
else:
if not current_date >= date_start:
continue
if destnum and destnum.find(dest) == -1:
continue
if line.find("Start call") != -1:
# check to see if this caller already has one open
if phone_num in open_calls.keys() and current_time > open_calls[phone_num]['last']:
# close out current call
call = open_calls[phone_num]
del open_calls[phone_num]
dur = call['last'] - call['start']
#print("closing out call pre-emptively: " + phone_num + ", "+otalo_utils.date_str(current_date) + ", "+otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
if phone_num in online_time:
online_time[phone_num] += dur.seconds
else:
online_time[phone_num] = dur.seconds
# add new call
#print("adding new call: " + phone_num)
open_calls[phone_num] = {'start':current_time, 'last':current_time }
elif line.find("End call") != -1:
if phone_num in open_calls.keys():
# close out call
call = open_calls[phone_num]
dur = current_time - call['start']
#print("closing out call: "+phone_num + ", "+otalo_utils.date_str(current_date) + ", "+ otalo_utils.get_sessid(line) + ", duration: " + str(dur.seconds))
if phone_num in online_time:
online_time[phone_num] += dur.seconds
else:
online_time[phone_num] = dur.seconds
del open_calls[phone_num]
elif phone_num in open_calls:
#print("updating call dur: " + phone_num)
# this makes things conservative. A call is only officially counted if
# it starts with a call_started
open_calls[phone_num]['last'] = current_time
#print("open_calls: " + str(open_calls))
except KeyError as err:
#print("KeyError: " + phone_num + "-" + otalo.date_str(current_date) + " " + otalo.time_str(current_time))
raise
except ValueError as err:
#print("ValueError: " + line)
continue
except IndexError:
continue
except otalo_utils.PhoneNumException:
#print("PhoneNumException: " + line)
continue
#flush the last week
#flush_open_calls(online_time, open_calls, current_day)
if not quiet:
print("Total online time, by phone number (s):")
for num, tot in online_time.items():
print(num +"\t"+str(tot))
return online_time
