Creating and organizing workspaces. How to use Workbench.
Recently active
Hi, I am retrieving data through an API using an HTTP caller. The data consists of points and lines. My plan is to pull this data, perform some attribute mapping, and then POST it to a website. However, I'm having trouble extracting geometry after flattening the JSON data. I used a Geometry Replacer, but it fails every time I run it. The error message says:INVALID_PARAMETER_GEOMETRY_SOURCEI would appreciate any assistance with this!
Hi,I have a file of points which correspond to buildings. Each point or building has a number of apartments (total 9000). from this layer, I would like to create zones for every 500 apartments, without intersection. I tried the neighbor finder with sorter assending on the distance then range mapper attributes but the result is not good because I should not have any intersection between the polygons. Help please :) Thanks a lot
Hello Folks,I am working on a use case where I need to retrieve data for retail shops closest to my current location or a given set of geographic coordinates.I am attempting to implement this using an FME Form; however, I am encountering difficulties in obtaining the current location dynamically.If anyone has experience or insights on how to effectively retrieve the current geographic location within FME or through any integrated approach, I would greatly appreciate your guidance. Thank you in advance!
Hello,I am experiencing some odd behaviour with the FeatureReader when trying to read in a schema from a Feature Class in a FGDB. I am using the “path_windows” attribute that contains the location of the gdb. When run like this, I often get a rejected message (see Caption 2). When I add in the hard coded full path into the Dataset field of the FeatureReader, the data gets read correctly. What is strange is that this has been working fine in the previous weeks when I had developed it. It only appears to be an issue since today. It also seems to read successfully when I run the workbench with caching to the Aggregator before the Feature Reader, then running again from the aggregator (no settings have been changed). I have tried using the path_unix field instead, but get the same error. I have also tried other datasets, but get the same issue.Has anyone experienced similar behaviour when using the FeatureReader with a GDB?… and any ideas to help with the stability of the run? The workbenc
Hi everyone,I’m encountering an issue with the migration of Smallworld collection records to MSSQL using FME. I perform a differential migration of Smallworld records daily, and I need a way to identify and log any failed records during this process.In a previous migration project, I handled this situation using a post-validation Magik script, which compared the migrated objects in the external database. This database had a version control mechanism managed by an additional date column, making it easy to track if records were inserted, updated, or deleted.However, in the current case, there is no such versioning column in the MSSQL database, making it challenging to track failed records.I’ve decided to log the failed records directly in FME. After exploring various resources, most suggestions point to using the Logger transformer, custom transformers, or Python scripts to read the FME log file for errors. While these methods help identify general errors, they don’t provide details abou
I have 501 polygons of various shapes and sizes. I want to split it up in clusters of roughly 20 polygons each. But I wan the clusters to be located together. I have tried the spatialsorter, which gives good results. But not quite what I’m looking for. Is this possible? Any help would be greatly appreciated. ThanksB
Morning,I have access to the bucket and can read files. However, when I attempt to download a file I receive the following error:My admin insists I have the correct credentials, and I can download this file using WinSCP. Are there are settings I might be missing on the connector?
Hi all, i've got a strage error. I have about 30 ArcGIS Online readers that i want to read, update and write back to ArcGIS Online. Now, the update part with the Changedetector workes fine. (Dont look at the mess ;). The problem:When i run the workspace, it gets all the 41K features that are in there. The other ones are skipped because it is not found. This works as it should work. After that it tries to search in groups accessible to the user, and then it says "error running translation”. Does anyone know how to fix this? I have attached the log file and the workspace. Thanks in advance!
Hi, I’m trying to calculate the volume of various areas of beach using point cloud data. I want to calculate it above a horizontal plane at a level input as a user parameter and I have individually references mif/mid polygons demarking the areas.I have been using the method at the below link as a starting point, but the problem is the beach is sloping, not flat, meaning using the z.median value gives an incorrect result.https://support.safe.com/hc/en-us/articles/25407483031053-Volume-Measurements-with-the-VolumeCalculatorAny suggestions for a solution would be gratefully recieved!
Hello Forum, I have a polygon dataset of railway land, but it contain holes where items such as buildings, tracks and signal boxes would be. I need to fill in these holes to form a continuous polygon. The image below shows a sample of the data. I’d want to fill in holes like those marked in red. But I do not need to close spaces such as those marked in gold. I’ve seen…. … but I don’t think that’s suitable for the task. I’ve also looked at Dissolver, but I’m not sure if that's the right way to go. Any ideas, please. Thanks,Stuart
Hi, I need to find into a network of GPS lines the location where 2 line overlaps or where a single line overlapThe problem is that of course the lines aren’t exact the same (the lines derived form GPS points so I don’t have a duplicate geometry) and only a portion of this lines overlapssee picture attacherd If you need the sample of shape dataset let me know thx Francesco
Hello Everyone, I have two datasets, which I essentially want to stack on one another. One datasets has data on rivers, streams, and brooks, while the other has information on ponds, lakes, and reservoirs. They all have the same attributes, so I just want to add the pond, lakes, and reservoir data as new rows in the river, streams, and brooks dataset. Can someone please help me figure this out?
I'm trying to use the WHERE Clause in a FeatureReader. I'm reading in an Oracle SDE featureclass and want to only select those records that match an attribute in a csv file I've loaded. I'm assuming that I have everything setup correctly where the attributes from the csv file are FME Feature Attributes. It seems when I add the @Value(col0) to my WHERE Clause, it breaks. How can I check to make sure it is setup correctly?
I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!
Hi,I need to use Upsert to either Update or Insert features into an Oracle database.If I use Insert to add values it works a treat, so the connection to the Oracle tables is good.As the Oracle tables are large, when adding the writer I use Import from Dataset… This picks up the format of the date fields and all sorts. It works well for initially inserting the data.However, when dealing with deltas, which might be Inserts or Updates I want to use Upsert. I can test it on a filegeodatabase and it works perfectly. Taking that knowledge into the Oracle process like this: I use the NODE_ID as this is the unique identifier.However, this fails.So I have followed the guidance to implement fme_db_operation, I have created a new attribute field of that name, and used a FeatureReader, FeatureMerger, and then AttributeCreator to define whether the feature is classed as INSERT or UPDATE. All works well in the workspace, and a manual / visual comparison between Workbench and the Oracle table conclud
Hallo FME enthusiast, I am trying to create a 2D overview map from 3D roofs (OuterEaves).What is the goal?The goal is to create a 2D view map from the top and those areas below should show the area in 2D, which seen are from the top and the highest Areas should stay on top.What attributes do I have for the roof surfaces?-ID of the building-xyz coordinates of the OuterEaves But I fail because of the intersection of the roof surfaces. The 3D data set is not 100% cleanly created and therefore I have up to 10 overlaps of the roof surfaces to each other or even within themselves.My question to you: What is the easiest way to clean up these overlaps in 3D space so that I get my result? King regards,Michael
i was reading on FME Form Advanced module, in Generic writing sectionand it has this part that mentioned : When you use the Generic Writer, it is sometimes helpful to pre-configure parameters specific to individual output formats. For example, you must specify a seed file to write a Bentley MicroStation Design file.To do this, add a writer to a workspace. This step causes Workbench to think that there is more than one output format and forces Workbench to create a Multiwriter for the workspace. The first writer in the multi-writer will be the Generic writer, and this one should have all the output feature types. The second writer will have no feature types but will be used to communicate any format-specific writer settings to the Generic writer when FME users that format for the Generic writer.Suppose you configure the Generic writer to write to a format requiring a filename as a dataset. In that case, the Generic writer will turn the output folder into a filename by appending a file e
Hi,I would like to setup a FeatureReader to read all the XML files in a onedrive folder. My OneDrive (graph) connection works and I’m able to view the contents of my folder. I am able to select individual files to read in the FeatureReader parameters but I want to be able to read all XML files. How would I go about accomplishing this? Thanks in advance.
Hello everyone,How can I place my points on a terrain model?I don't have Z values for the points I have, but I have a rester data in Tiff format, how can I place my points on this terrain?
Herkese merhaba3B ağaç verilerim yatay görünüyor, onları nasıl dik konuma getirebilirim? (döndürücü ve 3d döndürücü) Bu iki aracı birçok kez denedim ama işe yaramadı. Bu durumu nasıl çözebilirim?
Hello everyoneI have data in shp and obj format. I have a tree model in obj format, I want to assign it to points in shp format, then I want to export it as cesium 3d tiles, can you please help me with this? I tried this method with GeometryInstantiator, but I think I am doing something wrong
Hello,Is there any way to assign Index “Primary key” to the field and Type “serial” somehow in another way rather than in Feature writer - User attributes? These options are not present in AttributeManager transformer, unfortunately. That would help me to reduce number of manual adjustments and use “Automatic” attribute definition. Because I have many FeatureWriter transformers in my workspace and I need to replicate it to read another data.
In the above image, I read a text file that contains lines of data where specific lines that start with an ID relate to different features.In the #1 category it contains the projection information but I want to be able to set the projection of the other output ports based in the information in that line.How do I hold and set the projection of the Lines, Points, etc?I was thinking that I may just need to read the text file twice, once to get the projection from Port #1 and then have a feature reader that can then set the projection before processing the other output ports.Is there a more efficient way of doing it?
Hello.I have a JSON file the looks roughly like this, containing a list of un-named values:{ [ { “UniqueID”:123446, “Dealership”:”Dan’s Dodge”, “Owner”:”Dan”, “BestSelling”: [ “blue”, “red”, “blue”, ... “red” ] ... “Telephone”:”411” }, ... ]}My first JSONFragmenter feeds two workflows: the first workflow captures the named values (including “UniqueID”), and the second workflow immediately discards everything but “UniqueID” and the JSON from the first JSONFragmenter and then uses a JSONFragmenter to turn the JSON list into Features. Finally, a FeatureJoiner that adds to each newly-minted Feature an Attribute containing the appropriate name for its unnamed value. Now it’s time to FeatureMerge the new Attributes back into the first workflow by matching on “UniqueID”.Alas, the newly-assigned names are stored in the same Attribute of each JSON-list Feature. So, after FeatureMerger merges the first Feature,
I want to Run FME process through task schedeuler. The fme workspace is reading data through postgresql. I am able to run it through any specified user. I want to run this through LOCAL SERVICE in Task scheduler.But it is showing error. My 0objective is the process become independent of user Error connecting to PostgreSQL database(host='', port='', dbname='abc', user='', password='***'): 'fe_sendauth: no password supplied Thanks