CSV Import of Conditions with Capsule Properties

[Allison Buenemann]

FAQ: I have a CSV file that has the start and end times of some historical events and various information about the events that I would like to use in my analysis in Seeq. How do I go about getting these events and all of their associated information into Seeq?

Solution:  Use the Import from CSV tool and Seeq Formula to bring in a condition comprised of each of these events and assign the data in each column of the CSV as a property of the condition. 

1. Ensure your CSV file is formatted correctly for import into Seeq. The first column should be the event start time, the second column should be the event end time, and all other data columns should be to the right of these. A list of acceptable timestamp formats can be found on the Seeq Knowledge Base in this article. 

2. Use the Import CSV File tool to bring the condition into Seeq. Drag and drop your CSV file or navigate to your file through Windows (Mac) Explorer. Under "Import File as" select "condition". Choose the start-time and end-time columns in the "Choose columns" section. Specify a max capsule duration that is just longer than your longest event. 

3. Once your condition is imported, use Seeq Formula to assign the data from the other columns of our CSV as properties of each capsule. 

Begin by using the item properties for the CSV imported condition to duplicate the condition to Formula.

Once in Formula, add the column headers from your CSV to the query in line 1 of the code, separated by commas. Then use the setProperty() function to assign each of the columns of the CSV as a property of each capsule. 

Once executed, the output is a new condition that looks exactly like the original from trend view in the display pane. However, this new condition has properties, that can be added to the capsules pane using the gridded+ button. 

[Devin]

Hi @Allison Buenemann. I'm so glad I ran into this post!! This is exactly what I need to do. I did notice this post is over a year old, and wondering if there is now a easier\less formula intensive way to do this? It's so common to have additional attributes in spreadsheet data that need to be in SEEQ as capsule properties I'm hoping the process is perhaps more automated, "spoon fed", faster, streamlined now, etc. Thanks again.

[Allison Buenemann]

Hi @Devin, beginning in version R22.0.48 this got much easier with the CSV Import Tool 2.0. You can learn more about the CSV Import 2.0 tool from this https://support.seeq.com/space/KB/537690127/Import%20CSV%20Files. If you need assistance upgrading your software to version 48+ feel free to reach out to your account manager or sales executive. 

[Devin]

Hi @Allison Buenemann. Thanks for the reply. Could you further expound (screenshots appreciated)? I read the wiki page above but it doesn't really show how to import the capsule properties. It just infers you can. Maybe I missed it.

[Allison Buenemann]

Hi @Devin,

When  you open the import from CSV file tool, select import file as condition. 

If you scroll down to the "+" icon that says "Optional Settings" you'll see that the default treatment of CSVs imported as a condition is to treat all columns as capsule properties.