Transformers

FME beginner here, I'm trying to do a pretty straight forward export from an sde based database to file geodatabase, the only real criteria I'm after is preserving the ObjectId values in the output. Everything tried results in the ObjectId resequencing itself in the output per normal, our client has built relationships on the OID (why I'll never know) so we need to preserve them in the extract. Any help is appreciated.

After georeferencing CAD in ArcGIS Pro, generating World (wld3) and Projection files (prj), FME doesn't position the drawings correctly despite enabling advanced options. Why?

I've tried using FME Desktop on one of the new M1-based MacBooks. When running workflows I notice that I get considerably more memory optimization messages and warnings than I do when running on an Intel Mac or on Windows. The result seems seems to be lower performance. I'm not really surprised as it is a brand new platform and Safe probably haven't had time to test this properly. It would be interesting to hear if anyone else have experienced the same thing. I'm also curious to hear if anyone from Safe can shed some light on the matter.Judging by my tests so far it looks like FME could potentially perform very well on Apple Silicon once the memory issues have been addressed and a universal executable for FME Desktop is available. For more details and results from running FME workspaces on Apple Silicon (and Intel Macs / Windows) I wrote a blogpost here. I also uploaded the workspace I used for testing.   

Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point should get unique id number I tried with many videos and tutorials didn't solve my issue thanks

Hello, In my current project, i mostly use UTC datetimes, except for one process, where we need local time (Paris).  For example, i need to convert "2020-04-29 12:00:00" (UTC) to "2020-04-29 14:00:00" (local).  To convert my UTC datetimes, I could use the rule "+01:00:00 winter" and "+02:00:00 in summer". However, the day the times changes is never the same from one year to another.For example, in 2020, Winter time (one hour difference with UTC time) was adopted on October 25th, and Summer time (two hours difference with UTC time) was adopted on March 29th. In 2021, Winter time change will be adopted on October 31st and Summer time will be adopted on March 28th. Moreover, the conversion will not occur at the specified datetime ! This conversion could be run six months later, a year later… because we are processing data long after it was created. So I can not rely on the time of the computer doing the calculs to compute a time difference. I need t

Hello, I'd like to add a geo-referenced and framed text (see attached) to a GeoTIFF.I've used the transformers on the attached screenshot.Everything runs without error but the framed text does not appear on my output GeoTIFF.Could you help me? I'm new to FME. Thank you in advance,Camille

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?