WorldMap Issue - JSON-DB


#1

Using the postcode-lookup node to lookup up lat/long for pinning to the WorldMap.

This works very well when connecting the postcode node directly to it. However, with the amount of postcode lookups being pushed and the time it takes to return the results and plot on the map, thought it best to regularly refresh a local store (utilsing DataIn/Out Json-DB node) where the map can be fed via user desire (button).

All seems to work great but when I have the exact same data fed via the Data out of the JSON-DB to the WorldMap node, nothing is plotted.

Comparing the msg / payloads of both direct and via the store, they seem to be exactly the same. Could anyone suggest what is happening here? I am joining the postcode output into an array for storing and splitting once recovered from the JSON-DB but the data looks exactly the same.

Help!

Thanks

M0CRT

[{"id":"a1b3bdf3.f1c4c","type":"ui_button","z":"c6c8da13.897d68","name":"","group":"157db759.2fc6e9","order":25,"width":"6","height":"1","passthru":false,"label":"30 Day Attendances - MEX","color":"","bgcolor":"Blue","icon":"","payload":"","payloadType":"str","topic":"30DayAttendancesMEX","x":1435,"y":3004.000823020935,"wires":[["135b059f.6e464a"]]},{"id":"8f5820fd.148e4","type":"postcode-lookup","z":"c6c8da13.897d68","name":"","postcode":"","x":1328.2657012939453,"y":2638.382887840271,"wires":[["204ee702.eabdc8","7b1bc1b4.7cdde","12d2ccff.2073f3"]]},{"id":"12d2ccff.2073f3","type":"change","z":"c6c8da13.897d68","name":"","rules":[{"t":"set","p":"payload.lon","pt":"msg","to":"payload.longitude","tot":"msg"},{"t":"set","p":"payload.lat","pt":"msg","to":"payload.latitude","tot":"msg"},{"t":"set","p":"payload.name","pt":"msg","to":"name","tot":"msg"},{"t":"set","p":"payload.layer","pt":"msg","to":"Attendances","tot":"str"},{"t":"set","p":"payload.iconColor","pt":"msg","to":"Blue","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1713.5237770080566,"y":2631.5398712158203,"wires":[["711fed42.c18c44"]]},{"id":"3bceb0b5.00f05","type":"delay","z":"c6c8da13.897d68","name":"","pauseType":"rate","timeout":"5","timeoutUnits":"seconds","rate":"50","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":1096.5,"y":2636,"wires":[["8f5820fd.148e4"]]},{"id":"c6dca4fa.591618","type":"inject","z":"c6c8da13.897d68","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":1449.7737655639648,"y":2928.391445159912,"wires":[["135b059f.6e464a"]]},{"id":"e7e9e92f.d39fc8","type":"DataIn","z":"c6c8da13.897d68","collection":"251e99e8.6886f6","name":"","update":false,"path":"/Attendances/30Days/Mex","x":1485.7738418579102,"y":2851.906904220581,"wires":[]},{"id":"135b059f.6e464a","type":"DataOut","z":"c6c8da13.897d68","collection":"251e99e8.6886f6","name":"","path":"/Attendances/30Days/Mex","error":true,"x":1723.7894744873047,"y":2954.7272176742554,"wires":[["434c1180.bc89f"]]},{"id":"7b1bc1b4.7cdde","type":"join","z":"c6c8da13.897d68","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":1409.8333282470703,"y":2766.3334970474243,"wires":[["e7e9e92f.d39fc8"]]},{"id":"434c1180.bc89f","type":"split","z":"c6c8da13.897d68","name":"","splt":"\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":1715.1666717529297,"y":2781.0008153915405,"wires":[["12d2ccff.2073f3"]]},{"id":"204ee702.eabdc8","type":"trigger","z":"c6c8da13.897d68","op1":"","op2":"true","op1type":"nul","op2type":"bool","duration":"5","extend":true,"units":"s","reset":"","bytopic":"all","name":"","x":1146.5003967285156,"y":2713.33349609375,"wires":[["f89d6c1b.7b496"]]},{"id":"f89d6c1b.7b496","type":"change","z":"c6c8da13.897d68","name":"","rules":[{"t":"delete","p":"payload","pt":"msg"},{"t":"set","p":"complete","pt":"msg","to":"true","tot":"bool"}],"action":"","property":"","from":"","to":"","reg":false,"x":1220.1668167114258,"y":2818.3334980010986,"wires":[["7b1bc1b4.7cdde"]]},{"id":"711fed42.c18c44","type":"worldmap","z":"c6c8da13.897d68","name":"","lat":"53.530","lon":"-1.109","zoom":"11","layer":"OSM","cluster":"","maxage":"0","usermenu":"show","layers":"show","panit":"false","x":1800,"y":2439.00048828125,"wires":[]},{"id":"157db759.2fc6e9","type":"ui_group","z":"","name":"ED - Live","tab":"91e09b2a.c9cbd8","order":5,"disp":true,"width":"40","collapse":true},{"id":"251e99e8.6886f6","type":"json-db-collection","z":"","name":"30 Day Attendances MEX","collection":"30DayAttendancesMEX","save":true},{"id":"91e09b2a.c9cbd8","type":"ui_tab","z":"","name":"DBTH Ops - ED","icon":"dashboard","order":9}]


#2

Show us the output of a debug node in each case.


#3

Colin

I'm embarrassed.

The join prior to the store removed a msg.{name} which then did not form part of the array and thus when split on the otherside was not there and guess what I was using to set the 'name' in worldmap for the pins...yes...that field.

Cough cough.

All working now! Thanks for the reply

Mo


#4

Unfortunately the human brain seems to be hard wired to see what it expects to see, not necessarily that which is actually there.