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

PCDMIS to Excel Problems

kellyh
First, thank you to many of you who posted and gave options for automatically saving PCDMIS to Excel. That command is great.

But, now that I have that working. I have a little problem. The program that I am importing the CSV data to reads the file like a txt file. So the input looks like this
,CONC1,UNITS,MM,,,,,,,,,,,,,,,,,,,,
,DIMENSION,DESCRIPTION,Feature,AXIS,Segment,NOMINAL,MEAS," +TOL"," -TOL",BONUS,DEV,OUTTOL,DEVANG,"Datum Shift Effect","Unused Zone","Shift X","Shift Y","Shift Z","Rotation X","Rotation Y","Rotation Z",,
,CONC1,"Dimension Concentricity (CIR4- SNOUT OD,CIR6- OUTER CIRCLE BELOW STEP)",,M,,0.0000,0.0053,0.

Now, some of our inputs work just fine, but others appear like the one posted above. This poses a problem because in the () there is an extra comma that causes me to import the nominal and not the actual measurement. So 2 questions.

1. Is there a way to just dump that description? or
2. Is there a way to export PCDMIS into a MDB or ACCDB, or even a SQL database?

Thank you so much for any help you can provide.
Parents
  • First, thank you to many of you who posted and gave options for automatically saving PCDMIS to Excel. That command is great.

    But, now that I have that working. I have a little problem. The program that I am importing the CSV data to reads the file like a txt file. So the input looks like this
    ,CONC1,UNITS,MM,,,,,,,,,,,,,,,,,,,,
    ,DIMENSION,DESCRIPTION,Feature,AXIS,Segment,NOMINAL,MEAS," +TOL"," -TOL",BONUS,DEV,OUTTOL,DEVANG,"Datum Shift Effect","Unused Zone","Shift X","Shift Y","Shift Z","Rotation X","Rotation Y","Rotation Z",,
    ,CONC1,"Dimension Concentricity (CIR4- SNOUT OD,CIR6- OUTER CIRCLE BELOW STEP)",,M,,0.0000,0.0053,0.

    Now, some of our inputs work just fine, but others appear like the one posted above. This poses a problem because in the () there is an extra comma that causes me to import the nominal and not the actual measurement. So 2 questions.

    1. Is there a way to just dump that description? or
    2. Is there a way to export PCDMIS into a MDB or ACCDB, or even a SQL database?

    Thank you so much for any help you can provide.

    Thank you to whoever provided this custom script. It was very useful and helped me fix my problem with a bit of tweeking. http://www.pcdmisforum.com/showthread.php?16586-my-solution-to-CSV-output I can now import the necessary data consistently.
Reply
  • First, thank you to many of you who posted and gave options for automatically saving PCDMIS to Excel. That command is great.

    But, now that I have that working. I have a little problem. The program that I am importing the CSV data to reads the file like a txt file. So the input looks like this
    ,CONC1,UNITS,MM,,,,,,,,,,,,,,,,,,,,
    ,DIMENSION,DESCRIPTION,Feature,AXIS,Segment,NOMINAL,MEAS," +TOL"," -TOL",BONUS,DEV,OUTTOL,DEVANG,"Datum Shift Effect","Unused Zone","Shift X","Shift Y","Shift Z","Rotation X","Rotation Y","Rotation Z",,
    ,CONC1,"Dimension Concentricity (CIR4- SNOUT OD,CIR6- OUTER CIRCLE BELOW STEP)",,M,,0.0000,0.0053,0.

    Now, some of our inputs work just fine, but others appear like the one posted above. This poses a problem because in the () there is an extra comma that causes me to import the nominal and not the actual measurement. So 2 questions.

    1. Is there a way to just dump that description? or
    2. Is there a way to export PCDMIS into a MDB or ACCDB, or even a SQL database?

    Thank you so much for any help you can provide.

    Thank you to whoever provided this custom script. It was very useful and helped me fix my problem with a bit of tweeking. http://www.pcdmisforum.com/showthread.php?16586-my-solution-to-CSV-output I can now import the necessary data consistently.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement