FME Form

I’ve seen that FME 2023.2 Build 23764) doesn’t recognise ArcGIS Pro 3.3 for access to Esri licenses. Will this be resolved in 2024.1? I haven’t tested 2024.0 as I’m waiting on the .1 release

I'm building a data validation tool and utilising the AttributeValidator heavily as part of the process. There are a couple of attributes that are "optional" but have an associated list of valid values (field validation/domain). This means they are allowed to be null, but if they have a value, it must be one of the pre-defined valid values.  I'm hoping to use the Conditional Value option for Rule Configuration as below:  However, upon running the workbench, FME terminates and the translation fails immediately due to "unbalanced quotation marks on line XXXX of file <workbench directory>\\wb-xlate-1700200438336_13788". Is this a bug or is my conditional value rule configuration just incorrect?

I’m  combining lines based on end noded while keeping some attributes in a list for each original lines (1). Then I create a new attribute based on the lists (2) with conditions based on numbers in the lists (3).    I would like to set up the condition statement dynamically: the number of lists varies each time I run the workflow so I would like to pick numbers from the last list available (in this case PR_list{2}) and do something like: PR_list{0}.ORIGINE < PR_list{max}.ORIGINE instead of choosing the list manually.  Is it possible to create a dynamic condition in the condition value definition? 

I am currently reading all .dwg files from a folder with a dwg reader and it works well. To gain time, I would like to select in the reader the layers I want to keep (named “CADRE”)  instead of reading all the dwg files and the thousands of elements contained by them, which I filter after as I am doing currently (see photo). I looked the reader documentation and on forums but I can’t find the right parameters, is it not possible to do something like that? Thanks for your help!

Dear All,  I'm looking for tools to write ENHANCED COMPRESSED RASTER GRAPHIC (ECRG, MIL-PRF-32283) and High Resolution Elevation(HRE, NGA.IP.0002_1.0 HRE) files.  I have searched the FME reader/writer list, and these two formats are not on the list. ECRG and HRE files are physically formatted within a National Imagery Transmission Format 2.1 (NITF 2.1). Is it possible to use NITF writer to export ECRG and HRE?

Hi, I have a problem. I just created a line out of multiple points of an x,y,z text file with the LineBuilder tool. The problem is that the points name are lost. After the LineBuilder I use a Chopper to split the line into segments. Now I want to add a new attribute to the line segments, which has the initial names of the points. Because due to the LineBuilder the names are lost and are everywhere the same. How can I do that?

In my scenario, I have an FME script that performs data validation. If the data is valid, it updates the database. However, if any records contain errors, I want to capture those records in an Excel file for users to review before uploading the data. In this error case, no data will be updated to database. So, the logic I'm aiming for is as follows:Validate the data. After validating all data, capture all invalid records to an Excel file. Then, terminate the FME script without uploading the data to the database. If all data is valid, proceed to upload it to the database.I've attempted to create a flow with a terminator, but the Excel writer doesn't have a connector. Connecting the terminator to the output port of the TestFilter after validation would terminate the writing of the error Excel file as well.Can anyone provide suggestions to solve this issue?

Hi, I am trying to use FME to create an Inspection in the Cityworks. How can I configure Answers for the Questions in FME? I believe I need to do that in the Additional Parameters Section but I cant figure out how to set it up. Can someone help please?

Is anyone aware of a connector for FME that enables our GIS databases (Microsoft SQL) connect to a Techncology One Property & Rating database? 

I read two obj models, but one of them has a texture displayed as a blend with the other model

I have two point files and need to identify the nearest point in file A to the nearest point in file B, however the matching must be unique. Meaning once a point in file B is matched to a point in file A it cannot be matched to any other point in file A.I can match them using nearest neighbor but don't see a way to restrict to eliminate duplicate matching, so I end up with the same point in file B matched to multiple points in file A.

Hi All,I’m having a bit of headache to read all the SHP included within a ZIP through the FeatureReader transformer, I’m getting the following error Shapefile and cannot be read for some reason. I can reader it with the normal SHP reader but can’t get it to work on FeatureReader, here is a screenshot of the settings: What am I doing wrong? 

I’m trying to create a new value based on the first letter of each word in a string. I tested the regex ‘\b(\w)’ and the returned value is correct, but when I used that regex in the @SubstringRegularExpression(), it only returned the first letter of the first word.@SubstringRegularExpression(@Value(ID),\b(\w)) where ID is “MARKHAM RD/ORANGE BLVD, SANDFORD”. You can see in the regex editor, it is correct. This is the result of the substring 

Hi Community! I was wondering if anyone had an idea of why I am getting different values for polygonal areas when calculated in FME using AreaCalculator vs the SHAPE_Area attribute of an ESRI feature class?The geometry I am working with enters the workbench with a defined projected coordinate system (DUB-DTLM) from a dwg file and the feature dataset in which the destination feature class resides is also in DUB-DTLM.The discrepancies are minor (at the 3rd decimal place in sqm) but nonetheless have the potential to cause issues.Interestingly, when the features are interrogated in Map3D, they show the same area as is calculated in FME.Any explanation (or even hint!) as to the cause of the difference would be much appreciated.

