Exporting Tool library

[gcode]

ctually, no save to a csv, you have to save from Excel to a csv

did it work going into VC?

[JParis]

did it work going into VC?

Not yet....will it, not sure...says it will..

I need to get my data all formatted properly...that's what I am working on now

[MIL-TFP-41]

I found it...you output the simple report, then once that Active reports window is Open, you do a Save as and choose csv...

I have to reconfigure my Active report to get the info I want out before I can use the csv but it at least gives me a path

Thank you MIL-TFP-41

The only reason I knew this option was there is recently I was saving my tool list as a .pdf file. I was going the print to .pdf route, then I decided to click on the File/Save as button and discovered the options. At the same time I learned that PDF stands for "Portable Document Format", a useless piece of trivia I will never use. It is unfortunate that it doesn't have a .csv option. 

[kccadcam]

If you run Varco Reports I'll bet Jim Varco could add that .CSV option.
Maybe even format it for VC on the fly. Contact and ask him.

I worked with him to output Tool Assy. info to a Haimer Presetter.
Works flawlessly. (.XML data)

Code Select Expand

<MASTERTOOL>
  <KeyToolId>1100</KeyToolId>
  <ToolDescription>EMC .7500 3F 3FL 6L</ToolDescription>
  <AdapterNo></AdapterNo>
  <AdapterDesc>CAT40</AdapterDesc>
  <ToolTypeDesc>Flat endmill</ToolTypeDesc>
  <ToolImage>\\***\****\****\SHARED MASTERCAM 2022\COMMON\REPORTS\IMG\MTOOL3D21.BMP</ToolImage>
  <isAngleHeadTool>Falsch</isAngleHeadTool>
  <RotationAngle>0</RotationAngle>
  <ToolAngle>0</ToolAngle>
  <midDeviation>0</midDeviation>
  <ahHeight>0</ahHeight>
  <ahWidth>0</ahWidth>
  <shankdiameter>0</shankdiameter>
  <STAGE>
    <CutCount>3</CutCount>
    <Measured>0</Measured>
    <StageType>0</StageType>
    <DataOutput></DataOutput>
    <ReferenceX>0</ReferenceX>
    <ReferenceZ>0</ReferenceZ>
    <ReferenceY>0</ReferenceY>
    <Info></Info>
    <X>19.05</X>
    <UX></UX>
    <LX></LX>
    <Z>172.72</Z>
    <UZ></UZ>
    <LZ></LZ>
    <R>0</R>
    <UR></UR>
    <LR></LR>
  </STAGE>
 </MASTERTOOL>
 <MASTERTOOL>
  <KeyToolId>1101</KeyToolId>
  <ToolDescription>EMC .5000 3F 2FL 4L</ToolDescription>
  <AdapterNo></AdapterNo>
  <AdapterDesc>CAT40</AdapterDesc>
  <ToolTypeDesc>Flat endmill</ToolTypeDesc>
  <ToolImage>\\****\****\****\SHARED MASTERCAM 2022\COMMON\REPORTS\IMG\MTOOL3D24.BMP</ToolImage>
  <isAngleHeadTool>Falsch</isAngleHeadTool>
  <RotationAngle>0</RotationAngle>
  <ToolAngle>0</ToolAngle>
  <midDeviation>0</midDeviation>
  <ahHeight>0</ahHeight>
  <ahWidth>0</ahWidth>
  <shankdiameter>0</shankdiameter>
  <STAGE>
    <CutCount>3</CutCount>
    <Measured>0</Measured>
    <StageType>0</StageType>
    <DataOutput></DataOutput>
    <ReferenceX>0</ReferenceX>
    <ReferenceZ>0</ReferenceZ>
    <ReferenceY>0</ReferenceY>
    <Info></Info>
    <X>12.7</X>
    <UX></UX>
    <LX></LX>
    <Z>139.7</Z>
    <UZ></UZ>
    <LZ></LZ>
    <R>0</R>
    <UR></UR>
    <LR></LR>
  </STAGE>
 </MASTERTOOL>

[kccadcam]

Wait, it's already there, just disabled.
Let me contact Jim and gather intel.

[gcode]

Varco Reports can also Save As Excel XLS and XLSX
CVS is also in the Export list, but it's greyed out.. don't know what that's about

[kccadcam]

In Varco, Go to Setup Sheet Display settings, CNC Code file Tab, Check CSV Export.

[kccadcam]

Hi Jim,

Go to Tool Manager, Tool Library, import/export, Report
I don't get the .CSV option there.

Kevin,

That was an oversight on my part that has been fixed for the next update.