Transformers

Hello,I have a trouble with zipfiles.I made a script that take multiple files and put them into a PostgreSQL database (in a binary column).My script works really great : I'm using a datafile reader to get files and the PostgreSQL writter put them into my DB without any problems.Where it doesn't work : when I try to import zip files, FME try to unzip them.  I don't want them to be unzipped, I want them to be imported as zip files directly into the DB. Have you any solution ? Thank you for your answer.Best regards.Arthur Bazin

I'm trying to create a server app that allows users to select one (or more) values from a list in order to filter / select data for download as a CSV.My workspace is a slightly more complex version ofReader (Web Feature Service) ------> Tester (based on Published Parameter) --------> Writer (CSV)And is designed to be run as a Server App where users can define the value(s) from a list to filter the data for download.The Published Parameter is configured as "Choice (Multiple)"I would expect the Tester to be able to work with the list provided from the User Parameter. However, Tester (using the "In" operator) requires values to be comma separated whereas "Choice (Multiple)" provides a whitespace separated list.So I can't think of a way to offer users multiple choice values for downloading filtered data.I've found some fairly old topics covering this, but I don't think the provided solutions will work adequately for a Server App

I think this can be done using FME, but I'm not sure where to start... I'm looking for a way to decode IOT dataframes. I attached the documentation, not sure what to do more because I really don't know where to start. Can anyone give me a pointer?

Hi, I'm currently working on a project in which I need to change the table format from long to width. The data is coming from a csv file and consists of information on purchases. Each purchase has it's own line, so there are almost 1.7 million single rows in the dataset. Currently each row has got the name of the product bought and the company who bought it. I would like to have a single row for each company, containing the number of items they bought from each category. My current table looks like this; In which; Deb.nr. Is a unique ID for each buying companyTotaalGroep , is the total number of items in the group, bought by all companiesGroup is the group the item belongs toGroep.total_count is the number of items within the group an individual company has bought%vanGroepperDebNr. is the percentage of sold items a company has bought. The other columns are seemingly irrelevant for now.  I would like for the data to look like this; In which the % Total group is the percentage of

Is it possible, and if it is, how could i transform my .FME to .FMW file??

I'm trying to create a ellipse2D or circle shape from four points. i have 4 coordinates (North, South East, West) i want to join up the points with a round shape. I have tried 2D ellipseReplacer, and used East+West for the Primary Axis & North + South for the secondary Axis. its seems to almost work but the scale an shape is slightly differentI have managed to create a Square using BoundingBox Accumulator - But need to fill that box with a round shape, touching all edgesusing 2019.2 DesktopThe image attached shows the 2D ellipse shape overlayed on the 4 points/box. As you can see it's not right. Even when I scale it down it's still incorrect Grateful for any assistance

FME Desktop 2018.1.01. on Windows Server 2012.I started a translation at 1523 yesterday which simply reads point data from SQL Server Spatial and writes it to an ArcSDE layer. At 1821 STATRP lines started appearing in the log. And at the end I got 2 lines saying "Translation was SUCCESSFUL with 1 warning(s)..." instead of the usual 1 line.Statistics are ticked in the translation options but I've never noticed this situation before. What is STATRP, and how is it different from STATS?2019-06-17 18:21:30|9989.8| 2.5|INFORM|Transaction #3779 was successfully committed 2019-06-17 18:21:34|9993.1| 3.3|INFORM|Reading source feature # 3780000 2019-06-17 18:21:34|9993.1| 0.0|INFORM|Transaction #3780 was successfully committed 2019-06-17 18:21:36|9995.6| 2.5|INFORM|Transaction #3781 was successfully committed 2019-06-17 18:21:39|9998.1| 2.5|INFORM|Transaction #3782 was successfully committed 2019-06-17 18:21:40|9999.4| 1.3|INFORM|Reading source feature # 3782500 2019-06-17

