Transformers

Hi,I have troubles using UpdateDetector (FME 2018) and/or ChangeDetector (FME 2019).First, I join an xml file containing projects with a ESRI Feature Class containing land parcels using FeatureJoiner (joined on parcels ID). Result is an Esri SDE Feature Class showing only the parcels with projects from in the xml-files, including project information from the xml-files for each parcel. Xml-files will be regularly updated, and the FC must be updated consequently. Parcels geometry is not changing and doesn’t need to be compared. First, I tried UpdateDetector in FME 2018 to compare the output of FeatureJoiner with the sde fc (I use it both a reader and writer). It kind of work but the parcels with unchanged project attributes go through ‘updated’ and are rewritten/updated on the fc instead of stopping in ‘unchanged’. But either UpdateDetector ‘inserted’ and ‘deleted’ works and the end results is correct but I do not want that unchanged parcels/data are being replaced. I tried the new Chan

I clip a PointCloud with some rectangle (after I used a PointCloudThinner) and send the clipped result into a TINGenerator.What I get for some features is an Error which breaks my translation.Reason seems clear to me, because in one example I have a row of 9 points on a straight line and there is no way to calculate a TIN from this input.My problem: TINGenerator doesn't have a Rejected port and how should I know in advance which features will break the translation ?GeometryValidator doesn't seem to have a useful option for this kind of check ?

Hi, I have an issue whereby the datetime formats are coming out incorrectly.I have a number of scripts that read json formats directly from a couchbase database, and spits them out in human readable excel format, using the FileNamePartExtrator transformer. It all works great except for the inspection and submission times. They seem to be getting mangled. I am 6 hours behind UTC, but the FME reader is already altering the timestamps before doing anything to it (I checked this in the reader preview). For example, I have a correct inspection timestamp in the database that reads 15:58:13 but it is getting populated in the output spreadsheet as 09:58:13It is being read in as timestamp format and being outputted as datetime format. I would just like to have them outputted in the same time that they are getting read and stop FME from changing them without my permission. I have tried various date & time formats in the output writer to convert them back but nothing seems to work, for exampl

Hello Team,Present i am working on the FME Version: FME(R) 2015.1.1.0 (20150715 - Build 15515 - WIN64). I could able to zip a downloaded file through HTTPcaller by using feature reader and single writer(text file) in independent workspace. Selected output as compressed Zipoutput in the writer parameters.But when i did the same thing with my master workspace which is having a custom transformers and ArcSDE writer at that time i am getting output as text file with the .zip extension which is not compressed. I assume that output just updated with .zip extension and it got corrupted. Can somebody help me to resolve the issue?? Thanks..Nagendra

Hello Team,I have archived a .jxl using ZipArchiver, After zipping the required file can we delete input file from source location.Thanks,Nagendra

Hi FME Community!My goal is to construct CityGML Terrain model (dem:TINRelief) from really accurate TIN data created with 3D modeling software.I have found certain ways to construct CityGML Terrain with FME but it always starts with generating TIN surface with the TINGenerator. I don't want to construct TIN again in FME environment. Because if I do so, the TIN is not anymore as accurate as it was in the beginning. Is there any other way to get CityGML Terrain model than generating TIN again with FME?

I have to associate a simple progressive number (from 1 to the number of rows of my data). The Counter Transformer gives me back strange results: one time only even numbers, another only odd numbers and other times one every four (0,4,8,12,...).I tried using the Arithmetic Editor in the AttributeManager but it produces the same error. How can I solve the problem?Thank you!

Hi Experts,I am working on FME 2019.0. I have to find the dead ends from a huge road network (without geometry). I have to take only associations into consideration.There are two columns jun_id_to and jun_id_from for each road. The value that comes just once in jun_id_to or jun_to_from both would be the dead-ending road. A small illustration about how the road network would look like and the association table is below:Road geometry:Attributes:I tried using StatisticalCalculator, but, I am not sure if it can tell the count of each character in both the columns. Also, FeatureMerger with jun_id_to and jun_id_from merge doesn't give the required output. I think Lists might work in this case but not sure how.Any ideas?Thanks.

I have a process inside a PythonCaller that converts a long pandas dataframe into a wide dataframe that when output, has around 200 columns. The dataframes are transformed back into an fme feature for output. Now I need to expose all 200 column names but need to avoid doing this manually. Is there any way to do this from within the PythonCaller?

Hi,I need help with transponsing the data in the attached "Input" tab to the data in the "Output" tab.Each row transposed to columns grouped by "f.WorkOrderEquipmentRef.0"-"f.WorkOrderMstNo.0" - e.g. CHM67-1003 + have the group by column data next to it...I gave it a shot but couldn't get the desired output.Thanks.

Hello, I am trying to find the distance between a point feature class and polygon feature class with the NeighborFinder. The points are the base, and polygons the candidates. I have a max distance of 5000m. The actual scenario is finding the distance between houses and well sites. I need to find out which well sites are within 5km of each house, and record the distance to and ID of the well. The result that I am getting is only one candidate/base. I would like to have multiple records for each base, showing the distance to each candidate. My parameters are attached. Thank you.

Workbench contains 7 individual sql queries that produce shapefiles.When run all together six work, but one of the processes fails with a no schema error. However, the process that fails works when run on its own.What could be the problem?Thanks.

Hey FME'ers. I just wanted to draw your attention to this useful piece of information I found.See my tweet here: https://twitter.com/FMEEvangelist/status/1151516193263640577Basically, when doing a Dataset Fanout you can set the folder to be a zip file when you write to it, or you can set the Fanout Expression to have a zip file extension, or you can use both!I'm not sure when this got implemented. I think the first method has been around for a long time, but the other two might only be in 2019 or newer.Hope you find this useful!

