pole-emploi fetcher convert fails
convert fails with
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dbnomics_fetcher_toolbox/resources.py", line 214, in _process_resource_wrapper
process_resource(resource)
File "convert.py", line 175, in process_resource
build_dataset_formation_teleform(
File "convert.py", line 531, in build_dataset_formation_teleform
book = xlrd.open_workbook(str(source_file))
File "/usr/local/lib/python3.8/site-packages/xlrd/__init__.py", line 170, in open_workbook
raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported
2021-07-25 01:07:50,035 [12] INFO dbnomics_fetcher_toolbox.resources [resource: retours]: Processing resource 4/4
2021-07-25 01:07:50,086 [12] INFO dbnomics_fetcher_toolbox.resources [resource: retours]: Resource processed in 0.05 seconds
2021-07-25 01:07:50,087 [12] CRITICAL root: Traceback (most recent call last):
File "convert.py", line 636, in <module>
asyncio.run(main())
File "/usr/local/lib/python3.8/asyncio/runners.py", line 44, in run
return loop.run_until_complete(main)
File "/usr/local/lib/python3.8/asyncio/base_events.py", line 616, in run_until_complete
return future.result()
File "convert.py", line 119, in main
Category(
File "pydantic/main.py", line 404, in pydantic.main.BaseModel.__init__
File "pydantic/main.py", line 1040, in pydantic.main.validate_model
File "pydantic/fields.py", line 734, in pydantic.fields.ModelField.validate
File "pydantic/fields.py", line 767, in pydantic.fields.ModelField._validate_sequence_like
File "pydantic/fields.py", line 899, in pydantic.fields.ModelField._validate_singleton
File "pydantic/fields.py", line 723, in pydantic.fields.ModelField.validate
File "pydantic/fields.py", line 899, in pydantic.fields.ModelField._validate_singleton
File "pydantic/fields.py", line 699, in pydantic.fields.ModelField.validate
pydantic.errors.ConfigError: field "_children_ForwardRef('Category')" not yet prepared so type is still a ForwardRef, you might need to call Category.update_forward_refs().
-
replace xlrd by openpyxl for *.xlsx files -
refactor offres
parsing. File changed by the producer -
waiting for #1044 (closed) to be fixed
Edited by Christophe Benz