Transformers

Hello all, I have a DWG file that has distance labels (text) and lines that I need to attach the text to. I have figured out, mostly through assistance through this forum (thank you), how to get the closest features to match but what I am having trouble with is where the text label is not the closest feature. I have used the Neighbor Finder and then a feature merger but for the ones that don't merge I want to be able to do a second test to look through the list of the other lines that are in the closest lines list. I have done this by using a List Exploder, followed by a length calculator and then a tester. My issue is that if I have found the closest 5 features to the label and the test is successful on one of them, how do I ignore the other four in the test? In some cases no matches will be found, so in this case I need to keep the failed record. Any assistance or guidance into how to do this better is very much appreciated. Thanks Dean

i am trying to clip a shapefile using a polyline and / or a polygon and the clipper keeps failing by saying that the "clipper outputs a rejected feature"

I'm trying to rename .wld files to .jpw after an image has been processed but the following dos command is not working. Any idea?

I'm posting a new question since part of my question was answered. The workbench uses published parameters for selecting the files to input $(SourceDataset_DGN or DWG). There is a feature reader for dwg and a feature reader for dgn, each pointing to the correct dataset. In both feature readers, the <Generic> port attributes to expose are: $(SourceDataset_DGN or DWG), $(Project) typed in as a parameter, fme_feature_type, fme_basename_, fme_text_string, fme_dataset, and fme_geometry. All seven attribute fields are created but only fme_feature_type and fme_text_string are populated with data, all of the other fields (except geometry which I get) show "missing". I am getting the fme_dataset for the DGN reader but not anything else. Takashi recommended a FileNamePartExtractor transformer after the DWG reader but still nothing. I think nothing else is populating because there is a problem with converting the parameter information since not even the $SourceDataset has any information. It crea

we have 12 tables with about 400,000 records so i want to know if I can create 4 new fields; Lat, Long, and both Spatial SQL fields from the current UTM zone 13 Nad83 data. New user, so the help posts I have ready don't directly answer this question and I am still trying to learn how to create the new fields. Can I do this in one project, or does this become a multi project for each table? If not to much to ask, can you give me the functions in order for this? I can supply data if that will help also.

I've got some .KAP files which are missing spatial data and as such, I cannot convert them into something more useful like a .TIF image. I've been using FME which errors on these files with "Failed to specify the feature index as constraints on the reader". Has anyone come across this and found a solution? At this point, i'm happy just to convert to a non-spatial image format.

I have flattened some JSON and it now shows as a separate feature for each object. This is the JSON And this is it flattened from the JSONFlattener I want to get the json_index to be the attribute header and the _response_body to be the feature attribute. These are the settings I currently have for the JSONFlattener. Any assistance on this would be great. I am in unfamiliar territory with JSON. Thanks

I have an attribute containing multiline text where an arbitrary block of lines are repeated near the end of the data. I can't just remove duplicate lines, as an individual line might be have legitimate duplicates. In the below example lines 2 and 15 are identical, but are correct, whereas the block of lines 17-23 are a repetition of lines 10-16, and need to be removed. The number of lines that are repeated varies, but there will always be at least one, and will include the last REV line before the footer. The footer data varies in length and content, but will never include a line beginning with REV. SITE 1REV 10-1PREV 10-3DSITE 2REV 20-3V3REV 20-3V4REV 20-3V5REV 20-3V6REV 20-3WREV 20-3XREV 20-3X4REV 20-3X5REV 20-3X6SITE 3REV 10-1PREV 10-1P1REV 20-3XREV 20-3X4REV 20-3X5REV 20-3X6SITE 3REV 10-1PREV 10-1P1Footer Data Here The data is not in a text file that can be read bottom up, though I suppose if required it could be written to one and read back in

Hi! First question up here for me :) I have a Dataset with 137k timestamped points (over 1000 trajectories belonging to 160 individuals). Now I want to figure out, what percentage of each path is unique (I define unique as >80m away from any other path). So first i created lines from my csv-file with the coordinates of the trips, then i used Linebuilder to create a line for each trip and added a buffer of 80m. Now I wanted to use this geometry as the filter in SpatialFilter, with the point dataset as Candidates. The Problem is though, that I want to compare each point ONLY with the Trips(buffered lines) of the same Individual, except the Trip with the same TripID, because otherwise they woul all intersect. Can anyone of you help with an idea to create these conditions before feeding the data into SpatialFilter? Here is my workspace so far.

Hello FME users, I have a set of lines that make up a polygon. I need to determine which side(left or right) of the line is "looking" outside of the polygon. Lines are not oriented the same, end point of one is not always a start point of next line and so on. LeftRightSpatialCalculator can't do the job because I don't have anything to Candidate. Thank you in advance. Milos

Hello all, I am looking for some suggestions on the best way to create a summary table that can be used in the HTML Report Generator. The overall scenario is that we have an AutoCAD file coming into FME and various parts of the data are being validated and reported on. What I am trying to get it something like the following: Object Passed Failed Total Roads 10 3 13 Distance 15 1 16 Area 5 2 7 Thanks Dean

Hi Team, I have a folder structure with thousands of DWG files in multiple sub folders. Excuse the naming convention, its purely indicative.Currently as below, all the DWG files reside inside the DWG folder. I am trying to create the following, In the current workspace I have a Directory and File and Pathnames reader to FileCopy Writer The reader reads the "TESTIN" Folder with "Recurse into subfolders" as the checked option, running a path filter of "*.dwg" I have an Attribute Manager translator to assign 'Path_windows' and "Path_filename" to the writer. Currently the writer output location is set to the same Root level "TESTIN" folder using the "SourceDataset_PATH" parameter (which is default), with the fanout expression of "_PLANS\\DWG"This result obviously searches all the folders for the .dwg extension and then copies them all to the TESTIN\\_PLANS\\DWG folder that is created by the fan out expression. My question is, How do I get it to produce the output directories in each subfol

