Bulk upload not posting data - MC node says successful about node-red-contrib-mindconnect HOT 6 CLOSED

Okay, so I have got it working. MindSphere was rejecting the data because of the timestamp format.
I was using the "toString()" function, which let it pass the MindConnect node checks but then obviously it got rejected.
To create a timestamp with "new Date()" would return a huge list of errors. It was just a matter of using the toISOString() function.

So in the end my timestamps would be made as such:
var timestamp = new Date().toISOString();
dict.timestamp = timestamp;

I'm quite a novice programmer, so I hope this info can help others like me in the future. Is it possible to add some tidbit like this to the docs for the bulk upload section?

Thanks for taking the time to assist in getting it all working!

from node-red-contrib-mindconnect.

@Peekaboo-Cockatoo At the first glance, you are using the local time stamp instead of the UTC time stamps in your msgFail.txt. Could you please convert those time stamps to UTC and try again ? (Sorry for the brevity, I am on vacation....)

from node-red-contrib-mindconnect.

@sn0wcat Changing the timestamp to UTC gives the exact same result unfortunately.

from node-red-contrib-mindconnect.

@Peekaboo-Cockatoo Have you already checked in the agent diagnostic app (on your launchpadj and/or talked to the support if MindSphere is dropping your data because of some misconfiguration / problem on the MindSphere side? When the agent says that the data has been delivered , it only means that the ingest endpoint has accepted them, not that the data has been stored in the iot or the aggregates have been built (these are both asynchronous processes)

https://documentation.mindsphere.io/resources/html/agent-diagnostic/en-US/122438280075.html

https://community.plm.automation.siemens.com/t5/General-Forum/Uploading-Time-Series-Data/td-p/598700

from node-red-contrib-mindconnect.

@sn0wcat Agent Diagnostics returns:

[Dropped] TimeSeries Data is dropped. Validation failed for reason <Pre-processing of <21> data points ended with <0> valid and <21> dropped data points. Following issues found: Invalid timestamps count is <7> resulting <21> data point value to be dropped.Invalid timestamps includes: <[Tue, 30 Jul 2019 01:31:14 GMT, Tue, 30 Jul 2019 01:31:17 GMT, Tue, 30 Jul 2019 01:31:20 GMT, Tue, 30 Jul 2019 01:31:23 GMT, Tue, 30 Jul 2019 01:31:26 GMT, Tue, 30 Jul 2019 01:31:29 GMT, Tue, 30 Jul 2019 01:31:32 GMT]>.>

I'll contact MindSphere Support and let you know the results.

from node-red-contrib-mindconnect.

The documentation has been updated.

https://opensource.mindsphere.io/docs/node-red-contrib-mindconnect/getting-started.html#tab1anchor3

from node-red-contrib-mindconnect.