FME Form

Hi folks,Let's call this edition of What's Up Wednesday the "GIS Day Special" - although by the time I finished writing it's more like a "Meme Special"! 32-Bit DeprecationIn case you missed it, external factors mean that we've had to bring forward the deprecation of FME on Windows 32-bit. FME 2021.2 will be the last FME version to support 32-bit! FME 2022 onwards will be 64-bit only. Most formats already worked on both 32- and 64-bit platforms, including ones you might think of as mostly 32-bit, such as File Geodatabase, Microsoft Access, and Smallworld.  But some formats are 32-bit only and will therefore be missing from future FME versions. We will try and supply patches (to 2021) if necessary and where possible, but we really do encourage users to upgrade to 64-bit. For more information,

FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this  

FME Desktop 2020: Deaggregating the result of clipper tool produces extra unexpected polygons, I’m wondering why deaggregating the inside result of the clipper tool produces extra unexpected polygons. I’m expecting to have exactly 8 polygons while the result is 12 What could be the issue here? The workbench and the dwg file are attached          

FME 2020: How to join the none intersecting lines? In the screenshot below, I wanted first to break at intersection and then to join the none intersecting lines. How this can be performed in FME to end up with 4 lines?     

AttributePivoter has started failing with a "WARN |Python Exception <TypeError>: '<' not supported between instances of 'str' and 'float'".Prior to sending features into AttributePivoter I validate the features and they all pass as numeric .I am aware of numerous workarounds and custom transformers - I am just curious about this error.I hope the image is sufficient information - the Transformer Parameters are on the left hand side. PS: I tried numerous python installations - including my OSGEO4W 3.7 - and both FME 2020 and FME 2021.

convert Using XML hierarcy(parent-child id) to relational database(postgresql) tables

I Run a job from FME server but it just ends up in the que and do not execute. I have published a workspace from the training environment so it should work? Why is it not starting to run?

The attached data has 164028 rows but only 134483 row are actually read. I can import using Excel and this has the correct amount of data but if I use FME I get less, anyway I can resolve this? I have also attached the parameters I used. Cheers

Hello,  I use one featureReader to load Oracle spatial data on my workspace. How can i choose my geometry like the oracle spatial reader ? By defaut fme read the first geometry field.  Thank you

Error message:ArcGIS Online Feature Service Writer: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services.arcgis.com', port=443): Max retries exceeded with url: /BLN4oKB0N1YSgvY8/arcgis/rest/services/CalOES_Evacs/FeatureServer/0/applyEdits?f=json&token=mL3ovIy1sDWEeKZf8I_hNgrP8RNVQ2LuK1AoOdpsOmPJQC3fwycVaePeFqqVF5juSz3eo9-OAgfgz8Po5I2J6OWUgjUz-V0Uw_OasaRYY2AQf3W1O1R0RjnpUoDIL9dFcXrP11eThAsyBkCQwo37gzZ6yGyPHuRfBc3rBd6ddxrdhmfSIjwBEfm0Ne1L_lalIOLytVjsalnqV5QzuE2VRZSLQwbHZM86QjYSc7esV-EZlRpxjI3bbjLwYLI0qMnQB4UZeKOmkhhviYwuqqJU-HPfpk8OuSgPTBLSSyodMSU. (Caused by ProtocolError('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None)))'ARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for detailsA fatal

As an example, in Excel you would use the filter function and select specific values from the drop down menu across multiple columns. How in FME do you filter rows of data based on attributes held in multiple columns? I've looked at the two SQL translators; SQLCreator and SQLExcuter but both need connecting directly to a database. In my case I need to use the transformer within my workflow. Thanks.

Hi FME Community,I have a column with number. I want to add a dot to the last three numbers.the pictures show what I expect as a result:what I have:Thanks in advance :)

I am trying to use the Attribute filter to only see the columns i'm interested in (those containing the text 'lith') and using it's _element_index to filter the columns (lists). Its not working and I'd like some help or advice on better ways to solve this problem. The job will read in a database table of values to check against, but i'm not there yet as I first need to find / isolate the relevant columns of interest. I attach the text file & workbook for reference Thanks

