Hello,

I am trying to use the data source of type "data file" and want to import .csv files from a specified directory.

1. I created a testing directory on the mango box. Tested that the directory exists using the check file option on
   the data source.

2. Placed a .csv file in the testing directory.

   The csv file contents is:

   TIME, DP_TEST_VALUE
   12/10/2014 7:09,-1
   12/10/2014 7:24,-2
   12/10/2014 7:30,-3

3. I added a data point to the data source called DP_TEST_VALUE in the .csv file.

I have data point details "Logging All".

I'm an seeing the value N/A value which is wrong. Not sure if the format is wrong. If someone can send me a link to
that can show a simple example as shown above that would be great.

Cheers,
Gary C

Hello,

I am trying to use the data source of type "data file" and want to import .csv files from a specified directory.

1. I created a testing directory on the mango box. Tested that the directory exists using the check file option on
   the data source.

2. Placed a .csv file in the testing directory.

   The csv file contents is:

   TIME, DP_TEST_VALUE
   12/10/2014 7:09,-1
   12/10/2014 7:24,-2
   12/10/2014 7:30,-3

3. I added a data point to the data source called DP_TEST_VALUE in the .csv file.

I have data point details "Logging All".

I'm an seeing the value N/A value which is wrong. Not sure if the format is wrong. If someone can send me a link to
that can show a simple example as shown above that would be great.

Cheers,
Gary C

Hello,

I would like to understand how the "valueRegEx" to be used against a JSON string in mango.

   "pointLocator":{
                    "dataType":"NUMERIC",
                    "ignoreIfMissing":false,
                    "timeFormat":"",
                    "timeRegex":"",
                    "valueFormat":"",
                    "valueRegex":"\"id\":\"10001\",\"type\":\"batteryzone\".*?\"dcvoltage\":\"(.*?)\",\".*?\"currinputs\""
            },

I know its gets the dcvoltage from the json string but don’t know how it terminates (I’m assuming currinputs match). I want to start from a different point in the json string.

Thanks,
Gary C

Hello,

I would like to understand how the "valueRegEx" to be used against a JSON string in mango.

   "pointLocator":{
                    "dataType":"NUMERIC",
                    "ignoreIfMissing":false,
                    "timeFormat":"",
                    "timeRegex":"",
                    "valueFormat":"",
                    "valueRegex":"\"id\":\"10001\",\"type\":\"batteryzone\".*?\"dcvoltage\":\"(.*?)\",\".*?\"currinputs\""
            },

I know its gets the dcvoltage from the json string but don’t know how it terminates (I’m assuming currinputs match). I want to start from a different point in the json string.

Thanks,
Gary C

I’m using mango to do this so. It will use a HTTP request to get the data which is returned in json.

"xid":"DP_50009_1",
	"loggingType":"ON_CHANGE",
	"intervalLoggingPeriodType":"MINUTES",
	"intervalLoggingType":"INSTANT",
	"purgeType":"YEARS",
	"pointLocator":{
		"dataType":"NUMERIC",
		"ignoreIfMissing":false,
		"timeFormat":"",
		"timeRegex":"",
		"valueFormat":"",
		"valueRegex":"\"id\":\"50009\",\"type\":\"controlfunctionasset\".*?\"ReferenceInput\":\"(.*?)\",\".*?\"cmddata\""

The above is the datapoint I'm importing.

Hello,

I'm new to mango. I'm importing a pointLocator with a regular expression:

"valueRegex":""id":"50009","type":"controlfunctionasset".?"ReferenceInput":"(.?)",".*?"cmddata""

{"assets":{"controlfunctionasset":[{"id":"50009","type":"controlfunctionasset","label":"VOLTAGE_REGULATION_CF","model":"voltageregulation","extant":"true","Ts":"0.017","Enabled":"false","Hold":"false","Reset":"false","ResetValue":"0.000","Output":"0.000","UpperLimitHit":"false","LowerLimitHit":"false","OperationFault":"false","ExternalFault":"false","ReferenceInput":"0.000","DebugLevel":"0","Initialized":"true","Gain":"1.000","PreGainOutput":"0.000","CompareInput":"0.000","CompareInputGain":"1.000","LimHi":"false","LimLo":"false","Vtest1":"0.000","Deadband":"0.010","MaxCommand":"1.000","MinCommand":"-1.000","Kv":"1.000","Kgv":"1.000","Kpv":"0.000","Kiv":"1.000","Krv":"1.000","Kdroopv":"0.000","Slew":"9.000","SlewDef":"1.000","QtestActive":"false","QtestCmd":"0.000","Unwind":"false","UsePControlOnly":"false","KpvActive":"0.000","KdroopvActive":"0.000","VRef":"0.000","Qvr":"0.000","PiErr":"0.000","POutput":"0.000","IOutput":"0.000","DroopSignal":"0.000","RampInput":"0.000","RampOutput":"0.000","cmddata":{"Enabled":"false","Hold":"false","Reset":"false","ResetValue":"0.000","ExternalFault":"false","ReferenceInput":"480.000","CompareInput":"0.000","MaxCommand":"2000.000","MinCommand":"-2000.000","Deadband":"4.800","Kv":"100.000"}}]}}

I would like the ReferenceInput after the cmddata? Not the first one. Dont know how the valueRegEx works? Is there a test site or tool I can use?

Much Appreciated,
Gary C

Hello,

I'm new to mango. I'm importing a pointLocator with a regular expression:

"valueRegex":""id":"50009","type":"controlfunctionasset".?"ReferenceInput":"(.?)",".*?"cmddata""

{"assets":{"controlfunctionasset":[{"id":"50009","type":"controlfunctionasset","label":"VOLTAGE_REGULATION_CF","model":"voltageregulation","extant":"true","Ts":"0.017","Enabled":"false","Hold":"false","Reset":"false","ResetValue":"0.000","Output":"0.000","UpperLimitHit":"false","LowerLimitHit":"false","OperationFault":"false","ExternalFault":"false","ReferenceInput":"0.000","DebugLevel":"0","Initialized":"true","Gain":"1.000","PreGainOutput":"0.000","CompareInput":"0.000","CompareInputGain":"1.000","LimHi":"false","LimLo":"false","Vtest1":"0.000","Deadband":"0.010","MaxCommand":"1.000","MinCommand":"-1.000","Kv":"1.000","Kgv":"1.000","Kpv":"0.000","Kiv":"1.000","Krv":"1.000","Kdroopv":"0.000","Slew":"9.000","SlewDef":"1.000","QtestActive":"false","QtestCmd":"0.000","Unwind":"false","UsePControlOnly":"false","KpvActive":"0.000","KdroopvActive":"0.000","VRef":"0.000","Qvr":"0.000","PiErr":"0.000","POutput":"0.000","IOutput":"0.000","DroopSignal":"0.000","RampInput":"0.000","RampOutput":"0.000","cmddata":{"Enabled":"false","Hold":"false","Reset":"false","ResetValue":"0.000","ExternalFault":"false","ReferenceInput":"480.000","CompareInput":"0.000","MaxCommand":"2000.000","MinCommand":"-2000.000","Deadband":"4.800","Kv":"100.000"}}]}}

I would like the ReferenceInput after the cmddata? Not the first one. Dont know how the valueRegEx works? Is there a test site or tool I can use?

Much Appreciated,
Gary C