This is a parser that will convert a Google Exports Voice archive into a TSV

Usage

Requires the Mojo::DOM module to be installed:

cpan install Mojo::DOM

Will dump the parsed message to STDOUT as .tsv

./calls_parse.pl 1112223333 Calls/ > allmessages.tsv

Where 1112223333 is your phone number.

To import into SQLite:

sqlite3 allmessages.db <<SQL
create table if not exists messages (date text, diretion text, sender text, message text);
.mode tabs messages
.import allmessages.tsv messages
SQL

TODO

• Comment more
• Refactor to be a cleaner FSM
• Convert HTML entities to their ASCII or Unicode equivilents, like '

As of 2020-02-10, parser still works.