importing *.pts files into Creo 1.0

[ptc-4284382]

This seems like it should be fairly simple - go to "open" and bring in a *.pts file. But when I go to bring in a file, Creo doesn't even see the files, regardless of whether I tell it to look for all or just "*.pts". I've seen the actual physical data in the file and I can access it both in notepad and excel - in both cases, the coordinates are separated by spaces and not tabs. I've included sample data from the file and I'm not sure why I can't pull it into Creo. I'm also uncertain what that first line actually is (I think it's a count of the total number of points) and I'm wondering if just deleting that will solve my problem.

2473035

2.3026 1.4849 -0.1258 -955

2.3131 1.4998 -0.1283 -1116

2.3155 1.4994 -0.1284 -1084

2.3175 1.4988 -0.1285 -987

2.3236 1.5006 -0.1288 -795

2.3249 1.4993 -0.1288 -666

2.3205 1.5066 -0.1305 -1164

2.3291 1.5102 -0.1310 -987

2.3284 1.5078 -0.1309 -907

2.3294 1.5064 -0.1309 -730

2.3332 1.5068 -0.1311 -345

2.3285 1.5016 -0.1307 -441

2.3266 1.5105 -0.1326 -1132

2.3281 1.5095 -0.1327 -891

2.3309 1.5094 -0.1328 -779

2.3311 1.5075 -0.1327 -538

2.3339 1.5073 -0.1329 -56

2.3308 1.5031 -0.1326 -313

2.3301 1.5128 -0.1346 -1084

2.3278 1.5093 -0.1344 -843

2.3324 1.5103 -0.1346 -762

2.3316 1.5078 -0.1345 -457

2.3339 1.5073 -0.1346 88

I've compressed and attached the entire file (it's currently a .txt), if anyone has any clue how to get this into Creo I'd be very appreciative.

[TomD.inPDX]

Select the Datum Point > Offset Coordinate System. Select the CS and then "import" at the bottom of the dialog.

When I imported your list verbatim, this is what it returned: -note the 1st value was ignored.

!

! DATUM POINT ARRAY DATA FILE

!

! Comment lines should begin with an exclamation mark (!).

! You may have as many comment lines as you wish.

! There must be at least one space between values.

!

! Enter values with respect to datum arrays' coordinate system:

!

!CARTESIAN coordinates:

! X Y Z

!

1.4849 -0.1258 -955.0000

1.4998 -0.1283 -1116.0000

1.4994 -0.1284 -1084.0000

1.4988 -0.1285 -987.0000

1.5006 -0.1288 -795.0000

1.4993 -0.1288 -666.0000

1.5066 -0.1305 -1164.0000

1.5102 -0.1310 -987.0000

1.5078 -0.1309 -907.0000

1.5064 -0.1309 -730.0000

1.5068 -0.1311 -345.0000

1.5016 -0.1307 -441.0000

1.5105 -0.1326 -1132.0000

1.5095 -0.1327 -891.0000

1.5094 -0.1328 -779.0000

1.5075 -0.1327 -538.0000

1.5073 -0.1329 -56.0000

1.5031 -0.1326 -313.0000

1.5128 -0.1346 -1084.0000

1.5093 -0.1344 -843.0000

1.5103 -0.1346 -762.0000

1.5078 -0.1345 -457.0000

1.5073 -0.1346 88.0000

[ptc-4284382]

That makes sense...unfortunately, my software isn't seeing either of the *.pts or *.txt files, and I'm at a loss as to why.

Beyond that, the other thing that frightens me is that the third column being returned there is not a coordinate point. I would assume that it is actually something like a refraction index because when I saw the images directly off the camera and while they're black and white, they look like panoramic fish eye photos...and that number is telling you how light or dark the image is.

[TomD.inPDX]

Remove the spaces from your file names.

Yep, you do have to format the data. Bring it into Excel and create the PTS file from there.

[ptc-4284382]

*smacks head to desk* Well that's pretty embarrassing.

As for formatting the data...I've got 2 million points to work through and the four values on each line are contained in a single column in excel. Am I as screwed as I think I am right now?

(thanks for the speedy responses, btw. Appreciate it a lot)

[TomD.inPDX]

You need to import the data into excel as space delimeted. Not sure how that's done, but I've seen it done. If you need a specific delimiter such as a comma, you can replace all the spaces with <delimiter> with a simple text editor.

[TomD.inPDX]

Wow! That file is massive! Even Excel wouldn't import the whole thing. It stopped at 1,048,575 entries.

Anyway, MS Office 2010 Excel will import the text as space delimited using the Data tab "from text".

Oddly enough, Notepad pretty much crashes on the file

Do you really think Creo can handle that much point data without choking? Looking forward to the results.

PS: I've attached the 1st 1M entries in the text file.

[TomD.inPDX · Accepted solution]

Oh, and Creo reports the point limit at 30117 for the import.

[ptc-4284382]

And that's the error I'm getting now. Something tells me that it won't be worth it to try to pull this in in chunks because the original file is >2M points.

Antonius, you have been an amazing help, thank you very much. Looks like I'll have to go about a different way of getting this to work.

[TomD.inPDX]

Happy to help. Sorry you ran into the limitation.