[Ma...] Posted June 2, 2020 Share Posted June 2, 2020 Can anyone confirm the text encoding format for the text files output by Calypso, in particular the format for the Characteristics Table File and the Printout Header Table file. We have used notepad to identify the encoding format as follows: Characteristics Table File: ANSI Printout Header Table File: UTF-8 Just looking for some confirmation that this is correct. TIA Link to comment Share on other sites More sharing options...
[Ro...] Posted June 2, 2020 Share Posted June 2, 2020 What are you looking to do? (FYI i have no idea about formats) Link to comment Share on other sites More sharing options...
[Is...] Posted June 2, 2020 Share Posted June 2, 2020 I don’t use Characteristic tables or Print out header, but I’m also curious to know the reason.. By the way I checked my text formats: CompactPrintout: ANSI Files generated with PCM: ANSI Qualification probe data: UTF-8 Link to comment Share on other sites More sharing options...
[Ma...] Posted June 2, 2020 Author Share Posted June 2, 2020 We are looking to pull data from these files to monitor results to put all individual results together and monitor / review. Effectively a variation along the lines of Pi Web. Link to comment Share on other sites More sharing options...
[Ma...] Posted June 2, 2020 Author Share Posted June 2, 2020 Please sign in to view this quote. How did you check the format, with notepad? Is this the correct way to check? Link to comment Share on other sites More sharing options...
[Ro...] Posted June 2, 2020 Share Posted June 2, 2020 We use PCM directly to generate our Text reports, don't use Pi web or any of the canned outputs in calypso. (we do also print out a standard custom printout, which is also saved as a pdf for our records) The reason for this is i have to EXACTLY mimic the reports we already have in PC Dmis, and our inhouse code writers have found a way to digest these reports and pump them directly into Winspc, which at one time was an operator input process. We have many programs that we can run on Zeiss or PCD, so the reports have to match right down to number of spaces and blank line as the top line. I don't know how they do it, I just generate the report in the way that they need, and the system works great.fdvghjhnjk.JPG Link to comment Share on other sites More sharing options...
[Is...] Posted June 3, 2020 Share Posted June 3, 2020 Please sign in to view this quote. I did it with the Notepad, not sure if this is the correct way. Link to comment Share on other sites More sharing options...
[Da...] Posted June 3, 2020 Share Posted June 3, 2020 I use a SQL server to pull the data from the output text files. Then you can pull down the data with a Pivot table in Excel. Or you can pull the data in to Minitab. All data can be sorted by all input fields in Calypso. All files are saved by the program name and by the time down to the millisecond so no two runs ever have the same name. The system also emails engineers if parts measure out of tolerance or if they start trending off the mean by a set amount. So you can do about anything but it just requires time and programming. Link to comment Share on other sites More sharing options...
[Ma...] Posted June 3, 2020 Share Posted June 3, 2020 We have all three files ( fet, chr, hdr ) in ASCII. Using Notepad is the fastest method to get encoding - if you don't have PSPad for ex. Excel and other programs will read file correctly nowadays. I don't remember if i had to choose encoding when i was programming editors. Link to comment Share on other sites More sharing options...
[Is...] Posted June 3, 2020 Share Posted June 3, 2020 Please sign in to view this quote. I have the same methodology, no problems with the text Encoding... Link to comment Share on other sites More sharing options...
[Da...] Posted June 4, 2020 Share Posted June 4, 2020 I will add the code that I am using and video of how the Pivot table works in Excel. Link to comment 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