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

          Long meetings (6-7 hours a day): Being “babysat” by supervisor

          Image
          Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote 31 down vote favorite 4 I hold a PhD in mechanical engineering with a 7 year background in self-guided, self-paced research including 2 years as a graduate level course instructor and a subject matter expert for various engineering projects in a university setting in the United States. For the last 10-11 months, I am working in a research industry in France where my task is to debug C++ spaghetti code written over a period of several years by my current supervisor. It is a team of 2: just I and my supervisor. Diurnally, I am posed with a "bug of the day" to get out of this C++ code. My supervisor generally gives me about 15-30 minutes to solve it and then accosts me about whether or not the task is completed and then rinses and repeats this until the end of the day. Off-late, my supervisor has been holding 6-7 hour long "meetin
          Read more

          Is the Concept of Multiple Fantasy Races Scientifically Flawed? [closed]

          Image
          Clash Royale CLAN TAG #URR8PPP up vote 2 down vote favorite Many fantasy worlds have multiple humanoid species (elves, orcs, humans, etc) living in the same world, in addition to that, they often have the ability to interbreed. And I can't help but question their believability... fantasy-races reproduction interspecies-relations share | improve this question edited Aug 9 at 14:46 Michael Kjörling ♦ 21.1k 10 85 161 asked Aug 9 at 13:13 Chlodio 118 6 closed as unclear what you're asking by MichaelK, Gryphon, John, Vincent, Frostfyre Aug 9 at 15:25 Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question. 3 Stack Exchange exist to
          Read more

          Confectionery

          Image
          Prepared foods made with a lot of sugar or other cabohydrates "Sweetmeat" redirects here. For the racehorse, see Sweetmeat (horse). Not to be confused with Sweetbread. This Kransekake is a traditional Scandinavian baker's confection. Confectionery is the art of making confections , which are food items that are rich in sugar and carbohydrates. Exact definitions are difficult. [1] In general, though, confectionery is divided into two broad and somewhat overlapping categories, bakers' confections and sugar confections. [2] Bakers' confectionery, also called flour confections , includes principally sweet pastries, cakes, and similar baked goods. Sugar confectionery includes candies ( sweets in British English), candied nuts, chocolates, chewing gum, bubble gum, pastillage, and other confections that are made primarily of sugar. In some cases, chocolate confections (confections made of chocolate) are treated as a separate category, as are sugar-free versions of
          Read more