Restore courses from remote Moodles

So, you are saying:
"Database table name where category informations are stored" = 'course_categories".
"Database table foreign key for category id" = 'idnumber'.
That makes sense. But what should be set for:
"Unique database table field that represent category..."

to work since you have 2 moodles you need to be sure that you have a unique category identifier common for that two moodles.
Since id can't be garanted to be the same (since generated by database) two make the category retreieving to work you need a field with this unique value. I suggest to put idnumber.
I can put what you ask as default values for settings since it would be a default case

Hi Celine. I read your comments, and I'm still unclear on what those settings should be. Are you saying you use them because you have non-standard tables in Moodle to store category information? If so, it is unlikely that someone installing this plugin would have the same non-standard tables.
If these settings are intended to override using standard Moodle tables, it would be best if they defaulted to what would be used in a standard Moodle install.
So, I think it would be:
"Database table name where category informations are stored" = 'course_categories".
"Database table foreign key for category id" = 'id'.
""Unique database table field that represent category..." = ?? (I don't know what this would be)

Mike,
last thing the database related setting fields will in fact enabling you (if activated) to restore a given course in its original category found in the local system and corresponding to the original one

David,
If I understand you well, I'll have to put tool_my_external_backup_restore_courses_admin in the block plugin distribution?

Hello, sorry to be late but I was in vacation.
Mike, the settings fields concerning database are the most generic fields I found to model unique indentification of category between 2 Moodle.
This is our example of integration
In our architecture where have 2 Moodle.
In each Moodle , course categories are field thanks to a home made ETL that create/update and delete all course categories
So for a given category course_categories ids will be different in each Moodle, so we need an other unique field common in the 2 Moodles
We created an additional table course_category_types
this have following fields :
catgoryid (foreign key), code (unique code in our information system)
So in block settings :
block_my_external_backup_restore_courses | categorytable is course_category_types
block_my_external_backup_restore_courses | categorytable_foreignkey is cateogryid
block_my_external_backup_restore_courses | categorytable_categoryfield is code
But you can imagine other architectures such like
block_my_external_backup_restore_courses | categorytable with course_categories
block_my_external_backup_restore_courses | categorytable_foreignkey id
block_my_external_backup_restore_courses | categorytable_categoryfield with idnumber
I'm gonna try to explain that in readme file

Hi. I have installed the block on a test site, and I am reviewing the settings screen. There are settings for "Database table name where category informations are stored", "Database table foreign key for category id" and "Unique database table field that represent category...". I'm unclear on what these fields would be. Can you provide some information on what I should be putting in these fields?

Hi. I have begun the review of your plugin for the Plugins Guardians. Please refer to the prechecker results above and correct issues that you can. One thing to notes is that none of the code files contain the necessary boilerplate information (https://docs.moodle.org/dev/Plugin_contribution_checklist#Boilerplate). It would be great if you could address that. I will take a look at the rest shortly. Thanks.

Prechecker results: 4831 errors/183 warnings
https://integration.moodle.org/job/Precheck%20remote%20branch/28139/artifact/work/smurf.html