Hello, I´m trying to import topography from a surveyor into the REVIT. I have an excel file with x,y,z points. Saved as CSV. Everytime when I try to import it by ,,Specify points file" revit says ,,no points were found". I tried to look for many solutions but none of them worked. Tried to save the excel as an CSV ( comma delimited) or CSV UTF-8. But it gives me the same result. Uploaded my csv file into Attachments aswell. Thank you for your advices or tips.
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
That's not a proper CSV file. Plus, the Coordinates are way too far away for Revit.
Try the attached TXT file. You can create a Toposurface from TXT files as well as CSV.
also what kind of coordinates do you mean? x y?
Screenshots from autocad:
is it cutout? because it shouldnt look like that or the part of it should but there should be 2 roads from both sides. Also can you tell me how did you manage to filter out the ,,751" and ,,116" from the begging of every number? or coordinates
I think my x coordinates are wrong then. Drop the beginning digit from each x coordinate value.
Here's the main issue with your CSV file. Your xyz coordinates are all dumped into one colomn. On top of that, they are separated by semi-colons. Revit translates COMMA SEPARATED x,y,z values - not semi-colon separated x,y,z values. Lastly, the x,y coordinates are too large. You need to truncate values. Essentially this is like moving the Toposurface closer to the Revit Internal Origin.
that is right they were all dumped into one colomn. My friend managed to fix that. And even after revit still showed me the points not found error.
Are you sure this truncation doesn't work or is incorrect?
000.000, 000.000, 000,000
Now, when I edit it with the points visible it looks correct. Thank you for your help. Even tho I would like to know why my CSV file didnt work. I did watch many youtube tutorials and they all did the same thing. And it did work for them. Maybe it´s because of numbers being ,,too big" for revit. I dont really know. But thank you for your help.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.