Hi together,

for some unknown reasons the database has "NaN"-entries. This entries make problems with the "sum" and also with the "integral" calculations, they are simply wrong. The pattern why it happens is not clear for me, but I will check further.What I realized is, that a bunch of datapoints has the NaN-entry at the same timestamp.

Now my question. How can I clean this up?

The available backend-scripts are not showing such examples, but it looks like this will be the best way. API did offer some methods, but it is not documented that good that I can find a way.

Ideas for the script:

1. loop through all datapoints
2. query values of the first datapoint and search for NaN-values

This example query the values via sql-console, but "delete" command is not allowed here.

SELECT * FROM POINTVALUES WHERE DATAPOINTID = 28 AND nullif(POINTVALUE, 'NaN') is null

--output

ID	DATAPOINTID	DATATYPE	POINTVALUE	TS
14134	28	3	NaN	1700760554775
19447	28	3	NaN	1700762775326
20933	28	3	NaN	1700763381424
201309	28	3	NaN	1711605424899

3. use the informations "datapointid" and "ts" to delete the values
4. go on with next datapoint.

I want to use it also for cleaning values that are infinite or out of set value ranges (extreme), but this is an second requirement.

Are there some best practices and examples available?

Regards
Sasa

Hi together,

I read the post how to add an button with quick dates: https://forum.mango-os.com/post/19141

An addition to this topic is how to configure the time? The preset time is always the current time, but I need an custom time like 06:00 a.m. for "from" and "to", so the user don't need to setup again. Often ranges are selected for a shift so this would be the goal.

Some ideas?

@Jared-Wiltshire how to change the time? It should not use "now" - instead a fix time like 06:00 a.m.

Thanks!

Do you see problems with snapshots, because of the SQL or NOSQL databases?

KR,
Sasa

@phildunlap

That´s it - solved!

Thx & Cheers
Sasa

Thank you Phil,

here is the output and it is 100% used, right!

Should I remove all from /var/spool/exim4/input? What exact redirect do you recommend?

Sorry for the title. It was an older issue with this exception, but it seems not affect the current error. Here is still the "tsdb" exception:

ERROR 2017-05-13 11:58:46,511 (com.infiniteautomation.nosql.MangoNoSqlBatchWriteBehind.execute:110) - Error saving point value. 
org.tinytsdb.TinyTSDBException: java.io.IOException: No space left on device
	at org.tinytsdb.impl.TinyTSDBImpl.write(TinyTSDBImpl.java:309)
	at com.infiniteautomation.nosql.MangoNoSqlPointValueDao.savePointValueSync(MangoNoSqlPointValueDao.java:65)
	at com.infiniteautomation.nosql.MangoNoSqlBatchWriteBehind.execute(MangoNoSqlBatchWriteBehind.java:96)
	at com.serotonin.m2m2.rt.maint.BackgroundProcessing$1.run(BackgroundProcessing.java:54)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.IOException: No space left on device
	at java.io.UnixFileSystem.createFileExclusively(Native Method)
	at java.io.File.createNewFile(File.java:1012)
	at org.tinytsdb.impl.Shard.ensureDirty(Shard.java:325)
	at org.tinytsdb.impl.Series.write(Series.java:160)
	at org.tinytsdb.impl.Series.write(Series.java:145)
	at org.tinytsdb.impl.TinyTSDBImpl.write(TinyTSDBImpl.java:301)
	... 6 more

