FME Form

Hello! I have problem to write several geopackage data to one geodatabase. I used Attribute filter and Dynamic writers. Attributes from all objects comes to each features. How to write data to geodatabase so that there are each features has own attributes? I am not profs with FME yet :) Would be thankful for tips.

How do we read AGOL relationship classes/related tables in FME? The published table can be imported separately but the relationship linkage is not maintained in the parent feature service. Is there a way to import feature service in a way from where the related table is linked?

Hello, I'm attempting to use an attribute with HTML as a value into the HTML2PDFConverter. What's odd is that said transformer asks where the HTML will originate from (a file, attribute, or URL), but when you select one of those options, it's still asking for the other two as a requirement. Is this a bug?     

Hi all!I'm reading spatial data from a MapServer hosted in organizations ArcGIS Portal. The query is made with HTTPCaller, and the response is in EsriJSON (by default). I then extract the "geometry" part of the response json, as well as some other attributes from the response, with PythonCaller and replace the geometry with GeometryReplacer to FME Feature Geometry, so that I can perform other spatial tasks with FME later in the translation.  However, I noticed that some polygons returned from the query contains holes inside of them, or they should contain (this is confirmed from the source data), but after the GeometryReplacer, the holes are not holes, but filled with a polygon, and the Geometry returned is a multiarea with polygon part of it on top of the polygon itself! This behaviour happens, when the Geometry source encoding is EsriJSON. The MapServer can be queried so, that the response format is in GeoJSON, and when I perfomed the same method with the GeoJSON encodi

I've created a workspace to call a lot of wms services - and I'm not getting the right response. When I copy the URL to a browser the %EF%BB%BF appears in my string - this I cannot se within FME. How can I fix this ?

Hi, I want to simplify some line geometries which may be single or multi part IF their coordinate count is greater than a fixed value. Is there a simple way that I can apply a generalisation based of max resultant coordinate count rather than a tolerance setting where the post generalisation coordinate count will not be know until until after the generalisation has been applied. In the latter situation if the count still exceeds my threshold the tolerance would have to be increased, and generalised once or multiple times? I was interested to know if I could go straight to my max value rather than having to create a looped process? I am using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64)  Ultimately I want to create a WKT Geom encode which does not exceed a fixed string length. For this I know that each line should have no more than ~1250 vertices, so I want to simplify the line to this number if the coordinate count exceeds this. Regards, Rob

So essentially the lines are the boundary of this polygon. I have tried spatial relator which only sometimes gives me a 1 to many join on every other line, I tried neighborfinder but I can get the attributes to copy over. I have specified merged attributes but it doesn't seem to be working. Not sure what I am doing wrong and help will be appreciated. The images show what I would like to achieve in FME.

Hi everyone.I am trying to obtain a csv file with some information about several raster files. One of the attributes I need to get is the number of pixels with a determined value (in my case I need, among others, two attributes for each raster: the number of pixels with value=0 and with value=255). Is there any transformer for that?Thanks!

I have some Autocad data where the objects are constructed as 3D solids, like this:The 3D data is nice for many uses, but I would also like to extract a simplified version for our GIS databases. The Surface Footprint Replacer will generate a nice polygon, but will also remove the elevation and return 2D data.  Is there a way to get a footprint that retains the elevations of the "top face" of the solid? I most cases this face is flat, but in some cases, like ducts and pipes, this is not the case.

When I am trying to open GPKG file, I am receiving the following error: Workspace generation failed. Parameter file was C:\\Users\\MITINA~1.UPW\\AppData\\Local\\Temp\\FME_1695313458867_14324. I have tried reinstalling the software.

I have a workspace writes data from one ArcGIS database to another. I used the drop and create option on tthe tableI get the error , [DDL operations are not allowed across database boundaries.]} My question is how can ArcGIS allow you to drop a table but not create it again? This was very inconvenient. Is there anyway to stop FME from droping the table if it does not have the permission to create a new table?Best regards,Kicki M My error message:Geodatabase Writer: Dropping table/feature class `DBO.GVF_GEOM_TMP'Geodatabase Writer: Creating feature class `DBO.GVF_GEOM_TMP' in feature dataset 'gdbhmag.DBO.hmag'An error occurred while attempting to create the feature class 'DBO.GVF_GEOM_TMP'. The error number from ArcObjects is: '-2147220989'. The error message from ArcObjects is: {The operation is not supported by this implementation. [DDL operations are not allowed across database boundaries.]}GEODATABASE_SDE writer: A fatal error has occurred. Check the

Hello! I am trying to add an attribute to a table from a dataset that is specified by the user. This input data varies in attributes, so I don't know the format of them beforehand. However, I am consistently just adding 1 attribute to this data and writing it to another table. It looks something like this: The first dataset that I input works fine, but any dataset after that does not match the attributes of the first dataset will not go through properly. I've done some research on dynamic workflows in FME, but I'm still struggling a bit to find a solution to this. Any ideas?

FME(R) 2023.1.0.1 (20230831 - Build 23620 - macosx-aarch64)

This is what I am trying to accomplish in FME:A. Read a .jpg file, clip collars, add GCPs.B. Feed that into a GeoTiff reader to convert to GeoTiff.C. Feed the GeoTiff into a CADRG writer (requires GeoTiff for input). I've done this with some (limited) success using "reader to GeoTiff writer",then "GeoTiff reader to CADRG writer". (see my previous post on how the resultant GeoTiff raster was flipped horizontally) As the GeoTiff is an intermediate format, how can I streamline this flow? Thanksbill  

