sheet_metal_material table edit

[Lars1978]

Hi All,

I'm trying to edit the sheet_metal_material.txt file. I'm doing this with the notebook "app/programm" in windows.
I don't like it because the colum vallues are not aligned.

I tried to work with excel and read the file as a coma saperated file. Now the vallues are neatly aligned....but when saved the file does not seem to be stored in the comma separated matter...?

Any suggestions ?

Lars

Lars
NX12.0.2.9 native
Solid Edge ST10
Inventor

 

[deedub777]

What I recommend is to create your standards file in excel (in xlsx format). Do you changes and do a save as to csv file that NX looks at. You can do this with a small vbs script to make it easier, something like this:

Sub SaveAs_CSV()
 
  ' Copy activesheet to the new workbook
  ActiveSheet.Copy
 
  'Save new workbook as SheetMetalFile.csv into the folder where ThisWorkbook is stored
  ActiveWorkbook.SaveAs ThisWorkbook.Path & "\SheetMetalFile.csv", FileFormat _
        :=xlCSV
 
  ' Close the saved copy
  ActiveWorkbook.Close False
 
End Sub

Please note the code is provided as-is with no responsibility for any errors, etc, etc.

Join the Sheet Metal Community

 

[Lars1978]

@deedub777

can't I just use the csv format excel provides ?



Lars
NX12.0.2.9 native
Solid Edge ST10
Inventor

 

[deedub777]

Yes you can,
Sorry, maybe I missed your point?

In Excel use the Save-As csv

 

[Lars1978]

so to make sure i can read the .txt and save this into an .csv file. In NX I point to the .csv file instead of the .txt ?


Lars
NX12.0.2.9 native
Solid Edge ST10
Inventor

 

[deedub777]

Correct,
If you are starting with the txt file, just read into Excel and save as csv. when saved, point NX to the csv file.
Be careful as depending on the source of the txt file I've noticed it can contain some strange formatting (leading spaces). You may need to remove these if you find that's the case.
The reason I suggested using excel format is that you can add some formatting top read the data easier. csv just resets the column widths etc. each time it's saved.