0

I have some jquery files I am using to customize Django admin. I want to draw in a code table from a local csv file using Google's jquery-csv.

function getCodeTable() {
    $.ajax({
        url: "admin/js/custom/Sample100.csv",
        aync: false,
        success: function (csv) {
            csv_as_objects = $.csv.toObjects(csv);
        },
        dataType: "text",
        complete: function () {
            return csv_as_objects;
        }
    });
}

The original csv file is created by Postgres. When I put it in my project and try to access it, I get this error:

CSVDataError: Illegal quote [Row:3]

Thinking that there is something wrong with the csv, I have opened it in Notepad++ to look for problems, but I see none.

I have run the file through https://csvlint.io/ and it came out valid. I then downloaded their Standardized CSV of the same file. When I opened it and looked at it, the only changes it made where to put quotes around the primary keys. I put that in my project and ran, and came back with the same error:

CSVDataError: Illegal quote [Row:3]

I thought Postgres is giving me some badly formatted csv file somehow, so I went to this site https://www.appsloveworld.com/sample-csv-file/ and downloaded a csv file named Sample100.csv to see how that works.

Comes back with the same error:

CSVDataError: Illegal quote [Row:3]

So now it seems any csv file I put in comes back with the same error. I do not know if this is a jquery-csv library problem (doubt it), or if I am missing something in my code

First 5 lines of codeTable.csv:

"codecategoryid","codecategorydesc","codetypeid","codetypedesc"  
15,"Address Types",60,"Mailing Address"  
15,"Address Types",59,"Physical Address"  
15,"Address Types",61,"PO Box"  
8,"Agricultural Employee Types",22,"Distribution Worker"

First 5 lines of Standardized CSV of my codeTable.csv downloaded from https://csvlint.io/: 

"codecategoryid","codecategorydesc","codetypeid","codetypedesc"  
"15","Address Types","60","Mailing Address"  
"15","Address Types","59","Physical Address"  
"15","Address Types","61","PO Box"  
"8","Agricultural Employee Types","22","Distribution Worker"

First 5 lines of Sample100.csv downloaded from https://www.appsloveworld.com/sample-csv-file/: 

Serial Number,Company Name,Employee Markme,Description,Leave  
9788189999599,TALES OF SHIVA,Mark,mark,0  
9780099578079,1Q84 THE COMPLETE TRILOGY,HARUKI MURAKAMI,Mark,0  
9780198082897,MY KUMAN,Mark,Mark,0  
9780007880331,THE GOD OF SMAAL THINGS,ARUNDHATI ROY,4TH HARPER COLLINS,2
Shubham Agrawal
  • 104
  • 10
arc
  • 37
  • 6

1 Answers1

0

If you are trying to use the jQuery CSV data parser on Mac, it might give you this error:

CSVDataError: Illegal quote [Row:3]

The reason is likely your CSV file that was saved on a Mac and line endings on Macs use special characters, and the parser “chokes” on them and spits out this error.

The only solution I can find this is from here

If you want a quick and dirty fix. Just add a 'state' object literal with rowNum and colNum both initialized to 0.

AzyCrw4282
  • 7,222
  • 5
  • 19
  • 35
  • I've figured out that any calls I make to a csv or json, it comes back as the entire page of html, via the console. This is why the data always thrown an error. And now my new issue: why is the entire page of html coming back instead of the file contents? This is a Django setup on Win 10. – arc May 26 '20 at 01:56
  • function getCodeTable() { $.ajax({ type: "GET", url: "admin/js/custom/codetable.json", aync: false, datatype: "json", success: function (data) { console.log(JSON.parse(data)); }); } – arc May 26 '20 at 01:59
  • I can switch this between json and csv, and it always comes back the same: the whole page's html @AzyCrw4282 – arc May 26 '20 at 02:00