FME Form

Hello,does anyone know why the Truncate Existing Function in Esri SDE Writer does not reset the OBJECTID Counter of a registered Table. (Table is not Versioned).SDE Writer File is based on World Parameter (not SID) and I am using ArcGIS 3.1.4 and FME 2022.2 (but had the Issue also in constellation ArcGIS 2.6 and FME Desktop 2021)The data is written on Oracle 19.15BrGoran

I have three separate CSVs (readers below in yellow) to which I have added several transformers. I first added a “AttributeFilter” to filter through two values. I then connected to an “AttributeValueMapper” to map the previous two values to given names. Then I added a “StatisticsCalculator” to sum the values within these two values. Then an “ExpressionEvaluator” to convert the values from feet into miles and after an “AtributeRenamer” to rename the field names. Lastly, I added an “AttributeCreator” to add a third field of data. This is seen in the picture below of my workflow. At the end of the workflow, I added an “AttributePivoter” in an attempt to merge all of these together before attaching a Writer and exporting the results as an Excel Sheet. I am not sure the AttributePivoter might be the best way to merge all of this. What would be a better approach before adding the Writer?Thanks!

I have a raster wherein the values are in epoch time (number of days since 1970-01-01)Is there a way in FME to convert these values into different date formats, such as yyyyddd?DateTimeConverter seems to only work with attributes, but translating all pixels to polygons with attributes for the pixel value is not optimal. I would guess this could be possible with RasterExpressionEvaluator, but if someone can give an example that would be really helpful. Thanks!

Hi folks, I had some urgent need at my workplace, as the GIS database administrator working in a electricity distribution company, I was required to draft out various district data to be used by another department which will require me to decode and clean the data to enable them understand the data format based on their needs. I tried using manual method of copy and past after extracting this data from the database but it was time consuming.I tried FME and I was able to create a workflow using two transformers FeatureJoiner and Matcher and I am happy how this workflow was able to query the two excel files added to the left and right part of the FeatureJoiner transformer thereby giving me the output based on joined attributes file, one is coming as a number and varchar.  Feel free to connect with me on linkedin https://www.linkedin.com/in/anthony-ezema/ 

Hello Folks,I am working on a use case where I need to retrieve data for retail shops closest to my current location or a given set of geographic coordinates.I am attempting to implement this using an FME Form; however, I am encountering difficulties in obtaining the current location dynamically.If anyone has experience or insights on how to effectively retrieve the current geographic location within FME or through any integrated approach, I would greatly appreciate your guidance. Thank you in advance!

Hello, I want to cut raster data with a shape data. There are 10 objects in the shape data and 10 raster data. Sometimes the objects in the shape data overlap. There is a column in the shape data that contains the names of the raster data. I want to cut each raster data with only the object with this name. I couldn't find the result despite trying very hard. I am using the clipper transformer. If you have any advice on this subject, I would be very happy.

Hello, I’m trying to create a custom chart (waterfall, combination, etc.) and I couldn’t find a transformer that could accomplish this other than PythonCaller. I’m having trouble integrating my code within FME (2022 version) which requires me to use a few packages to execute. Has anyone been able to accomplish this? I’ve already reviewed the existing FME material out there.

Hi AllA few learned gotchas in regards to GDA2020 transformations.- Dont use the Navigator to convert datums GDA94 > GDA2020 as it defaults to 7 param (unless thats what you want)- Reprojector Transformer is seemingly default to 7Param when it should default to gridshift (have a call logged with Safe)- CSMapReprojector - if you are using Desktop this is the best to use as you can force the transformation from the dropdownHowever if you are going to server and you want the user to select the output coordinate system which may or may not include a transformation you need to automate which method you use by setting it with either a parameter or a conditional value based on the selected coordinate system code  Lots of fun to be had but some caution as well. No transformation is the same.

A column name that I am trying to SELECT in the SQLExecutor is titled: STATEThe line in the SQLExecutor that contains it is as follows:I receive an error message that leads me to believe that it is not grabbing this column, and instead trying to grab the alias that I am trying to establish:Is there a reliable work around for this reserved word? I have tried using the following, to no avail:[STATE][“STATE”][state]“[STATE]”

