FME Form

I have the following scenario.We use FME Form to gather public data. The data gathered should be written into a MSSQL database. Since we mainly work with ArcGIS Pro, and other ESRI products our MSSQL  server has an SDE extension on it.As long as I work in Form I can easily use sde connection files to access the databases. However, publishing a workspace utilizing an sde connection will result in errors since we do not have an ArcGIS Pro running on the same machine as our FME Server.Until now I was using the reader and writer ‘ESRI ArcGIS Portal Feature Service’ but this isslow, and requires published feature services in the ArcGIS Enterprise portal.I got our IT to open the firewall for direct access of FME Server to the MSSQL server and installed the latest msoledb drivers after getting the following error:Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259) Named Pipes Provider: Could not open a connection t

I have a dozen files in a folder. I was able to use the Path Names Reader to write the File Name, Upload Date, Upload Time, and File Size to the CSV Writer.  Does anyone know how, or if it is even possible, to get the name of the user who copied/uploaded a file into a folder? I see in the Pathname Reader the path_ownername attribute, but all this has in it is the value “Administrators”, no user name. 

Hi there, I wonder anyone can help me to resolve the issue I am having with FME 2023.2.1 installation on Windows 2012 R 2 Server. I have the following error opening FME.

I have a workspace that writes to a simple Excel sheet. The sheet has 3 columns: Report Name, Upload Date, and Upload Time.In Excel you can set a Filter for each column allowing a user to filter the data in that column. In Excel, I added a Filter to each column, but when I write to the sheet in FME Form, the Filters disappear. Is there a way to “keep” or “add” a Filter to each column in the sheet by tweaking a Writer parameter or is there another Transformer I need to add before the Writer? The screen capture below shows what I would like the sheet to look like:  

I have a list of lab test results and only want to include the rows that match a list of analytes. I am trying to use the IN operator in the tester transformer.I have followed the advice from this post:Help with syntax when using Tester transformer | Community (safe.com)This is what I have:Sheet1 contains the test results, text_line_data contains the list of analytes as one feature. I have merged them to get this: The “text_line_data” column looks like this: My tester transformer is set up as below: However, all rows fail the test. What am I doing wrong?  

Hi All,  I have a table with a 'route_ID' and a measure value (like a event table). On the other hand I have a polyline feature classe.  The attribute 'Name' correspond to route_ID from the table. The measure values are points on the lines. Now the measure values changed by a predetermined value (e.g. the point was 10 m and now the point is 10.5m). My Problem, the Polyline feature class is not defined as route form a linear referencing system. And so the table and the Polylines have no relations. I don't no where (which coordinate) my old and new points are.  Can I build a route feature class with FME? The Basisc should be my polyline Feature Class. I would have assumed a route feature class, how can I creat points (with coordinates) form the table?  Thanks for your help.  Debby

My work colleague is trying and failing to connect to Oracle Spatial.I suspect that her installation of FME is slightly broken and she lacks the access rights to the folder where FME connections are stored.When she goes to Tools | FME Options | Database Connections FME pops up an error message "Unable to retrieve database connections"And she is also unable to create a new database connection.If I knew the folder location, we could check if she has the proper access rights assigned by IT.Thanks,Nick

 I have a workbench build in version 2022 using active choice to enable and disable parameters based on other parameter values. This option stopped working in the new 2023 version.Does anyone know if the active choice is discontinued?Thanks

FME Desktop 2022.1 crashes when trying to read Esri File Geodatabase - Reader works fine with any other format including Arc SDEs but crashes when setting format to File Geodatabase and trying to browse local drive

Hi, I have a gdb with pleanty feature classes with unique schema and I use SchemaScanner and Dynamic gdb to save the layers. Feature layers saved in the gdb have correct schema but the order of the columns is wrong, it looks like the new feature layers have the columns ordered alfabeticaly  

