Display results in CSV-file that is continously updated

Discussion Ask a question
,
1

Hi!
Very new in this, and need some help.
We are creating a webpage to show possibilities for Sweden to run on only clean energy from renewable energy sources. We are doing the modelling i GAMS and the connection between data input to the GAMS-code, MATLAB etc via Python. Now we want to display what we have found out on the webpage with continously updated data from our GAMS code (it gives us an updated CSV-file every hour).

We would like the results to be continously updated on our webpage here on Wix. The output from the model is a CSV-file which matches the database set import function. Altough we need it to be updated automatically every hour. Is it possible to use the import function for database in this case? We could keep the output file on a server, would updating the file on the server then change the file imported to the database?

We have also used “wix-fetch” and found the possibility to upload the information as an URL by letting Pyhton rewrite our output file to a JSON. This is a very “long” process and we’ve been thinking if there is an API similar to “wix-fetch” that can get information directly from the CSV file without the reroute to a URL? To anyone have a tip?

We are now looking into the html-box and to see if we can use this to our cause. Anyone have any tip in this?

Really thankful for any tips and answers. Very new in this!

Best regards
Kristine

2

Hi.

Please take a look at wix-http-functions. You might define a web endpoint and call it with the appropriate data from the net when you are ready to report.
You can use wix-data to update the relevant collection once the data is parsed.

wix-data currently does not support csv format for importing directly from.

Regards,
Genry.

3

Have you found a working solution for this CSV problem? I’ve got exactly the same issue, but I’m having trouble making it happen. Thank you. Derk

4

This is an old post from 2018 and is being closed.
Please add a new forum post to the forum and refer back to this link if needed, rather than bumping up an old thread from 2018.

You can 't import csv files automatically as stated in the original reply from Genry as it involves you having to check it so that the fields are mapped correctly etc.
https://support.wix.com/en/article/importing-data-to-a-database-collection

If you did it automatically and fields were not correctly mapped for example, then that would be your error and not Wix error as you did not check.