FME Form

Hello Forum, I have a workspace which reads in a tab file with a start_date attribute and end_date attribute. These are populated with datestamp values (e.g.: 202410281200). That reader flows to a TestFilter which determines if today is before the start date. If so, these records go to a new output writer for sites not yet started. If today is beyond the start date. These then go on to a second testFilter, which determines if the end date has been reached or not. If the end_date has been reached, then this goes to an output writer for historic sites If the end_date has not yet been reached, then this goes to a output writer for live sites. These test Filters are doing exactly what I want them to do.

Hi.  I’ve a FGDB how contains polygone and line feature,.I need to create a separate shapefile for all feature of the FGDB.After that, I’ve to create a zip with all the shapefile. Can i do that with FME ? Thank for help

Hello everybody, i want to know if someone know how i can to do to rename a value in an attribut ? which name for the transformer ? thank you !! Bonjour tout le monde, je voulais savoir si quelqu’un savait comment modifier une valeur dans un attribut ? quel transformer dois-je utiliser ? Merci par avance.

Hello , I would like to generate constant unique id for lots of points or lines that has not get  the id yet and keep the same constant unique for each time running FME (no change)i do not want any changing of id for each running Fme .lines or points should get constant unique id and after one month when I run Fme workspace and there are new lines or points .FME should provide the same constant unique id for old points or lines that provided them before and provide new constant unique id for new lines or points .The problem I am generating points that they are not exist before at GIS data and I am not able to save the points with id in Gis database but I want to keep the id for each point without changing in Fme thanks in advance fme 2021 

Let's assume we have a feature attribute called "two_digit_number". The attribute can have any integer value from 10 to 99. The condition "not an unlucky number" is met, if the value is not "13".  I was wondering if I could represent this condition in a single line of my SchemaMapper's lookup table? Something like two_digit_number != 13.  I could probably use a "TesterFilter" to filter out features with unlucky numbers before they enter the SchemaMapper - however, in my project I have dozens of attributes that need to be handled in a similar way. I would have to send all of them through a "TesterFilter". And this is what I would like to avoid. I am excited to learn if there is a simple solution I may have overlooked.

Hi, I want to find duplicate addresses in the data based on duplicate address numbers.The way that I found in ArcGIS Pro is using spatial join of the layer with itself using attribute matching “address number”. This way if a point has a duplicate with the same address number in the same location, is joining with the point with the same address number and if a join count is more than 1 display, there is a duplicate. I am looking for a way to do the same step in FME. I used SpatialFilter but did not get a result. I really appreciate any suggestion for doing this analysis.Also, in ArcGIS Pro, it is possible to join spatially "within a distance". Is this option available in FME?

Hello ,i have self intersection at specific line .but Geometry validator did not catch it .I have read at other article that it is better to use chopper vertex 2 and snapper segment to let geometry validator to detect self intersection issue ?I have tried it but it does not work .is there other suggestion that I have to try ?FME 2021thanks in advance .

When converting a Cloud Optimized TFF to a Geospatial PDF, the output resolution is very pixelated (see attached file). How can the output Geospatial PDF resolution be specified?GeoPDF Resolution Example

I need to select the lines that fall entirely within a specific polygon and update their data with the respective polygon name. I attempted to use a spatial filter, but it didn't work as expected. When a line intersects two polygons, the filter selects and attributes the line to only one of the polygons, which is causing issues. I also tried using the NeighborFinder without success. I've attached a screenshot to illustrate a line segment that should not be selected within this polygon.

I see an idea to add/support bulk mode in the PythonCaller has just been updated to "Released" - https://community.safe.com/s/bridea/a0r4Q00000HbriAQAR/support-bulk-mode-in-pythoncaller I'm wondering what the usage of the bulk mode is in the PythonCaller, by design the PythonCaller iterates over each feature individually, therefore going against the idea of bulk mode.    

Dear all,I need to add multiple REVIT/IFC files into an ArcGIS WebScene. I am trying to determine the most efficient way to achieve this.From my understanding, the process should involve the following steps:Read multiple REVIT/IFC files from a given folder. Transform these files into Multipatch and save them into a Geodatabase. Publish the layers.Do you think it is feasible to obtain such a result?Many thanks.  PS: I found this post which contains a similar request: 

I need to create a JSON attribute with a key that only has an empty object as its value as you can see at key1.{ "key1": {}, "key2": { ... } "key3": [ ... ]}Problem is that the JSONTemplater turns empty objects into null. An empty object is valid JSON and is very different from the value null so this behavior is completely incorrect.How can I set an empty object as a value inside a JSON attribute?I tried using the JSONUpdater but it works in the same way. If you set value type to JSON/XQuery it replaces the object with null. If you set the type to plain text, it only creates a string “{}” containing two curly braces.

