FME Form

I am having issues running workspaces on FME Server that contain Python 3 (using Esri GIS Python module). This is the error I am getting: The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.6+', which requires an appropriate version of ArcGIS Pro or ArcGIS Server. If ArcGIS is not required by this workspace, then update Python Compatibility to a non-Esri-ArcGIS Python. Otherwise, please install the required ArcGIS product, or if ArcGIS Desktop already installed, update Python Compatibility to 'Esri ArcGIS Python 2.7'. To update this setting, go to: Navigator -> Workspace Parameters -> Scripting -> Python Compatibility Environment Details: FME Desktop/Server 2021.2.5.0, ArcGIS Pro 2.8 and ArcMap 10.8.1 Per the compatibility page (

The FME Python environment is a bit weird, to say the least, which makes it difficult to use in various contexts. It's a Windows Python embedded installation, with the bundled and user-installed libraries in non-standard paths. As stated by the Python doc linked above, this installation doesn't officially support using Pip for package installation (due to the sysconfig paths likely being invalid). For dependency management, I would honestly much prefer using a virtual environment, but the python311 installation bundled with FME 2023 doesn't include the ven

Hello everyone,I am reading a google sheet with Google Sheets v4. The reader runs but it does not read some of the columns. I do not get any errors. how is that possible? I thought maybe because those columns cells are empty they can be read and then I added values in some cells but that was not the case. it still does not read them. in the workbench when I view the source data they are there in the sheet.  

Hi All,Novice, here.   I am trying to work with two different layers where I want one set of data to overlie another set of data.  I don’t know how to move the lines, adjusting them so they will match the sister layer.  I have tried Neighborfinder, anchored snapper, was looking at affiner, orientator and geometry coercer, and any other transformer I thought might work.  I suspect there are many steps involved in this process, but I really don’t know where to begin.    Below is an example of my data set.  I would like the black lines to match the red lines.  Is this doable in FME? Please let me know if more information needs to be provided.   Thanks for any help.  It is greatly appreciated! Version: ME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)   

Hi,Is it possible to add a map of a feature/layer in an HTML report using the HTMLReportGenerator? Thank you in advance

Hello there, How can I clip a Raster image using FME ? Thanks, Siva  

As a beginner, Can you give or help me very very detailed step by step process guiding me to build FME workbench for this geometry and attributes gap findings with line shapefile feature in FME ? Please help with any logical approach or steps or solution to find attribute name continuity gaps finding in a line features as with existing roads names or street names on it. For more details you can mail me on my mail id : actual.abhijeet@gmail.com

Hi, I am in need to convert an attribute with “188-195” as value (Wich means 188up to and including195) in “188;189;190;191;192;193;194;195”.How can this be done in FME workbench 2024.1.0.0.With a  combination of transformers AttributeCreator, AtributeSplitter, ListElementCounter, ListExploder and AttributeManager I am be able to produce the 8 new features. THNX.

The system integrate data from ArcGis API Services(source) to Microsoft SQL Spatial DB(target). When the api side have new row of data, i want to check if the data that is already pulled to DB is already existing using let say object_id field. I cannot use upsert at the writer since the flow is that we do not the want any change of pulled data since it will need to go through manual approval for any data changes. How to insert new row of data only without updating existing data? 

I need to incorporate a custom coordinate system definition into FME Form, but can’t find the right parameters in the online form to fulfil the definition.The following parameters define the map projection, but e.g. ITRF does not exist anywhere in the online tool.projection type: Gauss Kruger (Transverse Mercator)reference ellipsoid. GRS80datum / reference frame. ITRF2005central meridian. 11° 20’scale factor at central meridian. 1.0false northing. 0.0 meterfalse easting. 1000000.0 meter How can I create a proper fme file with these parameters?

Hello,I have a Navisworks 3D file of our facility that needs to be viewed in ArcGIS Pro and published as a 3D Scene. We exported it out to a fbx for City Engine which is then exported to a scene layer package to be viewed in ArcPro and this “works”, but we have a only layer with zero attribution. Is there a way I can either use the original Navisworks file or the fbx to break out the all the features withing the facility and create an output as a multipatch gdb?  sorry for my noobnessthanks in advance.-C

If yes please may i request you to share me demo workbench ?  If NO, is there a workaround to convert Navisworks files to IFC format ?   Any suggestion / idea / workbench is more than highly appreciated forever . I also request FME experts who even have little know-how please requested is your little for any leads . thank you / Br

Hi everyone,Curious if I could pick your brain on the workflow below.I would like to just write the asset_id field values from the GIS feature class into the corresponding assetID field in the API table. I’d want to write the asset_id from the GIS FC to the assetID field in the API table only if the assetID doesn’t exist in the API table. They have different field names.Curious where I would place the HttpCaller transformer with the PUT request in the workspace.The GIS EGDB reader would be at the start of the workspace exposing the relevant fields. Once I rename the asset_id field from the GIS feature class to match that of assetID for the API table, what would I do? Could I hook up the output from an AttributeManager directly to an HTTPCaller without a Creator?  

