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.
#!/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.
