RULES USE TOOL : 1. Program must use not less 2 input parameters (else will openned page for show help content) 2. Two first parameters must will as : - 1-parameter is value ShowMode, where possible values : SW_HIDE (hide tool for view), SW_MAXIMIZE, SW_MINIMIZE, SW_RESTORE, SW_SHOW (show form tool), SW_SHOWDEFAULT, SW_SHOWMAXIMIZED, SW_SHOWMINIMIZED, SW_SHOWMINNOACTIVE, SW_SHOWNA, SW_SHOWNOACTIVATE, SW_SHOWNORMAL (by default you can use SW_SHOW or SW_HIDE) - 2-parameter is name function, where possible values : GetStructureTables (prepare structure file), CheckStructureFile (checking structure file), ConvertFileInCSV (convert as CSV file), ConvertFileInMYSQL (convert as SQL script), help 3. All other additionasl parameters depend from called function 4. Additional parameters with values must use as "nameparameter=valueparameter" ---- Function "GetStructureTables" - save structure selected table(s) in INI file 1. List additional parameters (in case not use any from parameters will use value by default) : pathmysql -> path to mysql.exe tool [MANDATORY] outputfolder -> folder where will save INI files (by default folder where placed program) [MANDATORY] createonlymissedfiles -> 1/0, flag to checking and creating only not existing file(s) (by default = 1, that mean create only unexisting file(s)) [OPTIONAL] server -> IP or domain name to Mysql server [MANDATORY] port -> port number, by default = 3306 [OPTIONAL] database -> name database [MANDATORY] user -> Mysql name user [MANDATORY] password -> user password [MANDATORY] nametable -> name table(s) for which need prepare INI files, sample : "001" or "100|120|555" (in case several tables separator between tables must will "|"). Possible tables "001|002|003|004|005|006|007|008|009|010|011|012|013|014|015|016|017|018|019|020|021|022|023|024|025|026|027|028|029|030|031|032|033|034|035|036|037|038|039|040|041|042|043|044|045|046|047|048|049|050|051|052|053|054|055|056|057|058|059|060|061|062|063|064|065|066|067|068|069|070|071|072|073|074|075|076|077|078|079|080|081|082|083|084|085|086|087|088|089|090|091|092|093|094|095|096|097|098|099|100|101|102|103|104|105|106|107|108|109|110|111|112|113|114|115|116|117|118|119|120|121|122|123|124|125|126|127|128|129|130|131|132|133|134|135|136|137|138|139|140|141|142|143|144|145|146|147|148|149|150|151|152|153|154|155|156|157|158|159|160|161|162|163|164|165|166|167|168|169|170|171|172|173|174|175|176|177|178|179|180|181|182|183|184|185|186|187|188|189|190|191|192|193|194|195|196|197|198|199|200|201|202|203|204|205|206|207|208|209|210|211|212|213|214|215|216|217|218|219|220|221|222|223|224|225|226|227|228|229|230|231|232|233|234|235|236|237|238|239|240|241|242|243|244|245|246|247|248|249|250|251|252|253|254|255|256|257|258|259|260|261|262|263|264|265|266|267|268|269|270|271|272|273|274|275|276|277|278|279|280|281|282|283|284|285|286|287|288|289|290|291|292|293|294|295|296|297|298|299|300|301|302|303|304|305|306|307|308|309|310|311|312|313|314|315|316|317|318|319|320|321|322|323|324|325|326|327|328|329|330|331|332|333|334|335|336|337|338|339|340|341|342|343|344|345|346|347|348|349|350|351|352|353|354|355|356|357|358|359|360|361|362|363|364|365|366|367|368|369|370|371|372|373|374|375|376|377|378|379|380|381|382|383|384|385|386|387|388|389|390|391|392|393|394|395|396|397|398|399|400|401|402|403|404|405|406|407|408|409|410|411|412|413|414|415|416|417|418|419|420|421|422|423|424|425|426|427|428|429|430|431|432|433|434|435|436|437|438|439|440|441|442|443|444|445|446|447|448|449|450|451|452|453|454|455|456|457|458|459|460|461|462|463|464|465|466|467|468|469|470|471|472|473|474|475|476|477|478|479|480|481|482|483|484|485|486|487|488|489|490|491|492|493|494|495|496|497|498|499|500|501|502|503|504|505|506|507|508|509|510|511|512|513|514|515|516|517|518|519|520|521|522|523|524|525|526|527|528|529|530|531|532|533|534|535|536|537|538|539|540|541|542|543|544|545|546|547|548|549|550|551|552|553|554|555|556|557|558|559|560|561|562|563|564|565|566|567|568|569|570|571|572|573|574|575|576|577|578|579|580|581|582|583|584|585|586|587|588|589|590|591|592|593|594|595|596|597|598|599|600|601|602|603|604|605|606|607|608|609|610|611|612|613|614|615|616|617|618|619|620|621|622|623|624|625|626|627|628|629|630|631|632|633|634|635|636|637|638|639|640|641|642|643|644|645|646|647|648|649|650|651|652|653|654|655|656|657|658|659|660|661|662|663|664|665|666|667|668|669|670|671|672|673|674|675|676|677|678|679|680|681|682|683|684|685|686|687|688|689|690|691|692|693|694|695|696|697|698|699|700|701|702|703|704|705|706|707|708|709|710|711|712|713|714|715|716|717|718|719|720|721|722|723|724|725|726|727|728|729|730|731|732|733|734|735|736|737|738|739|740|741|742|743|744|745|746|747|748|749|750|751|752|753|754|755|756|757|758|759|760|761|762|763|764|765|766|767|768|769|770|771|772|773|774|775|776|777|778|779|780|781|782|783|784|785|786|787|788|789|790|791|792|793|794|795|796|797|798|799|800|801|802|803|804|805|806|807|808|809|810|811|812|813|814|815|816|817|818|819|820|821|822|823|824|825|826|827|828|829|830|831|832|833|834|835|836|837|838|839|840|841|842|843|844|845|846|847|848|849|850|851|852|853|854|855|856|857|858|859|860|861|862|863|864|865|866|867|868|869|870|871|872|873|874|875|876|877|878|879|880|881|882|883|884|885|886|887|888|889|890|891|892|893|894|895|896|897|898|899|900|901|902|903|904|905|906|907|908|909|910|911|912|913|914|915|916|917|918|919|920|921|922|923|924|925|926|927|928|929|930|931|932|933|934|935|936|937|938|939|940|941|942|943|944|945|946|947|948|949|950|951|952|953|954|955|956|957|958|959|960|961|962|963|964|965|966|967|968|969|970|971|972|973|974|975|976|977|978|979|980|981|982|983|984|985|986|987|988|989|990|991|992|993|994|995|996|997|998|999", by default all tables [OPTIONAL] 2. Sample request for use in CMD/BATH file "TAFConvertor.exe" SW_SHOW GetStructureTables "pathmysql=c://PATH_TO_MYSQL/mysql.exe" "server=localhost" "database=TECDOCDATABASE" "user=NAMEUSER" "password=USERPASSWORD" 3. Notes : - you must have installed mysql.exe tool (https://dev.mysql.com/downloads/installer/) - on Mysql server must will created Tecdoc TAF tables (ask structure tables http://tec-doc-services.com/index.html#footer1-9) - in folder "outputfolder" will save INI file with description structure tables, name files will use name of tables (here http://tec-doc-services.com/download/INI_TAF24_structure.7z you can also download ready INI files) ---- Function "CheckStructureFile" - checking file (that will use for convert) on the correctness of the data structure in file 1. List additional parameters (in case not use any from parameters will use value by default) : inputfile -> path to binary TAF file or path to arhived file (7z format) from Tecdoc supplier (in this case arhived file will unzipped in temp folder) [MANDATORY] tempfolder -> temp folder that will use in case checking arhived input file, there program will create additional folder with name as IDThread, by default temp folder use path where placed program [OPTIONAL] inifolder -> folder where placed INI files, by default folder where placed program [MANDATORY] logresult -> path to file where will save path to successul checked files (each path to file in separate line) [MANDATORY] path7z -> path to 7z tool [OPTIONAL | MANDATORY only in case use arhived input file] 2. Sample request for use in CMD/BATH file "TAFConvertor.exe" SW_SHOW CheckStructureFile "inputfile=C://PATH_TO_FORLER_WITH_TAF_FILES/200.0001" "inifolder=C://PATH_TO_FOLDER_WITH_INI_FILES/" "logresult=C://PATH_TO_FILE_WHERE_WILL_SAVE_LIST_SUCCESSFULL_CHECKED_FILES" 3. Notes : - you must have installed 7z tool (https://www.7-zip.org/download.html) in case use arhived files - in folder "inifolder" must will placed INI file with description structure tables, that can created with help function "GetStructureTables" (here http://tec-doc-services.com/download/INI_TAF24_structure.7z you can also download ready INI files) ---- Function "ConvertFileInCSV" - convert input file in CSV format 1. List additional parameters (in case not use any from parameters will use value by default) : inputfile -> path to input binary TAF file [MANDATORY] outputfile -> path to output CSV file that will generate [MANDATORY] inifolder -> folder where placed INI files, by default folder where placed program [MANDATORY] uselimit -> values in case divide file on necessary count lines, for example value = 100000 mean that in files will save not more this count lines and will create separate files where in name files will added additional sort number 1...xxx, by default = 0 and mean without divide [OPTIONAL] logresult -> path to file where will save log convertions input file and log saved output file(s) [OPTIONAL] progress -> path to file where will save log progress conversion input file [OPTIONAL] tableseparator -> symbol table separator, by default as ";" [OPTIONAL] addheadercolumns -> create [1]/not create [0] first line with name of columns, by default as "1" [OPTIONAL] 2. Sample request for use in CMD/BATH file "TAFConvertor.exe" SW_SHOW ConvertFileInCSV "inputfile=C://PATH_TO_FORLER_WITH_TAF_FILES/200.0001" "outputfile=C://PATH_TO_FORLER_FR_SAVE_FILES/200.0001.csv" "inifolder=C://PATH_TO_FOLDER_WITH_INI_FILES/" 3. Notes : - in folder "inifolder" must will placed INI file with description structure tables that was created with help function "GetStructureTables" (here http://tec-doc-services.com/download/INI_TAF24_structure.7z you can also download ready INI files) ---- Function "ConvertFileInMYSQL" - convert input file in SQL script for import in Mysql tables 1. List additional parameters (in case not use any from parameters will use value by default) : inputfile -> path to input binary TAF file [MANDATORY] outputfile -> path to output SQL file that will generate [MANDATORY] inifolder -> folder where placed INI files, by default folder where placed program [MANDATORY] uselimit -> count nested grouped lines for import in one transaction, by default = 10000 that mean that will generate file with lines for import 10000 lines in each transaction [OPTIONAL] useingnore = use IGNORE in query INSERT INTO, by default = 0 that mean without IGNORE, in case = 1 then this mean with IGNORE [OPTIONAL] logresult -> path to file where will save log convertions input file and log saved output file [OPTIONAL] progress -> path to file where will save log progress conversion input file [OPTIONAL] 2. Sample request for use in CMD/BATH file "TAFConvertor.exe" SW_SHOW ConvertFileInMYSQL "inputfile=C://PATH_TO_FORLER_WITH_TAF_FILES/200.0001" "outputfile=C://PATH_TO_FORLER_FR_SAVE_FILES/200.0001.sql" "inifolder=C://PATH_TO_FOLDER_WITH_INI_FILES/" 3. Notes : - in folder "inifolder" must will placed INI file with description structure tables that was created with help function "GetStructureTables" (here http://tec-doc-services.com/download/INI_TAF24_structure.7z you can also download ready INI files) ----