Importing a Part File, Expressions issues
Importing a Part File, Expressions issues
(OP)
Hello all,
under NX8.0
We have a big datasheet under spreadsheet form that have to figure on some drawings.
This spreadsheet exist in nearly the same form on a xls file used by engineering team for some calculation and design parameters summary.
As it is impossible to directly import an excel file, i tried this tricks :
- In one hand, wrote a macro is this xlsm file that generate a .exp file containing all the variables with the correct syntax.
- On the other hand, a part, with only this spreadsheet in the drafting space.
Cells are populated by expressions and we "import" "part" this spreadsheet when needed.
But when I import this part in a new drafting file, then the expressions have a suffix '2 ou '3 added
And then, my exp file does not correspond for uptading the cells values.
Why these suffix are added, even if the expressions are not exist before de importation ?
How to solve that ?
I'am now trying the fucntion that read cell values but i don't like it as it create a permanant link to an excel file.
Thank you.
Stéphane
under NX8.0
We have a big datasheet under spreadsheet form that have to figure on some drawings.
This spreadsheet exist in nearly the same form on a xls file used by engineering team for some calculation and design parameters summary.
As it is impossible to directly import an excel file, i tried this tricks :
- In one hand, wrote a macro is this xlsm file that generate a .exp file containing all the variables with the correct syntax.
- On the other hand, a part, with only this spreadsheet in the drafting space.
Cells are populated by expressions and we "import" "part" this spreadsheet when needed.
But when I import this part in a new drafting file, then the expressions have a suffix '2 ou '3 added
And then, my exp file does not correspond for uptading the cells values.
Why these suffix are added, even if the expressions are not exist before de importation ?
How to solve that ?
I'am now trying the fucntion that read cell values but i don't like it as it create a permanant link to an excel file.
Thank you.
Stéphane





RE: Importing a Part File, Expressions issues
That being said, if you have a GRIP execute license, the attached program will rename all of the expressions in a Part file removing the 'hash' marks. Download the file and before attempting to open it change the file header name from .zipper to .zip and then extract the files. If you open the 'Rename_Exp.grs' file it includes a description of what the program does.
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.
RE: Importing a Part File, Expressions issues
It is running but the message windows tells :
0 expressions Renamed
119 Duplicates Unchanged
And the expressions remain the same.
I'am in change of developping some master parts and automate some process like that.
They must be as much as possible user friendly, so executing a grip is fun but if we can do without, it's better.
I have two other idea to try to solve this problem.
- import the .exp file in my original spreadsheet file, doing a save as and import it afterward.
- define a new set of drawing template with this spreadsheet already imbedded.
RE: Importing a Part File, Expressions issues
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.
RE: Importing a Part File, Expressions issues
In this part, after the import, when I list "all" expressions, i don't see other than mine followed with '0 or '1
Weird.
I'am home now, I'll try my other ideas tomorrow. They are easier.
PS : How to learn Grip language ?
RE: Importing a Part File, Expressions issues
As for learning GRIP, you're about 25 years too late. It still works, but it's basically unsupported.
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.