cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Collaborate forum

Converting XYZ data to usable data

Josh Verran
Expert

My query relates to altering/converting XYZ files so Archicad can utilize them without errors.

I'm hoping this is the right forum for that.

 

We get XYZ files from various sources (topographic surveyors), they always come in slightly different from the last, which is understandable, eg sometimes the first column is an ID, sometimes the X and Y column are back to front, sometimes theres -999 Z data that we don't want in mesh etc.

 

Up until now, I have been performing the below operations to make the data usable ("place mesh from survey data"). Think there must be some way (maybe through macros and VBA - I have little to no knowledge) to setup a template excel file that can read a source, then export to a given format with target range.

 

  • Opening a blank excel file
  • Get data from csv
  • Copy the three XYZ columns
  • Paste to new worksheet,
  • Export as txt file
  • Open txt file
  • Save as
  • Change encoding to ANSI.
ARCHICAD 18-25 | BIMcloud Basic | CI Tools - CI Extension by Central Innovation | Windows 10 Pro | Intel Core i7-6700K @4.00GHZ | 32Gb RAM | Dual Samsung S27F350 1920x1080 | Nvidia Quadro P2200 5Gb
2 REPLIES 2

Laszlo Nagy
Community Admin
Community Admin

There is an article that talks about this topic, which you may find useful:

https://community.graphisoft.com/t5/Design-articles/Importing-Point-Clouds-and-Modelling-the-Terrain...

....................................................................................................
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC26
Loving Archicad since 1995

Josh Verran
Expert

Thanks @Laszlo Nagy  that's a great article.
I've only started playing around with point cloud files in the last few months.
Can see lots of possibilities.

ARCHICAD 18-25 | BIMcloud Basic | CI Tools - CI Extension by Central Innovation | Windows 10 Pro | Intel Core i7-6700K @4.00GHZ | 32Gb RAM | Dual Samsung S27F350 1920x1080 | Nvidia Quadro P2200 5Gb

Start a new conversation!

Labels

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!