This issue is where I will identify the progress we have towards 1.0. As I make new dev snapshots, I'll record comments here that indicate what the status of the snapshot is. We can also use this as a place to discuss the feature set for 1.0. Subscribe to this issue if you want regular updates when the dev snapshot changes.

Comments

metzlerd’s picture

Just committed an update that starts the online documentation. The documentation is in a series of help reports. Visit the admin page to specify your report location (must be writable by apache) and then visit the My Reports link. Site admins should see a pretty good start to online documentation.

zeezhao’s picture

subscribing.

metzlerd’s picture

The current dev snapshot is largely feature complete. There isn't yet a way to delete reports that were created in the UI, but the product has already been used to create near 100 different reports at our institution. I need to focus more on documentation, and will. I'll also plan on implementing the delete functionality.

Todd Zebert’s picture

subscribe

Rj-dupe-1’s picture

subscribe

metzlerd’s picture

Latest commits have been focused on both improving the documentation as well as starting to provide some sample reports that better illustrate what you can do with the system. The Sample reports require PDO Sqlite support, so that I could easily deliver some sample data with the product.

I will likely roll some kind of beta release as soon as the docs are fixed, and I add the ability to delete a report. In truth I use this product on production sites already.

I'd love feedback from anyone about questions regarding "how do you" that aren't covered in the documentation.

rhymeswithcamera’s picture

Subscribe

metzlerd’s picture

Commited a fix and some sample reports that better illustrate what you can do with Forena, including help reports that illustrate master/detail reporting in a couple of ways. The Sample reports are built off of sample data that requires PDO sqlite support as described above. I would love feedback on the docs by anyone who's using/reading them.

metzlerd’s picture

Added native Postgres support and improved the error checking for supported drivers.

I also corrected a bug where users that were not user 1 couldn't see the help reports/files. The help reports are supposed to be visible based on who has permissions to edit reports, but were only showing up for user 1.

rhymeswithcamera’s picture

I'm looking forward to playing around with this in the next few weeks. I come from the enterprise BI space, so a solution like this certainly sparks my interest. The project I'm working on requires reporting for our partner organizations. Once I dive in, I'm sure you'll be seeing me in the issue queue. Thanks for your work on this!

metzlerd’s picture

Time for a check in:

I'm getting ready to consider a 7.x port and also am working. I'm using this pretty extensively, but I haven't seen much on the issue queue. So the question is. You subscribed, are you using this product or did it leave you wanting? If so, why? Honesty is greatly appreciated.

Todd Zebert’s picture

This is somewhat non-feedback: I like the concept, and I've installed it, but my need for it got pushed behind a number of other things so I haven't spent any time with it.

rhymeswithcamera’s picture

Same as Todd Zebert: I love the concept, but we've pushed reporting out to the next release. This module is at the top of my list for reporting - if there's a path to Drupal 7. We plan to upgrade to Drupal 7 in 2012.

Rj-dupe-1’s picture

Haven't actually installed as we are switching most of our development into D7; entities solve so many problems for us that we didn't have much option. Very excited that you're considering porting.

zeezhao’s picture

Not been able to use it yet, as found it late in the process at the time.

Also, in any case, since my data was using hierarchical_select module and hence had some hierarchy in the data, I needed ways of aggregating data by hierarchy. Views is good at pulling back raw data for this without needing to worry about the sql. However, it could not deal with aggregation easily...

So what I ended up doing then was using views to pull the basic data, and then built a custom module based on hook_views_post_render(&$view, &$output) for aggregating, massaging, and plotting the data and as required. For graphing I used fusioncharts module, but also played with chart (google) module.

Please let me know how this approach could potentially be done in forena. Once I have some time, I may try and experiment with it. Thanks

metzlerd’s picture

OK guys point taken. I'll get on the port to d7 immediately. I'll look seriously at the graphing support as well. Thanks for the input and interest. If you do have troubles working with.... do file requests on the issue queue. Id really like to see this take off.

zeezhao’s picture

Thanks.

A couple more things: on the project page you have on the roadmap:

1. "Views integration" - please how do you see forena working with views?

2. Printing/Pdf - I have been using the http://drupal.org/project/print module with wkhtmltopdf for making pdf files. This currently works with any page, but you need to do css for special layouts etc.

metzlerd’s picture

Title: Forena 6.x-1.x Roadmap » Forena Roadmap

The D7 port is up and running. There may be some notice compliance issues in the various db drivers (I haven't tested them all). But the D7 port is functional.

metzlerd’s picture

I've released base 6.x-1.0 and 7.x-1 .0 versions of Forena. Mostly these are bug-fixes, but I'm starting development on custom rendering required to get pluggable flash graphs to work soon. As always, keep the feedback coming.

DigitalD’s picture

Version: 6.x-1.x-dev » 6.x-1.0
Component: Code » Documentation
Category: feature » support
Priority: Normal » Major
Issue tags: +Documentation, +forena

Hi,

I am looking to use this module for the reporting needs of a client. I would like to know how to create new data blocks as there is no information on how to do this in the help files (just place holders). If you could provide a walk-thru on how to do this it would be very much appreciated!

I have tried to figure this out myself by creating an sql statement and placed it a subdirectory under the repos directory in the forena module directory structure but it does not appear in the data block list. What is it that I am doing wrong? I assume I need to make some other modifications somewhere but don't know where.

Any help you can provide would be appreciated!

metzlerd’s picture

As a quick test. Put it in the repos/drupal folder and make sure that it has an access content comment at the top of the sql. The block list includes permissions of the form:

--ACCESS=access content

You can replace the "access content" with any drupal right that you see in the permissions page.

metzlerd’s picture

Version: 6.x-1.0 » 6.x-2.x-dev

A major backport has just been complete that brings most of the Forena 7.x-2.0 provided features to the 6.x-2.x dev branch. This includes internationalization support, and graphing, along with new hooks for modifying parameters. Very interested in help with testing on this branch.

metzlerd’s picture

Pushed support for dataTables jquery plugin. Also added support for js files for each form or report.

metzlerd’s picture

Status: Active » Closed (fixed)

6.x new features development has been ended.

prasannamaddirala’s picture

How can i convert my forena reports to featuresset.......

Can you please help ...

metzlerd’s picture

I don't understand the question. What do you mean by featureset? Could you please open a separate issue on this?