Transformers

Hi all, I have an oracle SDO geometry table containing multiline features. These features should be contiguous collections of point-pairs. i.e. all endpoints should touch another point-pair from the same feature. the features can form a string of point pairs ('~'), but also a 'Y' type of topology, or something more complex. However, the feature should not consist of sub-parts that are not connected to each other (e.g. '~ ~' ).How can I test for this requirement to be met ?I think I should somehow be able to count what Oracle calls the parts of the multiline object, but it is not clear to me if I can call these oracle constructs from FME, or what FME equivalent to use. Can you point me to some example or helpful bit of information for this type of tests in FME ?Regards, Ronald

Hello,I am trying to insert vertices at the end of lines, using the vertexcreator and 'insert point at index'.To do this I am using -1 for the index, but this adding the vertex at the point one before last (see image). How can I get the extra vertex to be at the end?Thanks, Owen

Hi, I'm executing the following queryselect 'PT' as TEST, sdo_geometry (2001, 9999999, sdo_point_type(1673919.702, 513986.296, NULL), NULL,NULL) as geom from dual;which returns (in sql developper) a geom value of MDSYS.SDO_GEOMETRY(2001, 9999999, MDSYS.SDO_POINT_TYPE(1673919.702, 513986.296, NULL), NULL, NULL)How can I add such query in sql executor so that the field geom will be considered as the geometry of the feature?  Rigth now there is no 'geometry' in the inspector   Thanks

I have two line datasets. Dataset A was created by using the snipper on dataset B (attributes BeginMeasure and EndMeasure), resulting in 15 segments in dataset A. They are both saved in SDE. Now I want to use the LineOnLineOverlayer to segment dataset B (only 1 segment before segmentation). I would expect that there will be 15 segments with _overlap = 2, and attributes from dataset A at each segment. Except that is not what is happening. There are only 10 segments with _overlap = 2, the rest are 1, which indicates that the two datasets do not overlap completely which is weird since A was created by B. I'm attaching the ffs for each dataset as well as the result ffs. What is going on and how do I fix?

Hello,I am starting using FME Workbench and it's amazing!A quick question as I can't manage to achieve what I would like.Basically I am starting with 2 features, Airports and Runaways. I have a OneToMany relations between those 2 features.What I would like to do is in that my final GEOJson looks like bellow, meaning that the list of my runaways with their properties + geometry if needed are nested into the Airport feature.I managed well using InlineQuerier to have the data I need and execute the join I need the thing I don't know is what is the flow to build properly the GEOJson as I want. { "type" : "FeatureCollection", "name" : "Airports", "features" : [ { "type" : "Feature", "geometry" : null, "properties" : { "someAirportProperty" : "someAirportValue", "runaways": [ { "someRunawayProperty": "someRunawayValue" } ] } }, ]}

I have a workspace that can generate a table with permutations of rows = 1 to x and rows = 1 to x to possibly create table variations from 1x1 up to at most 10x10 (see pictures). I'm looking for suggestions on how I can create images out of the table created. I'd like to see the format similar to the picture I attached. My 3rd sample is a 12x12. I'm using this pictures for a underground conduit inspection form. Sequence as well as matching picture matter to the users. Attached is my workspace to generate each table. I'd love to be able to create all 100 pictures using one workspace.

I have several hundred TIFFs that I want to load in to a File Geodatabase (FGDB) raster mosaic. ArcGIS allows you to load one image, then mosaic additional images into the same raster. I'm trying to do this with FME.So far, I have tried the following:1) RasterMosaicker, but that seems to create the mosaic in memory or temp before writing one huge raster to the FGDB.2) Read several TIFFs (e.g. select 2 TIFFs or specify *.tif in the Reader) and send to the same FGDB raster dataset (i.e. no fanout on the Writer) with Drop Table set to "No" for obvious reasons. This loads the first image then fails on the second with "ERROR |Failed to write raster data tile when writing to raster dataset 'TIFF2'. The error number from ArcObjects is: '-2147467259'".3) Using the Path Reader to get the TIFF names, then sending these 1 at a time to a second Workspace using the WorkspaceRunner (Wait for Job to Complete = Yes). The second Workspace loads the TIFF into

FME People, I'm trying to limit the number of source values I use in the AttributeValueMapper by using the following statement as my Source Value: @Value(LAYERTYPE) Ends With _Wd, In other words I have many different attribute values ending with "_Wd" and I want to reassign all of the those to one new value. The destination attribute ends up being an empty value. I moving data from SDE (oracle) to a file geodatabase.Gary

Can we write Xattributes to dgn elements in Bentley V8i Select Series 3 ?

Hi there,I have a table (lets call it TableA) which contains a field (lets call it Types). I need to compare each value in the Types field with ALL of the values in another field (lets call it OriginalTypes) which is in another table (lets call it TableB). If there is a match a value gets updated, if not nothing happens. Currently I have these 2 tables feeding AttributeManager which has a Condition Statement checking if Types In OriginalTypes but this is not producing my expected results. Any thoughts on what I am doing wrong here or what might be a better approach?Regards

I want to extract XFM data from the attached dgn file. I have tried using the Bentley Map V8XFM reader in both FME 2017 & 2018, but am unable to do so. I have exposed the igds_xfm* attributes as well. Is there a way out ?

I have a SystemCaller that simply deletes a file. I would assume if the deletion is successful, it would give code 0, otherwise 1. However, it always gives 0 whether the deletion is successful or not (for example, I keep the file open before hand to cause the deletion to fail). Any workaround? I could use PythonCaller to do the deletion and generate an exit code, but would be nice just do this simple operation in the SystemCaller.

