FME geometry conversion from string?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
2
down vote

favorite












I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the left and format I need it in is on the right.



enter image description here



I can use the following FMW workflow to get the correct coordinates and export to xlsx without issue.



enter image description here



However, when I try to reproject the coordinates within the same workflow I can't get it to work?



This is what I'm trying to do



enter image description here



When I open up the exported xlsx I get the same coordinates? (like no reprojection has happened?) Any ideas what I'm missing?



(on a side note, if I open up the exported xlsx file in a new workbench and run the reprojector it works perfectly)






geometry fme excel geometry-conversion string







share|improve this question









New contributor




user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.























    up vote
    2
    down vote

    favorite












    I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the left and format I need it in is on the right.



    enter image description here



    I can use the following FMW workflow to get the correct coordinates and export to xlsx without issue.



    enter image description here



    However, when I try to reproject the coordinates within the same workflow I can't get it to work?



    This is what I'm trying to do



    enter image description here



    When I open up the exported xlsx I get the same coordinates? (like no reprojection has happened?) Any ideas what I'm missing?



    (on a side note, if I open up the exported xlsx file in a new workbench and run the reprojector it works perfectly)






    geometry fme excel geometry-conversion string







    share|improve this question









    New contributor




    user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.





















      up vote
      2
      down vote

      favorite









      up vote
      2
      down vote

      favorite











      I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the left and format I need it in is on the right.



      enter image description here



      I can use the following FMW workflow to get the correct coordinates and export to xlsx without issue.



      enter image description here



      However, when I try to reproject the coordinates within the same workflow I can't get it to work?



      This is what I'm trying to do



      enter image description here



      When I open up the exported xlsx I get the same coordinates? (like no reprojection has happened?) Any ideas what I'm missing?



      (on a side note, if I open up the exported xlsx file in a new workbench and run the reprojector it works perfectly)






      geometry fme excel geometry-conversion string







      share|improve this question









      New contributor




      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the left and format I need it in is on the right.



      enter image description here



      I can use the following FMW workflow to get the correct coordinates and export to xlsx without issue.



      enter image description here



      However, when I try to reproject the coordinates within the same workflow I can't get it to work?



      This is what I'm trying to do



      enter image description here



      When I open up the exported xlsx I get the same coordinates? (like no reprojection has happened?) Any ideas what I'm missing?



      (on a side note, if I open up the exported xlsx file in a new workbench and run the reprojector it works perfectly)






      geometry fme excel geometry-conversion string




      geometry fme excel geometry-conversion string






      share|improve this question









      New contributor




      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 7 hours ago









      Vince

      14.2k32445




      14.2k32445






      New contributor




      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 8 hours ago









      user2803487

      111




      111




      New contributor




      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user2803487 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          2
          down vote













          First, I'd recommend using an ExpressionEvaluator or AttributeManager to calculate the correct coordinates instead of using StringReplacers. e.g. @Value(Y) / 1000 + 5000000
          Second, since you're writing out to Excel, just use an AttributeReprojector instead of the VertexCreator and Reprojector. Are you writing out to a new Excel file?






          share|improve this answer




















          • I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
            – user2803487
            7 hours ago

















          up vote
          2
          down vote













          Your reprojected features are not being written. The excel writer is likely writing attributes only.
          After the reprojector try adding a coordinateextractor to populate attributes with the point lat/long and this should let the writer do its stuff.






          share|improve this answer






















          • That's done the trick Jim. Thanks for the quick reply :)
            – user2803487
            7 hours ago










          • If this reply answered your question, please accept it as per the site guidelines.
            – Fezter♦
            5 hours ago










          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "79"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );






          user2803487 is a new contributor. Be nice, and check out our Code of Conduct.









           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f300928%2ffme-geometry-conversion-from-string%23new-answer', 'question_page');

          );

          Post as a guest

















          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          2
          down vote













          First, I'd recommend using an ExpressionEvaluator or AttributeManager to calculate the correct coordinates instead of using StringReplacers. e.g. @Value(Y) / 1000 + 5000000
          Second, since you're writing out to Excel, just use an AttributeReprojector instead of the VertexCreator and Reprojector. Are you writing out to a new Excel file?






          share|improve this answer




















          • I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
            – user2803487
            7 hours ago














          up vote
          2
          down vote













          First, I'd recommend using an ExpressionEvaluator or AttributeManager to calculate the correct coordinates instead of using StringReplacers. e.g. @Value(Y) / 1000 + 5000000
          Second, since you're writing out to Excel, just use an AttributeReprojector instead of the VertexCreator and Reprojector. Are you writing out to a new Excel file?






          share|improve this answer




















          • I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
            – user2803487
            7 hours ago












          up vote
          2
          down vote










          up vote
          2
          down vote









          First, I'd recommend using an ExpressionEvaluator or AttributeManager to calculate the correct coordinates instead of using StringReplacers. e.g. @Value(Y) / 1000 + 5000000
          Second, since you're writing out to Excel, just use an AttributeReprojector instead of the VertexCreator and Reprojector. Are you writing out to a new Excel file?






          share|improve this answer












          First, I'd recommend using an ExpressionEvaluator or AttributeManager to calculate the correct coordinates instead of using StringReplacers. e.g. @Value(Y) / 1000 + 5000000
          Second, since you're writing out to Excel, just use an AttributeReprojector instead of the VertexCreator and Reprojector. Are you writing out to a new Excel file?







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 7 hours ago









          Dan Iseminger

          362




          362











          • I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
            – user2803487
            7 hours ago
















          • I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
            – user2803487
            7 hours ago















          I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
          – user2803487
          7 hours ago




          I will check it out Dan, I haven't been convinced about the string replace transformer, It was just something I could do quickly. Eventually, I will be posting into AGOL but I was just trying to get the reprojection happening first!
          – user2803487
          7 hours ago












          up vote
          2
          down vote













          Your reprojected features are not being written. The excel writer is likely writing attributes only.
          After the reprojector try adding a coordinateextractor to populate attributes with the point lat/long and this should let the writer do its stuff.






          share|improve this answer






















          • That's done the trick Jim. Thanks for the quick reply :)
            – user2803487
            7 hours ago










          • If this reply answered your question, please accept it as per the site guidelines.
            – Fezter♦
            5 hours ago














          up vote
          2
          down vote













          Your reprojected features are not being written. The excel writer is likely writing attributes only.
          After the reprojector try adding a coordinateextractor to populate attributes with the point lat/long and this should let the writer do its stuff.






          share|improve this answer






















          • That's done the trick Jim. Thanks for the quick reply :)
            – user2803487
            7 hours ago










          • If this reply answered your question, please accept it as per the site guidelines.
            – Fezter♦
            5 hours ago












          up vote
          2
          down vote










          up vote
          2
          down vote









          Your reprojected features are not being written. The excel writer is likely writing attributes only.
          After the reprojector try adding a coordinateextractor to populate attributes with the point lat/long and this should let the writer do its stuff.






          share|improve this answer














          Your reprojected features are not being written. The excel writer is likely writing attributes only.
          After the reprojector try adding a coordinateextractor to populate attributes with the point lat/long and this should let the writer do its stuff.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 7 hours ago

























          answered 7 hours ago









          JimT

          1,013417




          1,013417











          • That's done the trick Jim. Thanks for the quick reply :)
            – user2803487
            7 hours ago










          • If this reply answered your question, please accept it as per the site guidelines.
            – Fezter♦
            5 hours ago
















          • That's done the trick Jim. Thanks for the quick reply :)
            – user2803487
            7 hours ago










          • If this reply answered your question, please accept it as per the site guidelines.
            – Fezter♦
            5 hours ago















          That's done the trick Jim. Thanks for the quick reply :)
          – user2803487
          7 hours ago




          That's done the trick Jim. Thanks for the quick reply :)
          – user2803487
          7 hours ago












          If this reply answered your question, please accept it as per the site guidelines.
          – Fezter♦
          5 hours ago




          If this reply answered your question, please accept it as per the site guidelines.
          – Fezter♦
          5 hours ago










          user2803487 is a new contributor. Be nice, and check out our Code of Conduct.









           

          draft saved


          draft discarded


















          user2803487 is a new contributor. Be nice, and check out our Code of Conduct.












          user2803487 is a new contributor. Be nice, and check out our Code of Conduct.











          user2803487 is a new contributor. Be nice, and check out our Code of Conduct.













           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f300928%2ffme-geometry-conversion-from-string%23new-answer', 'question_page');

          );

          Post as a guest
































































          Comments

          Post a Comment

          Popular posts from this blog

          What does second last employer means? [closed]

          Image
          Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote -3 down vote favorite Say, for example I have worked in the following companies, Company A => 2010 - 2011 Company B => 2011 - 2012 Company C => 2012 - Till Date Company D => Have offer Now assume Company D is asking to submit documents from my second last employer. So from the list of companies given, which company would be qualified as second last employer? software-industry employer share | improve this question asked Aug 10 '14 at 5:16 Rajaprabhu Aravindasamy 559 1 6 13 closed as off-topic by Jim G., jmort253 ♦ Aug 11 '14 at 1:58 This question appears to be off-topic. The users who voted to close gave this specific reason: "Questions seeking advice on company-specific regulations, agreements, or policies should be directed to your manager or HR department. Questions that address...
          Read more

          Installing NextGIS Connect into QGIS 3?

          Image
          Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote 1 down vote favorite Just acquired free version of NEXTGIS and trying to install the plugin for QGIS. It tells me it was not designed for version 3 of QGIS. How do I set up the QGIS-NEXTGIS interface then? qgis qgis-plugins nextgis share | improve this question edited 3 hours ago PolyGeo ♦ 51.9k 17 77 233 asked 4 hours ago IanGS 16 4 New contributor IanGS is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. add a comment  |  up vote 1 down vote favorite Just acquired free version of NEXTGIS and trying to install the plugin for QGIS. It tells me it was not designed for version 3 of QGIS. How do I set up the QGIS-NEXTGIS interface then? qgis qgis-plugin...
          Read more

          One-line joke

          A one-liner is a joke that is delivered in a single line. A good one-liner is said to be pithy - concise and meaningful. [1] Comedians and actors use this comedic method as part of their act, e.g. Jimmy Carr, Tommy Cooper, Rodney Dangerfield, Norm Macdonald, Ken Dodd, Stewart Francis, Zach Galifianakis, Mitch Hedberg, Anthony Jeselnik, Milton Jones, Shappi Khorsandi, Jay London, Mark Linn-Baker, Demetri Martin, Groucho Marx, Dan Mintz, Emo Philips, Tim Vine, Steven Wright and Henny Youngman and Arnold Schwarzenegger. [ citation needed ] Many fictional characters are also known to deliver one-liners, including James Bond, who usually includes pithy and laconic quips after disposing of a villain. [ citation needed ] Examples "A baby seal walks into a club." "A dyslexic man walks into a bra." (Anonymous) "There are three types of people, those who can count and those who can't." "Venison's dear, isn't it?" (Jimmy Carr) "An escala...
          Read more