[SR-Users] Siremis graph time format is a bug!?

[Humberto Rodríguez]

Hello:

I added a graphic to Siremis of my actives dialogs.  But, it only shows unix time (From 1969-12-31 19:33:37 To1969-12-31 19:33:37)   as Xaxis (19:33). I had siremis 4.2 and never saw it correctly, I just updated to Siremis 4.4 and I see the same problem.Please see the attachment file with the graph, and my configuration files and table bellow

Thanks in advance.


My /var/www/siremis-4.4.0/siremis/modules/ser/view/xxxx.xml file 

<?xml version="1.0" standalone="no"?>

<EasyView Name="ChartsSumdialogsView" Description="Charts" class="EasyView" Tab="" TemplateEngine="Smarty" Access="SERAdmin.Administer_Modules" TemplateFile="view.tpl">

    <FormReferences>

        <Reference Name="ser.cms.form.ChartsForm"/>

    </FormReferences>

</EasyView>

-----------------------------------------------------------
My siremisCharts.xml
----------------------------------------------------------
<ChartGroup name="sumdialogs">
          <Chart name="sumdialogs" table="active_dialogs" title="Active_Failed_Dialogs" type="area" order="reverse"
                        orderby="ORDER BY id DESC" limit="LIMIT 10080">
                <XAxis>
<!--                        <Item name="date_created" data="hour(date_created)" title="date_created" type="timestamp"/>  -->
                        <Item name="date_created" data="date_created" title="date_created" type="timestamp"/>  
                </XAxis>
                <YAxis>
                        <Item name="active_dialogs" data="active_dialogs" title="active_dialogs" type="dataset" color="#D02020"/>
							<Item name="failed_dialogs" data="failed_dialogs" title="failed_dialogs" type="dataset" color="#DFC329"/>
               </YAxis>
    </Chart>
  </ChartGroup>

---------------------------------------------------------------------------------------
See bellow, the portion of the table  used to build the graphic,  the column "date_created"  is the problem, and the format is "TIMESTAMP" 
------------------------------------------------------------------------------------------


# id, date_created, active_dialogs, early_dialogs, expired_dialogs, failed_dialogs, processed_dialogs, 
'1', '2017-04-11 14:40:40', '220', '0', '1219', '37', '6879491'
'2', '2017-04-11 14:42:02', '206', '0', '1219', '37', '6879604'
'3', '2017-04-11 14:43:01', '215', '0', '1219', '37', '6879685'
'4', '2017-04-11 14:44:01', '191', '0', '1220', '37', '6879744'
'5', '2017-04-11 14:45:02', '203', '0', '1220', '37', '6879837'
'9', '2017-04-11 14:46:01', '211', '0', '1220', '37', '6879929'
'11', '2017-04-11 14:47:01', '234', '0', '1220', '37', '6880019'
'12', '2017-04-11 14:48:01', '222', '0', '1220', '37', '6880087'

----------------------------------------------------------------------------------------------------------------------------------

No Matter How Hard The Past, You Can Always Begin Again ~
-------------- next part --------------
A non-text attachment was scrubbed...
Name: siremis_format.png
Type: image/png
Size: 29321 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170913/f6f2ecfd/attachment.png>