Issues after installation of new GNPy SW on VM during the pytest of gnpy: Wrong release for xlrd and issue with import of Element Tree

[filip-nikolic]

I performed installation of new GNPy on VM and I want to share my findings with you. I hope that it will be useful :)

Installation of GNPy was done on new Linux VM. OS is ubuntu 22.04.

As a precondition I did installation of anaconda3 python distribution. After installation this is the status:

(base) user@GNPy:~$ pip show xlrd Name: xlrd Version: 1.2.0 Summary: Library for developers to extract data from Microsoft Excel (tm) spreadsheet files Home-page: http://www.python-excel.org/ Author: John Machin Author-email: sjmachin@lexicon.net License: BSD Location: /home/infinera/anaconda3/lib/python3.11/site-packages Requires: Required-by: gnpy

user@GNPy:~$ pip show pandas Name: pandas Version: 2.1.4 Summary: Powerful data structures for data analysis, time series, and statistics Home-page: https://pandas.pydata.org Author: Author-email: The Pandas Development Team pandas-dev@python.org License: BSD 3-Clause License

user@GNPy:~$ python -V Python 3.11.7

And installation of anaconda3 distribution.

Installation of GNPy is run according to: pip install --editable .

After installation I run test of gnpy.

(base) user@GNPy:~$ python -c 'import gnpy' (base) user@GNPy:~$ pytest

The result of test was:

oopt-gnpy/tests/test_amplifier.py ................................................................................................................. [ 21%] oopt-gnpy/tests/test_automaticmodefeature.py . [ 22%] oopt-gnpy/tests/test_disjunction.py ............................ [ 27%] oopt-gnpy/tests/test_equalization.py ................................................................................................................................ [ 52%] oopt-gnpy/tests/test_gain_mode.py ......... [ 54%] oopt-gnpy/tests/test_info.py . [ 54%] oopt-gnpy/tests/test_invocation.py ................. [ 57%] oopt-gnpy/tests/test_logger.py ...FF...........FFFFFFFFFF [ 62%] oopt-gnpy/tests/test_network_functions.py .............................. [ 68%] oopt-gnpy/tests/test_parameters.py .. [ 69%] oopt-gnpy/tests/test_parser.py F..F.................................. [ 76%] oopt-gnpy/tests/test_propagation.py ......................... [ 81%] oopt-gnpy/tests/test_roadm_restrictions.py .............................. [ 87%] oopt-gnpy/tests/test_science_utils.py ..... [ 88%] oopt-gnpy/tests/test_spectrum_assignment.py ............................................................. [100%]

====================================================================================== FAILURES =======================================================================================

_ test_wrong_xls_service[wrong_service.xlsx-testTopology.xls-Service error: Request Id: 0 - could not find tsp : 'Voyager' with mode: 'Mode 10' in eqpt library \nComputation stopped.]

Please check the logs for complete output of errors in attachment.

Logs_after_installation.txt

By help of Esther Lerouzic we successfully manage to fix the issues in two steps.

1. Wrong release for xlrd, we coudn't use excel input.

This issue was fixed by adding of lines in convert.py and service_sheet.py (just before "from xlrd import open_workbook.......")

Lines are:

2. After this only issue was warning:

======================================================================================= warnings summary ======================================================================================== anaconda3/lib/python3.11/site-packages/xlrd/xlsx.py:39 /home/user/anaconda3/lib/python3.11/site-packages/xlrd/xlsx.py:39: DeprecationWarning: defusedxml.cElementTree is deprecated, import from defusedxml.ElementTree instead. try: import defusedxml.cElementTree as ET

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ================================================================================ 514 passed, 1 warning in 50.92s ================================================================================

We solved this by editing of xlsx.py file in folder /home/user/anaconda3/lib/python3.11/site-packages/xlrd/

In file xlsx.py we replaced cElementTree with ElementTree

Before change:

After change:

After this i run the pytest again and it was successful.