Decimal problem during import

Resolved webyildirim
(@webyildirim)

9 years, 2 months 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://wordpress.org/plugins/pods/

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

Plugin Contributor Josh Pollock
(@shelob9)

9 years, 2 months ago

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)

9 years, 2 months ago

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)

9 years, 2 months ago

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)

9 years, 2 months ago

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)

9 years, 2 months ago

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)

9 years, 2 months ago

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
(@sc0ttkclark)

9 years, 2 months ago

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)

9 years, 2 months ago

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

Plugin Author Scott Kingsley Clark
(@sc0ttkclark)

9 years, 2 months ago

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

Thread Starter webyildirim
(@webyildirim)

9 years, 2 months ago

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)

9 years, 2 months ago

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