Hi all,I have a 15 minute timestep data which has random missing values (expected). I’ve managed to track where the data has gaps, but in order to calculate a consistent rolling 24 average of the value I need to fill these missing gaps with a timestep but null value (so i can calculate an average from the preceding X values)Does anyone have any suggestions on how to fill these data gaps automatically? Or better still calculate a 24 hour rolling average using specific timesteps rather than just number of rows? Thanks 

I have a SHP file with geometry. It has an attribute called 'id_alt.' I would like to extract only the values of this attribute. Is there any way to convert these values into variables that I can use the value use with TESTER after UUIDGenerator to filter my data? Alternatively, what is the most efficient method to achieve this with FME  

Hi, Is there a way to divide records into equal parts based on the value of an attribute? In concrete terms, I want to divide 400 areas into 3 pieces, each of which is the same size.Thx

Is it possible to create features with a null polygon geometry and write to an ESRI file geodatabase?I have some features with known geometry which I write successfully.I would also like to write features with no geometry to the same table and update their geometry by manual editing later.I have tried modifying fme_geometry{0} and fme_geometry but nothing seems to work.I usually get an error like  “can’t write features to and area feature type” I have read through similar questions but don’t seem to have a complete response. It appears it is possible to create a valid null geometry. Thanks go any help.

I have an attribute containing String values such asGladstone RegionalSouthern Downs Regional, Goondiwindi RegionalMoreton Bay City, Noosa Shire, Somerset Regional, Sunshine Coast RegionalI want to replace the last comma with “ &” so that the output will look like thisGladstone RegionalSouthern Downs Regional & Goondiwindi RegionalMoreton Bay City, Noosa Shire, Somerset Regional & Sunshine Coast RegionalIs there a way to use a Regular Expression inside the StringReplacer transformer to accomplish this?

Hello everyone, I want to get the largest rectangle inside a parallelogram. Do you have any good ideas for achieving this goal? I didn’t find an efficient answer on the web.  Is there a transformer/workflow in FME that can do this?Thank you very much for the help! Jenny

HI, I’m looking into using HTTP caller to update records in my Salesforce Org I am struggling to get anything workisng, I have tried to setup a connected app to setup a FME web Connection but keep getting an error. The aim is that another service calls the FME job and it runs and updates a record in Salesforce, we have the record ID for each run so we know what record and field to update but I’m also not sure using the HTTP Caller how to have it refresh the token also?   I have also tried following this guidehttps://support.safe.com/hc/en-us/articles/25407494166029-Connecting-to-Salesforce-in-FMEbut everytime I try to test it come up with a Network Error: invalid_request Any direction would be appreciated. Thanks

Hi. reading LYRX (“layer files”) from ArcGIS Pro failes when the layer file include Grouped Layers. It works just fine if the LYRX file does not include Group Layers.Thea Layer File/LYRX is made with ArcGIS Pro 3.2.2 where the LYRX file is in JSON format.

HiI am receiving this warning below - It worked fine in 2022.2.5. Since we have migrated - to 2023.1.x - this started to appearIt happens using GeoDatabase writer / and or FeatureWriter - using GeoDatabase : DB Version 10.9.1 on SQL ServerGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.action' to '_Update_0__action' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.attributeName' to '_Update_0__attributeName' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.originalValue' to '_Update_0__originalValue' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.revisedValue' to '_Update_0__revisedValue' based on format constraints for invalid characters, length, and case    

I have my workbench on version 2021.2 where i am running different workspaces, the emailer transformer always throws an error 2024-05-09 22:54:24|   0.5|  0.1|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2024-05-09 22:54:24|   0.5|  0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'2024-05-09 22:54:24|   0.5|  0.0|FATAL |Factory proxy not initialized2024-05-09 22:54:24|   0.5|  0.0|FATAL |Emailer_3_CALLER (PythonFactory): PythonFactory failed to process feature2024-05-09 22:54:24|   0.5|  0.0|ERROR |Emailer_3_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details2024-05-09 22:54:24|   0.5|  0.0|ERROR |Creator_XML_Creator (CreationFactory): A fatal error has occurred. Check the logfile above for details2024-05-09 22:54:24|   0.5|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details This is the fme email package Please help me understand what i am missing here

I am running a call to an Oracle DB based upon an input ID as a feature attribute value coming in from a CSV. There are upwards of 2000 ID’s to process. Initially, that call was running on a per-feature basis; I am now trying to make this more performant by using the IN statement e.g. WHERE ID IN (‘1’, ‘2’, ‘3’). I am doing this by aggregating incoming ID’s into one attribute value. Where this falls flat is that there appears to be a limit on items that Oracle can cope with in an ‘IN’ statement, so I figured I would chunk it up into more manageable numbers. My first thought was to create a looping transformer. My conception of this would be that a Counter would increment a Sampler to take the first 500 records (X), then the X+1 group of 500 (e.g. values 501 to 1001), X=2 and so on, until the _matched_records result coming out of SQL Executor was 0, at which point a tester in line would fail. However, Sampler doesn’t support that kind of expression building (as far as I can see). Any id