Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-3618

Error on Excel Ex-/Import

    XMLWordPrintable

Details

    • Medium
    • investigate a submitted report. But there is no problem in Translate5. Look like user "destroyed" Excel by deleting the "meta-sheet"

    Description

      Aleks note in Slack

      can you check this problem:

      ERROR in core: E9999 - Workbook does not contain sheet:meta data
      Exception: PhpOffice\PhpSpreadsheet\Exception
      Level: ERROR
      Errorcode: E9999
      Message: Workbook does not contain sheet:meta data
      Domain: core
      Version: 6.8.1
      File (Line): /var/www/instances-local/instance-1031/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php (822)
      User: xxxx
      Request: POST https://xxxx/editor/task/22756/excelreimport
      Trace:

      #0 /var/www/instances-local/instance-1031/application/modules/editor/Models/Excel/ExImport.php(287): PhpOffice\PhpSpreadsheet\Spreadsheet->setActiveSheetIndexByName()
      #1 /var/www/instances-local/instance-1031/application/modules/editor/Models/Excel/ExImport.php(189): editor_Models_Excel_ExImport->getSheetMeta()
      #2 /var/www/instances-local/instance-1031/application/modules/editor/Models/Import/Excel.php(90): editor_Models_Excel_ExImport::loadFromExcel()
      #3 [internal function]: editor_Models_Import_Excel->__construct()
      #4 /var/www/instances-local/instance-1031/library/ZfExtended/Factory.php(56): ReflectionClass->newInstanceArgs()
      #5 /var/www/instances-local/instance-1031/application/modules/editor/Controllers/TaskController.php(840): ZfExtended_Factory::get()
      #6 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(516): editor_TaskController->excelreimportAction()
      #7 /var/www/instances-local/instance-1031/library/ZfExtended/Controllers/AAARestController.php(349): Zend_Controller_Action->dispatch()
      #8 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
      #9 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
      #10 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
      #11 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
      #12 /var/www/instances-local/instance-1031/library/ZfExtended/Application.php(74): Zend_Application->run()
      #13 /var/www/instances-local/instance-1031/library/ZfExtended/BaseIndex.php(174): ZfExtended_Application->run()
      #14 /var/www/instances-local/instance-1031/public/index.php(35): ZfExtended_BaseIndex->startApplication()
      #15

      Unknown macro: {main}

      Request:

      Array
      (
      [format] => jsontext
      [autoStartImport] => 0
      [CsrfToken] => xxx
      )

      I traced the above error. Looks like user deleted the "meta-sheet" this sheet is important, cause it contains Task-Guid etc.

      I also tested to.. export the task as excel and reimport it again. Works fine. I made that with the task in the customer installation from above.
      So user "destroyed" the excel, and my suggestion is, he deleted the "meta-sheet". Should be able to repair it by simply export it again as excel and transfer the meta-sheet from this export to the edited Excel.

      Attachments

        Activity

          People

            Stephan Stephan Bergmann
            Stephan Stephan Bergmann
            Aleksandar Mitrev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: