FME Form

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 

HiAttached is workspace what wrong with it, as I can't write the output in to feature class inside esri gdb. 

How to convert the neatest distances in neighbour finder to individual lines?

Hello,Is it possible to transform a table (ie from Postgresql, or Excel) into this complicated Json format within FME please? I have attached the json file and also a small dummy sample excel file (which doesnt quite have the correct column headers as its a work in progress).I am completely new to JSON and I have done the JSON Templater tutorial but no idea how to actually apply it to my needs!!Help wanted!!

Hi,I am having trouble reading the names of the groups with which the layer is shared in Esri Enterprise. I am using an HTTPCaller with the following settings, but the Share info does not appear in the JSON response.The only information I get is:   "access": "shared". Could you please advise on how to retrieve this information?

Hi  Please advice on the best option(s) for data store that FME can read and write to, also one that Power Bi will be able to read and connect to.The data to be handled has no geospatial element to it. Thanks

Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14|  2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an

Hello All,I’m having an issue where SchemaMapper prefix whitespace (space) when using fmeexpression=.I attached a sample workspace and would appreciate if anyone could test before submitting ticket. This issue came apparent after upgrading to FME 2023. for example: col0=’2’, col1=’3’-->using “fmeexpression=@Evaluate(@Value(col0)+@Value(col1))” returns value “ 5” or “fmeexpression=@Evaluate(@Value(col0)@Value(col1))” returns value “ 23”Previously, using “@Evaluate([return “@Value(col0)@Value(col1)])” returns value “23”. I know 2023 introduced new functionality to SchemaMapper, per transformer help doc and https://support.safe.com/hc/en-us/articles/25407523665165-SchemaMapper-Advanced-Schema-Mapping.  Would appreciated if someone could test before submitting ticket. Output SchemaMapperDoc 

Hello! I am having some trouble overwriting a hosted feature layer on ArcGIS Online that is public and has editing disabled. I have a geojson file that is updated fairly regularly and I would like to create a workflow that reads the geojson and writes it to an AGOL feature service. I have that initial-publish workflow down, but after I log onto AGOL and change the feature service to public (sharing) and disable editing, subsequent runs of my FME tool fail and produce an error stating,  "Feature Service 'xxx_layer' does not support writer mode ''. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator". That error makes sense since I've disabled editing to the feature service, but I'm wondering if there is a way for FME to overwrite the feature service without me having to enable edits on the AGOL feature service. Because the data is public facing, I cannot allow edits to be enabl

Hi All,I’m using the JSONTemplater and I am getting the following errors from FME when it parses the root template:JSONTemplater (XMLTemplaterFactory): The following error occurred near line 81, column 59 of the query:JSONTemplater (XMLTemplaterFactory): "fme.get-attribute": function with arity 1 not declaredIn the root template, I have the following starting on line 80:    "Subfeature1Array": [    fme:process-features("Subfeature-First", "xxxNumber", fme.get-attribute("xxxNumber"))    ],    "Subfeature2Array": [    fme:process-features("SecondFt", "xxxNumber", fme.get-attribute("xxxNumber"))    ],    "Subfeature3Array": [    fme:process-features("ThirdFeat", "xxxNumber", fme.get-attribute("xxxNumber"))    ]Both the root features and the sub-features have an xxxNumber attribute.  I am following what is documented in the Help for the JSONTemplater “Selecting the Sub-Features to Process” section example but have no clue what the issue is. Any help would be greatly appreciated!

Hello Community,I have data in the following format:Attribute value field1 a field2 b field3 c field1 e field2 f field3 g field1 j field2 k field3 l Which transformer can I use to transpose my data into this format? field1 field2 field3 a b c e f g j k l  The names field1, field2, and field3 can be dynamic, and their number may also vary

I am using a WorkspaceRunner so that I can run multiple times the same FME workbench on different DNG separately. Just to be clear I will call the WorkspaceRunner to the workbench that runs the “child” workbench, and i will just call Workbench to the child workbench. I was all working fine the first times and now I find that some User Parameter (in my case “DNG”) I was “sending” from the WorkspaceRunner to the Workbench is not working anymore (I didn’t change the parameter in the WorkspaceRunner but maybe i used it in more places inside my Workbench). When I run it directly inside my Workbench it makes no problem. But when I run it from the workspacerunner the following error appears:  ERROR : Undefined macro `DGN' dereferenced in file `G:\Buzon\Miguel\CQ_topologia_copia\wb-xlate-1738321227449_8672'I think the wb-xlate is a temporary file of some sort. I have a wb-xlate in the root of the project but not the name does not match the one appearing here. That wb-xlate actually contains th

I have about 500,000 building footprints that are collected to varying degrees of accuracy. I would like to true these footprints so the corners are either 45 or 90 degrees on the polygons as depicted below. Is there a means to do this using FME desktop? The corners are typically within +/- 5 to 10 ground units of being true.  Before:After:

Hello Everyone,I am trying to use RCaller in FME 2024.1.3.0 with R version 4.3.3.To get started, I followed the tutorials, but in every case, the script gets stuck at RCaller. There are no errors or warnings—it simply does nothing and keeps running indefinitely.The last thing I see is: It seems that the connection to R.exe is working.Does anyone know what beginner mistake I might be making?  

Hi everyone,I have a question about the Reprojector. In the reprojector in FME Form, my desired coordintion systems are available:  But when I publish it to FME Flow, some of the coordinate systems are not available to select from: Could you please help me to solve the problem? Thanks!

Hi all,FME supports writing to USD file, but there is no option in the reader for USD.  How would I go about reading a USD file in FME? Thanks,Michael