Transformers

Hi folks,I developed an FME workspace that connects to an api service. The workspace is quite elaborate, but in its basics its sends (calculation) jobs to an api, periodically requests a status update from the api to see which jobs completed, and downloads the results for all jobs that are completed. If I look at the FME workspace I see that in total 5469 (calculation jobs) were initialized, and it seems that the monitoring process has identified 590 jobs to complete. If I however manually request a new status from the api, it seems that (nearly) all jobs in fact completed, but many did so after the latest time instant that was logged during the translation (2020-09-18 17:41:26). Also if I look in my resultFiles folder for the jobs that were downloaded, I see that the latest resultFile was downloaded at 18-09-2020 17:41... I notice that the workspace indicates to be still running, but there doesn't seem to be any progress anymore. If I look at the translation log within workbench,

Hello. I would like to know how to produce tiff or jpg with georeference. As an input I have tiff or jpg with no information stored inside the file about the image position. I have separate csv file with coordinates for upper left corner of the image and image rotation. Which tools should I use , can I find somewhere a workflow for this task? Which tool should I use to connect information from csv with images. I a using FME since 2 weeks so everything is new for me and I dont have full understanding. I saw a video on youtube that someone made a workflow for images from drones but unfortunately it was not described how it was done in details. Raw input images have no coordinate system, in csv I have an exterior image orientation for every image and there I have information about the coordinate system. How many tools I should use.

Hello Team,I have a drone image ( jpeg ) and there are some metadatas informations, for example: longitude and latitude.I extracted these informations - center point of image.My goal is try to georrefencing this file using the transformer RasterGeoreferencer:  Thanks,Danilo

Is there a transformer that can convert a number into a number with a thousands separator, that is, "1000" to "1,000"? I know you can do it with Python but I can't find a transformer that does this.Thanks

I need to pass quite a few parameters (10+) to my workbenches running on FME server. The jobs are started though a call to the FME SERVER rest API, from a c# application.I'm considering 2 options:1) specify each parameter individually, which requires some additional coding in c# when calling the workspace.2) specify a single JSON parameter, which combines the values of all parameters. Passing parameters to the workbench will be more generic, since the set of parameters may be organised in a class and (de)serialized when required. What would be the pros and cons of both methods? 

  i have as output 3 splitted tables from FME but i would like to add background color to the main header of each table and add different color line per line for each row .if there is any idea to create table it will be nice but if not ,i would like to change the color so i can recognize the main header from the body of the table .is there any way to change the background color depend on amoount of rows at each table ,bcs no, of rows changes always .FME 2018 Thanks for help  

Hi everybody, I built a report composed of some tables using the "group by" parameter to split the rows in groups. Despite the data structure and types are the same (obviously), there is a bad vertical alignement beetween the tables (see attached screenshot).  Any suggestion is welcome! Thanks

It seems to be very complicated to cut polygons based on the angle between intersecting lines. Is there a workaround in fme to automate this process? Enclosed a gdb with sample data. In the gdb source data (BGT) and desired result (new_polygons), GW_OVK represent the line features to be used. Many thanks in advance! (FME Desktop version 2019.2.2.0) Kind regards, Pim van der Zwaag. 

Hi I am using a GeometryValidator with custom set of vaidators (see attached).I have tried using an intersector, generalizer before GeometryValidator to repair the geometry errors. Unfortunately, in a lot of cases, the auto repair by GeometryValidator isn't correct. It is removing the geometry completely.Most of the geometry errors are either self intersection, or there is Duplicate Consecutive Points (see attached examples)Any suggestion how to best approach this and correct the geometry in these cases? 

I try to change the 'Incoming Attribute' parameter in the AttributeEncoder to 'Use Bytes' instead of 'Honor Enconding' but still have this problem. In FME linux the speciale characters are OK, but not in Windows, i try different encoding but still no fix yet!

How to get UTC time in FME 2014? TimeStamper gives local time >>When in DateTimeCalculator I'm subtracting hours from local time to get UTC time, but this won't work after Daylight Saving Time begins.

Hi,Does FME Server support LDAPS?the closets KB article I found is:https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Import_CA_Certificate_for_AD_SSL_Connections.htm but unfortunately introducing a certificate doesn't seem to be working.Anybody have any experience with FME Server + LDAPS and would like to share his/her experience?@david_r @mark2atsafe @jlutherthomasThanks,Itay 

I would like to generate 3D object from 2D Shapefile.The 2D Shapefile is Long/Lat coordinate system and has height value of Floor and Roof with meter unit.Is it possible to 3D feature using 3DForcer and Extruder.Could you tell me the procedure for it? I could generate 3D model from 2D Shapfile if the horizontal unit of coordinate system is m.

The server we are using is on-prem 2019.4. I am trying to publish a dataset using safe fme. I have read through the rest api tableau documentation, but I am still having trouble translating that so that the http caller reflects tableau's rest api guidance (https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm). Some help cross walking the two would be helpful. Thanks, Greg.

I'm a pretty new to FME so apologies if my question is a bit basic. There are 2 polygonal shapefiles, one that gets modified daily on a server and another we have in a sde. I'd like the first one to replace the one I have but only where changes have been made to existing polygons, while simultanously puting any new polygons created in a separate shapefile to add in manually for quality control. I'm not quite sure which transformer(s) to use. Any help would be appreciated, thanks!

