Number-with-currency type column import

  • Hi,

    We’re trying to create a bubble chart based on a Google Spreadsheet table.

    One issue we can’t solve is with columns having cells with numbers, prefixed with a ‘$’ currency symbol. When we try to set the data type of this column to integer in the wpDataTables table settings, the column get broken, and each cell displays a zero value.

    Any idea what might be the problem and how to fix this?

    The second issue is about colors: is there any way to change the color spectrum applied by the plugin on a bubble chart (Google Spreadsheet chart engine)?

    Thanks in advance for your help. ???♂?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Gabor Lippert

    (@lunule)

    Quick update:

    I tested what happens if a .CSV table, including a column of currency-suffixed number cells, is imported, and the result is the same as with a live Google Spreadsheet table base: even when the column is well formatted in LibreOffice (currency), it appears broken once imported with the wpDataTables plugin, and again, each cell displays a zero value.

    This seems to be an import- or parsing-related plugin bug/issue.
    It seems there’s no way to import a column with currency values and handle it as an integer value with the plugin – the reason why this is a problem is that the bubble chart accepts one string type column only, thus, due to this bug, we can’t generate the chart we need. ??

    • This reply was modified 2 years, 9 months ago by Gabor Lippert.
    Plugin Author wpDataTables

    (@wpdatatables)

    Hello there.

    Sorry for the late response.

    All columns that include any other character other than numbers will be considered as string columns, so you can’t link to, or import a table that has a prefix or a suffix.

    The data in the column has to contain only numbers, and when you link that table with wpDataTables, you can add a prefix and/or a suffix in column settings.

    However, neither the suffix nor the prefix will be included in the chart – charts are able only to pull values from the table, and to include them in the chart, you’d need to use some wpDataChart callbacks, like we did in this example, by adding kilometers as a suffix.

    We hope that helps.

    Kind regards.

    Thread Starter Gabor Lippert

    (@lunule)

    Hi,

    Thanks for your reply. Are you planning to implement a better currency field implementation? The reason why I’m asking is that there’s a typical scenario:

    1. The client wants to import a live Google spreadsheet to wpDataTables, one theat includes columns with currency&number data type.
    2. The same client needs these columns’ data type because this same column is used by other APIs as well.

    With this scenario, the current way of implementation (remove the currency symbol in Google, and re-add it in the wpDataTables UI) is not a workable solution.

    —

    Also – do you have some info regarding the other question?

    The second issue is about colors: is there any way to change the color spectrum applied by the plugin on a bubble chart (Google Spreadsheet chart engine)?

    Thanks again for your help.

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello again.

    Since you’re using the Premium version of the plugin, please open a ticket on our official support platform, and we’ll gladly help you there.

    Commercial products are not supported in these forums, as per this comment by www.ads-software.com moderators.

    Thank you for understanding.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Number-with-currency type column import’ is closed to new replies.