FME Form

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 pa

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 “

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

I am creating a workbench where I will bring spatial object assets from an oracle database into a file geodatabase. I want to sort the assets into feature datasets as I go but I am confused as to how to go about this. I have only done a few FME workbenches so I don’t have a great deal of experience. So far, when I have been creating File Geodatabases, I add a Esri Geodatabase (Open API) writer and then the file geodatabase is created and any features I connect to that writer are added in. So its kind of a two for one where the file geodatabase is created plus my features are converted and added to it. How would I go about creating a feature dataset during this process? Is it possible with FME 2018 or does that come with newer versions. We will not be upgrading for several months and my co-op term will be over by that time. Thank you!

We are trying to use GoogleDriveConnector to update a folder within a shared folder on Google Drive. Unfortunately, when uploading the folder to the shared folder, it creates another folder with the same name as the one we’re need to update. We’d preferably like to overwrite this folder, or delete the Google folder before uploading, or something.There is a delete in GoogleDriveConnector but you have to have the exact Google id for that folder, which will change each time the FME is run. So we can’t automate weekly since we won’t know what the id will be each time.If neither of those options are possible (overwrite or delete), is it possible to upload to Google with a new name for the folder (like with a timestamp) so that we all know which is the most updated? (We can manually clean it out after that if need be.) This is less preferable, but right now I’m looking for any solution that may help our needs.Thanks!

Hi fellow FME enthousiasts,Another case i'm struggling with today.I have a list of parcels that need to be added into a Excel template. In most cases I can sort the parcels by parcelnumber and concatenate them grouped by the Section number and write them to the Excel.But the field in the template can fit a maximum of 5 parcel numbers. So if there are more then 5 parcels they need to be split in groups of 5. So say i have a file with 13 parcels, I would need to split them into 3 groups (2 of 5 parcels and 1 of 3 parcels). I can get the number of parcels with a StatisticsCalculator, but i struggle with the part where i have to split them into groups to write to the Excel. How would you do this? Cheers!

Hi, I use parallel (//) processing in other workspaces successfully but this is the first time with a Clipper. The tips offered in article: FME Parallel Processing: Tips and tricks for generating groups | Safe Software do not seem to apply, or at least I think they don’t. I am trying to clip an OBJ of  ~12720000 triangles with ~93K polygons of diiferent sizes. The OBJ has no attributes, just geometry. 1st try: link the same modcount (4 groups) to both Candidate and Clipper inputs of custom xformer containing only a Clipper.  The data passess through it without any clipping. The Clipper inside is set as “multiple clippers”; Clippers do not arrive first; Reject only parts, merge-clipper, and the rest is set with defaults.2nd try: cloning the OBJ as explained in article but it slow and eventually crashs as it runs out of memory.

The steps I have so far: 2 layersSpatialRelator, which generates the list attributes with the intersects.Then I test the output to find out which features have more than 1 relation (indicating overlapping with more than 1 feature).Then I explode that list and delete the unimportant attributes with AttributeManager. I now have a table like this. First column containing a unique identifier for Layer 1, the second row containing the unique identifier for Layer 2.  A feature of Layer 1 can overlap with multiple features of Layer 2, and vica verca, hence the duplicates on both sides.Layer 1  Layer 2 ID1 123 ID1 345 ID2 987 ID3 456 ID3 123  Now the hard part. I can FeatureJoiner them together, and then dissolve, but then I miss

Hello fellow FME enthousiasts,I have a case which i can't seem to find a solution for.We have a process that adds a score to incoming records based on certifications added as hyperlinks in a table.During several steps these certifications have to be manually checked by an employee. Finally when everything has been approved the records are written to a central database (this can only be done when all the records have been approved, so the whole dataset has to be kept together during the whole process). Right now i have the process setup to output all data to an Excel table (with a template to make it readable for the employee). Here the employee can select if a certification is approved or not. This Excel table is then put back into the next process untill all necessary checks have been done.Each time a proces is run i would like to check at the end if all records are approved or not. Depending on the outcome two things can happenIf ANY

I have a batch workspace that spawns multiple child workspaces using four separate FMEServerJobsubmitters. I have two engines in FME FLow but the other engine is occupied with other processes so I'm able to use only one engine. As i understood, if i set Wait for jobs to complete to "Yes" and Submit Jobs "In Sequence", FME Flow should spawn a sub-engine that will run the child workflows and once they are ready it will continue the parent process. This is the behaviour that I would need because I only want to continue parent workflow when all the child processes are successful. However, with this setup the first child process enters queue and never starts. It also shows in the parent log file that the submit was successful, but it ends up into queue. I have separate queues for the two engines and both the parent process and the child process are tied to engine2 running in queue2 so it should interfere with the other engine and queue.