{"id":453,"date":"2008-06-15T21:36:54","date_gmt":"2008-06-15T19:36:54","guid":{"rendered":"http:\/\/192.168.1.2:8080\/?p=453"},"modified":"2008-11-21T21:22:02","modified_gmt":"2008-11-21T19:22:02","slug":"migracion-a-wordpress-completada","status":"publish","type":"post","link":"https:\/\/nauj27.com\/blog\/?p=453","title":{"rendered":"Migraci\u00f3n a WordPress completada"},"content":{"rendered":"<p>Bueno pues al fin he realizado <a title=\"Migraci\u00f3n de pmachine a wordpress\" href=\"http:\/\/192.168.1.2:8080\/2008\/06\/14\/diez-motivos-por-los-que-migrar-a-wordpress\/\">la migraci\u00f3n<\/a>. Por el camino he perdido alguna informaci\u00f3n como las categor\u00edas, los usuarios registrados y el estilo visual de la web, pero en el fondo ha merecido la pena. Hace un par de a\u00f1os migr\u00e9 el blog antiguo a <strong>utf8<\/strong>, por lo que los caracteres acentuados se quedaron un poco regular. Ahora se hab\u00edan quedado peor a\u00fan as\u00ed que me he hecho un peque\u00f1o programa para arreglarlo.<\/p>\n<p>Despu\u00e9s de tener la base de datos con todos los art\u00edculos y comentarios he realizado un volcado de la base de datos completa y he aplicado el siguiente script en python:<\/p>\n<pre lang=\"python\"># -*- encoding: utf-8 -*-\r\n\r\ninputFile = 'post_wordpressnauj27.sql'\r\noutputFile = 'post-out-wordpressnauj27.sql'\r\n\r\nfin = file(inputFile, 'rt')\r\nfout = file(outputFile, 'wt')\r\n\r\nfinBuffer = fin.readlines()\r\nfin.close()\r\nfoutBuffer = []\r\n\r\nbadChars =\u00a0 (u\"\u00c3\u00a1\", u\"\u00c3\u00a9\", u\"\u00c3\u00ad\", u\"\u00c3\u00b3\", u\"\u00c3\u00ba\", u\"\u00c2\u00bf\", u\"\u00e2\u201a\u00ac\", u\"\u00c3\u00b1\", u\"\u00c2\u00a1\", u\"\u00c2\u00ac\")\r\nfixedChars = (u\"\u00e1\", u\"\u00e9\", u\"\u00ed\", u\"\u00f3\", u\"\u00fa\", u\"\u00bf\", u\"\u20ac\", u\"\u00f1\", u\"\u00a1\", u\"\u00ac\")\r\n\r\nfor line in finBuffer:\r\n    line = line.decode('utf-8')\r\n    for index in range(len(badChars)):\r\n        line = line.replace(badChars[index], fixedChars[index])\r\n    foutBuffer.append(line.encode('utf-8'))\r\n\r\nfout.writelines(foutBuffer)\r\nfout.flush()\r\nfout.close()<\/pre>\n<p>Una vez hecho esto he volcado el resultado de nuevo en la base de datos y listo. Lo siguiente ser\u00e1 personalizar el aspecto de la web y dejar de usar la plantilla por defecto.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bueno pues al fin he realizado la migraci\u00f3n. Por el camino he perdido alguna informaci\u00f3n como las categor\u00edas, los usuarios registrados y el estilo visual de la web, pero en el fondo ha merecido la pena. Hace un par de a\u00f1os migr\u00e9 el blog antiguo a utf8, por lo que los caracteres acentuados se quedaron [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,5],"tags":[63,197,41],"_links":{"self":[{"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/453"}],"collection":[{"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=453"}],"version-history":[{"count":1,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions"}],"predecessor-version":[{"id":491,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions\/491"}],"wp:attachment":[{"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nauj27.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}