I am having issues with glacial speeds of using a delete from statement within a SQLExecutor pointed to Oracle Database. The SQL query is something like:DELETE FROM ABCWHERE ID = @value(id)AND TO_CHAR(DATETIME,’YYYYMMDDHH24’) > @value(timefrom)AND TO_CHAR(DATETIME,’YYYYMMDDHH24’) <= @value(timeto) (note: The query above is paraphrased and might contain syntax-errors, I have checked and confirmed the syntax in the actual version) The Oracle Table contains about 40 million rows, so I expect this to take some time (1-5 minutes per query) but not the >30 minutes for the first query (at which point I gave up, I have not confirmed if the query will ever finish) Currently I am using a workaround of Loading the primary keys of all features that fit the selection criteria and using a writer to DELETE all corresponding records, but this seems unnecessarily inefficient and wasteful. I can imagine that the error is caused by Oracle not returning a ‘succeeded’  or ‘finished’ message, causi

I have XML file with features I'm trying to read.. that works. Next step is to create a polygon for each feature, I have a string with points that make the polygon. String looks like this:  173363.252 587903.412 173363.369 587902.665 173362.055 587900.798 173363.867 587888.745 173364.007 587887.815 173371.744 587888.843 173368.618 587904.7 173363.252 587903.412 That's a list of x and y coordinates, now I can't figure out a idea to make polygons from it. Any ideas? Do I have to seperate them, create lines and make a polygon from it? Any help is appreciated.   

This is how the initial output from my ftpcaller looks like ( calling a csv to attribute)and this is how it looks like when i sort it by file contents.Any transformer that i use after calling the data uses the first screenshot, thereby inhibiting me from automating any process.I have to download to file, open and save it and then re add it to a second script to manipulate it and push it to AGOL ( which is my end goal)

I would like to convert a json file to csv using a csv writer from a json fragmenter. How do I convert it? The json file is an output that is generated using API tokens. When I run the FME workbench, the translation log is successful. But when I try to inspect the data, I get the below error message. Please look into it and do the needful.  An error has occurred. Check the logfile above for detailsCSV reader: Failed to open file 'C:\\PSDCitywide_towns\\Lake simcoe\\LakeSimcoe_Trial_17J2024\\@Value(Assets).csv' for reading. Please ensure that the file exists and you have sufficient privileges to read itCSV reader: Failed to open file 'C:\\PSDCitywide_towns\\Lake simcoe\\LakeSimcoe_Trial_17J2024\\@Value(Assets).csv' for reading. Please ensure that the file exists and you have sufficient privileges to read itAn error has occurred. Check the logfile above for detailsFailed to specify the feature index as constraints on the readerAn error has occurred. Check the logfile abov

Hey guys, I have a fairly large dataset of lines and points. The points need to receive the Z coordinate from the nearest index on the line. Using the CoordinateExtractor followed by a ListExploder isn't an option because that would be too heavy for my workspace. Isn't it possible to use the CoordinateExtractor in a way that in the setting 'Specify coordinate' you only extract the index that is nearest to a point feature? Is there a different way to go about this?

HelloI would like to create 3D objects, I have footprints, DEM, LAS file of building. Roof of the buildings are pretty unique, so It's hard to use Extruder on it, do you have any idea to create 3D objects with unique roof? And then I would like to separate roof and the body. Could you help me?

I have an FME session set up, from shapefile to shapefile with a renamer. My number fields go in as "Long". They are set to come out as "Long". When I pull the output into ArcGIS, the format is "Double" What am I doing wrong?

Hello,I encountered an issue while using the RasterObjectDetectorSamplePreparer to prepare samples for the RasterObjectDetectorModelTrainer. My goal is to detect certain objects based on a digital orthophoto image. I created an annotation.txt file using OpenCV and provided the relative paths to the negative samples directory and the annotation file as inputs to the Sample Preparer transformer. However, when running my workspace, I received the following translation log message:Translation FAILED.The translation was terminated due to the following feature:RasterObjectDetectorSamplePreparer_<Rejected> (TeeFactory): RasterObjectDetectorSamplePreparer_<Rejected>: Termination Message: 'RasterObjectDetectorSamplePreparer output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''The feature on tag `PYOUTPUT' fail

