FME Form

I have multiple sensor output csv files that have the same field names that changes with every single file.  The locations of the fields stays the same which is good.  An example is ID, DATE, TEMP, COND_HIGH, COND_LOW.  If the reader field names are changing constantly what is a good way to strip those names and put the simple ones above in their place?  I have attempted or looked at the Schemamapper, but I’m not sure if that is the route to take.  The other way I messed with was Reader > UUID > AttributeExploder > AttributeCreator (Conditional Statements) > Aggregator?  Any help would be appreciated.  I think I am making this harder than it needs to be.

I have a workspace that sends data to a url through the HTTP Caller transformer. I want to terminate the workspace if a NULL value exists in a field that is in a table on a SQL database before the data is sent. What is the best way to do this? Do I still need the Creator transformer if I use a Tester? 

Hi,Has anyone done or has experience with integrating BIM/CAD and GIS data between ProjectWise and ArcGIS Enterprise? I know that this isn’t a solution supported by ESRI, but FME's capabilities allow to process data and connect both environments. I am looking for ideas and solutions for integration and full synchronization between environments. Ultimately, I would like the design data saved in PW to be displayed on the GIS portal.Thanks for any ideas and suggestionsFilip

HiWhile converting an existing chain of workspaces from 2022.1 to 2024.0 version i ran into this issue:The current FME process locale has been changed from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to call 'setlocale()' in plugin code and doing so may cause unexpected errors..Python version 3.12 loaded successfullyPython: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more detailsC:\Users\%username%\AppData\Roaming\Safe Software\FME\Packages\24187-win64\python\safe.azurestorage\azure\storage\blob\_deserialization.py:657: SyntaxWarning: "is" with 'int' literal. Did you mean "=="?  elif num_empty_lines is 2:Message Type: fme::internal::_v0::py::ExceptionPython Exception <Error>: unsupported locale settingPythonFactory failed to load python symb

I have a table where I have emergency meeting points. Each building has a meeting point, some buildings have many points, here is an example:Building Meet_Points 123 11,12,13 124 16  I would like the table to look like this:Building Meet_Points 123 11 123 12 123 13 124 16  How would I separate those meet points, and make numerous rows of the same building that has each meet point and all the other attributes carry over to the newly made rows and are the same?

Good morning all - hoping that you can help me; I’ve got a fairly lengthy workbench which we run daily updating our internal data warehouse from a variety of sources. due to the complexisty, there are several no features testers included in the workbench which continue the translation when no data feeds in at certain points. However, there are certain instances where we would want the translation to stop (no new source file available, source system not ready for update etc.). We currently use terminators in order to stop the subsequent no features testers from triggering - however it would make it easier for us to keep on top of our monitoring if this didn’t then appear as a failed job in our server log - is there any alternative way of stopping the translation without it appearing as a fail? 

Hi together, Is there a way to delete the content of a ffs file but not the file itself? I am using FME 2021.2.0.1. Thanks for your support

Hello forum, This is probably a very silly question, but where do custom transformers (ones downloaded from the Hub) get installed? I ask this because I have downloaded the What3WordsEncoder and What3WordsDencoder transformers from https://hub.safe.com/publishers/safe-lab/transformers/what3wordsencoder and https://hub.safe.com/publishers/safe-lab/transformers/what3wordsdecoder.I’ve transferred the files to the server hosting FME Form, I’ve gone to the folder they’re stored in within  in File Explorer, right-clicked and selected Install. A message appeared saying it installed.  But now if I search in the Transformer Gallery in FME Form they are not found. So, can I instead browse to them? If so, where do they get installed? Thanks,Stuart 

Hello, I have the following JSON file (sample) where by te attributes names are under “Channels” while the data values are under records. This JSON come to me as a API call and have no way of modifying the source. Using FME 2019 {  "deviceID": 12345,  "channels": [    "RecordTime",    "Status",    "Current Total Average Main",    "Current Total Average Load1",    "Voltage Total Average Total",    "PhaseAngle Total Average Main",    "PhaseAngle Total Average Load1",    "Voltage Total Instantaneous Total",    "Current Total Instantaneous Main",    "Current Total Instantaneous Load1",    "PhaseAngle Total Instantaneous Main",    "PhaseAngle Total Instantaneous Load1",    "ModemSignalStrength Total Average Total"  ],  "records": [    {      "recordingTime": "2002-03-03T00:00:00",      "status": "None",      "values": [        2.781,        0,        237.95,        37.4,        0,        238.27,        2.804,        0,        37.66,        0,        14.82      ]    },    {      "recordingTi

Is it possible to use OAuth2 authentication using the Kafka Connector?

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