Path issues while attempting load Python module. FME Pip installed Pypdf. It got installed to: C:\Users\james.hawks\Documents\FME\Plugins\Python\python39\pypdf But workbench cant see that for unknown reasons.  Python Exception <ModuleNotFoundError>: No module named 'PyPDF'

Hi everyone,I need to update the block attributes with the csv data, but I don’t know what I’m doing wrong. Can someone check my script and with this issues? I’ll really appreciate it. 

Hi, I have a JSON that I want to "flatten”, Currently, it has this structure. {"A":{"id":"1","Name":"Aa","IsTrue":"True"},"1stList":[{"Type":"Yes","Number":"100"},{"Type":"No","Number":"100"},{"Type":"Maybe","Number":"1000"},{"Type":"Unknown","Number":"11"},{"Type":"Hh"}],"2ndList":[{"X":"10","Y":"100","Z":"Abc","Q":"Def"}]}{"A":{"id":"2","Name":"Bb","IsTrue":"True"},"2ndList":[{"X":"10","Y":"11","R":"100000","Z":"Efg","Q":"Klmo"}]}{"A":{"id":"3","Name":"Cc","IsTrue":"True"},"2ndList":[{"X":"10","Y":"12","Z":"Lmno","Q":"Stuv"}]}Just reading it with the following parameter settings doesn't work:Flatten Nested JSON Values into Attributes: YES I've tried with 2 listexploders after reading, but that also doesn't give the correct result.I just want the endresult to be a flat table. How can I best achieve this in FME? 

Hi,I have a FME workbench and in the Fanout Expression, i have to manually amend the date (YYYY-MM) in the file name each month from 2024-06 to 2024-07 when running at the start of the month for the previous months data.E.g. the fanout expression will look like this:R@Value(ba_id)-2024-06-filename.xlsx So at the 01st August I would amend the above filename date to 2024-07. Is there a way to automate or code the date so I don’t have to manually change from 2024-06 to 2024-07 etc.

I am having 100 individual text files consist of Point feature..So..........At a time, How could i convert each files into KML files respectively? 

To reproject WGS84 (Lat/Long) to GDA2020 (Easting/Northing) in FME v2024.1, the only option appears to be via GDA94.  This moves the data approx. 1.8m NE as it assumes that WGS84=GDA94 and GDA94+1.8m = GDA2020.While this is usually what people use, there is a need for a second option of WGS84=GDA2020 (ie a Null transformation + Geographic to Grid) as other software packages, such as Conquest have adopted this.  For more information see: https://www.spatial.nsw.gov.au/__data/assets/pdf_file/0008/224396/WGS84_and_Australias_misaligned_web-maps_Information_Sheet.pdf. Is this something that FME will be implementing anytime soon?

Hi FME Enthusiasts,I am trying to run a fmw file by running a batch file. I tried to read smallworld data then convert into some other format. I create a batch file to execute but reader does not read the data. So I passed single record as input and ran the bat file it could able to read and converted into my destination format. but if i passed 100 records it was taking long time and waiting at “Getting feature using command number: (0)” it not moving further. If I manually run the same data with same fme workbench straight , which is working fine without any struggle. if anyone faced this kind of scenario early?.   

We have some text fields that shouldn’t have any UNICODE characters.  Turns out at least one has snuck into the data.  Is there a way to Test to find UNICODE characters and then remove them?FME 2022.2.3

I'm still a newbe to FME considering below.I'm trying to query open data from the Dutch https://public.ep-online.nl/api/v4/Mutatiebestand/DownloadInfo?fileType=csv (API-key required, available from https://epbdwebservices.rvo.nl/) to get the data from a csv-file. HttpCaller works, url obtained with JSONFragmenter (attributes to expose: 'downloadUrl’)+testfilter (to get the actual url). However, I can't seem to use this url in an FeatureReader or further HTTPCaller to actually get the data itself from the csv-file. Copying the url (contains a token valid only one time) does download the file from a browser as a zip-file, but how can this be done in FME?I tried to look at 

I have read through this post to try to get a fix but it doesn’t address the issue i am having.The work flow is…use a Directory and pathname reader to get a list of zip file in a specific folder. sort by path created date sample the first 1 feed the path widows to the reader (esri geodatabase reader or featurereader [preferred]) I am trying to capture the feature datasets within the gdbI have gone to the parameters of the fgdb featurereader and exposed the geodb_feature_dataset format attribute as well as the fme feature type.I have also gone into the generic port and exposed the same. it does not show up as an attr

When exporting to shapefile from GeoServer/WFS one can specify encoding in the request, for my case I specified UTF-8.This shapefile has a cst-file that establishes the encoding (similar to cpg from ArcGIS).When I read this in Workbench/Server 2022.2 the fields have encoding cp-1252 and some garbled characters. If I change the filename to from cst to cpg the attributes come in with the correct encoding.Is this fixed in later versions, or should it be reported as a bug… ?

I have a LOD 0(BUILDING FOOTPRINT) file and a LOD 3 Building 3d model file. Lod 0 is in shapefile format and Lod 3 is in gdb format. The gdb file have no attribute value and lod 0 have. so i want to add its attribute to gdb. How to do it?