rattail/rattail-corepos
1
0
Fork 0
Code Issues Pull requests Actions Packages Projects Releases Wiki Activity
305 commits 1 branch 59 tags 441 KiB
Commit graph

111 commits

Author SHA1 Message Date
Lance Edgar c3441f700d fix: improve core-office anonymize command logic 
- prefer setting `custdata` names over `meminfo`
- use custdata name for basis of `meminfo.email`
- use "real" random zipcode
- fix attr assignment for `meminfo.zip`
 2024-08-10 12:00:48 -05:00
Lance Edgar 339c718b32 fix: fix DELETE triggers for meminfo, employees 
whoops not sure how those got missed
 2024-08-06 11:41:02 -05:00
Lance Edgar 1b04b4097c fix: add Employee support for CORE API -> Rattail import/datasync 2024-07-04 18:29:05 -05:00
Lance Edgar dca2c1bfe2 fix: add command to install mysql triggers for CORE office_op DB 
for use with datasync.  this also adds datasync support for
ProductCost preference
 2024-07-03 18:25:18 -05:00
Lance Edgar ea147e8c0d Add typer equivalents for rattail commands 2024-05-16 19:16:08 -05:00
Lance Edgar 93c7b254a3 Migrate the crepes commands to use typer 2024-05-15 23:12:49 -05:00
Lance Edgar 2b0ca89fb8 Migrate the core-office commands to use typer 2024-05-15 23:01:26 -05:00
Lance Edgar 8eb097867e Add basic support for importing from CSV to office_arch.bigArchive 
still requires CSV file header column names to match the SA model,
and *not* the underlying mysql names
 2024-05-08 14:54:16 -05:00
Lance Edgar f07c767826 Truncate "blue line" text if necessary when updating CORE 2024-01-17 11:26:42 -06:00
Lance Edgar e6c1b2d9ba Add function for writing value to fannie config file 2023-11-18 12:11:39 -06:00
Lance Edgar aa1b53d96c Improve the anonymization logic some more 
hopefully this scrubs all personal data from a `core_op` DB
 2023-10-04 18:52:07 -05:00
Lance Edgar 478126f1e3 Improve the core-office anonymize command somewhat 
API is not good enough for this, need to write direct SQL instead

this "mostly" anonymizes `custdata` and `meminfo` but still needs to
also anonymize probably `CustomerAccounts` and `Customers`, as well as
`employees` and possibly others..?
 2023-10-03 23:17:09 -05:00
Lance Edgar ebdb658a2c Make CORE API client via app handler, not deprecated function 2023-09-18 08:12:20 -05:00
Lance Edgar 7dc09d0a2e Let config override the CORE API client factory 2023-09-17 13:47:06 -05:00
Lance Edgar 465322b87b Add common base for commands which import straight to CORE op/trans DB 2023-09-09 12:19:54 -05:00
Lance Edgar 2af89f2cbf Add core-office anonymize command 
for sake of demo data etc.
 2023-06-19 20:58:00 -05:00
Lance Edgar 9c15952386 Rename model for custdata to CustomerClassic 2023-06-12 20:04:31 -05:00
Lance Edgar a6541a2c32 Add core-office patch-customer-gaps command 
hopefully this is not often needed, but definitely might be sometimes..
 2023-06-12 20:04:24 -05:00
Lance Edgar cc517702e1 Improve email diff display for exports to CORE API 'Member.customers' 
break out each subrecord into separate fields, for easier viewing
 2023-06-12 16:39:32 -05:00
Lance Edgar 46eec6b781 Improve diff detection for customerID when dealing with CORE API 
sometimes it returns int, sometimes str..
 2023-06-12 16:36:31 -05:00
Lance Edgar 3cef682a75 More tweaks for CORE <-> Rattail member sync 2023-06-11 21:05:51 -05:00
Lance Edgar 2ca9cd8f76 Fix how customerAccountID is imported from CORE API 
geez.

also optimize joinedloads when fetching Rattail member data for CORE
export
 2023-06-11 15:21:30 -05:00
Lance Edgar 15bac1dc23 Add core-office export-csv command; deprecate crepes export-csv 2023-06-11 11:55:29 -05:00
Lance Edgar 43cd63c1f5 Add phone/email support for Rattail -> CORE export for Member 2023-06-10 21:18:14 -05:00
Lance Edgar bde8200cdf Add core-office ping-install command, for DB setup 2023-06-10 18:35:49 -05:00
Lance Edgar 660637522d Add CustomerShopper.corepos_customer_id and refactor importers 
removes phone/email support for now..also change how we handle
default/empty values for member start/end date..
 2023-06-10 14:35:08 -05:00
Lance Edgar 2cf865d879 Add core-office import-csv command; deprecate crepes import-csv 2023-06-09 19:53:47 -05:00
Lance Edgar 6267205966 Avoid the Change model by default, for CSV -> CORE import 2023-06-09 17:41:32 -05:00
Lance Edgar 95fcf054ef Fix import to avoid deprecation warning 2023-06-09 15:28:08 -05:00
Lance Edgar bfc52a6fb3 Make card_number more central for CORE API -> Rattail importers 
let's track that as (effectively) `Customer.corepos_card_number` and
use that when possible for importer key
 2023-06-05 20:45:45 -05:00
Lance Edgar 5dc1392ef7 Skip customer record with no member type, for blue line update 
otherwise would just raise error, and prevent the rest of updates from
happening
 2023-06-03 07:27:57 -05:00
Lance Edgar e838e5b514 Add support for htdigest auth when using CORE webservices API 2023-05-22 21:36:04 -05:00
Lance Edgar 80084e13da Add core-office import-self command, to fix custdata.blueLine 2023-05-18 15:55:56 -05:00
Lance Edgar e74a47b99a Add behavior options for CORE member importer 2023-05-11 15:23:39 -05:00
Lance Edgar f8de832294 Add support for member_type_id in CORE MemberInfoImporter 
also improve support for first, last name sync
 2023-05-09 20:25:52 -05:00
Lance Edgar 24d4afa22b Move CORE DB import handler to more general location 2023-05-08 14:56:49 -05:00
Lance Edgar ef823260ab Move logic for CORE importing to "more precise" module path 
should distinguish "office vs. lane"
 2023-05-08 14:56:46 -05:00
Lance Edgar 519ed0a594 Avoid deprecated import for OrderedDict 2023-05-05 01:48:39 -05:00
Lance Edgar 63a1172408 Update usage of short_session() per upstream changes 2022-08-21 20:00:15 -05:00
Lance Edgar e91fef0e8d Refactor CORE API hack to use custdata instead of Customers table 
the older table seems more reliable?  at least i just ran across an
example where it was, albeit a demo..
 2022-01-08 19:49:51 -06:00
Lance Edgar 9045965035 Mark some import handlers as safe for web app 2021-12-06 21:29:56 -06:00
Lance Edgar 3140245857 OMG a ridiculous commit to overhaul import handler config etc. 
- register all import/export handlers via setup.py and config
- use "handler key" lookup for all import/export commands
- fix logic bugs w/ CORE -> Trainwreck importer
 2021-12-06 20:07:42 -06:00
Lance Edgar 0e28a6ee2b Some tweaks to expose CORE <-> Rattail import handlers in web app 2021-12-05 17:24:54 -06:00
Lance Edgar 7522dd14cb Add custdata importer for CORE Office -> Lane 
to double-check sync issues
 2021-11-04 17:42:38 -05:00
Lance Edgar 980c2fa952 Add CORE Office -> Lane op importer for Department 2021-08-31 22:41:32 -05:00
Lance Edgar ca723ffde8 Add email setting for CORE Office -> CORE Lane export 2021-07-22 12:15:26 -05:00
Lance Edgar 6c9d9964dc Add basic support for CORE Office -> CORE Lane export 
just products data so far
 2021-07-21 20:05:16 -05:00
Lance Edgar 83ba5c9ace Fix typo 2021-02-09 15:41:27 -06:00
Lance Edgar 1be258246c Add make_corepos_api() convenience function 2021-02-09 14:28:38 -06:00
Lance Edgar f61a0a7dd9 Add importer support for VendorItem 
this was done mostly for CORE <-> CORE diffs
 2021-01-30 13:17:45 -06:00