Just want to convert from string containing fractional numbers (e.g., 4 1/2 2 7/8...to decimal doubles 4.52.875...Anyway to not use multiple transformers for this? ( I know I can separate the fraction from the whole number, then value map the fractional segment to decimal segments, and then patch the number back together via concatenation...). However, I thought I'd check to see if I'm missing something less bulky.Many thanks, Pete

I have a raster dataset stored in a file geodatabase and when I read this into a workbench the nodata bit masks for each band are merged into a single additional alpha band named geodb_nodata as default and stated in the help documentation.When I view the grid in the inspector Band 0 contains data values and a value of 0 or -3.40282e+38 for nodata cells. Band 1 (ALPHA8): geodb_nodata contains a value of 0 for nodata and 255 for cells containing data. My question is how can I set the values in Band 0 as nodata using Band 1 (ALPHA8)? I assume it's a combination of using the RasterSelector with the RasterBandNodataSetter transformers, but no combination has worked for me so far.Specifically, I want to set the values in Band 0 to nodata using Band 1 and then sending the output to a RasterCellCoercer transformer to create points for all raster cells containing a value i.e. excluding nodata cells.Thanks

Hi there,I'm exporting rvz files to a esri file geodatabase. When I want to open the multipatches in ArcGIS pro I have to adjust the elevation to make the features visible. In Revit it is possible to built storey /levels and give them a height or elevation value. How can I transfer Z-values to arcGIS and use them as an attribute field for the elevation source?  Thank you. I hope my question makes sense.

I am using FME to convert ESRI Raster Dataset orthophotos to an .ecw file and there are some very ugly black pixels added to the border.

Im simply trying to get fme to use FileCopy (so that I can copy csv files inside a large zip file (about 4 gigs)) to a network folder. I only used a reader with format set to CSV, dataset set to the path of the zip file, and workflow options set to Individual (connected to filecopy writer). Are there any issues with fme and large zip files? Is there a better method to extracting a specific file type from the zip than what I used? Thanks for any help--latest error states: "failed to open file. failed to get any schema from reader". i am able to manually use filezila or 7 zip and perform this

Hi All,  I'm working with 3D solids (buildings) and sometimes they are made up of surfaces from which the orientation (order of the vertices) is not the way I would expect them to be. This causes that for some of the surface I'm looking at the 'inner' side in stead of the 'outern' side when visualising them.  Is there a good approach to  1) detect these "wrongly oriented" surfaces 2) correct these "wrongly oriented" surfaces ?  (The SurfaceReverser can turn all orders of all the vertices for solids, (making inside outside and vice versa) but that is not what I'm looking for)  Thanks

Hello all,I have two questions. 1- Is it possible to replace regex with a regex? For example, I want to add a dot after every numeric value before any letter.  StringBeforeAfter 1 7 St7. Street21 Av1. Avenue@ReplaceRegEx(@Value(POI_NEW_NAME),^\d\s\w,^\d\.s\w,))Search: ^\d\s\wReplace: ^\d\.\s\w2- I have different variations which I need to manipulate. Is there any possibility to use different expressions in a text editor of an AttributeManager? I tried to use "|" symbol for this purpose but it didn't work.@ReplaceRegEx(@Value(POI_NEW_NAME),^\d\s\w,^\d\.s\w,))|@ReplaceRegEx(@Value(POI_NEW_NAME),\d$,$\d\.))Sorry, if it's a duplicate question but I couldn't find a similar case.Thank you

I want to aggregate or dissolve a set of input polygons based on 3 fields - Authority, Category, Site_Name. So where these values are the same, there should be one output feature. If the polygons are not adjacent, a muti-part feature should be output (File Geodatabase). If they are adjacent, then I expect them to be merged. However this is not happening. I've tried both Aggregator and Dissolver, individually and together. The boundaries may not be shared, but I believe the polygons overlap, so why aren't they being merged?In the attached image, the blue fill is the input, and the hatching is the aggregated/dissolved polygons.Also, there are 2 blue polygons on top of each other in the middle, but in the output there's no polygon visible.

I would like to ask how can I filter data by using Tester consider condition:ATTRIBUTE_ABC - contains - "max. 1" or ATTRIBUTE_ABC - contains - "max. 2" or "max. 3" etc.how can I generalize Tester by substituting number 1, 2 or 3... to don't build x number of testers.

Hi, In the attached workspace I am having issues with the spatial filter and attribute pivoter transformers.With the spatial filter, I am trying to output from the buildings Mapinfo table reader, the buildings that intersect the filter layer, comprised of buffers for different simulations. In the attributepivoter transformer, I am trying to show a count of flood vol, separated into columns for sim (there should be six simulation columns), for each propref (row).There should be numerous proprefs where there are flood vol values for more than one sim, I am struggling to recreate this. Also struggling to bring through all six sims as columns. Any ideas how to restructure this?Thanks

As per Bentley, XML attributes are stored in Xattributes. Does FME support these attributes ? I am using FME 2018.

Firstly, yes I know that there are already answers regarding measuring points along lines, but trust me I've read them on here, and I'm still not getting an answer. So I'm clearly doing something wrong.Ok, so I have a series of 3d points (recording x,y,z) as a shapefile. These all occur along a single line of section. I also have that line of section as a polyline shapefile. All I need to do is measure each point from the start of the line.It "should" be easy, I'm sure of that. But I've tried all the ideas posted by people like @takashi and I still have no joy.My setup so far is -A reader for each shapefile (one point, one polyline), PointOnLineOverlayer, into a MeasuresGenerator then a MeasuresExtractor. But I get no measurements output. You're help would be much appreciated.Steve T

Does anybody know if it's possible to use a dwg template with a block and then set parameters in FME so the block is 3D-rotated in the resulting dwg-file?