Search results

  1. dewebkrant

    Calculation using Plotalot sql shortcodes

    Thanks for the FabrikHelperHTML::runContentPlugins hint - that helps to return a value in the details view instead of the shortcode so I guess the outcome can be used in the calculations element also.
  2. dewebkrant

    Calculation using Plotalot sql shortcodes

    Ok thanks @troester but can you please explain how I can test this and where to add var_dump($dienstena);exit; ? I tried by putting this code in the calc element where I use $dienstena-$dienstenb; with the plotalot shortcodes as described but outcome is still 0 - And if "Maybe the plotalot...
  3. dewebkrant

    Calculation using Plotalot sql shortcodes

    I "solved" this by using the calc element solution proposed by Nick on http://fabrikar.com/forums/index.php?threads/simple-solution-for-sum-total-in-element.44417/#post-228180 - instead of a sql query from Plotalot, I placed the $db strings in the elements used for calculating...
  4. dewebkrant

    Calculation using Plotalot sql shortcodes

    Unfortunately, this does not seem to work out of the box although logically it should I think: $dienstena='{plotalot id="37"}'; $dienstenb='{plotalot id="36"}'; $totalBTW=$dienstena-$dienstenb; return $totalBTW; But totalBTW is showing 0 while return '{plotalot id="37"}'; shows 1328 and return...
  5. dewebkrant

    Simple solution for SUM total in element

    Yes Nick, that is working also! So now we have two solutions. Great, thanks a lot.
  6. dewebkrant

    Simple solution for SUM total in element

    Managed with the Plotalot solution (http://fabrikar.com/forums/index.php?threads/fabrik-and-plotalot-with-variables.44027/) - using sql string in Plotalot single item and placing the plotalot shortcode in calc element and disabling the Ajax option in the calc element. Ok, this opens a lot more...
  7. dewebkrant

    Simple solution for SUM total in element

    Thanks Nick for your quick reply. Trying to implement the proposed solution and have: $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select SUM($db->quoteName(array('Bedrag'))); $query->from($db->quoteName('boekingen_inkomsten')); $db->setQuery($query); $results =...
  8. dewebkrant

    Simple solution for SUM total in element

    Just seeking for a simple solution to show the sum total of column in a form element. Sum total in list is what I have but I want this value to be shown in a form field. Tried calc element with many options but nothing worked sofar. Hoped to have an option to enter a simple SQL query like...
  9. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Tried 'http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml', map: map and http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml Turned group by sidebar off. Removed the first instance of overlay URL (Germany) and yes, http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml is...
  10. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Tried with some KML files by searching on google filetype:kml (examples I tried: https://www.globalgiving.org/globalgiving.kml and www.visualtravelguide.com/Germany.kml ) But I do not really know were to look for. Just need one (or some) working examples. Filled in the Chicago example...
  11. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Thanks again for your quick reply. I will remove the firewall rule.
  12. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Googled around and tried this evening to get it working but failed in showing any overlay in the overlay section of the googlemap visualisation ( https://resfarm.info/index.php/en/results-farmers-survey/map-overview-results ) - Yes the sidebar is showing but no data in the map. Tried a few...
  13. dewebkrant

    Having visualization only load data from certain elements

    Ok, tested in the live application and used your method: copying the list and de-publishing all elements which I do not need for visualization. (Great idea, I can use the elements for visualization later). Tested first with list 1, result is Gateway timeout 504 - Have visualization read from...
  14. dewebkrant

    Having visualization only load data from certain elements

    Thanks o lot for your quick replies. I managed myself in the meantime by adding a new list and selecting under "data" the same table as list 1. Effect seems to be the same as copying the list: 91 elements with unique ID are created and added to the newly created list. After this I trashed the 85...
  15. dewebkrant

    Having visualization only load data from certain elements

    Tried to work this out but did not manage sofar. Have a list (list 1) with 91 elements (questions). Till sofar, more than 700 interviews have been submitted. Want to show certain outcomes in a googlemap. Managed to do so but have server issues (504 bad gateway - timeouts etc.) because the system...
  16. dewebkrant

    Fatal error: Class 'PlgFabrik_Elementinternalid' not found after Github update

    Looks like this is fixed now. Did a complete new overwrite from github including the rating plugin changes and do not see errors and it functions, thanks a lot and double thanks for offering one of (if not "THE") the best Joomla extensions around.
  17. dewebkrant

    Fatal error: Class 'PlgFabrik_Elementinternalid' not found after Github update

    I meant the "update database" option on de Forms page in the backend (administrator/index.php?option=com_fabrik&view=forms) Just downloaded the rating element plugin from Fabrik and installed with the Joomla installer. No success. Same 1064 error. Think I go back to the backup of the site which...
  18. dewebkrant

    Fatal error: Class 'PlgFabrik_Elementinternalid' not found after Github update

    Update: I did a normal re-install of Fabrik 3.4 using the pkg_fabrik_3.4 zip file and went to Forms and "restore database" . Result: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY row_id' at...
  19. dewebkrant

    Fatal error: Class 'PlgFabrik_Elementinternalid' not found after Github update

    Using Joomla 3.4.8 and php 5.6.14 ; But I will try a new Github upgrade after I am on a different internet connection. Maybe there is something wrong with the upload process (although Filezilla shows no errors).
  20. dewebkrant

    Fatal error: Class 'PlgFabrik_Elementinternalid' not found after Github update

    My update: update again by doing new download from github, unpack and complete overwrite action. Result is now a 500 error page with "View class not found [class, file]: fabrikViewform, /components/com_fabrik/views/form/view.html.php ; Tried with opening menu item and choose as menu type "Fabrik...

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 167 (members: 1, guests: 166)
    Back
    Top