SQLite format 3@ 0.G    V :  { N {J##=tableconfigspecsconfigspecsCREATE TABLE configspecs ( sub_var text not null, prompt text not null, initial_value text, entry_type text, width integer, validation_regex text, sequence integer, constraint pk_conf primary key (sub_var) )2P'''viewimport_configimport_configCREATE VIEW import_config as select cs.* from configspecs cs inner join configusage cu on cu.sub_var = cs.sub_var where usage = 'Import'5MI#indexsqlite_autoindex_configusage_1configusage 1 5KI#indexsqlite_autoindex_configspecs_1configspecs >O--3viewallbutdao_configallbutdao_configCREATE VIEW allbutdao_config as select cs.* from configspecs cs inner join configusage cu on cu.sub_var = cs.sub_var where usage = 'AllButDAO' L##tableconfigusageconfigusageCREATE TABLE configusage ( usage text not null, sub_var text not null, constraint pk_usage primary key (usage, sub_var) )2Q'''viewexport_configexport_configCREATE VIEW export_config as select cs.* from configspecs cs inner join configusage cu on cu.sub_var = cs.sub_var where usage = 'Export'&N!!viewall_configall_configCREATE VIEW all_config as select cs.* from configspecs cs inner join configusage cu on cu.sub_var = cs.sub_var where usage = 'All' T+ ^    + I f  : ^)g ##~scan_linesNumber of lines of a text file to scan for delimiters during import100[1-9][0-9]* a !+~dao_flushDelay, in seconds, between use of DAO and ODBC with Access5.0[0-9]*\.?[0-9]+L+Y#~console_heightApproximate height of a console window25[1-9][0-9]*<\ /}~replace_newlinesNewlines in imported data will be replaced with a space.0checkbox z =Y~hdf5_lenLength of text columns for HDF5 output1000M'i~log_datavarsWrite data variable assignments to execsql.log1checkboxa + ~write_warningsWrite warning messages to the console as well as to execsql.log0checkbox>'K~only_stringsImport all data columns as text0checkbox ?U!~log_writeEcho all output of the 'write' metacommand to execsql.log0checkboxT/o~console_wait_errLeave execsql's console open when an error occurs0checkboxX1u~console_wait_doneLeave execsql's console open when script is complete0checkbox Y >!U~gui_levelUse GUI dialogs for user interaction0[0-2]K)W#~console_widthApproximate width of a console window100[1-9][0-9]* y&m 1#~import_row_bufferNumber of rows of input data to buffer for the IMPORT metacommand1000[1-9][0-9]* ;!K~quote_allQuote all text values on output0checkboxL !m~make_dirsCreate directories if necessary for export files0checkbox V1c#~export_row_bufferNumber of data rows to buffer during export1000[1-9][0-9]*K)Y#~zip_buffer_mbBuffer size for zipped exports, in Mb.10[1-9][0-9]*e '~trim_stringsLeading and trailing whitespace on imported strings will be removed.0checkbox J#g~empty_rowsEmpty rows in imported data will be preserved1checkboxn )'~empty_stringsEmpty strings ('') in imported data will be preserved, not replaced with NULL1checkbox[ )~import_commonImport only columns present in both source and destination0checkbox| +A~dedup_col_hdrsMake repeated column headers unique by appending an underscore and column number on import0checkbox?-G~create_col_hdrsCreate missing column headers0checkboxh +~clean_col_hdrsReplace non-alphanumerics in column headers with underscores on import0checkboxY)~boolean_wordsValues of Y, N, T, and F are considered Boolean on import1checkboxO%q ~boolean_intValues of 0 and 1 are considered Boolean on import1checkbox   jzf.u TT2B@!~dao_flush)~zip_buffer_mb'~log_datavars+~write_warnings'~only_strings!~gui_level!~log_write/~console_wait_err1~console_wait_done)~console_width+~console_height ~hdf5_len1~export_row_buffer!~quote_all!~make_dirs 1~import_row_buffer #~scan_lines '~trim_strings /~replace_newlines #~empty_rows)~empty_strings)~import_common+~dedup_col_hdrs-~create_col_hdrs+~clean_col_hdrs)~boolean_words% ~boolean_int G 0zdQ8#z`F5# g I ,  k O /  q Y < !  k R <  z ] I 0G)Export~zip_buffer_mbFExport~hdf5_lenE1Export~export_row_bufferD!Export~quote_allC!Export~make_dirsB'Import~only_stringsA#Import~scan_lines@1Import~import_row_buffer?)Import~import_common>'Import~trim_strings=/Import~replace_newlines<#Import~empty_rows;)Import~empty_strings:+Import~dedup_col_hdrs9-Import~create_col_hdrs8+Import~clean_col_hdrs7)Import~boolean_words6%Import~boolean_int5)AllButDAO~zip_buffer_mb4'AllButDAO~only_strings3'AllButDAO~log_datavars2+AllButDAO~write_warnings1!AllButDAO~gui_level0AllButDAO~hdf5_len/1AllButDAO~export_row_buffer.1AllButDAO~import_row_buffer-!AllButDAO~quote_all,!AllButDAO~make_dirs+!AllButDAO~log_write*/AllButDAO~console_wait_err)1AllButDAO~console_wait_done()AllButDAO~console_width'+AllButDAO~console_height&#AllButDAO~scan_lines%'AllButDAO~trim_strings$/AllButDAO~replace_newlines##AllButDAO~empty_rows")AllButDAO~empty_strings!)AllButDAO~import_common +AllButDAO~dedup_col_hdrs-AllButDAO~create_col_hdrs+AllButDAO~clean_col_hdrs)AllButDAO~boolean_words%AllButDAO~boolean_int)All~zip_buffer_mb'All~only_strings!All~dao_flush'All~log_datavars+All~write_warnings!All~gui_levelAll~hdf5_len1All~export_row_buffer1All~import_row_buffer!All~quote_all!All~make_dirs!All~log_write/All~console_wait_err1All~console_wait_done )All~console_width +All~console_height #All~scan_lines 'All~trim_strings /All~replace_newlines#All~empty_rows)All~empty_strings)All~import_common+All~dedup_col_hdrs-All~create_col_hdrs+All~clean_col_hdrs)All~boolean_words%All~boolean_int G J^3!uN | i0 h J E  ( + Z ) B { c }   M 7 i M 2   c | )Export~zip_buffer_mbGExport~hdf5_lenF1Export~export_row_bufferE!Export~quote_allD!Export~make_dirsC'Import~only_stringsB#Import~scan_linesA1Import~import_row_buffer@)Import~import_common?'Import~trim_strings>/Import~replace_newlines=#Import~empty_rows<)Import~empty_strings;+Import~dedup_col_hdrs:-Import~create_col_hdrs9+Import~clean_col_hdrs8)Import~boolean_words7%Import~boolean_int6)AllButDAO~zip_buffer_mb5'AllButDAO~only_strings4'AllButDAO~log_datavars3+AllButDAO~write_warnings2!AllButDAO~gui_level1AllButDAO~hdf5_len0 1AllButDAO~export_row_buffer/ 1AllButDAO~import_row_buffer.!AllButDAO~quote_all-!AllButDAO~make_dirs,!AllButDAO~log_write+/AllButDAO~console_wait_err* 1AllButDAO~console_wait_done))AllButDAO~console_width(+AllButDAO~console_height'#AllButDAO~scan_lines&'AllButDAO~trim_strings%/AllButDAO~replace_newlines$#AllButDAO~empty_rows#)AllButDAO~empty_strings")AllButDAO~import_common!+AllButDAO~dedup_col_hdrs -AllButDAO~create_col_hdrs+AllButDAO~clean_col_hdrs)AllButDAO~boolean_words%AllButDAO~boolean_int)All~zip_buffer_mb'All~only_strings!All~dao_flush'All~log_datavars+All~write_warnings!All~gui_levelAll~hdf5_len1All~export_row_buffer1All~import_row_buffer!All~quote_all!All~make_dirs!All~log_write/All~console_wait_err1All~console_wait_done)All~console_width +All~console_height #All~scan_lines 'All~trim_strings /All~replace_newlines #All~empty_rows)All~empty_strings)All~import_common+All~dedup_col_hdrs-All~create_col_hdrs+All~clean_col_hdrs)All~boolean_words% All~boolean_int