Transformers

Hello! I have a workspace selecting a feature then passing its geometry into a different workspace for analysis: However, I receive these messages and the second workspace doesn't run:WorkspaceRunner_CleanerUpperOfBatchesInitiator (CreationFactory): Created 1 featuresWorkspaceRunner_CleanerUpperOfBatchesDoWeNeedToDoIt (TestFactory): Tested 1 input feature(s) -- 0 feature(s) passed and 1 feature(s) failedWorkspaceRunner_CleanerUpperOfBatchesRunner (TestFactory): Tested 0 input feature(s) -- 0 feature(s) passed and 0 feature(s) failed Here is the Geometry Extractor: Here is the WorkspaceRunner:

AreaGapAndOverlapCleaner has turned on itself, see examples below. The changes occur within tolerances, but the transformer should only be modifying gaps between neighbouring polygons, not itself? I have checked incoming features with the GeometryValidator but can not find anything wrong with them.What is going on here? Before AreaGapAndOverlapCleaner (this is a river)  After (AreaGapAndOverlapCleaner thinks there is a drought and has turned the river into puddles) Before and after combined 

By referring to the article Creating a Custom Format and section Using the Custom Format Wizard, I have created a custom format along with few (Published) user parameters.However, when consumed the custom format via Workspace Resources of a new FME workbench, user parameters those were created in the custom format were not appearing. Did I

Hi, I'm following the FME Basic course, here exercise Flood Risk Project within the module Use Conditional Value. In the course text the Inspector result is shown in the picture attached here ("... Inspector according to exercise").However, in my FME the outcome is different (see "... Inspector"): other names and 3 items instead of 5 items.I checked the conditional values used in the AttributeManager several times, it is exact the same as in the course text (see "... Conditional Value" Any thoughts?

I have 3 tables, a linear tables of sections, a non geometric table of bus lines, and a intermediate table between both, with relations N:M. I need to merge the sections to get the geometry of bus lines. but some of the sections belongs to many bus lines, so I need to "duplicate" some of the sections. Any idea of how to get the geometry of bus lines? Thank you again

Hello,on the SchemaScanner transformer, in the data types section, there is a parameter to define the action to be taken for attributes with the value Missing/Null/Empty.When ignore is selected, if an attribute has no entry, it is excluded from the schema. This seems correct for Missing. But is this the case for Null and Empty?In the latter case, shouldn't the attribute remain in the data model?If not, what other prossibility exists for retaining an attribute that has no value entry in the data model? Best regardsPatrick

I am using the OpenAIChatGPTConnector in my workbench. I thought that I provided all the correct parameters. But I get the log error: OpenAIChatGPTConnector_HTTPCaller: An error occurred while accessing the URL 'https://api.openai... What might be wrong?

I want to generate a textured plane top-down projection from a mesh. Like a raster equivalent for the SurfaceFootprintReplacer, which would derive a footprint polygon. Is there a transformer for that use case?

Table 1 Table 2

I have an FME process that requires me to read in an AGOL feature service that includes attachments and write the data and attachments to tables in an Enterprise SDE database on our servers. I've gotten this entire process to work on a smaller copy of some of this data, but for some reason when I run the process on the larger set of the data, none of the attachments that exist on the hosted feature layer are read by the reader at all. I definitely have "Include Attachments" turned on, and I've exposed all of the attachment related attributes: everything is identical in the FME process to the one that functions properly. There are some minor differences in the way these layers were uploaded to ArcGIS online, so I'm just wondering if there's ANYTHING on that end that could be causing this problem.

Hi, I'm following the FME Desktop Basic training, now doing exercise "Flood Risk Project" (under "Use Conditional Values"). As it is clear that I'm newbie to FME, so maybe this is a stupid question: where can I find the parameter "Elevation"? See pics attached here. This parameter is not listed in the AttributeManager, nor in other Read items. The FME workspace can be found here. Maybe I overlooked something?

We had numerous SQL Creators based on JDBC connections that worked in both FME Desktop and FME Server. We are in the process of migrating our SQL Creators from JDBC to Microsoft SQL Server Non-Spatial (ADO). In doing so their SQL continues to perform well in Form, but now generates Warnings when executed on Flow. The Warning takes the following form:"Microsoft SQL Server Non-Spatial Reader: Getting Custom SQL schema failed. Custom SQL query 'SELECT ... WHERE ... ORDER BY ...' may execute in an unexpected manner. Make sure all columns are named (any ambiguous columns, e.g. GEOM.STBuffer(1), must have an AS clause). If there is an ORDER BY clause, either remove it or add a TOP clause." Removing the ORDER BY does eliminate the Warnings generated on Flow. However we enjoyed using the power of the database to presort the records prior to being transformed within the workspace.  Why is ORDER BY

