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

Thanks Daniel-Constantin Mierla, I followed your recommendation, and began to use a date column as INT. Then, I started to insert the date as unix_timestamp, like this (unix_timestamp(now())), which was the only way the graphic showed the date correctly (Active_Failed_Dialogs_4_hours - From 2017-09-15 12:04:01 To 2017-09-15 16:00:01), I failed inserting (now()+0), siremis didn't understand this format too. Cheers, Hto Now No Matter How Hard The Past, You Can Always Begin Again ~ -------------------------------------------- On Thu, 9/14/17, Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; wrote: Subject: Re: [SR-Users] Siremis graph time format is a bug!? To: "Humberto Rodríguez" &lt;humberj77(a)yahoo.es&gt;es>, "Kamailio (SER) - Users Mailing List" &lt;sr-users(a)lists.kamailio.org&gt;rg>, sr-users(a)lists.sip-router.org Date: Thursday, September 14, 2017, 4:09 AM Hello, try to set the type of the time column to int, so it is retrieved as numeric timestam, not as formated datetime. Cheers, Daniel On 13.09.17 05:39, Humberto Rodríguez wrote: 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 ~ _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced Training - www.asipto.com Kamailio World Conference - www.kamailioworld.com