Transformers

I have a polygonal tax lot feature class where about half of the features are being rejected from the Point On Area Overlayer Transformer with a rejection code of "INVALID_POLYGON_GEOMETRY_VERTICES". How do I fix these so they are recognized by the transformer?

Hi all one more time,I didtutorial example: Transpose a Table Using FME. Is it possible to further modifythe table according to the images below, please?  Values could be"x" or any other. Thankyou all :)

Dear All, I am facing the following issue. I have 2 datasets (which are quite large) that contain a series of common attributes. I have a 3d table that stores the attribute names that I would like to compare (no geometry comparison).  What I would like to do sounds very simple (sorry, I am newbie to FME...) :loading the 2 data, add prefix, merging them based on a key attribute (they will then have attributes like source1_col1, source2_col1, source1_col2, source2_col2, etc.)load the data that contain the column names I want to compare (e.g. col1, col2, etc.)iterate over col1, col2, etc. and for each of this value use TestFilter testing sth like "@Value(source1_$(column)) = @Value(source2_$(column))", write the unfiltered in an excel file on "$column" sheet) I have tried thousand things (custom transformer, ChangeDetector, workspace runner), but could not achieve exactly what I would like to do. One solution works rather well : I have a parent workspace that loads the

Is there a way to take a table as input and split it out into multiple outputs based on the value of an attribute (that I may not know)?I have a table of data that refreshes daily and one of the columns is for an object value. Most of the features (non-spatial) will have the same value for this field but people do have the option to set it to a different value that would be specific to them. Depending on the person adding data, the value could be different from one day to the next. Is there a transformer that will split a table out based on the value of a single field and then let me do different processing for each output? I've looked around and saw a few mentions of a "Fanout" but that looks to be something that happens on the writer and that's usually geospatial. I'm looking for something more like this:I see that there is an "AttributeFilter" transformer but it seems like I need to know what the values are that I would need to split by in advance. In

In the same workspace, I have 2 "lines" of attributes.I have to test an attribute value in line 1 to pass an attribute value of the line 2.I tried with an Aggregator, but all the attribute values are gone just after the Aggregator.Maybe it's just for geographical data.Is there another way?Or is it just my parameters in the Aggregator not right?

I'm wanting to see how many of a list of 34 overlays intersect each of 25,000 cadastral parcels, and get attributes from any that intersect. I'm currently using the SpatialRelator transformer, to see if each of parcels intersect the 34 overlays. However the output only appears to contain the attribute information of the first of the 34 overlays found, and I'm wanting all attribute information of all intersecting overlays. I would be able to achieve what I'm after if I used 34 different SpatialRelators, so each parcel could check if it touches any of the 34 overlays, however I'm hoping for a more concise solution. I wished that the SpatialRelator could do group processing that applies to only one layer, so that it effectively runs 34 times. AreaOnAreaOverlayer isn't doing what I'm wanting, as some of the parcels overlap and entirely contained by one another, which appears to be blocking the overlayer from reading them.

Dear All, I am facing a very weird issue : I want to run another workspace using a workspacerunner with a set of user parameters. Sometimes it works, or sometimes I get a UNDEFINED MACRO error. What is really strange, it is that in some FME workspaces it works very well and the workspacerunner does the job - but in another workspace a workspacerunner (that calls exactly the same script with exactly the same set of input parameters) fails with the UNDEFINED MACRO failure. Even stranger : when I copy-paste the workspacerunner that does not work in the same workspace of the workspacerunners that works, it also does not work -> so in the same workspace I have 2 workspacerunners exactly identical, one working and the other raising a UNDEFINED macro error ???!!! I've spent days trying to understand what was wrong in my script and/or parameter settings, but I end up thinking something else might be wrong... Do you have any ideas what could cause the issue ?Particular cache files to del

When I populate a FeatureReader with dynamically generated values containing the options I want, it works but not completely. It reads the parcel data I want, but returns no schema/attribute data:  If I manually fill in the values in the exact same reader. It produces the output I do want (I.E. the parcels and their data). This is super inconvenient since our process is based on the assumption that we will not have to populate workspace objects manually each time we run them. I feel like I am missing something fundamental here that will great enhance my understanding of FME. Please help me to understand why this behavior is happening. Any help pointing me to how I might get the automated values to generate the output I want would be greatly appreciated. Thank you for your time. Kim

I have a table with multiple rows. Each line has a number. The number is appended to the column name. After that, each line should be appended to the other. The picture shows the starting table and the target. I've researched a lot but found nothing. Does anyone know how it works?

Hi, I am trying to reduce texture resolution on a .obj model. This is what i have currently:The output at AppearanceSetter does not have any textures applied to it. I have tried connected AppearanceStyler to AppearanceSetter directly and it also does not work. So I am assuming that perhaps the way that I am setting the appearance is wrong. Images attached below shows before and afterI have attached the .fme workspace. The .obj can be found here: (due to size limit here) https://drive.google.com/file/d/1Cg6wNNzllzl0M7O6ifciswnPfC_0z57s/view?usp=sharing 

Hi there, I am connecting to Vicmap as a Service (VAAS), which is an ESRI ArcGIS Service Feature Service, which will allow me to bring in the state property data and push it straight into our SQL Database. This will replace a weekly download of MapInfo files which are pushed into SQL via automated procedures. The ESRI data is in Vicgrid GDA2020 (EPSG:7899) and I am trying to push it out to SQL as UTM55S GDA2020 (EPSG:7855). It doesn't matter which projection tool or coordinate system tool I use the data still outputs as Lat Long with an SRID of 7844. Is there a way I can do this? I thought perhaps I need to output to a different file format and then reproject that file and push into SQL, but I'd rather avoid an extra step if possible. Regards, Josh

