FME Form

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 vie

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. 

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

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=

Hi, Is there a way to set the font of a text in a DGN file by using the font name?With the DGNStyler you can only set the font by the font number. In this post, https://community.safe.com/s/article/microstation-text-styles-in-fme , there's a workflow described. Basically, in microstation you add a text object for every desired font in the seedfile. In this way, a font number for each desired font is stored in the seedfile. Next, you read this seedfile with FME, to inspect all igds_font values. Still, there is no "igds_font_name" kind of attribute. So you should use the font name as the text value in the seedfile, I think. Once you extracted this mapping (font name <> font number), you remove all these text objects again from the seedfile. But f

We're deploying our FME Server 2021.0.3 (21326) on Kubernetes using Docker containers and would like to properly set up FME_SERVER_HOST environment variable which is now set up simply to "localhost" value for every job. I tried to change FMESERVERHOSTNAME environment variable under core and web containers to proper hostname and restarted FME Server, but this led to that core container couldn't connect to the web container - trying to update its services as log said. Probably container couldn't connect by other hostname than "localhost".fmeserver-core container logs when FMESERVERHOSTNAME changed to other than localhost:Update Services: Trying to update FME Server services...  Is it possible to adjust FME_SERVER_HOST environment variable on FME Server 2021.0.3? Do you have any suggestions? YAML from Kubernetes with environment variables set up for my core and web containe

Hi,  Very new to using FME but I've been following the tutorials on How to make Minecraft worlds. I'm using the same workspace as the Moai statues with my own data subbed in, but when I convert my elevation model I get an error saying there are negative z values. When I check the DEM itself there are no negatives so I don't understand where the issue is coming from. It is roughly 4sqkm with a max height of 30m as well so it should be well within the appropriate size. Thanks

Hei I am trying to convert a kml file into a geodatabase, because the kml file has attached pictures that were taken. If I do it via arcgis software I don't get the information, just the points. Via FME I can get the points, the information about the points, and that existes some jpg files attached to the points, but not the jpg files. Shapefiles don't allow to attach files into, but geodatabase allows that. Someone with experience on that?In attachment you can find an example to teste. Thank you in advance,Artur

I have used the quick transformer to convert Revit file to IFC format. The log message said the features were converted successfully but when I open the output, no features was found.

After the dynamic writer is done i need to update some column for each feature type being written.Something along the lines with (its not the actual SQL, this one is simplified for demonstration )   update public.$(feature_type_name) -- This is table nameset area = ST_area(geom)I want that to be run as    update public.parkset area = ST_area(geom)But fme_feature_type is not available. Can i do this without hardcoding the feature types names?

We are having two csv files, which are having address fields. We are trying to match the attributes column by column from two tables by using a feature joiner in the custom transformer's loop iterateWe are unable to iterate the list value in feature joiner, we are using feature joiner as below. Please help me with how to iterate the left attribute _list{0} to the next value.Thanks in advance for your help on this.

I am using a spatial filter to test if a candidate polygon is within the base polygon. The settings for the spatial filter are as follows:Filter Type - Single FilterPass Criteria - Pass against one filterSupport Mode - Support aggregatesSpatial Predicates to test - Contains CandidateUse bounding box - noCurve boundary rule - default For some reason it keeps failing and I'm not sure why. I've attached a sample of the data.