FME Form

Hi, I have this problem on FME qnd I don’t know how to fix it : Microsoft Excel Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DictionnaireVariables_ITV.xls;Extended Properties="Excel 8.0;IMEX=1;HDR=YES"'. Provider error `(-2147467259) Erreur non sp\xE9cifi\xE9e'Can you help me please ?

Hello,I have two polygon datasets: folios and townlands(see image below). For the most part, the folios(grey outline) are nested neatly within the townlands dataset(red outline) so the outer folio boundaries are shared with the townlands’ boundaries. I would like to extract the areas where these two datasets’ polygon boundaries cross...i.e. where they are not nested neatly. Most of these will be slivers.  SpatialRelator(and Tester) helps to extract the offending folios using the Spatial Predicates Test: "Requestor OGC-Overlaps Supplier" however the output is the entire folio polygons(not overlapping area) as SpatialRelator does not edit the input dataset. I am unsure as to what to do next, I would like to automate this process in FME Server if possible so having one workflow would be useful. 

I’m doing a project where I have to generate and compare multiple DTM TIN-models. In regards to this, I wonder: Is there a difference between TINGenerator and Surfacemodeller in regards to how the triangulation algorithms work?How does the triangulation algorithm(s) work, in more depth than that it is delaunay triangulation?​​​​​​​Are there any other transformers/methods to produce TINs in FME?

I would like to identify snapping errors of newly captured layers which is snapped to old layers only.I do not want to find any old layer's errors as it is not my scope of work.Please suggest the best transformer. RegardsArun

Hi!I have many workbenchs to manage and I would like to find a way to create a table linking the workbench name with the output writers of each workbench. The goal is to find which workbench generates which table(s). My idea is to add a custom transformer to all my workbench. The information I would like to have is :name of the workbench directory of the workbench writer information (table name, table qualifier and writer)With ParameterFetcher, more specifically, the FME_MF_DIR and FME_MF_NAME parameters, I can get the information about the the name of the workbench and directory. But I cannot find a way to extract the information of the writers. All the writers I have are in a postgis format.I would prefer not to use Python if possible. I’m sure there’s a way to extract the information since it appears in the log, I just don’t know how to get to it! Thank you 😀 !

"Hello, I have a folder containing multiple shapefiles, labeled as (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after everh iteration, so i can't get a configuration of the loop.  I appreciate any assistance or proposition you can provide. Thank you."

Hello everyone,I have a colleague that uses FME Form 2023 in combination with the FME auto plugin (MApublisher)In previous versions he had nog problems using the FME auto plugin, however in FME Form 2023 he gets the following error:In  the previous versions one was able to succesfully extend the Avenza MAPublisher for Illustrator via the Integration console, however in read in a post that the Integration Console is deprecated :  https://support.safe.com/s/article/FME-Integration-Console-DeprecationI was wondering wheth

Dears, If i have Revit Model that has multiple Locations and we need to separate each Location to single Revit file .Is it possible using FME?? Thanks in advance

Hello all,When trying to write my data as a geopackage I get the following warnings (see attached).In the reader I have to specify what geometry type I want to use but I can only select one, which results in some features being excluded.I have read a thing about the dynamic writer but that one is giving me errors.Using the GeometryFilter the only type I get is ‘area’ so it doesn't seem to make a distinction between those.Is there a way to write these different geometry types in one Geopackage layer? I am using version 2020.0 

We are getting an error while running FFS writer: Failed to write to file 'C:\\Users\\use\\AppData\\Local\\Temp "Please ensure that you have sufficient privileges to write this file, and that sufficient disk space is available" This should be a simple merging of .SHP file (3221) into a single FeatureClass in a GDB. The Reader set to read .shp in Single Merged Feature Type. Got a GeometryValidator set to degenerate or Corrupt geometry "Edit". A Tester to get the read shapes and then the GDB Writer. We have and checked that the user is admin on the box and folders, so Think the issue room for the temp file. this is running on a Server where c:\\ only has OS on it and not much space left after that. So can we run in a way that clears the Temp location after so many record run, or can we move the Temp to a larger drive??

Hello, I am trying to convert an shapefile in IFC format, never did before.What I did is to connect the reader for shp format to a writer for IFC format but the result is empty.Please, can you explain me the setting to use or the procedure to perform this conversion?Thanks

Hi,Have a workbench that I have been using for a while in previous version (2023).This is to convert data with attachments from ArcGIS online to a FGDB.I use a ListExploder for this, I don't get an error message but also no objects.When I use the workbench again in the old version, everything works fine again.The problem occurs when a space is used in the naming of the layer and/or feature class. Does anyone know about this problem? Any solution would be helpful. Gerard

I've two types of cell features in my data with same name, only difference is that the origin of the features, as shown in the picture one type having the origin at the right bottom and other has it at the left bottom, how to identify those. expecting some suggestion 

Hi FME community,Just wanting to ask has anyone had success using a HTTP Caller or a connector to obtain data from Konect  server? Cheers.

