General

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?

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 containers:spec:      containers:#fmeserver-core:21326        - env:            - name: PRIMARY_PROCESS              value: c

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.

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 for the Hub but I can't seem to get the

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 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

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?

Hello there using the parameter $(WORKSPACE_NAME) to get the workspace name not working if the works[ace is saved as template, we get a different name as an example the workspace saved as a template with the name ( cad_to_gis.fmwtwhen use the parameter $(WORKSPACE_NAME) we get getting this name ( wb-late-1653463418287_7640)Any idea Please Thanks

I recently had my SMTP Gmail subscription start failing over the weekend and had been wracking my brain on how to solve this and found a difference in SMTP Server Settings that Google recommends vs what is on the template. Google recommends using smtp-relay.gmail.com. The template is still using smtp.gmail.com and is failing on the connection.  This may have been fixed in a more updated version of FME Server.  Thanks 

Dear community, I need to read a txt file who have empty column names like that :How can I manage my reader for having all columns ?Thanks for your help.

ID | Mile 0 6.5 1 6.42 6.43 6.4 4 9.25 12.8etc For every object which has a Mile number that occurs more then once I need to add a number to the Mile number. So for example, ID 1 would be Mile 6.4-1, ID 2 would be Mile 6.4-2 and so on. Now I have done this using Python but I'm sure this can be done with FME also. Can anyone give me some advice? Much appreciated.

Hi, I have installed FME desktop and server, my organization has a license server that i was able to define for the desktop client, but, i am unsure how to configure the FME server instance to that license server?  Is it not meant to work that way? Thanks, Jared

Hello,I'd like to use feature attribute in another function. something likeclass FeatureProcessor:  def __init__(self):    pass  def input(self, feature):    col1 = feature.getAttribute('col1')    col2 = feature.getAttribute('col2')    self.pyoutput(feature)  def close(self):    passdef myFunction(col1,col2) another code etc.  I do not know how I can get attributes col1 and col2 to use it in another function.. (first time using python caller) .. thanks for help.

This is how I get after entering the portal in which my fme server is running.There is a 401 error initially in the console and then also 503 and 500 

Hello, I have a wms that I'm clipping with a polygon bounding geometry. It work but the problem is that FME don't refresh the maps to the level of zooming of my bounding geometry. So It cut the whole planisphere and I have only one giant pixel as result of clipping ... how can I do to have a a detailed map ? Here is url if you want to test : http://ows.terrestris.de/osm/service

When writing data to a zip shp. file often the data doesnt comply with the 3 decimal points put down in the CoordinateRounder. It usually ends in a couple decimals and then ending on 00001. In the AttributeRounder description it states that this is an issue that can occur: The CoordinateRounder may not always behave as expected, due to known limitations in floating-point computing. I am looking for a way to always make coordinates end on 3 decimals. The data comes from an Oracle Spatial reader, which after some transformers, goes through a Generalizer and then a CoordinateRounder before writing the data as a zip shp. Hopefully anyone here can help me out?

Hi I need some help with parsing the json response from the rest server api /transformations/jobs/completed with parameter competedState: failed What I want is a complete table with all attributes except TMI and NMI Directives. From PublishedParameters I only need subsorter and its corresponding value. This is a problem I cant solve. As it is now I can get subsorter and its value but no other attributes like "timeStarted". It would be great if it was possible to parse the whole json file and get a nice table with only 1 fragmenter. I attached a workspace where the json code is embedded as an attribute. Thanks in advance if someone could point me in the right direction. 

Hi! I'm trying to download a .zip-file using HTTPCaller. The zip-file is accessed via API by an order number generated when I placed the order for the data.  The response body looks like this: [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/anlaggningsomrade_kn0125.zip?q=_9yzl22V_4v728pM........"}] (shortened down, was way to long to post here).  The 'anlaggningsomrade_kn0125.zip' is what I'm after. Is this possible? Any help is much appreciated 🙂   

Having recently disabled older SSL & TLS versions on our servers, fme desktop/server sql connections have broken. The workaround for other applications was installing OLE DB v19. I've tested this using a blank .udl file and confirmed it works creating a db connection with v19 but not the other. How do i get fme desktop/server to recognize this new version? As the error still suggests its using the basic oledb driver. The connection string fme complains about i think should have'provider' set to MSOLEDBSQL19 instead of just MSOLEDBSQL Any suggestions are appreciated! 🙂

Hi,I have a question regarding the AreaGapAndOverlapCleaner and I dont know how to solve my problem...I have multiple polygon layer which I want to overlay. The lines of the polygons are not totally coincident as different data sources are used. Many sliver polygons are created when the layers are overlayed. I would like to remove these small sliver polygons with the AreaGapAndOverlap Cleaner (it does it job well - I used a tolerance of 1 m). My only problem is, that the AreaGapAndOverlapCleaner itself creates some little gaps between the polygons. Is there a way to prevent the transformer from doing it? Using Fill All Gaps does not make sense in this case, as there are some big gaps (exclaves) that I want to keep. Do you have any idea to prevent the AreaGapAndOverlapCleaner from creating gaps? Or is there any other transformer which suits better?Thank you!

Hi !I have an xls file with 2 columns. One contains a code and the other contains numerics values. I would like to create an attribute that group my data when there are a break on the values and group by code. For example : code valuea 1 => group 1a 2 => group 1a 3 => group 1a 10 => group 2a 11 => group 2b 1 => group 3b 2 => group 3 I saw "AttributeRangeMapper" but I have to indicate the bounds. In my case I would like that the bounds are create automatically because my datas change every time.My values can be integer or decimal. Thanks ! 

Workbenchs/ Connection String work fine on existing server. Moved them over to a new server and get: ArcGIS Desktop 10.8.1 and Background georproccessing 64 installed, TNSNAMES is fine, can ping to oracle server.  822022-5-13 12:41:01 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}832022-5-13 12:41:01 | Please ensure the connection parameters are correct (server=`sde', instance=`sde:oracle$sde:oracle11g:ocspub', user=`encdirect', password=`***', database=`', version=`SDE.DEFAULT') Edit: added SDEHOME Variable C:\\Program Files (x86)\\ArcGIS\\Desktop10.8\\bin Still no good  FME Server 2021.2.5Build 21816 - win64