Archive
Monthly
Go
|
|
DNN Blog
May
18
Posted by:
Andrew Nurse
5/18/2007
Well, I've just finished up week 2 at Microsoft, which is going great by the way, but back in DotNetNuke-land a new version of the Reports module has been released! This is basically a version I finished up before leaving for Microsoft and it adds a few new features. The next major release will probably be in a few months, seeing as I can't work on the project while I'm at Microsoft, but until then check this one out.
Here's a short list of the new features implemented:
- "Test Query" button on the Settings page allows Admins to verify that their query will produce results (as well as see exactly how many results are produced)
- "Show Xml Source" button on the Settings page allows Admins to see an Xml representation of the data, in the format used by the XSLT Visualizer (designed to help in the development of XSLT transform documents)
- "Upload SQL File" feature allows Admins to upload a text file containing their SQL script (NOTE: The file itself is not saved, its contents are simply sucked out and placed into the Query field)
- Tweaked Visualizer API to abstract the Visualizer Settings away from the TabModuleSettings table. In previous versions, Visualizers had to manually add their settings to TabModuleSettings, now they can simply manage a Dictionary containing their settings and the framework will save them to the appropriate place (which is still TabModuleSettings)
- SuperUsers can now see the details of a SQL Syntax Error, if one occurs, on the view page of the module instead of a message simply stating that there was an error
- "Add/Remove Extensions" feature allows SuperUsers to install new Visualizers (and other Extensions, in future versions) by simply uploading a ZIP package (package format and details to come in a future blog, along with a complete guide to Visualizer development).
I hope you enjoy the new version, for the next major release the focus will be on the Data Sources Framework which will allow users to pull data into the module from sources other than the current DNN Database. This is a feature that people have been asking about for a long time, and the next release will include a system for doing this.
By the way, I'm not going to be a complete ghost this summer, although my focus will be on Microsoft. Feel free to stop by the Reports Module Forums and ask questions if you have them, or fire off an email to: andrew DOT nurse AT dotnetnuke DOT com.
7 comment(s) so far...
Re: Reports 04.05.02 Released
I am trying to use your module with an xslt file. But could your provide me with an .xslt example in which you refer to f.e. the survey database and display some fields.
Currently i am using this but that is not correct.
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
My surveylines
reg. Geert
By geert2007 on
5/28/2007
|
Re: Reports 04.05.02 Released
My recommendation would be to use the "Show Xml Source" feature in Reports 04.05.02. In the settings page, there will be a "Show Xml Source" button which you can use to see the Xml that is fed to the XSLT Visualizer. This should help with developing your XSLT transforms.
By openarrow on
5/28/2007
|
Re: Reports 04.05.02 Released
Tried that indeed. but could not find out why my xslt was not working Even if i use the DocumentElement/QueryResults as xpath for my vars. The naming seems not matching.. I will take an extra look. But a little sample would be nice to make sure that i am doing the right thing...
By geert2007 on
5/29/2007
|
Re: Reports 04.05.02 Released
I definitely agree that samples are needed. At the moment, I don't have the time (see other blogs posts re: Microsoft Internship :) ), but I will be making it a priority when I finish at Microsoft. Until then, if you do figure out your problem, please post your sample (if possible, and after removing any private data) in the Reports Module Forums for others to see!
Otherwise, if you still have issues, you can also post your questions there. The forums make it a little easier to post XML content, and your previous comment on the blog didn't quite come out right :).
Thanks for using the module!
By openarrow on
5/29/2007
|
Re: Reports 04.05.02 Released
I can't get this to install, I get the following error right after Created C:\WebSites\DNN441\DesktopModules\Reports\js\dnn.reports.js
ExceptionSystem.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Common.Utilities.Config.AddCodeSubDirectory(String name) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateModuleFile(PaFile File, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()
By davido on
6/12/2007
|
Re: Reports 04.05.02 Released
Found the problem with the install. Explained here: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/33/threadid/136979/scope/posts/Default.aspx
By davido on
6/12/2007
|
Re: Reports 04.05.02 Released
Andrew
I added a CSV export feature to 04.05.02. Hopefully similar functionality can be included in version 5. Great Job. I love the Visualizer API. It was so easy to find out if Paging was set.
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/112/threadid/175001/scope/posts/Default.aspx
By tharris9d on
10/9/2007
|
|