FME Form

Hi, I have one table that have attributes called months of the year, that begin in OUT_24, NOV_24...until SET_25.My workspace will run month by month by workspace runner. In my workspace sometimes the value is filled in OUT_24, in the next execution NOV_24...until the end. How my table can be updated if OUT_24 have a values only for example? I would like to ignore attributes with missing values. I try this code in SQLExecutor:  UPDATE ARCGIS.BTA_SAT_NDVI_pl SET MAR_25 = @Value(MAR_03) WHERE COD = @Value(COD) AND NEW_ID = @Value(NEW_ID); But don’t work for me...because I need to change SQL after SET to attribute with value. Thank´s

我在PyCharm中导入fmeobjects模块时，提示：ImportError： DLL load failed while importing fmeobjects： 找不到指定的模块。PyCharm项目设置中我已将python解释器的路径添加了，但是我发现出现以上问题的根源在于FME 2024.2.1安装目录下的“fmeobjects”文件夹下没有对应python版本的fmeobjects.pyd文件，这是什么原因造成的？又该如何解决呢？

Hi, Is there a way to read the JSON file. JSON file consists of user parameters. I created scripted parameters for the all the user parameters but the scripted parameters are not able to read the values of the user parameters in the JSON file. Scripted parameters contain python that reads up the json file and fetches the parameter for that specific parameter. Is there any solution to read the user parameters in the JSON file? User parameters in the JSON file are dynamic.

Hi,I am working with FME Desktop, and at a certain point, my features have a "Month" field with values such as 10, which refers to October, 11 meaning November, and so on for all months of the year. The table that will receive this value has columns ranging from OCTOBER to SEPTEMBER. How can I make FME understand that if the column has a "Month" value of 10, the "Average" field should be renamed to OCTOBER, ensuring that the values from the recently renamed OCTOBER field are recorded in the table, which also has a column named OCTOBER? Thank´s

Hi,I need using attribute value to create another attribute, but the @Value<attributeName> no work in attribute creator.Can you help me? Thank´s

This monring i upgrade FME version 2024.2 to last version FME 2025.0 and after upgrade i start my workbench which include “Bentley Microstation V8” reader. FME give a message “Module 'acad/ACAD' is unavailable for use with this FME edition” why ? I resarch old topic in the Community some body had some problem at 2022. But no body give any solution way for fixed this problem. Also i found acad.dll in C:\Program Files\FME\plugins\acad. What is real problem ?  Note: After uptdate FME i am uninstall Autocad Map program from my computer. Think couldnt any relation maybe, because the Autocad differntly program.

When publishing any workspace to FME server, with files that need to be uploaded, i get the following error. Publish failed - FME Server encountered an error and reported the following message.The resource name must not contain any of the following characters: \\ / : * ? " < > | & = ' + % # non have my files have these characters Its happening with any new workbence, and it doesn't seem to matter what the reader is. even simple workbence, with a reader straight to a writer fails to upload.  Wondered if anybody has encountered this.Using FME Server/desktop 2020.2

 Hi everyone,I have a set of consecutive lines, and I need to detect when there is a digitization direction conflict between them. As shown in the image below, the green arrows represent the direction of my lines, but Line 2 is oriented differently compared to the others.Is there a way in FME to detect such conflicts? Ideally, I’d like to flag or filter out the lines that have a reversed direction compared to their neighbors.  

I have configured all parameters on manage web services for Dropbox. But I am having to reauthenticate every time I run the workspace. What should I be checking? I also need to schedule it on Server. I am not being able to authorize it on Server as well. Any feedback is highly appreciated.  

I’ve read a couple of posts on this, but I’m still not perfectly sure on how this works.I have over almost a year been working on and refining a flow. Since I keep getting new updates from the project, the flows has became large. It became into 3 flows, that could maybe have become 1, but I don’t think it would be that easy, at least I’m not up for that task. It consist of multiple feature readers and multiple feature writers. Each flow takes up some data from the other. For example something can have been made in a file Geodatabase or on ArcGIS Online, and the next flow would then use that content.So, I easily enough just want to run those 3 flows, by one click in workbench. I would expect just to create something like this. I just find it’s strange to connect it like that.Is it that easy?  

I have different IFC files which I want to read and transform.The geometries each contain a Transformation Matrix. From the FME Form Documentation I know they are not applied.How can I apply them?I tried to extract the parameters (with TransformationMatrixExtractor) and then used the 3DAffiner, but with no result.Ther must be a more convenient way, right?!

I have a shapefile with a coordinate system defined which I'm using to test my workspace. I'm using the coordinate system extractor to check if there is a coordinate system. The _coordsys attribute comes up empty. But the shapefile does have a coordinate system. Why might this be happening?

Hi all, I have a workspace that preps all input features by reprojecting them to GDA94/ Australian Albers and then calculates input area. When I run the same feature (as a shapefile, but different different coordinate systems) I get different Area values even though they’re both in the same Coordinate System.I ended up testing the features with an AreaOnAreaOverlayer and turns of there’s really tiny slivers across the boundary of the feature (I don’t know where these slivers are coming from?). I added both the shapefiles in ArcGIS Pro and followed the same process- reproject and calculate area and both area values are coming out as the same in Pro. I am unable to figure out why I’m getting this difference in areas in FME but not ArcGIS Pro. The difference is tiny but ends up changing the final stats.Screenshots attached. Any help would be greatly appreciated.  

Is there a way to connect to Autodesk Build and retrieve photo's and Forms? Either through a connector or through the API. I can get acces to Autodesk Docs but I need acces to Build as I would like to add the photo's to a webmap.Because the API acces to ACC Build makes use of a three-legged authorization I see no possibility to do this. The process needs to allow for a pop-up and I don not know a way to avoid this. I hoped it was possible to use a webconnection in conjunction with an httpcaller but I do not know how.Does anybody have experience with this and perhaps an example?

LineOnLineOverlayer after upgrade from FME 2020 to FME 2024 output there is a count difference in outputs. The data used for both version is same, In FME 2020 the tolerance parameter was none while there is no such option in 2024, so used 0 as tolerance value. Still showing count difference.

I am attempting to post a JSON body to an API from an HTTPCaller Transformer.  I have postman setup and can succesfully post through there.  I am not sure exactly what is happening now as i get a 400 Error through FME Both processes are being done from the same computer on the same network. HTTPCaller_2 (HTTPFactory): An error occurred while accessing the URL 'URL/api/v1/integration/inbound' Here is a screenshot of my HTTP Caller  Here is my Sucessful postman Post 

Dear All,I’m  working with two datasets that share a common key: Station ID. Each dataset provides coordinates ( latitude and longitude) for these stations. My objective is to determine whether the station with the same ID have identical location in both datasets or if there are discrepancies.To achieve this, I need to calculate distance between the corresponding coordinates from both datasets. While this seems straightforward, but I encountering challenges in implementing it effectively. I would appreciate any help on the best approach.Thank you in advance.BR//  

How to convert polyhedralsurfaces(voxels) stored in database with addtional attributes stored in columns into cesium 3dtiles?Additionaly to export the data in a suitable format to view voxel and its attributes?

Hi Everyone, I’m kind of stuck with a problem with my Geopackage writer. For a client, I’m working on building a script that generates multiple Geopackage tables, each with its own name. Each Geopackage table writer uses a fanout to automatically provide the writer with the needed file name. The writer also uses a Geopackage with styling embedded in the database, with 0 features, as a template file. This template is provided by an engineer from the team, which should automatically style the Geopackage based on the attributes it has. The problem occurs when I have both fanout and template file enabled. This causes the Geopackage to only write certain features. I can’t find any logic behind why it writes some features and not others. The template file and the Geopackage writer are 1-to-1 copies of each other, and I get no errors/warnings regarding feature issues. For example, one table, which consists of 470 features, will write 233 features, and 237 features end up somewhere in space. :

I’m am using WorkspaceReader to document my workspaces. Is there a way determine what annotations are linked to what transformers?

  Im fairly new to FME, I have a programming background, and I was hoping to bring those skill here, but i can see is not fully the same. So I apologize before hand 😂 I have a custom transformer that does a API calls and loops until it finds “last-batch” set to true from the Header area. For Reference Here is the custom transformer:The first call uses uses the InitialHTTPCaller, which uses the the request url and access token from the main workbench. Here is a screen cap: The _response_header list will have the variables I need to determine if the its the last-batch = true and the next batch url. The JSONFragmenter, is exposing the values for _response_header{5}.value,_response_header{6}.value.I have a tester that checks if _response_header(5) is true to go the pass else it will fail and will go to Output and call upon the Loop to the NextPage.  When the NextHTTPCaller gets called it will be using the User Parameter named NextUrl of which im setting it with the @Value(_response_header

Hi.I'm using the ArcGIS Portal Feature Service writer to do some inserts, updates and deletes on two feature services, one with line and one with points. The inserts and deletes works for both featureservices, but update on lines fails with the following error (operation rolled back for all of the features): ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'Operation rolled back., Operation rolled back.... There are about 2000 features I need to update, so my best guess is that the jsonobject for update is too large. The update works fine with up to 200 features. What would be the best alternative for updating the line feature service? One way might be to create some kind of loop to update 200 lines at a time, but how?

Hi, I have a workspace using an ESRI ArcGIS Server Feature Service reader with a token authentication. I am trying to read 3 feature types from the map server and 2 of them read fine but one comes back with the error:  "ArcGIS Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Error performing query operation'. Details: ''" Does anyone have any ideas of why only one of the feature types would not work? The three feature services should all have the same naming standards and schema so there is no reason why they should behave differently that I can see. Are there any suggestions for how I might be able to find the source of this issue?  Any help would be greatly appreciated! Thanks.   

Hi,Does anyone know of a method where I can readily identify which transformers are affected (ie need an update / fixed / superseded!) when updating from one version to another?Whilst I know there is documentation with each release, is there an easy way to compile a list that could be read into a workbench?I am also aware that each transformer has a version number.I want to create a method for identifying which workbenches are going to break before updating the software!I am hoping someone has already thought of this and the solution is already built… Any help much appreciated.Stu

Hi Im using the AGOL feature service writer to write to our AGOL account but it is not working correctly. The workbench reports that it has been successful with the correct number of features. However, when you open the item in AGOL, there are features missing. The last one I tried had 80k reported to have written but only 4k in AGOL!If I use write a fgdb locally and then the ‘ArcGIS Online Connector’ transformer to upload the file and another to publish it, it works fine. However, I cant work out how I could use this to do updates to the hosted feature service when the data changes (Ive got this sorted with the writer)Im using FME 2023.2 (dont really want to upgrade until 2025.1 is out as its a proper pain to upgrade server) but if there is an issue with the older version of this transformer I will.Does anyone know why the writer is not working but the connector is? This data is business critical so I need to ensure that it is correct.Thanks