Feature request: download and reproduce all elements of a workbench analysis (signals, formulas, aesthetics) via CSV

[Jose]

Say I’ve set up a Seeq workbench analysis exactly just how I’d like it, with a TON of customizations to the trend aesthetics, a number of active/inactive signals, conditional statements, a few sprinkled in formulas, etc. I'd like to continue making similar workbench analyses for a remaining number of signals belonging to my process area, but it's a pain to reproduce the same workbench analysis N times over manually.

Is there a way to export my workbench analysis into some sort of CSV file that allows me to see each field and its associated value (e.g. which signals are actively trending, what lane they're on, how the trend is visualized like line width and color, what conditional statements exist and how they're defined, etc.)? I'd then want another script that can take that CSV file and reproduce the EXACT SAME workbench analysis with all its associated aesthetics, active/inactive signals, conditional statements, formulas, etc.

I'd also hope that the script which outputs a workbench analysis could output several workbench analyses all at once and optionally compile them all into a blue workbook. 

The implications of something like this would be immense for my role as it would enable me to very quickly take a concept workbench analysis and reproduce it N times with different signals and tailored analyses depending on the signal.

Does this exist? Will I need to become a part-time coder and write the script myself?

Edited July 10, 2024 by Jose

[Mark Derbecker]

Hi Jose,

Yes, if "part-time coder" means "some coding". You will need to use Seeq Data Lab to do this. All of what you want is possible, it is all covered by Workbook Templates, and here's the documentation:

https://python-docs.seeq.com/user_guide/Workbook Templates.html

You will need to get at least knee deep in Seeq Data Lab and Python to do this, but you may find that it enables all kinds of other great work that you might want to do. Also, our AI Assistant can give you lots of help if you have it enabled.

If you hit a wall, come back here and post again with what progress you've made.

[Jose]

Thanks, Mark.

I gave it a shot; unfortunately, I keep encountering errors when using spy.push on my configured template worksheet. 

I imagine troubleshooting these errors would go a lot smoother on a call with a Seeq expert. Who may I reach out to?

[Mark Derbecker]

Hi Jose-- the screenshot of the error message is cut off... can you take multiple screenshots so we can see everything?

[Jose]

Here you go: 

Edited July 12, 2024 by Jose

[Mark Derbecker]

Hmmm, somehow a bad character made its way into the template. Can you attach the Jupyter Notebook to this forum thread so I can take a look at your code?

[Jose]

See here: <Removed Internal Link>

Edited July 15, 2024 by John Brezovec

[John Brezovec]

Could you download the notebook and attach it to the thread? We're not able to access your internal link.

[Jose]

See attached.

JARTemplate_07152024.ipynb

[Mark Derbecker]

This is looking like a bug, SPy is not handling some aspect of what's in your template.

First, can you change your spy.workbooks.save() call to use a zip format by changing it to this:

spy.workbooks.save(workbooks, 'JAR1.zip', overwrite=True)

(Then also change your load call to use .zip extension.)

Then, can you please go to our Support Ticket site and log a request to investigate this? Please mention that you are working with Mark Derbecker and he requested that you log this.

Please attach the following:

1. The .ipynb file that you added to the message above.
2. The JAR1.zip file that was created by the spy.workbooks.save() call. You can download it from Jupyter to your machine if necessary.

I'll be out of the office until Friday July 19 but will take a look then.

[Jose]

Submitted; ticket SUP-52442.