With ods you can use the following formula:
=(A1/86400+DATEVALUE("1970-01-01"))
where A1 stands for the cell with the unix timestamp. For example:
| 1349857600 | 2012-10-10 |
In the other direction:
=(A1-DATEVALUE("1970-01-01"))*86400
| 1999-02-08 | 918432000 |
With Excel its DATE instead of DATEVALUE.
hth
Did it perform better on any previous version the module or is it the first time you are trying 1 record with 3000+ fields?
What does the performance info Moodle generates suggests?
The Dataform is a big box. It can already send notifications on various events and has partial infrastructure for user defined events. It can even allow you to fetch data from anywhere in Moodle, if you can write SQL, but that's still experimental and not yet availalbe even on git.
You don't need to do git to go there and download a zip file. Installation instructions are available in the Dataform Moodle docs at Installation.
Yes, module and block and there is also a label-like resource that does what the block does but in the course section rather than side region. There is still a lot of work to do. the versions currently available from the plugins repo are fairly behind. Hoping to finalize a stable release soon and upload it to the repo. In the mean time Most recent RC is on git.
If you try the Dataform please download the most recent build from git at https://github.com/itamart/moodle-mod_dataform.
You need to first create a Dataform activity, then export your data from the Database activity and import it into the Dataform activity.
For import into the Dataform create CSV view (to distinguish from the deprecated Import view). The view allows you to specify the field patterns to import and the csv settings. Then you prepare the csv content and either upload it from file or paste into a textarea in the import form (especially convenient for testing the import content before importing many entries). After import you are redirected to the browse view to see the imported entries. If there are no entries the import failed for some reason which at this point is not displayed (hopefully this would be added soon).
Now, you can import almost anything that can be displayed, including entry info such as userid, timecreated, timemodified etc. You just need to include the right pattern in the view template. The csv column name is by default the pattern name unless you define in the template a different name. The import form also allows you to set a specific name for each column in case your csv content is predefined and you don't want to change its column headers.
The pattern for the entry owner is ##author:id##.
In the Dataform settings you can select group mode 'Separate participants' so that each student can see only his/her entries. Also, set max entries to 0 and entry editing time limit to 0, so that students would not be able to add any entries by themselves or edit the entries that were added on their behalf.
If you want to be able to edit entry owner when editing an entry, use the tag ##author:edit##. This tag behaves like the ##author:name## tag in browse mode but in entry editing it displays for managers a dropdown of all the course participants.
All this is undocumented so if you need futher assitance just let me know and feel free to add to the module documentation at http://docs.moodle.org/23/en/Dataform_module.