ivylabs / suitecrm-data-integration

6 stars 5 forks source link

Lead Created TKs in Demo Data not being updated #184

Open fraserward opened 2 years ago

fraserward commented 2 years ago

Describe the bug LEAD_CONVERTED_TK are not going through the process of being updated in the Demo Data transformation when the dates of all demo data are being updated. This means overtime the converted lead dates fall further and further back into the past.

**Solution File populateLeadsManagament.ktr

To Reproduce Steps to reproduce the behavior:

  1. Run Demo Data
  2. Converted Dates are before Created Dates

Expected behavior Converted Dates are to be after Created Dates in all cases.

Additional context Updated the transformation to get an absolute number JAVA ABS step from the generated LEAD_CREATED_TK Use a Random Number Generator generating numbers below 1.0 Use the absolute numbers and times them against the generated numbers to created the new LEAD_CONVERTED_TK which will now be post LEAD_CREATED_TK when rerunning the Demo transformation