FME Form

Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!​​​​​

Hello,  Using a SQl executersyntax: update <table name>  set date_start= to_char(sysdate -1,'dd/mm/yyyy')        where  DATE_START is nullcommitNo updates of the tables.Does FME have a problem with using Oracle “to_char(sysdate -1,'dd/mm/yyyy')”?Because the syntax works under ORACLE SQLPLUS  

Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN.  I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

I am struggling to save text as a hyperlink in Excel. I tried using this formula:=HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")However, the outcome in Excel didn’t work as expected.  Does anyone have any idea why it behaves this way?

Using an Esri ArcGIS Portal Feature Service Reader to read attachments, RasterReplacer fails on the attachment blob with INVALID_FEATURE_CANNOT_READ_BLOB. Enable Attachments='Y' on the reader, the arcgisonline_attachment{} list is exposed, and arcgisonline_attachment{}.data contains data. I am able to manually download jpg attachments from Portal successfully. I've tried all the image formats in RasterReplacer against the jpg in Portal. Any help would be much appreciated. Thanks! FME 2019.2.1.0, Portal 10.6.1

HiI am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .let's say (routeNo)  or any other unique value.the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones.Any help is highly considered. Route 1Route 2 

Overwritting .shp files gives mixed results so my workaround is to delete the .shp file(s) first and then create the new version.  But I can not figure out how to do that --I read somewhere that writers have a ‘delete’ setting for the ‘fme_db_operation’ parameter but I can not locate that anywhere.  Can anybody tell me if FME has the ability to delete the .shp files in a folder?  Thanks!  Lewis

Hi all I am trying to compare two databases which contain similar and different geometry files. I am trying to figure out which geometry's are the same and which are unique to each database.   A few big issues I have is the complex of the geometry and even the SAME geometry's has been captured slightly differently; even thou it's of the same area.I also have no data to help identify which geometry's are the same.Example of 2 similar complex geometry's - zoom in to show compilation differencesI am currently struggling to figure the best solution to my problem, the geometry can be complex with donuts and multiple areas representing the “same” geometry. I can't find the sweat when I simplify the data enough to get a match and not corrupt the data too much that everything m

IssueI have several 3D objects (coming from IFC) with variable appearance styles. In one case the style seems transparent. Both in FME inspector and in the final writer (Cesium3DTiles) these objects are kind of transparent.(see feature informations in annex)the dark-red “wall” seems transparant by contrast with the two parts ontopWhat I did so farChanged/Reset appearance (AppearanceSetter) → no effect checked on Geometry (GeometryValidator, VertexNormalGenerator, GeometryRefiner, etc) → no effectQuestionsHow can I make the transparent objects opaque? What’s the difference to the other objects?

