Time convert into influxdb timestamp

1

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:

current date
current date704×224 5.04 KB

need to fix it so that it takes the date as per my csv.

2

Hi @Nitesh,

How are you importing your CSV into InfluxDB? Are you using Telegraf?

3

No, i am using Node-red

4

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

6

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”.

7

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.