INFO  2017-05-30 16:47:35,858 (com.serotonin.m2m2.Main.main:82) - Starting Mango 2.7.12 with Schema Version: 12 
INFO  2017-05-30 16:47:37,464 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'sqlds', v1.6.2 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,546 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'TCPIP', v1.1.5 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,558 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'asciiFile', v1.2.1 by Infinite Automation 
INFO  2017-05-30 16:47:37,570 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'sqlConsole', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,583 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'galil', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,598 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'sstGlobalScripts', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,610 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'mbus', v1.1.3 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,629 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'log4jDS', v1.1.2 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,640 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'persistent', v1.6.5 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,652 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'vmstat', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,663 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'mangoApi', v1.1.7 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,674 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'pointLinks', v1.5.5 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,687 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'log4JReset', v1.1.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,691 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'sstTheme', v1.1.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,698 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'jmxds', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,715 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'twilio', v1.1.2 by (unknown vendor) 
INFO  2017-05-30 16:47:37,731 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'mangoESConfiguration', v1.1.7 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,746 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'meta', v2.2.4 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,759 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'excelReports', v1.0.6 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,782 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'snmp', v1.5.3 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,793 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'http', v1.5.2 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,810 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'controlcore', v1.1.1 by Infinite Automation 
INFO  2017-05-30 16:47:37,821 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'graphicalViews', v1.6.7 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,869 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'scripting', v1.1.2 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,882 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'watchlists', v1.7.4 by Infinite Automation Software 
INFO  2017-05-30 16:47:37,904 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'dataPointDetailsView', v1.0.5 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,917 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'modbus', v1.6.5 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:37,933 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'dashboards', v3.2.2 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:38,175 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'onewire', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,196 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'virtualDS', v1.5.2 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,208 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'dataFile', v1.1.1 by Infinite Automation 
INFO  2017-05-30 16:47:38,230 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'ssh', v1.1.1 by Infinite Automation 
INFO  2017-05-30 16:47:38,242 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'dnp3', v1.6.2 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:38,254 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'dataImport', v1.4.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,265 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'pop3', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,276 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'jspViews', v2.1.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,292 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'templateConfig', v1.0.8 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,310 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'BACnet', v2.2.4 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,325 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'pid', v1.1.1 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:38,339 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'zwave', v1.1.2 by Infinite Automation 
INFO  2017-05-30 16:47:38,378 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'egauge', v1.1.1 by Infinite Automation 
INFO  2017-05-30 16:47:38,389 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'openv4j', v1.1.2 by aploese 
INFO  2017-05-30 16:47:38,393 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'scheduledEvents', v1.5.2 by (unknown vendor) 
INFO  2017-05-30 16:47:38,404 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'loggingConsole', v1.1.1 by Infinite Automation 
INFO  2017-05-30 16:47:38,415 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'sstGraphics', v1.1.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,452 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'mangoNoSqlDatabase', v1.2.3 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,465 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'reports', v2.2.3 by Infinite Automation Systems Inc. 
INFO  2017-05-30 16:47:38,479 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'maintenanceEvents', v1.5.1 by Infinite Automation Software 
INFO  2017-05-30 16:47:38,491 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'serial', v1.2.1 by Infinite Automation 
INFO  2017-05-30 16:47:38,503 (com.serotonin.m2m2.Main.loadModules:417) - Loading module 'internal', v1.5.3 by Infinite Automation Software 
INFO  2017-05-30 16:47:41,325 (com.infiniteautomation.mangoApi.MangoApiReloadingProperties.checkForReload:146) - (mangoApiHeaders) Found updated file at /opt/mango/web/modules/mangoApi/classes/mangoApiHeaders.properties. Reloading properties 
INFO  2017-05-30 16:47:41,714 (com.serotonin.m2m2.Lifecycle.loadLic:464) - Checking license... 
INFO  2017-05-30 16:47:42,019 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42) - Initializing H2 connection manager 
FATAL 2017-05-30 16:47:44,554 (com.serotonin.m2m2.db.DatabaseProxy.initialize:190) - Unable to connect to database of type H2 
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: Error opening database: "Could not save properties /opt/mango/databases/mah2.lock.db" [8000-181]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:615)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
	at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
	at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:204)
	at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:106)
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:602)
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:280)
	at com.serotonin.m2m2.Main.main(Main.java:116)
Caused by: org.h2.jdbc.JdbcSQLException: Error opening database: "Could not save properties /opt/mango/databases/mah2.lock.db" [8000-181]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.store.FileLock.getExceptionFatal(FileLock.java:456)
	at org.h2.store.FileLock.save(FileLock.java:225)
	at org.h2.store.FileLock.lockFile(FileLock.java:352)
	at org.h2.store.FileLock.lock(FileLock.java:135)
	at org.h2.engine.Database.open(Database.java:631)
	at org.h2.engine.Database.openDatabase(Database.java:266)
	at org.h2.engine.Database.<init>(Database.java:260)
	at org.h2.engine.Engine.openSession(Engine.java:60)
	at org.h2.engine.Engine.openSession(Engine.java:167)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
	at org.h2.engine.Engine.createSession(Engine.java:128)
	at org.h2.engine.Engine.createSession(Engine.java:26)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
	at org.h2.Driver.connect(Driver.java:72)
	at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
	at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
	at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
	at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
	at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 12 more
Caused by: java.io.FileNotFoundException: /opt/mango/databases/mah2.lock.db (No space left on device)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:101)
	at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:290)
	at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:233)
	at org.h2.store.FileLock.save(FileLock.java:213)
	... 33 more
ERROR 2017-05-30 16:47:44,562 (com.serotonin.m2m2.Main.main:120) - Error during initialization 
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: Error opening database: "Could not save properties /opt/mango/databases/mah2.lock.db" [8000-181]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:615)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
	at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
	at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:204)
	at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:106)
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:602)
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:280)
	at com.serotonin.m2m2.Main.main(Main.java:116)
Caused by: org.h2.jdbc.JdbcSQLException: Error opening database: "Could not save properties /opt/mango/databases/mah2.lock.db" [8000-181]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.store.FileLock.getExceptionFatal(FileLock.java:456)
	at org.h2.store.FileLock.save(FileLock.java:225)
	at org.h2.store.FileLock.lockFile(FileLock.java:352)
	at org.h2.store.FileLock.lock(FileLock.java:135)
	at org.h2.engine.Database.open(Database.java:631)
	at org.h2.engine.Database.openDatabase(Database.java:266)
	at org.h2.engine.Database.<init>(Database.java:260)
	at org.h2.engine.Engine.openSession(Engine.java:60)
	at org.h2.engine.Engine.openSession(Engine.java:167)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
	at org.h2.engine.Engine.createSession(Engine.java:128)
	at org.h2.engine.Engine.createSession(Engine.java:26)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
	at org.h2.Driver.connect(Driver.java:72)
	at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
	at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
	at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
	at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
	at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 12 more
