FME Form

Hi, If I’m writing a fme-binary attribute out to jpeg using an AttributeFileWriter is there any way to publish as DataStreamer on FME Flow?  

I’m encountering this error and am at a loss. Everything in workbench (SQLCreator - Attribute Mgr - Excel Writer) seems to work fine, up until it gets to the writer. Excel Writer: Failed to write an attribute of type 'string' with value 'XMLDATA' to row '0' column '-1015942868'. Error message is 'col must be in range 0-16383'. Skipping featureWriter Mode: UpdateOutput Field Names: YesFormal Field Names: NoUse Attribute Names as Column Positions: YesStart Position: Start Column: 1 Start Row: 1  Any suggestions?  

I’m trying format the headers of an excel file. I’m attempting to use a template but can’t get it to work. The output always has a tab that is formatted like the template, and a tab with the data without the formatted headers. I’d like to write the data to the formatted tab. Is this possible?  

I’m querying databases using SQL Creator and have a Where clause date > ‘$(dateuserparameter)’.  I would like the dateuserparameter default value to be yesterday’s date, for example ‘2024-10-07’.  Is it possible to set the parameter’s default value to be yesterday’s date?

We want to automatically write 3D data to an existing 3DScene in ArcGIS Online. The data consists of borehole samples (geometry simple 3D-cylinder). We have tried using the Esri Indexed 3D Scene Layer-writer but the output does not show correctly and we can't create pop-ups showing the attribute data (although it looks like it's there). We're not sure why this doesn't work but figured we'd try here first to see if we can get any pointers to a best practice. So, can anyone please help shed some light on the best way of doing this - updating 3D-data to an existing 3D-scene in ArcGIS Online? (We will want to be able to do this also with mesh-data... for instance a ground model.)  

I’m reading a GPKG table, and when I view the data in the Data Inspector, I notice that FME removes some small holes in my polygons. How can I prevent this from happening?

I use a Sorter to sort on some attributes.When using the Dissolver with a GroupBy attribute and the Accumulation Mode ‘Use Attributes From One Feature’ after the Sorter I assumed the attributes are taken from the first feature of the sorted group. (Basically the same behavior as for a combination of Sorter/Matcher or Sorter/DuplicateFilter).However the Dissolver seems to work differently. The considered feature seems to be random (maybe a geometry condition drives which feature “wins”?).So the question is, how can I use the Dissolver so that always the first feature of my sorted group “wins”?I have an ugly mitigation flow with Tester, Duplicate Filter, AttributeKeeper, FeatureJoiner which is not really smart but cumbersome.Any ideas?Klaus (Version: FME Forms 2024.1.0 WIN64)

Hi,I am wondering if someone can give me some ideas on how I could pass the result of a sql query from a sql executor so that the result or specifically an ID is passed sequentially so that each is fully processed before the next one starts. So the result is as shown below. The attribute I’d like to pass one by one is either the device_id or the row_index.I have had a look at this post iterating/looping a workspace using attribute values | Community but cannot formulate the workbench to do this task.Any suggestions very welcome.Thank you.fb

Has anybody experienced an issue starting FME Form (tried from v2023.2.1 to v2024.2) when having 3 displays connected.We have 2 LG 24MP60G 1080p monitors conected to a Dell Alienware X15 R1 (Intel Core i7-11800H 4.20Ghz, nVidia GeForce RTX 3070 8GB GDDR6, 32 GB DDR4). In this setup FME opens as a blank white windows.If we disconnect any monitor FME starts as usual.Please let me know if anybody else experienced something similar or if this is a known issue.

I am working with a script that transfers data from one SDE to another SDE. Currently, the script does not ensure that the relationship between a feature and its attachment remains intact. To address this, I extended the workspace based on the guidelines in this article: Writing ArcGIS Geodatabase Attachments.This solution worked fine when transferring data from one GDB to another GDB using the same data model. However, when we run the script from one SDE to another SDE with the same data model and data, it fails and I encounter the following error messages: Failed to retrieve origin row for a relationship feature with OBJECTID '3' from table/feature class 'BAGGERWERK_WATERLOPEN' GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): A fatal error has occurred. Could you provide guidance on how to resolve this issue?

My team has a workspace that has ran thousands of times before that has started failing in two different ways. The first failure does not actually trigger FME to fail, it stalls out on the ContourGenerator and does not move. Memory space, RAM, CPU usage, and GPU usage are all fine, none of them spike or max out. In fact RAM usage is quite low. Other times it will fail, at the same spot and give this error:An error occurred. FME will attempt to obtain more information on the error, but this may cause the translation to be terminatedAn error occurred. Here is the information that FME was able to find on the errorget_next_capacity, allocator's max size reachedI found this post from four years ago suggesting to just contact the support team. Any ideas before I do so, or is that still the recommended route to take?Version is FME 2021.1.3.0 (20211002 - Build 21631 - WIN64) I know this is an older build, I was told by my management that a new build would not fix any issues/make a difference a

