REPORTING! REPORTING! REPORTING! Easy and MUST have feature
RFord:
I can't believe someone would be bit*hing about using a free service for business purposes, a want OBiHAI to bend over backwards to meet their needs. They are a large number of paid VOIP Providers that provide this data. You are too cheap and think people owe you something. In case you are not aware, GV was never design to be a free phone service, much less to be used by a business enterprise to avoid the cost of a phone service.
Dude, you need to go pay for service for your business instead of trying to "mooch" off Google Voice. Lastly, if you sign into GV, the call history for each DID is clearly available for all inbound/outbound calls, with the data in the form that your require. I hope you now ignored with your unreasonable request.....you make be want to puke!
Stewart:
Although I agree with RFord that your request is unreasonable, I wrote a simple perl script to format the output from Google Takeout as a CSV file. Feel free to modify it as you desire, but if you fix bugs or add features, please post the modified script, so others can use it.
On Windows, if you don't have perl installed, download a free copy from ActiveState at http://www.activestate.com/activeperl/downloads . On Mac or Linux, the preinstalled perl should be fine.
Before running the script, your current path should be the 'voice' folder from Takeout, i.e. a command to list files should show the 'conversations' folder. If successful, the script will write a calls.csv file in the current path.
Code:
#!/usr/bin/perl -w
$ncalls = 0;
$path = "conversations";
opendir(DIR, $path) or die "can't open $path folder";
open(OUT, ">calls.csv") or die "can't write CSV file";
print OUT "Date,Type,User,Number,Duration\n";
for $fname (readdir(DIR)) {
next unless $fname =~ /\.html$/ && open(IN, "$path\/$fname");
$date = $type = $user = $number = $duration = '';
while (<IN>) {
$user = <IN>, $user =~ s/<.+\n// if /Call Log for/;
$type = $1 if />(Placed|Received|Missed|Voicemail) (call |from)/;
$number = $1 if /tel:\+(\d+)/;
$date = $1 if />([\w,: ]+)<\/abbr>/;
$duration = '00:00:00' if $type eq 'Missed' && $date;
$duration = $1 if />\(([\d:]+)\)<\/abbr>/;
if ($duration) {
print OUT "\"$date\",$type,\"$user\",$number,$duration\n";
++$ncalls;
last;
}
}
}
print "processed $ncalls calls\n";
In return for this free software, please report some details about each of your eight OBi installations, which will be useful to the community:
1. City and country where installed.
2. ISP, type of connection (DSL, cable, FTTH, etc.) and speed.
3. Service providers configured, if any, other than Google Voice.
4. Any quality issues experienced, e.g. choppy outbound voice.
5. Any reliability issues experienced, e.g. incoming doesn't always ring phone, dropped calls, etc.
6. Any functionality issues, e.g. message waiting indication doesn't work correctly.
7. Any other problems, e.g. GV charging for calls to US.
8. Action taken that successfully corrected any of the above issues.
If in the future, you deploy additional OBi devices in new countries, I would appreciate it if you would also post this information about the new units.
QBZappy:
With that volume of calls, the geography involved, and the attitude, it sounds like yorktown might be in the telemarketing business. I'm sure that we all love these people. Before being too helpful it might be interesting to know what kind of business we are advising on.
Stewart:
Quote from: QBZappy on April 18, 2012, 12:16:58 pm
... it sounds like yorktown might be in the telemarketing business.
While it's likely some kind of sales or service function, one would be nuts to attempt classical telemarketing with OBi and GV. For starters, the agents would be spending more than half their time dialing calls, waiting for setup and answer, and getting voicemail. Virtually all telemarketers use predictive dialers, so agents spend >90% of their time talking to people. Also, GV does not provide outbound CNAM, which would cause many prospects to ignore the call. Finally, GV does not support Early Media, so instead of hearing that a number is not in service or has been changed, the agent wastes time hearing ring-no-answer, and may waste more time retrying the number at a later date.
QBZappy:
Stewart,
Not saying that it is not a legit business, however keep in mind that GV numbers are disposable and can be setup from any location on the planet. Illicit telemarketers are known to have used disposable prepaid cell phones to make their calls. This is the same technique, just different technologies.
Navigation
[0] Message Index
[#] Next page
[*] Previous page