Using transformers to modify data.
Recently active
I have a set of touching polygons representing physical spaces and lines representing the doors on the polygon boundaries dividing the spaces. I want to dissolve only the polygons that aren't separated by a door. Not sure how to group the corresponding shapes. The doors are only a small segment of the boundary.
Is there a way to create a transposed table in the MSWordStyler? I'd like to have attribute names in column 1 vs. attribute values in column 2 like this:So far I only managed to create a table like this:The horizontal presentation isn't really useful for Word documents, especially when listing lots of attribute values.I've tried creating several individual tables that I concatenate when writing but there will always be a line break between them. I've also had a look at the msword_table_col_header{0} and msword_table_col_value{0} format attributes but it looks like they don't allow for more than one row either.Is there a solution?
Hi,I am trying to overlay 7118 points on 3 lines using the PointOnLineOverlayer transformer.Every time I run the the workbench, it crashes with a FME EXE has stopped working error message at the point in the log where it says: "Creating spatial index of 1787 point featuresCompleted spatial index creation".I have tried the workbench in both FME 2016 and FME 2017.0 Desktop versions, and I get the same issue.Anyone know what could be causing this?Thanks,
Hello. Looking for some suggestions on how to fix geometries. These unnecessary vertices are the result of import from MicroStation cadastral based DGN files. The unwanted vertices are on a cadastral grid line.First case, lines with extra vertex that should be removed:Second case:2 line segments that should be merged, assuming they are colinear. Would need a test for that, right? In the screenshot below, the short segment south of the green highlighted segment should be merged with the green highlighted segment and defined by 2 points (again, assuming they are colinear).Third case: polygons with extra vertices like in the line segments. Pt 4 (and others at cadastral grid lines) should be remove (assuming colinear segments):There are ~25000 lines affected and and similar number of various polygon features.Thank you for any direction!!
Hello all,I am trying to add one UUID for each CAD file entering the workbench. Is there a way to set a parameter so when a new filename enters the workbench, each feature with the same filename receives the same UUID character? I have tried using a the filenameextractor followed by the attributecreator and using the @uuid() function as the new attribute value. But that just gives each feature a different UUID instead of the same. Any assistance would be appreciated.Thanks,David
Hi,I think FME does not treat some arc during transformation.I have a polygon in a dwg containing a long arc:What i see in acad:What i see in FME Data inspector: the main problem is that some function like spatial relator (IE: "Requestor is within supplier") don't see the circle in the polygon.In acad, all my circle are inside other polygon, here is what spatial relator see, the highlighted circles are misinterpreted.If i use a dwg writer to ouput data, the arc seems correct in acadIf i use a shape writer to ouput date, the arc is like the one in FME data inspector.I attached the minimal workbench and dwg to this post.Any hint?David
I want to run the workspace by command line. But my workspace don´t have source dataset and output dataset. I´m using just creator and HttpCaller for download the zip file.I haven´t experience to run workspace by command line. I was created the batch file like this:fme.exe C:\\Users\\FME\\Desktop\\Workspace\\download.fmw LOG_FILENAME c:\\fme.log But nothing happens..:(
Hello,I want to to use the NetworkTopologyBuildrer. However, this transformer requires that the network must be topologically noded. How can this be achieved in FME ? Thank you very much
Table of attributes I want to merge with Group By: FILENAMEInputAggregatorOutputDesire
Is it possible to alter a workspace's output before it is zipped and made available for download through the data download service? Specifically, I'd like to output a shapefile, then alter the .prj file using a python shutdown script. All of this before being made available to the user as a zipped download.
Hello. I have face type geometry planes in 3D space. I would like to split them at intersections. It's trivial task in 3D modeling software like SketchUp, but I'm not able to do this in FME. I can't find solution in existing forum posts or other online resources. Any help would be appreciated :)
I am trying to create a Private Parameter Value from an Attribute Value. What I Have is a SQLCreator that is pulling two columns from a table. ROUTE_ID SYSTEM_CODEThe SQLCreator is using a Published Parameter to query out the data associated the user defined SYSTEM_CODE. What I want to do is assign a Private parameter from that result as the ROUTE_ID value. This would allow me to run other queries based on the Route_ID which is a unique number.
Hello,Here is my issue : I have a feature containing buildings, with a height value. By merging the buildings and extracting holes, I get another feature which represents inner courtyards. Courtyards have a unique ID. I want to get the minimum height of buildings touching each courtyard. I tried to use a SpatialRelator combined with a StatisticsCalculator (grouping by courtyard ID) :(not the real workbench, which is quite a mess, but this is close enough) But I get an issue : the SpatialRelator only seems to compute an output for one building and one courtyard. So when a buildling touches several courtyards, it is only used once to determine minimum heights. Here is an exemple, height are displayed on buildings, and computed min height on courtyards :As you can see, the building north-west to the wrong courtyard min value is not taken into account, as it migth be used for the elongated courtyard which also is adjacent to the building. Am I being clear enough ? And do you think of any
I have a dataset of bridges and I have a road network. I want to create reroutes for each bridge. So I want to clip the bridge part out of the roads to use the shortestPathfinder to get the new route . But I want to send the bridges one by one to this process. I got the workspace working as I want as long as I use just one feature but I need the to do the calculations on all the bridges, but one at a time. I´m really stuck on this one...
Hello, guess this question has been asked here many times, however I still struggle with finding a good answer. Basically what is happening: this is a table that shows records all possible values of all possible attributes, from all possible objects. However I need to create a table, where column names will be values from the column 'attribute', where each row will be singular object. Real table has much more columns, this is just an extract. Resulting table should have one row per 'object_id', attributes created from 'attribute' column and the attributes created should be filled with values from 'value' column. There are going to be a lot of attributes created, not each of those objects has all of those attributes. Any help is really appreciated. Radek
I´m using this comand: cd / "C:\\Program Files (x86)\\WinRAR\\Rar.exe" x-y "@Value(_response_file_path)"The file is downloaded correctly but the unzip process don´t work properly.Thank´s
Hi, I'm trying the FME Trial to convert a JSON file to an ESRI Shapefile, but I'm having issues with the conversion.The JSON file contains 354 polygons, and each polygon has a list of information (features?).How to configure the Readers and Writers to perform this task well? Thanks a lot!
I have a set of points that have no order of collection and I need to connect them together to form a polyline. I have been working with the neighbor finder transformer, but having some issues coming up with the best way to have them drawn correctly. I'm thinking I might need to designate a start point and then remove each point from a list that was previously used to connect? What I would like to achieve is one polyline connected from PT4 - PT1 - PT3 - PT2. Any ideas on a good way to achieve this result? The example below is just a sample, as the full job would contain hundreds of points that need connecting and are all out of order, so I can't use the line builder.
Is there something wrong with the Inspector? Here is the layer(s): http://cmnmaps.ca/mapguide/mapagent/mapagent.fcgi?REQUEST=GETCAPABILITIES&SERVICE;=WMS&VERSION;=1.3.0& The BC Mines Layer works with Gaia but the others don't for some reason. I am using FME desktop 2018 thanks
I use FeatureMerger with Requestor and Supplier having 1:m relationship. The FeatureMerger gives me "merged" features with an attribute, which is a list of values fromthe matched supplier. How to check a list of values for an attribute before moving to next feature?I don't want to use ListExploder afterwards.
I'm using the RasterMosaicker to create a series of mosaics through zoom levels. This involves sorting rasters corresponding to their scale, so the largest-scale raster always sits at the top. To get the RasterMosaicker to recognise this, I've set Data Values > Overlapping values: Last.The rasters therefore are sent in to the Mosaicker from smallest-scale (e.g. 1:1000000) to largest-scale (e.g. 1:5000) and the last data point where there are overlaps will always trump.This works fine, except I noticed that as I went to higher zoom levels the resolution was appalling, and much lower than my larger-scale maps. I investigated and found in this Scenario: "the first image to hit the RasterMosaicker, defines the spacing of the output raster. If the RasterMosaicker is allowed to do the resampling, the resolution output may be undesirable."So, it seems that if I could sort my maps so that the largest-scale came first, the RasterMosaicker resolution would be right. However,
Please help and aattributes
I have a points in shape files and radius information in attribute. Ho to create buffer polygon in new shapefile?
Hello...by default the FMEServer-URL is <server>:<port>/fmeserver. Is there a way to change this URL to lets say <server>:<port>/apps/fmeserver?Thanks in advance for any hints :-)
Hello. I'm having trouble running a sample translation with Windows Task Scheduler. Ultimately I will need to run multiple translations on weekends.I'm using a .BAT file with the following text only: FME C:\\Users\\ ...[[truncated]]... \\Scaler_Test.fmwThe batch file runs in CMD with the above text only, and the translation is successful. When running this with Task Scheduler, the translation fails and the log is as follows (portion):...2018-07-30 10:10:00| 0.2| 0.1|INFORM|Creating writer for format: NULL (Nothing) 2018-07-30 10:10:00| 0.2| 0.0|INFORM|Trying to find a DYNAMIC plugin for writer named `NULL' 2018-07-30 10:10:00| 0.2| 0.0|INFORM|Loaded module 'NULL' from file 'C:\\Program Files\\FME\\plugins/NULL.dll' 2018-07-30 10:10:00| 0.2| 0.0|INFORM|FME API version of module 'NULL' matches current internal version (3.8 20180209) 2018-07-30 10:10:00| 0.2| 0.0|INFORM|Creating reader for format: 2018-07-30 10:10:00| 0.2| 0.0|INFORM|