arithmomaniac / googlevoice-to-sqlite Goto Github PK

Most people do not have Python. Include a compiled, stand-alone executable in 
the downloads.

What steps will reproduce the problem?
1. Open googlevoice_to_sqlite.exe
2. Type in location "./voice/calls"
3. Press enter- program runs but only for 10 seconds before shutting down. Open 
up output file and it only has 147 records, and i've been using google voice 
for 3 years now...

What is the expected output? What do you see instead?
Thousands of rows of data. Only 147

What version of the product are you using? On what operating system?
Windows 7 32 bit and version 3.3

Please provide any additional information below.
Can you help out?

This should solve the Python dependency problem, as well as increase visibility.

Currently, a select(MAX) call is made upon every insert into the database to 
determine a row's primary key.

This can be stored as ints inside the gvoiceconn object itself.

Currently, the name of each file is printed on a new line.

We would like to use the fish module to show on the same line.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
No errors...

What version of the product are you using? On what operating system?
googlevoice_to_sqlite_v3.2.2_win32.zip

Please provide any additional information below.
C:\G2Sql>googlevoice_to_sqlite.exe
Specify the Calls file location (ends with "\Voice\Calls"): 
C:\Users\jxxx.TRANSIT\GoogleTakeout\Voice\Calls
Andrea_Pxxe_-_2012-03-17T02-44-47Z.htmlTraceback (most recent call last):
  File "googlevoice_to_sqlite.py", line 429, in <module>
  File "googlevoice_to_sqlite.py", line 382, in getobjs
  File "xml\etree\ElementTree.pyc", line 1301, in XML
  File "xml\etree\ElementTree.pyc", line 1643, in feed
  File "xml\etree\ElementTree.pyc", line 1507, in _raiseerror
xml.etree.ElementTree.ParseError: not well-formed (invalid token): line 152, 
column 38

After trying several times, I ended up deleting the GoogleTakeout files for 
this particular person....hoping that perhaps there was something about those 
files that was wrong.

On the next run...a new error was present:

C:\G2Sql>googlevoice_to_sqlite.exe
Specify the Calls file location (ends with "\Voice\Calls"): 
C:\Users\jcolpean.TRANSIT\GoogleTakeout\Voice\Calls
Dan_xxx_-_2011-07-20T22-20-27Z.htmlTraceback (most recent call last):
  File "googlevoice_to_sqlite.py", line 437, in <module>
  File "googlevoice_to_sqlite.py", line 330, in import_Audio
TypeError: 'NoneType' object has no attribute '__getitem__'

Add a "press enter to continue" dialog. Makes it easier to debug.

Script produces same error every time.
Tried both executable and python scripts.
Tried several different sets of text messages resulting in same error.



3.2.2
Running on Windows 7 Ultimate


   File "googlevoice_to_sqlite.py", line 430, in <module>
   File "googlevoice_to_sqlite.py", line 385, in getobjs
   File "googlevoice_to_sqlite.py", line 233, in process_file
AttributeError: 'NoneType' object has no attribute 'group'

Possibly the html format changed???

I would love to be able to convert these messages into a database to import 
them into android...

Have an option to export the database to a set of CSV files

As the GVoice files are HTML, some characters are escaped. These should be 
unescaped in all text fields before database insertion

This needs to be structured like a real Python package, with modules that 
neatly correspond to well-factored classes.

End goal is to be installable with easy_install.

Also, move to Githib because it's where all the action is :)

What steps will reproduce the problem?
1. Get a Google Takeout of your google voice
2. run the googlevoice-to-sqlite exe

What is the expected output? What do you see instead?
I get an error back.  I compared an older takeout zip and noticed that the 
timestamps have changed.  Here is one difference:

< <abbr class="published" title="2012-03-20T10:17:13.000-04:00">Mar 20, 2012 
10:17:13 AM
< Eastern Time</abbr>

---
> <abbr class="published" title="2012-03-20T14:17:13.000Z">Mar 20, 2012 7:17:13 
AM</abbr>

What version of the product are you using? On what operating system?
Jan 2012 version

Please provide any additional information below.

Appears that program chokes on some special chars.

Instead of matching just by name and phone number, try to find the contact who 
has those attributes, but was closest in time to the null record in question. 
This better accounts for contacts whose phone number changes over time.

What steps will reproduce the problem?
1. Ran script

What is the expected output? What do you see instead?
Database loaded.

What version of the product are you using? On what operating system?
Python 3.1 script

Please provide any additional information below.
After the first error, removed all mp3 files so there are only html files in 
the system. Still getting error.


contact_name - 2012-03-21T00-37-51Z.htmlTraceback (most recent call last):
  File "googlevoice_to_sqlite.py", line 81, in <module>
    if gvconn.import_Audio(record, False) == 1: #no contact for audio. Can happen if files have been renamed
  File "/Users/curtis/Downloads/googlevoice_to_sqlite_v3.1_python/gvoice_sql.py", line 96, in import_Audio
    callid = callidrow.fetchone()[0]
TypeError: 'NoneType' object is not subscriptable

10char

A misplaced tuple cell reference causes some contacts to be deleted from the 
database.

Until after enter is pressed. But then it's too late to download.

use setuptools?