Title: Decimal problem during import
Last modified: August 22, 2016

---

# Decimal problem during import

 *  Resolved [webyildirim](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/)
 * 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://wordpress.org/plugins/pods/](https://wordpress.org/plugins/pods/)

Viewing 11 replies - 1 through 11 (of 11 total)

 *  Plugin Contributor [Josh Pollock](https://wordpress.org/support/users/shelob9/)
 * (@shelob9)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814422)
 * 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](https://imgur.com/iQKT4bD)
 *  Thread Starter [webyildirim](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814548)
 * 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](https://wordpress.org/support/users/shelob9/)
 * (@shelob9)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814565)
 * 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](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814606)
 * 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](https://wordpress.org/support/users/shelob9/)
 * (@shelob9)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814631)
 * 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](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814635)
 * 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 Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814637)
 * 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](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814638)
 * 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=>[http://tinypic.com/r/1z2f8td/8](http://tinypic.com/r/1z2f8td/8)
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814639)
 * That sounds like a great test process to see if this is related to that.
 *  Thread Starter [webyildirim](https://wordpress.org/support/users/webyildirim/)
 * (@webyildirim)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814650)
 * 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](https://wordpress.org/support/users/shelob9/)
 * (@shelob9)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814651)
 * 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.

 * ![](https://ps.w.org/pods/assets/icon.svg?rev=3286397)
 * [Pods - Custom Content Types and Fields](https://wordpress.org/plugins/pods/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pods/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pods/)
 * [Active Topics](https://wordpress.org/support/plugin/pods/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pods/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pods/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 11 replies
 * 3 participants
 * Last reply from: [Josh Pollock](https://wordpress.org/support/users/shelob9/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/decimal-problem-during-import/#post-5814651)
 * Status: resolved