Translation :
To the c.a. technical support,
already 1 year ago I started this post.
But because of the difficulty in installing Apache, I was stranded.
I also changed pc and operating system.
Now try again.
Operating system: windows10
Ampps vers. 4.3 (Contains: Apache, Mysql, Php)
Python vers. 3.10.2 (64-bit Vers.)
Pycharm Edu vers. 2022.1.3
I run the scraping program: Web Scraping Fernandod1, but it fails on line 85.
These are the settings I assigned:
$ mysqlserverhost = “localhost”;
$ database_name = “Archive”;
$ username_mysql = “root”;
$ password_mysql = “mysql”;
$ sql = "INSERT INTO datasss (nr, date_of_event, l1, l2, l3, l4, l5, l6, l7, l8, l9, l10, l11, l12, l13, l14, l15, l16, l17, l18, l19, l20, l21, l22) VALUES
^
SyntaxError: unterminated string literal (detected at line 85)
Process finished with exit code 1
Warnings :
1 °) The site from which I would like to extract the data has the archive in zipped format.
2 °) If it were difficult to scrap from this site, since I already have the extractions, both in txt and Cvs (Excel) format, is it possible to operate with Python from these elements?
How can I build the graphic part and connect some algorithms, initially simple. Do you have examples you can show me?
Thanks again for a possible answer.
Nelson