Hello everyone,I am converting several SDE geod to respective CAD files. All CADs need to be written in the same folder (with suffix of the currentdate). I  created this folder in Python Caller. How can I now route CADs to this folder?

FME friends,As you know, the Transformer Gallery in FME Workbench is the window that exists in the lower left hand corner of Workbench, and gives you access to transformers.However, now that most people are using Quick Add instead, we are considering removing the Transformer Gallery from Workbench completely.Obviously, with a big change like this, we want to first get your feedback on how this might affect you.So please:Visit this page to find out more information and to cast a vote in our poll of users. Add your comments to the thread below (but do check out the other page first).I closed the poll. The results are 66% to remove the gallery, 33% to keep it. I’ll let you know what the product managers decide and wil

Hy there !I’m using FME 2022.2 and ArcGISpro 3.1.1, Python Compatibility is set to Esri ArcGIS Python 3.6+I want to test arcpy in FME with the following script, it works but throws this error:Python Exception <TypeError>: clip_shapefile() missing 2 required positional arguments: 'clip_features' and 'output_shapefile' Clip works well and the shapefile is valid, but the pythoncaller ends up with this error.The Script:import fmeimport fmeobjectsimport arcpyimport os# Overwritearcpy.env.overwriteOutput = True# Functiondef clip_shapefile(input_shapefile, clip_features, output_shapefile):    arcpy.Clip_analysis(input_shapefile, clip_features, output_shapefile)    return output_shapefile# Sourceinput_shapefile = 'D:/TEMP/SHP/VWG_KAT_GEM.shp'print("Quelle gelesen !")#Clip Featuresclip_features = 'D:/

Hi there, I am getting an Error on Windows Server FME 2021.2.5  when add Reader FGDB and tried to open Tables. (Geodatabase Error (-2147024894) Please see the attached image for more details.I have used FGDBs many times using FME, Windows Server Patches installed by the IT Department recently and it seems since then I am having this issue on FMEI have tried on different servers, ie: Windows 2012 & Windows 2019 and FME on all servers have the same issue.I can drag and drop FGDBs on to the FME Workbench canvas without any issues. Could anyone help me to identify this issue and let me know how to resolve it?thanksRegards,Pushpa

Is there a way in Form to find out the active FME Flow Connection when running a workspace?I thought it might be a (hidden) parameter somewhere, but I can’t find it immediately, and it doesn’t seem to appear in the logs either.I was wondering if I could use it to determine which environment I’m working in, setting up a development parameter is an easy workaround but might be useful one day to know/log the active flow connection anyways

Hi FME Community, So I’ve created a basic FME Flow application using a script that simply lets you upload two excel files then generates a html report comparing the two. I’m wanting to improve this functionality where there's a dedicated library of files (.csv) from cloud drive (One Drive) as buttons or drop down selection menu. Requiring only to upload the comparison .csv file. Would I have to achieve this by writing a python or java script in a custom HTML in a HTML report generator?

We have a series of databases (postgis) that get _year_month added to their endings so that we can see which one is the newest. The rest of the name, schema etc is the same.It would be convenient to have our workspaces automatically look for the most recent database.So if there exists: supercooldatabase_21_09, supercooldatabase_23_07 and supercooldatabase_24_03 on the server I would like to have FME check all supercooldatabase’s and select the one with the higest number, aka _24_03. This attribute would then be passed on to guide FeatureReaders correctly.Would it possible to do this within FME?

Hi, I am using a sql executor reading dynamically some data from our db. I am using following query: select * from t_@Value(F_CLASS_NAME) where fid=@Value(FID). How can I expose the attributes of each query ? I can not use the attribute exposer of the sql executor as the attributes name and number change depending on the table name. I tried a few things but nothing has worked so far. I am reading about 10-40 tables so I want to avoid to manually type in all diff attribute names.

I'm converting an obj file to local coordinates, glb.Running one obj file in FME will take you to the desired local coordinates.But when I run thousands of obj files in FME, they don't move to local coordinates (0,0,0).I want to move thousands of obj files all to (0,0,0) at once.For reference, I activated move to local coordinate. 

Running into issues while running a workspacef_85 (HTTPFactory): [4]: HTTP transfer error: SSL connect errorf_85 (HTTPFactory): [4]: Please ensure that your network connection is properly set upf_85 (HTTPFactory): [4]: No proxy settings have been entered.  If you require a proxy to access external URLs, please ensure the appropriate information has been enteredf_85 (HTTPFactory): An error occurred while accessing the URL 'https://static.inaturalist.org/photos/355260564/medium.jpg'The below feature caused the translation to be terminated 

Hi, When I try to overwrite a layer in AGOL using the AGOL Feature Service Writer it creates a duplicate feature layer, with a different feature ID. I need to overwrite as there is a schema change in the data and i’m trying to avoid creating a new feature layer as we’ll have to re-configure the downstream map services.I ran the same workbench on a different environment and it had no issues overwriting the layer I was pointing at. Any ideas on how to get this to overwrite?I’ve attached a screenshot of the settings I'm using