{"id":20019,"date":"2026-11-17T18:47:32","date_gmt":"2026-11-17T16:47:32","guid":{"rendered":"https:\/\/www.beseit.net\/?p=20019"},"modified":"2026-11-17T21:46:51","modified_gmt":"2026-11-17T19:46:51","slug":"ajuda-html_a_csv-py-geopolitica-html","status":"publish","type":"post","link":"http:\/\/www.beseit.net\/?p=20019","title":{"rendered":"Ajuda html_a_csv.py geopolitica.html"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A Deepin ja sol venir amb Python 3 instal\u00b7lat, aix\u00ed que no cal instal\u00b7lar res.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Posa <code>html_a_csv.py<\/code> i <code>geopolitica.html<\/code> a la mateixa carpeta (per exemple <code>~\/Desc\u00e0rregues<\/code>).<\/li>\n\n\n\n<li>Obre un terminal en aquesta carpeta: al gestor de fitxers, clic dret dins la carpeta i tria <strong>Obre al terminal<\/strong>. Tamb\u00e9 pots fer-ho des del terminal: <code>cd ~\/Desc\u00e0rregues<\/code><\/li>\n\n\n\n<li>Executa l&#8217;script: <code>python3 html_a_csv.py geopolitica.html<\/code><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Si tot va b\u00e9, veur\u00e0s:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">30 v\u00eddeos escrits a geopolitica.csv\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I tindr\u00e0s <code>geopolitica.csv<\/code> a la mateixa carpeta.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Per comprovar que tens Python, pots fer <code>python3 --version<\/code>. Si diu que no el troba, instal\u00b7la&#8217;l amb:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">sudo apt install python3\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Si vols posar nom a la llista i usar URLs de miniatura de YouTube:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">python3 html_a_csv.py geopolitica.html -n \"Geopol\u00edtica\" --icona youtube\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Que tot hagi pujat de cop vol dir que ara la taula i el CSV quadren columna per columna.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Per qu\u00e8 no et funcionava.<\/strong> El CSV portava <code>nom_llista<\/code>, <code>enllac_icona_video<\/code>, <code>titol<\/code> i <code>enllac_video<\/code>. La taula <code>videos<\/code> antiga tenia a m\u00e9s dues columnes que el CSV no omplia: <code>enllac<\/code> i <code>llista_id<\/code>. Eren obligat\u00f2ries (<code>NOT NULL<\/code>) i sense valor per defecte, aix\u00ed que MySQL rebutjava cada fila amb l&#8217;error <code>Field 'enllac' doesn't have a default value<\/code>. Fallava des de la primera fila, per aix\u00f2 no hi havia manera d&#8217;importar-ne ni una.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Qu\u00e8 he canviat a <code>videos<\/code>:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>He tret les columnes sobrants (<code>enllac<\/code>, <code>llista_id<\/code>) i he deixat nom\u00e9s les quatre del CSV, amb els mateixos noms, de manera que DBeaver les mapa soles.<\/li>\n\n\n\n<li>He tret <code>id<\/code>. No el necessitaves, i la clau prim\u00e0ria ara \u00e9s <code>(nom_llista, enllac_video)<\/code>: un mateix v\u00eddeo no es pot repetir dins d&#8217;una llista, per\u00f2 s\u00ed pot estar a llistes diferents.<\/li>\n\n\n\n<li><code>nom_llista<\/code> \u00e9s clau forana cap a <code>llistes<\/code>. Per aix\u00f2 calia que <code>geopolitica<\/code> exist\u00eds a <code>llistes<\/code> abans d&#8217;importar. La clau forana tamb\u00e9 t&#8217;impedeix tenir v\u00eddeos d&#8217;una llista que no existeix.<\/li>\n\n\n\n<li>Amb <code>ON UPDATE CASCADE ON DELETE CASCADE<\/code>, si reanomenes una llista, els seus v\u00eddeos la segueixen. Si l&#8217;esborres, s&#8217;esborren tamb\u00e9 els seus v\u00eddeos.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Per qu\u00e8 tamb\u00e9 he refet <code>llistes<\/code>.<\/strong> En crear <code>videos<\/code>, la clau forana donava l&#8217;error 150. Ho vaig atribuir a la <code>llistes<\/code> antiga, que probablement no tenia <code>nom_llista<\/code> com a clau prim\u00e0ria. Ara en t\u00e9 i amb el mateix tipus i charset que a <code>videos<\/code>. No vam arribar a mirar l&#8217;estructura antiga, aix\u00ed que aix\u00f2 \u00e9s una deducci\u00f3 meva.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Canvis al CSV i a l&#8217;script.<\/strong> He tret la columna <code>id<\/code> i el BOM del fitxer, que \u00e9s el que feia que DBeaver podia llegir malament la primera cap\u00e7alera. L&#8217;script ja genera aquest format directament.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Deepin ja sol venir amb Python 3 instal\u00b7lat, aix\u00ed que no cal instal\u00b7lar res. Si tot va b\u00e9, veur\u00e0s: I tindr\u00e0s geopolitica.csv a la mateixa carpeta. Per comprovar que tens Python, pots fer python3 &#8211;version. Si diu que no &hellip; <a href=\"http:\/\/www.beseit.net\/?p=20019\">Continua llegint <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-20019","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20019"}],"version-history":[{"count":3,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20019\/revisions"}],"predecessor-version":[{"id":20022,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20019\/revisions\/20022"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20019"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}