Title: Problem with CSV
Last modified: August 24, 2016

---

# Problem with CSV

 *  Resolved [mavuus](https://wordpress.org/support/users/mavuus/)
 * (@mavuus)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/)
 * Hi there!! Really Nice plugin! I’m interested in buying some premium modules,
   but I’m not able to import csv data. I put all fields, even those I have no data,
   following the sample, but I get this error:
 * PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Required header
   column “nombre-de-la-empresa” missing’ in /home/direxporta/www/wp-content/plugins/
   business-directory-plugin/core/class-csv-import.php:280\nStack trace:\n#0 /home/
   direxporta/www/wp-content/plugins/business-directory-plugin/core/class-csv-import.
   php(262): WPBDP_CSV_Import->set_header(Array)\n#1 /home/direxporta/www/wp-content/
   plugins/business-directory-plugin/core/class-csv-import.php(71): WPBDP_CSV_Import-
   >read_header()\n#2 /home/direxporta/www/wp-content/plugins/business-directory-
   plugin/admin/csv-import.php(308): WPBDP_CSV_Import->__construct(”, ‘/tmp/phpco7jN4’,”,
   Array)\n#3 /home/direxporta/www/wp-content/plugins/business-directory-plugin/
   admin/csv-import.php(82): WPBDP_CSVImportAdmin->import()\n#4 [internal function]:
   WPBDP_CSVImportAdmin->dispatch(”)\n#5 /home/direxporta/www/wp-includes/plugin.
   php(496): call_user_func_array(Array, Array)\n#6 /home/direxporta/www/wp-admin/
   admin.php(226): do_action(‘gestion-de-dire…’)\n#7 {main}\n thrown in /home/direxporta/
   www/wp-content/plugins/business-directory-plugin/core/class-csv-import.php on
   line 280, referer: [http://direxporta.es/wp-admin/admin.php?page=wpbdp-csv-import](http://direxporta.es/wp-admin/admin.php?page=wpbdp-csv-import)
 * nombre-de-la-empresa is my first column on the csv file, so it doesn’t miss..
   I also tried deactivating modules, activating twenty fifting theme… nothing. 
   Please could you give us a hand?
 * [https://wordpress.org/plugins/business-directory-plugin/](https://wordpress.org/plugins/business-directory-plugin/)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114231)
 * Hi Maavus,
 * Sorry you ran into issues here.
 * Can you tell me a bit more about your setup?
    – Version of BD? – Version of WP?–
   Version of PHP? – Can you post a screenshot of the CSV Import screen which shows
   your field configuration and required fields? – Can you post a link to a sample
   CSV that shows the problem?
 *  Thread Starter [mavuus](https://wordpress.org/support/users/mavuus/)
 * (@mavuus)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114253)
 * Yes of course, thanks a lot!!!
 * MySQL 5.5
    Wordpress 4.2.2 PHP 5.3.10
 * [ Screenshot 1](http://direxporta.es/wp-content/uploads/2014/08/FIELDS.jpg)
    
   [ Screenshot 2](http://direxporta.es/wp-content/uploads/2014/08/FIELDS-2.jpg)
 * Everytime I import or validate, I got empty dashboard: [Screen](http://direxporta.es/wp-content/uploads/2014/08/Screen.jpg)
   
   And finally I attach my csv file, maybe I miss something: [CSV](http://direxporta.es/wp-content/uploads/2014/08/pruu.csv)
 * Let me know if you need anything else, thanks again!!!!
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114301)
 * Hi mavuus,
 * The problem appears to be in your CSV file directly.
 * The first row looks like this when I open it up in Excel:
 * nombre-de-la-empresa;sector;descripción-corta-del-negocio;descripción-larga-
   del-
 * That’s garbage, unfortunately. Something about how you’re saving it isn’t keeping
   the encoding correct. What are you using to save the file?
 *  Thread Starter [mavuus](https://wordpress.org/support/users/mavuus/)
 * (@mavuus)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114340)
 * Open Office Calc, charset Unicode UTF-8. Any suggestion? Is it normal no error
   information on pannel?
 * Thanks a lot!
 *  Thread Starter [mavuus](https://wordpress.org/support/users/mavuus/)
 * (@mavuus)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114341)
 * I also tried with no accent file, created with Text Edit, same results.
 * [file](http://direxporta.es/wp-content/uploads/2014/08/pruu1.csv)
 * Also advanced search seems not work, it doesn’t show results properly when you
   use filter of categories or tags, it shows always the same page results, the 
   loop. I really like this plugin but if I couldn’t find solutions I couldn’t buy
   the rest of modules I need 🙁
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114342)
 * Hi Mavuus,
 * We’ve had a lot of reports of people using OpenOffice and having character encoding
   issues with it. I’d suggest trying another tool to create the file. It seems 
   that OpenOffice doesn’t do a good job with it. Folks who use Excel seem to do
   fine. A regular text editor should be fine as well, just make sure it encodes
   the output correctly and doesn’t mangle the accented characters. We know that
   the input engine can handle them if the file is encoded correctly.
 * For search issues, usually it’s best to understand how you did it. Can you tell
   me:
    – What you searched for? (Screenshot of the form just before you search 
   is really the best way) – What you got back? (Again, a screenshot is best) – 
   What did you not see that you expected to see? (Links to specific listings are
   helpful here) – Did you perform this search on the search widget, the Quick Search
   field, or the advanced search screen?
 * Knowing that will help us pin the issue down better.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Problem with CSV’ is closed to new replies.

 * ![](https://ps.w.org/business-directory-plugin/assets/icon-256x256.png?rev=2901888)
 * [Business Directory Plugin - Easy Listing Directories for WordPress](https://wordpress.org/plugins/business-directory-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/business-directory-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/business-directory-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/business-directory-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/business-directory-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/business-directory-plugin/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/problem-with-csv/#post-6114342)
 * Status: resolved