FME Form

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="c:\\temp\\test.ifc"/>910 <updatemodel file="c:\\temp\\test1.ifc" with="c:\\temp\\test1.ifc"/>1112 <updatemodel file="c:\\temp\\test2.ifc" with="c:\\te

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 and it goes thru. After saving the web connection and testing it on the sharepoint connector transformer it fails to load any sites and just throws an “unknow error”.So I am not sure at this point if its an issue with the registered app setup or if i lack access permission to o

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) = >https://data.woodmac.com/query/upstream_weekly/imp-met/odata/field_geospatial_summary<Reader Parameter(1) = >AUTHENTICATION<Reader Parameter(2) = >Basic<Reader Parameter(3) = >USERNAME<Reader Parameter(4) = >allen.guan<at>bhp.com<Reader Parameter(5) = >PASSWORD<Reader Parameter(6) = >********<Rea

Am using DateTimeConverter to change date YYYYMMDD into YYYY-MM-DD (CSV File), it is converting it when check on Visual Preview. But when open in excel, does not show it. Seeing FME_Rejection_Code = Invalid Input

Hello, I have 4 excel documents hosted on SharePoint, I am using a FeatureReader taking in a temp download path.  As can be seen the 4 items are being opened successfully in the featurereader, but the data is not grouped in any meaningful way for me to extract and sort out the various excel documents data (which is varying formatting, some have multiple tabs with differing data/headers between them, as you can see there are 14 schemas (total tabs within excel docs), and 1546 generic bits of data (total rows))I’ve read that I can re-group the datasets by using fme_basename but I cannot work out how to expose this, I’ve found the post below, which offers suggestions of how to expose that data. But the solution it offers is not applicable, I am using version  Does anyone know how I can expose the fme_basename?ORIs there a better way to do this?     

I have a unique problem. I have a set of polygons which take the shape of numbers. In the example below, the number 1875 has been extracted from a raster. As it sits, the 4 numbers are separated but could easily be aggregated. I’m looking for a way to convert this value ‘1875’ to an integer attribute.I can’t think of a way apart from some kind of AI solution, but thought I’d ask the collective to see if anyone has any thoughts?  

I want to convert a tiff to TINrelief in citygml. Is there a fmw workbench file or step by step guide for this? I’M a complete begineer to fme and citygml format.

Does writing to a MapInfo Extended TAB format take longer than to a MapInfo TAB ? Just wanted to check with the community if this is a known/expected behaviour with writing data to MapInfo Extended TAB and also if there are workarounds to quicken the writing process.Although I have experienced FME 2017 take considerably longer time to write a MapInfo Extended TAB for polygon data that is about 1.2 million in count, I failed to take note of the actual time it took, from the log. I do have a stat for a much smaller dataset, that of 1500 polygons and it took about 14 minutes to write to a MapInfo Extended TAB

Hi! I have a new question today. I want to create centerlines on highways. Now, long lines, without intersections, work fine. However, i get wrong results when fme encounters a intersection, like in the pictures below. I expected this and tried to solve it, but it only became worse.  Does anyone know a right way to do it? Thanks in advance!    

Hey guys, I'm not sure if this is the right forum to ask, but I'm at a loss as to what to do here. I'm still quite new to FME and have tried looking for solutions to this problem that I am having.I have read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and installed SQL Server Native Client 2012 on my machine, https://www.microsoft.com/en-us/download/details.aspx?id=50402, which wasn't installed before, but I am still running into the same issue.Details from the translation log:2021-06-05 13:14:39|   0.2|  0.2|INFORM|FME 2020.2.2.0 (20210111 - Build 20817 - WIN64)2021-06-05 13:14:40|   1.2|  0.0|INFORM|Operating System: Microsoft Windows 10 64-bit  (Build 19041)2021-06-05 13:14:40|   1.2|  0.0|INFORM|FME Platform: WIN64  2021-06-04 08:28:55|  45.6|  0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2021-06-04 08:28:55|  45.7|  0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2021-06-04 08