Tool library changes

[Leandro]

I need to modify all the tools from my tool library.

For example "Plunge speed"

Is there a way to do this quiker than one by one ??

[ToolMan184]

Export them to an Excel sheet make the mods and import back into MC.

[Leandro]

ToolMan:

I try to exporta as text from MC and import in Excel.¿Is this correct?

But the file that I get is complicate to handled. May be I´m not importing correctly.

 

Is another way??

 

Thanks

[ToolMan184]

You can export data from a tool library in either of two different report formats.

 

Detailed report

You can create a document that contains a detailed report about each tool in the tool list area, so you can print out or review the tool information outside of Mastercam. This information includes tool names, material, size, and all other parameters entered when the tool was created.

 

Open the Tool Manager.

 

Right-click in the tool list area and choose Import/export tools, Detailed report file. The Specify File Name to Write dialog box opens.

 

Enter the name of the file you want to create or choose an existing file and choose Save. Mastercam creates a text file with a TXT extension.

 

The file will open in your default text editor.

 

Summary report

You can create a document that contains a summary of the information found in the tool list area, so you can print out or review the tool information outside of Mastercam. For each tool, it lists the tool number, tool type, tool name, insert info, and turret.

 

Open the Tool Manager.

 

Right-click in the tool list area and choose Import/export tools, Report file. The Specify File Name to Write dialog box opens.

 

Enter the name of the file you want to create or choose an existing file and choose Save. Mastercam creates a text file with a TXT extension.

 

The file will open in your default text editor.

[ThRaSH]

You could just open your exported text file in PFE (Programers File Editor). Then do a Replace (F3) "Plunge speed" with the value you want. This Will change all "Plunge speed" values at once. Then just import your text file back into MC.

[Leandro]

Now is something that i don´t understand.

When I exoprt i can get a convertion to txt, a report and a detailed report.

Reports looks nice but any changes that I make there can not be imported back to Mastercam.

 

The txt file looks like follows

 

# TOOL LIBRARY FORMAT - Fri Aug 22 15:32:57 2008

# TOOL LIBRARY FORMAT

# = comment if 1st character in line

# line 1 - TOOL (start of tool definition)

# line 2 - tool material (1-HSS, 2-CARBIDE, 3-COATED CAR, 4-CERAMIC, 5-BORZON, 10-UNKNOWN)

# line 3 - tool comment

# line 4 - tool name (geometry reference for backplot)

# line 5 - tool manufacturer

# line 6 - chuck designation

# line 7 - tool_no, tool_type, rad_type, dia, crad, thds, tip_angle,

# dia_off, len_off, feed, plunge, retract, rpm, coolant, n_flutes, bottom_turret, station

# line 8 - Drilling attributes (see tool_type in line 7 above)

# line 8 - cycle, peck1, peck2, peck_clr, chip_brk, dwell, shldr_angle, root_dia (tap), bore_shift

# line 8 - Milling attributes (see tool_type in line 7 above)

# line 8 - cut_able, rgh_x, rgh_z, fin_x, fin_z, tip_dia, root_dia (thd mill), thd_angle

# line 9 - pilot_dia, flute_len, oa_len, shldr_len, arbor_dia, hldr_dia, hldr_len, spindle_ccw, sfm, fpt, metric

# line 10 - Holder type, Work offset, Initial dir vector[3], Head offset[3], Tool offset[3]

# line 11 - Canned text coolant information (canned text 1, canned text 2, ..., canned text 20)

# (tool types) (tool capabilities) (canned cycles)

# CENTER DRILL 1 ROUGH & FINISH 0 SIMPLE DRILL 0

# SPOT DRILL 2 ROUGH 1 PECK DRILL 1

# DRILL 3 FINISH 2 CHIP DRILL 2

# TAP-RH 4 TAP 3

# TAP-LH 5 (tool corner radius) BORE1 4

# REAMER 6 NONE 0 BORE2 5

# BORING BAR 7 CORNER 1 MISC1 6

# COUNTER BORE 8 FULL 2 MISC2 7

# COUNTER SINK 9

# END MILL FLAT 10 (coolant types)

# END MILL SPHER 11 OFF 0

# CHAMFER MILL 12 FLOOD 1

# FACE MILL 13 MIST 2

# SLOT MILL 14 TOOL 3

# CORNER RAD MILL 15

# DOVETAIL MILL 16 (spindle direction)

# TAPER MILL 17 CW 0

# LOLLIPOP MILL 18 CCW 1

# END MILL BULL 19

# BLOCK DRILL 20

# ENGRAVE TOOL 21

# BRADPT DRILL 22

# *** DO NOT REMOVE LINE NUMBERS OR DELETE ENTIRE LINES! ***

# *** ALL TOOL DEFINITIONS MUST CONTAIN 9 LINES AND THE 'TOOL' LABEL! ***

#

 

1 - TOOL

2 - 3

3 - FRESA CHAFLAN Ø10

4 - C:MCAMX3MILLTOOLSCHMFMILL.MCX

5 -

6 -

7 - 200 12 0 16. 0. 0. 60. 1 1 0. 0. 0. 0 16 2 0 -1

8 - 0 0. 0. 0. 0. 8. 0. 0.

9 - 0. 10. 50. 12. 16. 50. 25. 0 0. 0. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

1 - TOOL

2 - 2

3 - Fresa plana Ø8

4 - C:MCAMX3MILLTOOLSFLATMILL.MCX

5 -

6 - Pinza

7 - 2 10 0 8. 0. 0. 0. 1 1 70. 40. 70. 3000 16 2 1 -1

8 - 0 0. 0. 0. 0. 0. 0. 0.

9 - 0. 28. 40. 30. 8. 40. 40. 0 100. 100. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

1 - TOOL

2 - 3

3 - Fresa de cara Ø80

4 - C:MCAMX3MILLTOOLSFACEMILL.MCX

5 -

6 -

7 - 3 13 0 81. 0. 0. 45. 1 1 250. 250. 250. 650 16 6 0 -1

8 - 0 0. 0. 0. 0. 93. 0. 0.

9 - 0. 12. 90. 30. 80. 40. 40. 0 0. 0. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

1 - TOOL

2 - 3

3 - Fresa de escuadrar Ø50

4 - C:MCAMX3MILLTOOLSFACEMILL.MCX

5 -

6 -

7 - 4 10 0 50. 0. 0. 0. 1 1 200. 150. 200. 800 16 4 1 -1

8 - 0 0. 0. 0. 0. 0. 0. 0.

9 - 0. 12. 50. 40. 40. 50. 25. 0 0. 0. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

1 - TOOL

2 - 3

3 - Fresa esferica Ø32

4 - C:MCAMX3MILLTOOLSBULLMILL.MCX

5 -

6 - Pinza

7 - 5 19 1 32. 6. 0. 0. 1 1 150. 70. 150. 1500 16 2 0 -1

8 - 0 0. 0. 0. 0. 0. 0. 0.

9 - 0. 12. 120. 15. 20. 40. 40. 0 50. 50. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

1 - TOOL

2 - 1

3 - Fresa plana Ø3/4"

4 - C:MCAMX3MILLTOOLSFLATMILL.MCX

5 -

6 - Pinza

7 - 6 10 0 19.05 0. 0. 0. 1 1 20. 20. 20. 300 16 6 0 -1

8 - 2 0. 0. 0. 0. 0. 0. 0.

9 - 0. 28. 40. 30. 19.05 40. 40. 0 0. 0. 1

11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

 

I don´t think I cann manipulate this file easily.

 

What am I doing wrong??