FME Form

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

Microsoft SQL Server Spatial Reader now fails to connect post upgrade to 2020.1. It worked with 2020.0. We are getting this error: Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. - is there something we need to install?

I have an AGOL text field with a limit of 1000, but the reader appears to be cutting off the fields at 255 characters. It appears to be happening in the reader directly, not later on in the translations. Any workarounds on this other than just adding an additional text field, or is this a known issue of the AGOL Connector?

I have got some beautiful Excel templates containing tables (not normal ranges). It's quite easy to write to a named range within Excel but I haven't figured out how to write to a Table. Does anyone know how to do so?

Currently I have 23 CoG’s in an Azure Blob container and I want to retrieve only the area of those CoG’s covered by a rectangle that I use as the initiator for a FeatureReader.Unfortunately, the FeatureReader is reading first all the CoG’s in before making the decision where the bounding box is within, and then it returns the entire CoG, where I was rather expecting it would return the part the bounding box is covering.The CoG’s originate from the Copernicus DEM coverage GLO-30, contain overviews, etc…It takes almost 3 minutes for the FeatureReader to process the request. The bounding box is within a single CoG.When looking at the parameters for the COG reader, then I can see there is actually the possibility to set a search envelope. I could feed the bounding box to the envelope, which sadly is missing in the FeatureReader. Is there a way to speed things up? I only want to have the parts of the COG’s covered by the bounding box used as initiator, basically performing a range request.

I am trying to configure to run a FME workbench as in Schedule task. The batch file itself run fine. But something is happening when its run from Task Schedule. It seem to start a workbech, but it is not executing the workbench. This is the stout output i manage to log.          FME 2022.2.5.0 (20230329 - Build 22795 - WIN64)            FME Database Edition (floating)                Permanent License.           Machine host name is: xxxxxx   Operating System: Microsoft Windows Server 2022 64-bit (Build 20348)         Copyright (c) 1994 - 2022, Safe Software Inc.                Safe Software Inc. When i run the batch file through cmd it start logging "reading" etc after the first I assume is a license check initial License check. I have tried to multiple things alreadySet the "Start in" option to be the directory where the bat file (and workbenches) are locatedabsolute pathset the first line of batch file to cd into the directory of the workbenchI am running the batc

Hi,I have a parameter that I have set in an FME Server/Flow app that is conditional on another parameter. I.e. The first is set by the user in an app. If there is a certain value, then it would require you two set a secondary variable.I used to have this set as a simple ‘dropdown’ choice, which then would require a simple text input (if needed). I tried to change the original parameter to a ‘choice list’ instead, to make it easier to follow, but this is causing me issues.When I preview how this looks in FME Form it works exactly how I want to. Though when I try to on Flow it doesn’t show/require the secondary parameter. Is this a bug? Or something I can fix? I am constrained to version 2023.2.1.0 (23774) for at least the foreseeable futureAny advice would be appreciated, I can’t seem to get it to work no matter what I try

I have an excel file that has a list of addresses, and their associated license number.I want to join this to a geodatabase file to output any parcels that have any of the addresses in the excel file.  I can’t seem to make that work.  Can anybody point me in the right direction?  I’ve tried FeatureJoiner and FeatureMerger and can’t seem to get any output without failure.

I’m using the Data Interoperability extension in ArcGIS Pro.  I can’t seem to get a excel reader to add in.  I’ll set the parameters, it’s not open anywhere else, it’s not password protected or anything like that, and it’s on my local system.   When I click ok to add it, fme acts like it’s trying to add it, but then just sits there and spins until it eventually times out.   What am I doing wrong?  I haven’t used FME in about 7 years or so, but I used it extensively prior to that and never had this sort of issue.

Hi,when writing using a dynamic Excel Writer (in my case there are no columns defined at design time - see attached screenshot), the font settings get lost in the output file and also in the Feature Type Writer itselfs when I double-check it.Has anyone solved this issue?Thanks! 

 Hello Forum, I’ve set up a simple workspace to convert a csv with eastings and northings (EPSG:27700) to a csv with long lat (EPSG:4326). This is working OK. The workspace is something I’m going to use quite often, so I’m keen to automate it as much as possible. Is it possible to automatically make the ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) the same as the input csv name. For example, if my input csv is called ‘Properties030225.csv’, then when this reaches the FeatureWriter the default ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) is ‘Reprojected’. Instead, I would want that default csv file name to be the name of the input .csv. In this case, Properties030225.csv. Yes, of course, I could type in Properties030225.csv in, but I don’t want to do that every time. Instead, I want it to automatically pick up on the input file name. How can I do this? Thanks,Stuart