ivylabs / suitecrm-data-integration

6 stars 5 forks source link

Fix the Lead Converted Dates in the Demo CSV file #185

Open fraserward opened 2 years ago

fraserward commented 2 years ago

Currently the Demo CSV files bring LEAD_CONVERTED_TK as a Date TK and not a random number like the other date logic.

Create some ETL to make random numbers which will make the converted date operate like all other dates in the demo date.

Make sure the converted date number is always beyond the created date so we done have items converted before they are created.