Can't import mapper

ChrisLitfin

Hi all,

I can't seem to import a mapper spreadsheet. If I try to ingest it though the webUI, the file just downloads itself again and doesn't go into the importer list. If I try through caUtils, I get the following error:

PHP Fatal error: Uncaught Error: Class 'ZipArchive' not found in /var/www/html/staff/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php:94 Stack trace: #0 /var/www/html/staff/vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php(268): PHPExcel_Reader_Excel2007->canRead('/media/usb/cama...') #1 /var/www/html/staff/vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php(191): PHPExcel_IOFactory::createReaderForFile('/media/usb/cama...') #2 /var/www/html/staff/app/models/ca_data_importers.php(766): PHPExcel_IOFactory::load('/media/usb/cama...') #3 /var/www/html/staff/app/lib/ca/Utils/CLIUtils.php(1231): ca_data_importers::loadImporterFromFile('/media/usb/cama...', Array, Array) #4 /var/www/html/staff/support/bin/caUtils(167): CLIUtils::load_import_mapping(Object(Zend_Console_Getopt)) #5 {main} thrown in /var/www/html/staff/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php on line 94 www@ca:/var/www/html/staff/support$

The mapper is attached.

I am using a fresh install of Providence 1.7.6 on Debian with the latest Apache, php7.0, mySQL. "Check Configuration" in Providence shows all OK.

I have tried apt-get upgrade, but I don't think that what is throwing the error is caused by an apt package. (Didn't change anything after the upgrade attempt.)

I'm SSHing into the server, but have the mapper physically attached on a USB stick.

Yours,

Chris Litfin

ChrisLitfin

Edit: I thought it might have had something to do with the fact that it was running on a crummy old 32-bit desktop that I use for sandboxing, but it does the exact same thing on my slightly-less-crummy 64-bit sandbox as well. As above, I am using a fresh install of Providence 1.7.6 on Debian with the latest Apache, php7.0, mySQL. "Check Configuration" in Providence shows all OK.

seth

Make sure the PHP Zip extension is installed.

ChrisLitfin

Hi Seth,
Is that a new required package? A PECL package? I can’t find any reference to it in the CA documentation.
Yours,
Chris Litfin

seth

It's often installed by default. It's a PHP extension, not PECL. It's a requirement of PHPExcel.

ChrisLitfin

OK, Seems to now be fixed.

I ran apt-get install php7.0-zip and the mapping importer imported successfully.

I did some digging and it seems that php zip is (now?) not included by default in the Debian repo version of php7.0.

I have updated my install script (https://github.com/ChrisLitfin/install_ca) to explicitly install php zip.