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)










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)










    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)










      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






      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













































































          Popular posts from this blog

          How to check contact read email or not when send email to Individual?

          Displaying single band from multi-band raster using QGIS

          How many registers does an x86_64 CPU actually have?