# Insert data into influxdb from node / windows causes problems **URL:** \ **Category:** Store\ **Tags:** influxdb, windows\ **Created:** [February 1, 2018, 7:26am UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847 "2018-02-01T07:26:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Nicholas\_Zdvorak](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Nicholas\_Zdvorak](https://community.influxdata.com/u/Nicholas_Zdvorak)\ **Post date:** [February 1, 2018, 7:26am UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/1 "2018-02-01T07:26:45Z")
I’m trying to insert data into InfluxDb using node/windows but there is a (seemingly well-know) bug that I am having trouble wrapping my mind around. I am trying to do a batch insert into my local db by loading data from a file and sending to my database using a POST. Here is the data that I am trying to insert: test\_data.txt > test\_measurement test=val1 1516665684 > test\_measurement price=val2 1516665685 > test\_measurement price=val3 1516665686 Using the code: > var http = require(“http”); > var fs = require(‘fs’); > > fs.readFile(‘test\_data.txt’, { encoding: ‘utf8’ }, function (err, data) { > var options = { > “method”: “POST”, > “hostname”: “localhost”, > “port”: “8086”, > “path”: “/write?db=test\_db”, > “headers”: { > “cache-control”: “no-cache” > } > }; > > var req = http.request(options, function (res) { > var chunks = ; > > ``` > res.on("data", function (chunk) { > chunks.push(chunk); > }); > > res.on("end", function () { > var body = Buffer.concat(chunks); > console.log(body.toString()); > }); > > ``` > > }); > > req.write(data); > req.end(); > }); And I get the error `{"error":"unable to parse 'test_measurement test=val1 1516665684\r': bad timestamp\nunable to parse 'test_measurement price=val2 1516665685\r': bad timestamp\nunable to parse 'test_measurement price=val3 1516665686': bad timestamp"}` From my research, I understand that windows uses \r\n characters as a carriage return, but I’m having trouble wrapping my mind around how to fix this. I’ve made attempts to remove all \r and \n characters when I read the file in, but it doesn’t seem to remove them, as I continue to get the same error. Even if I was able to remove them this way, how would influx know where the next insert of the batch began? It needs to know where the next line starts for a batch insert, but doesn’t like the new line characters. Any help would be great!! ---
**Author:** ![davidgs](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/davidgs/32/6936_2.png) [@davidgs](https://community.influxdata.com/u/davidgs)\ **Post date:** [February 1, 2018, 9:19pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/2 "2018-02-01T21:19:09Z")
I’m a bit confused by some of this, so hopefully you can clarify. Valid line-protocol is of the form: ``` measurement,tag1=tag_value,tag2=tag_value value=9999,value2=8888 timestamp ``` Your data is not being sent in the right format. first, there should be a comma `,` not a space ` ` after the measurement name followed by the tag=value (I’m assuming that “test=val1” is your tag. After that, you would insert your field values as field=value pairs, finally followed by a timestamp – though the timestamp is optional. See the line-protocol docs here :[Writing data with the HTTP API | InfluxDB OSS 1.4 Documentation](https://docs.influxdata.com/influxdb/v1.4/guides/writing_data/) for more information. If I’ve misinterpreted what you were doing/trying to do, please do let me know! Best regards, dg ---
**Author:** ![Nicholas\_Zdvorak](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Nicholas\_Zdvorak](https://community.influxdata.com/u/Nicholas_Zdvorak)\ **Post date:** [February 1, 2018, 9:23pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/3 "2018-02-01T21:23:58Z")
Hi David, I’m very new to influx so I could be wrong here, but I do not have any value that is worthy of being a tag, so i’m omitting tags. I just have a timestamp and two field values. I read that if you do not want tags, you can omit them by using the format: measurement value1=value1,value2=value2 timestamp And it has been working great! So I do not believe that this is a line-protocol format issue. The issue seems to be something to do with windows adding \r\n at the end of each line to represent a new line and influxdb not being capable of parsing that. ---
**Author:** ![davidgs](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/davidgs/32/6936_2.png) [@davidgs](https://community.influxdata.com/u/davidgs)\ **Post date:** [February 1, 2018, 10:03pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/4 "2018-02-01T22:03:38Z")
True, you can omit the tags. The ‘invalid boolean’ is actually indicative of the value not being correct. Try replacing val1, val2, etc. with numeric values, or quoting the string values and see if that changes things. dg ---
**Author:** ![Nicholas\_Zdvorak](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Nicholas\_Zdvorak](https://community.influxdata.com/u/Nicholas_Zdvorak)\ **Post date:** [February 1, 2018, 10:07pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/5 "2018-02-01T22:07:18Z")
Wow, sorry about that! It actually says ‘bad timestamp’, i have no idea how ‘invalid boolean’ got in there. It says ‘bad timestamp’ due to the fact that it’s trying to read 1516665684\r as a timestamp. Sry to mislead you there. Good catch. Edited my original question. ---
**Author:** ![davidgs](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/davidgs/32/6936_2.png) [@davidgs](https://community.influxdata.com/u/davidgs)\ **Post date:** [February 1, 2018, 10:11pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/6 "2018-02-01T22:11:07Z")
> [@Nicholas\_Zdvorak](#): > > test\_measurement test=val1 1516665684 > curl -i -XPOST ‘[http://localhost:8086/write?db=mydb](http://localhost:8086/write?db=mydb)’ --data-binary ‘test\_measurement test=val1 1516665684’ > HTTP/1.1 400 Bad Request > Content-Type: application/json > Request-Id: 656cfa5a-079c-11e8-98d4-000000000000 > X-Influxdb-Build: OSS > X-Influxdb-Error: unable to parse ‘test\_measurement test=val1 1516665684’: invalid boolean > X-Influxdb-Version: v1.4.2 > X-Request-Id: 656cfa5a-079c-11e8-98d4-000000000000 > Date: Thu, 01 Feb 2018 22:08:13 GMT > Content-Length: 85 > > {“error”:“unable to parse ‘test\_measurement test=val1 1516665684’: invalid boolean”} > Davids-MacBook-Pro:Downloads davidgs$ curl -i -XPOST ‘[http://localhost:8086/write?db=mydb](http://localhost:8086/write?db=mydb)’ --data-binary ‘test\_measurement test=“val1” 1516665684’ > HTTP/1.1 204 No Content > Content-Type: application/json > Request-Id: 6d390206-079c-11e8-98d7-000000000000 > X-Influxdb-Build: OSS > X-Influxdb-Version: v1.4.2 > X-Request-Id: 6d390206-079c-11e8-98d7-000000000000 > Date: Thu, 01 Feb 2018 22:08:26 GMT So val1 is invalid, but “val1” is ok. That’s the origin of your invalid boolean error. You will also, apparently, need to strip the \r and replace it with \n in order to make this successful. You should be able to use `string.replace()` to remove the `\r` from your lines in your JavaScript. ``` res.on("data", function (chunk) { chunk = chunk.replace("\r" ""); chunks.push(chunk); }); ``` dg ---
**Author:** ![Nicholas\_Zdvorak](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Nicholas\_Zdvorak](https://community.influxdata.com/u/Nicholas_Zdvorak)\ **Post date:** [February 1, 2018, 10:28pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/7 "2018-02-01T22:28:15Z")
Awesome!! It’s working when stripping the \r. This will be an extra step that I assume will slow things down a bit when looking at 100 million lines of data from files, but it looks like the best solution possible. Thanks for the help! ---
**Author:** ![yosiasz](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/yosiasz/32/8060_2.png) [@yosiasz](https://community.influxdata.com/u/yosiasz)\ **Post date:** [August 12, 2021, 8:54pm UTC](https://community.influxdata.com/t/insert-data-into-influxdb-from-node-windows-causes-problems/3847/8 "2021-08-12T20:54:55Z")
saved my bacon after spending hours thanks @davidgs !