So I'm trying to intersect this centerline data with parcel data to return the length of the parcel line from the centerline to the edge of the property. In areas where none of the parcels intersect each other there is no issue however when parcels do intersect my length measures get split due to the self intersection that is going on. I've attached some sample data as a go by. So I'm basically trying to figure out how to intersect the polygons turned into lines (desired output) via chopper based only on where the centerline cuts through the parcel line(s).  

Hi guys,I noticed that question severl times, but never find out any final solution, taht will work for me.I have a database, with a lot of attributes in domain field. Is there any option to export those coded values with fme?Thanks in advance. Miha 

Hi, I've been attempting to extract a volume calculation from two LAS files and have tried a few methods advised in this forum but I'm having limited success with final reported volumes being incorrect.I have an existing level LAS file with a secondary as-built LAS file which I need to create a volume calculation and also generate a glb model solid. Method as follows:1. Read 'existing' LAS and use TINGenerator to create surface to extract volume calc.2. Read 'as-built' LAS and use TINGenerator to create surface to extract volume calc.3. Compare difference of volume calcs.This method works OK for comparing surface area difference but not the volumes. My design software shows that the TINVolumeCalculator creates wildly different values which I assume is operator error.However my preferred method using design tools would typically follow this pattern...1. create surface DTM from existing LAS file.2. create surface DTM from as-built LAS file.3. extrude as-built surf

i would like to ask : is it possible , to extract the map after using clipper and add to the sheet file . the output that i get n inspector ,i would like to let workspace to save the map automatic new sheet file in my feature writer .Thanks for help

I need to update some measurements of line strings. How do I calculate the length of a line string with points stored in Oracle Spatial SDO_GEOMETRY?

Hi all, I'm quite new using FME and it's my first time using JSON. I have being reading about the different transformers, but I couldn't find how to solve this (without python).I'm reading a JSON which contain feature collections. With the json reader i get the blue table, which contains some columns with nested values. Using the JSONFragmenter transformer I can expose the attributes (orange table), but they are populated in different rows. How can obtain the green table? Thanks!

I have two datasets of hundreds of polygons. Each has an ID and each ID appears exactly once in both data sets. One of each pair of IDs is bigger than the other but they always overlap somewhat. In the image, below, you can see such a pair in pink: the highlighted polygon is from data set 1 and the non-highlighted polygon is from data set 2. These are surrounded by other polygons that may or may not overlap them and have different IDs. I need to find a way to clip the polygons in dataset 2 only by the polygon in dataset 1 that has an identical ID such that, in the below case as an example, the only part of the pink polygons that is left is the spur extending to the bottom right. 

I have two tables having ID column in common. These IDs are repeated multiple times in both the tables. Now I need to merge these two tables into a single table based on this ID field. I tried using Feature Merger, but the results were not as expected. Some data were missing. Is there any effective way to do a many to many join in FME?  

i have issue with date some times i have attribute has date 01.02.2010 in this format and some times the same attribute but in another excel file it shows 20100304so when i use date converter and i set format as input %d.%m.%Y$ output %Y%m%d i need output format in this format %Y%m%d because of the rest of transformer condition depends on thsi format .but from the beginning i want to check the date ,if this attribute whatever comes,it should convert to this format %Y%m%di tried with tester before it ,i am not sure how to set it ,as i want to check if the date include this format %Y%m%d so pass if not ,so u have to convert whatever the format to this format as 20100304 but one of another excel files that caused me terminated ,FME reads it as 01.02.2010and i thought ,i can get output of dateconverter when it rejects to use as input so i connected output and rejected to next transformer ,i found the

Hi All,i have a polyline for which i would like to find the digitization direction. and based on this i will be applying the driving direction for this line .I am not sure how i can find the digitization direction for polyline , can somebody help me with this .?I checked with azimuth calculation but not sure how i can use this any guidance on this will be helpful. Thank you in advance .

Hi all, I saw that a WMTS reader has been requested. But meanwhile, I would like to ask whether anyone of you implemented a workaround to read WMTS.I want to read the orthophoto via https://www.basemap.at/wmts/1.0.0/WMTSCapabilities.xml and crop it by a polygon. However, I cannot currently read it. Thanks in advance and stay safe!Best, N

