SBS - The best value in QMS software

Zeiss CMM Calypso output to Excel or CSV file Help

Brad Gover

Involved In Discussions
#1
Hi all. I am oh so glad this forum is up again! Anyways I am trying to get a Zeiss CMM using Calypso software to out put measurement data to an excel or CSV file so I can upload it into an SPC program. I have done this before on Mitutoyo CMMs and Brown-n-Sharp CMMs. All the programmer needed to do was to edit the code and insert a couple of code lines in the program. Sure appreciate any help!

Regards,
Brad Gover
 
Elsmar Forum Sponsor

Eredhel

Quality Manager
#2
We've got a couple Zeiss CMMs. Would you mind letting me know what you're trying to do in the end? I have all our inspection results automatically, a little bit of coding, save to a server folder by J# and inside that named by part # drawing # and incremental part #. But so far I haven't needed anything in excel.
 

Eredhel

Quality Manager
#3
Ah, SPC, sorry about that! You might check your Measurement Tab, Multiple Printout, and then look toward the bottom where excel is listed. This is an odd area where you can choose different report outputs. We use PiWeb for our SPC and I encourage you to look at it if you're going to use Calypso long term. You can also go into Resources and Results to File for other options.
 

Brad Gover

Involved In Discussions
#4
Thank you Eredhel. Yes I am trying to output the measured data and a few descriptors like you did...Machine #, Part #, Operator, and Print #. Ideally when I outputted this data on a Mitutoyo and Brown-n-Sharp, the CMM's program would Open a file (CSV or Text), amend the data already in the file, and then close the file prior to going to the next measurement. This was the easiest way to upload the data in an SPC program such as Infinity QS or SQC pack. I would prefer using a CSV or Text file format instead of Excel. You mentioned you have your inspection results automatically. You also mentioned a "little bit of coding" too. Would you be so kind as to show me what coding you need to perform and how you opened the editor to add specific coding? I am pretty naïve as to how to write coding in Calypso.
Thanks a whole lot,

Brad Gover
 

Eredhel

Quality Manager
#5
Yes you can have your results show up in several formats. I've accidentally gotten an old school text format :). I'd experiment in the Measurement Tab's Multiple Printout area for sure. As well as the Resources to file section.

Since we use PiWeb I have some different options available so I may not be able to see the same things you do. PiWeb automates all the SPC, CPK, et cetera data collection, storage, and reports.

Do you have Zeiss care right now where you could call them? They'll find out your need and then have someone that knows the area call you back. Fee free to send me a PM and we can get together on the phone sometime to go over some stuff, probably way easier that way.

The code isn't too bad. You basically set a global thing. And then every program you write you have to point to that global selection. Under Resources, Name for output files, "...for all Measurement Plans" you choose the output file type from the drop down, check mark "Name of output file variable" and "Applies for all users" and then enter the code syntax (similar to the way formulas are handled in Result Elements.) Once you do that then every time you write a program you go to Name for output files, "... for this Measurement Plan" and then you just choose your file type from the drop down, check mark the boxes, and then it autofills your code for you (from the global setting.)

I don't think elsmar hosts pictures or I'd upload some, so a phone call might do better. It's super handy to have set up. When I check QA docs for shipping I can open a server folder and make sure CMM checks were done for the job without leaving my desk.

Here's a sample of the code that will automatically find, or create if not already there, a folder named by the job number, part number, and drawing number. Then inside that it will save the actual results by file name with part number, drawing number, job number, and incremental part number. You have to be sure your file type drop down is the same as what you choose when you run the program otherwise it won't save because it doesn't match:

Edit: Something in the way this forum works is messing up the actual code syntax. It won't let me put the \ where it needs to be in one area. I put it there and save but it omits it. So this syntax is actually incorrect. I could email it tho.

