Bulk edit of Slot Descriptions
Throughout my company's time using Zuken, we have accumulated quite the library of slot descriptions.
For example, I have slot descriptions of 1/2"_NPT, 1/2IN_NPT, 1/2NPT, 0.5NPT because of inconsistent naming. I would like to replace all of them with NPT_1/2IN.
Is there any way to:
- report a full list of existing Slot Descriptions
- report a list of models with that slot description (as a slot or a mount description)
- Bulk edit (change everything with 1/2"NPT to NPT_1/2IN)
- Purge unused Slot Descriptions (They stay in the list even when used on no models)
I am competent in SQL. If someone knows the full picture of how this info is stored in the tables, I should be able to take it from there...
Was this Helpful?
-
I don't have a complete understanding of the database schema. At most, I'll write select queries to get information. I can't recall ever doing update queries.
I'm always reluctant to give advice on modifying the database outside of E3. When I was first introduced to E3 library, I was in the training when a customer reached out to Zuken for help. The customer had copied some entries from Component table into Excel, made more parts, then tried to copy parts back into the library. It ended up destroying their database. They hadn't backed up their database. Not sure what happened there after.
If you're going to make changes directly to the library, make sure you have your database backed up!!!
If you're simply changing texts in an attribute, that should be straight forward. It depends where these slot descriptions are defined.
- Component table via the Description field.
- Or ComponentAttributes table via an attribute that defines the Slot.
You mentioned naming... I don't know how E3 creates and maintains relations between tables. If you're trying to normalize slot components or models, then proceed with caution. You'll have to study the tables closely to understand the relationships.
Good luck.
Was this Helpful?
0
Please sign in to leave a comment.
Comments
1 comment