Export data to a text file without Datapage

I see a lot of questions about how to export data to a text file. I have a program that checks a golden part. I want to export certain measurments to a text file to automatically import into Excel at a later time. I also want to record the day and time the program is run and the serial number of the probe module used for that run. I do not have Datapage.

This is how I do it in 4.2MR1:
After I take my measurments I export the data with File I/O commands.

From the menu:
Insert -> File I/O Command -> File Open
Insert -> File I/O Command -> Writing Commands -> Write Line
Insert -> File I/O Command -> File Close

COMMENT/REPT, Global Machine
                        , 
FPTR       =FILE/OPEN,N:\QA\CMMDATA\DATASTORE\GLOBAL.TXT,APPEND
            FILE/WRITELINE,FPTR,SYSTEMTIME ("hh':'mm")+","+SYSTEMDATE("MM'/'dd'/'yy")+","+LOWER_2_HOLE.D+","+D_1.MEAS+","+D_2.MEAS+","+UL_50.Y+","+ROUND_1.MEAS+","+WORK_ORDER.INPUT+","+TOP_PLANE.Z
            FILE/CLOSE,FPTR,KEEP

In my case, this exports Time, Date, Diameter, 2d-distance, 2d-distance, Y axis position, roundness, user input, and z-height to a Text file stored on our network server that can be retrieved anywhere from the network.

This info is put onto its own line in the text file GLOBAL.TXT each time to program is run. It can then be imported into Excel or any other software package that take a CSV/TXT file as input.

Have fun with it....

SURESH over 13 years ago

Sir,

I export date,time and circularity but in this i am not able to exort x,y,z and diameter

please give me the example
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
rsegriggy over 13 years ago

In my example above, lower_2_hole.d is the diameter of a circle. lower_2_hole.x would be the x coordinate of that feature. Is that what you are looking for?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
robgs57 over 12 years ago

Is this to record individual features? what if you want to save the whole report?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
jenny over 12 years ago

I always go under Insert, Statistics Command, and Statistics, When the box comes up I click DES under Data base options instead of Datapage, Under Stats options under Transfer Directory I browse to find where I want file to go. I insert this in program before my output then after my output I type Stats\Off, when it runs through it will output an MEA file which can easily be brought into excel same as txt file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
hertangel over 12 years ago

Rick, do I write this at the bottom of the CMM program??
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
rsegriggy over 12 years ago

You can put it in at any point after you have measured the features you want to export. I usually put this line after I write my standard .pdf output file. There is no reason you couldn't put it at the begning of your program to just export the time the program started or something. (Obviously there would be no part data at that point.)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
SURESH over 12 years ago

Data Export Programe to Exel format

Dear all,

Please go thru the attached programe,i hope you get export to exel within a hour,

Note : Your PC-DMIS report & exel file should be in the same folder.

Attached Files

Data Export prg..pdf
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
flyboy309 over 12 years ago

I always go under Insert, Statistics Command, and Statistics, When the box comes up I click DES under Data base options instead of Datapage, Under Stats options under Transfer Directory I browse to find where I want file to go. I insert this in program before my output then after my output I type Stats\Off, when it runs through it will output an MEA file which can easily be brought into excel same as txt file.

This works very well, thanks
john
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
serban.petru over 12 years ago

this is my most simple solution

Rapoarte Sheffiled.zip
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
thenettrainer over 10 years ago

Hello Serban.Petru.

Have you updated your report file to work with W7/PC-DMIS 2013?

Has anyone updated Test32?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel