PHPExcel sample deployment problem

Scriptcase 8 Discussion
#1

Hi,

I am using Excel (XSL) importation with PHPExcel sample.
Everything works well at a development environment.

With advanced deployment I can handle temp and document URL:s nicely.
Xls file which I am trying to import to database is also uploaded to right folder to server side.
Then happens nothing.

From error log you can see that PHPExcel is trying to read file from wrong path.
I can’t find any way to fix this issue!

Could somebody help?

PHP Fatal error: Uncaught exception ‘PHPExcel_Reader_Exception’ with message ‘Could not open …/…/…/tmp/sc_47541d35_2test.xls for reading! File does not exist, or it is not readable.’ in /home/postilok/public_html/test/_lib/prod/third/phpexcel/PHPExcel/Shared/OLERead.php:80
Stack trace:
#0 /home/postilok/public_html/test/_lib/prod/third/phpexcel/PHPExcel/Reader/Excel5.php(1164): PHPExcel_Shared_OLERead->read(’…/…/…/tmp/sc…’)

#2

Without having worked with PHPExcel yet, I would say that it sounds like a very basic issue/problem:

The file name mentioned in the error log starts with “sc…”, which indicates that it is not a name that PHPExcel creates, it must somehow have been passed to PHPExcel when you create an object with the class: https://github.com/PHPOffice/PHPExce…Spreadsheet.md

Why don’t you first make a very simple blank or control application where you create an object of PHPExcel with an Excel file name that you just supply and see if you can get that to work.

Once thing to consider as well is that if you upload files using SC’s field type “Document (File Name)”, the path of the folder where uploaded files are stored is stored in this variable:

$_SESSION[‘scriptcase’][’<FILL IN YOUR APP NAME HERE’][‘glo_nm_path_doc’]

(See this post: http://www.scriptcase.net/forum/foru…nt-upload-path)

Could it be as simple as the wrong path to the uploaded file is stored in the database, which can then not be opened by PHPExcel?