search

alkem-io / populator

Populate the entities in an ecoverse from a defined Google Sheet format
European Union Public License 1.2
0 stars 0 forks source link

BUG: Row spaces from excel sheets are not considered, when data is populated #75

Open Comoque1 opened 2 years ago

Comoque1 commented 2 years ago

Describe the bug Row spaces from excel sheets are not considered, when data is populated.

To Reproduce Steps to reproduce the behavior:

  1. Populate the data using alkemio-sdgs.ods file
  2. Navigate to http://localhost:3000/un_sdgs/challenges/energy
  3. There must be a row space as in screenshot: image.png
  4. There is no such space image.png

Expected behavior Row spaces from excel sheets are considered, when data is populated.

techsmyth commented 2 years ago

Have had a look at this, problem is in the data loading by xlsx.

Raw text in ods file: image.png

as loaded in by xlsx: image.png

note extra spaces are stripped out.

Tried setting xlsx parsing options but they had no effect:

image.png

Note: above image is directly after loading, and before converting to json to populate the models.

Thoughts?