{"id":28724,"date":"2021-05-27T16:01:00","date_gmt":"2021-05-27T13:01:00","guid":{"rendered":"https:\/\/themewp.inform.click\/?p=28724"},"modified":"2021-10-17T04:36:21","modified_gmt":"2021-10-17T01:36:21","slug":"hur-man-exporterar-inlagg-till-csv-i-wordpress","status":"publish","type":"post","link":"https:\/\/themewp.inform.click\/sv\/hur-man-exporterar-inlagg-till-csv-i-wordpress\/","title":{"rendered":"Hur man exporterar inl\u00e4gg till CSV i WordPress"},"content":{"rendered":"

WordPress \u00e4r en bloggplattform. En blogg \u00e4r inget annat \u00e4n en samling inl\u00e4gg. I vissa scenarier kanske du vill dela din lista med inl\u00e4gg med n\u00e5gon via CSV-filen. Det kommer att vara till hj\u00e4lp att titta snabbt p\u00e5 alla inl\u00e4gg utan att logga in p\u00e5 instrumentpanelen. Med en s\u00e5dan CSV kan du enkelt hitta inl\u00e4ggstiteln och deras permal\u00e4nk. I den h\u00e4r artikeln visar jag dig hur du exporterar inl\u00e4gg till CSV i WordPress.<\/p>\n

Jag ska l\u00e4gga till en anpassad knapp p\u00e5 backend-postlistans sida. N\u00e4r du klickar p\u00e5 den h\u00e4r knappen h\u00e4mtas CSV-filen automatiskt som inneh\u00e5ller information om inl\u00e4gg.<\/p>\n

Som ett exempel exporterar jag en inl\u00e4ggstitel, inl\u00e4ggs-URL, kategorier och taggar till CSV-filen. Anv\u00e4ndaren kan l\u00e4gga till fler f\u00e4lt i den. Den slutliga utdata kommer att vara ungef\u00e4r som nedan sk\u00e4rmdump.<\/p>\n

\"Hur<\/a><\/p>\n

L\u00e4gg till anpassad knapp i postlistan<\/h3>\n

F\u00f6r att skapa CSV m\u00e5ste vi f\u00f6rst ge en knapp p\u00e5 listan \u00f6ver backend-inl\u00e4gg. Dessutom skriver vi kod som genererar en CSV genom att klicka p\u00e5 den h\u00e4r knappen.<\/p>\n

\u00d6ppna din functions.php<\/code>fil och placera nedanst\u00e5ende kod i den.<\/p>\n

function admin_post_list_add_export_button( $which) {\n\u00a0\u00a0\u00a0\u00a0global $typenow;\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0if ('post' === $typenow && 'top' === $which) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<input type=\"submit\" name=\"export_all_posts\" class=\"button button-primary\" value=\"<?php _e('Export All Posts'); ?>\" \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php\n\u00a0\u00a0\u00a0\u00a0}\n}\n\u00a0\nadd_action( 'manage_posts_extra_tablenav', 'admin_post_list_add_export_button', 20, 1 );<\/code><\/pre>\n
Ovanst\u00e5ende kod l\u00e4gger till knappen ’Exportera alla inl\u00e4gg’ p\u00e5 inl\u00e4ggslistan som visas p\u00e5 sk\u00e4rmdumpen. H\u00e4r har jag anv\u00e4nt kroken f\u00f6r manage_posts_extra_tablenav<\/code>att placera den anpassade knappen p\u00e5 sidan ’Alla inl\u00e4gg’.<\/p>\n
\"Hur<\/a><\/p>\n
Faktisk kod f\u00f6r export av inl\u00e4gg till CSV<\/h3>\n
I det h\u00e4r skedet \u00e4r du redo med din anpassade knapp som ska generera CSV. L\u00e5t oss nu l\u00e4gga till en kod som genererar CSV genom att klicka p\u00e5 en knapp och skicka den till webbl\u00e4saren f\u00f6r nedladdning.<\/p>\n
L\u00e4gg till koden nedan i functions.php<\/code>filen.<\/p>\n
function func_export_all_posts() {\n\u00a0\u00a0\u00a0\u00a0if(isset($_GET['export_all_posts'])) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$arg = array(\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'post_type' => 'post',\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'post_status' => 'publish',\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'posts_per_page' => -1,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0);\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0global $post;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$arr_post = get_posts($arg);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if ($arr_post) {\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0header('Content-type: text\/csv');\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0header('Content-Disposition: attachment; filename=\"wp-posts.csv\"');\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0header('Pragma: no-cache');\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0header('Expires: 0');\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$file = fopen('php:\/\/output', 'w');\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0fputcsv($file, array('Post Title', 'URL', 'Categories', 'Tags'));\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0foreach ($arr_post as $post) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0setup_postdata($post);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$categories = get_the_category();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$cats = array();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if (!empty($categories)) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0foreach ($categories as $category) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$cats[] = $category->name;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$post_tags = get_the_tags();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$tags = array();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if (!empty($post_tags)) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0foreach ($post_tags as $tag) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$tags[] = $tag->name;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0fputcsv($file, array(get_the_title(), get_the_permalink(), implode(\",\", $cats), implode(\",\", $tags)));\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0exit();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0}\n}\n\u00a0\nadd_action( 'init', 'func_export_all_posts' );<\/code><\/pre>\n
Det \u00e4r allt! Forts\u00e4tt och prova. Du b\u00f6r h\u00e4mta CSV-filen tillsammans med informationen om ditt inl\u00e4gg.<\/p>\n
Jag hoppas att du f\u00f6rst\u00e5r hur du exporterar inl\u00e4gg till CSV i WordPress. Dela dina tankar och f\u00f6rslag i kommentarsektionen nedan.<\/p>\n
relaterade artiklar<\/h4>\n