FME Form

Before implementing SSO across our services where we are using FME, I wanted to get some clarification on how SSO would work with a HTTPCaller. While this is configured in the workbench on desktop, I understand that it will use the windows user to authenticate any request. However, how does this authentication work once a workbench is published to FME Server? If we invoke a workbench through a webhook that runs Server Automation, how would the FME server know the identity to authenticate against? Has anyone encountered this before? If so, was there some way of passing a token through the webhook call that would provide identification for the HTTPcaller?Appreciate any thoughts.

What R Packages and Python Libraries are available on FMECloud?

I am trying to write ifc file with IfcReinforcingBar but FME can't write all the reinforcingbars. Does anyone know to work with IfcReinforcingBar in FME?

Hi FME'ers,After a couple of weeks' absence, it's time for What's Up Wednesday. As you can imagine, I have a LOT of content to share this week! Sometimes it's too big to post to an FME forum, so find WUW on LinkedIn to get the full content. FME Hub UpdatesIt's the start of a new month, which means the Hub now has a list of items added during May 2022. This list includes the Unfolded format reader and writer, for which you'll need FME 2022. I've got two new transformers there: a GeographicCenterOfGravityAccumulator, which I created for use in an upcoming webinar, and a SoundexCalculator, because I found the Soundex function in the InlineQuerier doesn't work (oops).  There are other great transformers and tools to check out, but I really wanted to give a mention to Bruce Harold of Esri, who "decided to cut out the middle man" and add some interesting ArcGIS-related transformers to the Hub; like the EsriSimpleModalTripRouter. This transformer

I have created a workspace having AzureQueueStorageConnector, which should listen to an Azure queue continuously.I am able to run it as a Job as well and create a stream as well dedicated to this workspace. I have also checked this article about the streams:https://docs.safe.com/fme/2021.0/html/FME_Server_Documentation/WebUI/Streams.htm I was wondering, what are the differences between these 2 types of running a workspace i.e.Running a stream type of workspace with normal execution flow. (from workspace run button) OR Running it as a dedicated Stream (by creating a Stream dedicated to this workspace).  I observed both of the methods listen to the queue continuously and process till the time it is running. Few of the differences I was able to find are:Streams are capable of restarting themselves, regardless of whether the job was completed successfully, failed, or the server crashed or was shut down. But normal Job executions are not capable of doing this by their own.Streams need dedic

Hello I have a problem, the project was created in version 2019 and has not been used since, today I launched this project in version 2021 and found that Disslover does not work the same as in version 2019. Has anyone encountered a similar problem and if so how to solve it? log errors 2021-05-28 23:16:39| 11.7| 0.0|FATAL |Internal error running translation2021-05-28 23:16:39| 11.7| 0.0|FATAL |Expression: start != end2021-05-28 23:16:39| 11.7| 0.0|FATAL |Unknown internal topology error. This can be caused by self-intersecting input or numerical precision issues in arc processing

I have a feature reader set up so that the user selects a table and whatever table of the 8 possibilities is chosen it should write out to that table. It is reading from a file geodatabase and writing to a SDE geodatabase. There is a schemaMapper transformer for each table. How do I set up the featureReader so that once the user selects a table it will only write to that table?

 I am able to connect to AWS S3 in the Automation connection I have set up in FME Server. The FME Server Log shows the error to be with the Python module 'fmepy_amazons3' not being found when it is trying to connect to S3 in the readI have tried setting the python interpreter for the workspace to Python 3.7 and republishing, rerunningI have tried restarting the FME Engines Thank you for any insight or troubleshooting steps you have to offer! I have a support case started but wanted to also reach out to the community. 

I have read multiple questions\\answers\\commentaries around this topic and I may be more confused than before.Here is the scenario:I have an excel workbookThe sheet names are always the sameSome of the columns are static Some of the column names change-- and sometimes there are more or less columnsI need to capture the column names and row values then process the infoThe only way I have seen to update columns is to manually refresh the reader with 'Update Feature Types'Is there a way to dynamically read in new or changed excel column names without manual intervention? FME 2021.2Thanks!

I get this Error: ArcGIS Online Feature Service Writer: The geometry type of feature type '[LAYER]' is 'arcgisonline_point', but the geometry type of the corresponding layer/table on the Feature Service is 'arcgisonline_multipoint' I previously used ArcGISOnlineConnector to upload -> Publish a ziped shape-file to a feature layer. But when i later want to update the feature layer with the same shape i get this error.  Anyone know how to fix this?

