Currency settings for CSV import

  • Resolved janpompe2014

    (@janpompe2014)


    3 years, 2 months ago

    Hi Peter,
    First of all I want thank you for this amazing plugin I discovered yesterday.

    How can I import a column with currency values?
    I started with values like our Dutch settings from an Excel-CSV file like € 10,00
    It gave me an empty column in WPDA.
    After changing the data type to Double, I got numbers without decimals.
    Now after changing the data in Excel to a decimal point in stead of the comma, I get numbers like 10 and 12.5 and 24.35.
    Is there a setting like the separator and the date format in CSV import?
    Or maybe another way to convert numbers to a value with 2 decimals?

    Thanks in advance.

    • This topic was modified 3 years, 2 months ago by Jan Dembowski.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Jan,

    You cannot import numeric values from a CSV with a currency. A currency is a string value and requires a text column. You can import your numeric values with the currency into a text column, but sorting (enabled on your demo page) will not give you the expected output. If all values have the same currency, you can add the currency to your column label (button: Click to define labels). If different rows have different currencies, you can import the currency in a separate column.

    Does this help?

    Best regards,
    Peter

Viewing 1 replies (of 1 total)
  • The topic ‘Currency settings for CSV import’ is closed to new replies.

Tags