minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Does not show graph when load from shared Google Drive file CSV file

Fri Sep 15, 2023 1:12 pm

Hi there,

I'm just trying to create a simple chart that loads simple data (Values 1, 2, 3) from a share CSV file on Google Drive. For some reason, there is no graph. Could someone help me look into it?

Link to CSV file: https://drive.google.com/file/d/1SEjl64 ... sp=sharing
Link to JSFiddle: https://jsfiddle.net/ntintel/6xuL8724/

Thank you.

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Sat Sep 16, 2023 12:37 am

I uploaded the file to GitHub for raw access and still no graph. Link to GitHub: https://raw.githubusercontent.com/Realn ... ample1.csv

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Sat Sep 16, 2023 2:52 am

When I replaced the link with a file from Highcharts GitHub Repository itself, it still doesn't work: csvURL: 'https://github.com/highcharts/highchart ... s-2015.csv'

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Sat Sep 16, 2023 4:25 am

I've figured it out. It needs an x-axis column.

jakub.j
Posts: 886
Joined: Tue Jan 24, 2023 11:14 am

Re: Does not show graph when load from shared Google Drive file CSV file

Mon Sep 18, 2023 7:55 am

Welcome to our forum and thanks for contacting us with your question!

As for now, there is no way to load data from a shared Google Drive file in Highcharts, but the approach with Github is fine and there shouldn't be any problems. It looks like your demo is also working correctly when loading this file.

Demo: https://jsfiddle.net/BlackLabel/fwyu5kh6/

​If you have further inquiries, you may reach out to me at any time.
Best regards
Jakub
Jakub
Highcharts Developer

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Tue Sep 19, 2023 5:55 am

Thanks Jakub. I got it working. And Google Drive needs an API Key and a sheet key, got that done too.

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Thu Sep 21, 2023 12:32 pm

Hi Jakub. Sorry to bug you again.

I loaded the same csv to my local web server IIS, as shown here:
Image, or this link: https://ibb.co/Sdk5W3w. You can see the content of the CSV file from accessing the link locally via its URL. Permission is set publicly for IIS users.

but the chart doesn't show anything (Image, or at https://ibb.co/xSHZ9v5). It probably has to do with Highcharts failing to get data from the locally hosted file.

Do you have any idea where, what I should look into? Or even how to get error messages from Highcharts?

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Fri Sep 22, 2023 8:23 am

For additional information, I configured the MIME type of CSV as 'text/plain' on IIS, so it will show the csv file's content directly on the browser.

minh
Posts: 8
Joined: Fri Sep 15, 2023 1:04 pm

Re: Does not show graph when load from shared Google Drive file CSV file

Fri Sep 22, 2023 8:59 am

I think I've figured it out. I either need to place the HTML file in the same folder as the CSV file in IIS, or enable some CORS configuration for it to work.

Return to “Highcharts Usage”