Transformers

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

Hello all,I need to read glb-files and run a spatial transformation on it. Every glb shows one floor of a building with all its rooms. On the walls there are textures of photos so it looks like the view inside the room. The exterior walls show the same image as from the inner backside, because the building photos where only taken from inside, not from outside the building.FME can not read glb, so I tested some software to create different formats which FME can handle, like fbx and dae.When I look at the glb, fbx or dae in a 3D-Viewer, I can see the photo projections correctly. But in FME Inspector and after transforming the data to cesium 3D Tiles at exterior walls the inner room images are only shown outside. On the inner side there is the image missing.Is there a way to show the same images at the exterior walls and also at the inner side or change some settings so I can see the images only at the inner side and not outside?I am thankful for any help!Best regards, MiHue

I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.

Hi,I am trying to read data Oracle non spatial data from a View and create an output in Oracle Spatial.Although the process writes to the Oracle Spatial table and you can view the attribute data OK the data does not seem to be spatial and I can't see any data on a map. I have learned through passed experience that the Spatial Column must be changed from GEOM to SHAPENot sure if this is because i can't set the Eastings and Northings in the Reader to Types x_coordinate and y-coordinate?You can set in a CSV Reader but not Oracle? (if this is the issue)  Thanks