hexagon logo
Register Sign in
  • Replies 4 replies
  • Subscribers 221 subscribers
  • Views 71 views
  • Users 0 members are here
Options
Related

csv output difference between 2017 and 2021

lovethepirk
This isn't a pressing issue, but we have statistical software that was programmed to accept 2017 csv output. If anyone has seen the output it isn't pretty, very hard to read.

There was mention of updating to 2021 or greater soon and in our 2021 csv output, I was told it looks different enough where we would will have to re-map the outputs to the statistical software.

Was I told correctly that the output is different? I'm not impressed with how jumbled the csv output is, hard to read in my opinion.

Thanks.
  • Not sure how you are building the CSV file, but if it was with basic scripting, your script will need to be modified to obtain the data from the Geo-Tol outputs. If you are using the built-in to Excel feature, then you should get the same output as you were before.
    Where I am, I updated the basic script to obtain the data regardless of legacy/Geo-Tol outputs.
  • Thanks for the reply...I don't actively program the CMM's but I am familiar with them. We are just using the default csv output. I've done some VBA scripting on the CMM, but refuse to do anymore until I learn how to integrate python into pcdmis, I just cannot stand vba.

    We have a satellite office using xml output, but that output makes zero sense, you cannot make sense of it. I guess since Geotol got implemented post 2017 the default csv output simply cannot be the same without some type of scripting.
  • If you have a pdf output, you can make sense of the data in the csv file. I've also found that headers can be input to the csv files so you can know exactly which output the values are from. But if you aren't utilizing PC-DMIS or reviewing pdf's then I can understand that the data in a csv file would read like gibberish to someone.
  • I'm interested in knowing what are the changes in 2021 version. I also use .csv export (2018 R2) to import data into a metrology Software and would be happy to know if i have to modify the import tool in case we decide to update version !
    Maybe someone using 2021 version could upload a little example of .csv export with some different kind of data ? and eventually a shot of the export window.

    Anyway if it is minor changes you can just code a little VBA script that reshape your data correctly and overrite the file (having done this on another machine, VBA and csv format is nightmare !), but yes this would be one more handling to do.
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement