Okay
  Public Ticket #2910965
Chart not updating & table css issue
Closed

Comments

  • Johan Ekman started the conversation

    Hi, 

    Earlier before purchase I got some help from you. Please see attached document. It is regarding how to display a chart and add filters to it by hiding a table connected to the chart. 

    Now I have purchased wpDataTable and please check the website where I am trying to do this here: https://www.e2economist.com/new-tiles-market/

    As you can see I have a couple of issues:
    1. The css style could does not seem to work ? It does not hide the table..
    See the page / link!

    2. My Chart is not updating according to my settings. 
       a) I have clicked "enable grouping" and the preview should be as attached picture - See that the values will be different. But on website this seeting is not impacted. 
       b) The Dates on the axis of the table is not fomratting correctly either.
    See the pciture attached from chartsetting and see the page / link!
    (Not displayed the same) 

    Please help me with above. 

  • [deleted] replied

    Hi Johan

    Thank you for reaching out to us.

    wpDataTables is a WYSIWYG (What You See Is What You Get) concept-based plugin. This means that the table and chart should look the same both in the back-end and in the front-end. If your front-end table or chart looks and behaves differently than in the back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.

    Issues like this usually occur when there is a conflict either with the theme currently active on your website, or another plugin you have installed.

    Can you please change the theme and see if the issue is resolved? If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be). If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. Once it does reoccur, you will have found the plugin causing the issue.

  • Johan Ekman replied

    Hi, 

    Changing theme on a live site is not an option. It will bring the whole site down. 
    Deactivating plugins will also disturb a live site massively. 

    My site has very if perhaps none "special" plugins installed - it is very clean in regards to plugins. 

    The Theme installed is PenNews  :   https://themeforest.net/user/pencidesign?ref=PenciDesign

    Firstly, do you know or can you check if this theme is known NOT to work with your product?
    Can you perhaps try this theme on your side and check the compatibility?
    (Tips: Would be good if you had a list of compatible themes so we customers know if it works or not)

    Secondly: If the that theme should not be a problem I also know that I am running the plugin "WB Bakery Page builder" one of the most common page builders for wordpress in the world. '

    Q: Do you have compatability issues with WB Bakery Page builder plugin ? Can you try it on your side ? 

    Let's start with those.
    If you cannot support with above I would need to issue a refund and rate this product down. 


  • [deleted] replied

    Hi Johan

    It's hard to say without taking a closer look and inspecting the configuration and the related page. We will need to recreate the issue to be able to locate the cause.

    So if you don't mind can you please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

  •   Johan Ekman replied privately
  •   Isidora replied privately
  • Johan Ekman replied

    OK, I think I understand but how do I access the file: 
    wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.googleCharts.js:

    I have only access wordpress via the regular wordpress front end. Not sure where files are stored or accessed. 

    Thanks for this support, great so far!

  • [deleted] replied

    Hi Johan

    You can try using Plugin Editor or you can reach out to your hosting provider and they will give you instructions on how to edit this file.

    Do let us know if there is anything else we can do to assistsmile.png

  •   Johan Ekman replied privately
  • [deleted] replied

    Hi Johan

    I forwarded this to our developers to investigate further. We will get back to you with more information.

    We truly appreciate your time and patience. 

  •  2,572
    Aleksandar replied

    Hey Johan.

    Sorry for the late response.

    I took a look at the wdt.googleChart.min.js on your site and it is still loading the same old line of code:

    7687637135.png

    Milan forgot to mention that after modifying the wdt.googleChart.js file, you need to disable "Use minified wpDataTables Javascript" in Settings/Custom JS and CSS:

    8531795845.png

    I disabled it, and the chart is properly grouped now on the front-end:

    4557096879.png

    Sorry for the delay once again, and for forgetting to tell you about the minified file.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Johan Ekman replied

    Thank you now it behaves correctly
    The last 2 issue with this visual is that on the website is that:
    1. How do I present the date on the axis as the dateformat I set on the table. In this case I have set the date format to be YYYY-MM-DD but the graph here in edit mode shows the name of the month and not the same format. But on the website it is even more incorrect, there it is adding the TIME and sets 12:00 on all dates as time is missing...it should not be there...

    So how do I get the table to show YYYY-MM-DD in both the editor/builder and website ? 
    Here is the page with visual also see pic of editor below.
    https://www.e2economist.com/new-tiles-market/

    2. On the website where we now have hidden the table in order to get the filters to be able to filter the graph the "clear filter" button is all black in background and does not look good. click link above to website to see the black clear filter button. How do we change this to be matching website color ? 

    5195109357.png


  •  2,572
    Aleksandar replied

    Hi again Johan

    1. HighCharts should inherit the date format from wpDataTables, but since you're using Google Charts, they have their own format which can't be adjusted by changing the format in wpDataTables, or in WordPress' General settings. You would need to use some wpDataCharts callbacks to change the date format in the chart.

    • Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts APIHighcharts API, and Chart.js API
    • All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
    • Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.

    As for the time - I can't see this on your chart:

    8382934695.png

    2. The color of the font is probably coming from your theme, so you can add some custom CSS:

    button.button.btn.wdt-clear-filters-button {
        color: white;
    }
    

    And the color of the text will be white:

    8707978107.png


    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables