FME Form

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  

I am reading a JSON file and converting into File GDB, here using Attribute Manager, but in Attribute Manager list of attributes are not updating accordingly when ever I change the JSON files. In order to update is manually update the reader and feature type, then only it is updating. So. requesting you please suggest a way to auto update this.

We need to move our FlexNet License Server for FME Desktop to a new machine. What is the best way to move the licensing from the old license server to the new? Thank you.

Hello,  I have a shape with points and a shape line. I want to create the shortest path between my points which have the same trip_id with the stop_seque field but the shortestPathFinder doesn't work.I don't understand ? Please do you know what is a problem ?Thank you

Hello, I need your help please my pdf after conversion is too heavy. do you have an idea to compress these pdf please? 

How would I go about copying the name of a column and using it as an attribute?

What is the best way to join 2 ArcSDE layers and then add a whereclause on the joined data?