A read-only category for lost FME Form topics. We hope to move them shortly.
Recently active
Dear FME community,I have a question dealing with citygml files. I have several hundred xml-files formatted in citygml. These xml-files have information of the buildings of a city stored in them. It is a 3D model of the city in the level-of-detail 2. So there are ground-surfaces, wall-surfaces and roof surfaces of the buildings stored. Each surface has the right coordinates. A group of 4 xml-files will create one tile with a size of 2x2 km. I want to create my own tiles and decide by myself what size I want to use. So I have loaded all xml-files inside FME and I have managed to create obj-files with small circles. Each circle represents the center-point of a ground-surface. For the tiling process I extracted the center-points and tiled the resulting point-cloud using the “tiler”-transformer. Later I placed a circle on each point with the “bufferer”-transformer since I could not export the point-clouds. Then I created the obj-files. Now I wanted to combine the information of the obj-fil
The image in the annex shows my workbench. This is the result that can be seen in ‘Passed from Tester_2’:NAME ; DBKOrganisation X1 ; 111Organisation X2 ; 222 This is the result that can be seen in ‘SQLCreator_3’:ID ; OWNER_ORG ; CLIENT_ORG ; MONITOR_ORG1 ; 111 ; 111 ; 3332 ; 222 ; 222 ; 2223 ; 333 ; 444 ; 5554 ; 333 ; 222 ; 3335 ; 444 ; 555 ; 111 I would like to use a transformer that uses the results from ‘Passed from Tester_2’ to check if one of these DBK values is present in the organisation columns of result ‘SQLCreator_3’.So I need the transformer to select ID 1, 2, 4 and 5. But not 3 as Organisation X1 and X2 is not present in one of the three organisation columns. Can anyone explain to me how I can do this?Thanks in advance!
Greetings, I am exporting data from an ESRI File gdb to DXF files (fanned out). I would like to update Entity values from a list, rather than opening the DXF in a text editor and manually updating the values.The format is:1001ACAD1000type=NTI want to set the values to:1001Trimblearea1000dxf name (sourcelayername) I would appreciate anyone sharing any pointers or a simple workbench, that illustrates this. Regards, Clive
Hi!I have a question. I would like to test MapTextLabeller but on the transformer I have an error message :"Failed to load label-EZ plug-in. please ensure .NET 4 is installed"On my machine I have the version 4.8.Do I have to install the version 4 or it supposed to works with this version that is more recent?Thanks!
I am trying to find line geometry that has been changed between two dataset. I know there are minor and major changes (Tolerance set to 0 at the moment). But the result does not make sense to me. Nothing comes out the Updated channel. Just Intersted and Deleted. Does the Change detection transformer work on lines?All the Deleted features come from Original stream. All Reviced come as Inserted.Is it something to do with datatypes?I just did a test and took a feature from the Delete stream and it does exist in both original and reviced dataset.I am matching on a UUID key example: A53B8017-9987-4636-B941-737AF58C5F08 EDIT: Since I am matching on UUID i was not sure FME handel them as strings. But I did a AttributeValidation on Type String and that came out possitive. EDIT: This is the WKT of the objekt with same id, from two different sources.The result is going to Deleted. But as you can see the WKT is identical. Just to be clear: I created a WKT attribute to double check what was happen
I am looking to see if there is a method of setting a 'continuation' for counting features in FME.Essentially I have 300 features with a UID of a simple number (1,2,3 etc). I wanted to see if there was a way for when I add additional features into the mix, the UID would automatically populate continuing with the next available UID (i.e. 301)
Hello,I am a youth volunteer with a medieval boys camp. Since Covid hit, we have not been able to attend any camps for safety reasons. I have been given a DEM and an aerial image of the property where we hold the camp and I would like to build a Minecraft World to scale, so we could attend virtually. I found some info about how to use FME to translate the DEM into a Minecraft world, but I need help. Is there someone or some way that you could use your software to help us create this? I am an expert with Minecraft but as a 15-year old, I have no idea how to use FME. Thanks For Your Time, Kaleb McNeil
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 section. Thanks.
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... ^QUE...'A fatal error has occurred. Check the logfile above for detailsI have then defined the schema to the actual function for each table, but still get the above message in FME.
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: The Puzzle of the Extra Partner Challenge 2: The Puzzle of the Holidaying Lizards Challenge 3: The Puzzl
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! Hexagonify the World: The Theory and Applications of Uber H3 - February 10th Overcoming the Complexities of AIXM with Model-Based Data Integration - February 24th Gaming with FME - February 25th FME Support FormDid you know, when you are logged into the new Community, you can see the status on all of your support cases as well as reply to them. To view your cases go to Support > My Cases or bookmark this link. BlogFME Tips & Tricks: Creating Dynamic Workflows, this blog highlights various ways to get started creating dynamic workflows. Then if you are interested in trying it out for yourself, check out the links to the knowledge series at the bott
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 https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/Date-Time-Functions.htm in the subsections 'Arguments' and 'Format String Flags', for supported flags and exclusion lists
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)
