Create a new import file format from SciStream manage formats of the Data Import app

Prior to this task:

✔ Spotfire for Signals (item) must be opened.

✔ Data Import app must be opened.

1️⃣ Data Import – Analysis tab ➡ select  [Configuration]
2️⃣ Data Import – Configuration tab ➡ select  [Manage formats]
3️⃣ SciStream window ➡ select [Add…]
4️⃣ Open window ➡ browse and select file(s)
5️⃣ Open window ➡ select  [Open]
6️⃣ SciStream window ➡ select  [Manage Formats…]
7️⃣ Manage Formats window ➡ select  [New…]
8️⃣ Create File Format window ➡ select/type Name Description The data format Each well has Layout Worksheets Name Worksheets Positions Primary Delimiter Secondary Delimiter FileName Delimiter Plate Rows Plate Columns File Header Rows Plate Header Rows Data Block Headers Rows Data Block Column Headers Data Blocks Per Plate Data Block Footer Rows Plate Footer Rows File Footer Rows Columns ➡ modify accordingly
9️⃣ Create File Format window ➡ select [Save]
🔟 Manage Formats window ➡ select [Close] (This last close action is also taken for the SciStream window)

Supporting Knowledge

SciStream enables users to import, aggregate, and organize raw instrument data and metadata files within Spotfire for Signals. This allows scientists to efficiently batch import instrument data files from plate readers, high-content screening readers, and flow cytometers, along with associated metadata, experimental details, and plate layouts, ensuring instant and seamless access to data.

There are several file types supported for importing instrument files through the SciStream data source, including Excel, .csv, .txt, EZreader (rst), and Flow Cytometry (fcs) files.

Note: Excel sheets in a multi-page document can be identified by name.

Note: SciStream parsing can be set to begin at a specified keyword if applicable.

Note: From the Create File Format window, under the Columns area, there will already be other columns by default; these should not be deleted or modified, since they will be needed for the main table.

Alternatively, the user can create a new import file format when creating a new data table from an instrument file. From the Spotfire for Signals start page, select  [Files and data]. From the Files and data flyout, select the [Other] option, then from Other options, select Instrument Files with SciStream. This will open the SciStream options. From the SciStream window, follow previous steps 6️⃣ through 🔟 to create the import file format. Once this is done, from the Add data to analysis pane, select the  [Rename data table] icon and type the new name; under import, select Add as new data table; then select the  [OK] button.