hexagon logo
Register Sign in
  • Replies 4 replies
  • Subscribers 32 subscribers
  • Views 59 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.
  • 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.
  • Hi,
    there is one way to create a mdb database with simple external command at the top of the part program.
    this one software provided by Hexagon France (available & documented in english language) , this is already used by many majors compagnies.

    You can try this link to get the software installation kit :
    - Software Kit
    - User Guide

    you can try it for 21 days for free ... ;-)
    if you need assistance or more information you contact Elgin(WI) application team !Slight smile
  • Hi Charlyboy,

    Im trying to use this software as it looks very useful for what I am trying to achieve,

    Im having trouble opening the compressed file though do you have a walk thru?


    Many thanks

    Phil
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement