When importing points from point files one of the most common issues you may see is that the file does not parse correctly producing this error (No point file format match found) or a similarly sounding error. In almost all situations I have seen, it was due to the bad data within the point file. Whether we are looking at extra characters in the file or bad format it seems that it all relates to the points formatting. Recently, I have received a report from a customer where they were unable to import point file (CSV) into Civil 3D due to “No point file format match found” error. That gave me an idea for this post. Converting CSV to TXT or any other supported format did not help, by the way.
1. Open CSV file with Excel and look at any
suspicious point, take a close look at commas, dots and formatting
2. Notice that the two points show the extra dots. See image:
|Note: Program basically goes through each value checks it and parse it, each time it sees comma (in this case, because it is comma delimited format) it assumes that new value is coming next, then checks next value and parse it, and so on until it reaches the end of the file. Program expects that points be written in a decimal format having only one dot "." separating. If it finds an extra dot it will throw an error. Hence the message we are seeing.|
3. To resolve right-click on CSV file, chose Open
with and select Notepad
4. In Notepad locate problematic points and remove extra formatting and save the file.
5. Go to Civil 3D’s Insert tab and select correct point format and corrected CSV file
6. If you still get the same error, then go back and look for more bad point.
7. Eventually, at the end you will be able to see something like this:
8. After it imports with no error you should be able to see your points.
Stay tuneed for more!