FME Form

I had an issue with a workspace with a disabled junction. I then discovered that disabled junctions won't get grouped in the navigator as disabled transformers and disabled connections do. Is this on purpose or is this something that can be improved? I expected them in the "Disabled Transformers" group. The workaround is to search for "junction" in the workspace search, this will display all junctions and mark the disabled junctions grey. Tested in 2021.1.1.0 (20210730 - Build 21619 - WIN64)

Hi,I created an FME workbench which contains python script at FME shutdown. This python script uses Arcpy library to make database connection. The workbench execute successfully and insert the data in database when executed manually. However, the script fails when we publish the FME workbench in FME server. It shows transaction is successful with message as 'FAILURE'. The FME job fails to insert data in database. Please advice.

I have a workbench in which I translate XML files to featureclasses in an ESRI SDE geodatabase. The featureclasses are versioned. I use a featurereader in which I specify the child version. That version is then created by the featureader since it doesn't exist before the start of the translation. Updates are done with an SDE geodatabase writer in this version. I specify in the parameters that the version is to be reconciled and posted after the translation. After posting, the version should be deleted. This is also indicated by setting the appropriate parameter. When I run this workbench in FME desktop, this works fine. However, when I publish the workbench to FME server and run it via an automation, the version is reconciled and posted, but it is not deleted. The log displays the following error:Error deleting the version 'versionname'. The error number from ArcObjects is: '-2147217140'. The error message from ArcObjects is: {The version is currently in use. [versi

I have some data that i am trying to replicate from 1 DB to another, but I cannot create the readers for several FCs that contain arcade expressions. I get the The error number from ArcObjects is: '-2147211773' message. I am running FME 2021 (64 bit), and have ArcPro installed and the Esri ArcGIS Capability is set to Pro. One thing I can't seem to get is the ArcPro Python listed under Python Compatibility. But I do see that listed in FME 2019 on the same machine. Any thoughts on whether or not this should be working and if so, how I can get it to work?

Greetings,I'm running a workspace through FME Python API using FMEWorkspaceRunner, and need to ensure that the 'redirect to fme data inspector' parameter is toggled off prior to running. How can one access this workspace parameter?Thank you,TylerFME 2021.0.0.1Python 3.7

I have been using the neighbour finder to create a line between an existing point and road line, which works fine up to a point. I am sure the below is fairly straightforward but have been racking my brains to no avail. I have tried the group by which is giving some strange results too... Both the Road and Point Datasets have a RoadID attribute meaning that all points should be linked to the correct road, this is not currently happening with some points being linked the shortest distance to the nearest road and not to the correct road. Any suggestions how i can get the points to link to the correct road via the RoadID field? The image below shows the results i am getting with the Yellow lines drawn on where the links should be going. Thanks in advance...

Hello, I have created a list of one specific attribute (Listbuilder), which I have finally cleaned from duplicate entries (ListDuplicateRemover). So the list contains several elements, but they cannot be duplicated. As a next step I want to select all geomtria from another dataset which are contained in the list. When trying to do this with the FeatureReader, it seems that I can only specify one element in the WhereClause query. How can I select all geometries contained in the list in one step? I would like to avoid the detour via the PythonCaller 8-). Thanks a lot.

I'm new to FME and tried to use the Rcaller transformer. However, the software lags at the log point "processing Rscript" and does not finish the translation but does not give back an error. This is also the case if I try to run the Rcaller example dataframe() script without any input data. See screenshots for details. Any help much appreciated.I'm using FME 2019.2 with R >=3.6. Translation log:Rcaller parameters:FME Translation Options:

I'm trying to create a series of adjacent wedges from a central point. I have built a workflow that builds one wedge (polygon) then I'm attempting to use the Rotator to create a new wedge at every 1.8 degree rotation 200 times to encompass a full 360 degrees. I suspect there is a simpler method but this is what I have done so far. I'm using the XY-MM coordinate system. Any thoughts on the best way to accomplish this task? Thank you,Gil

Hello, before writing a Python script, I'd like to know if there is a way to retrieve the lines between a point A and a point B using classic transofrmers?  

I need to check the encoding of several files. For this I can use a scripted parameter like so: featureType =open('F:\\PGV\\Projektarbejdsmapper\\P4\\SCSV_til_kontrol\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv')t = str(featureType)return t With a Creator and a ParameterFetcher i get the following attribute:<_io.TextIOWrapper name='F:\\\\PGV\\\\Projektarbejdsmapper\\\\P4\\\\SCSV_til_kontrol\\\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv' mode='r' encoding='cp1252'> When I try to do this with a useparameter like so: file = FME_MacroValues['SCSV_file']featureType =open(file)t = str(featureType)return t This returns the following log:Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython38'INFORM: Python version 3.8 loaded successfullyERROR : Python Exception <KeyError>: 'SCSV_file'INCLUDE -- fai

Hi authors.FME workspaces are stored in a specific and well-known structure on an FME Server. So finding the path of another workspace is feasiable.I'm wondering whether I can use WorkspaceRunner to submit other workspaces on an FME Server instead of FMEServerJobSubmitter ?Is this completely no-go, or are there benefits, such as running more workspaces within a single job ?It would also simplify building and debugging on desktop.Any insights are appreciated.Cheers

