This subject includes two issues because they are perceived by this novice user to be related. I have poured over various support instructions on best practices for loading the subject items into the Libraries module via /sites/all/modules/libraries without success. I have closely followed renaming instructions for the 1.7.6 PHPExcel Library. Nothing I do brings me anywhere near a successful conclusion.

My objective is to teach myself how to convert XLS (Excel) files to csv format and import the data into nodes and or taxonomies. I may not be using the correct verbage here, but I have hopefully presented this with some clarity.

For reference I have attached a screenshot of the error messages I get when attempting to enable the "Feeds Excel Parser" and "Feeds XLS" modules. Any assistance ordirection will be greatly appreciated.

CommentFileSizeAuthor
Feeds XLS-Excel Parser.jpg305.32 KBstugacz

Comments

killtheliterate’s picture

killtheliterate commented

@stugacz - it is rather confusing as to how the library for each respective module needs to be installed. I'm using Feeds XLS, as Feeds Excel seems to be extremely broken. I have a mostly functioning installation of this module, and have installed the appropriate library.

Here is a screenshot of my exact directory structure ---> http://cl.ly/043T0l2p0B0f1S1p2F0H

Both modules require different flavors of the PHPExcel library.

Also, clear cache a few times.

stugacz’s picture

stugacz commented
Title: Issue With Both Feeds XLS and Feeds Excel Parser » Issue With Both Feeds XLS and Feeds Excel Parser "Fixed"

@killtheliterate- You are "The Bomb"!

presleyd’s picture

presleyd commented
Title: Issue With Both Feeds XLS and Feeds Excel Parser "Fixed" » Where to install PHPExcel library
Status: Active » Closed (fixed)

That is not how you close a ticket...

CosticaPuntaru’s picture

CosticaPuntaru commented

please some1 write the paths, the link has expierd

rooby’s picture

rooby commented
Title: Where to install PHPExcel library » Write installation instructions including where to put phpexcel library
Category: Support request » Task
Issue summary: View changes
Status: Closed (fixed) » Active

There is still not good documentation for this.

sdrycroft’s picture

sdrycroft commented
Status: Active » Closed (won't fix)
sdrycroft’s picture

sdrycroft commented

Note, installation instructions for the PHPExcel library are provided on the module page. They are deliberately terse because the installation is that simple - what more would you like?

BartNijs’s picture

BartNijs commented

I had trouble with this as wel. How I did it eventually:
In the downloaded zip file, there is a folder called Classes. This is the folder you place into the libraries folder and rename to PHPExcel.
So don't simply extract the file into the PHPExcel folder. The file PHPExcel.php should be directly in the libraries/PHPExcel folder along with another folder called PHPExcel.

sdrycroft’s picture

sdrycroft commented

That's actually not the case Bartelli, the _feeds_xls_load_phpexcel() function will look for the IOFactory.php file under the classes folder, or where you place it. The following will work:

Extract PHPExcel Zip into a folder named PHPExcel anywhere the Libraries module can find it e.g.

sites/all/libraries/PHPExcel/Classes/PHPExcel/IOFactory.php
sites/example.com/libraries/PHPExcel/Classes/PHPExcel/IOFactory.php

Extract the PHPExcel Zip into a folder named PHPExcel within the feeds_xls module folder e.g.

sites/all/modules/contrib/feeds_xls/PHPExcel/Classes/PHPExcel/IOFactory.php

Extract the PHPExcel Zip, and rename the Classes folder to PHPExcel anywhere the Libraries module can find it e.g.

sites/all/libraries/PHPExcel/PHPExcel/IOFactory.php
sites/example.com/libraries/PHPExcel/PHPExcel/IOFactory.php

Extract the PHPExcel Zip and rename the Classes folder to PHPExcel in the feeds_xls module folder e.g.

sites/all/modules/contrib/feeds_xls/PHPExcel/PHPExcel/IOFactory.php

texas-bronius’s picture

texas-bronius commented

Hi Bartelli-
Welcome to the world of user contributed and maintained third party modules! I appreciate seeing this thread here, because I, too, was confused about where to put the extracted PHPExcel library. I think what's not clear is that the Drupal Libraries API (https://www.drupal.org/project/libraries) module may be required for PHPExcel to be found in the sites/all/libraries folder. Without the libraries module (which I somehow thought shipped in D7 core but I guess doesn't?), you can place PHPExcel directly in the feeds_xls folder or even symlink it from there to wherever you do end up putting it.

Ex. For my installation I currently have PHPExcel extracted as sites/all/libraries/PHPExcel and have sites/all/modules/contrib/feeds_xls/PHPExcel -> ../../../libraries/PHPExcel.

I hope this helps. If this is the case, I'd request of the module maintainer to make Libraries API a module dependency or provide an explicit explanation in your installation notes. (Speaking of which, somewhere between 6-x and 7-x, we seem to be missing README.txt as shown in stugacz' support request screenshot).

-Bronius