do linked resources work via CSW?

[gubuntu]

using QGIS MetaSearch, test that EMC records that have valid OGC resource links, return those links in a valid way in the response such that you can load them directly into QGIS.

Use existing records in the EMC that you've identified to have these links else create your own testing records with valid links

[seabilwe]

@Mohab25 @tharanathkartoza

I am trying to create testing records to test if the CWS is working, but I keep getting when trying to save a record created

I asked @ThiashaV to create one, she is also getting the same error

But also @gubuntu @Mohab25 @tharanathkartoza, when testing csw connections from existing records, I get this:

[gubuntu]

@seabilwe please rather send a screencast so we can see what you were trying to do.

What is CWS? (attention to detail!)

and what base url are you using to test csw?

Are you sure you understand the OP?

[seabilwe]

@gubuntu

url1 used: https://csw-testing.emc.kartoza.com/csw

url2 used: https://csw-testing.emc.kartoza.com/

[gubuntu]

well you can't really test this till #175 is fixed. When it is fixed, you should be able to find a record like https://testing.emc.kartoza.com/dataset/7-seasonal-mean-near-surface-2m-temperature-degc-change-from-the-10-percentile-projected-for-2036-20 which has two linked resources, one of which is a WMS (which actually works). You should be able to open the WMS layer directly in QGIS from Metasearch.

[seabilwe]

@Mohab25 Was able to view the 95 public records using link: https://csw-testing.emc.kartoza.com/csw

I also notice that the records remain at 95 after adding login credentials. The records should be more after logging in, I assume.

[gubuntu]

Your response should be in #175. That's great but this issue is about linked resources (which will enable the 'add data' button in metasearch) - please test that as per https://github.com/kartoza/ckanext-dalrrd-emc-dcpr/issues/344#issuecomment-1315505801

[gubuntu]

This is not working. AS you can see, this record has a valid WMS link:

but is it not being returned as part of the csw response (it should be in the Links section):

I'm sure the resource links field(s) just need to be mapped properly to pycsw in the materialised view?

[voogt]

• CSW was not returning data as there was no rows in materialised view

• Steps to fix

1. Tried running poetry run ckan dalrrd-emc-dcpr pycsw create-materialized-view (produced error)
2. Dropped table emc_pycsw_view in postgres database
3. Recreated materialised view by running sql script found at /templates/pycsw/pycsw_view.sql
4. Refresh materialised view by running REFRESH MATERIALIZED VIEW CONCURRENTLY emc_pycsw_view;