FME Form

I just learned that you can copy & paste Conditional Values from one transformer to another without having to open the "Parameter Condition Definition" windows each time. My question is: When pasting a Conditional Value, you have to select "Paste Conditional", if you select "Paste" it will paste a text equation that fails. I assume this behavior is a bug, can someone confirm this? This is better described in the second observation noted below.The screenshots below show how this works from AttributeCreator to AttributeManager. Observations I had which might be helpful to others are:When copying/pasting you need to select the text first (e.g. "3 Possible Values", not simply the Cell. (Right clicking the cell gives you options to Cut/Copy/Paste/Duplicate the row.) When pasting I noticed that you have to select "Paste Conditional", if you select "Paste" it will paste a text equation an

Is it possible to write an image from a jpeg url into a file geodatabase? In other words, I want to store images directly from a url into a geodatabase. I need to extract the image from the url and move that image into a geodatabase. Thank you!

Hello there,i want to mark some points which are already placed at each corner of the building polygons in a DGN(MicroStation) file,i want to mark points which exist within 10m buffer from the road, and also points which at the road facing side of the building not at the back side of the building polygons,when i tried using the buffer it covered all the points including the backside points, if buffer reduced some building points got missedseen the image, the intention is to mark only the blue circled pointslooking for some suggestion, ideas are most welcome thanks. 

How to securely achieve the desired order of in which are feature types (tables) written in the database? I have some FK dependecies in the target tables and I have somehow discovered that its written from the bottom to the top of the feature types list. If its not written from the parent to the childs it crashes on FK violations. I know there is an idea registered. But so far what are the options? It consider the inserts/updates and also deletes where i would need the inverse order.Thank you for the suggestions.

Hello, I’m new to FME and I’m encountering a problem where the same rows of data aren’t being saved to both writers. I have two writers connected to the same database but with different tables. When the data is processed, the one saved in the shp_db_b table and can be seen, but there’s no output for the dashboard table (Even though it said ‘Translation was SUCCESSFUL’). I think the issue might be with the Aggregator transformer, but I'm not completely sure. I've attached the relevant pictures for reference.  

I’ve a Microstation DGN file where Building as polygons and each corner of the building polygons have a point, those points have some attributes in the form of MicroStation TAG, i want to check the TAG attribute of the points.Each point will have many attributes like building no, street name, etcif any point in the Building with TAG value ES=1 then the trailing point and successor point must be either ES=1 or ES=6in the below image red point are ES=1 and the orange points are ES=6i want to check the validate this caseany ideas most welcomethanks in advance 

Is there any possibility to use an if statement similar to the xmlTemplater: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/xmltemplater.htmThe following code in the jsonTemplater returns the error "JSONTemplater_2(XMLTemplaterFactory): The following error occurred near line 2, column 50 of the query:JSONTemplater_2(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)"Suggestions and code samples would be very welcomed.{    if (fme:get-attribute("IS_GRENZPUNKT") eq "1")    then        "1": {}    else       "2": {}}

Hi,I am trying to put data in a zipped file geodatabase in 4 feature tables. Only 1 table is written to the zipped file geodatabase, the rest are not. (no error message). If I write to an unzipped geodatabase file, the 4 tables in the geodatabase are written. How do I write multiple feature writes in the same zipped file geodata tables? (I have tried feature holders to put tables 1 by 1 in the zipped file geodatabase but that makes no difference). 

It’s about this error message "No Module named GeoEncoder", how can I solve this error?  

Hi all,When I write to a newly created Feature Service on ArcGIS Enterprise, the attribute data doesnt populate, all the attribute column data is null.The shape data populates but the attibute data doesnt for the Feature Service.Has anyone come across this when writing a Feature Service to ArcGIS Enterprise using FME?ThanksAnthony

I am getting some really strange results when trying to offset aggregated lines. The fat red lines below are aggregated. This is sent to an OffsetCurveGenerator, thin pink lines. In this instance it seems like the OffsetCurveGenerator treats the lines as individual parts and offsets them to different sides (I am looking at only left channel out here). In other cases it fuses the lines into unities that can not be restored afterwards with a Deaggregator.Any ideas on how to resolve this, or workarounds?Edit: I went back and checked the geometries in the examples below, there where to complaints in the GeometrValidator. This is a spinoff from my previous thread:   

I’m trying to identify the vertex/vertices in a 3D dataset which are at the zmin.The task is very easy but I’m trying to figure out the fastest/cleanest way to do this. The dataset could be quite big and the geometry could be any type (not point cloud or raster).  

Hi,I need your help.I would like to read the data from an excel file that change every week.  Moreover the excelfile have a different name every week.I would like to try to automate the process and as an input i would like to have the directory instead of the file. How can I do that? Thank you for your answer.Pauline 

I have this XML that I want to update:1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with="c:\\temp\\test.ifc"/>910 <savemodel file="c:\\temp\\test.smc"/>1112 <exit/>13 </target>14</batch>I want to read other files, for example, test1.ifc and test2.ifc in FME, and I want to add them to the XML to be like this:1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with=

How to modify Adjacent feature to find a value of two next cells?Thanks 

Hi, I have generated a tree in FME that looks like that (data type=buffer)How can I save it as in Excel so it looks the same? I assume the question is how to change buffer data to an image

Hi all,I just wanted to get an idea on how others are working with FME when it comes to inspection.I have FME configured to always open up the FME Data Inspector rather that the Visual Preview in Workbench. Mostly I do this because I like to have a larger window and I’m used to it from the pre visual inspection days.Am I missing out? Any tips on using the Visual Preview? I’m interested to hear from other on how they handle inspection 

Hello , I would like to read all versions name without selecting them in feature reader arcsde esri i need to let feature reader to show me the data from all versions from users ,to know which data that users are currently  working on  .could someone advice me ?thanks in advance 

Hi guys,Need a bit of help from those experienced with FME and sharepoint.Scenario:Need to access a “shared” excel file from our business groups sharepoint site as source for ETL development IT created a registered Azure app following FME guide on setting up Sharepoint web connection for single tenant, web guide. IT provided Tenant Id and client Id. IT setup registered azure app with delegated permissions: user.read, sites.selectedIssues:After following the guide for the web connection setup on FME, when testing, FME loads our orgs login page, when I key-in my windows account, I keep receiving prompt to ask admin for permission. I tried asking our Azure admins to test the web connection using their admin account

We have hundreds of mappings we execute via command line.  We have implemented standards regarding the use of source, destination, and logging user parms.We started our 2024 migration and found a bug while trying to pass in our --LOG_FILE parm from the cmnd line (fme ...fmw --LOG_FILE xxx).The workspace will not execute and throws this error:ERROR : Unable to open log file `X:\...\FME\X_\...\Log\mapping_name.log'ERROR : The preceding error has occurred during FME logfile setupFor some reason, in 2024 it is always prefixing the log location with the location of the fme workspace.The only workaround I found to get the log file to write in our desired location was to eliminate the --LOG_FILE parm and use LOG_FILENAME instead.I have opened a ticket with Safe and have not heard anything back.  Having to modify hundreds of workspace executions is a show stopper. 

Hey all, In my previous post It was suggested to use TempPathnameCreator to download these files and once processed, the location and file will be deleted, saving disk space. However, I am unable to view any data in the FeatureReader. In this instance, my FeatureReader has 905 records under the <Generic> Port, but when I view it via Feature Caching, it says “No Schema” for the attribute name and all the values are empty. However, If i click the Columns and hit “select all” it seems that I can actually see the tables, but I can’t seem to access the data with an attribute remover or the likes. Do I need to expose some attribute within the Generic Port <Attributes to Expose>?Any help will be appreciated! Thank you!

Hi all,I am working on a translation in FME, and I’m encountering an issue where my data is being fanned out to multiple locations. However, when FME tries to write the shapefiles to the first file location, the translation stops without any specific warnings or error messages, other than the general "Error running translation."Interestingly, on FME Flow, the process behaves similarly. It doesn't throw any errors, but the translation simply stops after attempting to write to the first location, as if it's hanging or failing silently.I’ve tried to troubleshoot by checking the file locations and permissions, but the issue persists. I would appreciate any guidance or suggestions on what might be causing this or steps I can take to diagnose it further.Thanks in advance for any help :)

Hello,I have an excel files with values in it. I read the excel file, want to use the value from column E (value is 45), use it in a math formular and calculate a new value. At the end the result should be written in to a Feature class in a FGDB. The transformer I want to use is expression value. But the calculation doesn’t work. Has anyone an idea? Thank you!Teresa  

When using Sharepoint Online Connector, this error message appears "timezone offset does not match system offset: -18000 != -216000. Please, check your config files." I'm from Mexico timezone, how can this be solved?

I have a vendor OData feed URL. It works fine in my Power BI, but fails to retrieve the feed in FME desktop (2020.1.3). Below shows the error. I am using the same credential in both Power BI and FME user authentications.  Python Exception <KeyError>: 'name'A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'ODATA' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationUniversalReader -- readSchema resulted in 0 schema features being returnedReader Parameter(0) = >