Caused by: java.io.FileNotFoundException: /opt/mango/databases/mah2.lock.db (No space left on device)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:101)
	at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:290)
	at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:233)
	at org.h2.store.FileLock.save(FileLock.java:213)
	... 33 more
INFO  2017-05-30 16:47:44,565 (com.serotonin.m2m2.Lifecycle.terminate:344) - Mango Lifecycle terminating...

Hi together,
we had a deactivated point on the MangoES. After reboot the server did not start. The logs are attached. We have enough space on the disk.

Some suggestions?

Regards, Sasa

[0_1496157253251_ma.log](Uploading 100%)

Hello together!

A third party system get´s some datapoints from our MangoES over the RESTful API (swagger).

I showed them this topic: http://help.infiniteautomation.com/support/solutions/articles/14000023292-mango-rest-api-authentication

but they had no success to develop something that works. The theory of authentication and the cookie-handling should be clear.

Could it be that their is a lack of information in case of implementing swagger librarieres that are needed?

Thx
Sasa

Hi guys,

I will get in hear instead of creating a new topic.

A third party system get´s some datapoints over RESTful API (swagger). They got the Java-Client-Example from here http://help.infiniteautomation.com/support/solutions/articles/14000023292-mango-rest-api-authentication
but had no success to develop something good. The theory of authentication and the cookie-handling are clear.

The problem is to realize the Java-Client without more informations about libraries,..... Are their some librarieres that we missed?

Regards
Sasa

Thank you for the interesting news Joel!
I had a bit contact with swagger and will dive deeper now to get it going.

Regards,
Sasa

Hi Phil,

thank you for the help. I will start with the implementation work now.

Sasa

Hi together,

I opened an new topic, because I couldn´t find helpful informations about "restful" in the forum. I think that is an often chosen way to push data, so it would be cool to have an complete documentation for that.

Case: An external system expects data from mango. It uses RESTful webservices.

Here is the definition:

The datastructure looks like:

{
"identifier": "1",
"timestamp": "1475157787",
"value" : "10",
"type" : "27",
"status" : "1",
"smgwid" : "1",
"obis" : "1-0:1.8.0",
"validation": "xyz"
}

I tried to use the HTTP-sender method, but couldn´t find a successful way to get it going. Looking at Phil´s work from this topic

http://infiniteautomation.com/forum/topic/2187/how-to-use-publishers-http-sender/4

gives me hope that it could work, because he creates an URL with custom fields.

Has someone experiences with that method or suggestions how it could work with given system methods?

Regards
Sasa

@phildunlap

Hi Phil,

I had an error in the post. It is "post" not "push". Sorry for that!
Mango has to send the JSON data to an external service (REST).

Is there something ready in Mango?

Regards
Sasa

@phildunlap

Hi Phil,

I had an error in the post. It is "post" not "push". Sorry for that!
Mango has to send the JSON data to an external service (REST).

Is there something ready in Mango?

Regards
Sasa

@phildunlap

Hi Phil,

what do you prefer in this case. We have to push values to a webservice (HTTP: PUSH) The excepted form is:

{
"identifier": "1",
"timestamp": "1475157787",
"value" : "10",
"type" : "27",
"status" : "1",
"smgwid" : "1",
"obis" : "1-0:1.8.0",
"validation": "xyz"
}

I hope it matches this topic. Some suggstions?
Regards
Sasa

Terry,

thank you for your help. I used the type "HTTP Retriever" where it is possible to create points by choosing the groups of the matched regular expression (now I understand the functionallity ;-)). I had to change the expression a little bit. Here is the working implementation as example for others and documentation.

Regular Expression

.*"tuples": [ [ ([0-9]+), ([0-9]+\.[0-9]+).] ] \} ] \}

Target string:

{ "version": "0.5.1", "generator": "vzlogger", "data": [ { "uuid": "123", "last": 1470924327196, "interval": 5, "protocol": "d0", "tuples": [ [ 1470924327195, 115.185 ] ] } ] }

Matcher

group(0)	{ "version": "0.5.1", "generator": "vzlogger", "data": [ { "uuid": "123", "last": 1470924327196, "interval": 5, "protocol": "d0", "tuples": [ [ 1470924327195, 115.185 ] ] } ] }

group(1)	1470924327195

group(2)	115.185

Configuration in Mango for choosing the value group 2 (115.185)

.

Value in the watchlist

.

Thank you very much!
Sasa

Hi together,

I need some help with this data:

That data comes from a software logger over http-service in json-fomat. I need the two parameters under "tuples": [(timestamp, value)]. Some suggestions? I was trying out some variants of data sources, but it didn´t worked.

Regards
Sasa

Re: Developing a module

Hi Matteo,

the environment works for me with eclipse, but I want to have it on intellij. Can you provide me the process in a short way how you implement it.

Thanks
Sasa