Hi,I have a database with FIRST_NAME, NAME and BIRTH_DATE.I have to find all the potentially duplicate people.If I find two features with FIRST_NAME and NAME written the same way or looks similar, I have to compare the features between each other to check if they have the same BIRTH_DATE. If they do, it's the same person, if they don't it's two different people.In this example, John Lennon and Jon Lenon are written almost the same way and they have the same BIRTH_DATE. We can consider it's the same person.But John Lennon (1950-01-01) is not the same John Lennon (1985-01-01). IDFIRST_NAMENAMEBIRTH_DATE1JohnLennon1950-01-012JonLenon1950-01-013JohnLennon1985-01-014RingoStar1945-01-015RingoloStar1945-01-016RingoStar2000-01-017GeorgeHarrisson2000-01-01 Would you have an idea how to do this kind of comparison? I tried the FuzzyDuplicateRemover but it doesn't give very good results and it doesn't store into a list the duplicated features potentially found (so I can&#39

I have a section of workflow that generates a dataset, each row I will want to POST to an API. I then have another section that requests an auth token via HTTPCaller and creates a dataset with a single row and single value containing the auth token. How do I now get the Auth token to set it as a header value in the HTTPCaller when POSTing each row from the dataset?    

The Excel function takes the inputs NORM.DIST(x, mean, standard deviation) where x is the value that you want to calculate the cumulative normal distribution for. I intend to use 0 for the mean and 1 for the standard deviation (i.e. the standard normal distribution). I've looked through the StatisticsCalculator as well as the Math Functions in the ExpressionEvaluator but I don't see anything like it in those transformers. This is related to this post where they are attempting to do the inverse: https://community.safe.com/s/question/0D54Q000080hEk3SAE/is-there-a-function-to-calculate-inverse-normal-cumulative-distribution?t=1599138666050 In that post the solution was to use PythonCaller and I am planning to follow that solution but wanted to see if I could use a standard FME transformer to complete this calculation instead.

I don't actually need a solution, but I'm just curious if there's a way to convert a number from a float to a decimal or vice versa in FME without resorting to python. So for example reading some data as a decimal, which is then stored elsewhere as a float and you want to do some change detection and consider56.358400000000003 to equal 56.3584and963.299000000000092 to equal 963.299and56.358499999999999 to equal 56.3585  

Dear all,I am learning how to export my data to GML. My file has many buildings (including roofs and walls), I separated the roofs and walls for each building using FME.Now, I want to make a CityGML file from this data using FME.It was pretty good when I used the gml_id (in Building class) based on the building's name. The roofs and walls (with gml_parent_id was set as the name of the building) had attached to the correct building (Figure1).But when I inserted and validated this CityGML file into the 3D CityDB software, these were some errors (Figure 2).I tried to ignore gml_id in the Building class (do not change gml_parent_id of the roofs and walls), checking this CityGML file (in the 3D CityDB software) was OK. Unfortunately, the roofs and walls were not attached to the correct buildings (Figure 3).What did I miss and what should I do to solve it?Does anyone have a solution to my problems? I am very grateful if anyone can respond (this took me several days). I am a beginner with

I'm having some difficulties with an translation of an Excel file that contains a some sort of layered structure and needs to be transformed to a sort of folder/path attribute structure in Excel. The input is as followed:The first problem I encounter is the use of indentation in Excel, it looks like FME does nog recognize this kind of setting/formatting. This issue makes it a lot harder to transform the layered structure of attribute "Naam" to a path structure with an "folder" and "name" attribute. As shown below: I already have a solution separating the steps and merging them back when the structure is OK. I can do this by splitting the steps using the Sampler with a Group By number with sample rate (N) 1 and sample type first N with no randomization. All steps will be in the NotSampled area and can be merges back later based on the number getting the structure from the Sampled part of the flow.  So is there a way to use the indention or anther wa

Hello, as the title already implies, I'm trying to merge XML formatted text ("insert") into a similarly ISO19115-1 formatted root template ("template"- see attachments) in a XML Templater feature. The insert (see attachment) is put together in a String concatenator feature from a set of values extracted from a database in a previous stage of the workflow and stored in an attribute named "SCIENTIST_INFORMATION". AFAIK I have two options to achieve what I want:  *Option 1 - plain 'fme:get-attribute()' *:If I use a simple {fme:get-attribute("SCIENTIST_INFORMATION")} the templater replaces XML special chars with their respective protected counterpart (e.g. < with <), rendering the text insert into something I do not intend. Note that I cannot reverse these transformation with a string replacer after the templater, as this also replaces non-XML specific special characters making the resulting XML files invalid.  *Option 2 - &#

I'm trying to convert various features of an IFC file to OBJ files. I'm able to do the entire transformation up to the point where I save the OBJ files, but it seems that the coordinates are in a projected CRS, evident from the very large X and Y coordinates. I have tried using a CommonLocalReprojector transformer (with a FeatureHolder just before it to make sure the transformation is done relative to the entire feature set):But the models appear stretched when I view them in Blender. Quite drastically. You can see that the doors are much taller than they should be, based on their width to height ratio:The only geographic information I really have from this file is RefLongitude and RefLatitude. But like I said, the coordinates themselves appear as large X and Y values, at least after being read from FME Does anyone have any idea on how I can fix this?

Hi folks I'm searching informations for importation of donuts (archipelago) inside GDB format. Up to now, all my donuts are ejected when I try to integrate them. I can do the import in GDB open API or GDB with ESRI licence.