topography from XML file

topography from XML file

HVAC-Novice
Advisor Advisor
85 Views
2 Replies
Message 1 of 3

topography from XML file

HVAC-Novice
Advisor
Advisor

I got an XML file from C3D. It seems Revit can link Topography (under Insert). But that only allows me to link from ACC projects. But there doesn't seem to be a way to link it from a normal drive. i put the attached file in a random ACC project. But when i access that from Revit, the xml file doesn't show up.

HVACNovice_3-1757533772395.png

 

 

 

And when I try to create the topography from the topo tool (create from CAD), it tells me the elements need to be imported (not sure why it says "import" and not "link". There doesn't seem to be an "import" 

 

HVACNovice_0-1757533146144.png

 

i also tried to convert the xml to a csv online. But I just got a csv that puts all three value into one column instead of separating them into three columns

HVACNovice_1-1757533260942.png

 

if it isn't obvious yet, this is the first time I'm trying this:

  1. am i missing some step when trying to link the file from ACC
  2. Is there a way to link or import the XML file more directly (like from a regular folder without ACC)? 
  3. Is there a good way to convert it to csv so that it has the 3 columns? 
  4. Does the attached XML file need to be different? i.e. does the Civil engineer need to export it in a different way? 

 

 

 

Revit Version: R2026.2
Hardware: i9 14900K, 64GB, Nvidia RTX 2000 Ada 16GB
Add-ins: ElumTools; Ripple-HVAC; ElectroBIM; Qbitec
0 Likes
86 Views
2 Replies
Replies (2)
Message 2 of 3

RDAOU
Mentor
Mentor

@HVAC-Novice 

Revit splits the text column into Northing/Eastin/Elevation check if these are being parsed into the right format. Moreover, check the Country and Regional settings of your system which Revit uses to parse xml and CSV. The format of the XML or CSV file must match your Windows settings. Otherwise, you will need to adjust them in the Windows Control Panel or reformat the xml accordingly. For example:

  • Decimal separator: "." or ","

  • Digit grouping symbol: "." or ","

  • Default delimiter: Tab, ",", or ";"

If these settings do not match, Revit will not be able to read (parse) the XML or CSV file correctly. Do not use Excel use Notepad++

 

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Message 3 of 3

HVAC-Novice
Advisor
Advisor

The Civil engineer found a way to fix the csv. I first delete the first column and the top row. Then in Excel go to Data-> Data Tools -> Text to columns. and that will split up that one column into three. 

 

And this is the online XML-cvs converter I had used. i tried all encoding methods. But none gave me the separated columns directly. 

 

i didn't try the XML-ACC method since i don't like to rely on an ACC project still being available in some years. The csv file is easy to keep with my Revit file. (and it didn't work for me anyway). Is there really no way to use XML file directly without ACC? That obviously would be nice to use XML directly. 

Revit Version: R2026.2
Hardware: i9 14900K, 64GB, Nvidia RTX 2000 Ada 16GB
Add-ins: ElumTools; Ripple-HVAC; ElectroBIM; Qbitec
0 Likes