Automate "export XYZ" file

I assume you don't have Datapage ? Thats the easiest way. The next best way is to export out data using the Xcel automation sheet.

Hi Jim.
You are correct, I do not have datapage. I have not used the automation sheet before either. The total of parts has now increased to 300!

Tell me what version you use and PM me your email and I'll see if I can hook u up with the Excel sheet.

Just what are they planning to do with the data? When you say export the data in a XYZ format what I am thinking is some format that can be imported into another CMM or CAD program but that doesn't make sense to me with that number of parts so now I am thinking that you mean something that can be imported into excell, more like a comma seperated file with the XYZ output. For something like that there are many scripts available and that is how I do it. I posted a script in the code section that will do that output for you but once you are done you will have to do a lot of work in excel to get the data formatted in a useable form with that script.

Open a .XYZ file where you write values. If you want to skip "<" and ">" you can use FORMAT("%3.3f,%3.3f,%3.3f",CIRC1.XYZ)
You open the file at the start, you write lines along the prog and you close the file at the end. You can add the part number at the start, with a operator comment.

I have pm'd you.

Open a .XYZ file where you write values. If you want to skip "<" and ">" you can use FORMAT("%3.3f,%3.3f,%3.3f",CIRC1.XYZ)
You open the file at the start, you write lines along the prog and you close the file at the end. You can add the part number at the start, with a operator comment.

Not sure I follow this jefman, can you post an example please?

cap master (version 2).zip
PCD_Parser.zip

Here is the program I use to save my output. You will need to add a folder called CMM DATA to your C drive for this to work. You can call this with an external command right from your program.

Here is the program I use to save my output. You will need to add a folder called CMM DATA to your C drive for this to work. You can call this with an external command right from your program.

Sounds great! MR. Hines, could you post code so I have a clue how to get it to work? Would appreciate. Thanks!

Sounds great! MR. Hines, could you post code so I have a clue how to get it to work? Would appreciate. Thanks!

This is the code I use to call the program:



This version of calling the command will open a dialog box that lets you input a job number and part/serial number (both required). There are also a couple of command line parameters that I have coded into the program to automate the process a bit. There is a /j: and /p: that you can use to pass the job number and part number.



I use this a lot for storing the data from my cap studies. If you are going to use the command line parameters you need to make sure you include the quotes the way I have them and also no spaces in the parameter.

I often use:



Honesly I didn't write this for distribution so I have no idea what sort of errors you may run into. This is my VB compiled version of the code I posted in the "My solution to .CSV output" thread.

for some reason the code tags aren't working correctly and seperating the external command line. Those should all be one line of code.