FME Form

I’m using Pro 3.2 and Data Interop extension with a simple workspace to pull point features from a SQL server database and publish them as a layer in AGOL, all within AWS on an ec2 instance. I have this scheduled to run every 15 minutes so users get fresh data. The workspace also uses an HTTP call to make the layer editable just before overwriting it, and then a second one after writing, to disable editing, because the layer is public. Seemingly intermittently, the file geodatabase used to publish the layer will not get deleted. I have the fgdb that was originally used to publish the layer still there in the same folder as the layer, but every so often another fgdb will be created and left in that folder too, so I get duplicates. Some mornings I check and there are 3-5 or more of them. I can manually delete them, but I’m trying to determine why they’re not getting deleted in the first place. I’ve checked the logs and can’t see anything out of the ordinary. I tried adding a 30-second De

I have a non-spatial table with about 5 million records of XY coordinates. I need to update the table with the Lat Long values in the so-named columns.I am facing problems with writing these to the table. When I choose UPDATE/UPSERT/fme_db_operation, the writing takes a seconf for every 10 records. It’s impossibly slow.When I choose, Insert with DROP and CREATE or TRUNCATE EXISTING, the script gets stuck with following last 4 lines in the log: Writer `MSSQL_ADO_2' of type `MSSQL_ADO' using group definition keyword `MSSQL_ADO_2_DEF'Microsoft SQL Server Non-Spatial Writer: Opening `GISReporting' for write operationMicrosoft SQL Server Non-Spatial Writer: Read 1 DEF line(s).  Found 9 attribute(s)Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server...MSSQL_ADO writer: Splitting bulk features into individual features  NOTE: I have set BULK Read and Write at 100000 records for every transaction.

Hi everyone ,I have dynamic doors in my dwg AutoCAD file :If I click on the small arrow the door changes direction , and the big arrow changes the size of the door I want to read on fme the default position and size of the door , just like a normal static door. But here is how the DWG Reader reads it :   Any Insight is much appreciated !-Yagami

I have a DWG file with unknown CS but I know the CS it just needs to be assigned to the DWG. When I set the CS when I read the DWG then it appears in the correct location on the Earth but once I try to write it, it doesnt write the CS info and it appears again in the false location on Earth! I also tried “CoordinateSystemSetter” but with no success. On FME it appears good while transforming but not in the resulting DWG. Any Idea?

I have many workbenchs and some of them are quite complicated. I would like to write a description of all the steps. Are the workspace parameters the best place to write the description and the steps?  Thanks :)  

Hi All,Quick question in regards FME & ArcPy: I have been able to create a Python script that overwrites a ‘tree_ID’ field on AGOL based on the sum count of the three geometries (point, line and polygon). Basically the script does the following calculation and assigns the IDs, example below:Point = 3 featuresLine = 2 featuresPolygon = 2 featuresTOTAL = 7 features ID to update on AGOL 1,2,3,4,5,6 and 7The python works fine as the AGOL feature hosted layers have been updated with the new ‘tree_ID’ but the PythonCaller stops with the following error: ‘PythonFactory failed to load python symbol `FeatureProcessor'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date’ I can always run it on Pro but wanted to integrate it using PythonCaller as part of my workflow runs on FME,Any idea why I’m getting that error?PD: Python script attached.

I’m using the JSON reader to read in a folder of JSON files. The reader is working how I want it to, however I would like to get the original file path/name as an attribute on each feature.  Is there an easy way to do this? I’m hoping that I am missing something silly.   

I tried the FMEFeature.reproject(coordSys) method but it can do only 2D reprojection. I want to do reprojection using Python only not with any transformer like EsriReprojector or CSmap.

I’m having trouble writing dynamically to a SDE feature dataset using the ‘truncate’ option in FME 2023.1. The features are written, but there is no ‘truncating’ taking place before the writing and instead the data doubles up... It works as expected in FME 2021.2.6 however, maybe due to the different way in which the feature dataset is specified in this version under ‘Table Creation Parameters’. How do I make it truncate also in 2023.1 version? Current set up in writer for FME 2023.1: 

Hi All, I’m working on a workflow to collect tree data in the field using Survey123 & Field Maps. The tree surveyors complain about having to manually change the Tree IDs every time they come back from the field. I was thinking that FME could help with this matter by reading the Feature Hosted layers (point, lines and polygons) and use the counter to re-numbering everything.I have the workflow pretty much ready but I want it to achive the following:Read and Overwrite the same Feature Hosted layers by using Feature Holder? I want to avoid creating a new layer with the new IDs. is that achievable?  I only want to overwrite one field (Tree ID) then the rest of the fields stay the same. I was thinking only exposing the Tree ID attribute in the reader?

Hi all,i know it will maybe an easy one….I’ve tried with substringextractor or with AttributeTrimmer as well but i couldnt reach the right result.i have attribute like these for example:he0_wasser_WSG_TK_20143_AGE_f_r01_231030 orni0_geobasisdaten_gemischte_industrie_gewerbe_flaechen_20256_AGE_f_r01_240118i have to split in this case “he0” and “ni0” and write that in an attribute xi have to split “wasser” and “geobasisdaten” and write that in an attribute yi have to split “AGE” in an attribute…….and so onnow comes the challenge:the text between “wasser” or “geobasidaten” and the 5digit number (20143, 20256) has sometimes 2 words, sometimes 3 or 5 words…..but i have to write the whole text in an attribute z….ho can i do that? i am not so well in regexp…..so i ask here for help Thank youCheersFranco  