Hi,FME Server 2022.2.1 Express install.Connecting out via proxy (not authenticated).https is not enabled on tomcat I've published an OAuth2 connection to the FME Server and am trying to Authorize it. Proxy is configured in the FME settings. Client ID and Secret is all set up correctly, including the redirect URI as I can get to the OAuth sign-in page for the app. However when supplying my credentials the token/code is being sent to http://<server><port>/fmeoauth but it just returns an error page "FME OAuth Service FAILED" "Failed to complete". I've also tried to use the ip address of the proxy to no avail. I'm guessing it is a tomcat redirecting issue but can't see any previous info related to modifying the server.xml or OAuth config file in the install folder. the FME OAuth log is detailing some nio error: Sun-19-Feb-2023 04:28:08.734 AM  INFORM  http-nio-0.0.0.0-80-exec-2  417005 : Retrieving connection with nonce: <removed>Sun-19

I have a dataset, representing a road network, in a Geographic Lat/Long coordinate reference system. The area covers three UTM zones.I want to calculate the length of roads / polylines with metres as the unit of measurement.What transformer should I use?

Connection to postgres seem not to close after query execution to postgres db. We are here allowed to have 5 connections to the postgres db and with the SQLExecution for each feature entering the transformer, a connection is established but seem not to close after the the query has been executed. After 5 features have entered the sqlExecutor I receive an error message: Error connecting to PostgreSQL database.....................: 'FATAL: too many connections for role "xxxxxxx"Is there a way to close the connection after each featue that enters the SQLExceutor? We are using FME 2021.1

I use the AIXM 5.1 Reader with the default settings to read all AirspaceTimeSlice. Some of them are missing geometry. For example, I have a feature which uses xlink:href  to reference the geometry of a CTR. The CTR in itself has an UNION and consists of two CTR's which are also referenced with xlink:href. How can I get FME to get this geometry. It somehow doesn't seem to follow up on the xlink:href. I use FME Desktop 2019.2.3.1

I have 4/5 layers of rasters representing the geological horizons. I want to visualize the layers in 3D voxel. what the result look something  like this. Is there a way to get this with fme? 

I have a layer that contains 2 point line features i.e. start and end only, and I want to convert the start and end to points but have a count that keeps the parts in order. For example the start of the first line has count of 1 and the end of that line a count of 2, then the next line, start point would be 3 and end point would be 4. Each line has an ID so was thinking to try and group the points by line ID and then apply the count but can’t get the grouping to work as expected.   

Hi, Im trying to write approx 17.000 rows into an existing feature service in AGOL. I get the error "entity too large for url", so I assume its too many rows. I have tested with a few rows, and that works fine.  I have tried now to use the ModuloCounter and a TestFilter to split into smaller groups, and then add multiple AGOL-writers, so they only write one group at the time. Im not sure this is the best way to go, as I would the need a lot of writers. Another is to use the FeatureWriter to do the same, but I would still need to do the setup for all the groups, so not sure if thats ideal.  Does anyone have any better suggestion? Best,Anne Kathrine

With a permanent licence fme desktop hit much engines do we have available ? 

Using FME Form 2024.1.2 and QGIS 3.34.4 with Python 3.9 the following script:import fmeimport fmeobjectsimport sysfrom qgis.core import QgsApplication, QgsVectorLayer, QgsProcessingFeedbackclass FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def __init__(self): """Base constructor for class members.""" # Initialize QGIS Application QgsApplication.setPrefixPath("F:/QGIS 3.34.4/apps/qgis-ltr", True) self.qgs = QgsApplication([], False) self.qgs.initQgis() # Append the path where processing plugin can be found sys.path.append('F:/QGIS 3.34.4/apps/qgis-ltr/python/plugins/processing') from processing.core.Processing import Processing Processing.initialize() import processing def has_support_for(self, support_type: int): """This method is called by FME to determine if

I am writing a PyQGIS script (Python version 3.9) within FME Workbench 2024.1.2 Python caller transformer which has to run some processing tasks from the QGIS (LTR 3.34.4) processing framework:import fmeimport fmeobjectsimport sysfrom qgis.core import QgsApplication, QgsVectorLayer, QgsProcessingFeedbackclass FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def __init__(self): """Base constructor for class members.""" # Initialize QGIS Application QgsApplication.setPrefixPath("F:/QGIS 3.34.4/apps/qgis-ltr", True) self.qgs = QgsApplication([], False) self.qgs.initQgis() # Append the path where processing plugin can be found sys.path.append('F:/QGIS 3.34.4/apps/qgis-ltr/python/plugins/processing') from processing.core.Processing import Processing Processing.initialize() import

Hello all ! I need to create CSV where value will end  with a semicolon. I can do it using AttributeManager > @SetValue(SUP); but in that case it would add “ “ between attribute because it is converted to varchar. I need it without those “ “ but can’t manage to do it.Example below : 1st is my output and second is what i want. Only difference is those “ “.PS : Title is correctly formattedCODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;"0,099368;"CODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;0,099368;

I would like to find for each green point the closest orange building limited by the parcel border the green points are situated in. See the attached image below. The neighbourfinder should do the the trick but should not search in adjacent parcels for closeby buildings. Any suggestions? Ps. This is a snapshot of my data. I have about 700 green points and their parcels and buildings. 

Hello, In the case of having a permanent FME Desktop license, can it be reused on new machines ( i want to use it only in one engine so i would like to know is it possible to use it in anothe engine), or do we need to purchase new ones?