FME Form

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.

The PDFPageFormatter transformers handels as follows when more than one feature enters the input port.  "If more than one feature enters the same input port, the scaling and centering will be calculated based on the aggregate bounds of the input features. The features will be written to the PDF in the order they entered the input port." I would like the oposit. Is it possible that the PDFPageFormatter recalculates the bounds of the input feature for each input feature?  My workflow:Reading multiple pdf's with different pdf sizes/ heights and widthsThen merging all those pdf files in a single pdf.  I would like that the output PDF contains all the read pdf's and keep the original pdf page sizes for each page. (Reading spatial pdf's as rasterized pdf layers is fine!) Thanks,Mark

Because of the frequent Tomcat upgrades, we're having to upgrade FME Server more frequently. When we do the upgrades we lose the apache default files fix: https://community.safe.com/s/article/FME-Server-Apache-Tomcat-Vulnerability-with-Default-Files Is it possible to either a) Include this fix in future releases FME Server or b) backup these files and the restore them when we do the backup and restore of the workbenches etc.

Hi all, I am trying to convert a CSV file generated from IoT censors to file GDB. The table got a geolocation field in which X and Y values were separated by comma. I wanted to get the data on LL-GDA94 projection. Although I was able to create a feature but it was not projected properly and appeared out of map extent in ArcGIS. Can anyone help me with the script that I have added here? I am attaching the CSV also. Thanks in advance.

Hi,I am trying to create From-To lines from every point in a shapefile to every other point. I have 45,989 points, so (in theory) each point should have 45,988 lines coming off and attaching to every other point. I have attempted to use both the FromToBuilder and the LineBuilder, but neither seem to work.Does anyone have any ideas that might work?Thanks

I'm making a custom transformer at the moment which I intend on putting onto the Hub at some stage soon. With my transformer there are two possible output streams. One adds certain attributes to the input, and the other makes a list instead of the attributes.  I would like this to go to the same output port but only expose the relevant attributes depending on which stream. I'm finding that if I have the transformer settings so that it makes a list attribute then the other attributes will still be listed, but as <missing>. I would like there not to be empty columns.  I can't seem to work out how to get into to only expose the attributes that exist and not just all possible ones from both streams. Changing the settings in the screenshot to the relevant selected attributes will look fine for one of the streams but not the other. As a side question, I have a <Rejected> output port. I'm trying to make the documentation

I have a workspace set up to terminate based on parameters that it has failed on. Is there any way for a message to come up as to why it failed that isn't in the log? Primarily for users running it that don't understand the log file and how to read through it so that they know why it failed?

I am bringing in an excel table and then adding some different attributes to it and writing it out to a geodatabase. I need to create a unique ID when writing it out to the geodatabase. I have brought in the original table and determined what the largest ID number is. I can't figure out though how to add it to the workspace without each row getting the same ID number.

Hi,I have a kml file that is created from a MapInfo Tab file that has 9 polygons, the polygons are all the one colour and will change to another colour if you hover over it. Now I want to remove the old outline colour and assign a different colour to each polygon using the Asset_Mgr_Region field to filter by, but still retain the highlight on hover. I am not sure where to place the Attribute Filter to achieve what I want, how do I use this? I have attached my workspace. Thanks

HI guys, I have a question. How can I generalize points in FME Desktop?I have like 10 points, each point is very clos to other and I want to make from them like less number of points like 3-4 maybe. I've tried with generalizer but it's not working, any suggestions?Screenshot below.TIA

Hi,I need to denormalize rows into repetitive numbered columns. Here's an example.Here is the normal version as it is in the relational db. Note that the three rows all have the same value in ID_DETAIL field.Here is the desired result. Note that for this one DETAIL, we end up with three groups of columns (ID_MENTION, MENTION, PRECISION).How would one do this in FME ?The number of repetitive groups of columns would be defined by the detail in the dataset having the most mentions (in my example it was 3).I was thinking of some kind of grouping on ID_DETAIL and some kind of "for-each-loop". But any better suggestion appreciated !

I have thousands of photos, under multiple sub folders, which i have been attempting to extract the photo date. I have used the jpeg reader together with option to search sub folders, however, none of the exif options allow me to append the original file details. I'm new to fme so it's probably something simple as if i pick a single file then the filepathextractor works a treat. 

I need help to figure out how to reorder the field "Shape". I tryed multiple things has these three options and also tryed to use the Attribute Menager transformer :But has soon as I play workspace, the "shape" field always appear at the end of the table. The problem is that it has to ben at the second place like on the image below.Thanks a lot in advance :) 

I am trying to view the DXF file using cesium, for now, I succeeded to convert the DXF (2D) file to MVT/GeoJson ( a format that can be viewed using the cesium), but the MVT does not contain style (colors, hatch, line type/width, dashed, font.... ), all the style of the DXF is missing, any suggestion/ideas to view the DXF including the style using the cesiumJS?