I am getting this error with the HDF connector, it seems imp was removed in 3.12 which ships with FME 2024, it seems IMP is deprecated in python 3.12  that ships with FME, would a repoint to a custom python interpreter of 3.11 fix this issue ?  or any other thoughts  2025-1-21 12:20:37 | Message Type: fme::internal::_v0::py::Exception 59 2025-1-21 12:20:37 | Python Exception <ModuleNotFoundError>: No module named 'imp' 60 2025-1-21 12:20:37 | PythonFactory failed to load python symbol `hdfsconnector.hdfsConnector.HDFSConnectorFactory'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date

Hello, I have a pdf report that I need to parse out. I can read it and create a line by line list. It has a line with employee code/name, then subsequent lines with codes and their values associated to the employee. Here is a sample of the report and then what it looks like when it is read in. I can get it split nicely into rows/columns/attributes no problem. My issue is that I dont know how to break it up in each employees portion and add the employee number to each row.There would be a few hundred employees. So in the end I want to be able to spit out a table that has the columns:Employee num, Code, Description, units, extensions,etc I am very new to FME and just struggling to get it figured out. I dont know if I should be using some kind of loop, python code, aggreator etc. Any help would be greatly appreciated! 

Hi all, I’d like to classify polygons by shape, these might include: pie shaped, L shaped, T shaped.I was originally thinking that I’d have to convert them to raster and use some sort of supervised classification. Another method might be to convert them to centerlines and compare their linework: a T shape polygon would have 1 or 2 lines at the top, meeting at 90degrees to another line point downwards

Hello all, I would like to create a simple FME workspace in which PostGIS writer automatically reads attributes from the reader and adds an attribute with PrimaryKey (there are 30+ feature types in total). Is it possible to do it somehow?  I have seen and tested this method:postgresql - FME PostGIS writer define column as serial/PrimaryKey with pre-existing id values - Geographic Information Systems Stack ExchangeHowever, the goal is to set up a straightforward process with automatic attribute definition. I would really appreciate it if you could share what methods you use.

I need to update an ArcGIS Online feature service using something other than 'OBJECTID' field. In previous versions, I was able to set the "Update Key Field" in the 'Properties' dialog box of the AGOL Writer. In 2017.1 that option is gone. I can't find any documentation or examples on how to set the Update Key Field to something else.Any suggestions?

HiI need guidance / SupportI have an excel where FiletypeName: .MDBPath of the MDB is mentionedWorkspace should read the excel and go to tha path mentioned in the excel and read the mdb for each and it should individual for each   Workspace should go to that path and read the MDB file in which Different FC are mentioned and then write it back with same Name of MDB and Fc in GDB formatKindly Guide me how can i proceedI have attached sample data with excel and MDB

My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it.Is there any workaround for this without having to change the password ?This happens in both FME Desktop and Server.Edit @TiaAtSafe:The password also contains this special characters $&@=Versions:FME Server 2017.1.1.1FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)

Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum!I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are  20+  polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed.  Does anyone have any tips how to solve this?Many thanks!//Andréa  

Hello everyone,I am trying to run the Feature Outline Masks tool from ArcGIS Pro in FME using the PythonCaller transformer. I am new to Python and would greatly appreciate your assistance. I copied the script from the ArcGIS Pro tools website (as shown below) and made modifications to fit my data:# Import system modulesimport arcpy # Set environment settingsarcpy.env.workspace = "C:/data" # Set local variablesinput_layer = "roads.lyrx"output_fc = "cartography.gdb/transportation/roads_fom_polys"reference_scale = "25000"spatial_reference = arcpy.SpatialReference(4326)margin = "5 meters"

I have MSSQL ESRI Entrerprise Geodatabases that are non-versioned but have archiving enabled. As far as I have figured out, there are no ESRI tools that easily copy data with the full archive of the feature class.If it was versioned I could use the ESRI tools for replication…What is the current best methods for an operation like this?

I am using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) - FME Forms.When running a workflow with the Data Inspector, from a file geodatabase with the SpatialRelator, the workbench appears to change coordinates on the fly. The dataset is in British National Grid (EPSG27700) with an expected data format of XXXXXX.XXX YYYYYY.YYY (depending on decimal places specified, ESRI being 3 decimal places resolution in metres).  An example is 283400.7988999998 377644.82890000001.However, inspecting the output, within the inspector attribute table and the feature information windows, this is replaced by an arbitrary grid XX.XXX, YY.YYY. An example is 66.069000000013411 97.342000000017881.  (These examples are different points). This doesn’t appear to be any projection or coordinate system with which I am familiar in this area and seems to be an arbitrary grid. Finally, when I click a point in the Inspector visual preview window, the coordinate system restores itself bac

FME Flow 2024.1 Is it actually possible to terminate a workspace that contains a JMSReceiver? I have a workflow set up and a terminator is triggered if certain conditions are met. This results in a Program Terminated and Translation Failed message in the log file but the workspace is not actually aborted and has to be manually stopped

I have a workbench file that generates the raster created by the QRCodeGenerator. So I have two output streams, the raster itself from the data stream and the PNG created by the PNG Format writer. Each QR code has URL data with dynamic parameters that can open an AGOL feature using the Camera app (Ios) or Google Lens app (Android OS). I’d like to extend this use case futher to include generating an email using the QR Code as a clickable image that opens the URL data of the QR Code.  The way to accomplish this is make the email in HTML with an HREF link to the QR Code PNG sent from that email. My challenge is how to create this email with Custom HTML that will make this picture an inline image on the email and not as an attachment or a reference to a picture stored from another server. Hope I can hear out out some suggestions or snippets of Custom HTML that will create this HTML email with the HTMLReportGenerator transformer.

Hello! I am currently trying to convert the CityGML models into FBX format using the workflow below.However, it was found that the absolute position of the FBX generated would be 100 times less than the original model. Therefore, I added a Scalar transformer in my workflow. There isn’t any problem in display but the relative dimension value would be multiply by 100 as well. The enlarged dimension could not be visually observed even being compared with other normal objects but the dimension value would be 100 times larger. (Not sure if I am describing the issue clear enough)Moreover, I also found that the Aggregator transformer at the end was not actually grouping the surfaces as one surface. They were just grouped under an object where this object was not a geometry. I tried the Surface Dissolver to merge the surfaces but in vain. If I don’t group the surfaces together, they will be exported as a series of Surface Member which would be difficult to manage during viewin

Hello, I have a geodatabase file to update with FME : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several attributes. First in my script, I read the geodatabase file. Then I change some values and create new ones.  Finally, I use a "Esri Geodatabase (File Geodb)" writer to update former data and insert new data at the same time. I chose feature opeartion "upsert" and table handling "create if needed". When I open the resulting "updated" gdb file in Arcgis Pro, I can see the updated data and... only part of the new features. There are several of them missing ! But why ? Here is what I should have : And here is what I get :

I have set up an automation process that retrieves information from an API to generate a report. However, this task has become complicated because an essential piece of information we need to include in the report is located in a different API, which requires an ID to access the relevant data.I am considering generating the report first, which will consist of the necessary IDs. Then, I plan to make a second API call to retrieve the information from the second API, one ID at a time. I have successfully completed the first part, but I am now stuck on the second part and unsure whether this can be achieved using FME or if a Python script is the only solution.