FME Form

I've gone into Manage Web Services and managed to configure the Microsoft Mail (safe.emailer) web service and it tests and authenticates without issues. However, when I add the Emailer transformer from Hub and go to select the Email Service from the Service section I only see Generic SMTP and Gmail. Is there something special I need to enable or refresh for the transformer to see my new web service? edit - have tried this in both versions of 'Form' I have installed (2022.0, 2022.1) thanks

The webhook is coming from a hosted FS on AGOL set to respond to updates and creates. There are 10 'pieces' (layerids) to the feature service and I'm only interested in triggering a workbench when the layerID=0. I've imported the JSON keys and made them available to the filter action. I've tried many different formatting methods in the 'Contains' setting but no matter what I put in there the filter always fails and logs another message that it has failed. I've got a fairly simple workbench I'm trying to trigger with the automation but since the filter fails the workbench does not run.

Hi guys i want to create a kml file with jpgs inside (they are inside a local folder) and when i click on the location jpeg pops up...... i have set up my workbench like this EmbedImages-in-KML.fmwt but the locations and the information about the jpgs FME is writing the right way ...but what i have to do when i want the jpg to pop up? write the path in a hyperlink or a special kml writer format attribute? Greetz and thx Franco

I have a workbench that uses the chartgenerator to create a simple chart graphic that goes into an automated daily email. image below: Blue line is the recent readings and the orange line is a limit (it looks static but it fluctuates throughout the year). I'd like to add a ten-day outlook to the orange line but the chartgenerator can't handle null values on the blue line, it throws the error: ​ ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numeric ​ the htmlreportgenerator can handle the null values but when it's embedded in the email as html content the chart is not in the email, I am assuming it's being scrubbed out by outlook and am left wondering if there is a way to covert the html output to an image which can be embedded in the email. Desired output: ​

This is part of larger script, where the goal is to generate multiple rotation alternatives for a series of polygons. In this case, I have a 5-vertex closed polygon, where the midpoint of its "tip" is located in the center of the axes (0,0). What I am trying to achieve is, after generating a series of rotations from an arbitrary point -located in the feature's upper segment (see blue point in pictures below)- to calculate the shift in coordinates the rotation caused, in order to move the whole polygon accordingly afterwards, so the "tip" midpoint of the rotated polygon is again place at the center of the axes. Please see pictures below for better understanding : In picture one, the original position of the polygon is shown, where the midpoint of the tip is located in the center of axes. In the second picture, a clockwise rotation of 45 degrees has been applied, where the blue point has been used as an "anchor" (0,31). In the third picture, the shift has been implemented, where the midp

Hello, I have have two different html files coming into HTMLayouter : A costum html file bearing specifications for a drop-down menu A file with charts AND a table. Before those two html files are joined into one with the layouter the table exists. After it the table seems to be erased and only the charts appear. Three charts of this: Normally there should be a table like the table attched.

I'm trying to buffer a line then divide it into equal distance sections. I've tried chopper but the resulting segments are not equal length and some are split awkwardly. How can I accomplish this in FME?

Hello , i would like to create a line between two attributes that has coordinates at same table This table has many points . Id_1 | x1 |y1|id_2|x2|y2 x1 ,y1 relates to id_1 x2,y2 relates to id_2 Both of them are points. How could I create a line between id_1,id_2 and add text that include the value of id_1 and add text of value of id_2 FME 2021

As an eg. there are 4 records i wanted to check how many null values are present for each records .

I'm trying to write to a table in Azure SQL using a sde connection file. There is no error when running the workspace but nothing change in the table. What could be the issue?

P.S. When I have managed to get this to work, the attributes from the various features read by the FeatureReader aren't being written.

Hi Community, I'm trying to run an existing FME 2018.0 workbench on FME 2020.2. and just received ArcObjects is: '-2147219879' error. Tried to search online but couldn't find the workaround/solution. The FME workbench reads a GDB and applies metadata based on XML file as well as an excel file. Attached the log file for reference. Any help more than welcome 🙂

Within Sophos can exclude event id but as file locations for each transformer is different would have to keep adding them. Command used to install like below. Have excluded paths with no success. Is it possible to install transformers from command line rather than within FME application. Tried to use below command but file not found. Manual install may get round Sophos blocking . Thanks in advance for any advice supplied. pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\PackageFiles\\safe.s3connector\\python --target C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\python\\safe.s3connector --upgrade --no-compile fme-amazons3'

