hexagon logo

Excel to Pc-Dmis

is there a script of something for getting data from an excel sheet and in to Pc-Dmis as an variable?
  • Pcdmis Will Output To Excel . But As Far As I Know It Can Not Input Into PCDMIS.
  • Ok!
    how about some sort of software that can read excel then output to a txt file
    and then the pc-dmis software can read the txt file???
  • Anytime I have gotten a hard copy of data I had to type it all in to a program. The only way to import data to pcdmis that I know of is through cad or dmis file. Maybe someone else might know something. But I have never heard anything about it. SORRY I COULD NOT HELP MORE.
  • I've never done it. But if I remember I seen a post that will write in from a text file..
  • I DO NOT KNOW HOW TO POST THE THREAD BUT I FOUND THIS.
    Ok i finally got it to send the information to a .txt file so how do you get back in as variables?

    Thanks






    Code:
    FPTR =FILE/OPEN,C:\TEST.TXT,READ
    V1 =FILE/READLINE,FPTR,{FILEVAR}
    FILE/CLOSE,FPTR

    When you do that you reference FILEVAR when ever you need what was in the text file.
    __________________[/QUOTE
    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #8 11-01-2007, 02:39 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    I really apperciate all of your help. When i try to insert something into the code it either deletes it or i can't put any thing there. I tried to copy and paste what you entered and also i finally found the help for reading from a file in the help menu, but i couldn't even put that in there.


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List

    #9 11-01-2007, 02:42 PM
    craiger_ny
    PC-DMIS Guru Join Date: Apr 2006
    Location: Elmira, NY ~ 853 miles from God's country
    Posts: 2,744


    Insert > File IO
    __________________
    _Believe nothing, no matter where you read it, or who said it, unless it agrees with your own reason and your own common sense. ~ Buddha_


    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #10 11-01-2007, 02:48 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    thanks


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List


    Page 1 of 2
  • Vektor,

    I apologize if I am not understanding your question, but there is a way to do what you asked the 2md time. You can create an XYZ file, its a simple text file. There is a line of parameters it needs is all.

    It will put the feature name ( PT12X34) in, the xyz coordinates and if you have the data, the IJK values. Once its read in, you can just pick those points off the screen and it will automatically bring up the autofeature box with all that info in it. You can even window around up to 250 (I think) at a time and write a huge program in seconds....I do this with Boeing files (Although they are DES files, I convert them to XYZ files....

    Let me know if this is what you are trying to do, or explain what you want to do with the data ?
  • I im trying to let Pc-Dmis decide what version of the measurment it shuld run
    there are 18 versions at the moment it can take up to 30 min just to figure out what version it is.
    They are so alike
    If i can get Pc-Dmis to read some data from our ordering system then this solusion shuld make my life alot easier
  • I im trying to let Pc-Dmis decide what version of the measurment it shuld run
    there are 18 versions at the moment it can take up to 30 min just to figure out what version it is.
    They are so alike
    If i can get Pc-Dmis to read some data from our ordering system then this solusion shuld make my life alot easier


    You want to create a parametric program and use Excel as the database?

    If so:
    Excel makes it a pain.
    How many different parts in the family?
    How many parameters in each part?

    A simple text file might be easier to manage

    I always use a text file to manager parametric data.