Not able to display CSV

It looks like there’s a bug in either the plugin or the WordPress HTTP API where it’s unable to read the CSV data when that data is served gzip compressed. I was able to make the shortcode you used work on a test server by ensuring the CSV file is served as an uncompressed binary stream. If you can modify your HTTP server behavior, this may be a workaround you can use while I work on implementing a fix in code.

Thanks for reporting this.

Hmm, y’know what, I take it back. This seems to work fine for me even when I serve the CSV file gzip encoded and with a text/csv Content-Type HTTP header. The problem is actually how my plugin handles the spaces in your URL path.

I will be releasing a new version of the plugin later today. Please update when you get a chance. Again, thanks for reporting this bug.

Upgraded, but still not woking.
See https://lelaurier.net/releve-de-compte/

Thanks to look agsain.

When I use the shortcode you provide, I get a table. I can pull your CSV file and see its data in my post. You may want to ensure no other plugin is interfering with the output. Since it now works for me, I can’t offer any further help.

I try disabling plugins but could not find any that was interfering with the output.
I got it working with a Google Sheet but would prefer to use CSV (easier for my users to upload the file).

Could you please have a look to this url https://lelaurier.net/test-releve-de-compte/
The CSV still show only a Line.
But the second instance of the Google Sheet (identical code to the first one) does not display some Datatable Objects (like if “dom”: “B<‘clear’>lfrtip” is not working)

Could this help finding the problem ?

Code is:
[gdoc key=”https://docs.google.com/spreadsheets/d/1qbkOQMu8c3vxFF_-iNdZLN7i4wenfZWcqeT4Y6kNGh4/edit?usp=sharing&#8221; ]
—————-
[gdoc key=”https://lelaurier.net/fileaway/Administration/Finance/comptes/comptes.csv&#8221; ]
—————–
[gdoc key=”https://docs.google.com/spreadsheets/d/1qbkOQMu8c3vxFF_-iNdZLN7i4wenfZWcqeT4Y6kNGh4/edit?usp=sharing&#8221; ]

Yeah, the CSV file doesn’t print out any content on your site. But I can’t replicate that, sorry. Like I said before, when I use the shortcode you provide, with your CSV file, even served from your server, it works fine.

Thanks for the quick answer again. Sorry to bother you.

I do appreciate that the problem is with my site but I was hoping that by inspecting my code at https://lelaurier.net/test-releve-de-compte/ you could tell me more for what to look for.

The fact the “dom”: “B<‘clear’>lfrtip” is not working for the second
[gdoc key=”https://docs.google.com/spreadsheets/d/1qbkOQMu8c3vxFF_-iNdZLN7i4wenfZWcqeT4Y6kNGh4/edit?usp=sharing&#8221; ]
does not tell you anything new?

Could it be my Theme? I used GeneratePress. I will contact them.

I don’t think the two issues are related. You are looking at two separate issues, most likely.

I disable all plugins and I am still having the problem.

Finally got to the theme developper (GeneratePress) to see if there is a conflict with it.
Here is the respond I got:
“I am seeing this error in my inspect console:
Uncaught TypeError: Cannot read property ‘aDataSort’ of undefined
Which points to a javascript error in the plugin.”

Any idea?

Hi,

On demand of my theme developper, I tried with Twenty Sixteen (in previsualisation) and the page https://lelaurier.net/test-releve-de-compte/ does not even open (just stay on same page).
If I remove the CSV code, it open.

Please check again.

I don’t think the theme developer understood what your problem was. Look, it’s not a matter of the JavaScript because no HTML is being produced on your site. Here’s a screenshot showing what I mean.

In contrast, when I use the shortcode you showed (that points to the CSV file on your server) on my test site, running the Twenty Sixteen theme, the HTML is produced and the JavaScript executes without an error. Here’s another screenshot showing what I mean.

Therefore, I cannot reproduce the issue and that means whatever is causing the problem is something else on your server.

If you want, you can show the theme developer (or whatever other developers you are talking with) this thread, to give them a better idea of what problems you’re facing, but I am not in a position to resolve this for you.

Hi Meitar,

I do appreciate that you took the time to answer again. Sorry for my insistance. I would really like to use your plugin with CSV.

Here is where I stand:
1) I rule out plugins conflict as I desactivated ALL others plugins and had same problem.
2) We also rule out the theme conflict as it is not working also on Twenty Sixteen
3) Direct link work, so no access problem

Any idea were I should look now?
Any idea what could cause not generating HTML body code on my site for CSV but still doing it for Goggle Sheet?

Thanks again.

Hi Meitar.

I was thincking about what could be different on my server and realize I am using the French version of WordPress.

Could this be cause in any way by a different language, a different version of WordPress or a different version of your plugin?

I am using the French version of WordPress.

Could this be cause in any way by a different language, a different version of WordPress or a different version of your plugin?

No.