menuimage

Description

Usage

Example

Options

Exit_Codes

Dependencies

License

Changelog

Download

My_Other_Sites

My_Programs

Comments

vodafone-compile-bills v1.07 [15 Mar 2016] by Dominic

Description

A bash program for GNU/Linux which processes downloaded Vodafone [UK] itemised call records. First you need to log in at https://www.vodafone.co.uk and then download (manually, sorry) by phone and by month, saving the files with the name format shown below at directory_for_input_output.

vodafone-compile-bills.sh then converts and combines all the files found at this directory into a single csv file and moreover creates numeric values for call duration in minutes and (for internet) MB used, and additional fields showing country of origin (Country) and minutes subject to minimum of 1 (Duration1; to match Vodafone's way of counting bundled minutes). The resulting file can be loaded into a spreadsheet program such as Excel and then easily manipulated, for example with a pivot table, to analyse usage.

If you create a file called vodafone-compile-bills.names in the directory_for_input_output with a list of phone numbers (no spaces) and then for each number a comma and the name of the user, this 'Name' field is appended to the output. Here is an example vodafone-compile-bills.names file:

077123456789,Peter
077234567890,Jemima

To obtain the original csv data files from Vodafone UK Business (process for personal accounts is fairly similar):
- log in to your account at www.vodafone.co.uk,
- click on 'View bills'
- on left-hand side click on 'View bills',
- you may need to click on 'Billed usage' tab,
- select 'Itemisation' from dropdown (under tabs), then click 'Go',
- repeat as often as required: {
-- select the required phone number and invoice date on right
-- click 'Go' and wait for all data to load including info on right of screen
-- click on download icon (to right of 'Itemisation' dropdown: a red down arrow and sheet of paper)
-- save in your chosen directory_for_input_output as filename:
--- '[phonenumber_without_spaces] yyyy-mm.csv',
--- e.g. 07771234567 2016-03.csv
--- (if bill covers more than one month, for filename use year and month of end of billing period)
}

Output file is directory_for_input_output/vodafone-compile-bills.csv

Usage

vodafone-compile-bills.sh [options] directory_for_input_output

Example

./vodafone-compile-bills.sh /home/user3/Documents

Options

-h - show this help and exit
-l - show changelog and exit

Exit Codes

99 - unable to process data, see error text for more information
1+ - number of errors encountered when processing data

Dependencies

awk, bash, basename, fold, grep, sed, stty

License

Copyright © 2017 Dominic Raferd. Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at https://www.apache.org/licenses/LICENSE-2.0. Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Changelog

1.07 [15 Mar 2016] - was not locating NAMEFILE correctly, fixed
1.06 [08 Aug 2012] - correction for zero notional cost of some outgoing texts
1.06 [25 Jul 2012] - correct identification of some internet items
1.05 [17 Jul 2012] - some help text corrections
1.04 [25 Mar 2012] - some bug fixes, add .names file
1.03 [30 Jan 2012] - add checks, and visual output, for number of calls
1.02 [16 Jan 2012] - some bugfixes, add -l option
1.01 [11 Jan 2012] - some bugfixes
1.00 [10 Jan 2012] - original release

Download vodafone-compile-bills.sh

My Other Sites

My Programs

Here is a selection of some (other) programs I have written, most of which run from the command line (CLI), are freely available and can be obtained by clicking on the links. Dependencies are shown and while in most cases written for a conventional Linux server, they should run even on a Raspberry Pi, and many can run under Windows using Cygwin. Email me if you have problems or questions, or if you think I could help with a programming requirement.

Backup Utilities

Debian/Ubuntu kernel and LVM Utilities

Dellmont / Three / Giffgaff / Vodafone - VoIP and Mobile Phone Account Utilities

Miscellaneous Programs

Comments

No comments yet
*Name:
Email:
Hide my email
*Text:
 
Powered by Scriptsmill Comments Script