Title: WP CSV to Database – Insert CSV file content into WordPress database Author: mra13 / Team Tips and Tricks HQ Published: 28 kovo, 2010 Last modified: 10 kovo, 2021 --- Ieškoti įskiepiuose ![](https://s.w.org/plugins/geopattern-icon/wp-csv-to-database_f1b072.svg) # wp-csv-to-database * [Informacija](https://lt.wordpress.org/plugins/wp-csv-to-database/#description) * [Atsiliepimai](https://lt.wordpress.org/plugins/wp-csv-to-database/#reviews) * [Kūrimas](https://lt.wordpress.org/plugins/wp-csv-to-database/#developers) [Pagalba](https://wordpress.org/support/plugin/wp-csv-to-database/) ## Aprašymas This plugin has been closed as of 15 gruodžio, 2022 and is not available for download. This closure is permanent. Reason: Autoriaus prašymas. ## Atsiliepimai ![](https://secure.gravatar.com/avatar/056f152326e76251eb370924581be76ff063301b861c6c4754468b86b290c98c? s=60&d=retro&r=g) ### 󠀁[Perfect!](https://wordpress.org/support/topic/perfect-9643/)󠁿 [artcolor](https://profiles.wordpress.org/artcolor/) 13 gruodžio, 2022 1 reply You saved my day!!!! Tons of thanks! ![](https://secure.gravatar.com/avatar/6aa5cb272382d80450c1b9d260d65f3e6499f231990c98283fa2e41e767fd1c6? s=60&d=retro&r=g) ### 󠀁[Fast import](https://wordpress.org/support/topic/fast-import/)󠁿 [lukechinworth](https://profiles.wordpress.org/lukechinworth/) 9 lapkričio, 2021 1 reply Can import thousands of rows in a fraction of a second. ![](https://secure.gravatar.com/avatar/13ca9faaca6b573655c43d4388857b67e1d98d743b2520d9faf039c6a282654f? s=60&d=retro&r=g) ### 󠀁[Buggy and lacking important features](https://wordpress.org/support/topic/buggy-and-lacking-important-features/)󠁿 [ascripter](https://profiles.wordpress.org/ascripter/) 1 kovo, 2019 1 reply 1. no option to choose csv dialect. You have to have „,” delimeter 2. No data conversion options. You want an empty field to be null instead of zero (or „”)? Can’t do it with this plugin. 3. no flexibility. csv table must have EXACTLY the same number of columns than the DB table in EXACTLY the same order. No header matching or column skipping. 4. Dubious errors. Clicking „Import to DB” I get „problem with database query” error because of duplicate entry. Clicking again I get instead „Starting row value exceeds the number of entries being updated to the database from the . csv file”. Clicking „Reload table preview” I get afterwards again the first error when I try to import. So which of the two shall I believe? It finally worked with the „update” checkbox (but only after clicking the „table preview” directly before), even though there was nothing to update but an empty table to be filled. Conclusion: Usage of this plugin is highly error prone because depending on your external data structure you might easily mess up the columns. The upload form seems to have some bugs. Not knowing what’s under the hood, I’m afraid using this plugin on live data might destroy a lot in the worst case. The idea is of this plugin is nice, but I’ll probably end up writing my own python script instead of using this plugin. ![](https://secure.gravatar.com/avatar/1771f767186d364fb8fa5ed912a43a4be4da30c436c3d0d3afed2fff0f0dc5bb? s=60&d=retro&r=g) ### 󠀁[Best CSV importer around](https://wordpress.org/support/topic/best-csv-importer-around/)󠁿 [wehnertb](https://profiles.wordpress.org/wehnertb/) 25 sausio, 2019 1 reply This is one of the best CSV importers I’ve found. I created a couple of new tables for a client and I needed a way to import CSV content into these tables. I tried a number of other components, but they only worked for stock items (posts, pages, comments, etc). This component does that and more. It will import data into your custom tables and it doesn’t so cleanly and easily. This has saved me hours of coding and it has a clean, simple interface that will not overburden my clients with jargon. If you’re looking to import CSV files regularly or just to populate data from the get go, this is the one you’re looking for. ![](https://secure.gravatar.com/avatar/5d2b2b53f354d570fd1f6b2a16c2212a74b429d7fd6b57af252f0df00b558594? s=60&d=retro&r=g) ### 󠀁[Awesome plugin!](https://wordpress.org/support/topic/awesome-plugin-3923/)󠁿 [jelena1401](https://profiles.wordpress.org/jelena1401/) 19 lapkričio, 2018 1 reply Very good! Works like a charm and saves a lot of time. Thank you for making this awesome plugin! ![](https://secure.gravatar.com/avatar/23ed5fcf6e520e0daed114ee3cab262e218caedfd898889dd5edc4559c5ec375? s=60&d=retro&r=g) ### 󠀁[Not Working with qoutes (Solved)](https://wordpress.org/support/topic/not-working-with-qoutes/)󠁿 [alexuidian](https://profiles.wordpress.org/alexuidian/) 19 liepos, 2018 2 replies Current version doesn’t support files with escape characters. you can add this features by adding following line in main.php file: $row = array_map(function($v) { return esc_sql($v) ;}, $row) ; Add this just line After this comment: //If. csv column count matches db column count [ Perskaityti visus atsiliepimus (9) ](https://wordpress.org/support/plugin/wp-csv-to-database/reviews/) ## Programuotojai ir komandos nariai “WP CSV to Database – Insert CSV file content into WordPress database” yra atviro kodo programa. Prie jos sukūrimo prisidėję žmonės surašyti toliau. Autoriai * [ mra13 / Team Tips and Tricks HQ ](https://profiles.wordpress.org/mra13/) * [ Ruhul ](https://profiles.wordpress.org/tips-and-tricks-hq/) * [ Ruhul Amin ](https://profiles.wordpress.org/ruhul-amin/) * [ Josh ](https://profiles.wordpress.org/josh401/) [Išverskite “WP CSV to Database – Insert CSV file content into WordPress database” į savo kalbą.](https://translate.wordpress.org/projects/wp-plugins/wp-csv-to-database) ### Domina programavimas? [Peržiūrėkite kodą](https://plugins.trac.wordpress.org/browser/wp-csv-to-database/), naršykite [SVN repozitorijoje](https://plugins.svn.wordpress.org/wp-csv-to-database/), arba užsiprenumeruokite [kodo pakeitimų žurnalą](https://plugins.trac.wordpress.org/log/wp-csv-to-database/) per [RSS](https://plugins.trac.wordpress.org/log/wp-csv-to-database/?limit=100&mode=stop_on_copy&format=rss). ## Metainformacija * Version **2.6** * Atnaujinta **prieš 5 metai** * Aktyvių instaliacijų **N/A** * WordPress versija ** 3.0 ar naujesnė ** * Ištestuota iki **5.7.16** * Kalba * [English (US)](https://wordpress.org/plugins/wp-csv-to-database/) * [Daugiau](https://lt.wordpress.org/plugins/wp-csv-to-database/advanced/)