Hi all,I am trying to run a workspace on FME Server (2019) through the Data Download service. This generally works fine in terms of authorization etc. I can successfully pass parameters (and directives) to it as a query string. However, one of the parameters is geometry, currently encoded as OGC Well-Known Text. The input for this parameter can become quite large, as the geometry will be passed to FME Server from a web map. When this happens, the URL exceeds tens of thousands of characters and this seems to break the request.Because of this, I am trying to pass the request as POST, keeping all parameters in the body and thus the URL nice and short. However I can't get this to work - the parameters in the body are ignored and the workspace is run with the default parameters every time.The FME Server Data Download logfile has this line every time:POST request received. Redirecting to GET method. Is it possible at all to use POST to start the Data Download service? If so, how do I pass pa

Hi list.This may be obvious to some, but I'm not very proficient in raster handling.I'm building a custom process that manipulates one DEM, and checks with another DEM.Both input DEMs are GeoTIFF with a single REAL32 band that contains the height information. My output should be of a similar construction.I'm using RasterCellCoercer at the input to vectorize, and ImageRasterizer to create the output image to be stored as GeoTIFF.However, ImageRasterizer does not offer REAL32 as an option, only multiband RGB(A) and single band 8/16 bit options.Is it possible to create a single band REAL32 GeoTIFF using FME, and if so, how ?Using 2020.0CheersLars I.

I'd like to use the TopologyBuilder but had some troubles to get it work with 3D lines.We want to consider the elevation when computing the topology so that:nodes are only produced were lines intersect in 3Doutput nodes are also 3DAttached workspace is my first attempt (that works) but I'm curious if theres a better solution out there.Peter

i used Network topology builder calculator , and each line has specific id so i get the output for which id is connect to which id ,but i have one problem when more than one line intersected it repeats id more than one time bcs as example id 5 connects with id 7 and id 9 and id 10so it repeats one id ,many times it depends how many lines connected to the same point ,so i would like to ask ,how could i give for all connects point the same id_network bcs if A connects to Band B connects to Cso A CONNECTS TO C so all of them should have the same id _network id_network for A =8id_network for B= 8 id_network for C = 8I WANT TO give the same id_network for all lines connects to the same point i do not want to repeat one id more than one time .  

Hi. I am working with FME 2019.1 and I have created a workbench that needs to be run by a person new to FME.The wb uses PostGIS database where the connection details are 'Embed Connection Parameters'. There are multiple hosts which come as dropdown options (choice parameter). So, when I have select a database from the dropdown, next thing is the schema that should be reading/loading by itself of the selected host. But, that's not coming.What is now- Problem faced: It is done manually by copying the schema name from PostgreSQL server to FME. Any ideal solution for this?Thanks.

Hello All,I apologize if I am not making much sense, as I am new to 3d modeling.I am having trouble trying to think of solution. I want to take spatial-vector data and output to local coordinate system. The local coordinate system, ideally, would be constraint to min and max extents of: -1m, -1m, 0.5m & 1m, 1m, 0.5m.Right now, I am getting values larger than min and max extent when using localcoordinatesystemsetter X CommonLocalReprojector. I am not sure what I can do to equalize each x-, y-values in order to scale appropriately. Nor find transformer that I can input area-extent as min/max extent constraint. I am sure there is a mathematical formula, but am lost. For example, point-1_Local = -7.5403653628193155, -5.638463266998554, 0.5point-1_LocalConstraint ~= -0.4817, -0.504, 0.5 point-2_Local = 7.502099056082192, 5.551721092860062, 0.5point-2_LocalConstraint ~= 0.8439, 0.828, 0.5 

Hello,I'm trying to find only the letter D on its own in a string such as the following: B,G,D,DM,TD,DM,TD,D. In this example, that would be 2 D's (the third D and the last D I've marked in red).Unfortunately, all the regex expressions I've tried also gets the D within TD (e.g using D,|D$). Thanks.Tony