General

Just installed FME server and need to create new web connection.Where do I create new user name and password?

Hello,I have a process that read a folder with PNG images and I have to populate a PostgreSQL Table with some information and the Picture Itself. I first tried to save the data in the column using the AttributeFileReader but it seems not working. Do you have an other approach? Thanks for your help. Mr Steph.

I am trying to import shapefiles from ESRI into FME and I am getting this error

Hi,I think I know the answer is "can't do this in FME yet", but thought of asking anyway :) Is there a syntax for constructing a predicate in JSON Query when used in a JSONExtractor or JSONFragmenter transformer? Basically I'm after getting to the data within complex JSON structures quicker and avoid having to fragment/flatten everything and then filter afterwards. Attached is an example: with a predicate, one would be able to get to the proper "Food" object in the array based on the predicate "Type"="Fruit", instead of having to flatten the whole thing, testing and filtering, then exploding again. Assuming this is not really possible, I also wrote a broader post in the Ideas

Old version 2018New Version 2020.2.2Windows 64 bitMS Software Download Center

What is maintenance pricing for Desktop and Server?

tired from jumping hoops just to ask... how does it do for 1cm topo?

 FME 2020: Which FME tool is equant to “Spatial Join” in ArcGIS? I couldn’t figure out which tool is equivalent to “Spatial Join” in ArcGIS.  I’m aware of the “spatial filter” tool but appears not to produce the expected result as the block number is supposed to be transferred to each parcel      

I have a SQL Executor that is meant to simply call a function on our PostGres database. The workbench is literally a Creator > SQL Executor > Logger To call the function I am executing the below SQL; do $$begin call apply_titles_update();end$$;FME initially struggled to find the function so I added the schema, so the SQL now reads; do $$begin call land_registry.apply_titles_update();end$$;This function does a number of things, notable a lot of table drops and inserts, however when FME runs it now fails to find the tables;Error executing SQL command ('do $$begin call land_registry.apply_titles_update();end$$;'): 'ERROR:  relation "dataset_update_schedules" does not existLINE 4: ...                                          from    dataset_up...

FME 2020: How to copy field names from file to another? In the screenshot below, I selected the fields from the first file and pasted them to the second but appears that the fields names are not pasted. How to perform this?          

FME 2020: How to exclude fields added by the “Deaggregator” tool? I couldn’t figure out how to exclude fields added by default as the the “Deaggregator” tool is performed 

FME 2020: How to remove points duplicates (identical points)? I couldn’t figure out how to remove points duplicates.    

Hello everyone,I hope you enjoyed the recent Twelve Days of FME contest. We had a great time and loved seeing all the submissions for every challenge. Unfortunately life got a little complicated and I didn't get the chance to keep publishing the daily solutions and winners as I'd planned. Sorry. Still, better late than never, as they say, and so here are the links to updated challenge articles. I've provided the solution to each challenge, listed all of the users who gave a correct answer, and added additional workspaces where possible. I've also awarded community badges to everyone for each correct answer (or winning entry, in the case of challenges that were judged by Safe). So congratulations to those of you who took part, got correct answers, or won prizes. I hope you had fun (and learned something) and we'll do this again for sure in the future. Challenge 1:

Welcome to What’s Up Wednesday FME Lizard & the Data ExplorersHave you ever wanted to experience FME in a comic book? Well, now you can, check out what the FME Lizard and Zipster are up to in Safe’s first comic book!  WebinarsIn addition to the eight webinars I mentioned in last week’s What’s Up Wednesday, we’ve added three more! 

Hello there we are doing some photo shooting for each road segment and we want to know if each segment have been covered by the photo shooting Attached you can find the road shapefile and shooting position of the camera as an approach, we have created a buffer of the road and use the clipper to clip all point within the road then build a line and compare the length of this line and road segments, but we face many issues due to the buffer overlapping and point duplication on those buffer, I mean taken twice  if you have any other approach will be appreciatedthanks 

