I keep getting "No point file match error found" with my CSV file

[michael.lasby]

I keep getting "No point file match error found" with my CSV file

[MMcCall402]

Delete the first line in the CVS file and it'll work.

[MMcCall402]

Another option is the enter # at the beginning of the first line.  That will denote the line as a comment and not a point entry.   

That is what is messing it up. It thinks the first line is a point entry and is expecting numerical values.  So either delete the line to tag it as a comment line with # at the beginning.

[andrewpuller3811]

This error also occurs if you have the csv open when try and import the points into civil 3d.

[ChicagoLooper]

Hi @michael.lasby 

For your csv file…….Save as this

[LucasHicks]

This only happens with excel.  Use Notpad++ or another text editor and you can read the csv with it open.

[ChicagoLooper · Accepted solution]

@michael.lasby 

Based on the csv file you uploaded, you can fix 2 deficiencies in your point file:

1. You have 'blank' cells in your csv, i.e., column E is not completely filled, it has empty cells. Put something in those empty cells. You can place two dashes such as '--' so they won't be empty. 

2. You'll also need to add the '#" sign to precede each column heading. If you don't add the # sign to headings in row 1, AutoCAD will get confused and treat it as data, which it is not. Row 1 merely contains column headings for the benefit of a human user and Acad should not consider them during the point insertion procedure. Your 1st row should look like this: 

 

Alternatively, you may delete row 1 altogether so Acad doesn't have an opportunity to get confused. Whether you delete row 1 or not, you can add a suffix to your csv to serve as a reminder for the point file format. For example:

MyFavPointFile_PENZD.csv