Decimal problem during import

  • Resolved webyildirim

    (@webyildirim)


    10 years ago

    Hi,
    I tried to import some data into my pods custom type via wpallimport. And i could finish the process. But when i controlled the values, i saw the deciam problem on all numeric fields. If value contains such as 7.5, it takes as 75 without decimal sign.
    How can i solve this problem?
    Thx, brgds

    my csv:

    ID,Content Title,brand,model,modelDetail,hatchType,fuelType,transmission,engine,door,hp,maxSpeed,accelerationTo100InMin,fuelTankCapacity,fuelSystem,cylinder,fuelConsCity,fuelConsLongTerm,fuelConsAvg
19195,ZAZ 11051.2 (58 Hp),ZAZ,1105,1105,Pick-up,Benzin A-92,Düz Vites,1.2 (58 Hp),5,58,148,17,38,Karbürat?r,4,0,0,7.5

    https://www.ads-software.com/plugins/pods/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Contributor Josh Pollock

    (@shelob9)

    When you created the number field in Pods did you set the number of decimals it allows? By default, number fields do not allow decimals and therefore will cause the change you are seeing. Try setting that option to 2:

    View post on imgur.com

    Thread Starter webyildirim

    (@webyildirim)

    Dear mr Pollock,
    Thank you so much for your response.
    Essentially, i had tried via setting option that you mentioned.
    Then i tried to import a few sample data. But nothing changes. Perhaps, firstly i should clear all data, deleteing number field and recreating numberfields with different names and setting decimal value from the beginning?
    Regards

    Plugin Contributor Josh Pollock

    (@shelob9)

    What I would test, to make sure the problem isn’t the period messing up the importer, is changing the number field to a plain text field to see if that works. You can always change the field type back.

    Thread Starter webyildirim

    (@webyildirim)

    Yes, Josh. It works well for plain text. But if i convert to number with decimal value. It imports as 75.00 instead of 7.5 value

    Plugin Contributor Josh Pollock

    (@shelob9)

    Am I correct that you imported, to a plain text field “7.5”. Then in the Pods settings you converted that plain text field to a number field, and set the number of decimals to 2 and that converted it to “75.00”?

    Thread Starter webyildirim

    (@webyildirim)

    Yes, after i setting the number format with decimal value as 2, i deleted the record. Then i reimported same data. It converted as “75.00”.
    Thank you in advance.

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    What number format are you using for the number separators? Is this WordPress installation on anything other than the default US localization?

    Thread Starter webyildirim

    (@webyildirim)

    I guess, you have a point! I ‘ve changed language of wordpress to Turkish.
    Turkish decimal sign might be comma. I’m not sure for now. But i think that, i should try it with US English setting asap. So after became sure what should i do?
    1. Import once with US setting then change to local language?
    2. Import after coding some function code that handle converting process into functions.php or somewhere like that?
    Regards.
    Plz see setting page=>https://tinypic.com/r/1z2f8td/8

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    That sounds like a great test process to see if this is related to that.

    Thread Starter webyildirim

    (@webyildirim)

    I tested and you were right about localization doubt. import in US English, then changed to Turkish. No problem seems on record values for now.
    Thank you so much.

    Plugin Contributor Josh Pollock

    (@shelob9)

    Awesome. Very glad to see this got worked out.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Decimal problem during import’ is closed to new replies.

Tags