How to calculate in/out minutes used per month?
QBZappy:
Quote from: giqcass on January 06, 2014, 03:12:09 am
I just found how to save from the Obi. I'm not sure if I feel like parsingo that xml mess in python or Java.
Another pain in the butt way.
The easiest way I have found is to open the call history xml file in excel. It results in nice columns of information which can then be further processed to determine other useful info like call duration, number of calls, (whatever) using the excel functions. No manual parsing is involved since excel parses it for you automatically.
giqcass:
Quote from: QBZappy on January 08, 2014, 08:28:21 pm
Quote from: giqcass on January 06, 2014, 03:12:09 am
I just found how to save from the Obi. I'm not sure if I feel like parsingo that xml mess in python or Java.
Another pain in the butt way.
The easiest way I have found is to open the call history xml file in excel. It results in nice columns of information which an then be further processed to determine other useful info like call duration, number of calls, (whatever) using the excel functions. No manual parsing is involved since excel parses it for you automatically.
My computer with Office on it is down right now so I was not able to import it with Excel. I tried importing it into Google drives spreadsheet program directly and that would not work. That's why I hacked the file into a CSV file. That imported into Google drive nicely. Then with a little spreadsheet magic I was able to pull out my totals. It was fun writing out those formulas above. I haven't done anything on a spreadsheet with nested logic in a while.
sdb-:
Quote from: giqcass on January 09, 2014, 01:17:11 pm
Quote from: QBZappy on January 08, 2014, 08:28:21 pm
The easiest way I have found is to open the call history xml file in excel.
My computer with Office on it is down right now so I was not able to import it with Excel. I tried importing it into Google drives spreadsheet program directly and that would not work.
Yeah, unless I take it in to work I'm not going to open it with Excel. I think the last Microsoft Office I had at home was 1997 and I trashed that in 2001 or 2002.
It didn't look usable when opened with LibreOffice Calc. So I used sed instead of manual editing for:
Quote from: giqcass
Find and replace the following
<CallHistory date=" with blank space
" time=" with ,
<Event time=" with ,
<e0> with ,
<e1> with ,
</CallHistory> with <BR>
"> with blank space
Code:
sed 's/<CallHistory date="/ /g; s/" time="/,/g; s/<Event time="/,/g; s/<e[01]>/,/g; s/<\/CallHistory>/<BR>/g; s/">/ /g' < dlfile.xml >newfile.txt
(that's not tested, just from qlcass' post like I did it the first time)
Robert.Thompson:
You can try this: http://www.obitalk.com/forum/index.php?topic=7188.0
Navigation
[0] Message Index
[*] Previous page