Contents
Why did Carto import an invalid CartoDB ID?
Invalid `cartodb_id` column – The import failed because your table contains an invalid `cartodb_id` column. If you want to use it as a primary key, its values must be integers, non-null, and unique. Otherwise, try renaming your current `cartodb_id` column.
Why do I get error Carto import CSV?
Malformed CSV – The CSV or converted XLS/XLSX to CSV file contains malformed or invalid characters. Some reasons for this error can be for example multiline header fields or multiline cells at Excel files or unquoted CSV. Too many columns – Data has too many columns.
What does the encoding error mean in Carto?
Encoding error – Problem reading the file. Encoding seems wrong, probably because there’s a wrong character. In order to sort it out, open your file with a text editor, save it with encoding UTF-8 and try again. Encoding error – The file you tried to import failed due to encoding issues.
Why does Carto not import files from Dropbox?
Dropbox permission revoked – CARTO has no permission to access your files at Dropbox. Please import file again. GDrive file was deleted – GDrive file was removed and can’t be synced, please import file again. File is password protected – File is password protected and can’t be imported.
Is there a limit to how many columns you can import into SQL?
I am trying to import an excel sheet to SQL database. This sheet has 700+ columns, but i understand there is a limit of 255 columns. Is there a work around to include all the columns while uploading to database.
What to do if import request does not contain a file?
Not a file – Your import request does not contain a file. Make sure that the request is correctly formatted and/or a file is being posted. Error retrieving data from datasource – There was an error retrieving data from the datasource. Check that the file/data is still present.
Is there a missing projection file in Carto?
Missing projection (.prj) file – CARTO needs a PRJ file for all Shapefile archives uploaded. Contact your data provider to see about aquiring one if it was missing. Otherwise see spatialreference.org to locate the right one if you know it. Remember, the file name for your .prj must be the same as your .shp.