Transformers

I have a linear input file from a survey depicting the edge of roads, that requires writing to a polygon feature class. The problem is the source data lines are not closed and very fragmented. I have tried combinations of areabuilder/linecloser/donutbuilder/geometrycoercer and neighborfinder/vertexcreators/geometrycoercer to join these lines together unsucessfully, Please see screenshot of sample data, anyone have any ideas?

I have a application that is calling FME server by sending ESRI JSON as a parameter and returning a zipped shapefile download url. This is working fine as a job submitter but failing as a data download. The succeeding json cmd line arguements in the job log are structured like : `--JSON_Text' `<opencurly><quote>displayFieldName<quote>:The failing json like:`--JSON_Text' `{"displayFieldName":The error is:The clause '@EvaluateExpression(FDIV,STRING_ENCODED,{displayFieldName:agn_name...,JSONFlattener) READ_FROM_FILE NO FILEPATH_OR_URL <Unused> EXPLODE_QUERY json RECURSIVE_FLATTEN NO ERROR_LIST_ATTR _json_error OUTPUT EXPLODED FEATURE_TYPE JSONFlattener_OUTPUT OUTPUT REJECTED FEATURE_TYPE JSONFlattener_<REJECTED>' is incorrect. The parameter to JSON_DOCUMENT must be a constant value, a value-of (&) attribute, or an FME function call Is it possible to handle this problem on the FME end? More info here https://github.com/geocortex/workflow-activities-fme/iss

What is the best way to calculate the most efficient way for a garbage truck to travel on a road network in such a way that it covers both sides of the road. So it needs to travel each road in both directions and cul-de-sacs just once (around). Is there an example of someone having done this? The standard way calculates from point a to b but doesn't take into account street sides. Thanks

Hi,I would like to know how I can extract the Coordinate System information contained in the header of several ecw files, using as a writer a xlsx or txt file. Thanks!

I'm wondering if it's possible in FME to perform a dynamic segmentation on an LRS event with an offset to the output line geometry.  What I mean by this is I'd like the result geometry to be beside the base geometry, parallel to it and a distance away. For example, here's my base LRS geometry, going from 0 to 10 meters. Here's the event I'd like to perform the dynamic segmentation on, with a start measure of 0 and and end measure of 5. This is what I'd to have. A line going from 0 to 5 meters, located to the left of the base LRS geometry. Is it possible to do something similar to this in FME?

I think this has crept in since the first release of FME 2018.I have a SQLCreator with a perfectly valid MS SQL query, however when I run the workspace (either in Workbench or in FME Server) it reports warnings in the log file: "Query failed possibly due to a malformed statement", which is not true. So here is the SQLCreator with the query. If I press the Run button to check syntax it reports Successful.And here is the same query in SQL Server Management Studio, it also reports successful.However if I run the workspace I always get a warning that the query failed due to being malformed.You will also notice in the log, FME injects its additional SQL around my original SQL statement (perhaps this the the cause of the failure warning)? The last line in the screenshots reports that the data read was successful. So the issue I have is this: even though the workspace runs OK, when examining log files I'm never really sure if there is indeed a genuine syntax error with the SQ

The problem:I have two lists which are related to each other by way of index so lets say we have the following format - List 1 (contains 4 Elements)List 2 (contains 4 Elements) The Elements in each list relate to one another so Element 0 in List 1 is directly relatable to Element 0 in List 2. Element 1 in List 1 is directly relatable to Element 1 in List 2 and so on and so forth for the rest of the Elements. What I'd like to Achieve:If any Element stored in List 1 = "foo" -- I would like to remove it as well as the related Element in List 2. I think this is easily achieved if it is possible to extract not just the attribute of the Element in the lists, but the Element Index as well. How do I do this? I am able to extract the attribute name of each Element easily by using:my_list = feature.getAttribute('my_list{}) Thanks in Advance. 

I am using the HTTPCaller transformer to perform a GET. How do I take the response and pull out specific attributes and their values?  For example, I pass in a list of 5 asset numbers to the HTTPCaller. It performs the GET to return all associated information for each of those assets. I need to pull out, from the response body, only the assetnum and status.

Hi everyone. I'm using the FGDB Open API writer in 64-bit FME 2020.1 (build 20624) to write an FGDB table (no geom). I have 2 "double" type fields in the FGDB table which are set to allow NULL values (I've checked in ArcCatalog). When I run my Workspace, FME refuses to write features to the FGDB table which have NULL values for the "double" fields. I have tried ensuring the values are NULL using a NullAttributeMapper before the Writer, but it hasn't made any difference. I have also tried using the other FGDB Writer - the one that uses ArcGIS Desktop, which seems better - I just need to fix some features which have "null" instead of NULL to complete the testing. Has anyone else experienced this difference between the FGDB writers?

Is it possible to create one dynamic reader for DGN files, which will use different schemasfrom input DGN files? I do not want to lost any kind of data from next readen DGN file schemas using this reader. As usual I read DGN files and sometimes this reader can not load some data from them. I only change the path of the next DGN file to process. 

Hi, I have a workspace that downloads two different files (1 geopackage, 1 textfile), renames them and stores them in a ZIP file. Said ZIP should contain the current date in its filename. Normally I use the date/time functions in the filepath paramters to create the current date on the fly but the options in "Destination Fanout Directory" do not offer these functions. As a workaround a created a Text Parameter where the user enters the current date manually but if possible I would like to do this automatically. Can this be done somehow?

