FME Form

What is the best way to convert Lines to Points? I would like the points that are created to fall in the middle of the line and include all non-geometry attributes of each line. I am hoping there a LinetoPoint Transformer out there somewhere. 

I find that the string functions on FME2024 don’t work similarly in FME 2023, in this case, it led to some problems with the outcome as not expected. Example:I have 2 strings:“EMD-1” “ÊMĐ-1”I use string functions as below: I received 2 outcomes differently:With the text 1: Count_index = 4With the text 2: Count_index = 6It is not right, in FME 2023 the outcome is 4 for both situations.Is this a bug in FME2024 ? 

Hi,I have a workspace that executes a piece of python in a PythonCaller which uses ArcPy. However it crashes the ArcGIS application that is running the ArcPy(Not FME Form), giving the following popup   The log doesn't have any errors and only two warnings: Python: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more details I have seen this warning a few times and in articles. So far this is the first time it gives me a crash. Articles say you need to update your windows version. At the moment I have Windows Server 2019 Datacenter, Version 1809.So there is an update possible here. Another warning is: PythonFactory script ch

Hello,I have just upgraded to FME 2024.1 (was originally using FME 2022) and when running an SQLCreator using ODBC3.x I get an error, this was working just fine when using FME 2022.What’s strange is that even though I receive an error, all expected features are semi-cached and observable in the translation view as shown in the picture, the problem is that I can’t continue to run the following transformers as FME is taking it that the SQLCreator failed.Does anyone have any advice on how to get around this? My SQL code is fairly simple, just pinging an Azure database and doing some basic joins (the code also works fine when running on Azure Data Studio). Thank you! 

Hi, I receive this message: message":"Some or all of the input parameters are invalid","problems":[{"reason":"dependency","field":"publishedParameters","message":"Illegal field  Does anyone know the reason?Thank you 

Hello , i have points and lines are topology connect together .i would like to find all paths possible in the network .i have used shortest path finder but it finds only the shortest path ,so i am looking for other solution to find all paths in the network between all points.i appreciate any help .Thanks in advance .FME 2021

Why does the FeatureReader transformer using OData operated differently (slower or not at all) with the same parameters used with the “regular” Reader, which performs as expected https://data.environment.alberta.ca/Services/EDW/waterwellsdatamart/odata/filterCreateTimestamp%20gt%202024-08-04T00:00:00-06:00 Table/FeatureWells  Thanks.

I am using the FME objects python API including the FMEUniversalReader. fmeobjects.FMEUniversalReader — Python FME API FME 2024.1 b24615 documentation (safe.com)In the documentation for this API it says to pass “Reader’s type mneumonic as found in the FME Reference Manual Part II” but the reference manual isn’t linked.It isn’t in the admin guide: FME Desktop Administrator's Guide (safe.com)And Safe Docs just link back to the python API Search (safe.com) which

I have a multiple choice question at first. Depending on the checked values I want to ask some follow-up questions. I only want these follow-up questions visible when the user checked that topic in the multiple choice question.Since I cannot use a condition on visibility like ‘contains’, I tried this by first using a scripted parameter.If the value is checked, return 1, else return 0.I then use this scripted parameter in the conditional visibility of the follow-up question(s).But.. this does not seem to work and affect the visibility.If I run the script, I can see the scripted parameter does work, it returns a 1 if needed and a 0 otherwise.But it does nothing for the visibility of the follow-up questions.Can this work? Or are the scripted parameters only calculated afterwards/during runtime and therefore cannot be used in conditional visibility of other parameters?I'm also seeing some new possibilties in 2024.1 (currentl

I have a glut of features of multiple types coming in from a handful of .ifc files. I am attempting to write a transformer as a proof of concept that will allow me to filter the features (currently 174000+) to different writers based on a small difference within their source filenames. Basically what I want to know is if it is possible to use the text editor to create an “if filename contains text (abc)” filter. If not, what would be the best way to filter for something like this.  

Something simple but can’t get it to work. I have a Field1 with two records. One record contains numbers as 205202021356 and the other record does not contain numbers as DAKLL. I have an attributeManager where I want to assign a value for the records that do not contain numbers and keep the value the same for the records that are numeric. In the AttribteManager transformer, this is what I have under the AttributeValue field 2 possible values:So if Field1 is not numeric, I want to assign NAIf it is numeric (contains numbers) then leave it with its original valueSample below are the records. I want to assign NA to record 2 and keep record 1 as is.Field1

Hi,I would like to convert an xlsm into xls so that I can then do a task chain. Is there a transformer or several that can help me ?Thank you for your help

I need to use the PythonCaller because the area on area overlayer doesn’t work with my input featureset. I want each polygon in featureset A to overlay against all the polygons in Featureset B (which does not self intersect) and then drop overlays with NA values in specific columns. I found documentation for the fmeobjects.PythonCaller, but the documentation doesn’t include how to actually run the transformer.fmeobjects.FMETransformer — Python FME API FME 2024.1 b24615 documentation (safe.com)i.e. what do I do with f = fmeobjects.FMETransformer after I’ve set the attributes?Additionally, it’s unclear what the parameters are for this object, as there is no function definition returned to define what is required for each transformer type.

Is there a transformer that can create classes based on natural breaks, quantiles or equal Intervals?

Hi.I have a workbench equipped with several runners. I want to send myself an email upon completion of the workbench, detailing the duration each runner took. I implemented a DateTimeStamper at the Succeeded port for each workbench and attempted to merge this with the creation instance, but it failed to function as expected.I would like the result to include the duration each workbench ran and the total time upon process completion.Any help is greatly appreciated.

