I've been searching for the answer to this question and, if it's been answered, I haven't been able to figure out how to do it.
I want to change one of the database templates so it displays the information horizontally.
It's a weather database and I want the students to be able to analyze the data over several days and that's almost impossible when the information is displayed vertically.
For simplicity's sake, let say the information the students are collecting is the date, the temperature and the barometric pressure. How can I see that information in a horizontal list?
Dean Mattson への返信
Re: How can I list database information horizontally instead of vertically?
- David Bogner の投稿
turn off the editor and type following html-source in top section:
<table style=" padding:5px; border-style: none; background-image: none; float: none; text-align: left; vertical-align: top;" border="0" frame="void" rules="none" width="100%">
<tr>
repeated entry type following:
<td>field1</td>
<td style="border-left-width:3px; border-color:black;border-left-style:solid;border-color:red;">field2</td>
in the footer section type following:
</tr>
</table>
<table style=" padding:5px; border-style: none; background-image: none; float: none; text-align: left; vertical-align: top;" border="0" frame="void" rules="none" width="100%">
<tr>
repeated entry type following:
<td>field1</td>
<td style="border-left-width:3px; border-color:black;border-left-style:solid;border-color:red;">field2</td>
in the footer section type following:
</tr>
</table>
David Bogner への返信
Re: How can I list database information horizontally instead of vertically?
- Dean Mattson の投稿
Thanks for the help. I was able to do what I wanted because of your expertise.
For anyone as inexperienced as I as and want to use the above as a model, I did have to add:
</tr>
in the repeated entry section to get it to work right.
Have some reading and experimenting, I put this in the top section:
<table style=" padding:5px; border-style: none; background-image: none; float: none; text-align: left; vertical-align: top;" border="0" frame="void" rules="none" width="100%">
<tr><TH colspan="1">field1
<TH colspan="1">field2
<tr>
This gave me some column headers. I'm not sure if that's the right way to do it, but it seems to be working!
Thanks again.
For anyone as inexperienced as I as and want to use the above as a model, I did have to add:
</tr>
in the repeated entry section to get it to work right.
Have some reading and experimenting, I put this in the top section:
<table style=" padding:5px; border-style: none; background-image: none; float: none; text-align: left; vertical-align: top;" border="0" frame="void" rules="none" width="100%">
<tr><TH colspan="1">field1
<TH colspan="1">field2
<tr>
This gave me some column headers. I'm not sure if that's the right way to do it, but it seems to be working!
Thanks again.
David Bogner への返信
Re: How can I list database information horizontally instead of vertically?
- Eva Lacy の投稿
Eva Lacy への返信
Re: How can I list database information horizontally instead of vertically?
- Liz Cross の投稿
In the template for List View create a table for the headings and a table for the data (see attached). The only additional thing I did was to go into the HTML code and change the percentages for the column widths so that coresponding columns were the same widths in the headings table and the data table. I have attached a screenshot and also an example database for you to try out in moodle - hope this helps.
Liz Cross への返信
Re: How can I list database information horizontally instead of vertically?
- dan roggenkamp の投稿
And that works just fine, but here's one more question. How does the Moodle site, in their horizontally displayed database list views, get the name field to link to what I'm assuming is the ##more## link in the default template? I'm sure it's probably something very simple, and if past experience is any indicator, I will probably have found the answer before I get a response... but that trick only works if I ask the question!
dan roggenkamp への返信
Re: How can I list database information horizontally instead of vertically?
- dan roggenkamp の投稿
Yes, I should have RTFM first. The answer is clearly documented at http://docs.moodle.org/en/Database_templates#List_template which states:
-
##moreurl##creates just the URL for the above link, useful for creating your own links. You can click on the link icon and type##moreurl##into URL field or in source view type<a href="##moreurl##">fieldname</a>.
David Bogner への返信
Listing database information horizontally instead of vertically?
- Peter Evans の投稿
After you have created the fields in the database click
> TEMPLATES
> LIST TEMPLATES
> and enter the following into the HEADER in HTML mode
<table style=" padding:5px; background-image: none; float: none; text-align: left; vertical-align: top; border-collapse:collapse" border="2" frame="void" rules="none" width="100%" bordercolorlight="#000000" bordercolordark="#000000" cellpadding="5">
<tr>
<TH colspan="1">Date
<TH colspan="1">Time (start-end)
<TH colspan="1">Contact (Name & extension)
<TH colspan="1">Purpose
<TH colspan="1">Edit
</tr>
> enter the following into the REPEATED ENTRY in HTML mode
<tr>
<td>
Date
</td>
<td>
Time (start-end)
</td>
<td>
Contact (Name & extension)
</td>
<td>
Purpose
</td>
<td>
##edit## ##more## ##delete## ##approve##
</td>
</tr>
Enter the following into the Footer in HTML mode
</table>
> click SAVE TEMPLATES
> click VIEW LIST
If all is well in the universe you should now see your database listed with each entry in a single row.
A screen image is attached and you can see the functioning database at http://www.baker-evans.com/community/mod/data/view.php?d=5
Unfortunately if you edit the template a filter in Moodle will validate the code and muck it up but if you keep the code in a external document you can just paste it back in and all will be well.
Does anyone know how or where to turn this off.
Peter Evans
Peter Evans への返信
Re: Listing database content horizontally instead of vertically
- Robert Allerstorfer の投稿
Peter Evans:
"Unfortunately if you edit the template a filter in Moodle will validate the code and muck it up but if you keep the code in a external document you can just paste it back in and all will be well. Does anyone know how or where to turn this off."
Hi Peter,
the first thing you should always do when entering one of the templates pages is to press the "Disable editor" button (unless the HTML WYSIWYG editor - which is really a bad thing there - is already disabled).
Best practice is to have a development instance of the same Moodle version, where you maintain a copy of the life database activity. Do all modifications of HTML templates always within a real good HTML editor app - and never directly in Moodle's interface. When you are finished, just select the entire text in your external editor app, copy & paste it into the corresponding field of Moodle's template pages. Finally, press the "Save template" button to make the changes effective.
Everytime you have changed something of the templates or fields, I would advise to go to the "Presets" tab and export as zip.
In your life Moodle, import the preset zip you have exported from the development instance.
Note that this process only works well as of the current 1.9.1+ weekly snapshot.
Best regards,
Robert
"Unfortunately if you edit the template a filter in Moodle will validate the code and muck it up but if you keep the code in a external document you can just paste it back in and all will be well. Does anyone know how or where to turn this off."
Hi Peter,
the first thing you should always do when entering one of the templates pages is to press the "Disable editor" button (unless the HTML WYSIWYG editor - which is really a bad thing there - is already disabled).
Best practice is to have a development instance of the same Moodle version, where you maintain a copy of the life database activity. Do all modifications of HTML templates always within a real good HTML editor app - and never directly in Moodle's interface. When you are finished, just select the entire text in your external editor app, copy & paste it into the corresponding field of Moodle's template pages. Finally, press the "Save template" button to make the changes effective.
Everytime you have changed something of the templates or fields, I would advise to go to the "Presets" tab and export as zip.
In your life Moodle, import the preset zip you have exported from the development instance.
Note that this process only works well as of the current 1.9.1+ weekly snapshot.
Best regards,
Robert
Robert Allerstorfer への返信
Re: Listing database content horizontally instead of vertically
- Madhu Avasarala の投稿
Good day all,
My aim is to get the most recently added items to be highlighted for attention after being listed vertically. I managed to get the vertical listing to work after following the instructions on this thread. Can someone point me the way to get the highlighting to work?
Thanks
Madhu
Peter Evans への返信
Re: Listing database information horizontally instead of vertically?
- Itamar Tzadok の投稿
Unfortunately if you edit the template a filter in Moodle will validate the code and muck it up but if you keep the code in a external document you can just paste it back in and all will be well.
Does anyone know how or where to turn this off.
One way to avoid this unfortunate but sometimes necessary behavior is to write the table with javascript. In the header you define a string variable to which you then add the relevant table parts from each section of the template and finally document.write it in the template footer. Something like:
Header script:
var strHtml="";
strHtml+='..'; // open table and header row
strHtml+='..'; // data row; the template generator do the loop on this script command and you get all rows.
Footer script:
strHtml+='..'; // close table
document.write(strHtml);
Peter Evans への返信
回應: Listing database information horizontally instead of vertically?
- Anderson Hsu の投稿
Anderson Hsu への返信
Re: 回應: Listing database information horizontally instead of vertically?
- William Lu の投稿