Hi.When you have a workspace with a published parameter of type text, and it has a default (e.g. testing) value, this gets used whenever the value isn't specified in JobSubmitter/WorspaceRunner.If I submit a blank text as a parameter value, this seems to be ignored, and the default value is used instead.Is this WAD ?If I want to overrule a default parameter value with a blank value, how is this achieved ? Cheers

Hi! I want to put points on lines with an interval of x (for example 100m) meters. I tried several ways to do that. (I beggin with FME). 1) I used the lenghtCalculator, then calculate how many points I can put in the line for 100m interval @int(@Value(_length)/100) , add a counter, copy the points distance attribute and get number of copy linked with the "cloner",copy the number of each lines*100, calculate at what lenght put the point @int(@Value(_length)-@Value(_copy)) AND snipper ! The problem with that solution is the "cloner", I have a VERY big database and it's make too much geometry... Is there a way to do it without touching or adding the geometry? Or maybe with a formula, ... python caller ?  2) I tried other ways too, like the chopper and the vertex, but it's not a strict interval of 100meters like this. 3) I also tried the method with measure generator, linedivider and measure extractor.. but it's deleating me some of my lines cause of invalid

Hi everyone,I wonder if there is any way to force the SurfaceFootprintReplacer to not ignore holes in polygons?I have 3D cityGML data and want to get only the footprint, using the SurfaceFootprintReplacer the result is image Nr.2, all holes are gone and merged to one polygon. There is a custom converter called "GroundSurfaceExtractor" (I found somewhere in the web), what does it correct but this one takes around 10 times longer to calculate. Any hints?(btw: the cityGML does not include "ground_surface" elements to query for, I tried this one...)Thanks a lot!Building Polygon in 2D:SurfaceFootprintReplacer Result:

Hey all,I am using the ArcGIS Portal Feature Writer and when I push my edits to a feature service, it overwrites the editor tacking fields (eg. createdby, createddate, modifiedby, lastmodifieddate) with my username and today's date and time of upload, instead of values I have prepopulated. The table sits in a postgres database and I have turned editor tracking off against that table. Is it possible to push data using the FME writer without those values getting automatically populated?

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?

Hi there, I'm using the UpdateDetector transformer and it's detecting changes with lat/long fields where numerically there's no difference. This is because in one reader (the CVS reader) these two fields have trailing zeros, while in the other reader (an oracle table) they do not. What's the best way to resolve this?

RegEx, FontEncoder and StringReplacer experts, please help! I want to replace regular text characters in a text string attribute with entirely different unicode characters, and be able to use them as geographical labels.For instance, let's say that I want to convert the character "A" (unicode U+0041) in my text attribute, to the Roman numeral "I" (unicode U+2160), and label my map with that.  Some other characters should use other conversion codes - maybe using a lookup table. Is it possible?

I am working on creating a geodatabase made up of multiple types of proformas, a total of 67 different proformas. The proformas contact collected survey data of differing species and spatial data.

Good Morning:We are trying to transform autocade dwg files to GeoTIFF. The log indicates that the 17,000 features are read except for the raster feature. Thus it fails when we try to write during the conversion.I've attached the read log and the failure to read the raster

Does FME support ESRI Representation when mapping data between two file geodatabases? If so how do you go about setting this up?  Thank you, Sam

Hi, I am trying to IMPORT an EXISTING relationship feature class and FME complains about the name being too long....I cannot rename the Relationship feature class since it is a part of an existing data model. The table/feature class name 'WaterstaatswerkWaterkering_Waterkering' is too long for Oracle (!!??) to accept. Please shorten the name and try again I think this is a FME limitation that should apply if you are going to CREATE the table, but should not apply if the table/relationship feature class already exists! Anybody any thoughts/ ideas on how to go about this?

I have a .dgn model that I am converting to a tileset but some of the input is just lines that I should 'fill' (see image attached). My initial though process was:Create areas from them, with the config from the imagesThen pass it through a MesbuilderBut what I'm getting from the AreaBuilder and the Meshbuilder is off (images attached)I am not sure what's wrong, I tried playing around with the snapping tolerance value in areabuilder but the higher it got the worse it looked. Any advice would be greatly appreciated.Thanks in advance!

When using PointOnPointOverlayer (POPO), after FME 2018, I experience performance issues. With FME 2018.1.2.0 (20190225 - Build 18590 - WIN64) I could use the POPO with 600,000 records and this portion of the job use to run in 30+ minutes. Now with FME 2020.2.1.0 (20201130 - Build 20806 - WIN64) it takes 7+ hours. I also tested briefly with FME 2021.1.3 (Build 21631 - win64) but saw no significant improvement. What options are available for removing this additional 6.5 hours of processing time? Similar issue to this article from 2017. Thank you in advance for your time :) Julia Highlights from the logfile:2021-10-21 14:11:59|  0.4| 0.4|INFORM|FME 2020.2.1.0 (20201130 - Build 20806 - WIN64)2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME_HOME is 'C:\\Program Files\\FME2020\\'2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME Desktop ESRI Edition (floating)...2021-10-21 14:12:50| 50.4| 0.0|INFORM|Creating spatial index of 2 point features2021-10-21 14:12:50| 50.4| 0.0|INFORM|Completed spatial in