Feng Jin Liew

I am working with our customers  who are also using Seeq but the person I am working with wanted to know if he can export the signal (like the manual import CSV) in excel format. The company set up their data linked with the DeltaV for data acquisition so he can't provide me with the data to support him for analysis. They also can't create another company VPN account for me as I am an external/vendor of their company. I came across this function as I was trying to export the data in Excel following the instructions below

But I receive the message below

I have the Seeq sign-in credentials. Is there another step I missed?

That works! 

Hi Teddy,
Thank you for the response. I have a set of data that are measured every 0.03 mins and I would like the data to be visualized as a cumulative sum of every 3 mins. I may have used the wrong formula. How should I share the worksheet with you? 

I have this formula but I am trying to modify it to calculate cumulative sum of data every 3 minutes. The data I have are generated every 0.03 min. What should I put in the periods (blank) here or do I need another formula?

$Periods = periods( blank ) 

$average = $acc.aggregate(average(), $periods, durationkey()) 

$difference = $acc - $average 

$difference.aggregate(sum(), $periods, durationkey())

1 minute ago, Sean T said:

Hi Andrew and Feng,

We currently do not support importing CSV files with separate date and time columns as Andrew mentioned. There are quite a few date formats and we do not yet have support for all of them including separated date and time columd, for now please use the DateTime format that Andrew mentioned above. We do have a feature request in for supporting separate columns, if you would like, i can attach you to that item so you will be notified as it is worked on.

-Sean

That would be great, Sean. Please attach me to that item. 
Thank you!

7 minutes ago, Andrew Fontenot said:

The csv must contain one DateTime column if importing Signals, or two DateTime columns (Start and End) if importing conditions. If you open the csv in excel, you can simply sum the Date and Time columns to get a new DateTime column. As the error states, one example of this is row 7 which has a value of 11:00:43. This is only a Time, Seeq requires a DateTime such as 9/28/2021 11:00:43.

Hope this helps,

Andrew

Thank you, Andrew. I just realized I might have asked the wrong question. I understand that it would be easier to use the formula in excel to add another column as datetime. I am trying to find out if there is a way to not do that and still import the csv file into SeeQ, determine the datetime data without the column if the dashboard has a function to combine both data without a data table. 

I am having trouble importing CSV file with a time column. I have 2 columns related to time, 1 is date and 1 is time. However, I am getting an error message (see below). 

I am also not able to import multiple CSV files. I am not sure if that is never available to begin with.