FME Form

HiIs it possible to connect fme to a Microsoft Fabric Lakehouse? And read data?I use fme 2022.2 

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 will share any updates I get.You can still leave a comment below to let us know what functionality you would miss by the gallery being removed.Thanks for your feedback.Mark

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:/TEMP/SHP/VWG_POLGEM_OBERGRAFENDORF.shp'print("Clip Features gelesen !")# Destoutput_shapefile = 'D:/TEMP/_TEMP/VWG_POLGEM_OBERGRAFENDORF.shp'print("Ausgabepfad festgelegt !")# Functionclip_sh

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 

I want to give file path to load multiple CSV file to SQL server, How to give file path to reader to select multiple CSV file?  

​Hello guys, Damjan here,i have problems with my FME process so i need your help.  Task:I have 1 dwg file with 6 polylines (3 pairs), each pair must go to PROCES (process makes a polyline between 1 pair, that's fine all works), then process must save this polyline in dwg and go to start for next pair.Shema: FME:DWG GRT: Each polyline has an attribute id which represent pairs (for example: 2 polylines (grt_dt & grt_lt) have the same id which means they are 1 pair), the second attribute is Description (DET_OPIS): grt_dt = right polyline, grt_lt = left polyline.  I add Creator to make counter, with the Attribute manager making the same attribute like in dwg (GRT), and then connect to tester. My idea is that the tester test if value of counter equals to id. If its true, then go to process, when process finish, save to dwg format and then go to start for next pair.  Problem:I have problem in tester cause i dont know how to setup tester to make him work. If anyone know how to fix that or

Hello,I need to write the xlink:type in an AIXM5 file (see below)  But when I look at the User Attributes of the feature type AirspaceTimeSlice (AIXM5 writer), I can only see 3 parameters of the xlink which can be set: href, role and title.  Anybody knows how to write the xlink:type with the AIXM5 writer ?ThanksAndré

Hi All,I need to concatenate the two values of the same cell into just one line. I’ve been (partially) able to do it by using a StringReplacer but some of the cells show an space which make the StringReplacer not working, see below an example:There’s an space between line 2 and Siding, how can I make the final result ‘CE Siding’ ?  

Hello enthusiasts, I am trying to migrate a bulk data (assume 2Million records) to an oracle table due to size  planning to split and sent them by batches. In this situation I have a certain doubts which are below, if a data already migrated to the oracle table, but next batch also have that record means oracle will through the “unique id constraint” error. how can I skip that record and move next one? Due to size of the data, i am splitting them into different batches and try to run parallel. FYI: I am migrating data into one same oracle table using oracle writer. can i run multiple workbenches (like insert1.fmw and insert2.fmw) parallelly and is it works fine or will be chances to loss data in this scenario ?WRITER using: oracle spatial object expecting your thoughts and suggestions.Thanks in advance !

I want to compare different methods of generating TIN-models. To assess the quality of each model, I want to calculate the vertical distance between each point in the input point cloud and the generated TIN in order to later calculate for example the RMSE. Any tips on an approach?

I am using FTPCaller. If I add the Emailer to the rejected port will it send me an email if the output gets kicked to the rejected port? I would have the Emailer already configured to send me an email. I want to double check with the Community since my workbench will stop running if the FTPCaller output is rejected. Here is a screenshot of a mock up workspace (note I have not set up the transformer parameters yet hence you see the red gear icons.) Not shown below, I know it will send me an email if the FTPCaller output is sent to Output.  

I want to write lines into an existing PostGIS table, which has default values for most of the columns. With FME PostGIS Writer, when executing the process, I have errors returning (in french):Bulk copy failed on table 'XXX' using delimiter ':'. Error was 'ERREUR:  une valeur NULL viole la contrainte NOT NULL de la colonne « YYY» dans la relation « XXX » I would like to use the Postgres default values for these NOT NULL columns, but I cannot find the way to do it.I use FME Form 2023.2

I'm trying to read a (big?) ecw file (EPSG 28992, 173 Mb) using FME 2020.1.0.1.This is very slow (> 10 minutes), QGIS displays the same file in a matter of seconds. I'm wondering if I'm missing some reader parameters that might speed up the process. I do need best resolution though...

Hi FME community,I’ve been tasked with trying to get the metadata we hold (in a SQL server database) into an INSPIRE-compliant format.I was hoping that we could use the metadata we currently hold (Title, Abstract, Temporal Extents etc) and run it through an INSPIRE XSD template. However, it’s pretty overwhelming when I look at the XSD templates (which I got from here - application-schemas/schemas at main · INSPIRE-MIF/application-schemas · GitHub) as there are so many nested parts (see screenshot). Is there a relatively straightforward method I could use for each topic of data (be they addresses, parcels of land etc - which have their own topic under the INSPIRE framework) which could be joined in FME and output an XML file which can be imported to the data in ArcPro? It seems a bit convoluted but I’m just trying to get an idea of where to go from here with a large shift in metadata storage and how we will be using it at my organisation going forward. Thanks

Dear all, I’m fairly new to FME but currently I’m quite impressed by the software :). My question is rather simple: is there an equivalent in FME of the Tabulate Areas function of ArcGIS Pro: Tabulate Area (Spatial Analyst)—ArcGIS Pro | DocumentationI have two datasets:The cadastral parcels of Wallonia in polygon format ; A land cover classification (TIFF raster) with 20+ classes.I would like to calculate for each polygonal entity the proportion of land cover classes.The result should look like this:ID | LC1 | LC2 | LC3 | … | LC201 | 10% | 0 | 0 |25 | … | 02 | …3 | … Many thanks in advance for your feedback :)

When I simply add the PDF reader and convert to the TIFF writer, alle Images are exported separately into rows, meaning that for each individual PDF-File I get 100+ TIFFs. How can convert PDF to TIFF without this happening?