First time at importing .xyz file, please help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-03 08:27 PM
I'm trying to import .xyz files. I got a sample text file from my surveyor. I renamed it with a .xyz extension.
It has this kind of data (see attachment). I tried to import it using the interoperability menu, but the file is not recognized and will not import. How do I get the file to import?
Thanks!
MAC OS Sonoma 14.5
ArchiCAD 28
- Labels:
-
Data Exchange
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-04 04:32 AM
I just tried your figures separated by tabs and it worked.
Barry.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-04 06:56 PM
Hi Barry,
This is what I typed:
MAC OS Sonoma 14.5
ArchiCAD 28
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-04 08:42 PM
I'm getting closer. Even though I was changing the extension on the file, it was not changing the file type. Changing the file type was accomplished by selecting "get info" on the file and changing the extension in the info box. At least now, ArchiCAD is recognizing the file as a .txt file.
However, a dialog box opens that says the data is invalid and that the file must have exactly 3-columns of data. I am working on how to do that now.
MAC OS Sonoma 14.5
ArchiCAD 28
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-05 12:24 AM
The .txt file from the surveyor had too many columns and extraneous data. I copied the data out and pasted it into Numbers, where I was able to then copy only the data that I needed from the columns and rows. Then I pasted it into a TextEdit file. Then I changed the file type to .xyz by editing the extension in the "Get Info" box.
There was a bad data point that corrupted the file, which I fixed manually. Now I'm getting this kind of view in 3d. I have to figure out what to do with the points! I somehow thought the result would be closer to terrain.
 
MAC OS Sonoma 14.5
ArchiCAD 28
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-05 02:44 AM
Hi Steve,
Sounds like you have got the text file format sorted now.
Here is the one I created from your 4 points (2 points are very close to each other.
Just with the default Windows Notebook text editor.
I don't think it matters what order the points are in so long as each point has an X, Y & Z coordinate separated by TAB.
The converter add-on will create a mesh and triangulate all of the points.
Be sure to select the correct surveyors unit as you import it.
Barry.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-05 11:17 PM
Hi Barry,
@Barry Kelly wrote:
The converter add-on will create a mesh and triangulate all of the points.
Is this a different process than described here: https://community.graphisoft.com/t5/Design-articles/Importing-Point-Clouds-and-Modelling-the-Terrain...?
I don't see how to use the converter add-on.
MAC OS Sonoma 14.5
ArchiCAD 28
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-06 04:08 AM
Steve,
Use "Place mesh from surveyor's data" command. You'll get what Barry showed in his screenshot. This isn't a point cloud.
Hope that helps.
Karl
One of the forum moderators
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-08 07:50 PM - edited ‎2023-05-08 08:10 PM
Hi Karl, 
Here's the series of steps that I had to take to get this to work on a Mac, in case anyone else is struggling with it:
1. Open surveyor's file (It was labeled .xyz, but it opened in Numbers
2. Copy relevant data by dragging to select and copying
3. Paste into TextEdit using CMD-Option-Shift-V (This is supposed to just paste the data, but I'm not sure if it worked, based on step 6.
4. Change TextEdit file to .txt in the "Get Info" box
5. Open the TextEdit file
6. Delete this misc text at the top, above the three columns of data and the slash at the end of each row, and the } at the end of the data
7. In Plan view, use the Interoperability -> Place Mesh from Surveyor's Data command
A piece of cake... Ha!
Thank you for your help!
MAC OS Sonoma 14.5
ArchiCAD 28
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-15 02:59 AM
you .xyz file is in the incorrect format.The .xyz format must contain only the xyz info. you will need to reformat the .xyz information in excel and save as .txt file.
1. Open the .txt file and select all , copy.
2. Open Excel paste make sure sure the info is in indivual columns.
3 delete the first row with the headings. Then delete survey point numbers in the first column by deleting the column and repeat for the last
4 make sure what you have left is three columns each with plain survey data.
5 Save excel as .txt
This article may be helpful:
https://asiabim.wordpress.com/2016/03/15/creating-topography-in-archicad-from-autocad-survey-data/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023-05-15 03:10 AM
This video will be very helpful in how to format the data correctly :