FME Form

Hi, I used an AttributeFilter transformer to split attributes. I want to write each of them as a feature class in a new file geodatabase. What is the best way to do that?Thank you for your assistance.

I have around 340 .las files and im just truing to split them. As you see in the picture i have a fair amount of distance between these files 

Hello,I would like to test a variable before running a workspaceRunner or not.if attribute ‘recetteCouche’ = 1 then running workspaceRunner ‘000_recetteCouche..’0’ else if attribute ‘ecritureLivrable’ = 1 then running workspace ‘0000_ecritureLivra...’, etcmy configuration for each  WSR is : ‘wait job job to complete = YES’Please, someone have an idea ?Olivier.

Hello. I have a workbench that reads an XML and splits it into attributes with their values (with one spatial attribute). I am trying to write this data to an existing, empty SQL Server table. If I set the writer to create a new table, it runs fine, but I can't seem to get it to populate my existing table. The workspace runs, and passes with warnings, but when I go to my SQL Server table it is still empty. Any ideas?  My writer is configured as follows: Feature operation: Insert Table Handling: Use existing  The translation log claims that all of my features have been written, and the data inspector shows them fine, but it just won't populate my table.  Thanks! 

Using the Httpcaller i can successfully make a rest api call to retrieve a token for an ArcGIS Portal Featureservice. A proxy server is set up but is not used for this url so the call bypasses the proxy. However, I can only set up and use an ArcGIS Portal Feature Service connection if there is no proxy set up at all. If the proxy is enabled, the connection tries to use the proxy even though the base url is on the exception list.

Hi,I have an URL that I’d like to read in, but it contains the current date and thus is being updated everyday. How may I change the URL within the reader so that it’s automatically up-to-date?I’ve tried define a user parameter as a URL but I don’t manage to make it dynamic there. I thought I could replace the date e.g. 2024-11-05 with @DateTimeFormat(@DateTimeNow(),%Y-%m-%d) in the Default Value URL but it doesn’t work.Any help appreciated! 

When using the FeatureWriter to write to an Esri Geodatabase (ArcSDE Geodb) Feature Class why is there no option to use an Attribute Value for the ‘Feature Class or Table Qualifier’ setting?There’s only the option to use a User Parameter. I am trying to make this dynamic as the Qualifier would change depending on the environment I am trying to write to. The value I want to use is coming from an attribute. The option is available in the ‘Feature Class or Table Name’: Just curious why this format is set up this way in the FeatureWriter. Could this be addressed in future versions please?Version: 2024.1.1.0 (20240729 - Build 24619 - WIN64) 

Hi,I want to fill the User Param Choice with data from a table in MS SQL. This works fine with the 'Import->From dataset...' option. but this function only populates data statically. Is there any way to 'hack' this to fetch data dynamically? The idea is that this Workspace should work in a App in FME Flow.  

My organization has a platform that allows users to collect spatial data. We have a forest plot survey that allows users to collect information about forest characteristics. The form is intense, with many nested layers, many-to-one relationships, and repeating sections. I have developed a workbench that reads the JSON from our organization website and ‘unpacks’ it into it’s individual tables, all with id’s to perform the necessary joins down the road. Previously I was just writing all the tables to their own sheet in an excel document, but now my managers are asking me to populate the data into their preferred format, so they have given me an excel table to show what they want the output to look like. It’s not a data friendly format. Essentially, they want all the data to populate onto a single sheet where the sheet has multiple instances of different fields names in the same column. Think like multiple tables stacked on top of each other in one sheet.  My initial idea was to write all

Hello everyone,This question has been asked before, but for some reason using the following transformers mentioned in the following post  (Geometrypartextractor > GeometryFilter > Chopper) didn't help me to split certain shapes into lines and arcs respectively. The situation is as follows for me: I read a dgn file (thus a CAD format) in FME in which I have exploded cells. Then I do some transforming on the data in fme before writing to a table in a database. The final step is that I use GeoServer to look on the table i which I have created in order to create a WMS. However in Geoserver, I get the following error: “ORA-13346: the coordinates defining an arc are collinear.".In my dgn, I have the following kind of shapes and I think these shapes are the causes of this error. So, I am now trying to split  specifically those shapes with arcs and lines into separate lines and arcs. Unfortunately, that didn't work for me yet. I hope someone can nudge me in the right direction. As you ca

