FME Form

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows.  Logs say:2024-05-24 11:32:20|  18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20|  19.1|  0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exact same setup (both for python and fme) it does work without any issues. I checked the debug file for both, the o

Main question: how to create polygons at point locationsWithin FME 2024.0 I created a point dataset of cross sections with 866 points.At each location I want to create a square, which is sized 10 by 10 meters. The current points should be in the centre of the squares.Any suggestions how to achieve this?I tried the Bufferer but did not find the right settings yet to get a nice square at each point location. Output should be like the blue squares in this image:  

 Hi, I’m using a change detector to see if any updates has been made from the new data, to the data  on ArcGIS Online. Previously I had the error about missing ObjectID on updated records, but I fixed that using a feature joiner from this Guide: How do I write updates to an existing ArcGIS Online feature service? – FME Support Center (safe.com) I got it working on points, lines and polygons, however if I want to update tables, I get the above error. By a search I found that this error has also been found in Survey123: Send Error Code 1000 - Esri CommunityTalking about GlobalID’s, I did try to activate GlobalID’s on my table service, and add that in my feature writer.Anyone who knows how to fix this?Thanks

Hi folks,I have the following error when I run my Workbench project : 2020-04-17 08:05:41| 785.3| 0.0|ERROR |SpatialRelator_15_Output Feature Recorder -1 2147615062(RecorderFactory): File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR |File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR | I've read some other articles about similar posts here, but I did what was suggested (FME Options > Translation > Log Message Filter and unchecked "log Debug") I'm using an FME Professional Suite (FME 2018.1.1.1, build 18578 - 32 bits). Even in a 64 bits version, the error message is still there. You can see that it begins to write datas, but then stop.The log file is attached and the error messages are line 9611 and after thank you for any help ! Patrick  

Hi,I have a workspace to translate a Shapefile to DGN. The shp file has a attribute wich I can filter data to output in three different levels. In this levels, two of them, only have contour style, but the other one is full. When I write DGN file, the level with full style is on the top, so the other levels are hidden under this one. I've tried to put the level number in an attribute called idgs_level, but it doesn't work. I've also tried to put the level number in the writer parameteres, but doesn't work. The issue is, how can i control the order of the levels?Thanks 

