Transformers

I have a lookup table in which some feature class name is mentioned. I have to select in the feature reader only those features from geodatabase which in there in the lookup table. How to do that. One more problem here all my feature classes is in the feature dataset in input geodatabase. In output I want this outside feature dataset

Hi! I have a gml file that i have downloaded from the statistical bureau of sweden. This is the data source: https://share.scb.se/OV0105/Xml/PD/pd_befolkningsfordelning_totalbefolkning_nt.xml It is in GML format and the data is structured in 10km squares. However, I can't seem to be able to convert it to any other format. The geometry im getting is just a bounding box for the entire dataset, not the specific 10km squares. I have found very limited resources to help with this problem online. The final destination should be in an enterprise geodatabase.  Has anyone else had trouble with this? Thankful for any help.  /Alex

I am trying to run a Shell Script from the System Caller but am running into issues when accessing the various gdal programs that are called from within the script. These are stored away in usr/bin/ and "globally" accessible through the PATH file. The folder where the command is run is generated by FME in earlier steps, so its not as straight forward as copying the gdal files to the folder. Is there some workaround to get this functioning?

I have two datasets, one with 'old' parcels and one with 'new' parcels. I need to find out which old parcels turned into new ones and come up with a was - is list. Desired output: feature OLD parcel XX712 with a list with new parcel attribute(s): 557, 516feature OLD parcel XX713 with a list with new parcel attribute(s): 584feature OLD parcel XX713 with a list with new parcel attribute(s): 584feature OLD parcel XX621 with a list with new parcel attribute(s): 189 What I have tried so far using the SpatialRelator with spatial predicates: Contains, Within, EqualsOnly works for parcels that stayed the same geometry wise. It is possible that geometry changed, see the example in the screenshots.  IntersectsThis works but its giving me too much suppliers. When a parcel geometry has stayed the same its giving me a supplier from the parcel next to it because the outer lines are touching.  TouchesGiving me only the touching parcel to the side Am I doing something wrong with the se

We have some Annotation points all in one feature class. We are looking to find duplicated annotation text that are close to each other. We used the NeighbourFinder and attached the attributes from the neighbouring annotation to the base annotation. This allows us to see that, for example, record OD=1 is close to OD=2. Then a Test Filter is used to check if the TextString is the same on the base annotation when compared to the neighbour.  From the results of the TestFilter we have a list of annotations that can be reviewed as it looks like they are close to each other and have the same text string (which may not be needed).  So, for an example, say there are 100 annotation points that come out of the TestFilter. For each of these points, one of the other points in that selection of 100 points is the point it is related to/neighbouring. So, we don't actually need a list of all 100 points, just 1 of the points from each relationship, resulting in 50 points.  Currently we are

Hello, I am writing features to a block that was created in a template. The attribute definitions in the block definition have their positions locked, but when I write a new file using the tempalte and block definition all the attribute definitions labels are moveable. I have been playing with settings and trying to figure out why it changes in the new file, but have not succeeded.  Original BlockNew Feature (See all the insertion points on the text, text is also moveable)  

When the user selects first parameters the second parameter values should populate based on the first parameter selected.EX: first parameters has values A,B,CSecond parameter has values 1,2,3,4,5,6,7,8,9If the user selects 'A' from first parameter; second parameter should display 1,2,3 values when the dropdown is selected.

Hi,I'm using the FTPcaller to upload data on a weekly basis. In order to preserve data already posted, the new file has an changing date in the file name.I've configured the Transfer > URL portion of the FTPCaller to accept an attribute value which works fine. However, when I try and do this with the Upload From A File > File To Upload portion, the FTPCaller fails, saying it cannot find the file:Any idea what I am doing wrong?

I have two datasets:A calibrated road dataset. Every vertex of the line has the measure value (kilometer point).A table with car accidents with a field that indicates the kilometer point where it happpenedI need to create Point geometries for the accident using both datasets. In other words, I need to create a point event layer.As you can imagine, the accidents don't happen at an exact vertex of the road.Can FME create that point event layer?I've tried using the Snipper transformer, but I'm not getting the results I want.

I also want to know the relevance of this setting

I want to connect two databases (Oracle) in an SQLExecuter Transformer. This is to compare the changes. Currently I can add only one connection. Is it possible through User Parameter? Thanks in advance Harish

What determines the origin for the PointCloudCombiner? I can set the interval between points, but can I control their origin?

 I have no problem accessing my Trimble connect account through the connector and can see all relevant maps etc. but am unsure whether i need a reader to be connected and what that looks like. I want to download GPS data that is captured in Trimble connect and process it through into shapefiles based on the various layers in Trimble connect using FME. A side question would be whether or not the Trimble Connect connector can process image files as well that have been collected with the GPS points.Appreciate any assistance from the community :)

Hi everyone. I have a question regarding a FME application where I want to compare certain measurements. The mesurements are imported to FME by LandXML format and the basic relevant data are the cordinates (X,Y and Z), the date of the measurement and the name of the point. Example:Data i imported.2024-01-01: P1; x=13,31, y=10,00;z=2,20P2; x=11,21, y=9,87;z=2,10P3; x=14,31, y=14,12;z=2,20 2024-01-02:P1; x=13,32, y=10,00;z=2,19P2; x=11,21, y=9,88;z=2,10P3; x=14,31, y=14,12;z=2,19P4; x=9,12, y=14,12;z=2,21 2024-01-03:P1; x=13,33, y=10,01;z=2,19P2; x=11,21, y=9,87;z=2,10P3; x=14,31, y=14,12;z=2,19P4; x=9,12, y=14,12;z=2,21 I want to import and generate graphs that shows the differences in plane and height (2 line graphs whit one line for each point and the date in x-scale) from the first measurement of the point. To complicate it a little further, as it shows it is possible for new points to be added later in the serie that will in later measurements be compared to the first measurement of

