Error Importing from Excel

I am also getting an error when trying to upload an excel sheet. However, the page goes blank instead of giving me an error message.

Please, it would be fine if you could also provide an example excel that shows the features of the import.

How should an average user be able to understand what he is supposed to do with that function.

Otherwise great project.

Regards

I have the blank page too.
Did some debugging. The PHPExcel Class is missing.
Download it at https://phpexcel.codeplex.com/
Rename the unzipped folder to “PHPExcel” and put it in wp-content/plugins/ultimate-product-catalogue/
The include path that should match now is wp-content/plugins/ultimate-product-catalogue/PHPExcel/Classes/PHPExcel.php

I still had no luck getting it running. After loading the file the page still goes blank. My php lacks the php_gd2 extension but I dont know why I need an image extension for reading a text xls.

The following requirements should be met prior to using PHPExcel:
* PHP version 5.2.0 or higher
* PHP extension php_zip enabled *)
* PHP extension php_xml enabled
* PHP extension php_gd2 enabled (if not compiled in)

The format of the excel file is defined as:
$Allowed_Fields = array (“Name” => “Item_Name”, “Description” => “Item_Description”, “Price” => “Item_Price”, “Image” => “Item_Photo_URL”, “Category” => “Category_Name”, “Sub-Category” => “SubCategory_Name”);

You need the array keys in your table. Name, Description, Price, Image…..

Also you should know that the import script cant import new categories or sub-categories. They should be added before importing.

Hi All,

First, Andre thanks for the awesome reply!

Like Andre said, the PHPExcel files appear to be missing sometimes when the plugin gets installed. Some users seem to end up with most of the files, others hardly any. I think the problem might be that there are a almost a thousand files in the class, so I’ll try to strip out everything that’s not used by the plugin. I’ll have the stripped down version released with the next version sometime next week.

As for the request for a sample sheet, I’ve added a link to one at the bottom of this page:
https://www.etoilewebdesign.com/web-services/

Thanks for the compliments and understanding it’s still in development!

You are welcome.
And do you have any clue why it still isn’t working after installing PHPExcel?
At
$objWorkBook = $objReader->load($Excel_URL); the php script is killed. I didn’t get any errors but I dont know if wordpress is configured to throwing any errors. I’m not very familiar with wordpress so far.
I tried some other methods of the class to load the file, same result.

And it would be a nice improvement if non existing categories and sub categories will be added to the db while importing.

Hi Andre,

You can set
define('WP_DEBUG', true);

to have WordPress show all errors, which might help us get to the bottom of the problem.

Having categories added automatically wouldn’t be a problem, but sub categories each belong to a parent category so I’m not sure I could see that working.

The newest version has a much smaller number of PHPExcel files (~20% of the total). Uploading from a spreadsheet worked for me when I installed from the WordPress repository, so hopefully this fixed the issue for all of you as well!