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!