Exception when creating documentation set

[ysi]

Hi,

When I want to create a documentation sert (menu 1 and 5), script crash at Generating Tier-1 Forwarding Tables level.

Traceback (most recent call last):
File "_poweropsmain.py", line 566, in
main()
File "_poweropsmain.py", line 563, in main
action()
File "_poweropsmain.py", line 225, in opt_docs
action()
File "_poweropsmain.py", line 295, in doc_set
docs_tier1_forwardingtables.main()
File "/Users/ysimonet/Documents/Scripts/NSX/Python/powerops/NSX-T-PowerOps/lib/powerops_master/nsx-powerops/basic/docs_tier1_forwardingtables.py", line 106, in main
sheet = t1_routing_wkbk.add_sheet(str(i), cell_overwrite_ok=True)
File "/usr/local/lib/python3.8/site-packages/xlwt/Workbook.py", line 368, in add_sheet
raise Exception("invalid worksheet name %r" % sheetname)
Exception: invalid worksheet name '21452d08-f591-416f-bead-112d6c25ad95'

It seems that you use UUID as name sheet with python module "xlwt". UUID seems too long for a sheet name. In Excel itself it's working but with xlwt, name of sheet must not exceeded 32 caracters.
If I replace in docs_tier1_forwardingtables.py line 89 t1_id_list.append(i['id']) by t1_id_list.append(i['display_name']), it seems working.

[EDIT] : On Mac OS with 3.8 python version

[stephen-sauer]

branch:T-OPS

Hi,

When I want to create a documentation sert (menu 1 and 5), script crash at Generating Tier-1 Forwarding Tables level.

Traceback (most recent call last):
File "_poweropsmain.py", line 566, in
main()
File "_poweropsmain.py", line 563, in main
action()
File "_poweropsmain.py", line 225, in opt_docs
action()
File "_poweropsmain.py", line 295, in doc_set
docs_tier1_forwardingtables.main()
File "/Users/ysimonet/Documents/Scripts/NSX/Python/powerops/NSX-T-PowerOps/lib/powerops_master/nsx-powerops/basic/docs_tier1_forwardingtables.py", line 106, in main
sheet = t1_routing_wkbk.add_sheet(str(i), cell_overwrite_ok=True)
File "/usr/local/lib/python3.8/site-packages/xlwt/Workbook.py", line 368, in add_sheet
raise Exception("invalid worksheet name %r" % sheetname)
Exception: invalid worksheet name '21452d08-f591-416f-bead-112d6c25ad95'

It seems that you use UUID as name sheet with python module "xlwt". UUID seems too long for a sheet name. In Excel itself it's working but with xlwt, name of sheet must not exceeded 32 caracters.
If I replace in docs_tier1_forwardingtables.py line 89 t1_id_list.append(i['id']) by t1_id_list.append(i['display_name']), it seems working.

branch:T-OPS