Updating Characteristic Names from External Sources

[[To...]]

We have a customer that creates ballooned Op sheets, however when they get a drawing revision, they don't reference the old balloon numbers and just randomly re-number the new Op sheet. Customer wants to be able to re-number the numbered characteristics in the Calypso program using an Excel spreadsheet or any other external source.

Do any of you "coding geeks" (term of endearment) have any tricks up your sleeve?

[[Ro...]]

Hi Tom,
I guess it depends on how they define the bubble number. Some do it in the characteristic name. Some in the comment section.

There's an option for importing and exporting characteristic attributes that looks like it could work. I've never used it. I couldn't find how to edit the attributes per the help file. When I look for them in the Characteristics Settings Editor per the help file they aren't shown as they are in the help file. It may be a PCM thing.

Let me know if you find a solution. Could be helpful.

Robert

[[La...]]

You have to have defined a characteristic attribute in order to access it from the Characteristics Settings Editor. That being said, if the customer wants to use Bubble Number as a characteristic attribute, apparently you can import a TXT from File --> Import Characteristic Attributes. I've always modified characteristic attributes directly by right clicking on the object, or modified them through the characteristic settings editor. So, I am of no help using the Import method....

Then, in PiWeb (assuming you're using PiWeb reporting, as you should be 😎 ) you would have 2 fields that represent characteristic name + bubble number in your report. One for the characteristic name as described in the CALYPSO Characteristic tab/list. And another text box that represents the Bubble Number, and those can change as the rev levels change.

The really nice thing about doing it this way is a) the ability to import, and b) the ability to retain historical information about characteristics as the numbers change. The names and statistical/historical data remain constant, the Bubble numbers are just an auxiliary item.

[[Is...]]

Put the command TR() in the characteristic column of the Piweb report.

Then in translate report section: set in the column of your language the custom name that you want for your characteristics.. is also possible import and export to excel..

Screenshot_20220111-220409.jpg

[[Is...]]

TR () command with XML file:

${TR(Qdb.Characteristic(2002))}

[[Gu...]]

An easier way with less impact is if you use the ballooning commentary, no.
But you can also rename inspection characteristics automatically

Create a userattributes.ini file:

Identifier u_k2002NewName new_identifier
X-Wert_Kreis1 FL1 hugo
Y-Wert_Kreis1 DI1 peter
Roundness1 RO1 willi
Diameter_Outside Circle DI2 fred
Roundness_Outside Circle RO2 tom


and use
File/Import Characteristics Attributes

userattributes.txt

[[To...]]

Please sign in to view this quote.

Danke Herr Haas. I eliminated center column in my test and it worked great.

[[Ri...]]

In the folder for each program is a file called "inspection".
All of your characteristics should be named in that file.
You could use excel vba to edit the data.

[[To...]]

Please sign in to view this quote.

Thanks Rich, unfortunately, I don't know how to do that..... 🙂