[Ha...] Posted November 18, 2019 Share Posted November 18, 2019 Has anyone else had any experience with CMM Manager Retrofit? We're currently updating our 2 Zeiss Eclipses' from USOFT to CMM Manager. We have a few parts that we specifically use PiWeb in order to collect our SPC data but wasn't sure if we could somehow export results from CMM Manager to our PiWeb database. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/ Share on other sites More sharing options...
[Ja...] Posted December 16, 2019 Share Posted December 16, 2019 I don't know about pulling data for PiWeb but, I do know you can export to an excel spreadsheet. It is one of the things I miss about CMM Manager and wish Calypso would do. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91926 Share on other sites More sharing options...
[59...] Posted December 17, 2019 Share Posted December 17, 2019 Please sign in to view this quote. Resources > Define printout > Default Report / Warning Limit tab. Choose an Excel template that you wish to Export to. Check off Excel Printout on your run screen. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91928 Share on other sites More sharing options...
[Ja...] Posted December 17, 2019 Share Posted December 17, 2019 Please sign in to view this quote. This only populates one page per part. CMM Manager will allow you to populate multiple parts into the same spreadsheet and you can report only the actual readings if wanted. It is very nice. Populating each part to a single spreadsheet doesn't simplify anything for me. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91930 Share on other sites More sharing options...
[59...] Posted January 9, 2020 Share Posted January 9, 2020 Use PiWeb to summarize your results then, and export to Excel if that's the desired output you're after... Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91932 Share on other sites More sharing options...
[Wi...] Posted January 10, 2020 Share Posted January 10, 2020 This is a template i use with a macro. You can grab all the excel at once and put them in one spreadsheet..Merge_1.xls Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91934 Share on other sites More sharing options...
[Jo...] Posted January 10, 2020 Share Posted January 10, 2020 Please sign in to view this quote. I've been using this. Super simple, and if I need it formatted the other way just copy and paste "special" transposes rows to columns. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91936 Share on other sites More sharing options...
[Ja...] Posted February 11, 2020 Share Posted February 11, 2020 Some of the engineers are wanting to test this excel reporting. I can't seem to find where to change the save location of the file. Also, is there a way to save the file and not have it open after each run? Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91938 Share on other sites More sharing options...
[Wi...] Posted February 13, 2020 Share Posted February 13, 2020 Please sign in to view this quote. Exactly how did you get your rows to column please ? Im not the best with excel 😃 Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91940 Share on other sites More sharing options...
[Jo...] Posted February 13, 2020 Share Posted February 13, 2020 Please sign in to view this quote. select the data and either control+c or right click and select copy, select the new destination cell ,then control+v and the little icon will appear for special. Transpose is one option. You can right click to get the special Paste menu directly. Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91942 Share on other sites More sharing options...
[Wi...] Posted February 18, 2020 Share Posted February 18, 2020 Thank you John Link to comment https://qualityforum.zeiss.com/topic/16504-cmm-manager-export-to-piweb/#findComment-91944 Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in