Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
|
2025-06-20
| ||
| 02:12 | For tkt [0acecac3390] Accept CSV for upload file. Error messages persist for upload of .tsv files, though not uninitialized value. The compaint formv_uniq_cnt_singers does not appear. In tmp.db there is a perfectly reasonable v_uniq_cnt_singers?? Leaf check-in: d22715e2d1 user: dlanewk tags: trunk | |
| 01:54 | For tkt [0acecac3390] Accept CSV for upload file. Generated .tsv file has double quotes everywhere. Seems to interfere with normalization. SQL hasdtrim((foo,dblquote) to handle things like this. Best done in definitions of sick, deceased, nm offcname tables. Needs extra tests in one of the *t suites using a copy of a tmp.db. check-in: 4dab2f1916 user: dlanewk tags: trunk | |
|
2025-06-19
| ||
| 17:00 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Closestkt [185a9edb9db] Need to separate finding workdir. Closes tkt [eade7283b88] make ready for multi-session. Closes tkt [0acecac3390] Accept CSV for upload file. Was failing to link_to on existing files. Just do the obvious in the tmp directories, which are now really unique with better scoped init_files. check-in: b8889a5753 user: dlanewk tags: trunk | |
| 13:26 | For tkt [185a9edb9db] Need to separate finding workdir so that caller can do ->link_to. Now creates workdir as part of get_workdir. Mystery why workdir does not appear in /tmp/workdir. Now initfiles is block-local. Was caching in global our init_files. Still a mystery why link_to is not creating file in /tmp/topdir.Otherwise appears to successfully split responsibilities between caller and InitFiles.pm check-in: 61be50a2b3 user: dlanewk tags: trunk | |
|
2025-06-18
| ||
| 20:26 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. A little cleanup of commented lines and some perl formatting. Added 'tstpath' as url_path; fixed calling convention in InitFiles::logme. Added comment about hauling out calc of working directory from init_dir. Changed system call in tst_upload.psgi to init_filecsv->cleanup(); In InitFiles.pm made url_path rw; Added sensitivity to ENV{DEBUG} eq 'LEAVE' to allow d.* directories to be created and survive. check-in: 09fb52f6c6 user: dlanewk tags: trunk | |
| 01:35 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. tst_upload.psgi now uses InitFiles to handle logging and quoting. Also should create Minutes.tsv and tmp.db in DEBUGCSV. check-in: b72a292572 user: dlanewk tags: trunk | |
| 00:58 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Removes tmp.db before importing; important or we get multiple copies of records in Minutes.tsv and tmp.db check-in: 5b69afbc9c user: dlanewk tags: trunk | |
|
2025-06-17
| ||
| 20:28 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Now tmpnam is taken from ENV{DEBUG} so we can check three cases: .csv,.tsv. and neither. Added copy of /tmp/topdir/DEBUG(CT)SV to fossil. All tests pass. Need approx 6-12 more tests, including badupload. check-in: 5415d12e24 user: dlanewk tags: trunk | |
| 16:16 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Fixed export_sqlite to have headers and force \n for EOL. Fixed html_quote to handle >. Fixed obj properties setting to use ->foo('newval') style. Accidental correct handling of tmp.db in hte .csv case. Exercised InitFiles::logme and InitFiles::html_quote. Still needs testing for init_dir. Sure would be nice to have a dreq attribute, Hard to coordinate Minutes.(csv/tsv) in the appropriate directories. Maybe fix tmpnam based on ENV{DEBUG} check-in: 1a6fc53280 user: dlanewk tags: trunk | |
| 09:40 | For tkt [3e1e57e4519] InitiFiles for setup (and cleanup) of temporary files. Now creates tmp directories which now hold Minutes.csv (from caller) or Minutes.tsv. InitFiles::init_dir creates ->tmp_dir and places Minutes.tsv in it from the Minutes.csv if necessary, then updates ->{fh, dbcon) with live handles to Minutes.tsv and tmp.db respectively. InitFiles::cleanup only runs if ENV{DEBUG} is empty. check-in: f7e4607977 user: dlanewk tags: trunk | |
| 02:07 | For tkt [3e1e57e4519] InitiFiles for setup (and cleanup) of temporary files. InitFiles creates tmp dirs with a .tsv file. Forces creation of .tsv if .csv file uploaded. Now has a copy of export*sqlite, becoming canonical. Can cleanup; provides nearly trivial err_msgs. check-in: 449946cd1d user: dlanewk tags: trunk | |
| 00:15 | For tkt [a1b7ace0fa1] Smart Quotes should be reported. Inline-only, with opt-out for European/Asian users. check-in: 5dbf33adb2 user: dlanewk tags: trunk | |
|
2025-06-16
| ||
| 22:35 | Closes tkt [842b753ab79] Deceased reports.Downstream of tkt [a34466a469d]. In OrderedTable::loc_rept remove stray semi-colon before final 'and'. Adds tests in 06*.t for dec7_alt and dec7_alt2. Also for tkt [89ced679865] Definition and use of OrderedBreaks, adds tests for 1,2 entry cases for OrderedTable::rept_nm. check-in: efedddf328 user: dlanewk tags: trunk | |
| 05:01 | For tkt [89ced679865] Definition and use of OrderedBreaks. OrderedTable::rept_nm sneakily re_uses loc_rept to handle short special cases and is a good candidate for filling SONGS in the templates. check-in: 4dcfc013b5 user: dlanewk tags: trunk | |
| 01:45 | For tkt [842b753ab79] Deceased reports. Downstream of tkt [a34466a469d] multiple fasola formats. Added OrderedTable::dec_rept_struct and ::dec_rept to produce the deceased report. Not closed because need (at least) two more tests of dec*7_alt* check-in: 95405a496e user: dlanewk tags: trunk | |
|
2025-06-15
| ||
| 22:37 | For tkt [a34466a469d] Supporting multiple fasola report formats. Centralized array handling to rept in OrderedTable::loc_rept. Refactored sick_rept to use loc_rept. All tests pass. check-in: 9ed1bd127c user: dlanewk tags: trunk | |
| 16:42 | For tkt [a34466a469d] Supporting multiple fasola report formats. Scaffolding for deceased. OrderedTable::dec_locs and ::dbg_dec_locs concentrate on just the location of the entries. Tests OK. Using 2 variants of dec..7(alt and alt2). check-in: 7e8fee1507 user: dlanewk tags: trunk | |
|
2025-06-14
| ||
| 17:25 | For tkt [a34466a469d] Supporting multiple fasola report formats. Sick reports implemented in sub OrderedTable::sick_rept. With tests in 06*t. check-in: d4cc288d92 user: dlanewk tags: trunk | |
| 17:17 | Adjusted col width for book_fasola check-in: df994ee4f7 user: dlanewk tags: trunk | |
|
2025-06-13
| ||
| 16:00 | For tkt [24196f72245] Rough out the web gui. Added autocomplete textarea. check-in: bf83851478 user: dlanewk tags: trunk | |
| 15:47 | For tkt [fc39cf58376] logging usage.. Centralized logging and applied to post,/, and *. Added some verbiage on the landing page about exporting from the spreadsheet. check-in: fbbb20a493 user: dlanewk tags: trunk | |
| 00:43 | Simple usage and template for exportTsv.sqlite. use File::Slurp; = read_file('d.XXXX.csv'); =~s/xxMINUTESXX/d.XXXX/; write_file('d.XXXX.sqlite',contents); system 'cat d.XXXX.sqlite | sqlite3 d.XXXX.db;' check-in: 50e229f675 user: dlanewk tags: trunk | |
|
2025-06-12
| ||
| 21:46 | Now only logs miss-entered paths check-in: e673728658 user: dlanewk tags: trunk | |
| 21:43 | This logging is too complex as shelling to system; need to do proper perl open of file as append etc. check-in: 7fb5373be5 user: dlanewk tags: trunk | |
| 21:19 | Closes tkt [fc39cf58376] logging usage; clean up /tmp/uploads for privacy. Now logs in times.lst bad urls and times - perhaps should be at hour granularity outside of test. Removes .db .csv .tsv from /tmp/db . check-in: cd40bebe16 user: dlanewk tags: trunk | |
| 17:53 | Closes tkt [381970f9742] Need to run twice on initial. Was a phase error with uploads.tt check-in: f69ea05967 user: dlanewk tags: trunk | |
| 17:46 | For tkt [873c89a06e5] Dancer2/plackup psgi. Added sub error_route with no effect. Added get '*' to handle things like /uploa. Changed myfile to ConvMinutes in upload. Used dry-run mktemp to get short tmp directory name - now upload files are linked to /tmp/uploads/d.XXXXX files. Used sub html_quote to handle obvious html gt; etc - Closes tkt [fe949d8c3d5] Arrow quoting.. check-in: d6fcb801b9 user: dlanewk tags: trunk | |
|
2025-06-07
| ||
| 05:32 | For tkt[873c89a06e5] Dancer2/plackup psgi. Moved sicketc to EOM variable; Provided a variety of temp and other files from data->.. and system calls to mktemp and uuidgen. check-in: 00b925e032 user: dlanewk tags: trunk | |
|
2025-06-06
| ||
| 17:35 | Not yet ticketed. Dancer2 runs based on tst_upload.psgi. Now includes stubs and heading for Officers, Sick & Deceased. check-in: 23edca5598 user: dlanewk tags: trunk | |
| 17:32 | Not yet ticketed. Dancer2 runs based on tst_upload.psgi. Has placements for Report, Stats, Sick etc , Errors. Working in ~/dockers/dancer2/. check-in: 9f3a8f78e2 user: dlanewk tags: trunk | |
|
2025-06-04
| ||
| 02:46 | For tkt[eaecb5bee5b] misc column in spreadsheet.. Bolded Event in spreadsheet misc column. Trimlined everything in misc table to help with vagrant spaces. check-in: 23363b6ba4 user: dlanewk tags: trunk | |
| 01:43 | For tkt[89ced679865] Definition and use of OrderedBreaks. Defined OrderedBreaks.FromNmTbl which grovels over break_name, int_order pairs from nm and calls Break.FromBreakInt appropriately then constructs an OrderedBreak instance. Now everything uses fixed CONN and SEP from inside Break.pm. check-in: 5b4a875c9f user: dlanewk tags: trunk | |
|
2025-06-03
| ||
| 23:31 | For tkt[a01b13b422b] Design for accessing first/second entry for formatting. 06*t excercises the special cases for first_pair_rest_entries. check-in: 5a7265137d user: dlanewk tags: trunk | |
| 15:49 | For tkt[2668bb9403d] Standard place for warnings. Better coment why DBT at the first line of DBT.pm. Updated tbl counts since we have added 2 more checkbox lines to spreadsheet, with labels this means 4 more entries in imp_misc. Misc adds 2 since info is now spread over two columns. check-in: c4510332ff user: dlanewk tags: trunk | |
|
2025-06-02
| ||
| 19:07 | Closes tkt[a01b13b422b] Design for accessing first/second entry for formatting. Adds OrderedTable.first_pair_rest_entries which returns everything at once. 06*t has setup for testing edge cases. check-in: 27bc8cc780 user: dlanewk tags: trunk | |
| 09:40 | Test 06*t for tkt[77e79d8cd76] For Sick and Deceased, full state name. Also tests tkt[55f267821e8] norm_locdec in deceased has missing locdec entries in int_orders qw/6 7 8/ check-in: 0ea954c46d user: dlanewk tags: trunk | |
| 08:55 | Closes tkt[55f267821e8] norm_locdec in deceased has not entries in at lease three cases. Was normalizing loc (from sick) rather than the correct locDec (from deceased). Also Closes tkt[77e79d8cd76] For Sick and Deceased, full state name. Uses href ::STATE_ABBRS in DBT class method sub ToFullState (registered along with the others in sub register_nm_functions) and used in sick and deceased inserts. check-in: 9fbbcbe39a user: dlanewk tags: trunk | |
|
2025-06-01
| ||
| 23:29 | For tkt [0acecac3390] Accept CSV for upload file. Updated 25Minutes.tsv for comparison's sake to slightly munged output of (cd scaffolding/; sqlite3 sqlite3 < exportTsv.sqlite > Minutes.tsv. Needed to remove double quotes and \cM to have a prayer. 39 lines of difference, mostly due to random double quotes in 25Minutes.tsv check-in: 00163586bd user: dlanewk tags: trunk | |
| 22:26 | For tkt[a1b7ace0fa1] Smart Quotes should be reported. Added checkboxen to Misc to control Unicode warnings. For tkt [0acecac3390] Accept CSV for upload file. Added 25Minutes.csv. check-in: da97178847 user: dlanewk tags: trunk | |
| 19:22 | For tkt[a1b7ace0fa1] Smart Quotes should be reported. In 05*t sample code now uses a more realistic report string. Now outputs fewer newlines; easier to edit changed report. Removed a debugging line (li 36) in DBT.pm check-in: e9fd053ae3 user: dlanewk tags: trunk | |
| 18:59 | For tkt[a1b7ace0fa1] Smart Quotes should be reported. In 05*t sample code we look at global regex substitution and add newlines, and provide an extra arrow to clarify the offending unicode. check-in: 46bfe80db2 user: dlanewk tags: trunk | |
|
2025-05-31
| ||
| 20:04 | For tkt[a1b7ace0fa1] Smart Quotes should be reported. In 05*t sample code with o'brian. Needs context added in error reporting - table/column and int_order. Quirks of utf8 mean multiple non-ascii codes will happen together check-in: 0fbad3a9fd user: dlanewk tags: trunk | |
| 19:22 | For tkt[b696b52c82d] Cheap template replacement. Updated 05*t for slightly different template reports. Changed LEAD to LEADERS for SICK and DECEASED templates in spreadsheet and updated *tsv therefore. check-in: 1f230d9f33 user: dlanewk tags: trunk | |
| 00:06 | For tkt[b696b52c82d] Cheap template replacement. Delete from break_name where (NULL or trim(foo)=''); dbg print statement in 05*t yields commonalities among many templates; essentially need to fill qw/LEADER FIRST_NUM LEADERS SONGS/ and add LAST_BREAK: TOT_SONGS and TOT_LEADERS along with many details from DBT::->{PREAMBLE}. check-in: 0a804c59ce user: dlanewk tags: trunk | |
|
2025-05-30
| ||
| 23:31 | Added comparison between trimline and sql trim function in 04*t; a little reformatting on dbg print statement in Formatter.pm. check-in: ad7b43de3d user: dlanewk tags: trunk | |
| 23:16 | For tkt[181fd3e610e] *book and break* columns in spreadsheet. xxNNL->xxNL;Bunch of double space (after periods; after end of expression. The TrimLine(foo)||' ' should take care of this. Widened spreadsheet break_template column to make this more visible. check-in: 22b41b24d0 user: dlanewk tags: trunk | |
| 16:10 | For tkt[181fd3e610e] *book and break* columns in spreadsheet. Uniformed titles - bolded titles are table names. Added cnt_abbr column like previous cnt column for num dups. All tests pass on qw/04 05/. check-in: 12d8768a15 user: dlanewk tags: trunk | |
| 15:33 | For tkt[ac4b459d0a6] Identifiable count_nm_num, office reports. Now have a default s=>'ShH' $DBT::ABBR_BOOK_HREF; now deletes both IS NULL foo and trim(foo)='' entries. A few more return '' unless $str. check-in: 0cb9fdcab7 user: dlanewk tags: trunk | |
| 02:03 | For tkt[ac4b459d0a6] Identifiable count_nm_num. FAILS because nm has just one entry. Closes tkt[ea52e224307] DBT::NormNum handles all book_fasola. Methods DBT.href_from_sql and DBT.init_hrefs defined. Added beginning O’Brian to start on tkt[a1b7ace0fa1] Smart Quotes. check-in: f4f3b32128 user: dlanewk tags: trunk | |
| 00:20 | Added l abbr for LD Lloyd's hymnal check-in: 0907ce30db user: dlanewk tags: trunk | |