We are currently using FME server version FME Server 2021.1.3 and FME Workbench 2021.0.1 and we wanted to upgrade the FME server to the latest version, so if we upgrade the server will it be some issues with the old workbench automations already running in the FME Server. Or the old workbench is compatibile for the upgraded FME server ?  

Hello ,i am trying to create a connection by SAS token between FME and Azure it works great when I create SAS token for all data inside the storage container ,then use this SAS token in Azure File storage connector in FME .but in case i specify one folder inside the container then generate new SAS token then use this sas token in FME ,it does not work in Fme .my question : How could I create the connection between FME and Azure storage for only specific folder ?i do not like to let FME has access to all data in Azure Container  FME 2021Thanks in advance  

I have two data sets - one is a 'main' dataset and the other is a 'lookup' dataset containing further information. In my main dataset I have a columns called 'Visibility' and 'road_condition' that contain a range of values from 1-13. There are over 4000 rows in the dataset. In my lookup dataset, I have 'code' and 'Column' columns that contain further information relating to each record in the main dataset. See screenshots of the data below.  Is there a way to create new columns in the main dataset called 'Visibility_Info' and 'Road_Condition_Info' that merges the data from the main and lookup datasets together without filtering each of the values in the 'Column' column individually before passing the data through to a FeatureMerger?

I need to write a couple of 100 tables from postgis into several geopackage files. This should be a pretty simple job? But the workbench fail OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int' This is related to https://community.safe.com/s/question/0D54Q00009SAyLQSA1/geopackage-dynamic-writer-error-unsupported-type-mediumint?t=1669103461721 and a follow up https://community.safe.com/s/question/0D54Q00009w0K1ZSAU/ogcgeopackage-writer-primary-key-attribute-id-has-unsupported-type-mediumint?t=1694607976804 "It seems like FME is trying to write a 32b integer when its expecting a 64b integer" Is there a solution to this problem? I need something stable to run in a production environment, this job will run nightly.  I can easily script what I want to achieve using ogr2ogr (append several postgis tables into one or several gpkg)Simple exam

Hi FME community, I am trying to start a job on FME Flow from another application by making use of a webhook and a token. The trigger results in succesfully starting a job on FME Flow, but the response is most of the time the following:502 - Web server received an invalid response while acting as a gateway or proxy server.It looks like this only happens when the job takes longer than 2 minutes. Does anyone have an idea where the 502 response comes from? This indicates an error while in fact the job is started as expected. Version 2022.2Build 22765 - win64

In a lot off my workspaces I need to fetch some 'global' values based upon user input. Example: user needs to provide project name: first check if projectname complies with the rules, once that is ok, use some api's to fetch global values for that project.Now those global values are in an attribute and need to keep track of those when using attributekeepers, list builders,...I can set them as a global variable with variable setter but it means that I need to use a lot off variable retrievers (10+).  Is there a way that I can put that value in a private parameter so that I can use it across the workspace without the variable setter and retrievers?

I am having problems using the FME Define custom Coordinate System Tool (demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw).​I want to make the ITRF2014 coordinate system that is in ESRI available in FME. I have used this ESRI WKT file from ITRF2014 - EPSG:9000 :​GEOGCS["ITRF2014", DATUM["International_Terrestrial_Reference_Frame_2014", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]]​However, when I test the new coordsys files I get errors. Any help in tracking down what I am doing wrong would be greatly appreciated.

Hello everyone! I'm a new FME Desktop user seeking some guidance. I've successfully managed to join tabular data with an existing GIS layer and write the data using the ArcSDE Geodb writer with the "truncate" option to update an existing feature class. Now, I'm looking to automate a new process in FME. Specifically, I want to join a table to a feature class and calculate one of the fields in the feature class using a value from the table I've joined. Is it possible to achieve this without overwriting the entire feature class, only updating the specific field's value? Your insights and assistance would be greatly appreciated!

Hi Everyone, I am relatively new and in my current position I am replacing someone who was a bit more advanced than me. I understand a lot of what the workspace is trying to do (and it worked in FME Server) but once we migrated to FME Flow, the workspace no longer works. The premise is similar to the FME Demo "Map Based Data Distribution". The difference in our workflow has an Input Project Area instead of an Area of Interest which allows the user to upload a shapefile or use our municipal boundaries which is stored in our Repository. We also create a waiver for our Digital Licensing Agreements, but that's a User Parameter with "yes/no" and with either setting, the workspace/app fails. I've included images for the parameters for the FeatureReader (but not the connection parameters). For "Feature Types to Read", we have a User Parameter ($(FEATURETYPES_2)), which is Choice List. It's the FQN of our Feature Types in the database connection file (

 Hello Forum, I notice that when FME Form convert a dataset from one format (e.g.: .tab) to geopackage it adds a field called 'id'. So, two questions: 1) Do geopackage files always have, and have to have, an id field?2) Or is there a way of asking FME Form to not create one/delete it? It doesn’t seem possible via an AttributeManager or in the Writer’s User Attributes. I've noticed that, separately, if I read in the created geopackage I can then use an AttributeManager to remove the id field and then publish again. But there are two problems with this… 1) It's a faff. I'd rather not read in, write out, read in, and write out again. But..2) even after removing the id field via an AttributeManager, the id field always appears in the output geopackage file. This makes me wonder if an id field must always exist in geopackage files.  I've also noticed that when creating geojson files FME seems to create a ‘fill’ field and a ‘stroke’ field, which I can't remove. Is