Hey Everyone, I hope this message finds you well. I'm currently working on a project involving data center integration, and I've run into a bit of a snag. I'm using FME to handle spatial data transformations, and I'm encountering challenges in seamlessly integrating data from various sources within our data center. Specifically, I'm dealing with issues related to data format conversions, data quality assurance, and ensuring smooth interoperability between different systems within the data center. I believe some of you may have experience with similar scenarios or could provide valuable insights. Here are a few points I'm struggling with:Data Format Conversions: How do you efficiently handle conversions between different data formats within the context of a data center using FME?Quality Assurance: What are your best practices for ensuring data quality as it moves through various stages of the integration process? Any FME transformers or workflows you recommend?In

(This is a spin of question from https://community.safe.com/s/feed/0D5OO000004YH4O0AW, but I thought it made sense to rephrase the question) I am trying to run a shell script from SystemCaller but for some weird reason I can not make it work.  My command line is: cd "/Volumes/disc1/test_systemcaller/" && my_script.sh 25 5The numbers at the end are parameters for the script. The error I get from the log file is:sh: my_script.sh: command not foundThe file 'my_script.sh' is placed in the actual folder, so should be found.If I test the file path by asking it to do something simple, eg mkdir, it will happily do so in the right place.If I run the command from Terminal it works fine.  I made a second script in the folder with a mkdir just for testing. While it works fine in Terminal, FME claims to know nothing about it. Since system caller cant find the script file, even though it is in the folder, I guess that something might be wrong with my syntax? I'm on a Mac if that matters. 

My fmw is saved in a directory called C:\\DATA\\VariousTasks. A parameter called InputFolder is pointing to a subfolder of this directory. Is it possible not to use FME MF DIR predefined parameter ? I use a text parameter to point to C:\\DATA\\VariousTasks\\DEV but the script is replacing it automatically by "$(FME_MF_DIR_USERTYPED)DEV" when executing which translates to C:\\DATA\\VariousTasks/DEV . I am using a python script later and python is every sensitive to / and \\ . How can I force FME to use C:\\DATA\\VariousTasks\\DEV instead of $(FME_MF_DIR_USERTYPED)DEV (translating to C:\\DATA\\VariousTasks/DEV) ?

Hello! I would like to create LOD2 buildings, but somehow, my files don't show their own citygml relations between parent_id and gml_id. Could you find me some errors in my workflow? I created gml_parent_id as a field already. eg.)<?xml version="1.0" encoding="UTF-8"?><core:CityModel xmlns:brid="http://www.opengis.net/citygml/bridge/2.0" xmlns:tran="http://www.opengis.net/citygml/transportation/2.0" xmlns:frn="http://www.opengis.net/citygml/cityfurniture/2.0" xmlns:wtr="http://www.opengis.net/citygml/waterbody/2.0" xmlns:sch="http://www.ascc.net/xml/schematron" xmlns:veg="http://www.opengis.net/citygml/vegetation/2.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:tun="http://www.opengis.net/citygml/tunnel/2.0" xmlns:tex="http://www.opengis.net/citygml/texturedsurface/2.0" xmlns:gml="http://www.opengis.net/gml" xmlns:gen="http://www.opengis.net/cit

I have a workspace that takes a spreadsheet that contains these fields: And I've got that reader feeding into a FeatureReader that grabs the Source Dataset feature classes from a specified .gdb.  I would like to dynamically create a new attribute called "_description" and populate it with the values in the Feature Description column. The values that are referenced in the Feature Description column are not exposed, but I can view the values when I click on a feature in the visual preview. I've tried to use an AttributeCreator with the following parameters:However the output looks like the literal string input values, instead of dynamically grabbing the values from the feature:Is there another way I can achieve this?

I have an error connecting to older version of ArcGIS Portal (10.9.1) from latest version of FME Form/Flow (2023.2.1 b23774). Does anyone know how to resolve this issue? 2024-01-23 20:15:03|  0.5| 0.1|ERROR |Python Exception <SSLError>: HTTPSConnectionPool(host='<portalURL>', port=443): Max retries exceeded with url: /portal/sharing/rest/generateToken (Caused by SSLError(SSLError(1, '[SSL: UNSAFE_LEGACY_RENEGOTIATION_DISABLED] unsafe legacy renegotiation disabled (_ssl.c:1006)')))2024-01-23 20:15:03|  0.5| 0.0|ERROR |An error has occurred. Check the logfile above for details