{"id":9552,"date":"2021-04-30T12:29:57","date_gmt":"2021-04-30T10:29:57","guid":{"rendered":"https:\/\/www.beseit.net\/?p=9552"},"modified":"2021-04-30T12:41:37","modified_gmt":"2021-04-30T10:41:37","slug":"posar-subtitols-en-catala-2","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=9552","title":{"rendered":"Posar subt\u00edtols en catal\u00e0 2"},"content":{"rendered":"<p>El &#8220;Carregador&#8221;, tamb\u00e9 ha creat el fitxer &#8220;1all_one_line.txt&#8221; el format el podem veure a sota. Com veiem te el separador <span style=\"color:red\"><strong>; <\/strong><\/span>que \u00e9s ideal per a importar amb dades en Excel (text en columnes).\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto1.png\" alt=\"\"\/>\n\t<\/p>\n<p>Entrar aquest Excel a una taula Access \u00e9s trivial\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto2.png\" alt=\"\"\/>\n\t<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto3.png\" alt=\"\"\/>\n\t<\/p>\n<p>Aquesta taula \u00e9s convenient conservar-la a base de dades de  MySQL subtituls. Pe aix\u00f2 farem un enlla\u00e7 via ODBC\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto4.png\" alt=\"\"\/>\n\t<\/p>\n<p>\n\u00a0<\/p>\n<p><strong>A onedrive\/access\/ <\/strong>hi ha les connexions dsn per a <strong>vincular <\/strong>les taules a taules access.\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto5.png\" alt=\"\"\/>\n\t<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto6.png\" alt=\"\"\/>\n\t<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto7.png\" alt=\"\"\/>\n\t<\/p>\n<p>En resum MySQL-AUX (que t\u00e9 la mateixa estructura que totes les taules de <strong>polidic <\/strong>est\u00e0 vincula amb acc\u00e9s i la consulta d&#8217;annexar a MySQL-AUX hi posar\u00e0 el registres de Full1.\n<\/p>\n<p>\n\t\t<img decoding=\"async\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2021\/04\/043021_1041_Posarsubtto8.png\" alt=\"\"\/>\n\t<\/p>\n<p>\u00c9S convenient anar a MySQL i canviar el nom de la taula amb el del la pel\u00b7l\u00edcula que volem conservar els subt\u00edtols. Creant pr\u00e8viament una copia de la estructura del fitxer per a la pr\u00f2xima vegada que vulguem salvar nous subt\u00edtols en BD\n<\/p>\n<p>\n\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El &#8220;Carregador&#8221;, tamb\u00e9 ha creat el fitxer &#8220;1all_one_line.txt&#8221; el format el podem veure a sota. Com veiem te el separador ; que \u00e9s ideal per a importar amb dades en Excel (text en columnes). Entrar aquest Excel a una taula &hellip; <a href=\"https:\/\/www.beseit.net\/?p=9552\">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-9552","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9552"}],"version-history":[{"count":4,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9552\/revisions"}],"predecessor-version":[{"id":9580,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9552\/revisions\/9580"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}