[Solved] Drupal 7 Feeds Excel Module Upgrade from 7.x-1.0-beta1 to Version 7.0-2.x
In Drupal 7 we can upgrade a module in many ways but we fail on upgrade feeds excel module. The reason being the newer version of the module is entirely different from the old version folder structure and file naming. We can overcome this situation by uninstalling the older version and installing the new version. Sometimes we cannot uninstall the module due to the module dependency and data lock. We can achieve this manually using the following steps.
STEP 1. Remove/delete library phpExcelReader (Which is not required Feeds Excel 7.x-2.x) .
STEP 2. Upgrade library PHPExcel older version to version 1.8 or greater. Download this from github https://github.com/PHPOffice/PHPExcel/archive/1.8.zip).
STEP 3. Upgrade module phpexcel older version to 3.11. Download this from Drupal module (https://www.drupal.org/project/phpexcel).
STEP 4. Upgrade modules Libraries (https://www.drupal.org/project/libraries) and Feeds (https://www.drupal.org/project/feeds) to latest version.
STEP 5. Replace older folder of feeds excel with feeds excel 7.0-2.x (https://www.drupal.org/node/2678690) by manually copy and replace.
STEP 6. Now we will get some PHP fatal errors, so you should truncate the Drupal cache table manually. If you have cpanel environment go to the phpmyadmin then truncate it.
STEP 7. Re-configure existing feeds importers (siteurl/admin/structure/feeds). Not support older importer configuration in the newer version.
STEP 8. Finally clear the cache.
Happy coding. If you need any further assistance please feel free to get in touch with us