I think the D7 version is not complete, or is broken with the newer Views releases
1. I get an error regarding below code: 

  // display current views calcs fields
  $fields = _views_calc_fields();
-  while ($field = db_fetch_array($fields)) {
+  foreach ($fields as $field) {
    $form[] = views_calc_field_form_item($i, $field, $substitutions);
    $i++;
  }

2. On admin/config/views_calc, I get Notice: Undefined index: #children in theme_fieldset() (line 2649 of ..\includes\form.inc).
3. In Views, when I try to select the Tree (adjacency model) the view mode doesn't get selected.

Comments

johnv’s picture

johnv
Primary language Dutch
commented

Also, documentation says "The 'Columns' tab allows you to set column calculations."
There is no such tab.

rnj786’s picture

rnj786 commented
Issue tags: +views calc sum

I had to use views_calc in one of my recent projects on D7, I had tough time trying to figure out all that is broken. I was able to change the db_fetch_array to foreach since this was mentioned on the D7 upgrade guide. However there are other problems with the D7 version of this module which need to be addressed.

The Calculation results are displayed as "node" instead of the actual number, especially when you have relationships or have a field or two from user table.

Maintainers & Generous contributors please step up and make the D7 version of this module usable. Also provide us some lead as to where exactly are the calculations done ? If there is any developers documentation, please let me know, i will go through the documentation and try to work on fixing it.

THANKS
rnj786

danepowell’s picture

danepowell commented

That's a shame, I was really hoping to use views_calc on a D7 project. Any chance this could be fixed? If it's just minor stuff dealing with upgrade from D6 to D7 I can probably take a crack at it, but I'd like some assurance that patches would be accepted and support would continue to be provided... this module seems like it's practically been abandoned.

miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented

Abandoned???
Dane, please read the statements:
"A partial resource-optimized rewrite, major cleanup (6.x-2.x), a Port for Views 6.x-3.x and a Port for Drupal 7 has recently been submitted by Miro Dietiker of MD Systems.".

It is fully maintained. Just provide clean patches and provide solutions and you'll see things going on.
I cannot see any issue that contains a reviewed patch. Do you?

danepowell’s picture

danepowell commented

Sorry, no offense intended- but with no official release in two years, the release that's already out there not 100% working (IIRC), and no commits by KarenS in over a year- you'll understand my concern. But, I'm glad to hear there's still development taking place behind the scenes, and I'll try to throw a patch together.

danepowell’s picture

danepowell commented
Title: D7-version broken? » D7 version broken - WSOD and other errors
Priority: Normal » Critical

I can confirm that replacing the db_fetch_array() call as proposed by johnv solves the immediate problem of a WSOD, but beyond that I'm really not sure how to set about fixing things- as rnj786 said, this module is pretty complex and there seems to be a long way to go for a D7 release. As contributors not intimately familiar with the code, it's hard to help.

rnj786’s picture

rnj786 commented

Dane, I have several other random issues along with the ones i mentioned above. One of the other problems is handling of Float types, all my calculations would provide the result double than the actual result when the field data is float.

I know there was some core issue with views about query caching (or DISTINCT) producing queries twice and generating double results. They said it was fixed in Views 3, so i don't know how this happens here again.

The way this module is trying to do calculations is still not clear. I am almost about to give up on this, I am checking out datatables module which is capable of providing the footer callbacks but it hasn't been developed for drupal yet which i am sure people are working on, subscribe to that feature request there to expedite the development !!

yugongtian’s picture

yugongtian commented

+1

hansfn’s picture

hansfn commented

subscribe

RealBirkoff’s picture

RealBirkoff commented

subscribe

BenK’s picture

BenK commented

Subscribing

dayer4b’s picture

dayer4b commented

subscribing

miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented

Since Drupal Core changed a lot in fields handling finally, we need to rework the whole module.

At the time of views alpha1 things worked perfectly in our port.
However, Drupal core and Views changed so much that this won't help us much.

I cannot find a simple way with my limited time to adapt the current code to the final changes.
Meanwhile i'm sorry there won't be any alternative without a next contributor of funds provider. Things will take days, not hours.

Merlinofchaos is interested in adding aggregation support into views itself. However this will take a lot of time.

Removed the 7.x-1.x snapshot from the release list.

EDIT: Note that this only hits fields / fieldable entities. If you define own fields in hook_views_data, things might work cleanly. This case is less work and possibly much more subject of being fixed soon.

danepowell’s picture

danepowell commented

Speaking of aggregation support in Views itself- I just noticed that if you enable grouping for a view (WITHOUT views_calc installed), and click on 'group settings', you can choose from various 'aggregation functions', including summation. Has anyone tried this? It doesn't sound nearly as fully-featured as views_calc, but it might help someone.

johnv’s picture

johnv
Primary language Dutch
commented

I tried in January, there are some issues in the Views queue (look for GROUP BY / GROUPBY), and at that moment, it didn't work yet. Perhaps it has improved.

OldAccount’s picture

OldAccount commented

Subscribing

rogical’s picture

rogical commented

+1

spacereactor’s picture

spacereactor commented

+1

kevin.mcnamee@mailbox.org’s picture

kevin.mcnamee@mailbox.org commented

subscribing

jason@greengeckodesign.com’s picture

jason@greengeckodesign.com commented

subscribing

intu.cz’s picture

intu.cz commented

+1

anektod’s picture

anektod commented

subscribing

david_de’s picture

david_de commented

subscribing

drupov’s picture

drupov commented

subscribe

chalee’s picture

chalee commented

subscribe

delty’s picture

delty commented

+1

Refineo’s picture

Refineo commented

subscribing

aliceduck’s picture

aliceduck commented

subscribing

shaisamuel’s picture

shaisamuel commented
Category: bug » feature
Priority: Critical » Normal

subscribing

Geex2011’s picture

Geex2011 commented

sub+

Yuri’s picture

Yuri commented

+1

jaspher’s picture

jaspher commented

+1

Yuri’s picture

Yuri commented

It is sad that such a useful module is currently not available for D7. Hope that someone steps forward to pick up maintenance.

nagiek’s picture

nagiek commented

Here's a hack: create a view as an attachment, turn on aggregation, and voila. Not the best, but not that hack-y either.

wizonesolutions’s picture

wizonesolutions
he/him
Primary language English
Location Norway
commented

I was thinking of that approach as well, since Views does have aggregation capabilities now.

nagiek’s picture

nagiek commented

Yeah, it's actually working pretty well for me. Add in a rewrite to call your label field "Sum" and some CSS to remove the header, and it looks great.

Yuri’s picture

Yuri commented

Well, I can't get the sum aggregation to work, it just does not show up when enabling aggregation on a decimal field. How exactly did you do that?
What version of views are you using? Applied any patches? I've installed the latest dev version.

Francesco1910’s picture

Francesco1910 commented

Subscribe!

wizonesolutions’s picture

wizonesolutions
he/him
Primary language English
Location Norway
commented

Francesco1910: You can now use the follow button at the top-right of the issue to subscribe.

patoshi’s picture

patoshi commented

subbing

peterx’s picture

peterx commented

My interest is to use something to generate input for the Charts module. Is there anyone else interested in working on Views Calc for Views 3 and D7 to feed Charts?

If the approach mentioned by nagiek works then we could start a documentation page describing the approach. The alternative would be to have a D7 branch somewhere so people can work on it toward a D7 version.

pbeakley’s picture

pbeakley commented

We are extremely interested but I personally lack the technical expertise to assist. However, my client would be happy to financially support the work. Not sure how much is "enough" and we've never done a donation-for-development type thing before. What's involved? Is there a specific developer out there who wants to take this on for a few hundred dollars?

tedchwang’s picture

tedchwang commented

I'm very interested in this, too. If a developer wants to give a quotation for this work, I'll be happy to chip in to the pool of funds.

Anyone else willing to contribute financially to this?

john bickar’s picture

john bickar commented

The functionality of Views Calc is (at least partially) provided by the aggregation functions in Views 7.x-3.x, which now has a stable release.

I found the screencasts linked from this page helpful:
http://dev.nodeone.se/en/blog/using-aggregation-in-views

derp’s picture

derp commented

subscribe

derp’s picture

derp commented

Hi Miro,

I understand that quite some work is needed to get this fixed. Is there a list available somewhere of items that need rewriting or fixing? Would a budget, sponsorship or funding help in any way to get this module back onto a production level?

Cheers,
derp.

Phibo’s picture

Phibo commented

subscribe

dannygoh’s picture

dannygoh commented

I am currently using Views Summarize for my Drupal 7 projects.

doana’s picture

doana commented

Thank you, dannygoh! Views Summarize worked like a charm for my D7 site.

karens’s picture

karens commented
Category: feature » bug
Status: Active » Fixed

The table display part of the code should be working now. Haven't worked on custom fields yet.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

jessepinho’s picture

jessepinho commented

dannygoh: Nice! Views Summarize worked perfectly for my purposes as well. Thanks!