hexagon logo

output points or point groups to CSV file

I'm running PC DMIS 2014 with a 7535 portable Romer arm. A customer has requested a report in a CSV format that shows no header, only 3 columns with the xyz values for each point measured. I assume they're just looking to dump the point info into something else and want me to make their job as easy as possible. So far it isn't helping my job any... I have tried Export > Excel > and configured to a CSV file, but I can't seem to get any of the actual point data to export?...
Parents
  • You can do it in a loop, something like :
    File/open,point.csv,write
    Loop from 1 to number of points
    ASSIGN/V1=1
    ASSIGN/V2="PT"+V1
    Write line,FORMAT("%3.3f,%3.3f,%3.3f",V2.XYZ)
    ASSIGN/V1=V1+1
    loop end
    close file

    Instead of V1, you can use directly the variable of the loop (I'm not at the cmm to give you the exact syntax...)
    If csv needs ";" to separate values , you can write /line FORMAT("%3.3f;%3.3f;%3.3f",V2.XYZ)
Reply
  • You can do it in a loop, something like :
    File/open,point.csv,write
    Loop from 1 to number of points
    ASSIGN/V1=1
    ASSIGN/V2="PT"+V1
    Write line,FORMAT("%3.3f,%3.3f,%3.3f",V2.XYZ)
    ASSIGN/V1=V1+1
    loop end
    close file

    Instead of V1, you can use directly the variable of the loop (I'm not at the cmm to give you the exact syntax...)
    If csv needs ";" to separate values , you can write /line FORMAT("%3.3f;%3.3f;%3.3f",V2.XYZ)
Children
No Data