Drop / Truncate F_SALES fact table on reinstall

ivylabs / suitecrm-data-integration

7 stars 5 forks source link

Drop / Truncate F_SALES fact table on reinstall #89

Closed harrisward closed 3 years ago

harrisward commented 3 years ago

Ross has reported that when rerunning the install o override an initial demo data install the F_SALES fact table isn't recreated empty.

fraserward commented 3 years ago

This is correct. The Table F_SALES is either not dropped or truncated when running the script for a live version after using demo date. On investigated this is also the same for F_CAMPAIGN_MANAGEMENT table.

fraserward commented 3 years ago

Added F_SALES & F_CAMPAIGN_MANAGEMENT to Truncate Table step of Pre-Execution job.

fraserward commented 3 years ago

PULL REQUEST https://github.com/ivylabs/suitecrm-data-integration/pull/91 FEATURE REQUEST https://github.com/ivylabs/suitecrm-data-integration/tree/feature-89

harrisward commented 3 years ago

Test and works