FME Form

Apologies if this is a dumb question! What I'm trying to do is build a dataset extraction tool for a third party in the organisation, but need to keep any login credentials secure.

My FME translation includes 2 different streams depending on the type of data provided in a zipped file GDB. So the first step before processing data is to test whether it contains a rater dataset/mosaic dataset or any number of feature classes. I don't want to read data yet, just check the data type of feature datasets. What's the best way to check that? Tried a generic schema reader but it doesn't provide an attribute with the format of feature types inside the file GDB.

Hi,For some time, I used the following approach to open a KML dataset (both in Desktop for development, and in Server for operational use, version 2020.1.0.1, both running on Windows (server) OS): Create a public parameter "INPUT_FOLDER"Create a public parameter "INPUT_FILE"Add a KML Reader for a specific KMl file to the workbench, which defaults to a public parameter "SourceDataset_OGCKML"Make this a private parameter, and change the definition to: "$(INPUT_FOLDER)\$(INPUT_FILE)" I then use either UNC or local paths in the INPUT_FOLDER to point the reader to the correct location. Last week, we started migrating to 2021.2.4, which I installed on my workstation (windows). For the sake of completeness I think I should mention we are targeting an FME server running in a docker container on a linux host. This approach stopped working, with the message :2022-03-19 14:58:52|

I would like to make a custom map for Power BI's Shape Map visualisation: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map When I make a TopoJSON with FME and open it in Power BI I see a completely filled square (basically the bounding box is filled). When I take the TopoJSON generated by FME and process it using the default paramaters of the online mapshaper tool (https://mapshaper.org/) by exporting as a TopoJSON the mapshaper TopoJSON file open's without a problem in Power BI.  When I compare the FME TopoJSON files to the mapshaper TopoJSON file using a text reader the only obvious difference that I see is that the parameters are in a different order, but the scale and trans

FME Desktop 2022 Build 22304: The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available, The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available in the Build 22304 that’s used to be in the Build 22257         Is this by design?

i would like to know : Does the data transmitted in encrypted form? https/TLSor which encryption form is using in FME Desktop ?please ,refer me to the documentation regarding to encryption form ,if available .Thanks in advance FME 2020.2

I am trying to extract records from one table based on a series of date ranges in another table. I want all the records from table A, that fall between date ranges from table B. Each table B row has a start date and end date.

Can GIS layers be setup via a relate in a workbench similar to how it is done in ArcMap

I'm not sure what is happening, but when I inspect a CSV the values in the CSV are not equal to the values read in by the CSV reader in FME Desktop 2021.1.0.0 Win64. Actual CSV ValuesFME Inspector As you can see it is not reading the first few digits of the easting values. Any ideas as to what might be the issue? My first thought was some sort of encoding problem, but wasn't sure. I've attached the CSV file in question.  

Hello there how could we move the blue line in order to make it parallel to the read one?

