Yes, I have installed upload course categories plugin and that worked for me for bulk categories. I have created csv file comprising category name, cat id(used to mapped external db enrollments) and description. Each enrollment is now mapped with respected categories.
Now I have new task i.e. to create transcript (not certificate) for student. Student should be able to download transcript and transcript information is again not present in moodle db. The information is in external db.
I have thoughts that I can do this by following steps
1. I need to first bring required data into moodle db through a php script (creating a transcript table or reporting table or add new fields into certificate table).
2. I need to customize the certificate plugin. The problem is that current certificate format is very much different from what I need. I need a dynamic length A4 transcript. length will vary according to courses and their outcome information.
Any Idea and take on this to correct my opinion?
Thanks for help.