Andre_Kr

Forum Replies Created

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

  • 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.

    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.

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