Hello, I'm looking for a method that will allow me to extract a summary from a JSON, but due to the size of each JSON, fragmenting the data first would be extremely time consuming.  For a bit of background, I want to extract daily data from the WebTRIS traffic counter API, with the aim of creating a summary of average traffic speed for the sites in question. The API allows for the download of multiple report styles, however only the daily report allows for the extraction of average speed. The report provides data at 15 minute intervals for each counter for the periods of time that the counter is active. If I wanted to extract the average traffic speed over a year, assuming the counter was active for the whole year, this might mean summarising 35,040 records, per site.  I've looked at using the JSON fragmentor, but due to the potential size of the data that would require summarising, this would create an excessive number of records per site. What I would ideally like to do is to

Hello, I want to develop FME page to check the CAD layer names if it's match the layer standard name! and then give a result "approved" or "Reject"If "Approved" then convert CAD to GIS and add the data automatically to the GDB. IF "Reject" shows the layer names that should be fixed.How we can do this in FME? Thanks,

Is there a trick on how to read and count points with a classification flag? This link (http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/las/quick_facts_las.htm) seem to indicate that there is but I can't find any transformer that does. Classification_flag is not part of the different field available in PointCloudPropertyExtractor. Writing "classification_flags" manually does seem to output a few things, but it only seems to be a 0 (there's no flags) or 1 (there's flags) kind of thing. ==1, ==2. ==3 doesn't output anything. How to count flags like in LASinfo?  

I am currently working with a number of 3D models that I need converting from CityGMLs to SLPKs (ESRI Scene layer packages) to be brought into ArcPro. I have found two ways to do this:1) firstly I can write to a File Geodatabase in FME before importing the file into ArcPro and performing the conversion to an SLPK there using the 'Create 3D Object Scene Layer Package' tool.or2) I can write directly to an SPLK in FME using the 'Esri Indexed 3D Scene Layer' writer. Ideally I would like to use the latter of the methods as it removes a step from the process however I have noticed that there are differences between the datasets being produced from each method.  When both files are loaded into ArcPro, the SLPK created in ArcPro renders very nicely with all elements being displayed, while the SLPK created in FME sees alot fo the elements appear and re-appear at diferent zoom levels - I am just wondering why this might be?

Currently I have few attributes that are saving row by row but raster images are saving one on another. Is there any way to save image into same rows like attributes?

I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew

With this Expression I get the max-value of the 5 first List-values.@max(@Value(FID{0}.FID),@Value(FID{1}.FID),@Value(FID{2}.FID),@Value(FID{3}.FID),@Value(FID{4}.FID)) But the features have different List-Numbers. Some of them 5, some of them more than 5. Is there a way to express not hard-coded? Where the Number of List-entries can be dynamic? My solution to get the maximum value was the Listsorter. But I wonder, if there is a way with the ExpressionEvaluator. An expression which is not hard-coded seems to be very powerfull.Thanks for help!

I am using a few check boxes at the Run window to let the user choose a few different things. I'd like different action to result from whether a tick box is checked or not. I can do that ok using a Tester and checking if the user Parameter is YES or NO, and the test works well, but this gets ignored by a FeatureMerger a bit later. The workbench somewhat carries on no matter what the test result is.  The end goal is to only create attributes if the user tick a box or not. Are there examples of that?   No features should go to the bookmark in yellow, but it does anyway despite failing the test. And the FeatureMerger returns empty values of course. I'd like to get rid of the Attribute with empty values before they get exported. What's the best way to do that? Let it merge then remove the attribute? if user-parameter is NO -> AttributeRemover on X I'd be a lot easier with Python, am i missing something obvious? I tried this but can't make it work: https://community.s

I have an FME process that updates one Oracle table from another via a ChanageDetector process. I notified the DBA that the table I am reading from is missing a field. The DBA created a able VIEW with the missing field and advised I use that to update the other table.  I don't see Oracle table VIEWS as an option in the Reader I am using. Can an Oracle table VIEW be used in a Reader? If so, how is that accomplished?Thanks in advance.

I have three datasets and there can be a possibility that the features that can be present in one dataset can also be another datasetThese type of features which shares same location should form one cluster.Similarly datasets that have same locations should be in one cluster and I need the count of clusters of all three datasets

I am working on a longterm project that will take csv files, turn the data into fme points and then use them to publish an agol web map. I have been trying to play around with the agol writer to publish the new feature layer. Whenever I use the writer to create a new feature layer, the data is lost, somewhere in the process and i get a blank layer with no data in it. Furthermore, when I try to insert data into these layers, nothing happens, the writer says it runs successfully but there will be no new data in the tables, they will remain blank. The final goal of this project as I said is to take csv data files containing point data and automate the process of making a web map with them. Is FME's writer unfeasible for this task? Do i need to accomplish this goal using Arcgis REST Api? The CSV datafiles typically contain the following: Latitude, Longitude, Object ID, Completion Status, Address, and a notes field. If I need to use python, how do I write my code so that it will use the

Hi all, I need clarification whether FME supports migration of Smallworld Electric Office data to ESRI Utility Network. Any lead in this aspect will be quite helpful. Please share if any portal is available as reference.

Hello,I'm having difficulty getting the results I want out of the Spatial Relator and AreaOnAreaOverlayer. Essentially, I'm trying to identify overlapping polygons within the same layer, where the overlap area is of a significant size, so that I can separate these out into separate layers in a fan out at the end of the process. I want to do this by creating a field and populating that with a value, where the first / bottom polygon remains in the original layer, but additional overlapping polygons are allocated an increasing number so they can be separated into a new layer - all the '0's, '1's and '2's together. I don't want to identify or attribute what are essentially topology errors (very slight overlaps), as these need to be reviewed and fixed manually, just what are considered 'legal' overlaps so they can be topologically cleaned separately. I have an (incredibly bulky and inefficient) solution, using both SpatialRelator and AreaOnAreaOve

Hello.  I would like to remove (replace with no text) everything what is after dash also with the dash. What I have: test - fmeWhat I want: testCheers, Oliwer