Hi, I have a MySQL database which I'm using the non-spatial MariaDB reader to get access to. Most fields are coming into FME Desktop ok, with the exception of a unique identifier field. The source data has a field called rg_key_id which is defined as char(21) in MySQL. A typical value in this field would be 'RG 022000001' But, when read FME is setting the datatype as fme_binary and I'm seeing '52472020303232303030303031' as the representation of 'RG 022000001' Can someone please point me at a resource, or help me understand, how I can either honour the source datatype or change the FME datatype so that it's no longer fme_binary. Here is the Feature Information showing the fme_binary encoding. Many thanks Brendon

While attempting to set up a web connection to cityworks via FME/ESRI’s data interoperability externsion, the connection continues to result in “Unable to authenticate using the specified connection information”.  We are on CityWorks Server 15.4.2 so the authorization token is set to be passed by query string.  Any other changes or tips that we should try?

I have a complex workflow where a specific attributes, i.e. “PositionID”, which are referenced across multiple transformers. I need to rename these attributes to another name throughout the entire workflow. Manually opening each transformer to change the reference would be very time-consuming.Is there a way to quickly rename this attribute in all transformers without having to edit each one individually? Any tips or tools within FME that can help streamline this process would be greatly appreciated.Alternatively, next time I create a project can I set these up as parameters or variables and reference them that way and hence change them more easily? Thanks

Hello,I am trying to start a workbench that uses data from my enterprise geodatabase. I have a feature class called WaterDevices and it has attachments. However, the FeatureReader does not read the relationship class. I attached an example where does read the relationship class in a different enterprise geodatabase for sewer.I’m not sure where to start troubleshooting this. Any advice would be appreciated. I’m on FME Form 2024.0.3.0.  

Hi All -I have been trying to convert a GeoTiff (also converted to ESRI Raster to try it too) and write to ESRI polygon feature class. I have used the steps below….. However, the translation fails and I get the following error:“Cannot write a non-point feature to a point feature class”There are no point features at play in any steps. RasterCellCoercer output cell geometry is set to ‘polygon’ and writer is set to polygon too. Does anyone know what is wrong here? Is another step in terms of geometry replacement or definition needed? Steps: Reader to read the GeoTiff (or Raster). RasterCellCoercer to convert the rastercells to polygons. AttributeCreator to convert the raster cell value to attribute. In this case _band{0}.value. Relevant writer to write the result to polygon FC.Thanks in advance! 

Hey all, I'm trying to do some webservice calls with the httpcaller. Unfortunately i'm getting the famous SSL connect error. I've tried setting the 'verify ssl certificate' to no but i'm still getting the error. I'm using FME 2020.1 and as an example i'm trying to do a get on the next endpoint/url:https://jira.atlassian.com/rest/api/latest/issue/JRA-9 My http caller settingsThe endpoint in the browser gets a nice Json back as response. The httpcaller however doesn't. The certificate is a wildcard certificate (could the be an issue?).Can anyone check it out if it works for them

I have a Simple  PythonCaller code to delete all .gdb files is a directory import osimport time# Define the directory and the age limitdirectory = r"../../../10_9_1"age_limit_days = 1current_time = time.time()# Calculate the age limit in secondsage_limit_seconds = age_limit_days * 24 * 60 * 60# Iterate through the files in the directoryfor filename in os.listdir(directory): if filename.endswith('.gdb'): file_path = os.path.join(directory, filename) file_age = current_time - os.path.getmtime(file_path) # Check if the file is older than the age limit if file_age > age_limit_seconds: try: os.remove(file_path) # Delete the file print(f"Deleted: {filename}") except Exception as e: print(f"Error deleting {fi

how to find the all paths between start node and end nodeexactly i have 8 nodes ,as point A,B,C;D;E;F;G ;Hi want to check the all paths possible what ever the length of path but i want to find any path available between every Node between Node A and the rest of nodes (B,C;D;E;F;G;H)then checck between Node B and the rest of Node (A,C;D;E;F;G;H)and so on ,i want to check between one node and the rest of nodesfor sure some of them has no connections liens ,i want to define that also which two nodes has no possible paths. i used shortest path finder but i think,it is working only to find the short path between path A and path B,but i want to find all possible paths between A and B even it is long or short and get the id of each line through this path . i prepared my network so all lines are connected without any gaps so i have now paths between some nodes and some not depend on the network .Thank

Hello,I am trying to start a workbench that uses data from my enterprise geodatabase. I have a feature class called WaterDevices and it has attachments. However, the FeatureReader does not read the relationship class. I attached an example where does read the relationship class in a different enterprise geodatabase for sewer.I’m not sure where to start troubleshooting this. Any advice would be appreciated. I’m on FME Form 2024.0.3.0.  

When I publish my workspace to our FME Server, and run it it works. After a while, published before Christmas 2023 -> ran now again, FME Server return with the following error: ArcGIS Portal Feature Service Reader: Authorization error. See http://fme.ly/AGOL401Error for more info. FMEException: 928221: ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '498' and the message was: 'Invalid token.'. Details: '' Trying to fix the issue I attempted to re-authenticate the web connection. The issue is, when I click on the 'Authenticate' button, then I get a browser window where I can authenticate myself against our Enterprise Portal and the portal returns a token. In other applications such as Jupyter the token needs to be copied and handed over to the requesting applica