FME Form

I'm trying to clip out 'curves' from a polyline. I have a 2 layers, a polyline layer and a point layer. The point layer has a "point type" attribute that states if the point is "Tangent-to-Curve", i.e. the beginning of the curve, or "Curve-to-Tangent", i.e. the end of the curve. There is a one-to-one relationship between "Tangent-to-Curve" and "Curve-to-Tangent" points.  The issue is that the "Tangent-to-curve" and "curve-to-tangent" points don't have a shared id to link them.  My polyline layer does have measure values, which might be of use.

I have polyline data representing roads and point data representing mile markers. The points are on the line, so PointOnLineOverlayer does segment the line as expected. The point data has a Measure value that I want to use on the line, how do I set the measure value of the points to the lines?

Hello everyone, I'm working on creating a Geopackage, and I've added a new table (feature type) to indicate the relationship between several other tables. How can I add features to this table without taking the original feature type or feature from the reader.

Now that LDAP/Active Directory reader have been put on the deprecation list in FME 2023, I'm trying to find an out of the box solution in FME to update my workbenches and continue using it.  

I am writing a shutdown script to logg a workbench result to a postgres database.To log the output location of a gpkg file I am fetching a public parameter like so fme.macroValues['dest_path']But i get some weird formatting where backslash etc ar written as verbose text instead of the actual path? How can I get the actual path? C:<backslash>Users<backslash>User<backslash>Documents<backslash>FME_proj<backslash>20230913_FME<backslash>WIP<solidus>output<backslash>myoutput.gpkg 

My input attributes have numeric or string values, with possible empty string values.I would like to replace empty string values with Null. When I use the option "Substitute Missing, Null and Empty by: Default Value", and set "Default Value: <null>", nothing happens. The values remain unchanged (with empty string values). I can get the desired result with the help of "Action:Set Value" and Value: Conditional Value -> If ATTRIBUTE IS EMPTY -> Value <null>". I know I can use the Null Attribute Mapper transformer, and the Set Conditional Value method above, but using the"Substitute Missing, Null and Empty by: Default Value" option seems the most elegant to me. Have I misunderstood the purpose of "Substitute Missing, Null and Empty by: Default Value" or am I using it the wrong way?

I have a routine to be done once a quarter-year or maximun a month. There is some major file downloading and processing that was managed by parallel workspace runner in Form (Desktop). I need to deploy the same routine on FME Flow, but I need to take advantage of parallel processing. As I understood I can't process multiple simultaneous jobs with one engine.So I have tried combining it with FME Form WorkspaceRunner that actually works, but somehow can't pass the DB connection from Flow job to Form workspace. Is there a way to pass the connection from Flow job to WSRunner other than embedding the connection and so creating a workspace for every DB connection?

Hi,I have been asked if FME can retrieve signal data from a site with no API. I have credentials to get into the site, and once in I can pass a list of site ids to a url to retrieve a csv file of the data.I'm having issues passing my credentials in the header of the HTTPCaller as UserName and Password to get past the login page. Any idea if this is possible? This is the site in question:https://www.detecdatapro2.com/login

Hello ,i have some points at the same line each two point has the same attribute .i would like to connect each point that has same id together So I think I can use line builder with group by id .how but how to connect each two point without the line intersect with other points ? as my phone , point 1 and point 4 has the same id but if I connect 1 and 4 together so it will create line intersect or overlap on other line between 2 and 3 2 ,3 has same id 1,4 has same id what should I do to create line between 1,4 and other between 2,3 ? The line should cross but not intersect because I would like to use network topology calculator later . fme 2021  

I am using the attribute validator to test a list of pavement marking line marking types coming from a AutoDesk SDF. The validator is throwing false errors when I use the "In" ValidationThe list of values in the rule configuration are: Broken 1-1,Broken 1-8,Broken 3-3,Broken 3-6,Broken 3-9,Double Solid,Simultaneous Solid/Brkn-1,Simultaneous Solid/Brkn-2,SolidEverytime I run my workbench Broken 3-3 is reported as an error even though I've verified that the spelling is correct.I've also tried subbing out the commas with double quotes and it doesn't seem to work either. 

Hello all, I frequently used the FeatureMerger or FeatureJoiner transformers. However, none of them seem to offer a join based on an expression, such as checking if a value from one table contains a value from another table. How can this be achieved? Thanks for any assistance.

I have a polygon layer that was digitized manually and as a result, has some issues with overlaps and gaps. However, the first issue I would like to solve is making the polygons have right angles. They are all square or rectangle-type shapes so each vertex should have a 90 degree angle. Is there a way to manipultate the polgyons so that they are all at right angles? At this point, I would be able to check for snapping and other issues. Thanks!

