[Cl...] Posted January 10, 2020 Share Posted January 10, 2020 We activate the Zeiss Characteristic.xlsx report in several of our programs. One of these programs .xlsx report doesn't match the custom printout numbers entered in the Incremental Part Number. Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/ Share on other sites More sharing options...
[Ke...] Posted January 10, 2020 Share Posted January 10, 2020 Please sign in to view this quote. Well... that sounds weird. Doesn't match, in what way? Did someone change the cells in the upper portion? Does the cell location match? I'm not too familiar with the macros; is it possible to copy and paste the cell from another sheet? Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94196 Share on other sites More sharing options...
[Cl...] Posted January 10, 2020 Author Share Posted January 10, 2020 I'm getting this complaint from another facility via e-mail and screen shots, so this is what I know so far. We use the Custom Printout and the Characteristic .xlxs. From Start Measurement - Report Header Data, the operator enters the Incremental Part Number. He says that the incremental Part Number doesn't match what's on the Excel report? Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94198 Share on other sites More sharing options...
[Ro...] Posted January 10, 2020 Share Posted January 10, 2020 make sure all programs are using the same VPHEAD.GRA template, and one program isnt using an old copy. Resource> Define Printoutjkljhkghfgh.JPG Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94200 Share on other sites More sharing options...
[Gr...] Posted January 13, 2020 Share Posted January 13, 2020 If the problem you are having with the incremental part number is just as it relates with Excel you need to do the following. 1st: You need to go to resources>Define Printout>Default printout/Warning Limit and at bottom of window you will see Excel Report. It is here you insert the path to the template being used (see picture) These templates are located C:\Users\Public\Documents\Zeiss\CALYPSO\data\excel_report 2nd: The ReportINI.xls file should be embedded in Excel 'C:\Program Files\Microsoft Office 15\root\office15\xlstart\ ReportINI.xls' Now when the program is run, the Excel-printout is no longer grayed out and can be activated. After run is completed 4 files are created. Characteristic.txt, Feature.txt, Header.txt feed the ReportINI.xls file which creates the final Excel Results file. This is a sample of one of ours Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94202 Share on other sites More sharing options...
[Cl...] Posted January 13, 2020 Author Share Posted January 13, 2020 Already doing that Greg. The problem is, the incremental part number on the custom printout does not match what's appearing on the .xlxs report. Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94204 Share on other sites More sharing options...
[Ro...] Posted January 13, 2020 Share Posted January 13, 2020 Please sign in to view this quote. What are the numbers displaying on the report and the xlxs report? Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94206 Share on other sites More sharing options...
[Ke...] Posted January 13, 2020 Share Posted January 13, 2020 Clarke, Is it possible that there is some PCM coding in your postsettings that set Incremental Part Number to a variable? It would look like something this: SN=getRecordHead("A User Defined field like Serial Number") setRecordHead("partnbinc",SN) Regards, Keith Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94208 Share on other sites More sharing options...
[Gr...] Posted January 13, 2020 Share Posted January 13, 2020 Oops, should have been more attentive when I first read your post. What version of Calypso are you running? I remember reading or hearing from someone Calypso 2019 will no longer support Custom Printouts. They are really pushing for PiWeb to be the sole reporting entity. Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94210 Share on other sites More sharing options...
[Cl...] Posted January 13, 2020 Author Share Posted January 13, 2020 That's OK, I do it myself quite a bit. We are running 2019/6.8. Link to comment https://qualityforum.zeiss.com/topic/16838-incrimental-part-number-excel/#findComment-94212 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