Skip to main content
Question

Shapefile Reader - dot in numeric field


Hello,

 

i have question and problem with ShapeFile Reader.

I have a lot of data with Numeric field N,12,6 (location_x, location_y, location_z). But separator is set with "," not "."

FME is cutting my data.

Problem 

Can somebody help mi with this issue? In previous version was parameter "Numeric Attribute Type Handling" but for now it's not accessable. 

QGiS is correctly reading numeric values.

 

9 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

I can reproduce this in 2021.1, but in the FeatureReader I can switch the Reader Parameter "Numeric Attribute Type Handling" from "Standard Types" to "Explicit Width and Precision" which seems to fix this.

2021-07-09_14h03_33I can't find this setting in the classic reader, maybe this is a bug?


Yes, you're right, but it doesn't help to correct read data :(


nielsgerrits
VIP
Forum|alt.badge.img+54
nielsgerrits wrote:

I can reproduce this in 2021.1, but in the FeatureReader I can switch the Reader Parameter "Numeric Attribute Type Handling" from "Standard Types" to "Explicit Width and Precision" which seems to fix this.

2021-07-09_14h03_33I can't find this setting in the classic reader, maybe this is a bug?

Template included.


nielsgerrits
VIP
Forum|alt.badge.img+54
marekszczepan wrote:

Yes, you're right, but it doesn't help to correct read data :(

This probably is an issue, because this works as expected in 2019.1.

You might want to Submit a Case.


hkingsbury
Celebrity
Forum|alt.badge.img+55
  • Celebrity
  • July 12, 2021

Could it be a local issue? European vs US number formatting?

1,000,000.99 (US) == 1.000.000,99 (European)

 

https://www.languageediting.com/format-numbers-eu-vs-us/


I don't think so, i tried with different setting, but it didn't have influance on this shapefile


geomancer
Evangelist
Forum|alt.badge.img+50
  • Evangelist
  • July 13, 2021

It seems your Z values are imported correctly, and only your X and Y values are changed. So maybe the Z attribute contains a different separator from your X and Y attributes?


unfortunatelly not, i checked in DBF file and columns definitions and separators are the same. Only number of digits are different

 

Strange issueobraz_2021-07-13_140048


geomancer
Evangelist
Forum|alt.badge.img+50
  • Evangelist
  • July 13, 2021

Alas! As you are reading point features, a pragmatic solution may be to just recalculate your X and Y attributes in an AttributeManager with @Evaluate(@XValue()) and @Evaluate(@YValue()).


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings