python - Batch converting Corel Paradox 4.0 Tables to CSV/SQL -- via PHP or other scripts -
python - Batch converting Corel Paradox 4.0 Tables to CSV/SQL -- via PHP or other scripts -
recently i've begun working on exploring ways convert 16k corel paradox 4.0 database tables (my client has been using legacy platform on 20 years due massive logistical matters) more modern formats (i.e.csv, sql, etc.) en mass , far i've been looking @ php since has library devoted paradox info processing while i'm confident in how write conversion code (i.e. calling few file open, close, , write functions) i'm concerned error detection , ensuring when running script, don't spend hours waiting run see 16k corrupt files exported.
also, i'm not sure logic loop calling files. i'm thinking of having programme generate list of files appropriate extension , looping through list, i'm not sure if that's ideal directory of size.
this beingness run on local windows 7 x64 scheme xampp setup (the database internal use) i'm not sure if pure php best thought -- i've been wondering if python or other lightweight scripting language might improve handling this.
thanks much in advance insights , assistance,
if intend convert info guess process 1 time run script locally command script. don't need web site , xampp. language take secondary except php has library. python or others have one?
about concern of error detection why not test script 1 file first. if conversion successful can build loop , test on maybe 5 files, i.e. have counter ends process after number. still okay can go on rest. can write log info , dump result every 100 files processed. way can see if script doing or idling.
php python mysql xampp php-gtk
Comments
Post a Comment