topic .txt / XYZ coordinates not importing - surveyor information in Collaboration with other software

.txt / XYZ coordinates not importing - surveyor information

FLA-JM — Thu, 16 Nov 2023 09:36:18 GMT

Hello,

I've extracted the XYZ coordinates from a dwg file - I've set up the file as I have done previously to import surveyors' information to create a mesh of the terrain but for some reason, it doesn't seem to be working?

I've attached the file with the coordinates as a pdf as I can't attach the .txt file - if someone could have a look at this and potentially test it there side it would be much appreciated.

Hope you can help me find the solution!

Thank you,

Re: .txt / XYZ coordinates not importing - surveyor information

Barry Kelly — Fri, 17 Nov 2023 02:20:10 GMT

Seems to work just fine in 26.

I just copied those coordinates into a text file (notepad on Windows), saved it and used the place mesh from survey data command.

Barry.

Re: .txt / XYZ coordinates not importing - surveyor information

FLA-JM — Fri, 17 Nov 2023 09:04:21 GMT

Hi Barry - thank you for looking into this. I think there are survey points missing as I've copied the numbers from the attached file, but in doing so it seems to miss some of the points.

Do you know a shortcut to remove the columns/rows from this file to have it read as the .txt xyz file that's needed to import the mesh? I'm aware it needs to be set up as below;

36000.00[tab]36000.00[tab]36000.00[return]

Re: .txt / XYZ coordinates not importing - surveyor information

Barry Kelly — Fri, 17 Nov 2023 09:50:12 GMT

I really don't know as I rarely do this.

Maybe a spreadsheet program (like Excel) would be best?

But I don't think Excel can open a PDF.

Word can.

But with that new PDF you attached, I just opened it in Word.

Deleted the top 2 rows because they are not co-ordinates.

CTRL+A to copy all and pasted it into Notepad (I am on a Windows machine).

Saving as a .txt or .csv file from Word does not seem to work.

Saved that as a 'txt' file and imported it into Archicad.

Seems to work just fine.

As you said before all you need is the text file to be in the format of ...

x_co-ordinate[tab]y_co-ordinate[tab]z_co-ordinate[return]

Barry.

Re: .txt / XYZ coordinates not importing - surveyor information

FLA-JM — Fri, 17 Nov 2023 10:01:51 GMT

Hi Barry - thanks for this, it all seems to work until I try to copy into a new 'notes' file or 'edit text' file on Mac. It copies the table as well as the text frustratingly and I'm not sure how to prevent this.

Are you able to share the text file with me?

Many thanks.

Re: .txt / XYZ coordinates not importing - surveyor information

Barry Kelly — Fri, 17 Nov 2023 14:04:02 GMT

Notepad on Windows is a very basic text editor.

It can't handle tables which is probably why it works.

Here is the text file (had to zip it to attach).

Barry.