unable to load a csv catalogue

Question

Hi, I'm trying to upload a new csv catalogue in myDB (less than 500 KB) but I continue to get an error: "Unable to process upload. Verify that the csv headers are present and that they match the table schema (for existing tables).". I can not understant what the problem is. Thanks.

The first rows of my file are:

ra,dec,name

135.5244181209099,-1.95698313545906,1

Answer 1

Thanks for reaching out. Maybe it's just the formatting here on the Helpdesk, but there appears to be a blank line between your header line and the first data row. Is this the case?
Other potential issues can be if in further rows there are a different number of columns (by accident), or special/invalid characters, or even unexpected white space after a comma.
If these general hints don't fix it for you, would you mind sending your csv file as an email attachment to datalab@noirlab.edu (please reference this Helpdesk post) so that we take a closer look?

Comments

Hi Robert, Thanks a lot for your check. Your suggestion (to use in the name of the file to upload only small-caps letters, digits, underscore symbol, and the first letter  not be a digit) worked for me.