I'm restoring some data from/to a MS/SQL database, which has been stored in a PostGIS database.PostGIS lowercases all attributes, and I'm getting errors in FME when writing them to the original database, where attribute names are mixed case. The database itself uses collation Danish_Norwegian_CI_AI, i.e. Case Insensitive.FME is case sensitive, and I presume that's why it throws this kind of error:Existing table for feature type `PARKER.d_basis_attribs_kontrolflader_traer' does not have attribute with name `tr_bemaerk'. Cannot continueThe database table has an attribute TR_BEMAERK, i.e. as uppercased.How come FME doesn't respect the case INsensitivity of the target database ?It feels kinda stupid to have to rename all attributes needlessly, and no, they're all very mixed case, not all uppercase.(still) using 2020.2

Hi.I'm generally use the workspace repository to assign job queue when scheduling job executions, although I have a couple of special queues to enable high importance jobs to run sooner.But jobs that are not scheduled by the FME server itself, instead being initiated via the REST interface, all seem to end up using the Default queue.I've looking into the API example, and it doesn't seem to include a queue name request parameter. And there's no way to create a queue designated for REST initiated jobs.Is it possible to control the execution queue with REST initiated jobs ?Using 2020.2.5

Hi Please am looking for your INPUTS on different idea what kind of services we could develop. What are mote transformer for this industry . Data is mostly from indoor Surveying Data ( point cloud)  OPEN to any suggestion, ideas or help . Highly obliged with your response. thank you

Hi,I have a set of polygons following a line like shows attached figure. The distance between these polygons along the line are the same. Objective: I have to create some polygons at the end/beginning of the line in the same line direction. Line could be in any direction, not only horizontal. Method (FME Desktop 2020): The original dataset is a polygon shapefile, so (1) I have computed a layer with center point of polygons, and (2) I have constructed a Line (LineBuilder) with this ordered points to know the line direction. (3) I generate a new polygon at the beginning or end of this line at some known distance. The size of new polygon is the same as the original ones, and I have to translate the polygon along the line (In fact, I have to generate several (n) new polygons along the line equally spaced (d)): I have extend the line (LineExtender, n*d), split the line n times to get center points,and then I h

Hello, I have vector data as gdb with multiple data layers: Communes Building Roads Green spaces I want to be able to cut out this data a bit like a cookie cutter according to the boundaries of the municipalities and group all the corresponding data, eg: Municipalities_01 Building (for this area) Roads (for this area) Green spaces (for this area) Municipalities_02 Building (for this area) Roads (for this area) Green spaces (for this area) Municipalities_... Building (for this area) Roads (for this area) Green spaces (for this area) Do you know how I can achieve this? Thanks very much

We have just upgraded to FME 2020.0.0.1 and are slowly testing our different workspaces. We use the python print command to log different things into the FME log file and since we have upgraded to 2020 all these log statements has disappeared form the log file. Python compatibility is set to 3.7+.Is that somehow a feature or a bug?

I am doing a simple landxml read to delete unnecessary data from a landxml pipe file and then write it again with the landxml writer. The Struct feature type should write out Invert{}.flowDir, but it doesn't. Anybody have an idea what the problem is?

Convert GDB to GML Hi I'm a beginner with FME, so I need help because I want to convert a GDB to GML and I don't know how to do it at all. Can you help me ? Thanks very much

Good morning. I have a table with two geometry fields in a SQL Server database. The coordinate system for both of them is EPSG:25830. I've followed this article to be able to write both columns at the same time: https://community.safe.com/s/article/writing-to-tables-that-contain-multiple-geometry-c It works great; but, when I check the SRID of both fields with the function STSrid, I get the 0 value for both of them instead of 25830. Before writing, I set the coordiante system with a CoordinateSystemSetter, so I don't know why it's not stored properly. That doesn't happen with tables with just one geometry column. 

Main workspace:LoopingAndBlocking.fmxThis gives me error: > Custom transformer 'LoopingAndBlocking' does not have a port named 'PrivateInput' which is suitable for parameter 'LOOPBACK_INPUT_TAG' Settings:Enable blocked looping: YesMax iterations: 100Attribute to hold iteration count: FME_LOOP_ITERATION_COUNT Using ALWAYS LINKED Publishing the PrivateInput Port does solves the LOOPBACK_INPUT_TAG problem, but then my feature are outputed through the Incomplete port. That suggests they could not be looped at all? Any thoughts appreciated. Attaching fmw + fmx

Hi all, I am trying to find an FME solution to an optimisation problem. I have ‘x’ polygons of varying sizes, the combined area of these polygons adds up to ‘y’. I need to allocate these polygons across ‘z’ number of groups, each of which require a different proportion of ‘y’. For example:·        10 polygons (x) of varying sizes with a combined total area of 62ha (y) that need to be proportionally allocated across three groups (z) ·        Group 1 – needs 60% of y (37.2 ha)·        Group 2 – needs 30% of y (18.6 ha)·        Group 3 – needs 10% of y (6.2 ha) Possible solutions: I am after an optimised solution for the groupings of these polygons (in the above example, the first solution would be considered the closest to the allocation requirement).

I have a script that strips a bunch of feature layers out into a GDB database that is then zipped. I then made a Creator that attached to ftpCaller. I set in the properties 'create at end' to be yes. This seems to work, however i notice it seems to still be doing the upload while other features are writing to the gdb. how can i say that i want to run the creator and the ftpcaller after every other feature has been written to the gdb? thanks

Select RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CD, MAX (YR_TXT) as LAST_YR_DVLfrom IMAGE_CTLGGroup By RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CDOrder By RD_ID, RDWY_ID,MAX (YR_TXT)

Hello FME'ers,Here is your weekly update on all the news related to FME. New 2021 (2021.2.4)Of course, we're all looking forward to the release of FME 2022, but fixes are still made to 2021. In fact, a new version of FME 2021 was released last week, 2021.2.4. As usual, there are few highlights (because it's not meant to be a spectacular release) but you should consider looking into this if you have experienced problems with either the ArcGIS Portal Reader or Excel writer. The changelog file has more information. Dmitri and Lena's AR SpectacularOtherwise known as the Exploring Outdoor Infrastructure with AR webinar! This took place yesterday a

Hello there we have a set of points getting to the line builder, not in sequence how we could organize them to build them straight line we are getting this from the line builderI think the line builder is connecting the point in the order they enter the linebuilder Any ideathanks