Table file modification

[[Me...]]

Hello all,

I've spent a lot of time trying to figure this out. I'm running Calypso 2018. My company insists on using the Infinity SPC program that they've had for years. Infinity pulls data from the _chr text file to populate it's data. In that _chr file I am trying to change the "planid" column to be something other than the program file name.

The naming convention for my file names is structured per company requirements based on part name, part rev and program rev. The engineer in charge of our Infinity programs is balking at the additional revision information and insisting on just a simple part name. Is it possible to have a program file name be different than the "planid" name in the _chr file?

[[Ma...]]

Hi

Is it the file name you want to change or the data inside the file ??
The file name you can change to what ever you want, even for only one program or all programs.
Go into Resources - Name for output files - choose what you want there (only this or all programs), there you can choose which file you want to change and what you want to call it.

[[Me...]]

It's the data inside the file I'm looking to change. I'm aware that I can change the file names though the Resources tab. Unfortunately, that won't help as the SPC software picks up the "planid" data inside the file.

[[No...]]

I don't think it's possible to do that from inside Calypso.
Does the SPC program access the chr files directly (in the Calypso folder) or can you copy them somewhere else?
Because a possible way would be to make a copy, then call a batch file and modify the planid column with an external tool.
In the past I liked to do such things with AWK, a small programmable tool that was made to analyze and modify structured table-like text files.

[[Me...]]

All the text files are sent to the "results" folder and copied into our SQL server. The SPC software collects the data from the SQL.

I know, it seems complicated. I cannot get the company (management) to explore other options though. I am perfectly fine with solid knowledge that what I am looking for can't be done. I figured that was the case. I just need it confirmed or denied definitively.

[[No...]]

Is the data collection from the results folder an automatic process or do you trigger it by hand? If it's automatic, wouldn't it be possible to define another source folder in whatever software copies the data to the SQL? Or is that not allowed too? You could of course try to modify the files in place, but I wouldn't recommend it. Also, if you'd use a tool like AWK, you'd need a destination file to write the modified output to, because in AWK this usually happens on-the-fly. It doesn't change the source file.
The last resort would be to modify the data in the SQL. I assume we're talking of a database here.

I'm sure there is a way, but it depends on what you're allowed to do.

[[Ky...]]

I am working through the same problem with Infinity. I contacted Zeiss and found that you can add columns to the table file. I added the code to the parameters inside the program. Here is the reply the sent:

You can add this bit of PCM anywhere in the measurement plan or externally. I used it in an inspection_start_pcm.txt file when I used it. Just copy and paste it for each header parameter you want to pass.


defineFunctionStart("OP_NAME")
OP_ID=getRecordHead("operatorid")
defineFunctionEnd("OP_ID")

generateTableColumn("Operator","OP_NAME")

[[No...]]

That's a possible way of course if you just need the data somewhere in the table file. But my impression was that the thread starter needed to modify the data that was already present in the table.