A space to discuss FME Form
Recently active
I have been able to extract polylines from esri fgdb, combine the lines into one record but I cannot seem to figure out how to now recalculate all the M-measures in that line. In arcmap I would manually use the Route Measure editing tools, Set As Distance to 0 and Apply Factor of 0.00018939 to recalculate the line M-measures in miles for the line. I couldn’t seem to get the measure transformers to get the result I was looking for. This was probably user error. Thanks,Ryan
Hello ,Is it possible to control the position of Upper left x and Upper left y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly?I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .
I have a SharePoint Teams Channel that has Documents; a single zip file is the only document that I update. I am using FME Form 2021. I created a workspace using the Path Reader and SharePointOnlineConnector. It uploads a file to SharePointOnline and overwrites the file already there. I run the workspace with no errors. When I go into SharePoint Online, I check the file and the Date Modified does not change. The Date Modified should say “a few seconds ago” or have a timestamp. This is not a SharePoint List. Is there a way to modify the timestamp in SharePoint Online so that I know the file uploaded using FME was updated (overwritten) in SharePoint Online?
I am using FME Form 2021. I have completely re-written this post. What is the best approach to zip all Feature Classes in a File GDB without having each Feature Class show up individually in the workspace? I have 25+ Feature Classes and do not want them all to show up separately. Just want to zip up my File GDB. Sorry about the incorrect subject header.
Hello, I need your help. I'm looking for a workflow to transform my keys and values into a list. Here is an example:I have this table:Key Value a 1 b 2 c 3 a 4 b 5 c 6 a 7 b 8 c 9 and I wanna transform it toa b c 1 2 3 4 5 6 7 8 9 Thank you
If we run SQLExecutor in FME workspaces in FME server 2022.2.2, then we can't connect to the Snowflake datasource. We have this problem in multiple workspaces that run on FME server and for multiple Snowflake databases/schemas. It raises this error:2023-6-29 15:14:13 | Performing query against SNOWFLAKE_NONSPATIAL dataset `snowflake_datalake_acc'2023-6-29 15:14:13 | No SNOWFLAKE_NONSPATIAL dataset name was specified (couldn't find a value for `R_1_DATASET' or `SNOWFLAKE_NONSPATIAL_DATASET')It has strange behaviour. When we load the same workspace, same input database/schema/role, same output database/schema/role, and different data table it can connect for some data tables, but it does not connect for other data tables. Is there a way to solve this? We got this problem when we switched to a new role in FME server for authorization to databases/schemas/tables in Snowflake. We already checked the database connection configuration in FME server multiple times and it is correct since it wo
I need to transform XYZ data from the currently used DHHN2016 height (EPSG:7837) to the older DHHN12 height (EPSG:7699). Unfortunately, the various transforming options don't seem to be able to do this. E. g. EsriReprojector, with "Use Vertical Transformation" checked, only lists <None> as option under "Vertical Transformation". To complicate things further, the switch to DHHN2016 did not happen directly from DHHN12, but first to DHHN92. So the transformation might need to be done with an extra step: DHHN2016 height (EPSG:7837) -> DHHN92 height (EPSG:5783) -> DHHN12 height (EPSG:7699). However there is no option for this way either.Perhaps a combination is necessary? In this case it would be 25832+7837 to 31468+7699 (or 25832+7837 -> 31468+5783 -> 31468+7699). I added the Reproject files to the install directory but that had no effect. I also don't have "PROJReprojector" available for some reason(?).Version:Data Interoperability Fixed OEM LicenseFME(R) 2024.1.2.1 (202
Hello, I have a table with 3 records per house. The table includes hundreds of houses. I want to create a new attribute called Type. There are two types only : A and B.For Type A: two values of attribute a1 per house equal the value of attribute a2 of another record of the same house.For Type B: two values of attribute a2 per house equal the value of attribute a1 of another record of the same house.How can I automatically assign the type to each record of any given house? Thx.
Hello, I am trying to read data of different formats, controlled by a resource list. I isolate web services with a separate WFS FeatureReader, I do not have database resources and for the other resources I use a Generic FeatureReader, with the REAL_FORMAT parameter set to:<Guess format name from extension>Some resources include gml files on a web location (URL). The Generic FeatureReader usually reads them correctly, with one exception that gives an http 404 error (Not Found). I can avoid the error by choosing OGC GML (Geography Markup Language) for the REAL_FORMAT parameter. But I cannot control this from my resource list, only with a published parameter. I have tried adding an OGC GML resource reader, but this does not help. The Guess format parameter apparently does not make the right choice.Does anyone have an idea how to solve this, without adding a tester with a separate FeatureReader or using a WorkspaceRunner?I'm using FME Form 2022.2.4 (Win)Below an extract of the worksp
I'm trying to read some USFS wildland fire data. There's a link to the kml on their website:http://www.wfas.net/google-earth/wfas_nfdr.kmzWhen I use the url in the kml reader, it downloads it to a temp file location successfully (I can see it there) and it's unzipped. It's got a folder structure about 5 deep.Then I get FATAL |KML: Could not determine the root kml file of `C:\\Users\\xxx\\AppData\\Local\\Temp\\FME_OGCKML_KMZ_1562607566639_14376' If I go to the temp file location and navigate down to the kml, I can read it in no problem.C:\\Users\\xxx\\AppData\\Local\\Temp\\FME_OGCKML_KMZ_1562607566639_14376\\fsfiles\\office\\wfas2\\dir-obs\\wfas_nfdr.kml
I am downloadning data by several url from different organisation webpages that I later import to tables in a Microsoft SQL server database.I want to get the information if all the attributes that I exposed for a datasorce isn’t containing any values (the value is missing).Is it a way too choose all or multiple attribute at the same time and test if they contain any values?I have data that has like 50 attributes and it is going to take a long time to manually set like a test for each of this attribute individually.
HiI work with stream processing and need to validate data in real time against a database using for example a database joiner. We have an MQ connector recieving large volumes of real time data. For best performance, I need to cache the dataset I am validating against, but the question is, what is the best way to update the cache? The data is updated in the database once per hour and there is 1.000.000 records in the table. A timewindow change can trigger cache update in Fme, but I can´t find out how to solve it, and what readers/transformers to use./Stefan *Edit, caption should be Stream processing….Cant edit.
I am going to read Data from ProjectWise. FME could read Folder trees (as attached picture) but accessing to folders is not possible. (my user name and passsword are correct)(Also I have the Bentley CONNECTION Client installed and logged in.)The IT guys said that they useAPI version 2.8.Is there any solution to solve this issue?Thanks in advanced
I am fairly new to FME and I am trying to pass an Excel file pathname to systemCaller so I can use it in a Python script. I need to use the SystemCaller as I am using a bat file to change virtual environment and then call Python.What I am trying to do is get FME to just pass the Excel filename via a user parameter to SystemCaller using this statement"C:\temp\Excel_processing.bat" --input "$(excel_infil)"where excel_infil = “C:\temp\Excel_processing\infile.xls”But I get a “File path is incorrect” error in the logger (not in english, so the error is a translation). I have even tried to just hardcode the input filename to the statement but get the same error. I tried this:"C:\temp\Excel_processing.bat" --input “C:\temp\Excel_processing\infile.xls” If i just use the statement "C:\temp\Excel_processing.bat" in SystemCaller, then I dont have any issues and the .bat/python script works as expected but I need FME to pass the filename along. I have a bunch of echo statements in the .bat file bu
I have a file A from which I am reading the creation date through a “Directory and File Pathnames Reader”.Now I want to add the date as data in a column of file B.It should look like this:ID path_created_date 1 2025-04-04 2 2025-04-04 I tried using AttributeManager, but what I get is this:ID path_created_date <missing> 2025-04-04 1 <missing> 2 <missing> I am very thankful for any other ideas or solutions.
I’ve been trying to process IFC data and convert it into a GDB format, however when running it will just stop processing at 19%. The workspace as worked with other IFC datasets but with a few of them it will stop at random arbitrary percentages too.Has anyone run into this issue before and is there a solution?
Hello everyone I've been designing a new custom transformer to sum up part of my workflow (in FME Form 2025.0). The issue is that I can't add any of my attributes to the text editor even though all attributes are selected to be exposed in the input parametres.Moreso, If I edit it individually, no attributes appear (as obvious), but if I edit them inside a workbench session and I choose specific attributes to expose, they are still not availaible in the text editor, but they get instead automatically added as user parametres for the custom transformer. Can anyone explain me how this works? I don't get a clear answer from looking at https://docs.safe.com/fme/2025.0/html/FME-Form-Documentation/FME-Form/Workbench/Using_Custom_Transformers.htm#Editing_Input_Output_PortsIt also irritates me that it’s theoretically a copy of another transformer with a couple of changes (only adding transformers or changing their parametres, none with the inputs) and that transformer allows to add feature att
FME Form 2024.2.4 on Windows Server 2016 I’ve been using the SlackConnector transformer for quite some time to send messages when jobs have finished in both FME Form and Flow. It’s been working without fail for the past two years.Just recently we had to reinstall a few things on our VM which caused our user accounts to be wiped. This meant all our existing connections had to be recreated.Unfortunately I’m no longer able to create the webconnection in FME for Slack as it keeps failing on the authentication step telling me “your browser is not supported”. Slack stopped supporting older browser on 15 March 2025I initially thought the default browser was causing issues so I set it again to Chrome, but I think FME Form must be running an in-built version of IE or something. I’ve also tried recreating to connection of various other machines running windows, but same issue. I can’t seem to find any way of forcing FME to use another browser. I saw on the FME known issues page a workaround by
I am seeking to mimic a script tool in ArcGIS Pro that I’ve constructed. The script tool provides a user with a list of fields within a shapefile, feature class, or feature service once the user has supplied the file path. Once the field has been chosen, the user can then select a feature from a list of features in the dataset with information from the field selected in the previous step. This allows the user to indicate a feature to run from a dataset rather than running the entire batch of features. I am struggling to find a way to prompt FME to assess an input file to provide that sort of list (in ArcGIS Pro this is done with the Validation page of the script tool). I’ve tinkered with incorporating User Parameters, but I feel like I’m missing something. If this sort of process is possible, I’d welcome some feedback and suggestions!
I have two layers: one raster with population data for each cell (blue) overlapping polygons (buffer of 100m) around existing road segments (red)I would like to know the total population contains in each polygon. How do I do this in FME?
Hi everyone, can you please help me out with this one? I have a vector layer with canopy heights. For example:name, index0-1m, 01-2m, 12-3m, 23-4m, 34-5m, 4As the features had been captured by LiDAR, they overlap each other. I am trying to clip the features to show max canopy heights, if that makes sense. 0-1m will be clipped by canopy heights >1m, 1-2m will be clipped by canopy heights >2m, 2-3m will be clipped by canopy heights >3m, etc.I don't understand how to set up a loop in a way that can filter and dissolve higher canopy heights. All feedback and suggestions are appreciated.
Auto attaching transformer to a link is a great feature. But while moving multiple transformers some of them they attach to links without such intension. If not noticed it create a lot of problems.
Unable to connect to IBM DB2 in FME form 2024.2. I’ve checked with other members of my organizations’ logins and those work fine on my machine; it’s just this particular user that is having issues. Please see attached screenshots
I am using the CoordinateSystemExtractor to extract CRS from shape files. The output attribute _coordsys is an abbreviated name and hard to make use of it downstream. For example. the shape file prj file has the name “NAD_1927_BLM_Zone_15N”, which is an ESRI standard name. But the _coordsys value is _NAD27.BLM-15N.ft_0. I would hope the output is NAD_1927_BLM_Zone_15N so that I can use it directly in EsriReprojector. Any idea to achieve this? I have an excel file with over 150 global CRSs that need to reprojected to WGS 84. Both the sources and transformations in this excel file use standard ESRI names. Want to use this excel file to reproject all source datasets (shape files) into WGS 84 using just one EsriReprojector for which both the source and destination CRS parameters are set directly from the excel file. If you know a solution, please send reply to my work email - allen.guan@woodside.com. Appreciate the help.
HelloI would like to copy files contained in an input folder to two different destination folders using filecopy writer, but I can't set two different destination paths.Do you have any suggestions?Thanks a lot in advanceEnrico