I'm working in an Oracle database, where there are multiple duplications of features with matching geometry that shouldn't be in a table named "TDS71"."METADATASRF". There are millions of records, and I haven't found a native FME transformer that can handle this in a timely manner (Matcher, AreaOnAreaOverlayer, etc). So I'm experimenting with deleting the duplicates in SQLCreator. For now, I'm simply just trying to return all but 1 of the duplicated geometries, and will worry about deleting after I can identify them. The code below is returning many more features than expected. I'm not really sure why to be honest. For example, a feature is duplicated 6 times in the database. From the query I have currently, 15 records are returned. Does anyone have experience doing this in SQLCreator/Executor? select a.OBJECTID, a.SHAPEfrom "TDS71"."METADATASRF" a join "TDS71"."METADATASRF" bon sdo_relate(a.SHAPE, b.SHAPE, 'mask=equal') = 'TRUE'and a.OBJECTID < b.OBJECTID

I have workspaces that allow a users to define an area of interest when looking for data. Instead of the openstreetmap coming up, now it is just a grey box. Coordinates still get passed, but the user cannot see where they are drawing their polygon.

Introduction: I am encountering an issue with an Esri ArcGIS Server Feature Service link. Over the past few days, the link has been functioning correctly; however, starting yesterday, it started throwing an error. As a newcomer to FME, I lack the necessary understanding to interpret the error message, specifically the AttributeError: 'NoneType' object has no attribute 'name'. I would greatly appreciate any assistance in resolving this issue. Problem Description: The link causing the problem is as follows: Link: https://mapservices.weather.noaa.gov/tropical/rest/services/tropical/NHC_tropical_weather_summary/MapServer/ Details: Upon accessing the aforementioned ArcGIS Server Feature Service link, I receive the following error message in Python: Python Exception <AttributeError>: 'NoneType' object has no attribute 'name' Request for Assistance: Since I am new to FME, I am unsure about the root cause and implications of this error. I am seeking guidance and support from individuals experi

Hi folks, While working with some JSON data, I seem to have noticed that null values are sometimes interpreted as a literal string, instead of a true <null> value (like non-existent/empty). When I just tried to replicate this, it seems that different FME JSON transformers seem to handle null values in a different manner. E.g. when using a JSONFragmenter or a JSONFlattener, it seems that null values are indeed recognized as true <null> values (like non-existent/empty), but when using a JSONExtractor or an XMLXQueryExtractor (with a JSONiq query), it seems that null values are returned as a literal string. Of course in the latter case I could add a NullAttributeMapper transformer to change the literal string 'null' to the <null> value, but this seems like a bit of a workaround (and also, how would you then distinguish between a literal string value "null" in JSON, and the true null value) Is there something I'm missing, or is this a bit of a bug? Kind regards, Thijs ps. see the below scr

PDF2TextReader does not recognize my published parameter for selecting a pdf file into the transformer. Is there any workaround this? PDF2TextReader runs when I select the pdf file directly but not when I use a parameter in selecting it.

It looks like Deployment Parameters might make some of our processes more manageable. Is it intended for use with workspace runners? Is there any documentation out yet for this new feature?

I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it. Has anyone dealt with a similar issue before?

I have a table of values with ID, Start, and End. Starting with the first row, I need to select the next row where the start value equals the end value of the first row. I need to repeat this process for the entire table. For example, I'd select row 1 then row 4 then row 6 then row 9 then row 13... Any thoughts on how to do this?

For a job that has been working for years, it is now endlessly polling job status and returning awaiting worker. In Server, the last message you get is about the Socrata Write executing. In the desktop software you get more information and it reflects endless polling. Something has changed and I'm having trouble figuring out the cause. 2 of 24 of these (county specific) ran and the rest hung, and now even the two that ran initially will hang. It appears to be happening in the last step involving the Socrata Writer. This is the last log information, with the "Polling the job status: Awaiting worker" repeating endlessly. Other jobs that write to Socrata are still working. It isn't blanket failure on writing to Socrata. Any thoughts on cause or leads to investigate are welcome. Thanks Socrata Writer: 0 features treated as points, 0 features coerced to point, 0 features with unsupported geometries written without geometrySocrata Writer: Invoking Socrata DataSync with control file action 'A

I have a zip file that has a csv file and multiple jpgs. I tried a CSV feature reader-- not a CSV reader-- as I was trying to read the file with in the zip file but that didn't work. I am using FME 2022.2.2. Is there a way to only extract a particular file from the zipfile? I dont want to unzip the entire thing as it will take a long time. Thanks in advanced.

I have this GML dataset (https://service.pdok.nl/hwh/administratieve-eenheden/waterschapsgrenzen/atom/downloads/administrativeunit.gml). I tried all kinds of configurations with the different GML readers (although I expect the INSPIRE GML reader to be ready for it). I can't get it to work. I also don't have much knowledge of the ATOM standard. Any directions for help?