Hello AllI need your guidance to correct this issue..I have few polygon layers with limited infomation in the layers. I have an excel master sheet with complete details and common field is species name  so , I have used feature joined after some transformation and got all details connected to layer.. Now , The issue is when i have exported it to gdb , everything is blank without geometry and only attributes are visible for polygon layer.. I want to project it to LL84 I have attached workspace template and error screenshot I shall be thankful for suggestion    

Dear FME community,I have a featureklass of lines. I want to find the start and end point of the lines. I used the Snipper transformers, setup as the screen shot below. '0' is the first vertex, '-1' is the ending vertex but the start and  end points which I created , don not lie along the line. I also used coordintateExtractor,, it gave me the same result. I couldn’t figure out what went wrong.I would appreciate any help to solve this problem.

I would like to split a polygon into it’s segments, so that the result is seperate segment-features (lines). Does anybody has an idea for this?

 I have 3 published parameters where the user inputs values for buffers. All three were created as Numeric parameters, with numeric precision set to Integer. I would like to extract the largest buffer value in a python scripted parameter. This is the code I’m using in FME 2023 (build 23332)buffer_list = [FME_MacroValues['BUFFER1'],FME_MacroValues['BUFFER2'],FME_MacroValues['BUFFER3']]buffer_list.sort(reverse = True)return buffer_list[0]What I’ve discovered is that if the 3 buffers are the same number of digits, the script will return the correct value. If the number of digits is different, it will not. Some examples:10, 40, 50 = 50 (correct)120, 60, 70 = 70 (incorrect)120, 180, 70 = 70 (incorrect)120, 200, 300 = 300 (correct)It doesn’t matter which order the values are input, nor does it matter how the parameters are sorted in the parameter list.Is this a bug, or am I missing something?

Greetings,I’m writing FME workspace that should be able to scan a list of IP Addresses for modems. The result will have reachable:yes/No attribute to determine the IP address is reachable or not.First thing to think of is using python caller to invoke the ping tool of OS. I did it that way and it’s working. However, the client policy demands workflows that are only built-in. No custom coding, and I want to make sure that there is no built-in transformer that may do the task?Is there a built-in transformer that can check if a networked IP Address is reachable or not. Is there one that can be tweaked to do so ?Thank you-Moataz.

Hello everyone,For one year, I’ve been running different workbenches daily (Windows Scheduler), reading from MSSQL tables to write into various hosted feature layers, used in various dashboards. I noticed an unusual consumption of the storage on our GIS server, coming from the “pgdata” folder of Arcgis Entreprise, so the underlying postgresql database (up to 20go additional Gb per month, while the size of all my hosted features stay constant at around 1gb only in total). After several tehnical sessions with ESRI, there is no doubts that this is caused by my FME workflows. Those workbenches are far to be optimised (as I was only starting to use FME) but they are working fine. It was easy to truncate all features to insert new features, sometimes up to 150 000 features daily, for one layer (see below, simplified version). The inserted features are polygons, from the same source hosted feature layer, daily joined with most recent MSSQL data. NB: Objectid is removed with “attribute manager

Hi!I want to add an attribute to geometry - is this done with the geometrypropertysetter?For instance, add ‘water  asset’ to a cylinder but not as a layer name rather as an data tag / table.I ultimately want to be able to bulk add them however am starting with a simple test case.Thanks.

We have a customer who would like to read data directly from Microsoft Dynamics AX 2012 R2 with FME. Has anyone done that if so how to do it? I haven’t been able to find anything related to this.

Hello , i have too many points I would like to find the points and lines between start of path and end of path in different paths ?i would like to have excel file that include First row Start point (a) - next point (b)- lines (line id 1)Second row From b point - next point C - lines (line id 2 )and so on till end point (blue point )fllow direction from start point to end point as picture fme 2021 thanks in advance 

I have followed this tutorial:Updating ArcGIS Online Feature Services using UPSERT (safe.com)As the last screenshot shows, I have 1495 records. Comparing the original CSV used to do the initial data load and the updated CSV, the new records in the updated CSV have not been added and existing records with changed attributes have not been updated.The tutorial suggests this is possible using the UPSERT operation. Example update I expected with the highlighted text the changed attribute value: 1000,ZYX3116631180,-123.093432,49.281221,31180,-53.7761,-21.7304,1,2011-12-02 22:01 Example add I expected: 9000,ABC1069610710,-123.093414,49.281637,10710,-79.377,-17.3218,1,2021-12-06 1:41

Since updating our server to the newest version of FME Flow, the "Browse Resources" button is broken on workspace apps. Users can only upload their own temporary files. Uploading files is a functional workaround, but it is much slower than selecting a file from the network drive mounted on the server. I have verified that both my user account and the app have permission on the resource. For the app I have given List and View permissions to the folder.  Any recommendations?

I have a complex workflow using multiple Workspaces. Each reads and/or writes temporal operational data to CSV’s.My question is, when do you use a Reader/Writer as opposed to a FeatureReader/FeatureWriter?I’ve settled on using FeatureReaders/FeatureWriters though I’m not sure if make much difference.I understand the Feature* transformers are geared towards mid-workflow use where you have input and output.Thanks in advance.

Hello guys,I want to know about 2 questions:1. Is the license attached to the HDD or MB?2. Can it be upgraded from HDD to SSD? Thank you so much