Conditional Excel Report

[[Ze...]]

Hi Everyone,

I'd like to have Calypso and/or Piweb output an Excel report based on certain conditions. 

1) Only create an Excel report if all dimensions are in tolerance.

2) Only create an Excel report if the inspection is a Final inspection based on the report header selection of inspection type that is chosen from a pulldown menu. 

I've done some searching and it looks like I might need to run some sort of script or something when the program finishes to accomplish this, but I'm not sure how to do that. I don't have PCM but if that's something that will do this then I would be willing to add that. Looking for the easiest way to do this within the program and not relying on a network solution.

Thank you for your help! 

[[DW...]]

Please sign in to view this quote.

Please sign in to view this username.

 To keep it all nice and tidy you would need PCM. All of the functionality to do what you want to do is baked into Calypso, just needs unlocked with PCM. Outside of Calypso is definitely possible, just not as streamlined. 

[[Ze...]]

Thanks for the reply, DWC. 🙂

Will CMM programs with PCM in them run on other Calypso computers that don't have PCM? I'd like to put it on an offline station and transfer the CMM programs to the other CMM's. 

[[Ze...]]

After reading a bunch of posts, some quite heated,🤬 it looks like a lot of PCM will run on non PCM machines but there isn't a real definitive list of what will and won't work. 

[[Ri...]]

You can do this either with PCM inside of Calypso, orrrrrrrr you can just write a Python/Golang script that does this for you, and have the report_end.bat trigger the script. All the Python/Golang script would need access to are the char, feat, and header txt files. From there, sky is the limit. 

Honestly this is super simple to achieve, with almost no coding experience - ChatGPT, Gemini, or Claude will easily do this for you. 

 

As for running PCM on a non-PCM machine - it would be a pain because you can't access the pre/post settings to make adjustments without a PCM license (so troubleshooting would be a pain), and the most useful command read/runPCMFile cannot be used without a PCM license - so everything has to be hardcoded.