Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

.txt / XYZ coordinates not importing - surveyor information

FLA-JM
Participant

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, 

J

 

 

5 REPLIES 5
Barry Kelly
Moderator

Seems to work just fine in 26.

 

BarryKelly_0-1700187459509.png

 

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

 

Barry.

 

 

 

 

One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11

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]

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

 

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.

 

BarryKelly_1-1700214550918.png

 

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]

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

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

 

BarryKelly_0-1700214199297.png

 

Barry.

One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11

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. 

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.

One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11