Im trying to create a page in perspective that one user can enter information on a spreedsheet and all others can view it. Right now the plant has a shared excel spreedsheet but we want to have it displayed on the prespective sessions which run on fire TVs through out the plant. Is it possible to have a excel spreedsheet that can be edited on a perspective session? If not, is there an alternative that anyone has implemented?
Looking for any ideas or examples if anyone has done something like this before
I once created an uri that allowed you to open files on the device. Which could open the excel... ofc this will not be in the same window, it will open the excel in excel.
Also you have to install the uri on every device that wants to use this feature and they ofc all have to have access to the shared drive.
Might not be the best solution, but with my sample it should be pretty easy to test out (if the tvs work with windows, no idea what a fire tv is)
Than you can see if the client is happy enough with it.
You could place the excel on google drive or something and use an iframe to open that file in perspective directly, though not sure if google allows that...
It would be production data. Mostly times and values. So, how much product on what truck and at what time, that sort if thing. The spreed sheet is 15x15. I want the information to be on the page at all times and update when more information is added. Ive been playing around with a editable table but havent gotten very far with it.
What functionality in excel are you looking to replicate? An editable table isn’t difficult, depending on where the data is stored, but doing expression evaluation, while definitely attainable is not trivial.
Only formula would be an addition for totals. The spreedsheet is a new sheet everyday in an ongoing workbook. Right now the only place the data is being stored is in the recurring excel spreedsheet so i dont have any of it in a database.
We've been setting up ignition in a lot of factories where they used to have spreadsheets all over.
We never tried to replicate those spreadsheets, instead we asked the customer what they used them for, what the need was, and then came up with solutions that were adapted to ignition.
Ignition is not excel, don't make it do spreadsheets. Play with its strength instead.
I'm coming to realize that now. I need to make the perspective system the data entry point and use a database to store this information. I'm new to Ignition and SCADA systems all together so I appreciate all the help!
Use a table to show past records.
Create a Named Query to retrieve the records you want from the database.
Create a Query binding on the Table component's data property and that will populate the table.
Use a popup form to enter or edit records.
Add Save and Cancel buttons on the form.
Make the Save button's enabled property be true when all the fields have valid data. (Use an Expression binding.)
On the save button onActionPerformed event add a Script.
On the table | Right-click | Configure Scripts | + Add Handler. Give it a name and scope to match those of the previously configured sendMessage. In the script add the line, self.refreshBinding("props.data")
You have a bit to learn but it's all sensible stuff.
Don't do silly stuff with layout or color schemes. Use a standard Windows style form layout that users will be familiar with. Save and Cancel buttons on the bottom right, etc. On each text / numeric entry field you can create a custom property with an expression to check if there is valid data in the field. Then on the component's style properties add the border color property, and create an expression binding to the custom property to set the border color. See Perspective Built-In Themes | Ignition User Manual.
There are are two great examples of collecting/editing data in the sample project. Look under ignition 101 under data entry. There is a link to the message handlers on that page too. It should help ya hit the ground running.