Skip to main content
Solved

Weird issue, why does this happen ? Excel, WGS84 coordinate, VertexCreator, invalid parameter Y or X

  • September 22, 2021
  • 3 replies
  • 107 views
essb
Contributor
  • essbContributor
  • Contributor

Hi

 

I want to know why this happens so I can correct it in the feature. I attached the example file "Excel" containing only one row so you can test for yourselfs.

 

In Excel both coordinates have comma.

excelWhen I use Excel Reader in FME it changes only attribute value for attribute aa to a dot. But for bb its still a comma.

fme_excelThis is maybe why I cant create a point using vertex creator, even tho I use string-replacer to change both values to dot or comma it refuses to create a point.

fme_screenshot 

This happens fairly often so It would be nice to know what cause this issue and how I can solve it.

 

It might be a bug or something to do with Excel. If I create a new excel file and manually enter every value then it suddenly works. But this is not something I can do with an Excel containing thousands of rows.

 

Iam using Fme 2020.2.5.0 Build 20827 - WIN64

 

 

 

Best answer by danilo_fme

Hi @essb​ 

 

I used the transformer StringReplacer for replacer all attributes that has " , " change automatically for " . " .

 

After I used the transformer AttributeTrimmer for elimate spaces into attributes:

Workspace_String 

Attached the Workspace template (.FMWT ).

 

 

Thanks in Advance,

Danilo

 

 

View original
1 Attachments
Did this help you find an answer to your question?

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • Best Answer
  • September 22, 2021

Hi @essb​ 

 

I used the transformer StringReplacer for replacer all attributes that has " , " change automatically for " . " .

 

After I used the transformer AttributeTrimmer for elimate spaces into attributes:

Workspace_String 

Attached the Workspace template (.FMWT ).

 

 

Thanks in Advance,

Danilo

 

 

essb
Contributor
  • essbContributor
  • Author
  • Contributor
  • September 22, 2021
danilo_fme wrote:

Hi @essb​ 

 

I used the transformer StringReplacer for replacer all attributes that has " , " change automatically for " . " .

 

After I used the transformer AttributeTrimmer for elimate spaces into attributes:

Workspace_String 

Attached the Workspace template (.FMWT ).

 

 

Thanks in Advance,

Danilo

 

 

Ah, dumb me! it was a hidden character in front of 18,01757! I actually feel embarrassed now for not even thinking about that possibility :D

 

Thanks alot for solving it so fast. Now I know how to handle cases like this.

 

Problem solved.

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • September 22, 2021
essb wrote:

Ah, dumb me! it was a hidden character in front of 18,01757! I actually feel embarrassed now for not even thinking about that possibility :D

 

Thanks alot for solving it so fast. Now I know how to handle cases like this.

 

Problem solved.

Thanks your reply! :)

 

I'm happy to help you!

Reply


Helpful Members This Week

Community Stats

31,354
Posts
118,936
Replies
38,972
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.