Possibilites with buttons

[[To...]]

Hi

I have asked half of this question before, but maybe someone has gotten smarter since and have the solution.

We export all of our measuring data to another system by exporting a the table file, but the table file is generated at the same time as the measurement report, so it is not possible for us to edit any of the header parameters before the table file is created.
One of our header parameters is the reason why the measurement has to be performed.

I would like the possibility that a button could change this header parameter to SPC/NC/xx based on the measurement report, and after that export to a tabel file.

Is this even possible?

[[La...]]

Yeah, it's probably possible.

You can have your report process this data in the background. Read in the hdr.txt, use a replace function to replace a placeholder variable (i.e. Reason for Test = In Process Inspection) with the new user input (Reason for Test = Remeasure) and then regenerate the HDR text and overwrite the file.

Use the "Write file" action to do the work.

Edit: you don't actually have to display this on the report. I just show it on my report to walk through the logistics of how to process the data. Then I hide everything afterwards.

[[To...]]

Please sign in to view this quote.

This is interesting, but it will create another problem.
The software that I export to will move the table file when it is imported. And it looks info the folder every other minute.

But maybe could another action be that the table file is put in to a folder an when I push the button on the report then it chances the variable and move it to another folder?
Is that possible?

[[La...]]

I do have a couple questions ...

- why can't they change the variable before running the program?
- is what you're doing in the other program re-creatable in PiWeb to avoid the transfers?

[[To...]]

Please sign in to view this quote.

They are able change the variable before running the program, but sometimes they will run the program again if it might have been set the part wrong in the fixture, or I would like to have the operators mark the samples as “NC”, and then the other program will automatical create the NC report, and notify team lead.
Also I make reports for the customers in the other program.

[[To...]]

Please sign in to view this quote.

I might have a solution for some it know.

Now I use a user-defined variable.
I could change that to "Reason for inspection" instead that would let me use the function "Write Attribute". It is also better cause new versions of Calypso can cause troubles when using own variables.
But Calypso doesn't allow editing "Reason for inspection" in the editor for pre-defined variables. Maybe there is a text-file somewhere as a work-around?

Now I only need a way of simulating "Result to file". If this could be possible it would also be smartere than having to turn it on inside the program.
It is possible to export to excel with the functions inside Pi-Web, so I believe this should also be possible.

[[La...]]

If you modify measurement attributes after the CNC run, the table file is already created. So this will not affect your table file retroactively.

[[To...]]

Please sign in to view this quote.

I know.
The perfekt thing would be that the table files would be created when pressing the button on the report.
It is possible creating .csv, but I don’t see an option for table files.
I would assume it should be possible maybe by using a special command?

[[La...]]

I already had suggested loading your table file in the background of your report, looking for a string and replacing it with the new value that the user would choose from the report. Then re-saving the table file. But, you mentioned the table file would already be consumed by your third party software at that point.

All I can suggest is to duplicate your function you use the third party software for within PiWeb so you don't need to worry about table files correctly. Or, have the user fill it out correctly before the run.

Laura

[[To...]]

Please sign in to view this quote.

Thank you, Laura.

It seems like a big task to me, but I need to do this.
It is either this or having a software programmer do some programming, but that is way to expensive.

Regarding the other software consuming the files I could create a folder in which the files go in to before and when a button is pressed on the report it would change the variable and write the file to the actual import folder.

How do I do the import of the file?