Script started on Tue Mar 24 06:47:55 2009 luke:~/tmp/mySQL-issue-2008.11.07-revisited dp2$ mv ~/Desktop/f47d.exe . luke:~/tmp/mySQL-issue-2008.11.07-revisited dp2$ unzip -q f47d.exe ; cp ../mySQL-issue-2008.11.07/processCSV.py . ; ls F47D.DBF F47D.csv f47d.exe processCSV.py run-2.log run1 steps luke:~/tmp/mySQL-issue-2008.11.07-revisited dp2$ scp -pqr processCSV.py F47D.csv dp2@172.16.0.10: Password: luke:~/tmp/mySQL-issue-2008.11.07-revisited dp2$ ssh dp2@172.16.0.10 Password: Last login: Tue Mar 24 06:19:16 2009 from 172.16.0.9 Macintosh:~ dp2$ mkdir -p /tmp/myTest ; cd /tmp/myTest/ Macintosh:myTest dp2$ python --version Python 2.5.1 Macintosh:myTest dp2$ ps auxw | grep -i mysql dory 5032 0.0 0.1 170532 1540 ?? Ss 16Mar09 0:00.37 /Applications/Adobe Acrobat 7.0 Professional/Adobe Acrobat 7.0 Professional.app/Contents/MacOS/mysqld --skip-networking --socket=/Users/dory/Library/Caches/Acrobat/7.0/Organizer70 --skip-grant-tables --skip-innodb --myisam-recover --lower_case_table_names=1 --tmpdir=/Users/dory/Library/Caches/Acrobat/7.0/ --datadir=/Users/dory/Library/Acrobat User Data/7.0/ --language=/Applications/Adobe Acrobat 7.0 Professional/Adobe Acrobat 7.0 Professional.app/Contents/MacOS/ dory 446 0.0 0.1 167948 1764 ?? Ss 15Mar09 0:20.65 /Applications/Adobe Acrobat 7.0 Professional/Adobe Acrobat 7.0 Professional.app/Contents/MacOS/mysqld --skip-networking --socket=/Users/dory/Library/Caches/Acrobat/7.0/Organizer70 --skip-grant-tables --skip-innodb --myisam-recover --lower_case_table_names=1 --tmpdir=/Users/dory/Library/Caches/Acrobat/7.0/ --datadir=/Users/dory/Library/Acrobat User Data/7.0/ --language=/Applications/Adobe Acrobat 7.0 Professional/Adobe Acrobat 7.0 Professional.app/Contents/MacOS/ _mysql 158 0.0 0.2 637088 4080 ?? S 15Mar09 5:38.53 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/Macintosh.local.pid root 122 0.0 0.0 600172 500 ?? S 15Mar09 0:00.02 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/Macintosh.local.pid dp2 84901 0.0 0.0 599700 368 s001 R+ 6:49AM 0:00.00 grep -i mysql Macintosh:myTest dp2$ cp -pv ~/F47D.csv /tmp/ ; cp -pv ~/processCSV.py . ; ls /Users/dp2/F47D.csv -> /tmp/F47D.csv /Users/dp2/processCSV.py -> ./processCSV.py F47D.csv processCSV.py Macintosh:myTest dp2$ ./processCSV.py > _my.sql ./processCSV.py:25: DeprecationWarning: The sre module is deprecated, please import re. import csv, formatter, htmllib, os, pdb, sre, sys, urllib, urllib2 Macintosh:myTest dp2$ mysql -u root -p < _my.sql Enter password: Macintosh:myTest dp2$ mysql -u root -p housing -e "select count(*) from stats; select * from stats limit 0,5" Enter password: +----------+ | count(*) | +----------+ | 11851 | +----------+ +----+----------+--------------------------------+----------------------------+---------------+------------+----------+-----------+------------+------------+----------------+------------+------------+---------+----------+--------------+----------------+----------------------------+------------------+------------+----------------------------+------------------+------------+------+--------------------------------------------------------+------+ | id | proj_num | proj_name | proj_str | prop_city | prop_state | proj_zip | units | ini_end | fin_end | mort_amt | fstpay_dt | matur_dt | term_mo | int_rate | curr_pi | amort_upb | hold_name | hold_city | hold_state | serv_name | serv_city | serv_state | soa | soa_sect | te | +----+----------+--------------------------------+----------------------------+---------------+------------+----------+-----------+------------+------------+----------------+------------+------------+---------+----------+--------------+----------------+----------------------------+------------------+------------+----------------------------+------------------+------------+------+--------------------------------------------------------+------+ | 1 | 00010010 | Collinswood Nursing Home | 299 Hurley Avenue | Rockville | M | 2085 | 160.00000 | 2008-05-21 | 0000-00-00 | 482700.00000 | 1909-02-01 | 1942-01-01 | 39 | 6.95000 | 3109.71000 | 482700.00000 | Wells Fargo Bank Na | Mc Lean | V | Wells Fargo Bank Na | Mc Lean | V | Zs | 241(a)/ 232 /improvements & Additions / Nursing Homes | | | 2 | 00010011 | Shady Grove Adventist Nursing | 9701 Medical Center Drive | Rockvlle | M | 2085 | 170.00000 | 2008-04-04 | 2008-04-04 | 1170000.00000 | 2008-06-01 | 1936-05-01 | 33 | 5.95000 | 7160.10000 | 1164524.04000 | Ziegler Financing Corp | New Albany | O | Ziegler Financing Corp | New Albany | O | Zs | 241(a)/ 232 /improvements & Additions / Nursing Homes | | | 3 | 00011156 | Mill Creek Apts | 17654 Amity Dr | Gaithersburg | M | 2087 | 138.00000 | 1996-09-30 | 1996-09-30 | 4320600.00000 | 1996-11-01 | 1931-10-01 | 42 | 8.00000 | 30687.53000 | 3872466.29000 | Wells Fargo Bank Na | Mc Lean | V | Wells Fargo Bank Na | Mc Lean | V | Re | 223(a)(7)/207/223(f) Refinanced Insurance | | | 4 | 00011161 | Willowbrook Apartments | 8100 15th Avenue | Hyattsville | M | 2078 | 590.00000 | 1997-05-01 | 1997-05-01 | 19734600.00000 | 1997-07-01 | 1932-06-01 | 42 | 7.90000 | 138736.00000 | 17826188.74000 | Wells Fargo Bank Na | Mc Lean | V | Wells Fargo Bank Na | Mc Lean | V | Re | 223(a)(7)/207/223(f) Refinanced Insurance | | | 5 | 00011170 | Gwen Forest Apartments | 1820 Irving Street Ne | Washington | D | 2001 | 15.00000 | 1998-11-30 | 1998-11-30 | 311500.00000 | 1999-01-01 | 1928-12-01 | 36 | 7.65000 | 2210.14000 | 272676.37000 | Midland Loan Services Inc | Shawnee Mission | K | Midland Loan Services Inc | Shawnee Mission | K | Hr | 207/ 223(f) Pur/ Refin Hsg. | | +----+----------+--------------------------------+----------------------------+---------------+------------+----------+-----------+------------+------------+----------------+------------+------------+---------+----------+--------------+----------------+----------------------------+------------------+------------+----------------------------+------------------+------------+------+--------------------------------------------------------+------+ Macintosh:myTest dp2$ head -n 5 /tmp/.F47D.csv 00010010, Collinswood Nursing Home, 299 Hurley Avenue, Rockville, MD, 20850, 160, 2008-05-21, , 482700, 1909-02-01, 1942-01-01, 396, 6.95, 3109.71, 482700, Wells Fargo Bank Na, Mc Lean, VA, Wells Fargo Bank Na, Mc Lean, VA, Zsq, 241(a)/ 232 /improvements & Additions / Nursing Homes, 00010011, Shady Grove Adventist Nursing, 9701 Medical Center Drive, Rockvlle, MD, 20850, 170, 2008-04-04, 2008-04-04, 1170000, 2008-06-01, 1936-05-01, 336, 5.95, 7160.1, 1164524.04, Ziegler Financing Corp, New Albany, OH, Ziegler Financing Corp, New Albany, OH, Zsq, 241(a)/ 232 /improvements & Additions / Nursing Homes, 00011156, Mill Creek Apts, 17654 Amity Dr, Gaithersburg, MD, 20879, 138, 1996-09-30, 1996-09-30, 4320600, 1996-11-01, 1931-10-01, 420, 8, 30687.53, 3872466.29, Wells Fargo Bank Na, Mc Lean, VA, Wells Fargo Bank Na, Mc Lean, VA, Rek, 223(a)(7)/207/223(f) Refinanced Insurance, 00011161, Willowbrook Apartments, 8100 15th Avenue, Hyattsville, MD, 20783, 590, 1997-05-01, 1997-05-01, 19734600, 1997-07-01, 1932-06-01, 420, 7.9, 138736, 17826188.74, Wells Fargo Bank Na, Mc Lean, VA, Wells Fargo Bank Na, Mc Lean, VA, Rek, 223(a)(7)/207/223(f) Refinanced Insurance, 00011170, Gwen Forest Apartments, 1820 Irving Street Ne, Washington, DC, 20018, 15, 1998-11-30, 1998-11-30, 311500, 1999-01-01, 1928-12-01, 360, 7.65, 2210.14, 272676.37, Midland Loan Services Inc, Shawnee Mission, KS, Midland Loan Services Inc, Shawnee Mission, KS, Hri, 207/ 223(f) Pur/ Refin Hsg., Macintosh:myTest dp2$ head -n 5 /tmp/F47D.csv 'PROJ_NUM,C,8','PROJ_NAME,C,30','PROJ_STR,C,30','PROP_CITY,C,19','PROP_STATE,C,2','PROJ_ZIP,C,5','UNITS,N,19,5','INI_END,D','FIN_END,D','MORT_AMT,N,19,5','FSTPAY_DT,D','MATUR_DT,D','TERM_MO,C,3','INT_RATE,N,19,5','CURR_PI,N,19,5','AMORT_UPB,N,19,5','HOLD_NAME,C,30','HOLD_CITY,C,19','HOLD_STATE,C,2','SERV_NAME,C,30','SERV_CITY,C,19','SERV_STATE,C,2','SOA,C,3','SOA_SECT,C,100','TE,C,254' '00010010','COLLINSWOOD NURSING HOME','299 HURLEY AVENUE','ROCKVILLE','MD','20850',160,05/21/08,,482700,02/01/09,01/01/42,'396',6.95,3109.71,482700,'WELLS FARGO BANK NA','MC LEAN','VA','WELLS FARGO BANK NA','MC LEAN','VA','ZSQ','241(a)/ 232 /Improvements & Additions / Nursing Homes', '00010011','SHADY GROVE ADVENTIST NURSING','9701 MEDICAL CENTER DRIVE','ROCKVLLE','MD','20850',170,04/04/08,04/04/08,1170000,06/01/08,05/01/36,'336',5.95,7160.1,1164524.04,'ZIEGLER FINANCING CORP','NEW ALBANY','OH','ZIEGLER FINANCING CORP','NEW ALBANY','OH','ZSQ','241(a)/ 232 /Improvements & Additions / Nursing Homes', '00011156','MILL CREEK APTS','17654 AMITY DR','GAITHERSBURG','MD','20879',138,09/30/96,09/30/96,4320600,11/01/96,10/01/31,'420',8,30687.53,3872466.29,'WELLS FARGO BANK NA','MC LEAN','VA','WELLS FARGO BANK NA','MC LEAN','VA','REK','223(a)(7)/207/223(f) Refinanced Insurance', '00011161','WILLOWBROOK APARTMENTS','8100 15TH AVENUE','HYATTSVILLE','MD','20783',590,05/01/97,05/01/97,19734600,07/01/97,06/01/32,'420',7.9,138736,17826188.74,'WELLS FARGO BANK NA','MC LEAN','VA','WELLS FARGO BANK NA','MC LEAN','VA','REK','223(a)(7)/207/223(f) Refinanced Insurance', Macintosh:myTest dp2$ logout Connection to 172.16.0.10 closed. luke:~/tmp/mySQL-issue-2008.11.07-revisited dp2$ exit Script done on Tue Mar 24 06:51:22 2009