Jump to content

Time format and multiple CSV import


Recommended Posts

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.

image.png.8cdea0d618fc2d4e5c4aa7b217142c0f.png

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

  • Seeq Team

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...