I have closed and open FME and run the workspace, I have enabled Visual Preview, and Feature Caching as well but still can not see the results in transformers. I appreciated if someone can help me.Thanks

Hi all, after NDVI calculation I select pixel values within a certain range. Afterwards I use a clipper to obtain only the desired area. Based on pixel values I get the following result:Afterwards I used "RasterExtentsCoercer" in combination with "Generalizer" to get smooth areas. It would be nice if the very small holes (yellow example) are combined to the detected area. Only larger holes should remain! How can I do this?   Thanks in advance 

Hi,I am wanting to create a count that increases if a condition has been met. So as an example, if TIME is greater than 100 then the COUNT increases, otherwise it stays the same: TIME - COUNT20 - 170 - 1130 - 2220 - 340 - 380 - 3370 - 4 Been stuck trying to figure this out for a while. With Python this would be easier with the use of variables but I am struggling with FME on this one. I see the Count transformer has 'Group By' capability but I don't think that helps me for this situation.

Using Form/Workbench 2022.2, connecting to MSSQL 15 with 10.9 SDE over the top. I'm not an SQL expert, and this statement was a combination of my knowledge, ChatGPT and colleagues knowledgeSELECT    p.*,    -- Calculate the rate of nitrogen (N) application over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.NutrientN / p.AppliedAreaInHa) OVER () AS  total_n_rate,     -- Calculate the total fertilizer rate over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.RateKgPerHa / p.AppliedAreaInHa) OVER () AS total_fert_rateFROM    [Agtech].[MASTER].[ProofOfPlacementSwath_evw] pWHERE    p.[SwathMergeID] = '@Value(swathmerge)';This runs fine in SSMS with no errors and re

I am sending JSON data to a Text File Writer. The Text File Writer has its MIME type set to "application/json", yet the response Content-Type remains "text/plain". Is there a way to force this to "application/json"? (Note: Using a JSON writer does set the content type to application/json, but it formats the response as a JSON array, which is not suitable for my calling application.) Second, the application that will be using this Data Streaming service sometimes requires specific HTTP status codes to be returned. Is there a way to force the HTTP status code e.g. to 400?

Hi, fellow FMEers! I a problem that I cannot solve. I want to present 3D data along a line with breakpoints. In my script I want the line to be presented as a straight line (a profile).  It is important that the length of the line parts are correct but it doesn't matter where the resulting parts start.  The data input line is drawn from start to end but can begin and end anywhere (from west to east, north to south and so forth...).  Any hints or suggestions? 

Hey. Hey. Could anyone advise how to write files to multiple datasets according to the number of sets defined by the number of flight tracks? The output dataset should contain the name of the ler route and some other attributes that are not relevant at the moment, however I need the number of datasets to match the number of flight routes ( ar_name attribute ). Currently I can only create one output dataset see attachment "current_dataset_routes_update_test". The attachment contains four flight paths in one dataset, namely Z410, L132, M725 and L602. The required output I would need is 4 x dataset Z410, L132, M725 and L602 see separate attachments with required_dataset + flight route name. I am also attaching a printscreen to give an idea of how to create the actual output dataset. The number of flight paths and the resulting dataset can of course vary, the process must be automated. Thank you very much. M. 

Hello everyone,I'd like to outline the main concept of my work. I am working with two point clouds, one representing a road and the other obstacles. Initially, my goal is to determine the minimum distance between these two point clouds. To achieve this, I rasterize both point clouds and calculate the difference (A-B). I then identify the point with the minimum height (Xh, Yh) and its corresponding difference height (H). After that, I rotate the two point clouds, merge them, and rasterize the combined set. The result is like represented in the first picture. However, I aim to enhance this representation by adding an arrow to signify the distance H, as shown in the second picture.  My idea (maybe not the best) is identifying the neighboring pair in the two point clouds close to the extracted point with the minimum height (Xh, Yh). I intend to draw a line connecting this pair, label it with H, and either rasterize it with the point cloud or incorporate it in the end somehow. For now i

All our processes that were inserting NVARCHAR(MAX) values into SQL Server databases have stopped working correctly (FME inserts NULL values into NVARCHAR(MAX))after the latest FME upgrade (2022).  We have found a temporary solution using the Microsoft SQL Server Non-Spatial (JDBC) format instead of Microsoft SQL Server Non-Spatial but it requires to modify a lot of workspaces manually. Does anyone know if this is a bug and if it will be fixed? Thank you! 

I have created a process that simulates the horizontal wellbore creation processes for a client. However, I am stumped on, what seems to be a rather "newbie" process of flipping 180 degrees a select set of features. Let me illustrate further:  In the example below the user selects a township to create the horizontal wellbores. The workbench tiles the township into 6 sections by default. They next pick a direction (ie East/West or North/South.) Next they choose a starting location for the Surface Hole (N, S, E, or W.) Lastly they choose how many wells to place in each section.  The result is this of a North/South orientation with the surface hole in the south and 6 horizontal wellbores placed in the sections. So far, no issues this is version 1 where they all go in the same direction.    However, the client also wants the option of creating a "pad well" style drilling progam. In this case alternating rows would be flipped or reversed. Normally I am able to figure thi

I've got two identical line/point features, each of them has a list of all attributes created by Aggregator. I want to compare these two list, some elements are same and some are not and number of elements may not be same. Matcher or ChangeDetector can do comparing part but can not out which elements are different. Is there a way to compare two lists and output different elements? Or can I just compare attributes of two features without creating lists?