I have tested some attributes of a Shapefile which are empty, with a StringLenghtCalculator and those empty fields returned a value of 254 characters. That's weird. I have tried to replace those empty values with '0' or with 'EMPTY' using the NullAtributeMapper with all options and with the StringReplacer using this regular expression: [^a-zA-Z\\d\\w,.\\-/\\s/+_\\\\] All with no success.... still the attribute value seems to have 254 characters  A familiar problem to someone? And maybe there is a solution?

Hello I have two tables below   This was done in excel, in essence, I want to assign the Pos_ID from the first table to the PosKey in the second table depending on the values on the date/time column on both tables. Is there a way to do this in FME? Thank you 

Hi All,  I'm wondering if there is an efficient way to flatten part of a mesh. I have a large mesh and in part of the mesh I simply want to set the z value to say 0.  I don't want to recalculate the triangles, just offset the effected vertices. The only way I can see to do this is to break the mesh down into it's vertices which seems super inefficient.  open to any ideas  

Hi all, I am new to FME and I am trying to solve the following problem: I have a set of 24 .shp. Each shp comes from the buffer line, and each has more than 50,000 characteristics. Each one contains polygons and donuts. When I read it together, I have a lot of polygons and holes overlapped.I have to dissolve the shp set because I need the fused surface of the buffers clearly, without overlays.Although I have tried to dissolve it by different methods such as extracting holes, dissolving and adding holes afterwards, or dividing the data set with a tiler and dissolving it based on groups (row, column), the output is never what you expect, having filled holes or partially undissolved areas. I think the dissolver does not work properly because there are too many overlaps, holes in a single feature and holes between features -from reading the entire set .shp in a single reader- I have attached an image of a shp containing the 24 shp merged, but with no dissolver and a image of unexpected out

Hello folks, I am wondering whether there are any tools that can help me clip one 3D city model with another? This might be unusual thing to do, but its for analysis purposes (thesis). I want to substract one from another and vice versa to see differences between the two. Both files are in Shape format. Any way I can do that in FME?

Hi, I'm trying to use point data from a shapefile to accurately place 3D objects (obj) in their correct geographic location, and then outputting the collection to FBX.I based my approach on the response by @takashi to the following forum question: Adding a 3D model and Geo-referencing it with multiple XY pointsIt seemed to work really well. However, when comparing the final FBX model to other 3D layers the markers seem to be in the wrong location.Input from QGIS matches FME 2D Inspector output pictured below.FBX Output in Unity (visualised below against other map layers exported from FME as 3D objects).The 3D objects in the FBX output appear to be spread to the north and the south and stretched to the east. This looks like a projection issue but the 2D output is fine so its unclear why the 3D output wouldn't be. Alternatively the problem may be the offsetter, but if that's the case I'm not sure exactly what the problem is.The input shapefile coordinates (clipper boundar

Hello Team, Present I am working on the following version of FME:-FME(R) 2015.1.1.0 (20150715 - Build 15515 - WIN64). Is there any possibility to do ZIP Archiving with existing version? When i tried Zip Archiving transformer it is asking for upgrade. So which version of FME supports Zip Archiving?Thanks...

Morning All, I have 4 equal polygons next to each other and i need to label them A,B C,B. Im struggling with my lists. They currently have no attributes My approach is to create a center point for all of them, to get the x and y. Then A should be the one with the smallest X and smallest Y, then B should be the Largest X and smallest Y etc etc. i get the inside x,y for all then build a list from them then sort the list by inside x but struggle from here. im unsure how to a list by two values ,ie x and y. i have tried list indexer, list exploder.  Thanks Steve point for each polygon then look for the [polygon with the smallest X and Y, this = A, The smallest X and

Hi, we are trying to use a hullreplacer (FME2017.1) to get a concave hull. When we feed it with polygons, it crashes the engine, even the polygons pass the GeometryValidator. The alpha parameter does not seem to have any effect on this behavior. However, when we chop the polygons into points, it comes with nice polygons. Any similar experiences on this?

hello guys i am finding a solution to join excel files related to stations on highwayseach excel file had the specific data for stations ( 1- shops 2- car services 3- motel,toilets etc) including coordinates for each related service.there is no unique id for station on which i can join them except the coordinates.each station has 3 to 4 points having attributes for services.and the distance between points varies as per accuracy on the device some time it comes within 50 meters and some time more than 100 meters according to the area of stations.i tried the buffer in arcgis but it not covers all and some time if the distance between two stations less joins the two stations as one is there any way i can join points related to each station with out having overlap and not joining stations from one side of road to the other side as some time there is station on both sides of the road infront of each other..also i want to create station id for each station

 Hi together The initial situation is as follow: The relation between column TR and column LTG is 1:n. Every value in the column LTG need to get a unique code independent from TR. The CODE also has to be unique per TR.TRLTGCODEA1?A2?B3?B1?C1?C3? I would like to get follow result (the code has to be unique per LTG and order is not importent): TRLTGCODEA12A21B31B12C12C31   

HiI have a workbench (), where I am reprojecting to WGS84, adding grids and text and clipping to a grid index. After the clip I was getting black borders, but I set this data to nodata and this fixed the problem when looking at the rasters in GIS software. However, in windows explorer the black borders can still be seen. I understand this doesn't effect the data, but it doesn't look good when sending the data to others. Is there any way I can remove these black borders in windows explorer. ThanksB