am trying to get my datas into csv file and send it to email!
can anyone give me a flow of that
Given the amount of info you have provided I would suggest a csv node followed by an email out node.
Well i have an s7node to read datas from my plc... so i want to hold these datas into csv file and send to email
flows (4).json (7.4 KB)
here is my flow
You can paste the flow in here directly, using the </> button.
[{"id":"ff4435a0.6d6c88","type":"tab","label":"Power","disabled":false,"info":""},{"id":"3faf165e.1fe6aa","type":"ui_text","z":"ff4435a0.6d6c88","group":"7ab6a5e9.a7585c","order":2,"width":9,"height":1,"name":"","label":"Reactive Power / L1 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":520,"y":320,"wires":[]},{"id":"d3ff16cd.2489a8","type":"ui_text","z":"ff4435a0.6d6c88","group":"ed18524d.8e34","order":1,"width":9,"height":1,"name":"","label":"Active Power / L1 (Kw) :","format":"{{msg.payload}}","layout":"row-spread","x":510,"y":100,"wires":[]},{"id":"287a3989.2c23c6","type":"ui_text","z":"ff4435a0.6d6c88","group":"ed18524d.8e34","order":2,"width":9,"height":1,"name":"","label":"Active Power / L2 (Kw) :","format":"{{msg.payload}}","layout":"row-spread","x":510,"y":140,"wires":[]},{"id":"15b37ddd.56ab22","type":"ui_text","z":"ff4435a0.6d6c88","group":"ed18524d.8e34","order":3,"width":9,"height":1,"name":"","label":"Active Power / L3 (Kw) :","format":"{{msg.payload}}","layout":"row-spread","x":510,"y":180,"wires":[]},{"id":"2f7bf826.35c928","type":"ui_text","z":"ff4435a0.6d6c88","group":"7ab6a5e9.a7585c","order":1,"width":9,"height":1,"name":"","label":"Reactive Power / L2 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":520,"y":360,"wires":[]},{"id":"c0d30ff4.765bb","type":"ui_text","z":"ff4435a0.6d6c88","group":"7ab6a5e9.a7585c","order":3,"width":9,"height":1,"name":"","label":"Reactive Power / L3 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":520,"y":400,"wires":[]},{"id":"57b69970.e47be8","type":"ui_chart","z":"ff4435a0.6d6c88","name":"","group":"ed18524d.8e34","order":5,"width":9,"height":5,"label":"Active Power","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"50","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":470,"y":220,"wires":[[]]},{"id":"e33c48e8.cfef48","type":"ui_chart","z":"ff4435a0.6d6c88","name":"","group":"7ab6a5e9.a7585c","order":5,"width":9,"height":5,"label":"Reactive Power","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"30","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":480,"y":440,"wires":[[]]},{"id":"2f6cb738.9d0ce8","type":"ui_text","z":"ff4435a0.6d6c88","group":"8446d071.daa45","order":3,"width":9,"height":1,"name":"","label":"Apparent Power / L1 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":530,"y":560,"wires":[]},{"id":"50f15939.f29028","type":"ui_text","z":"ff4435a0.6d6c88","group":"8446d071.daa45","order":1,"width":9,"height":1,"name":"","label":"Apparent Power / L2 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":530,"y":600,"wires":[]},{"id":"86fdb3f3.39c69","type":"ui_text","z":"ff4435a0.6d6c88","group":"8446d071.daa45","order":2,"width":9,"height":1,"name":"","label":"Apparent Power / L3 (KVAR) :","format":"{{msg.payload}}","layout":"row-spread","x":530,"y":640,"wires":[]},{"id":"e11d6e6e.42c19","type":"ui_chart","z":"ff4435a0.6d6c88","name":"","group":"8446d071.daa45","order":5,"width":9,"height":5,"label":"Apparent Power","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"50","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":480,"y":680,"wires":[[]]},{"id":"4f380e5c.947a1","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Active Power A","diff":true,"name":"","x":180,"y":100,"wires":[["d3ff16cd.2489a8","57b69970.e47be8"]]},{"id":"bec944e0.fa5878","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Active Power B","diff":true,"name":"","x":180,"y":160,"wires":[["287a3989.2c23c6","57b69970.e47be8"]]},{"id":"a43e6647.29a088","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Active Power C","diff":true,"name":"","x":180,"y":220,"wires":[["15b37ddd.56ab22","57b69970.e47be8"]]},{"id":"5ef0f1c4.0185a","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Reactive Power A","diff":true,"name":"","x":190,"y":320,"wires":[["3faf165e.1fe6aa","e33c48e8.cfef48"]]},{"id":"298e5da7.57e042","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Reactive Power B","diff":true,"name":"","x":190,"y":380,"wires":[["2f7bf826.35c928","e33c48e8.cfef48"]]},{"id":"53d2a44a.04948c","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Reactive Power C","diff":true,"name":"","x":190,"y":440,"wires":[["c0d30ff4.765bb","e33c48e8.cfef48"]]},{"id":"98ada1c6.4a1c8","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Apparent Power A","diff":true,"name":"","x":190,"y":560,"wires":[["2f6cb738.9d0ce8","e11d6e6e.42c19"]]},{"id":"3d1647ed.9539a8","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Apparent Power B","diff":true,"name":"","x":190,"y":620,"wires":[["50f15939.f29028","e11d6e6e.42c19"]]},{"id":"a7e34005.0a06b","type":"s7 in","z":"ff4435a0.6d6c88","endpoint":"5fd9fbc4.ee2b04","mode":"single","variable":"Apparent Power C","diff":true,"name":"","x":190,"y":680,"wires":[["86fdb3f3.39c69","e11d6e6e.42c19"]]},{"id":"7ab6a5e9.a7585c","type":"ui_group","z":"","name":"Reactive Power","tab":"eeea01e8.f258b","order":2,"disp":true,"width":"9","collapse":false},{"id":"ed18524d.8e34","type":"ui_group","z":"","name":"Active Power","tab":"eeea01e8.f258b","order":1,"disp":true,"width":"9","collapse":false},{"id":"8446d071.daa45","type":"ui_group","z":"","name":"Apparent Power","tab":"eeea01e8.f258b","order":3,"disp":true,"width":9,"collapse":false},{"id":"5fd9fbc4.ee2b04","type":"s7 endpoint","z":"","transport":"iso-on-tcp","address":"192.168.1.3","port":"102","rack":"0","slot":"1","localtsaphi":"01","localtsaplo":"00","remotetsaphi":"01","remotetsaplo":"00","connmode":"rack-slot","adapterauto":true,"adapterport":"","busaddr":"2","adapteraddr":"0","cycletime":"500","timeout":"1500","verbose":"default","name":"s7 1200 data read","vartable":[{"addr":"DB3,R0","name":"Courant L1"},{"addr":"DB3,R4","name":"Courant L2"},{"addr":"DB3,R8","name":"Courant L3"},{"addr":"DB3,R16","name":"L1-L2"},{"addr":"DB3,R20","name":"L2-L3"},{"addr":"DB3,R24","name":"L3-L1"},{"addr":"DB3,R32","name":"L1-N"},{"addr":"DB3,R36","name":"L2-N"},{"addr":"DB3,R40","name":"L3-N"},{"addr":"DB3,R48","name":"Active Power A"},{"addr":"DB3,R52","name":"Active Power B"},{"addr":"DB3,R56","name":"Active Power C"},{"addr":"DB3,R64","name":"Reactive Power A"},{"addr":"DB3,R68","name":"Reactive Power B"},{"addr":"DB3,R72","name":"Reactive Power C"},{"addr":"DB3,R80","name":"Apparent Power A"},{"addr":"DB3,R84","name":"Apparent Power B"},{"addr":"DB3,R88","name":"Apparent Power C"}]},{"id":"eeea01e8.f258b","type":"ui_tab","z":"","name":"Puissances","icon":"dashboard","order":2,"disabled":false,"hidden":false}]
So that is a bunch of input nodes feeding into dashboard nodes... all good.
But we still have no idea what the csv should look like? How and when it should be sent?
You will probably want to use the join node to join all the messages into one object using their topics to identify them, and then maybe feed a csv and then the email... but that would just send all the time... probably not what you want.
All i want is to to get every 15min the file contain name of intput and the value thats it
No one can help me?
How have you got on with @dceejay's suggestion to use the Join node to get them all into one message. You can find an example of this in this cookbook flow.
https://cookbook.nodered.org/basic/join-streams
ok with that but am a beginner in this and i need a a flow to inderstand
In that case start by watching the excellent node red essentials videos. I think they are linked from the node red getting started guide.
Then you can import the flow from the cookbook and experiment to see how it works.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