I have a workspace where permit data is joined to GIS data through a series of joins. That data is then written into separate feature classes. The 3 datasets in order are as follows BIN Join, BBL Join, a spatial join using the Point On Area Overlayer transformer. After all of these joins happen I'm dumping any remaining unjoined records into a point feature class called Fallout Points. However all of the records from the spatial join are ending up in the Fallout Points layer. How do I exclude them (or delete them after)?

I have 1,000's of 1km asc files which are simply named 1.. 10,000 which I wish to merge in to 5km asc files, and appropriately name with the correct OS Tile Ref. I have managed to perform a spatial filter and added the OS tile ref. I now wish to filter so all 1km tiles within an identified 5km tile go forward for merging. Is there a way to automatically filter based upon the present OS tiles without creating the individual condition filters manually?  

We are trying to create geopdfs for different defined area having multiple devices , features in them. Adding labels to symbols using LabelPointReplacer Parameters and set the label scale that most of the area fits to it. But few areas are having labels that are overlapping with the symbols as shown below Is there a way to adjust the scale based on different areas.  

In some cases I like to create cumulative statistics using the StatisticsCalculator. I'm glad it's kept as a Advanced option in the StatisticsCalculator. However, it feels a bit odd that the StatisticsCalculator seems to require/expect attributes for 'Summary statistics'. I.e. if I only want to create cumulative statistics, the StatisticsCalculator shows an error (Red Cogwheel) indicating; 'Parameter 'Statistics to Calculate: ' must have a value'; Although it's possible to ignore the error and run the translation, or provide a dummy attribute to calculate regular 'summary statistics', it doesn't feel fully correct. It would be nice to also have the option to only create Cumulative Statistics. I guess that may be possible by (also) embedding the regular 'summary statistics' in a Checked ParameterGroup (and be default checked).

I have two enterprise geodatabases, each with an annotation feature class (annotation version 2.x) that I need to keep synchronized. Edits are made in the feature class in the source geodatabase, and (ideally) updated nightly to the feature class in the target geodatabase, using an automated FME workbench on FME server. The annotation feature class in the target geodatabase should have all of its features truncated and replaced by the annotation features in the source geodatabase feature class. This works great for a number of other feature classes (polygon, points, etc.), and it works fine with older versions of the annotation (Desktop version), but not for this annotation version. I'm testing this out locally, using ArcGIS Pro 3.0 and FME 2022.0.0.2 (Build 22343), and regardless of how I set up my workbench, I'm not able to read and write the annotation features between these two data sources. Currently, I'm getting the following error from FME Workbench: "An error

Hi, I've got a 3d model made of cubes (points extruded in 3 dimensions) and would like to export it as Cesium3dTiles. I did styling with AppearanceSetter and everything is okay except the cubes consist only of 6 squares that are colorised and they are not filled in the inside. Having these solids filled is important to generate cuts through this model. Any suggestion on how to get filled cubes?Regards,Maik

I already had a look at the following link and it helped me in the right direction, however I am still stuck. I use values from the boundingbox transformer for determining whether I need a portrait or a landscape layout. See image below how I have defined it. In case the length of the xdifference is bigger than the ydifference, then I would go for a landscape layout.Then I tried several ways to define the size:1) defining the values shown above in the attribute pdf_page_size in the attributecreator transformer. 2) Create a user parameter from above and use it in the pdf writer under parameters "Page Size (points)"3 Using a TestFilter in combination with two PDFPageFormattters don't work I get the following error  PDFPageFormatter (PDFLayoutFactory): Invalid page object '<at>Value<openparen>Grootte<closeparen><space>=<space>Portrait' parameters 'MINX;-260;MINY;1152;WIDTH;255;HEIGHT;39;FIXED_ASPECT;Yes;CLIPPING_ENABLED;No'.  All point positions must be a pos

I have a file with points and as an attribute I have the measurement with respect to the LRS. How to view the points on the map?

I am trying to use the string search command to extract the file names from a text string, Path attribute. by reverse searching the path string in order to establish the location of the last sub directory i.e. \\ @FindString(@Value(Path),\\,-0,caseSensitive=TRUE) The forward search works but I can't get the reverse (right to left) to work! using a negative startIdx  

When rerunning my entire workspace, the transformers don't run one by one. They run to where all the transformers are being used at once and it takes an astronomically long time. It's faster if I run each transformer individually. Is there a setting to make each transformer run one at a time when I rerun my entire workspace?

I have the lakhs of electric line features in FGDB , I want to find out the line features which are overshoot and correct those . Can you please help me with the FME workspace ?

Hi, I am using a FeatureWriter to create a Geopackage. Although I set the Spatial Column name as "SHAPE" it is changed to lowercase "shape" in the output. Can I prevent this behavior somehow or is there a workaround for this (e.g. renaming the spatial column with sqlite in a PythonCaller)?

Hello , i have read text file but I see only one column in FME Important data starting from fifth column fifth row include the name of each column | col1 |col2|col3|col4| col5|rest of columns include data like this |..0383004|Abcd…………|383903…..|Dhaka Gheny 2|………|I see in one column all data ,as what I explained above .i would like to get the data into excel file .i would like to export the name or number between | | so I need to have five columns and each column include the data that belongs to this column as text file  thanks in advance FME 2021   

Hi together, I am trying to add new geometries to an existing dataset, but always my new geometries got rejected. I was using the FeatureMerger, FeatureJoiner and Dissolver, but it will not work at all to add them as new elements.  Does anyone has a suggestion to me what to do? Thank you very much :)