I have ArcGIS 10.8 with 64bit Background processing installed and am using the latest version of FME Form (FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64))I want to read data from an ESRI File Geodatabase with the Esri Geodatabase reader and writer and am having sporadic compatabilty problems. At the moment I cannot read from the geodatabase but I can write to it. Other times, I can’t write to it either.I have set the translation parameter to ESRI ArcMAP.I have also reinstalled ArcGIS 10.8 and this morning I updated FME Form.I have also realised, that after the problem arises, if I restart FME I can write to the File Geodatabase again.Why am I still having problems?

I have a workspace which takes point features and assigns them models essentially this workflow: https://community.safe.com/s/article/creating-and-using-geometry-instances But I'm finding that the performance is quite bad. Is there anything I need to be aware of when using this kind of workflow? The idea of using a geometry definition was supposed to speed things up - heh.  I know with raster datasets there is some little tricks that FME does in the background to speed things up by not reading bits until it needs to. Perhaps there are some transformers I should avoid?

Hi there - I have produced a table in a word document using the MSWordStyler and word writer. However I would now like to add a title to the word document above the table and I’m not sure how I do this. I would be grateful for some advice please. Thanks Ruth

I am trying to create a GML file that complies to the GML simple features profile (GML-SF) (http://portal.opengeospatial.org/files/?artifact_id=42729). I already created a GML application schema that complies to the GML simple features profile. It follows the pattern described in GML-SF, 8.4.2:<schema xmlns="http://www.w3.org/2001/XMLSchema" xmlns:ex="urn:uuid:3c615c60-013b-4006-bf53-d0ba4fb5fc94" xmlns:gml="http://www.opengis.net/gml/3.2" elementFormDefault="qualified" targetNamespace="urn:uuid:3c615c60-013b-4006-bf53-d0ba4fb5fc94" version="1.0.0"> <import namespace="http://www.opengis.net/gml/3.2" schemaLocation="http://schemas.opengis.net/gml/3.2.1/gml.xsd"/> <element name="FeatureCollection" type="ex:FeatureCollectionType" substitutionGroup="gml:AbstractGML"/> <complexType name="FeatureCollectionType"> <complexContent> <extension base="gml:AbstractFeatureType">

Hi, I’m having some problems working with the CSV Reader. I created a Reader from a CSV that has 3 fields: Address, City, and ZIP. I have ‘Case Sensitive Field Names’ and ‘Enforce Strict Schema’ set to No, but then if I modify my source CSV to have the attributes: address, city zip, and Notes, the Reader fails to read in any data.What am I doing wrong here? It seems like even though I changes some properties for the Reader, it is defaulting back to the original schema that I input when creating the Reader. Any help is greatly appreciated. 

Hi,I have one script in R running in RCaller, but the RCaller show some messages like erros but no erros, my script run properly. I would like to ignore these messages and generate one feature for the next transformer. How can I do this?  Thank´s

Hello ,i would like to insert some new points into ArcSDE, where each point will be positioned on and connected to various lines.How can I establish a relationship between each point and its corresponding connecting lines?Is it possible to set up this relationship in FME, so I can view the relationship class later in ArcMap?there is already a relationship exist between feature class lines and feature class points.But what  about the new points from FME?Could anyone advise me on a solution?Thanks in advance .FME 2023

Hello , I'm looking for an efficient way to compare the versioned SDE with the original SDE. I'd like to perform this comparison before running the compression and before posting the jobs in the database.I believe it would be time-consuming to read and compare all tables from both the versioned and original SDE. Is there a method that would allow me to read only the specific tables that have been edited in the versioned SDE?Thanks in advance FME 2021

I have a pair of longitude latitude coordinates that I’m trying to measure the distance between in KMIf I cross-reference this “distance” result in ArcGIS Pro, I get approximately 1.44kmThis is also roughly the same result if I use a online calculator;My question, is how does the result 0.01630799258600798 translate to 1.44km? is there something I’m missing??

I have an FMW that writes a CSV file and then uploads that CSV to Azure BLOB. The CSV that's created on the server's disk is okay. It has 201 records as expected and opens up just fine. That CSV--after FME uploads it to Azure BLOB via AzureBlobStorageConnector has about 25 less records--seemingly randomly removed. To rule out Azure BLOB itself as the problem, I used Microsoft Azure Storage Explorer to upload the CSV--when I do that, all records are in the CSV file when downloaded back down from Azure. I have experimented w/ a folder upload (upload the file w/ a containing folder) vs. a file upload--no luck w/ that, same result. What really bothers me about this is how it makes no sense. The CSV that gets uploaded should be the CSV that's on disk. It's a file and file-upload process. What could possibly be removing certain lines/records from the file?

Is it possible to use Microsoft app registration in Entra ID to connect to Azure BLOB (non-anonymous, for read+write)? I find information on using a key to connect to BLOB--but my IT policy doesn’t allow keys. I need to be able to connect to BLOB from FME Flow.App registration with Entra ID works w/ connecting to Sharepoint. How about Azure BLOB?

Hello,I have posted my question in esri community but I did not get answer yet .i hope ,if someone could fix my issue  .I am inserting points into an SDE version using FME, but after creating the point, I'm unable to edit the UT Attribute Data. My company uses UT-Editor (developed from ArcMap), and typically, when I create a new point in UT-Editor, a window automatically appears to fill fields in the UT Attribute Data.some fields are necessary to fill in like Adresse and … However, since I'm inserting the points through FME, when I use the UT Attribute Data symbol to select  the point to try  fill the fields in, the window does not open. How can I resolve this issue? Is there a specific method that would allow each new point to linkage to UT-Attribute Data by FME ? or How could open the UT Attribute Data window in UT-Editor for each new point ,come from FME ?Thanks in advance . FME 2021 

I have an aggregated line, containing three parts. Every 50 meters I need to have a point/vertex/measure and using the MeasureGenerator in conjunction with the MeasureExtractor works in principle fine.The MeasureGenerator will only work if I ‘Deaggregate’ the parts and then every part gets a list of measures, starting from zero (as defined in the MeasureGenerator).My challenge is, that the next part of the line should actually not start from zero, but should set the first measure with regards to the remainder from the part before, where there might be the last measure at e.g. 250 m, but there is a remaining piece of 2.2 m.These 2.2 m should basically subtracted from the start value when creating measures for the next part.Is there a way to achieve that?

Hello fellow FME enthusiasts!We've run into in issue with writing Excel files to our sharepoint. We have a workspace that output's an Excel file.We've set it up to use a template to make sure it has the same easily readable layout for our users. We store the Excel file on our sharepoint. Our sharepoint folders are available locally on the PC through One Drive. So we store them to a location like: C:\Users\[User Name]\[Sharepoint name]\[Folder name]The issue we have is that every time we do this with the Template setting active in the Excel writer we get a sync error saying there is one file in out local folder and another one online. It's easy enough to fix this manually (One Drive gives us this option). But it is a manual action. If we write to the same location without the template setting in the Excel writer all works fine.We are working with FME version 2024.0.3.0 (build 24220)Has anyone experienced this before? And found a way to fix this?

Hi FME ninjas.I'm trying to replicate this end result:These are city streets, they started as line objects and have been converted into polygons.I'm guessing the workflow is as follows:- Convert street lines with a buffer into a polygon- Inflate those polygons until they touch an adjacent polygon- ???- Proft! 😀But I don't have a clue how to do this or what transformers I need.Who can help me out creating this workflow?​​​​​​​Thanks.