How can I assign user parameters via a file? I have a large number of parameters and they all need to be pre-assigned. However, the content of the parameters can change. Therefore a variable solution is needed

Using string searcher with the search text LB I identified the number in the red box on the left. The number always contains the text LB and the same number of characters after LB. There are a lot of PDF's where the file names need to be changed to the LB number. Below I attached a screenshot in which I used a tester and a string searcher. I can find the LB number but how do I copy it to the writer name as output and how can I easiliy process aproximately 1000 pdf's in one go without manually changing parameters?

We have a selection of roughly 40,000 Uber H3 Hexagons. From this set we need to randomly choose 10 hexagons to perform a survey within, and would like to then select 10 more hexagons as alternates should one of the original 10 not be suitable for survey. Our first attempt used two Samplers. The first Sampler selected 10 features using the "Randomize Sampling". The second Sampler was fed from the NotSampled port of the first Sampler, and 10 more features were selected. Unfortunately both Samplers are selecting very similar patterns. Consistently, nearly every feature of the second sample is a neighbor of the first sample.  In our second attempt to get a more randomized pair of samples, rather than a repeated pattern, the first Sampler selects 20 randomized features. Those 20 are then fed to a second sampler to choose 10 from those 20. This approach generates what appears to be a more randomized sample of both primary and alte

I have prepared workbenches using FME 2022. Few days back, I have installed FME 2023 build 23603 FME 64bit. When I executed the workbench in latest version then translation is very slow when compared. I have crosschecked one again by running same workbench in FME 2022 and translation has completed as previously. Whether any other have encountered same issue??

I have made a beautiful Map using "HTMLReportGenerator". This Web Map contains coordinates of points or lines that I dont want to be shared with the World if I publish it online (because of data protection). Is there a way I can somehow make invisible those coordinates so that if I inspect the HTML page I will not be able to see all the coordinates ?

I have some database tables which contains a few so called "GeometryCollections". I try to use FME to find which objects are of that type so that I can fix them, but none of the alternatives in GeometryFilter will find the GeometryCollection objects. Any suggestions?

HelloI have a polygon, which is a single feature and need to clip it where the road name changesThe data i have is the polygons adjacent to the road, and the road centreline. I have created a centre line through the polygon, chopped that centreline into 1m segments and applied the nearest neighbour roadname to them.Any ideas how to chop the polygon where the name changes as shown in the redline on the image attached.Regards 

I understand can use the coordinateSwapper transformer to switch Y Z values in the wavefront obj file. But can I also change the sign of the y-values (says from -ve to +ve) as well?

 Hi, New to FME here. I have been tasked with creating a workbench to convert DWG to GIS (storm water asbuilts). Below is the autocad text string field which contains three rows. first structure name, Top elevation and on invert elevation. I would like to know a way to separate this into three fields. I have created the fields with Attribute manager but have no idea how to parse this out.  I was thinking it could be based on line row number? Since Multiple types of structures and line is always structure name, line 2 is always top, and line three is always Invert elevation.  Thanks! 

Dear Sir / Madam, So I have two excel tables. Mother name.xlsx is the original data and waterbody.xlsx is another table. So I would like to compare two excels. If both excels' column "ModelName" are matched. The mother name excel's model name column should change to newmodelname column. If not, just keep the original modelname. I try to use tester transformer but I am not sure why nothing can be matched. I hope someone can give me a hand. The output that I want is in the Output.xlsx Thank you very much. 

Hello Community, i want to know how is the transfer of georeferencing information is done between IFC and CityGML. Like is there any FME documentation that covers this subject?Thanks in advance.

Hi, I am a new FME user and hope someone can assist with my issues. I have to update weekly utilities data from .12dxml to geodatabase. From thegeodatabase, I have to create a map in ArcGIS Pro and publish it to ArcGISOnline. I just run the FME and overwrite the map whenever I receive data toupdate. I have no issues doing it since I just overwrite the data for everyupdate.However, the team requires me to add the date to each of the layer names e.g.:utilities_electricity_20221025.Previously it was just utilities_electricity.Hence, I couldn’t overwrite the data into the gdb. It will create a new layerinstead since the layer names are different every time I update the dataweekly. eg:utilities_electricity_20221025(for week 1); utilities_electricity_20221104 (for week 2). My questions are:1.      How to overwrite/replace the layer with a different name? E.g