We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1957837
creating data table from csv
Closed

Comments

  • Daniel started the conversation
    April 2, 2019 at 12:00am

    I receive this error message: "Please do not add more then one string-type (date/time, image, email, URL) column since only one can be used as a label" when referencing a csv file with two columns: One is a list of business types, the second is a list of percentages which I wish to turn into a chart. I am required to have a title for each column (a string), but the percentages could be floats...However, when I assign "float" to that column, the numbers all turn to "0's". I've imported several columns before successfully without seeing this error. What am I doing wrong? Simple pie, bar, whatever chart with two info columns. I've watched the videos and the don't address this issue. This guy: https://codecanyon.net/user/boedakpinank asked the same question (see attachment).

    I've tried Excel, Numbers and Google Sheets.


    Thanks

  •  2,576
    Aleksandar replied
    April 2, 2019 at 12:28pm

    Hi Daniel.

    Thank you for your purchase.

    If it doesn't contain any sensitive data - could you send us that CSV file, so we can take a look?

    Usually, when it returns "0" instead of actual values, it means the float format is different in the source file and wpDataTables settings (original file has 1.23 and wpDataTables is set to 1,23).

    Another thing about the charts - it simply can't handle more than one "String" type columns (date/time, image, string, URL, e-mail), so you got it right - changing to "Float" will resolve the issue.

    I'll provide better feedback once I see the file. If possible, of course.

    Best regards

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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

  • Daniel replied
    April 2, 2019 at 7:26pm

    Thank you, Aleksandar. I did eventually find documentation that addressed my issue. It involved removing the percentage sign on my .csv table then adding it back in via the table display settings as a suffix. Everything worked just fine from there. Please mark this issue as resolved. 

    I do have another question. Let me know if you'd prefer that I open up a new support ticket:

    I'm not fluent in js, so css would be my preferred way to style individual columns in a bar chart in the absence of a color-picker in the admin area. Say, for example, I was charting the percentage of money spent on grocery store purchases during a single visit. My Y axis might be the percentage and X axis the various grocery items. How would I color each column of data (on a bar chart) individually - as opposed to the whole series? Can you point me to documentation describing how best to add/discover classes that target the individual columns, or am I just better off learning to use the script method?

    Thanks for your timely help.

    Daniel

  •  2,576
    Aleksandar replied
    April 3, 2019 at 9:48am

    Hi Daniel.

    Glad to hear you got it to work!

    All functionalities of wpDataCharts present in the built-in versions are the ones you can find in the settings of each chart, but if you need some custom solution you can check in our documentation about wpDataCharts callbacks. There are some examples there of changing the color.

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

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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