Simple python script used to convert dbf files to csv.
Usage:
python dbf2csv.py INPUT.dbf OUTPUT.csv PAGE_SIZE
PAGE_SIZE is optional
Number of records to include in each file.
This can be used to avoid very large files.
It splits the output in multiple files named OUTPUT.0.csv, OUTPUT.1.csv, OUTPUT.2.csv, OUTPUT.3.csv, etc..
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001220s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.060040s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001005s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001178s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001087s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003150s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000873s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003820s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.021124s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001512s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 86365 [ RunTime:0.015294s ]
