Commit Graph

49 Commits

Author SHA1 Message Date
Paul Trowbridge 40b02b2bc5 merge latest updates 2024-03-05 08:36:02 -05:00
Paul Trowbridge faf78de0c5 vault backup: 2024-02-19 10:59:47 2024-02-19 10:59:47 -05:00
Paul Trowbridge 015f2679f9 convert fullcode to pdf 2023-05-22 11:41:09 -04:00
Paul Trowbridge 414c044fc0 updates 2023-05-05 12:57:57 -04:00
Paul Trowbridge 0b8e18e666 updates 2023-04-27 07:36:19 -04:00
Paul Trowbridge d75cb849e8 update ports 2022-12-20 10:07:03 -05:00
Paul Trowbridge a55b719e94 update issues upload to merge and to target db2 2022-08-04 16:47:39 -04:00
Paul Trowbridge ed4c795a40 clear page breaks 2022-05-12 10:07:54 -04:00
Paul Trowbridge e2315d3a16 add json and skip regex for ranged sql building 2022-05-06 16:38:33 -04:00
Paul Trowbridge 06990fd7dd add new parameter for handling empty cells 2022-05-05 13:48:16 -04:00
Paul Trowbridge 050eb881cb include another new column for compatable items 2022-04-11 08:43:56 -04:00
Paul Trowbridge b1c21d57ea work on core price list 2022-04-07 12:39:00 -04:00
Paul Trowbridge 3ce9b371ca include a new data type flag to prevent running regex on special characters that should be retained instead of removed 2022-03-31 12:35:18 -04:00
Paul Trowbridge 283e79714b utilize new sql function 2022-02-09 10:56:13 -05:00
Paul Trowbridge 539a966e1c convert input box on cross joining to range selector 2021-08-16 09:17:52 -04:00
Paul Trowbridge d78f665533 upload product groups 2021-08-13 11:01:12 -04:00
Paul Trowbridge 34984de260 updates to nursery regional parsing 2021-08-13 10:34:20 -04:00
Paul Trowbridge c80e5296d1 add 2 subroutines and SQL formatting 2021-06-16 09:03:23 -04:00
Paul Trowbridge 0101b45e8a set header values, wrap the sql in a commit block, close the connection 2021-03-15 16:02:45 -04:00
Paul Trowbridge b1328fac50 load table pcore from sheet contents 2021-03-15 15:41:44 -04:00
pt 605a1e95b0 update price list to just pull description columns 2020-12-02 11:53:21 -05:00
pt 0143a891bb rework the coloring a bit 2020-11-06 14:48:49 -05:00
Paul Trowbridge 9dcf8ac310 get rid of suffix column and include use accs instead of kit 2020-10-28 11:22:14 -04:00
Paul Trowbridge cc4bd12720 updates 2020-09-15 13:02:06 -04:00
Paul Trowbridge 4c0ceb334e add another iteration of the price list logic 2020-07-14 16:06:44 -04:00
Paul Trowbridge d10a15f113 live check of price list against lgdat records to test if inbound charges are new or update 2020-06-25 16:58:13 -04:00
Paul Trowbridge 17b974a940 move colors to columns, and update the highlighting 2020-06-23 15:41:59 -04:00
Paul Trowbridge 4b6d0c744d accomodate new sql builder parameters, and test for presence of price sheet 2020-01-29 13:31:32 -05:00
Paul Trowbridge 022240f8d3 update price list build to include status and stocked 2020-01-15 17:17:07 -05:00
Paul Trowbridge b4291d15e7 rework logic to hook off of color indicator supplied instead of using first 11 2020-01-15 11:41:19 -05:00
Trowbridge 35f5b04a1d use unit of measure to translate volume breaks, change default upload function to add 2020-01-13 17:25:22 -05:00
Trowbridge 56bb03ce7d default action is 1 2020-01-13 17:24:24 -05:00
Trowbridge aa88dbc9e7 upper bound was wrong 2020-01-13 17:23:39 -05:00
Trowbridge 94bc6e2b14 add shortcut keys and pricelist csv 2020-01-10 14:17:16 -05:00
Trowbridge fdd3ce6d93 add test for invalid numbers 2020-01-10 11:07:40 -05:00
pt 4311b3b3e4 build price list functionality 2020-01-09 17:53:00 -05:00
Paul Trowbridge b03218cd4d create full sql from selection 2018-05-25 11:27:02 -04:00
Paul Trowbridge 4755ebba5b add functions to create a text file based on range 2017-12-08 13:48:01 -05:00
Paul Trowbridge c2ab8b5a4b snap to current personal.xlsb 2017-11-06 13:27:09 -05:00
Paul Trowbridge ac530a079f add auto fit & format pivot 2017-11-06 13:26:33 -05:00
Paul Trowbridge 1b2cdf854b add functions to turn column number into letter, range to transposed string array, and build string array into sql values 2017-09-29 11:40:14 -04:00
Paul Trowbridge c2fc14e50b reference main library instead of duplicating code 2017-09-28 14:28:38 -04:00
Paul Trowbridge 7c746f7e62 change name of mark_down_from_table, create min spacing of 3 2017-09-27 12:55:58 -04:00
Paul Trowbridge 12e466714f add function to take multiple selections and put them into json 2017-08-24 00:01:53 -04:00
Paul Trowbridge aab361bbf3 add function to copy selection table to markdown on clipboard 2017-08-17 10:00:18 -04:00
Paul Trowbridge b311408659 add routine to cross join highlighted ranges 2017-07-12 11:15:50 -04:00
Paul Trowbridge 317324a342 extract_pnc - convert to write straight to csv fiels 2017-07-07 17:42:47 -04:00
fleetside72 730b2667d3 Update FL.bas 2017-04-05 09:53:14 -04:00
fleetside72 51164251a5 Add files via upload 2017-04-04 13:50:28 -04:00