I am trying to reproject a wms from the Environment Agency (https://environment.data.gov.uk/spatialdata/risk-of-flooding-from-surface-water-extent-0-1-percent-annual-chance/wms) from WGS 1984 to British National Grid. I need to know the cell size so I can provide a degree of accuracy of the data and have confidence in my areas of intersect calculations with some polygons. However, when I use the Reprojector, the spacing seems completely off. If I view it in ArcGIS Pro, the cell size appears to be 2m, which seems sensible. I have tweaked the parameters in the Reprojector but this doesn't give me the correct cell size. Any ideas what I'm doing wrong?

Hello - I have been able to use the HTTP caller to get data from an API. However there seems to be a 50,000 record limit. I have created a StartDate and EndDate fields using an attribute manager formatted as yyyy-mm-dd. I was wondering how I can use these fields as parameters to get data from (and including on) those two dates? P.S I have a field that is called OrderDate from the data the API gets and was going to use the dates to filter on that. However this field is formatted as date and time. Any advice would be greatly appreciated. Thanks,  

Hello,We are currently using FME and are quite satisfied with its performance. We are in the process of upgrading our SAP R/3 to an On-Premise S/4 HANA system. My question is whether I require an SAP HANA Runtime license or an Enterprise license to access the tables in my database. Has anyone encountered this issue before? SAP's communication on this matter seems somewhat ambiguous.

I have an Esri ArcGIS Binary Grid and a line shapefile. The shapefile was produced by the Surface Draper transformer, so it is 3D and has Z values at the verticies from the same Grid. The Z values that I would like to generate at a 10m interval can be output to a csv, instead of being applied to the shapefile: that is, I do not require verticies to be created in the shapefile at a 10m interval. Just need the interpolated Z values every `10m down the line. Thanks!

Hello - I would like to use the attribute creator in FME to generate a StartDate and EndDate. The EndDate should calculate the last date of the previous month and the StartDate should generate the first date of the previous month. There is no data to refence so I would like to identify todays data and then use the logic to get the Start and EndDate.  The idea would be to use these dates as parameters when calling an API. Does anyone have any suggestions on how I can implement this. many thanks 

Hello - I have several fields in hh:mm:ss format and I want to sum the total number of seconds from all parts all the field. For example:01: 10: 30 would total 4230 seconds  Does anyone know the best way to achieve this? I am brining the data in from an API and have used the JSONFragmenter to tabularise the data.  I assume the current data type for the fields is string as that's the default for FME?

We're trying to create a near-live view of our data, differing from the majority of content on our ArcGIS Enterprise which comes via registered Feature Services (source - Oracle database). We're unable to update the production dataset more often than the current weekly schedule due to internal constraints. We're aware that FME can update a Hosted Feature Layer but can it update a non-hosted Feature Service? I.e. one which is being referenced from a database via an SDE?

To ensure our database's data integrity, which is periodically enriched with measurement data governed by users, we use FME to create data validation reports in Excel. With these reports, users can correct their data iteratively.  To make this work, we use SQL statements stored as attributes in a table. Depending on the report to be generated, SQL statements are fed into a SQLExecutor transformer as attributes. At the time of writing, we employ close to 500 validation queries, each with their own set of columns as well as amount of columns. The picture below shows how the queries are inserted into the SQLExecutor as an attribute.  This is then routed to a dynamic Excel writer by using the SchemaSetter custom transformer. The Excel report is generated as expected, except for the column order, which

Reading las/laz from network drive suddenly throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it. Other filetypes works fine eg. JSON. Also, if I move the las/laz files and read the from my local machine it works fine.Any ideas why this happens? (My user have full priveliges on the folders and it's content also I have tried setting full access for anyone on the folders.) Thanks

This workspace is meant to upload salesforce data into our Snowflake account. I created a connection With Snowflake and have my account name as the parameter. When I run the workspace, it gets all the way to the end with no errors but says that the transformation failed. My coworker runs the same workspace (connected to their own Snowflake account, both are under the same company mother account) and it works and uploads the data to Snowflake. I have not found any similar issues while searching online. What could be the issue?

(Disclaimer: I have only rudimentary understandings of the inner workings of XML.)The source below is a GML file where I need to fragment/flatten the elements shown. I would like to be able to treat them as "normal" features with regular attributes. I am using the GML-reader associated with this specific data source, Norweigan SOSI, my settings are also below.  Q: What would be the best way to flatten this data?  (Or would the XMLfragmenter be a better tool? I must admit I find all this a bit confusing)    

Hi there,I'd like to add an arcgis online feature service to my Html report. When I use the Map Esri leaflet, I'm confused by the terminology of 'feature layer URL'.... Documentation/helpThis parameter allows the user to specify a list of comma delimited ArcGIS Online feature layer URLs, that will be displayed as additional layers on the map. Is this the feature service item Id URL? or do we need to be more specific and enter the REST URL of the layer in the feature service? As I understand it leaflet provides visualization capabilities for data hosted in Feature Services, Map Services & Image services. I think the documentation needs some detailed wording and/or examples. I don't seem to have much luck using this option in the html reports, but I

Saya hendak menukar file IFC kepada geopackage. Semasa meletakan writer geopackage saya telah memilih table definition manual dan juga Automatic. Masalah yang saya hadapi pada writer yang disetting Automatic, tiada objek geometri dan pada writer yang disetting manual berlaku kegagalan…Hanya apabila memilih dinamik sahaja ianya ok. Maslah saya disini dalah tidak mahu menggunakan table definition secara dynamic. Mohon bantuan bagi yang mahir. Bersama ini disertakan file2 tersebut. Tqvm.