Excel to Pc-Dmis

[vektor]

is there a script of something for getting data from an excel sheet and in to Pc-Dmis as an variable?

[T Miller]

Isn't it built into 4.2?

[pniven]

Pcdmis Will Output To Excel . But As Far As I Know It Can Not Input Into PCDMIS.

[vektor]

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???

[vektor]

or a script?

[pniven]

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.

[T Miller]

I've never done it. But if I remember I seen a post that will write in from a text file..

[pniven]

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


[QUOTE]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

[jjewell]

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 ?

[vektor]

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

[cmmguy]

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.

[vpt.se]

Tjena, vektor!

Do you know the exact location of the data in the file that separates the versions from each other? If so, you could make PC-DMIS just read that line, put it in a variable and use an IF/THEN statement to decide which 'version' to run.

A second option : you might need to code a script that parses the file and decides upon the data found which version to run.

...and the third, code a script that interfaces with Excel and by using COM server objects you could have Excel to sort the data out and pass it back to PC-DMIS.

The first suggestion would clearly be the most 'easy' one...

[JEFMAN]

You can also save your Excel sheet (with data) as a .CSV file. Then you can read it as a text file or rename it as .xyz file, and import data as a CAD.If you choose this way, you will have to change ";" by "," and write in head "XYZIJK METRIC".
Bye

[vektor]

Will try this.
Thank you :)

[080903k]

.1监控内容 设计、供货、监控 (http://www.cydjk.com/jk.htm)工程安装、调试与检测和维护安防监控系统：1.2系统工程管理目标 1)实行以合同期为目标的项目法施工，监控 (http://www.cydjk.com/jk.htm)全面履行工程合同，保工期、保质量、保完工。2)采取有效可靠的质量保证措施，监控 (http://www.cydjk.com/jk.htm)创工程优良，并达到优质工程评定条件。3)建立强有力的项目领导班子，监控 (http://www.cydjk.com/jk.htm)组织一流素质的施工队伍，采取先进的施4)监控 (http://www.cydjk.com/jk.htm)工管理方法和施工技术