Problem/Motivation

In #3567171: Update XLS file the downloaded Excel file was updated to a new one from Bpost. I never saw the old one, but in the migration yaml files you can see this:
worksheet: "Plaatsnamen op postcode"
The current Excel file (https://www.bpost.be/sites/default/files/zipcodes/zipcodes_num_nl_2025.xls) does not have a worksheet named Plaatsnamen op postcode but does have one named Plaatsnamen per postcode so this might have changed with the new file.

This causes this issue when importing:

Got 'PhpOffice\PhpSpreadsheet\Exception', message 'You tried to set a sheet active by the out of bounds index: 0. The actual number of sheets is 0.'.

And nothing gets imported.

We need to update the worksheet name in the migration files to Plaatsnamen op postcode

Steps to reproduce

Install the module or run the migration with drush migrate-import belgian_postal_code_main_municipalities

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

Comments

rgeerolf created an issue. See original summary.

rgeerolf’s picture

Status: Active » Needs review
rgeerolf’s picture

Assigned: rgeerolf » Unassigned
bramdriesen’s picture

Status: Needs review » Reviewed & tested by the community

Thanks! Mr looks good.

bramdriesen’s picture

Status: Reviewed & tested by the community » Fixed

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.