search

NERC-CEH / fit-count-app

Fit Count App & Website
Apache License 2.0
0 stars 0 forks source link

FIT Count website - new download function #187

Open kitenetter opened 7 months ago

kitenetter commented 7 months ago

Once we have dealt with #186 we would like to enable users who have the country coordinator role on the FIT Count website to be able to download the names and email addresses of all registered users who have linked their accounts to the country that is participating.

I'm guessing this can be done via a Drupal view?

Can we add a column that shows how many FIT Counts each user has contributed (including those users who have not contributed any)?

(Do we have a separate repository for the FIT Count website? I couldn't find one.)

andrewvanbreda commented 7 months ago

Hi @kitenetter This needs a SQL report grid which pulls data from the Warehouse. The Drupal database does not know anything about the number of FIT counts people have submitted.

This can be done on existing budget I think.

I don't think there is a repository for the FIT Count Website (as actually there isn't much on it). If in doubt I would put FIT Count/PoMS issues in here https://github.com/biologicalrecordscentre/poms/issues

I wouldn't worry about reopening a new issue for this, as long as it is in Github I don't think it matters too much.

kitenetter commented 7 months ago

@andrewvanbreda does that mean that the new 'user link to country' that we have specified in #186 will need to be copied into the warehouse as well as being part of the Drupal registration process? I'm a bit hazy on the relationship between what gets stored in Drupal and what gets taken into the warehouse.

The other possible complication is that we do want to be able to download users who have registered but have not submitted a count - are their details stored in the warehouse?

The download needs to be filtered to the country for the coordinator who is downloading, and to include:

Plus the following would be nice to include if possible:

Note to myself: The above assumes that there is a one-to-one relationship between country chosen by the user and a country coordinator, i.e. there is only one coordinator per country. That seems to be the case at the moment, but if we were to be in a situation where there was more than one project per country we could adapt the list of countries offered, e.g. so that the user would choose "country name - north" or "country name - south" etc.

andrewvanbreda commented 7 months ago

Hi @kitenetter Yes see note I just added to other issue, that country needs to end up in the Warehouse. Users who do not submit counts are in the Warehouse also. We can include the above fields. However note, because of the interaction between multiple websites, sometimes (often) the username in the report may not match the chosen one for Fit Count. For instance if they have multiple website accounts, but there is only one user account on the warehouse, that username may not represent what is on the website if they have different usernames for the sites.

kitenetter commented 7 months ago

Actually I don't think we do need to output the user name (and for many app users it is the email address that gets stored as the username anyway).

CCarvell commented 4 months ago

@kitenetter and @andrewvanbreda Hi! Has this been progressed since December? We are onboarding a couple of new countries, as well as getting Data Sharing Agreements signed to enable this personal user data to be shared with country co-ordinators, so it would be good to know when this function might be available. Ireland are also particularly keen for another download of user data asap.

andrewvanbreda commented 4 months ago

Hi @CCarvell @kitenetter @kazlauskis

Essentially from my point of view as I have not started this issue yet as it is to be done after https://github.com/NERC-CEH/fit-count-app/issues/186, however that issue has not had its functionality completely nailed down yet. Karolis still had a question and I think his side of things hadn't been agreed yet.

At the moment the threads are very long to re-read to catch up on, I would almost be tempted to suggest a video call to confirm what is to be done and timeframe.