Hello FME members,I have an IFC file with no coordinate information in the site feature.it is a 3dObject of a parcel that is supposed to represent the surface - but it is just a (3dObject) flat surface with an extrusion of 1]What I have done: I have at least 4 coordinates to transform, I tried to use:the 3daffinewarper, but the transformer showed me an error [because the transformation from 0,0,0 to x,x,444.1 is coplanar - and I only have 4 known points that went from z:1 to z:443] (I also tried 0,0,1 to x,x,444.1, but it didn't work) so I used the affinewraper to send the surface to the correct coordinate system)that worked!i need to know how to get the 3d object to the correct z value to display the surface (3d object) at the correct height.I hope someone can help m

I have several Excel writers in a workspace and one throws the warning below. I checked the parameters and they are all the same. Does anyone know where this can be changed? Thanks!Excel Writer: Invalid value '<Unused>' supplied for parameter 'xlsx_field_names_formatting'.  Reverting to default value 'yes' 

Hi All,I am updating few values in ArcSDE Geodatabase (in flat table) using FME workbench but its giving an below errorerror : Error while retrieving an ArcObjects update cursor for the table/feature class 'gis.xxx'. The error number from ArcObjects is: '-2147220652'. The error message from ArcObjects is: {}Stack  : FME workbench 2021.1 , ArcSDE Geodatabase, Flat table ,MS Sql Server Workbench screenshot :  Error message :    Feature writer properties Till now tried below : Us

Hi!I have to extract data and write it into excel sheet. I got to the point where I have the information ready but I need to delete missing values and move the features so the table looks different. I add an example.This is what I get:DaysMonthsCity<Missing>March<Missing><Missing>March<Missing><Missing>MarchParisMonday MarchParisWednesday <Missing>ParisSaturday<Missing>Paris<Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing> And this is what I want to write into my writer. DaysMonthsCityMondayMarchParisWednesdayMarchParisSaturday

Hello,I have a script which is written like this:import osparent = os.path.abspath('..')file= os.path.abspath('../file_08-06-2024.xls')return fileI would like to replace the date with an attribute defined in a attributeCreator transformer which could change and i write this :file=os.path.abspath('../file_$(date).xls')When i run, it doesn't work. Can you help me ?Thank you.

***UPDATE - PROBLEM RESOLVED***This is a strange one!For this example, I have 2 features. I put a counter to get 0 and 1 for the value. Then I’m updating my JSON with the _count value. The output from the JSONUpdater has SERIALNUM = 1 for both features. If I change the sort, it will set both to 0. I’m passing in the same feature in the Document and Update input ports. I’m not sure the distinction between the two input ports.  

Hi,A very random question. My son has recently started to like making mazes out of Lego for marbles. I was wondering if there was a way in FME I could perhaps randomly generate a maze?I know there are a bunch of generators on the internet, however they do not account for a cell size of 2x2, to accommodate a marble, or a wall thickness of 1. I see there is a generator on FME Hub, but it also doesn’t work because it calls a webpage that doesn’t exist anymore. So I thought perhaps I might have a go but I can’t work out a way to use any maze generation algorithms. I don’t know python, but I’m reasonably handy at desktopIf anything glaringly obvious comes to mind I’d love to hear itThanks

I have a workspace in FME Form 2021. It includes a writer for Automation. This writer creates the keys in the Automation I have created in FME Flow 2021. These keys are based on 4 Attributes I created and renamed in my workspace. When I change the attribute names, run the workspace, and upload it to FME Flow, they are reflected in the writer but are not written to the Automation I created that includes this workspace in FME Flow. The Automation still includes the old key names. ...but...after I run/upload the workspace as explained in the above paragraph, then delete the writer and re-add it into the workspace then run it/upload it again, this then it updates the keys in my Automation.  Has anyone else encountered a situation like this?  

Hello,I was hoping to get your input into how to speed up the following workflow:Read an Excel File with several sheets from a Network Share → Output each sheet to a different output port → Create a CSV file for each output port in a network share.I already have the above working, the problem is that CSV writer is taking  a loooong time writing the files. My connection to the network is pretty good so it is not a matter of latency between my PC and the network share (at least I don’t think so).Does anyone have any idea on how to improve the writing speed of the CSV files or what to do improve the overall time it takes for the workflow to complete?.Thanks in advance.RZ.-

Hi,I have a dataset with Centerlines shown in blue, some lines contain too much detail which is not accepted as input for the LineDivider I use in the downstream pipeline.Is there a way I can smooth the blue centerline into something like the red line shown on the right?The Generalizer should be the way to go I guess but did not find the right settings yet.  

Has anyone successfully created a workspace that can convert Ordnance Survey MasterMap data to dwg format? I understand the process would be quite complex, but it would be good to get an idea of what’s involved from anyone who may have done this.

Hi, I am trying to add Inspection attachments to the Inspections using FME Form.I have excel spreadsheet that have EntityUID, InspectionTemplateId, Observations Questions and Answers, and image links1 - to image link4(attachments)Each Inspection must have entity attach to it based on the EntityUID. Image as JPG extension located on the repository an each image have EntityUID in the image name.How can I attach image to the Inspection- that is first questionSecond question is that some Entities have up to 4 images related to them, that reference based on the different parameter (Image_link1, image_link2,image_link3, and image_link4)  It is easy to create inspection, add entity, and populate Observations questions and answers but I am struggling to attach the images. 

I am working to compare the geometry of two datasets and I am specifically interested in doing so with Vector Tolerance. For some testing purposes I have tried two different transformers to do so, namely the ChangeDetector and the Matcher. I added them in the same workspace with the same input data. For both I only checked the geometry (not the attributes), with the settingsMatch Geometry: 2D Lenient Geometry Matching: No Check Coordinate Systems: No Vector Tolerance: the same user parameter, e.g. set at 0.5 or 0.1. Always the same though.When looking at the documentation the vector tolerance seems to have to work the same for both transformers (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/changedetector.htm &