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.
SOLVED!

Import Terrain XYZ - Error is not in the right format

Hey guys I need little help with formatting coordinations.

I'm doing terrain model from DWG drawings


1. I got 3D Lines / curve - > I opened in Rhino and exported from lines to points and save like . txt = XYZ

Skärmavbild 2022-11-08 kl. 11.01.37.jpgSkärmavbild 2022-11-08 kl. 11.01.47.jpg

2. I opened in "notepad" and remove all symbols what I don't need it

Skärmavbild 2022-11-08 kl. 10.52.45.jpg


3. Then I opened in Excel and export to the 3 collums

Skärmavbild 2022-11-08 kl. 10.52.25.jpg

After all my work with it ... I stile cannot export it to Archicad 😕
I got Error note

What's wrong I'm doing ? It's becoming quite complicated but I really would like to learn it how to do it.

 

*No Elements were created. The source file is corrupted, is not in the right format or doesn't contain valid coordinates.

 

Skärmavbild 2022-11-08 kl. 10.53.18.jpg

AC 7 - 27 SWE

iMac (Retina 5K, 27-inch, 2020),

3,6 GHz 10-Core intel Core i9, 64 GB 2667 MHz DDR4, AMD Radeon Pro 5700 XT 16 GB
1 ACCEPTED SOLUTION

Accepted Solutions
Solution
Mathias Jonathan
Advocate

I work with tabulation for separator and no comma (point).

After a second look, your numbers seems really big. I always work with meters. Perhaps a problem in this direction?

View solution in original post

4 REPLIES 4
Mathias Jonathan
Advocate

what kind of separator (tabulation, semicolon, comma... ) did you use?

when you open the xyz file with textedit?

I replace all separation and put all numbers in to the columns in excel. I think that i tested all of them 🙂 which one is correct ? 

AC 7 - 27 SWE

iMac (Retina 5K, 27-inch, 2020),

3,6 GHz 10-Core intel Core i9, 64 GB 2667 MHz DDR4, AMD Radeon Pro 5700 XT 16 GB
Solution
Mathias Jonathan
Advocate

I work with tabulation for separator and no comma (point).

After a second look, your numbers seems really big. I always work with meters. Perhaps a problem in this direction?

Thanks this is it ... I exported in meter but My export was in millimeters.

I fixed it just change meter to millimeters

 

Skärmavbild 2022-11-08 kl. 11.38.37.jpgSkärmavbild 2022-11-08 kl. 11.38.19.jpg

AC 7 - 27 SWE

iMac (Retina 5K, 27-inch, 2020),

3,6 GHz 10-Core intel Core i9, 64 GB 2667 MHz DDR4, AMD Radeon Pro 5700 XT 16 GB