"Y:\CMM Reports"+getRecordHead("order")+" "+getRecordHead("planid")+""+getRecordHead("planid")+" "+getRecordHead("order")+" "+getRecordHead("partnbinc")+".pdf"

I may have some typos in there that but that's the idea.
 
Last edited:

mr500

Starting to get Involved
#7
I know this is an OLD thread but..... I have a program that runs in the back ground that will do just what you are asking. Can be set up to auto open the spreadsheet after the run with results. Also has some spc wrapped up in it but I do not use it much for that. I got it from one of my Calypso training classes from Ryan.

I can get it to you if you want. Its helped me tons. But we will soon be on the new PiWeb 2018 so I do not know how much I will use it then. As long as table files still work this should to. Let me know
 
G

Girish

#8
Yes you can have your results show up in several formats. I've accidentally gotten an old school text format :). I'd experiment in the Measurement Tab's Multiple Printout area for sure. As well as the Resources to file section.

Since we use PiWeb I have some different options available so I may not be able to see the same things you do. PiWeb automates all the SPC, CPK, et cetera data collection, storage, and reports.

Do you have Zeiss care right now where you could call them? They'll find out your need and then have someone that knows the area call you back. Fee free to send me a PM and we can get together on the phone sometime to go over some stuff, probably way easier that way.

The code isn't too bad. You basically set a global thing. And then every program you write you have to point to that global selection. Under Resources, Name for output files, "...for all Measurement Plans" you choose the output file type from the drop down, check mark "Name of output file variable" and "Applies for all users" and then enter the code syntax (similar to the way formulas are handled in Result Elements.) Once you do that then every time you write a program you go to Name for output files, "... for this Measurement Plan" and then you just choose your file type from the drop down, check mark the boxes, and then it autofills your code for you (from the global setting.)

I don't think elsmar hosts pictures or I'd upload some, so a phone call might do better. It's super handy to have set up. When I check QA docs for shipping I can open a server folder and make sure CMM checks were done for the job without leaving my desk.

Here's a sample of the code that will automatically find, or create if not already there, a folder named by the job number, part number, and drawing number. Then inside that it will save the actual results by file name with part number, drawing number, job number, and incremental part number. You have to be sure your file type drop down is the same as what you choose when you run the program otherwise it won't save because it doesn't match:

Edit: Something in the way this forum works is messing up the actual code syntax. It won't let me put the \ where it needs to be in one area. I put it there and save but it omits it. So this syntax is actually incorrect. I could email it tho.

"Y:\CMM Reports"+getRecordHead("order")+" "+getRecordHead("planid")+""+getRecordHead("planid")+" "+getRecordHead("order")+" "+getRecordHead("partnbinc")+".pdf"

I may have some typos in there that but that's the idea.
 

Eredhel

