Posts

Showing posts from December, 2014

How to use import-gvhistory script to parse Google Voice data from Takeout and export it to a .csv file

I recently posted the import-gvhistory powershell script that I wrote, which parses the html files provided by Google Takeout when downloading data from a Google Voice account.  Below are step by step instructions on how to use the script. Note: The link below to HTML Agility Pack goes to a codeplex page where you can download version 1.46.  There is a note at the top of the page that the latest version is available from NuGet.  Currently, the version on NuGet is 1.4.9.  Either of those versions will work, so for simplicity I recommend you just click the big purple download button and get v1.4.6 if you aren't already familiar with NuGet. Download your Google Voice data using Google Takeout . Extract the the zip file to c:\temp or another path of your choosing.  **Windows 7 Users** Download and install WMF4  to update Powershell to 4.0 Download the HTML Agility Pack , unzip the file, open the NET45 folder inside, and copy HtmlAgilityPack.dll the same folder.  For example,

import-gvhistory: Export Google Voice SMS/Text Messages and Call logs to CSV using Powershell

Here is a script I wrote to parse the thousands of HTML files produced by Google Takeout when exporting Google Voice data.  This script parses the html files to gather the Contact Name, Number, time, type (Placed/received etc), duration, and (text/voicemail) message contents for every phone call and text message, and outputs them as a powershell object which can be further filtered or manipulated and then exported into a csv or other format as needed. Basic examples of how to use this script are included in the script comments.  If you download the script and have trouble, or if it works perfectly, please leave a comment and let me know. **Update 12/20/2014** I've just posted step by step instructions for how to use the script.. **Update 11/16/2015** The script has been updated due to a change in how Google Takeout exports the timestamps.