Hi all, InlineQuerier doesn't give the last two outputs ? 

I want to create dwg's with object data with FME. The problem I run into is that the names for the layers and the object data table end up being the same, which makes the data hard to use in Autocad Map 3D. I have attached an example workspace to illustrate my problem. What I would like to achieve in this setup would be for the output file to be identical to the input. For this example I start with a dwg with one object data table Vegetation and two layers, Bos_groen and Ruw gras_groen. I read this, do nothing else, and write it to a new dwg. My end result has both polygons in the right respective layer, but their attributes in two different object data tables, with the names from the layer.  My problem is illustrated in two screenshots. In my sourcefile Object data table and and layer are distinct values, Vegetation and Ruw gras_groen respectively.

while i am trying to insert a record in a branch version of sde default using  ArcGIS Portal Feature Service Writer i am getting following error ArcGIS Portal Feature Service Writer: Writing features for layer/table '*****', with 1 inserts, 0 updates, and 0 deletesArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'Unable to perform applyEdits operation.'

Hi, We have an FME workbench to extract features from PostGIS, run through a GeometryValidator to identify and repair features, then written to an ESRI geodatabase. However when loading features from the Geodatabase in ArcMap, some features are prevented from loading due to geometry errors, such as self intersects. Is there a way to configure FME to match the geometry validation routine performed by ESRI and if possible repair these?

FME 2020: The “ArcSDEGridSnapper” tool appears not to be available, I couldn’t figure out why the “ArcSDEGridSnapper” tool appears not to be available 

Jag vill flytta min licens från en dator till en annan. Måste jag ta med hela programvaran eller kan flytta licensen mellan datorerna ändå?

I am not able to get the result that i want :i would like to have the same value of difference column for the same id but it depends on larger lengths for id_counter column .when we compare the row no.3 and row now.4 for id = 6so the output should be for first row id_counter = 1 /lengths = 2 /ID = 6/ difference = goodand the other row for the same id will be still the sameand the same idea with all rows . if the value in difference column is the same for the same_id so the program should do nothing and keep it .i was thinking to do it with matcher but i could not get the correct result .thanks for help fme 2018

This is more of a hypothetical question, I don't have a problem that needs solving, but am pondering the possibilities and limits of FME.What are the strategies to process huge datasets? I would imagine that there is a limit to the resource management that FME can do on its own? At some point the software might need some "help" in order to break down the data in manageable chunks? How is this done? Tiling? Memory management? Renting a super computer? Etc?Trying to think of an example I came up with the following idea. How would one go about generalizing the contour lines for a whole country in one run without watching life go by? Please note that I am not asking about how to generalize, my question is what strategies there are to speed up huge processing operations similar to the example above?

I tried to configure a http web-connector but without success. Does somebody know how to solve this?

I have multiple JPEG with corresponding location information in csv file. can anyone suggest me how to geotag those images?

Hi,We are looking to decrease the total time converting from Geotiff tiles to CADRG. The bulk of the time is in the CADRG writer. Are there any ways to process frames in parallel?If we divided the region into smaller regions and created multiple CADRG output sets simultaneously could we then merge them together?Are there any other parameters we could try settings to increase performance?Processing a 300x300 nautical mile region takes around 6 hours using a TC map type. Is that normal given the size of the input region and requested map type (resolution)?Thank you.

I have a workspace where I have lines that are clearly duplicated but the matcher does not identify them because the coordinates are flipped on one versus the other. Is there a way to identify duplicate geometries for lines regardless of whether the coordinates are flipped. For example: Line 1Coordinate 0 = 1973175.975504196, 1785187.3988771015Coordinate 1 = 1973164.445329631, 1784950.337012621 Line 2Coordinate 0 = 1973164.445329631, 1784950.337012621Coordinate 1 = 1973175.975504196, 1785187.3988771015 Both lines are identical, however the direction of one is different from the other. So how can I eliminate one of these based solely on geometry.