Hey all, I’m wanting to snap existing meter points in a Water Utility Network, to field-verified points collected in the field by a contractor. Currently, I am just using an anchor snapper to snap the points, however… the service lines attached to them are not moving, as I believe an “edit” has to be done on the lines to get the network topology to stay intact.  I have tried using the anchor snapper on the lines to snap the endpoint to the meter location… but I am not getting the same results I am getting with the points. Is there something I am missing/a better way to ensure the line attached to the meter also moves its endpoint to the new meter location?  CS is State Plane, 100 feet is the setting I am using for now. The endpoint of the service line is coincident with the meter location, if that information helps at all.

I am looking to extract data from AGOL to store in a separate table and filter the data by its date field. Essentially I will schedule this every evening to collate all the data with todays date, or run this early morning and filter on ‘Yesterdays’ date. How do I configure the tester transformer to reflect what I need.  Any help is greatly appreciated,

Hello,I am experiencing some odd behaviour with the FeatureReader when trying to read in a schema from a Feature Class in a FGDB. I am using the “path_windows” attribute that contains the location of the gdb. When run like this, I often get a rejected message (see Caption 2). When I add in the hard coded full path into the Dataset field of the FeatureReader, the data gets read correctly. What is strange is that this has been working fine in the previous weeks when I had developed it. It only appears to be an issue since today. It also seems to read successfully when I run the workbench with caching to the Aggregator before the Feature Reader, then running again from the aggregator (no settings have been changed). I have tried using the path_unix field instead, but get the same error. I have also tried other datasets, but get the same issue.Has anyone experienced similar behaviour when using the FeatureReader with a GDB?… and any ideas to help with the stability of the run? The workbenc

I'm running a workbench on FME Server 2017 and after running through some transformers, the data should be writteninto a database. I'm getting an error ans this message: An error occurred while flushing the cursor for the table/feature class 'xxx.yyy.zzz'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting float to data type numeric.] [xxx.yyy.zzz]} Am I right to assume that the error is possibly invoked by an incompatible value? How can I find out which value is causing the error? Is there a possibility to retrieve more information to start the search for the cause of this error?

Hello, I have a problem that I am struggling to get my head around recreating within FME. The images below are just for example.I have data from two separate sources for which I want to calculate the area of overlap, for each instance parcel data and problem area data.I want to calculate the area of overlap for every individual parcel and every individual problem area. So rather than calculating the overlap for every individual parcel against the entire other layer as would be the case in the image below:  I want to calculate the overlap for EACH SINGLE feature, and essentially create a list, so I can then also see the attributes for the problem area, and the area of overlap that particular parcels has with that particular problem area, to then go on and filter out those that fall under a certain threshold of overlap.  I have gotten up to the stage of generating a list, which has the parcel id’s and problem id’s for each instance of overlap. My issue is where to go from here and then c

I am researching options for a GIS data catalog and data lineage system. There are some GIS data catalog tools out there (Ex. Voyager) but they lack a method to store the ETL lineage information. For example, I'd want to map that the Streets feature class in my Oracle geodatabase is sync'd to an AGOL feature layer named "City Streets" every night at 3AM.  Some of the data lineage tools on the market can connect to ETL applications (Informatica, Azure Data Factory, etc.) and scan them to get source/target information from all the tasks configured in the system. I haven't seen Safe/FME show up as being supported by any of these products. So I'm curious if anyone's come across a product that can scan for this stuff. Alternatively there's always manually populating these systems by reviewing all the FME Server job logs and investigating source/targets in the workspaces.

Hi everybody!I wrote some weeks ago about a new solution for our education department in order to get the nearest routes between one Adress and all the schools of the city.thans your answers we could make a first version of it!Now that we get more and more users we have seen 2 problems in our solution.We have a point with the adress of the student and the lines of the streets (including the way from the door of the houses to the street). Usually you have some distance between the point and the vertex of the line. To get the point to the vertex of the line we use the AnchoredSnapper (snappint type: end point snapping; snapping distance 15, Add Additional vertex: never). And hier we get 2 problems.If the point is on the line we get the result as “Untouched” instead of “Snapped” If the point is too far away we get the same problem. Is there any posibility to standarize it? I mean we want to cover all the posibilites: point is in a range of 15, is far away than 15 and is on the line. Thank

