Course > Certificate > "Issue certificate to" criteria updation

[Renuka-S]

Hello,

We are facing an issue with getting certificates for the course.
Certificate criteria is 100 % completion + Assessment score above 70%

The "issue certificate to" option is set to "My org users", which seems to be a problem and we wanted to update that to "All".
Which isn't editable in the front end once saved.
We also tried using batch update API to change the "issue certificate to" criteria. Which isn't working.

Could you please help us with how we can update this or any workaround to resolve this?
As the users from other organizations aren't getting certificate.

cc: @paritshivani @coolbung

[Krishnaj20]

@rajeevsathish - Can you share how to correct the certificate issue criteria from backend please?

@vinukumar-vs @reshmi-nair

[komalm]

Hello,

We are facing an issue with getting certificates for the course. Certificate criteria is 100 % completion + Assessment score above 70%

The "issue certificate to" option is set to "My org users", which seems to be a problem and we wanted to update that to "All". Which isn't editable in the front end once saved. We also tried using batch update API to change the "issue certificate to" criteria. Which isn't working.

Could you please help us with how we can update this or any workaround to resolve this? As the users from other organizations aren't getting certificate.

cc: @paritshivani @coolbung

Hello @vinukumar-vs @reshmi-nair

Here is the curl that we used for the update. Please let us know if it is correct.

curl --location --request PATCH '{{host}}/certreg/v1/template/add' \
--header 'Accept: application/json' \
--header 'Accept-Language: en-US,en;q=0.9' \
--header 'Connection: keep-alive' \
--header 'Content-Type: application/json' \
--data-raw '{
    "request": {
        "batch": {
            "courseId": "do_11368256351592448011076",
            "batchId": "01368256840298496013",
            "template": {
                "identifier": "do_1136676765694607361904",
                "criteria": {
                    "user": {
                        "rootOrgId": "0130701891041689600"
                    },
                    "enrollment": {
                        "status": 2
                    },
                    "assessment": {
                        "score": {
                            ">=": 70
                        }
                    }
                },
                "name": "Tekdi Dummy Certificate",
                "issuer": {
                    "name": "{{issuerName}}",
                    "url": "https://org_site.org"
                },
                "previewUrl": "https://nuisstaging.blob.core.windows.net/co",
                "signatoryList": [
                    {
                        "name": "CEO",
                        "image": "data:image/png;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/4gIoSUNDX1BST0",
                        "designation": "CEO",
                        "id": "CEO/CEO"
                    }
                ]
            }
        },
        "oldTemplateId": "do_1136676765694607361904"
    }
}'

cc @Renuka-S @paritshivani @coolbung

[Krishnaj20]

@komalm - In the UI layer changes to cert rules are not enabled to live courses as it will lead to confusion to the learners. Hence you are not able to make these changes.

@reshmi-nair - We've gone thru the Lern microsite but we couldn't find the relevant info to take care of these exceptional scenarios from backend. Appreciate if you can share further details.

@rhwarrier @rajeevsathish @vinukumar-vs

[komalm]

Hello Team,

@Krishnaj20, @rhwarrier, @rajeevsathish, @vinukumar-vs, @reshmi-nair

Now, we are using the above CURL to update that 'Issue certificate to' dropdown value, and it's working (via postman)

As this has been updated we want to issue certificates to existing users who have not received certificates previously.
There has been a way to reissue certificates from the front end for course creators, we used the same to confirm if the above fix is being applied. This was successful.

The reissue certificate, asks for the user Id as a compulsory field. Frontend or via API. Is there a bulk reissue API or any other way where we can reissue certificates to users who haven't received certificates yet?
Currently, we don't know user Ids, we want to reassign to all users who have completed in the past 45 days.

Reissue certificate API

curl --location --request POST '{{host}}/certreg/v1/cert/reissue' \
--header 'Accept: application/json' \
--header 'Accept-Language: en-US,en;q=0.9' \
--header 'Connection: keep-alive' \
--header 'Content-Type: application/json' \
--data-raw '{
    "request": {
        "courseId": "do_11368261608669184011095",
        "batchId": "01368262607047884814",
        "userIds": [
            "106abf62-82fa-4c62-8300-baf3b36ccb4b"
        ],
        "createdBy": "5d757783-a86a-40cd-a814-1b6a16d37cb6"
    }
}'

cc @Renuka-S, @coolbung

[Krishnaj20]

@anandvarada - can you share any scripts you have used in the past to issue bulk certs to users in a batch please?

[komalm]

@anandvarada - Can you please share the update on this.

[anandvarada]

We have used this script couple of years back .. do check and use accordingly @komalm

https://github.com/Sunbird-Ed/sunbird-data-products/pull/167/files#diff-e5beab9b7248b2dbe23f207a971750ea0214a96bd1a252154b2e3944641417e2

Setup:
Login to Spark machine - where you can run this script
vi /home/analytics/ReplayIssueCertificates.scala
Copy the data from https://github.com/Sunbird-Ed/sunbird-data-products/pull/167/files and paste it in ReplayIssueCertificates.scala.

Execution:
cd /mount/data/analytics/spark-2.4.4-bin-hadoop2.7
sudo bin/spark-shell --master local[*] --packages com.datastax.spark:spark-cassandra-connector_2.11:2.5.0 --jars /mount/data/analytics/models-2.0/analytics-framework-2.0.jar --conf spark.cassandra.connection.host=
:load /home/analytics/ReplayIssueCertificates.scala

spark> ReplayIssueCertificates.main(sc, "BatchID", "CourseID", "<env_name>", "<kafka_IP>:9092", false) - for issuing certificates.
spark> ReplayIssueCertificates.main(sc, "BatchID", "CourseID", "<env_name>", "<kafka_IP>:9092", true) - for re-issuing certificates.

Below is the failed topic name:
<env_name>.certificate.events.failed (ex: preprod.certificate.events.failed)

cc: @Krishnaj20

[Krishnaj20]

thanks @anandvarada . @Renuka-S - let us know if this resolves your query?

[parthlawate]

@komalm @Renuka-S is this resolved now ?

[Krishnaj20]

@Renuka-S - since we haven't heard back from you. Marking this thread as answered.

[Nithin-ns24]

@anandvarada i have couple of doughts

1. Replay Issue Certificates.main(sc, "", "", "<env_name>", "<kafka_IP>:9092", false) in this command after sc what parameters we need to pass ?
2. after reissue of certificates, how we need to verify

[anandvarada]

the parameters are "BatchID", "CourseID" .. hope this helps ..

[Krishnaj20]

@reshmi-nair - Pls check if these details are sufficient for you to advise?

[bhargav0702]

@anandvarada
The issue regarding re-issue of certificate for users not generating.
we have executed the steps ( script) , after executing the script logs got generated but no events log got pushed to kafka topic, and users could not able to get certificate.
From backend, to do bulk re-issuing certificates for users the script which is suggested is not working
can u suggest further steps to re-issue certificate for users.

[Krishnaj20]

@rhwarrier @reshmi-nair - can you check this thread and respond pls?

@vinukumar-vs

[rhwarrier]

Tagging @Hari-stackroute

[reshmi-nair]

@bhargav0702 Pls check this thread.
https://github.com/orgs/Sunbird-Lern/discussions/65#discussioncomment-4793622
Similar error occurred, due to infra issues. Pls check the cassandra configuration in respective services

[Renuka-S]

@saiakhil46 @komalm Please share updates as you were looking into this.