[Al...] Posted January 13, 2021 Share Posted January 13, 2021 Hi, I have necessity to put in excel report file name the serial number in addition to the progressive number generated automatically by calypso. I would also have the need to add the serial number inside the header of excel report but I don't know how I do to modify the header of template. Thanks Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/ Share on other sites More sharing options...
[To...] Posted January 14, 2021 Share Posted January 14, 2021 I've seen a post on the forum related to modifying excel template. Try searching the forum. I understand it may be an length task. Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70170 Share on other sites More sharing options...
[Ow...] Posted January 14, 2021 Share Posted January 14, 2021 See attached documents. If not mentioned in them, it's a GOOD idea to make a copy (label as copy) of each document before editing them so you can go back to them if something goes wrong.EDITING_THE_ZEISS_EXCEL_TEMPLETE.pdfCalypso-Excel Report by Mark Boucher.pdf Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70172 Share on other sites More sharing options...
[SH...] Posted January 14, 2021 Share Posted January 14, 2021 Please sign in to view this quote. IMG_20210114_190002.jpg Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70174 Share on other sites More sharing options...
[Al...] Posted January 14, 2021 Author Share Posted January 14, 2021 Please sign in to view this quote. Thank you for the files. The second file explain very well. But I have a question about the report's header. For summarize. The first step is to edit the report INI to add personalized records. The second step is edit the char file adding new record, but is it possible to write manually directly in excel’s cells? I would like add in the report's header the serial number. I add this number before run program in Calypso Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70176 Share on other sites More sharing options...
[Ow...] Posted January 14, 2021 Share Posted January 14, 2021 I know it can be done by editing the xxx userfields or with PCM or through the piweb report but, I'm out of time today to get too specific and probably won't have much time tomorrow. I've attached a very old guide that should still work (?) on how to add the Workpiece Serial number to the input parameters in a window that can be forced to automatically open when the program is started and also can be added to the header. Hopefully somebody else will add the details if you have any problems. Good luck.Calypso Printout Header Variables with userfields.docx Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70178 Share on other sites More sharing options...
[Ün...] Posted January 15, 2021 Share Posted January 15, 2021 Is there any way to change the Excel filename as well. I want to add information such as date and time to the file name. Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70180 Share on other sites More sharing options...
[Al...] Posted January 15, 2021 Author Share Posted January 15, 2021 This morning I have modified the userfield file and the report ini. I Have added my personalized fields in the protocol's header in characteristics file. When I run a cycle in calypso, excel go into error. See attached files885D419E-67DD-4046-8EA5-998BF1C5AE84.jpeg3A36557C-EE3A-4554-879F-1DEBF0269C96.jpeg1E19C532-E4D6-4A02-BE31-F0C71CFB7D1F.jpeg43D56A22-3F95-4C8D-89FE-B70E6BC177AE.jpeg7862BFA4-9075-4E4D-9F97-BD4F5CA7331A.jpeg299C4F61-048F-4C04-8789-C81262026923.jpeg Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70182 Share on other sites More sharing options...
[Ma...] Posted January 22, 2021 Share Posted January 22, 2021 Try mapping your newly created variables by following the instructions in this Knowledge Base article from the Zeiss Portal: https://portal.zeiss.com/knowledge-base ... &id=454780 (since you are using them for Excel, ignore the PiWeb instructions at the end) Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70184 Share on other sites More sharing options...
[Ma...] Posted January 22, 2021 Share Posted January 22, 2021 If you want to add the date and time to the Excel report (after it is written and closed), you can do so with the following PCM:Forum Post to add date and time to Excel file name.JPG Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70186 Share on other sites More sharing options...
[Al...] Posted January 23, 2021 Author Share Posted January 23, 2021 Thanks but I don't have the pcm's license. I want to edit the excel template to add my personalized fields (work order and serial number) in the report header. I need these fields to post-process reports to prepare customer's documents. Link to comment https://qualityforum.zeiss.com/topic/13670-adding-serial-number-in-excel-report/#findComment-70188 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