First thing I ran into is the fact that civil files are in meters and Revit files in mm. The second thing is that my Revit files, most of the time, have been setup with shared coordinates.
After a long time twiddling around with excels files I got really annoyed with what excel does with the numbers and I switched to csv files. I don’t say that you can not get excel files to behave the way you want, it’s just that csv files are less cumbersome at this moment.
it’s been a while since I have been playing with civil so I had to do a bit of manual editing of which I am sure it can be done automatically. I just couldn’t remember how I did it last time.
The image above is from a civil file and you see an alignment with a bunch of objects placed along the alignment. These objects are blocks. I have used the data extraction tool. (part of AutoCAD) The data extraction wizard will create a file with the xyz coordinates of the blocks placed along the alignment. I fed the xyz coordinates into dynamo and had it place family instances into Revit. That made me happy until I realized that was missing direction. The Blocks in civil are following the alignment. XYZ alone are not good enough I need an additional vector. That’s where it ends for now because I can’t get a vector with the data extraction tool in Civil. But if you have something that is in an AutoCADbased tool and you the xyz information is enough than indeed you could use this workflow.
Donwload the dyn file civil 2revit dynamo file