Skip to main content
1-Visitor
October 24, 2019
Solved

What is best way to up loading large CSV file. C#

  • October 24, 2019
  • 1 reply
  • 935 views

I have large size csv.

 

It hasn't datetime info and many items and rows.

 

So I will input parameter Start time and interval time.

 

My code is VS C#.

 

I thin it will make store memory added time information by start time and interval.

 

and then send stream to Thingworx.

 

Can someone please tell me the ideal way?  

 

Currently my code is sending data based on one row of csv so it takes too long time.

I want to create it like a double buffering.
 
I want to send it to the stream at once without sending it several times.
 
Isn't it possible or is there a better way?
 
I would appreciate your reply.

 

 

 

 

 

Best answer by Constantine

Hello,

 

Take a look at AddStreamEntries service on the Stream, it allows adding multiple entries at once. You can execute it via REST call from your C# code as well.

 

/ Constantine

1 reply

18-Opal
October 26, 2019

Hello,

 

Take a look at AddStreamEntries service on the Stream, it allows adding multiple entries at once. You can execute it via REST call from your C# code as well.

 

/ Constantine