FME Form

I'm sure other people must have workspaces running this, but so far the only transformer I found was the emailer and no Email writer. At the end of the workspace I want to send an email to one of our staff summarizing what happened in the last week (how many traps were visited, names of the land owners and their contact details). This data is of course all in the workspace already. How do I set this up so it goes in one email with ideally a table of the above? Not individual emails per property. When I go into the Body of the Emailer transformer I see there are values I could add in (that looks like lists. They have {}), but when I actually run the process these values are empty in the email. None of them appear. I am not far enough along in my FME journey to understand how lists work yet... I think I might need to use a counter or aggregator so only one feature hits the Emailer transformer, but that feature would need to contain all the data I want in the body of the email. I also

I have two datasets, where one (a) is holding x/y/z coordinates and the other (b) contains a distance value. I created a line, based on the coordinates from dataset a, and after densifying the line used a measure to get values I can compare to the distance values provided by dataset b. The distance and measure values are not perfect matches, and I would like to accumulate the attributes from dataset b to dataset a based on an a rule like the following: IF 'ref_length' >= 'start_length' AND 'ref_length' < 'end_length' This is what I have so far 

I have a csv with numerous fields that have ( 323244,232324245) and would like to know how i can get rid of the brackets and keep the data

Hello fellow FME’ers! I have a case where I need my on prem FME Flow to listen to certain messages from my FME Flow hosted instance. I want job a job to trigger automatically when a FME Flow hosted job has run. It looks like this is not an out of the box thing. Or is it? for the record: I don’t want to solve this with a schedule task!How would you trigger your FME instance A to run after job on FME instance B has run? A can communcate with B, but B can not send messages to A.  

Hello everyone!We have a file format that we work with, which is used by our engineering world to create bills of quantities for engineering projects.The name of the format is SKN, and in fact it is very similar to csv/excle,Is there a way I can just read it and put it in my workflow?I am attaching an example of the file here (zipped)Thank you!

The ERDAS IMAGE Reader cannot workHey！I encountered a problem in using the FME workbench.The problem occurs in FME Desktop 2022.1-FME Desktop2022.2 ，If the ERDAS IMAGE reader has set the “Use Search Envelope” and “Clip To Search Envelope”, it cannot work normally. If FME2022.0 is used, the ERDAS IMAGE reader is no problem.the ERDAS filesize is 16GB​

I am looking to use the output of the postgres/postgis function as an input to my fme workbench model, I want to pass the parameter to such postgres function through fme workbench interface and want to use the output generated after running the function .

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