Reliable Country Selection

[p-a-s-c-a-l]

Coming back to country selection, there are two usability issues:

The first, more serious one is related to the recalculation of HC-LE input layers: The city selection box must contain cities only, that are guaranteed to be available (recalculated) for screening. So we have to periodically re-generate the cities taxonomy as @therter described here. I wonder, if there is a possibility to a) automate or b) simplify this process? If we could unpublish or hide some taxonomy terms, then it would still be a manual task to update the list of cities as new cities are becoming available, but it's still more efficient than doing the complete import process again and again.

The second issue is not that critical (showstopper) but it could still become frustrating for users: There are many countries without supported cities, so they shouldn't be shown at all in the countries selection box for Automated Screening: Urban Infrastructure studies.

Originally posted by @p-a-s-c-a-l in #141 (comment)

[therter]

The first, more serious one is related to the recalculation of HC-LE input layers: The city selection box must contain cities only, that are guaranteed to be available (recalculated) for screening. So we have to periodically re-generate the cities taxonomy as @therter described here. I wonder, if there is a possibility to a) automate or b) simplify this process? If we could unpublish or hide some taxonomy terms, then it would still be a manual task to update the list of cities as new cities are becoming available, but it's still more efficient than doing the complete import process again and again.

This can be solved by a script that I have created. See here.
But I have seen that the structure of the city shape file that is updated by @negroscuro, when new cities become available, has changed. So I must adjust the function that publish/unpublish the cities.

But this approach does not work for the countries. Because the countries will still be shown in the country combo box, when I unpublish them via the db.

[p-a-s-c-a-l]

This can be solved by a script that I have created. See here.

Yes, but currently it's not automated. ATM city data is being regenerated, so the list of cities has to be updated regularly.

[p-a-s-c-a-l]

Any updates?
Perhaps this can be combined with synchronisation? @patrickkaleta

How is synchronisation triggered? Manually or by a cron-job? In any case we could include @therter's republish.sh in the process so that the cities taxonomy is updated in DEV right before the synchronisation starts and then the updated taxonomies are synchronised to PROD. WDYT?

BTW, the scripts should be made available in this GitHub repo under /scripts.

[therter]

BTW, the scripts should be made available in this GitHub repo under /scripts.

I have added the script to the repo

[patrickkaleta]

@therter wrote:
But this approach (hiding empty countries by unpublishing them) does not work for the countries. Because the countries will still be shown in the country combo box, when I unpublish them via the db.

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

Tested it locally and it even worked fine together with the Business Rule function that handles the automated selection of cities/regions for the selected country.

The necessary View is already available in the CSIS, so if @therter can provide such a publish/unpublish script for countries, we can use this approach to get a more reliable country selection.

[patrickkaleta]

How is synchronisation triggered? Manually or by a cron-job? In any case we could include @therter's republish.sh in the process so that the cities taxonomy is updated in DEV right before the synchronisation starts and then the updated taxonomies are synchronised to PROD. WDYT?

For now, it's set to be triggered manually by running the pull_content.sh script in the target docker environment, which runs the individual drush migrate commands in the necessary order.

If configurations have changed (field & content type settings, Views, etc.), it's necessary to first synchronize the configuration, for which in turn it might be first necessary to run a composer update (in case new modules are used), so ideally during this whole process the site is put into "maintenance mode". All that considered I'm not a big fan of having a cron-job take care of this process.
However, it would be possible to only synchronize certain content types (like countries and cities/regions) by running the individual drush migrate commands for those taxonomies. @therter's republish script could be run in DEV before this "slimmed down" version of the content synchronization more frequently than the usual content synchronization.

BTW, the scripts should be made available in this GitHub repo under /scripts.

I will put the mentioned script for the content synchronization in there as well.

[therter]

The necessary View is already available in the CSIS, so if @therter can provide such a publish/unpublish script for countries, we can use this approach to get a more reliable country selection.

I have added the code for publishing/unpublishing countries to the function that publish/unpublish the cities. See here

[therter]

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

@patrickkaleta I have unpublished the country 'Andorra', but it is still shown in the combobox.

[therter]

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

@patrickkaleta I have unpublished the country 'Andorra', but it is still shown in the combobox.

[therter]

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

@patrickkaleta I have unpublished the country 'Andorra', but it is still shown in the combobox.

[therter]

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

@patrickkaleta I have unpublished the country 'Andorra', but it is still shown in the combobox.

[patrickkaleta]

I believe I found a possible solution for that problem. Instead of showing the overall taxonomy list for countries in the Study country field, I can place a View inbetween, which filters out unpublished countries. The result would be that only published Countries (for which available Cities exist) would remain.

@patrickkaleta I have unpublished the country 'Andorra', but it is still shown in the combobox.

@therter Sorry, for the misunderstanding. I prepared the necessary View but didn't switch to it until getting feedback. Now this new mechanism is active and in the Country selection box I can see roughly 30 countries.

In the "Maintenance" overviews I've added a list of the Countries, so it's possible to view & change the status of the published/unpublished countries manually.

[p-a-s-c-a-l]

Thanks! So this can be considered as done.