I've been searching everywhere and coming up empty. I'm loading data from a SQL Server database that users can use to store images as well. The image is stored in a field called "photo" and it is stored in base64.  You can see an example of the base64 data that's being stored in the field (attached). Using online tools and copy pasting the contents of this base64 data does render a png image, however, I cannot get FME to convert it into something that I can export to a folder or even store as a regular raster in the table. Wondering if anyone can provide some clarification. Every base64 image starts with the following: data:image/png;base64,I tried trimming that bit and taking just the encoding and running it through a text decoder. In the "character encoding for binary data" I chose "Binary (fme-binary)". Then i used an attributefilewriter to write the data into a folder. However, the resulting images cannot be opened using any image viewer.Any help on this matter would be appreciated

maybe if you have the correct schema for xml validation, can you share it with me ?. Because I don't understand how to validate the xml citygml schema in fme Best Regards

I don't really want the user to have to download a text file containing the information, then have to open it to find out the answer. I'm hoping to be able to present this to them via the apps webpage but I can't find out how to do this. Is it possible? Do I need to do something with the HTML writers? Thanks,Dave

Hello,I have a 3D line, the z value is varying along the line.I want to create a solid which is 0.1m above the line and has a height of 8.Its length shall be 9m and its width shall be the same as the line.I also have point cloud dataset. The goal is to keep only the points which are inside the solid.The image shall give you a better idea.Btw the coordinate system is in meters.Thanks for your help.

Hello,  I'd like to create an attribute and name it from the value of an user parameter.  I've seen that in the "input attribute" field it is possible to choose the user parameter (as seen in screenshot bellow) But then the output attribute does not react as expect. Whereas it should return the value of the user parameter, it returns the value $(annee) as attribute name. Is there any way to overpass this ? Regards,Andy METAYER 

Hello, I am using FME 2022.0 Build22337 (Oracle Edition). Every time I try to update the Oracle Feature Type Writer (Update Feature Types), FME now crashes without warning. Am I the only one who noticed this behavior?

A workspace runner have 100 or more files. Some files have errors. How to save files with errors separately into another folder from workspace runner?

I'm trying to convert ArcSDE to DWG file. I use a DWG file as a template. In doing so, I have a column as autocad_layer and autocad_block_name. instead of autocad_layer being used as layer name in my result, autocad_block_name is used. For example, instead of just creating a layer called Wasser_hydranten here, layers (Endhydrant, Ueberflurhydrant_neben_Rohr, Ueberflurhydrant_trennend, . . .) were created.autocad_layer was also selected as the name of layer in Writer. autocad_block_name only gets symbol and is not written as a layer in the result.

Hello there how could we change the bounding box size as shown bellow keeping the reduced size in the same place Thans  

Anyone have any ideas on how to format XLS to repeat stacked records in groups of four (see attached screenshot). Each group of four is one record in a database, but want to format it with the name and address on top of each other. And the parcel number/zoning. All of the header info will be part of the template.  Is this possible, or will we just have to write it out linear, then do some excel magic afterward to get it into the format we want? Thanks.

I would like to remove duplicate features based on geometry. It's a dynamic workbench where i query out all tables which intersect with a polygon.  The problem is that our database contains some duplicated features. For example 1 layer for the whole country, and 1 where it's only a small part of it. So i just want one of these.  I have tried to use this guide. But the problem is that the geometry is not 100% alike. So the CRCCalculator gives different values. The coordinates are more exact in one of them.Any tip on how i could fix this? Here is an example of how the difference is for the same point:  

Is it possible to use WITH RECURSIVE in InlineQuerier? It is not working for me. Thanks for your help!

I'm trying to delete a folder from FME Data folder using the following workspace:  Then I try to run the workspace from server:  First, the folder is not deleted though there is no error thrown.Secondly, I got a warning for SSL certificate.2022-5-24 08:50:20 | alim3263 FME Server - DES: SSL certificate verification failed for host 'xxxxxx.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='xxxxxx.com', port=443): Max retries exceeded with url: /fmerest/v3/resources/connections/Z:/fmeserverdata/resources/data/source/RVT/folder (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1125)'))) Can you advise please?

I would like to extract exterior box of my ifc file and remove all interior element and i didn't find the right transformers to do this.

Hi, I have successfully used APIs for simple HTTP GET requests. However, at the moment I am trying to download a table (or the whole site) from https://st.hwmonline.com/DG/Secure/SitesList.aspx where monitor sensor information (name, id, address) is stored. The problem is that when I call that URL (together with authentication headers) only the first 50 sites are shown. There are however thousands which I need access to. Entering the site via browser, there is a button 'show all sites' below the table which I need to somehow pass into my HTTP caller.  This is an excerpt of the source code that refers to said button. When trying to put "dropMessagesNumber=0" into the header nothing happens: <select name="ctl00$ContentPlaceHolder1$siteListInfo$dropMessagesNumber" onchange="javascript:setTimeout('__doPostBack(\\'ctl00$ContentPlaceHolder1$siteListInfo$dropMessagesNumber\\',\\'\\')', 0)" id="dropMessagesNumber" style