I think I may have run into unexpected behaviour. I’m trying to pass some text in a user parameter via a workspace runner but it’s stripping out the quotes within the text when I try to retrieve it.The text I am trying to pass through to a child workspace:"Building_Use" = 'Residential'In the log of the workspace runner it gets passed along in the command line arguments as:--SQL_WHERE_Clause {${="Building_Use" = 'Residential'=}}'and the child workspace receives it correctly when initiating the workbench as:``--SQL_WHERE_Clause' `"Building_Use" = 'Residential''.But when this is retrieved via a parameter fetcher or attribute creator it drops the quotes in the child workspace:Building_Use = 'Residential'However if I run the child workspace on its own (not via the workspace runner) it retrieves the text correctly. I can workaround this by replacing “ with another character before and then replacing it within the child-workspace, but I feel this shouldn’t be necessary. I couldn’t find anyone

I am trying to to transfer records with jpg file attachments between two seperate AGOL hosted feature services. The source has also has point geometry which is stripped out prior to passing into the target table. I've been able to create the target table by using the AGOL feature writer, but I'm unable to access the attachments - even though I've exposed the attachment attributes and ticked the "include attachments" parameter in the feature reader.Does anyone have a working example of this transformation?Thanks in advance,Brett

Hi,I have multiple features, for each I need use an Oracle sequence to get the ID of the feature.Then I need to write the feature to the database. The ID must be unique.I have used a SQLExecutor to obtain the sequence next value. I am struggling when there are multiple features to write. FME is executing the SQLExecutor multiple times before getting single value for the ID. I need to process each feature at a time i.e. run through SQLExecutor, get the feature ID and write feature to database, then proceed to next feature. Any suggestions ?  

I am having a problem with the counter transformer in multiple workbenches on multiple machines: It ofthen does not start at the set value (ussually 0 or 1). For instance; The counter in the image is set to start at 0. However: When I run the workbench it starts at 577. I have no clue at al why it does that.  When I use featurecaching and I run the whole workbench one by one transformer it will start at 0. But ONLY when I manually start every single transformer before the counter. I have this on this machine and another computer in completely different workbenches. I use the counter to merge features. the workbench stops because it can not merge features based on wrong counts.  

All two-point lines when exported to DGN, are saved as ‘Linestring’, not ‘Line’.I have a problem with this in the later stages of working in OpenCity Maps. All two-point lines are displayed as ‘Linestring’ and none of the functions work properly for me.In DGN Writer I select : Two point Line output; Type 3 Elements .Please, can anyone tell me how to write these lines as ‘Line’?

 I want all columns from the excel sheet in the table, not selecting them one by one in the column settings, is that possible?

I am trying to run my workspace on the command line, using a command file.fme COMMAND_FILE C:\Projects\330004063_Test\cmd_file.txtIt takes a bit, not as long as I would have expected, considering the test run of the workspace in the workbench, but then I get the following three lines, and everything is over.Reading...Emptying factory pipelineTranslation was SUCCESSFUL with 2 warning(s) (0 feature(s) output)The content of the command file looks like this:C:\Projects\330004063_Test\fme\figuring_things_out.fmw --DestDataset_OGCGEOPACKAGE "C:\Projects\330004063_Test\output\roads_test1.gpkg" --SourceDataset_SHAPEFILE_4 "C:\Projects\330004063_Test\input\KTM_Baseline2019Roads_EW50.shp" When I run the workspace in the workbench it takes 7.5 seconds to run through the data and is producing the expected geopackage, containing 11.433 features.The command line run does not seem to process anything. At least there is no verbose handling of the processing. It also does not produce the expected test1

Enverus’s Developer API has a custom header option to change the location of next link from the header to the body. When I put X-Omit-Header-Next-Links in the header of Postman I get the expected response: Results from Postman​​​​​putting X-Omit-Header-Next-Links in the header of HTTPCaller seems to be ignored as no next link is in the response body and the link remains in the response headers.HTTP Caller with X-Omit-Header-Next-LinksBottom of response body in FormReturned API header attributes in Form​​​​​Am I doing something wrong or has anyone experienced this behavior?Thanks in advance,Randy

I would like to know the name of the localization language file for FME FORM 2024. I know that the localization language file for FME Desktop 2020 is named transformers-localized.* (for example, transformers-localized.zh). I want to know if the new version has changed the name of this file.

Hi everyone, I have an Excel file containing SQL WHERE clauses used as Definition Queries in an ArcGIS project and I want to use the same SQL WHERE clauses in my workspace to create subsets of my data. Is there a way to "convert" these SQL clauses to Tester test clauses? I managed to do a lot with some StringReplacers, to the point where regular (att1= 'this') and list clauses (att2 IN ('this', 'that')) are covered, but I also have a lot of LIKE clauses (att3 LIKE 'th%') and I can't seem to get these translated to Tester's Begins With .  I know about the capabilities of the FeatureReader's Constraints, but in my analysis I need both the entire dataset I am querying AND the SQL-clause-derived-subset. And I want to prevent reading in the data twice, since that slows down my workspace a lot. Thanks in advance everyone!

Another one from my daily work:Is there any chance to find “spikes” in elevation to avoid situations like this in 3d view? I already found that there is spike remover but my job is to only find them.Red lines are bridges and they should look like a little bit smoother :)Attribute which they are based on is “F_ELEV” and “T_ELEV” Please help me with identifying such situation using FME.Shapefile with this situation: 

Hello everyone,Based on the following video I was delving a bit into the Classifier transformer in combination with the FeatureColorSetter and I was quite pleased with the possibility of coloring polygons based on a class.I assume making maps such as traditionally done in arcgis pro, is currently not possible in FME.However, since it's now possible to create chloropeth maps or give classes random colors now based on classes generated by the Classifier Transformer, I  was thinking it might be a nice step in the direction of being able to create maps in FME. My wish would be as follows:You could for example use the classes id (generated by the Classifier transformer) and a label for the classes id to create the legend for the map.A title can then be filled in by the user and maybe a scale bar can automatically be generated based on the extent/coordinates of the data. Moreover the user can move where the following objects should be placed on a landscape/portrait on some kind of preview sc

Hi,I’m massively confused on why certain machines in our office cannot connect to our Floating License Server. We previously had 2 floating licenses (esri edition) and bought a third seat; we then consolidated all three licenses under one Smallworld line item according to this article. To test, I opened FME on one machine, redirect the licensing assistant to use the new smallworld licenses, and everything works great. When I test on another machine however, I can’t connect (previously could). In the error diagnostics, FME is saying that it can see the FME Licensing Server correctly over the server and port information I provide, but won’t connect. I included some text from the diagnostics below:“Connected to a license service running on standard port 27000 on server MYSERVER”“The license service running on port 27000 on server MYSERVER (IP) does offer FME licenses. It provided the following license information: safe: UP v11.15.0 Users of FME: Cannot get users of FME: Timeout. (-139,100

I use the feature reader to read data from PostGIS, I created a user parameter in feature reader to get the feature type to read. However, it did not work if I select multipule features (tables) from my postgres database. It only works when 1 feature type is selected. Is this a common issue of FME?   

II read from a FGDB do some processing then I want to write back (update) to a field in the same FGDB.  I have a FeatureHolder immediately  after reading the FGDB to force complete reading before writing.  The Where clause  make sure I only update records with matching PremiseIDs (original source data and stream data).  I only want to update one field but I don’t see how to specify that field in the FeatureWriter.  In a AttributeManager before the writer I remove all other attributes than the one I want written.  Not working. 

I have a dgn Model and it’s meshed there are some mesh elements in the model but FME is not recognizing them. AppearanceRemover is rejecting them, Geometry FIlter is returning them as null geometry. These elements are visible in microstation and looking absolutely fine. MISSING_GEOMETRY_APPEARANCE  This the rejection code from APpearnce Remover and if I skip Appearnce Remover and pass it to geometry filter it returns the featurs as Null.

Ok soooo, for the longest time I’ve been a bit annoyed at the Terminator for it’s seemingly inconsistent behaviour about when it chooses to report it’s error message in the status result of an FME Server job and when we get the generic - “An error has occurred. Check the logfile above for details”.Anyway it has gotten to the point that I’d like to actually figure this out and I’ve at least found a couple of workarounds which are working for me. Looking at the solutions it is kind of obvious and I’m not sure why I didn't think of it sooner. Anyway I thought I’d share my findings - probably other know about it but I couldn’t find anything clear on the community or in the documentation.1. Use a FeautreHolder, then into the Terminator,2.  User a sampler set to sample last 1 feature and feed that into the Terminator (probably better for memory).The workarounds aren’t great because they don’t halt the translation as soon as possible - but at least the status message is there. Anyway, just wa

Hello,How can I make a workspace to convert excel sheets into a pdf files?I have tried everything but nothing works.Is there anybody who succeeded in this?Thank you in advance!Anne

What exactly does those FEATUREs stand for in a FME Form concurrent license file (safe.lic)? Where do I find a description / explanation?FEATURE FME ...FEATURE FME_GUI ...FEATURE national ...FEATURE basic_raster ...FEATURE segy_reading ...FEATURE segy_writing ...FEATURE smallworld ...FEATURE fmeobjects_reproject ...FEATURE ssis_extension ...FEATURE spatialbiz … Thanks.

Hi,It's possible to use FME Desktop to obtain indices like NDVI from images without downloading them? Thank´s