However, there is a lot of documentation there, and I am not sure how easy it is for a beginner to know where to start.
As you try to understand the documentation, your comments on how it could be improved would be appreciated.
But can someone tell me what the XMLDB editor is and how I can make use of it.
I saw it there when I was making a database and I was sure it could e useful....but I am at a loss as to how to leverage it.
Sorry for the "dummies" question. But a real dummies answer that also advances into an advanced answer would really be appreciated.
The XMLDB editor is a tool to produce as easily as it is possible the messy XML required by the new installation procedure. Considering writing databse scheme with XML is a real pleasure (!!) spending twice to four time the time you needed forextracting your SQL model. So here is the XMLDB Editor that helps you to extract from your DB the ugly and ultra-verbose, largely redundant XML code.
The best way to procede is to make your entire model in MySQL, arrange it, tune it and fix it, then using the XMLDB Editor to make the XML by creating the install.xml, then importing one by one the tables. Care that the first table of the module is imported when creating the XML at first but with a bug that only recognizes the "id" field, forgetting the others. You may import a second table, then delete the first one, and get it back to read all fields. XMLDB Editor allows you to rearrange entities in the order you would like they appear in the XML file.
You should closely check the XML as there are some type miscoding (such as integer turning into text fields, forgotten DEFAULTS, say, some little inconsistencies, but the major part of the work is done). Don't forget writing XML code back when finished arranging fields.
I am developing an Activity module named rubrics. But I am unable to modify the basic database table of the module. I want to add one filed named 'rowno' into the mdl_rubrics table. So using the XMLDB editor I edited the table and add the field. Then followed the instructions from different tutorial to update the change. And the notification I am getting is rubrics tables have been set up correctly. But when I am viewing the database using the command select * from mdl_rubrics; new field is not showing there. Plz help me how to add this new field.
May be this is a very basic question, but I am really unable to figure out the purpose of XMLDB editor in Moodle. To be specific I need answers to the following questions
- Can we use it to add a new field of a existing table?
- If yes how?
- Why not use PHPMyAdmin?
Waiting for some replies,
The XMLDB editor is designed for developers developing new plugins or core functionality. If you read something like the NEWMODULE tutorial, or Development:Installing_and_upgrading_plugin_database_tables it should become clear.
If it is not clear, don't use it
.... Now it is clear to me, so started using it. I was having some problem with the version number.
Thanks for your reply Tim