Just check the values in database, if (now()+0) is not a valid unix timestamp value displayed as number, then siremis will just fetch the value and convert to integer.
Maybe in the future we will also add support for datetime values, but the spare time is rather limited here for a short term perspective.
Cheers, Daniel
On 15.09.17 22:10, Humberto Rodríguez wrote:
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 miconda@gmail.com wrote:
Subject: Re: [SR-Users] Siremis graph time format is a bug!? To: "Humberto Rodríguez" humberj77@yahoo.es, "Kamailio (SER) - Users Mailing List" sr-users@lists.kamailio.org, sr-users@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 itis 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> <ReferenceName="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@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