FME Form

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?

Hey! I’m trying to do something that in my mind is very tricky, mainly because I don’t know how to do this. I have a table with bird “routes”. For some reason, each bird species is in a separate column, with a value for the number of individuals in that column. It can look something like this:  In row 2, at one given location, 1 “Stare” and 1 “Grönfink” have been spotted. There are around 190 columns, making this table a bit odd to work with. To work with this data in a different project, I would like the table structured differently. What i would like as an output is a seperate row for each observation, with number of individuals as a seperate column. So, in this case, row 2 would be 2 rows, one for the “Stare”-observation and one for the “Grönfink”-observation. Basically, turning the column names into attribute values.  Does anyone on this forum have any experience from this? Any help would be greatly appreciated!  Cheers!/Alex

Hello everyone, I have an XML file containing the registered real-estate data and want to export it as an IFC file. What is the procedure to get the geometries and their atributes out of that file. As I have read, the first step is to use the XMLFlattener. But I do not know on which level do I have to flatten it (Elements to match). There are a lot of nested paths. If I select one path, do I have to select the paths under it? And this flattening process takes a really long time! What is the solution? I would appreciate your help.   

Hi, I have a SQL Executor calling a stored procedure.  I am running FME Form FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and am getting this issue:Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'The transformer is not failing, but its not producing a result either. Not sure how to move forward with this one. Any thoughts?Thanks 

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 All,I'm experiencing a bug in the Excel writer in the new FME 2024.0. I've made a script that outputs multiple data categories I need to process in a particular order to ensure my calculations are fed as desired. The bug causes the attribute names to not be written in the first row in Excel; it just starts with the data in the second row. Whenever I open the exact same script in FME 2023.2, the writer does write the field row names, without me changing anything in the writer settings.For now, my solution is to not use FME 2024, but since my customer does use 2024, it's not desirable. Does anyone have any ideas?Here is a preview of Excel. I can't scroll up to the first row, the data is not hidden, and the navigator also won't allow me to go to row 1. 

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?