Hi all I am quite new to FME workbench and I am temporarily working for LOD2 process. I have already made LOD1 containing footprints and heights and I converted the models found in 3D warehouse into GML files. So the what should I do to use the gml models to take the place to cubs of LOD1 with matched ID? Thank you in advance.

Can anyone show me how I can calculate the number of unique values within the list of each record using Python? For example, what is the count of "Primary" or "Repair"? I know that I can do this easily by exploding the list and go from there. But since I have over 1mil lists, I think the best way to do it is to take advantage of Python to improve performance. Thanks in advance!

@takashi Hi I have a DESIGN_DATETIME field in SQL Server and an example of its value is 23/06/2019 11:21:01 I am trying to use TestFilter to return only records with timestample in the last 48 hours (i.e. 2 days) The following doesn't seem to work. I am using FME 2018 DESIGN_DATETIME >= @DateTimeAdd(@DateTimeNow(),-P2D) Any suggestion?

Hi All, I'm new to translating rasters and i'm looking at doing a simple translation from GeoTiff to ASCII grid data. The Geotiff is a simple single band DSM with REAL32 datatype. I've created a workbench that has the Geotiff as the reader and ASCII as the writer. I am also clipping the original Geotiff, so I've got a clipper in there as well. However, when I run this I get an error 'ESRIASCIIGRID writer: Failed to obtain raster from feature. Only features with raster geometry are expected'. I was kind of expecting something along these lines, because I suspected you need to extract the height info from the band before converting it to ASCII. How do you do this please? Thanks Dave

I have a predicament where I need to read a .txt file containing a list of reference numbers (example attached) . The file is dropped by a supplier onto our SFTP. The file usually contains customer information and therefore I don't want to store that file in a different format (e.g. csv) and read from it. I figured that I could just use the ListBuilder to create a List from the Attribute that the file contents is stored in. However, this does not appear to work - I'm still getting a single attribute value containing the contents in the inspector. Can anybody think of anything or am I just going to have to temporarily store, re-read and then delete the file?

Hi all, Does anyone know of an easy method to create a polygon around part of a LiDAR tile where the LiDAR tile does not have a complete set of values or is not complete? So in the example below I would like to create a polygon around the colored sections (crudely drawn in red), not the whole tile. I have tried the RasterExtentsCoercer, but that just creates a polygon over the whole tile. Thanks all.

Hello, I have two polygon layers: Layer 1 contains approx 2500 polygons some of which overlap with each other. Layer 2 contains approx 150,000 polygons which have been clipped so that all features are inside at least one Layer 1 polygon. I would like to intersect the Layer 2 features so that they are given the attributes (essentially a polygon ID) of the Layer 1 polygon that they fall within, and if a polygon falls within a Layer 1 overlap then two new polygons are created, one for each Layer 1 polygon it fell within. I thought that AreaOnAreaOverlayer would achieve this but when two Layer 1 polygons overlap it only outputs a single Layer 2 polygon (I don't know how it decides which attribute to give it). Perhaps Intersector would be a more appropriate Transformer to use (and it is the equivalent tool that I would use in ArcMap). I don't know. Although I'm getting an error when trying that Transformer which would need to be addressed outside the focus of this question. Both layers are

Hello, I would like to know if the "Lambert Mexico WGS84 (cm)" coordinate system exists in FME. Attachment definition If it does not exist in FME, how can I create the system and add it to FME? Thanks so much

I have a MapInfo file representing annotation from Cad data. When I open up the file MapInfo reads it the layer as line feature. Is there a way to convert this line object layer to texte (annotation) using FME? Thanks,

I created a space in revit.Then using FMEWorkbench I translate my model into citygml and then convert it to Geodatabase and use it on Arcgis. I used the model proposed here: BIM to GIS (Intermediate) | IFC LOD 300 to LOD 4 CityGML. The result is that I have the Room class as a table and I do not have the space displayed on Arcgis. The space is represented as a Table, not as a geometry. how should I do to have space as a result.

Dear all, I'm quite new with FME and I'm facing my first issue on my workspace. I would like to retrieve a BLOB from an Oracle DB. This BLOB contains a ZIP file of a DXF file. I would like to read this DXF file with autocad_extended attributes. Currently, I'm stuck at this point: I read the BLOB, I create an attribute (for future transformations), write the file on the file system and extract the zip file. Now, how can I read the DXF file extracted from ZIP with autocad_extended attributes? Thank you for the support! Best Regards, Michele

Hello, I'm relatively new to FME so apologies if this is a simple question. My data includes dates with the earliest being 2006 and the latest being 2019. My aim is to filter this to only include the oldest 6 years worth of dates (however, this is subject to change as the data is updated so it needs to be a fluid filter). I would like to further split this data into each separate year. I have tried using the fanout expression but I'm not entirely sure how to format this. When I tried this it also didn't seem to output all the dates per year. Is there a transformer that would be best for this task? Thanks very much

Hello, I'm new at FME and I can't the way to solve this problem. I have a dataset like this:OONNNEEEESSSSOVALUE123123456431678845221SS445765976455566678763NE I want to get, for each row, the column name where there is maximum value. Thanks.