I am reading a feature class stored in ArcGIS Enterprise database and I would like to output a json file. However, I need the datetime fields values to be in epoch time (with milliseconds) not in FME datetime format. I am using the DateTimeConverter transformer with the %s Output format parameter For instance I need this translation 2021020511442300 ---> 1612543463000 However the transformer return the following error:DateTimeConverter: Failed to evaluate expression '@DateTimeFormat(20210127152551,%s)'. Result is set to nullFormat flag '%s' is not supported for input type 'datetime'. Please check @DateTimeFormat() documentation in

Dear FME expert I would like to grab some example fmw about spatialrelator work together wirh listexploder. Please help me sincerely yours

FORMATTING DATES I can get this to work: @DateTimeFormat(20210127,%Y) = 2021 What I want to do is use the value of an attribute as the date input, like this: @DateTimeFormat(@Value(Date_Installed),%Y)

Hello, I have received a list of vertices/points of different lines in a CSV-File from our client. The CSV-File has the same structur like the following image: Creating the respective lines is not the problem (VertexCreator -> LineBuilder (GROUPBY "row1"). In addition to the complete line with all its vertices, I would also like to create all the individual line segments between the individual vertices as lines. Now there is the possibility to achieve this with the chopper, but after segmenting the line into its individual segments I would have to attach all attributes from the second column of the CSV file (start -> end point) to the line segment again by means of a spatial selection. I would like to avoid this. Is there an elegant way to do this in FME? Thanks a lot

We have a dataset of 911 calls by unit and are trying to calculate a response order for the unit by call. The dataset contains the fields ReportNumber(Unique Call ID), Unit, UnitType, UnitDispatch(Date/Time), UnitEnroute(Date/Time), UnitOnscean(Date/Time), and ArrivalOrder(Numeric). My goal is to calculate a field ArrivalOrder so that if 3 units are assigned to the same ReportNumber I can tell which unit was the first on scene, second, ETC. The dispatch database only gives me the first unit but doesn't give me the running order if multiple units are involved. I've gotten to the point that I need to group them by ReportNumber and now I'm stuck. Has anyone tried to calculate something silitar and had any success? I thought maybe StaticsCalculator might work but wasn't giving me the order per line. Thanks.

Hello everyone, I'm trying to create a point of intersection between bridges and the road below. The problem is that I need to create one point at the first intersection in the direction of traffic as shown in the image below (Image1).  My first tought was do to a line on line overlayer to have the intersection point between the road and the bridge. In doing so, there is a lot of point that are created (Image2) and I don't know how I can select the right one automatically.  I have tried to select them based on the coordinate but since the direction of the road change all the time, it is not reliable.  The ultimate goal would be to have a point that represent the clearace of the bridge at the intersection of the first bridge in each direction. This would be needed for the whole bridge dataset and have to be generated automatically.  Any help is much appreciated!

I have a 2D shapefile of the building footprints (without the building heights in the attributes) and Lidar data. Is there a way to clip the pointcloud according to the building footprints and then extrude according to the pointcloud?  I've looked at this webinar, specifically Demo 6, https://www.safe.com/webinars/gain-total-control-of-your-lidar-and-point-cloud-data/ but the reader is giving me errors because the building reader is having troubles reading the building attributes I think.

I know the question is a little bit weird, but I'll try to explain it. I have to create a simple workspace to get data from an external database (Informix) and copy to our database. This workspace will be published to FME Server.  As I said, I don't get access to external database, from my PC, but I do from Server. So, if I can publish the workspace to the Server it will run correctly, I sopose. But, how can I create an Informix Reader in FME Desktop if I don't get access to this database? Is it possible to do it? Thanks.

How could i put the output of fme as image in sheet of excel file ?i have read Pdf file and after i worked on it at Workbench and did some modifications .i would like to have the output inside sheet in excel file as image. How could i do that ? FME version 2018 Thanks in advance .

Would it be possible to create a script in one PythonCaller with a number of functions, and then call the functions in that script from another PythonCaller using the 'from <script_name> import <function_name>' syntax?