Hi All,I have a feature class with 351 columns and need to know which columns contains ALL the records as <Null>. I have tried the AttributeValidator transformer but it doesn’t seem to do what I want as all the records go to Failed and there’s definetly columns with all records as <Null>, see below: The ‘Attributes to Validate’ have been included the 351 columns,Any ideas how to approach this issue?Thanks :)

I have several types of rasters in my folders (ecw, png, tiff..). Not all folders i want to process contain all of the types. In my workspace i created one reader for each type, but when one type is not available, i can not launch the workspace. How can i make a reader optional so it will accept no input data?

Hello dear communityI am a real beginner when it comes to PythonCaller. I need the syntax to create a group processing with this transformer. My problem: Persons on an address belong to a group. A new attribute should be created based on another attribute in the group.I have already generated a basic program with Copilot, but I always get an errorPython Exception <TypeError>: process_group() missing 1 required positional argument: 'group'The code reads:import fmeobjectsclass FME_PythonCaller:    def __init__(self):        self.data = []        self.log = fmeobjects.FMELogFile()        self.log.logMessageString("FME_PythonCaller initialisiert", fmeobjects.FME_INFORM)    def input(self, feature):        self.data.append(feature)        self.log.logMessageString(f"Feature eingelesen", fmeobjects.FME_INFORM)    def close(self):        try:            self.log.logMessageString("Start der close() Methode", fmeobjects.FME_INFORM)            address_groups = self.group_by_attribute(self.

Hi,I am struggling to read the content of a layer published to ESRI portal. I have a  _website_urlhttps://gis-eu.xxx.com/arcgis/rest/services/LayerTest_Pt_01/FeatureServer/0for ESRI portal layer. For example I need to get Item Id HTTP_Caller does not get this info in _response_body

Hi, I have created a gdb with 2 feature classes, strings and points. But it only works the first time. Every time I make changes to the model and run it again I get errors. I have tried changing every setting but nothing helps. The only thing I can do is create a new gdb every time but that is not the intention.I usually use the Insert and drop and create settings   

Postman connects easily to Veoci (emergency management software) via a two-step process:1) Get a private token;2) Submit query using the private token. These is done in two separate steps:Step 1 (https) returns five new or updated Veoci cookies in the headers, two of which are APIALB and APIALBCORS.  Their values are identicalStep 2 (https) returns two more new or updated Veoci cookies: APIWALB and APIWALBCORS.  These two values are identical (to each other).These four cookies appear to be related to Amazon.I want FME to combine the two steps into one (and let me store the results in a relational database).Step 1 works fine in FME.  In fact, the pattern of packets matches exactly.Step 2 unfortunately returns the message “Authsession not found in cookie” no matter what I try.  I know conversation contains a permanent redirect (looks like Amazon) and I think this is the problem.Even running Step 2 alone in FME always fails.I’ve tried configuring the HTTPCaller in Step 1 and the HTTPCalle

Hi everyone,We have floating licenses and installed FME Form in a server, and the users will login to that server to use FME. So, my question is How many users can run the same workspace using FME Form in a same server at the same time? My user has different username and password to access the server. Please advise. Thank you.  

Hi, I have a html content in _response_body. I am struggling to get only specific text from it. I would like to get only the text highlighted in red. <b>Layers: </b><ul><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/0">2014/02/20</a> (0)</li><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/1">2016/12/07</a> (1) How can I do it? I assume I should use XTMLFragmenter but I am struggling to get the result I want

Hey everyone, I’m currently trying to get a workspace on FME Flow that makes use of the AutodeskDocsConnector. This single transformer would make my worksapace a lot smaller and easier to manage. Problem is that it just won’t work FME Flow! On Form it works without a hitch. On Flow accessing the same project and folder on Autodesk Construction Cloud also works when using the HTTPCaller. It’s only the AutodeskDocsConnector on Flow combo that seems to be failing me. This is the error message I get on Flow:  Anyone have experience with this or know how to help me out on this one?