Quality Manager
#10
I'm actually at a different company now and we don't have Zeiss CMMs here. I'm afraid I'd be too rusty to help :(, and I don't have a machine around to tinker to get answers. Do you have a current Zeiss Care where you could call them?
 
Thread starter Similar threads Forum Replies Date
A CMM Software Conversion - Converting from Zeiss/Calypso to Brown & sharpe PCDMIS Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
M Zeiss U-Soft versus Uni-Touch CMM Software Calibration and Metrology Software and Hardware 7
D Help find support manual for Zeiss CMM U-Soft, Ver. 3 Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
K Zeiss CMM Error Messages General Measurement Device and Calibration Topics 1
M Can an Internal Buttress Thread be inspected with a Zeiss CMM with a scanning probe Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
Z New CMM - Zeiss vs Wenzel vs ?? (Any Feedbacks) Inspection, Prints (Drawings), Testing, Sampling and Related Topics 23
J If you use the Zeiss CMM users forum.. Coffee Break and Water Cooler Discussions 7
GreatNate Metrotom - Does anyone have any exposure to the Zeiss Metrotom 800 or 1500? Manufacturing and Related Processes 0
N Calibration of a Zeiss ACCURA with tp200 and Vast XXT General Measurement Device and Calibration Topics 1
T Zeiss, Calypso Software Version 3.8.10 Calibration and Metrology Software and Hardware 2
R Como saber aplicar la tolerancia de un Perfil - Zeiss Calypso software Calibration and Metrology Software and Hardware 1
C Zeiss C 90 HP - Any suggestions for learning Umess UX. Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
P Pointers for qualifying the probes using the Calypso Software on a Zeiss General Measurement Device and Calibration Topics 4
J Help needed from a Zeiss Calypso expert Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
A Cg, Cgk and GRR of a CMM Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Marco Bernardi MMC & LMC modifiers and CMM measuring techinques like diameter least squares and circularity or minimum/maximim diameter. Calibration and Metrology Software and Hardware 2
L In house calibration - Our CMM's are outside certified can I use them to certify our standards General Measurement Device and Calibration Topics 4
M Honeywell CMM's - Why Honeywell will no longer sell their manuals Federal Aviation Administration (FAA) Standards and Requirements 2
Marco Bernardi Plane measurement with a 3D touch machine like a CMM. Calibration and Metrology Software and Hardware 3
Marco Bernardi Diameters measurement with 3D touch machine like a CMM Calibration and Metrology Software and Hardware 4
Emran.mi Measurement system analysis - Can you help me about implementation MSA for CMM device Manufacturing and Related Processes 2
A Gage type 1 study on CMM Capability, Accuracy and Stability - Processes, Machines, etc. 2
V Recording CMM dimensional results on CFG-1003 APQP and PPAP 3
G Measuring customer parts on a CMM - How many decimals to report to the customer? ISO 17025 related Discussions 28
J CMM Accuracy Formula General Measurement Device and Calibration Topics 3
J Manual Vision CMM Calibration General Measurement Device and Calibration Topics 7
D CMM Room cleanliness requirements ISO 17025 related Discussions 7
P IATF 16949 MSA Studies for CMM machines IATF 16949 - Automotive Quality Systems Standard 3
D Can a Mill be used as a CMM? General Measurement Device and Calibration Topics 2
Ron Rompen Best Practices in CMM Correlation Studies General Measurement Device and Calibration Topics 3
J CMM Probe Certification General Measurement Device and Calibration Topics 1
S Opinions on the "Best" CMM for High Accuracy Machining General Measurement Device and Calibration Topics 9
P Getting ready for Boeing's AC7130 requirement for suppliers using a CMM AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
J CMM Uncertainty Calculation Question - Deviations Measurement Uncertainty (MU) 9
K "Verification of Calibration" - CMM arm General Measurement Device and Calibration Topics 6
P CMM Equipment Validation and Qualification Approach ISO 13485:2016 - Medical Device Quality Management Systems 11
J Outsourced CMM Measurement Inspection Service and ISO 17025 ISO 17025 related Discussions 14
M Gage R&R with CMM 1X1X10 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
T CMM measurement and usage in the Automotive Industry Calibration and Metrology Software and Hardware 2
P CMM measurement using 2D drawings Calibration and Metrology Software and Hardware 1
M Translating and Rotating Rules when programming or measuring with a CMM Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
4 Quality vs Production on CMM Set Up Requirements Manufacturing and Related Processes 1
G Approval of Jigs (work holding devices) for CMM Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
J How to Retrofit an old, manual CMM Calibration and Metrology Software and Hardware 5
O Camio Output Control - Programming on Camio 4.6 CMM Software Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
F Comparison of 2 CMM machines using Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
R ISO - Clause 7.5.1.3 - CMM Software Program Validation ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
S Stated Accuracy of Portable CMM Arm and Real World Use Inspection, Prints (Drawings), Testing, Sampling and Related Topics 9
K Gage R on a 10 Piece Sample with a CMM using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
C Does anyone know anything about the Mitutoyo MACH V CMM? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1

Similar threads

Top Bottom