I have a csv file :
| time | Ziehkraft_IST_LIN | Ziehkraft_IST_LIN_int | COIL_ID |
|---|---|---|---|
| 15.08.2017 23:03:23.100000 | 771.572 | 77 | 1 |
| 15.08.2017 23:03:23.110000 | 721.65 | 77 | 2 |
| 15.08.2017 23:03:23.120000 | 775.572 | 77 | 3 |
but when sending my csv with node red it takes the current time:
need to fix it so that it takes the date as per my csv.
Hi @Nitesh,
How are you importing your CSV into InfluxDB? Are you using Telegraf?
No, i am using Node-red
Can you share a little bit more? It looks like it’s treating your time field as just another data field rather than the timestamp of the data, which is why it’s adding it’s own timestamp value
I’m not seeing your timestamp being added anywhere here, am I missing where that happens?
Also, I found node-red-contrib-influxdb (node) - Node-RED which says:
Note how timestamps are specified - the number of milliseconds since 1 January 1970 00:00:00 UTC. In this case do not forget to set “ms” in “Time Precision” (Advanced Query Options) of the “Influx Out Node”.
