Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

posted in User help

Need to add hundreds, possibly thousands of event detectors and don't want to do it manually. We use macros, etc... to generate SQL queries based on point lists in Excel. This allows us to instantly setup the points, histories, event detectors, etc... without having to do the work.

If there's a better way, please advise.

posted in User help

We're looking to use a query such as:

INSERT INTO POINTEVENTDETECTORS (
XID,
ALIAS,
DATAPOINTID,
DETECTORTYPE,
ALARMLEVEL,
LOWLIMIT,
HIGHLIMIT,
DURATION,
DURATIONTYPE,
BINARYSTATE,
MULTISTATESTATE,
CHANGECOUNT,
ALPHANUMERICSTATE,
WEIGHT
) VALUES (
'PED_000001',
'Testing1',
'132',
'12',
'1',
'18.0',
'24.0',
'5',
'1',
'N',
'0',
'2',
'',
'0.0'
), (
'PED_000002',
'Testing2',
'132',
'12',
'1',
'17.0',
'25.0',
'5',
'1',
'N',
'0',
'2',
'',
'0.0'
);

...to insert point event detectors, however we can't seem to figure out where the XIDs are coming from? Any advice? Thanks!

jzwicker

@jzwicker

Latest posts made by jzwicker