parsing price goes wrong

  • Resolved rafda26

    (@rafda26)


    8 months, 4 weeks ago

    Hello,

    im importing data by csv totally fine. I have a problem with the price (Sale or Rent Price) its getting a number format, example 2490000 and its pulling 2490000,00 (two more 0’s) but showing on the detailpage: 249.000.000 €

    I dont know why its pulling these two zeros after the comma?

    Do i have to change the field mapping instead of equal to *?

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Property Hive

    (@propertyhive)

    Thanks for getting in touch. Out of interest, how is the price being included in the CSV? Is it in the CSV with ‘.00’ at the end?

    Do let me know and we can go from there.

    Steve

    Thread Starter rafda26

    (@rafda26)

    Hi Steve,

    it is actually 2490000 without decimal places in my example. For the square metres it is 340.00 and that is how it is transferred. Only 2 decimal places are added to the price and the decimal point is omitted on the final page. My current solution is to remove the decimal point and the two zeros and update the price after the first time the data is filled in. after that it no longer updates the price.

    Maybe you have an idea? Or does the import expect always a decimal places from the csv?

    Plugin Author Property Hive

    (@propertyhive)

    I’ve tested this here with a CSV and no ‘.00’ was imported to the price. How are you viewing the CSV? In Excel or similar? I wonder if that’s masking/hiding the ‘.00’

    If you open the CSV in notepad or a similar text editor I wonder if the ‘.00’ is visible there?

    Do let me know.

    Thread Starter rafda26

    (@rafda26)

    Hey Steve,

    i took a look now in notepad and indeed there is the ###,00. Maybe this is why. In excel doesnt appear

    Plugin Author Property Hive

    (@propertyhive)

    Glad you saw them in Notepad. That explains it. Yes I think Excel masks the numbers.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘parsing price goes wrong’ is closed to new replies.