Commit Graph

  • f9aa2a31a6 add single def set Paul Trowbridge 2018-06-04 00:54:23 -0400
  • f7d197ce9c
    Merge pull request #30 from fleetside72/map_set fleetside72 2018-06-01 13:40:33 -0400
  • 0e028af435 when setting the map regex, retain the whole json being supplied Paul Trowbridge 2018-06-01 13:37:14 -0400
  • 5e2b6ee59d add mapped schema to paycom Paul Trowbridge 2018-05-31 17:03:45 -0400
  • e3f2097a0f format Paul Trowbridge 2018-05-31 16:33:19 -0400
  • 7c28ea8384 reload williams paid data Paul Trowbridge 2018-05-31 14:57:04 -0400
  • da9e9b08f1 sort collateral on id that needs to be in view, alter view creation to include ids Paul Trowbridge 2018-05-31 10:24:15 -0400
  • 86f72b4d97
    Merge pull request #29 from fleetside72/test_regex fleetside72 2018-05-31 02:59:37 -0400
  • 668a59b693 include new functions in deploy script Paul Trowbridge 2018-05-31 02:57:59 -0400
  • dd718a35d6 do test regex but retain all underlying orig recs Paul Trowbridge 2018-05-31 02:55:32 -0400
  • d4a697f652 rename Paul Trowbridge 2018-05-31 02:52:32 -0400
  • 9897cf1bee add basic regex test Paul Trowbridge 2018-05-31 02:52:08 -0400
  • 605bde16ec
    Merge pull request #26 from fleetside72/setup fleetside72 2018-05-31 01:57:33 -0400
  • ca0a3d107a include previos changes into the main deployment script Paul Trowbridge 2018-05-31 01:57:00 -0400
  • 8a7a597cf4
    Merge pull request #25 from fleetside72/rebuild_constraint fleetside72 2018-05-31 01:52:11 -0400
  • 4f96d433e7 exit if inbound is not different, and rebuild constrint key on tps.trans rows if the constraint defintion has changed 2018-05-31 01:42:28 -0400
  • ea1e0e746e
    Merge pull request #22 from fleetside72/cleanup fleetside72 2018-05-31 00:45:27 -0400
  • eb11380798 get rid of unnecessary files Paul Trowbridge 2018-05-31 00:44:46 -0400
  • 26ecccda00
    Merge pull request #21 from fleetside72/dev_setup fleetside72 2018-05-31 00:37:46 -0400
  • e20ffafe51 update files names in curl Paul Trowbridge 2018-05-31 00:28:04 -0400
  • 7b543dce39 rebuild hunt so that path is in curlies Paul Trowbridge 2018-05-30 23:58:35 -0400
  • ac3fccf84c move folder Paul Trowbridge 2018-05-30 23:44:10 -0400
  • 035122bba4 add huntington import commands Paul Trowbridge 2018-05-30 23:43:36 -0400
  • e438bdc79c update map for output format Paul Trowbridge 2018-05-30 23:30:06 -0400
  • e950c0bfa9 load huntington Paul Trowbridge 2018-05-30 23:26:33 -0400
  • 58590d159d lowercase Paul Trowbridge 2018-05-30 23:15:52 -0400
  • ddfbcdebec update dcard Paul Trowbridge 2018-05-30 22:58:15 -0400
  • 501654bd8d consolidate curls to one file Paul Trowbridge 2018-05-30 22:42:06 -0400
  • 56fe1df074 move files to reload and get rid of the rest Paul Trowbridge 2018-05-30 22:41:50 -0400
  • 494c0b13de break out huntington Paul Trowbridge 2018-05-30 22:38:24 -0400
  • 3abb2fa9ba load paycom Paul Trowbridge 2018-05-30 15:10:46 -0400
  • 0bedaa5657 start work on paycom Paul Trowbridge 2018-05-30 13:43:17 -0400
  • ee6746d830 post date has no space for collateral Paul Trowbridge 2018-05-30 13:38:27 -0400
  • 02e6b761b4 loan pncl Paul Trowbridge 2018-05-30 13:27:01 -0400
  • 9d5a69c891 load pncl Paul Trowbridge 2018-05-30 11:10:23 -0400
  • 3f038d9592 load pnco Paul Trowbridge 2018-05-30 10:44:41 -0400
  • e77727403a move dcard to it own folder Paul Trowbridge 2018-05-30 09:50:27 -0400
  • 38ff0d9e06 ddrop pncc_sample Paul Trowbridge 2018-05-30 09:49:50 -0400
  • 3ffb8d4293 pncc reload Paul Trowbridge 2018-05-30 09:48:30 -0400
  • a5baf90bd6 accomodate multiple map defintions at once in an array Paul Trowbridge 2018-05-30 09:48:19 -0400
  • 286e2bfc60 loading pncc Paul Trowbridge 2018-05-30 08:57:41 -0400
  • ffb55cafa9 definition is stored in regex object Paul Trowbridge 2018-05-30 08:57:10 -0400
  • 2af0a3432b pncc map def Paul Trowbridge 2018-05-30 08:43:17 -0400
  • aec0ea5563 pncc source Paul Trowbridge 2018-05-30 08:33:11 -0400
  • 07e5c55f98 reload Paul Trowbridge 2018-05-30 00:20:47 -0400
  • e16a60b9fb reload Paul Trowbridge 2018-05-30 00:08:36 -0400
  • eae2b5a92e add huntington map Paul Trowbridge 2018-05-29 23:54:47 -0400
  • 8fee2548a4 reload from ubm Paul Trowbridge 2018-05-29 23:47:24 -0400
  • 0301883d49 migrate Paul Trowbridge 2018-05-29 23:14:41 -0400
  • baadaaef8d copy over old dcard Paul Trowbridge 2018-05-29 22:35:16 -0400
  • 9218408ddf add paycom def Paul Trowbridge 2018-05-29 17:22:59 -0400
  • 092b12a8ce tpsv grant priveledge, add curl scripts to test Paul Trowbridge 2018-05-29 15:37:57 -0400
  • 8902f529a9
    Merge pull request #20 from fleetside72/dev_setup fleetside72 2018-05-25 16:06:29 -0400
  • afb9136e30 move scripts to one folder Paul Trowbridge 2018-05-25 16:01:59 -0400
  • afb9981af0 move test scripts to associated source folder Paul Trowbridge 2018-05-25 15:59:15 -0400
  • 27b90a2ab9 setup pncc import Paul Trowbridge 2018-05-25 15:53:36 -0400
  • 5df092b7ad merge maps into new_table then join back to trans Paul Trowbridge 2018-05-25 15:04:57 -0400
  • 05f509a434 update constrain on dmapi Paul Trowbridge 2018-05-25 14:36:24 -0400
  • 1ff496e072 if no map, set allj to rec. allj still an issue tho Paul Trowbridge 2018-05-25 14:22:23 -0400
  • 053ddb0c9e get json doc storage to work Paul Trowbridge 2018-05-25 14:03:01 -0400
  • 0196ba4c53 drop old files and start working on json storage scripts Paul Trowbridge 2018-05-25 13:44:37 -0400
  • c5eb8a102c get rid of old deploy scripts Paul Trowbridge 2018-05-25 13:08:39 -0400
  • 48c425ab86 get rid of old functions Paul Trowbridge 2018-05-25 13:07:55 -0400
  • 8641b286e6 add logid to trans as well as foreign key Paul Trowbridge 2018-05-25 12:52:16 -0400
  • c6554831a1 make view creationg script use allj Paul Trowbridge 2018-05-25 10:25:09 -0400
  • 39820d6051 test and modify building of view to be based on allj Paul Trowbridge 2018-05-25 10:23:43 -0400
  • cdba942e9e develop map values set Paul Trowbridge 2018-05-25 10:09:12 -0400
  • 64d3a1f310 add source set test Paul Trowbridge 2018-05-25 10:08:20 -0400
  • 850b2b9049 add map values set Paul Trowbridge 2018-05-25 09:54:00 -0400
  • 7739aeb554 comment out raise notice Paul Trowbridge 2018-05-25 09:12:53 -0400
  • 44db887b6a too much to list Paul Trowbridge 2018-05-25 02:25:36 -0400
  • 92d56aaba2 start work on mapping values Paul Trowbridge 2018-05-24 17:35:50 -0400
  • e694991d90 function was implemented elsewhere delete Paul Trowbridge 2018-05-24 17:31:17 -0400
  • 02555012f5 cast items in and specify insert columns, create test script Paul Trowbridge 2018-05-24 17:11:26 -0400
  • f23da6f5ec accomodate history defintion of parse map Paul Trowbridge 2018-05-24 17:03:55 -0400
  • ad2a7ed68d convert map definintion set to take only a json Paul Trowbridge 2018-05-24 17:01:03 -0400
  • 6de5ece3d0 add sample map def Paul Trowbridge 2018-05-24 16:56:34 -0400
  • 8ec04081b9 setup files for import Paul Trowbridge 2018-05-24 16:54:00 -0400
  • 5df85836cb start work on rebuilding import Paul Trowbridge 2018-05-24 16:20:19 -0400
  • d000367c82 rename json file and minify Paul Trowbridge 2018-05-24 16:20:10 -0400
  • ae77d01d51 add sql generation function to main setup Paul Trowbridge 2018-05-24 13:26:41 -0400
  • 46a1c94643 Merge branch 'dev_setup' of https://github.com/fleetside72/tps_etl into dev_setup Paul Trowbridge 2018-05-24 13:22:50 -0400
  • 516653afa8 convert to functino from do block Paul Trowbridge 2018-05-24 13:22:46 -0400
  • cd311ee1ce add function to setup, drop dev set, add test script Paul Trowbridge 2018-05-24 01:10:08 -0400
  • a4f630ca54 add history column and create srce_set function Paul Trowbridge 2018-05-24 00:49:10 -0400
  • 80406a2dc6 extrapolate a view from schema Paul Trowbridge 2018-05-23 17:18:17 -0400
  • eb8da0f6c5 get rid of validation steps not required Paul Trowbridge 2018-05-23 00:32:15 -0400
  • b6c1126ecb setup new files Paul Trowbridge 2018-05-23 00:31:45 -0400
  • 18a7bacb73 build out sql to deploy dev schemas Paul Trowbridge 2018-05-22 17:38:35 -0400
  • c886f910b1 include file to setup dev envrionment Paul Trowbridge 2018-05-22 14:30:08 -0400
  • 1342ab44c9 include notion of multiple interpretations of the data Paul Trowbridge 2018-05-21 17:24:50 -0400
  • 6f7f1ddeb3 additional test and update readme with decisions Paul Trowbridge 2018-05-21 17:00:19 -0400
  • e354d6c2b8 add notes about schema and table extraction Paul Trowbridge 2018-05-21 00:02:33 -0400
  • 3c4d9772bb update for current ubm2 document Paul Trowbridge 2018-05-21 00:02:08 -0400
  • 8728809ddc add fiels to feel out using path to extract Paul Trowbridge 2018-05-21 00:01:57 -0400
  • 809df3ef52 add notes on definition schema Paul Trowbridge 2018-05-20 15:53:04 -0400
  • d3114d5759 add throughts on new source definition Paul Trowbridge 2018-05-20 02:51:25 -0400
  • ba6a06e30a add notes Paul Trowbridge 2018-05-19 16:52:59 -0400
  • 2f2aa0926b Merge branch 'j_constr' into key_log Paul Trowbridge 2018-03-13 00:46:12 -0400
  • bb8b9f5181 add unmapped recs to schema Paul Trowbridge 2018-03-13 00:38:00 -0400