search

ivylabs / suitecrm-analytics

4 stars 4 forks source link

Data Exporter Tool, Lead Export - The "Lead Created Period" options don't appear to reflect the Live CRM data #267

Closed johnM2401 closed 3 years ago

johnM2401 commented 3 years ago

Describe the bug The Lead Data Exporter shows Periods that don't reflect the Live Data.

eg:

Oddly, the Available Parameters do seem to be the same as the ones used in the Case Data Export, (where the data matches) Perhaps this is related?


Component What component does this bug relate to?

  1. Other - Data Exporter


Solution File ExportSuiteCRMAnalyticsData.wcdf - Lead Data Export


To Reproduce Steps to reproduce the behavior:

  1. Create Records in various months for the Leads Module (Can be manipulated by changing the "date_entered" value in the Database
  2. Push data from the CRM to the DWH, via the ./run script
  3. Navigate to the Lead Exporter
  4. Expand the "Lead Created Period" parameter, and compare available options to the CRM data


Expected behavior The Periods available should match the Periods in which CRM Data exists. However, the Exporter appears to show Periods where no Data exists, as well as not showing Periods where date exists.


Screenshots As an example, the "Lead Created Period" parameter seems to show Periods for May/April/January 2021 image

However, the this does not match the available data.

ie, there are no records in April: image

But there are records in March, where this was not a Parameter: image


Additionally, there are options for 2019: image

But there is no data for 2019: image

Desktop (please complete the following information):

OS: Ubuntu 18.04
Firefox 88.01
fraserward commented 3 years ago

Bug confirmed.

fraserward commented 3 years ago

Updated CDA file.

Pull Request: https://github.com/ivylabs/suitecrm-analytics/pull/269