Transformers

Hello,I am curious of there is a setting or ability to ignore "insert errors" related to primary key constraints in a SQL Database. The workspace writer is doings its job by not allowing duplicate keys to be created but I would like to override/ignore these errors to allow the workspace to continue and finish successfully.I know I could use an UpdateDetector or reader from the destination to prevent these inserts from hitting the writer but this will really slow down the process to read all existing records to perform this compare. I was hoping to set a SQL writer or workspace property to allow the workspace to continue when a duplicate key is encoutered. Any tips or techniques for this situation without actually reading the destination and comparing the input records?Thanks Ronnie

I have one feature layer with lines that are not topologically cleaned. There are many lines that are partly duplicated with shorter lines. Except FID, other attributes are the same.Any suggestions how to identify duplicate polylines (short lines)? LineOnLineOverlayer dont work for me.

I have several MapInfo map layers that I want to generate and send to my client as an image. I see that https://community.safe.com/s/article/creating-pdf-cartographic-output offers a way to render as PDF, but is there a similar method to render multiple layers to a PDF? Ideally I would want render a report with several pieces:An underlying map layer with streets, parks, terrain etc.Highway layers for the major roads in the areaCustom elements layer, with labelsSparse color-thematic grid overlayLegend for the color thematicAdditional footer for some standard text information.And some alpha transparency to a couple of the layers.

Hello.. I was wondering if it is even possible to create a time lapse map scene for construction happening across BC over time. Please have a look at the snapshot of the video. This is something i am looking for. Any ideas folks?Thanks in advance

Hello.. I have a bunch of properties across BC stored as a table in SQL studio where the address fields are null. I don't know how to find the address. I have gdb files of the parcels and have latitude longitude information as well but i do not know to use these to extract the address. Is there any way to be able to do this without any cost. Is there a way to create own geocoder? Any suggestion.?These are the tables I have. Basically I am looking in to populate these fields.[PA_ApartSuite] ,[PA_StreetFrom] ,[PA_StreetTo] ,[PA_StreetDir] ,[PA_StreetName] ,[PA_City]I have around 100K properties to be reverse geocoded. Also the lat long information was extracted using the Assesment Fabric Gdb file shown below.I also have geodatabase file for all the parcels across BC.. Don't know if it can be put to use in anyway..Also, I do have QGIS but not ArcGIS.Any help will be much appreciated. Thanks in advance

i have group of values with different color codes. When I run the transformer, it considers only first row color for all bars. Actually Bar colors should vary based on color attribute , Really appreciable if anyone can help on this ?

I used the clipper transformer to clip my dwg, (a shapefile being the clipper). The transformation worked with no errors, but when I go to inspect the output it has lost it's crs. Have looked around and there doesn't appear to be any information our there on this, any help would be great. Thanks

Hello,I am trying to read WMS imagery data via a FeatureReader, but the resulting output (using a Bufferer transformer) is just a single coloured box with no image. Can anyone tell me where I'm going wrong? Snapshots of the FeatureReader are as follows:

Hi,I have a folder full of las files from a big area, but I want to find out which las files exactly are inside my zone if interest (.shp) . I have tried a hullaccumulator to get a hull from each point cloud, to then compare these with my .shp file using a SpatialRelator, but it doesn't seem to work or I did something wrong in the options. My goal is to obtain a list of these las files.Cheers

HiDoes anybody know how to solve this?  Is it only in the twentieth file or are all the files troublesome?

Hi all,I am trying to create PDF maps which show points and areas from a Geodatabase, overlaid on imagery from a WMS connection. Each image in the PDF needs to show the point from the GeoDB at its centre, and be zoomed to a uniform distance so that the areas from the GeoDB and WMS imagery are visible. Can anyone tell me where I need to start? I've made several attempts with a few different transformers, and I'm getting nowhere.Thanks in advance!

Hi there,I've been using the adjacent feature functionality and I'm really impressed with how useful it is once I wrapped my head around it. However, I'm a little stuck now.Here's an example of what my data looks like:WeekPlaceLength% Difference1Village1298938.438-2Village1299198.1190.023Village130032.0970.091Forest11038.854-99.152Forest11036.975-0.023Forest11140.5470.94 So the "% Difference" I'm calculating via adjacent features in an AttributeCreator (Just to get the % difference of length based on the length of the previous entry:New AttributeAttribute Value% Difference@round(@mult(@div(@sub(@Value(Length),@Value(feature[-1].Length)),@Value(feature[-1].Length)),100),2)  This all works perfectly and exactly as I hoped for, except the issue of having "99.15 % Difference" when going from Village to Forest. That number is huge and not actually something I'm interested in, as I want it to "Start over" once it gets to a new "Place

We recently upgraded from 2018 to 2019.1.3.1, a workbench that worked fine in 2018 is now have python issues both in Server and desktop. What could have changed and anyone know how to fix it?   2019-10-29 10:37:06| 46.1| 0.2|FATAL |AttributePivoter (PythonFactory): PythonFactory failed to close properly2019-10-29 10:37:06| 46.1| 0.0|ERROR |BADNEWS: A fatal error has occurred. Check the logfile above for details auto __thiscall STFDynamicFactory::doneAllGroups::<lambda_faaa637947b31c6de3e253c564f4e0ca>::operator ()(void) const(c:\\code\\fme\\foundation\\pluginbuilder\\pluginbuilder_cpp\\dynafact.cpp:169) - auto __thiscall STFDynamicFactory::doneAllGroups::<lambda_faaa637947b31c6de3e253c564f4e0ca>::operator ()(void) const(c:\\code\\fme\\foundation\\pluginbuilder\\pluginbuilder_cpp\\dynafact.cpp:169)2019-10-29 10:37:06| 46.1| 0.0|ERROR |AttributePivoter (PythonFactory): A fatal error has occurred. Check the logfile above for details2019-10-29 10:37:07| 46.5| 0.0|ERROR

Hi I have two ESRI geodtabase files with different parcel information for same location. I am interested in joining the two records based on the corresponding same location. The attributes for the file looks as follows:I want to get a table that contains all these attributes together, for a same location?Is it possible.. Any help will be appreciated.

Hello,I have a .dgn file in which the shared cells do not come through; they are not even read from the workbench. I know it is not much to begin with, but any advice please? Thank you. George

Hello, I am looking for a way to generate a precision code for GPS coordinates of parcel fabric. Is there any way to generate a code for the accuracy of coordinates like a range of number for example 1-7 where 1 signifies most accurate while 7 signifies least accurate.. I am re projecting my data from to LL84. Any suggestion?

I'm using the custom transformer "TableAdder" to create a table. But the columns are placed alphabetically - left to right - but I want to change the way they are placed. How can I do that?

Hi, I'm trying to calculate average response times for my city's fire department. I'm not sure which transformer is best to use? I've used the date time converter to change the data that is coming over in seconds to minutes but then I need to do a) calculate the average of those individual response times and/or b)subtract the difference between two fields and then c) calculate the average of the difference.  Thanks in advance for any help. 

Hi guys,I need to convert the current source data I have which comes in the following format and need to it to come out as the output below.The conversion aspect of it I can get working but the issue is I want a concurrent list of IDs that is based on the source data. So all the outputs should be unique unless they are the same as the source data. What would be the best way to do this? Using the substring extractor and substring replacer has worked to a certain extent but not to complete convert all the Ids to the suggested output of 9 digit example belowSource DataEXM12345 - IDEXM12346 - IDEXM12347 - ID Output requiredEXM-10001 - ID requiredEXM-10002- ID requiredEXM-10003- ID required Once mappedEXM12345 = EXM-10001 EXM12346 = EXM-10002EXM12347 = EXM-10003  

FME Beginner. Project has scanned the internal areas of a high rise building. Have raw scan files currently sitting in Trimble RealWorks. I was wondering if there is way to extract the dimensions of the walls from the point cloud? Happy to do this floor by floor if needed. Thank you.

Hello,I have a problem in FME. I have too much data so I want to filter data every 3 seconds (3 or 4 or anything, whatever) but I really don't know how to do it if someone can help me please . Here is my fme workbench if that can help :Here is an example of data (you can see that in date we have data every second and I want to put it in a "every 3 seconds format") :

Using Ingres X Spatial DB and getting "FME Configuration: No destination coordinate system set Invalid WKB encountered. Ingres: invalid WKB encountered " The table has been created with srid 26911 and data inserted with the same srid. In FME the Coord system shows EPSG:26911. Any ideas on what is going wrong ? Using the Ingres table in reader and writer features.

Hello,I have a workspace for converting DGN vector data into a LandXML surface file built by a fine FME support tech. It works great, but I'm now noticing that the coordinates in the output file have 10 decimal places. We really only need 3 places, which would shrink our files dramatically. I tried adding the coordinate rounder in a few places, but the final coordinates are not changing. Not sure where to look to fix it. I'm not able to add attachments or I would attach my workspace (nothing happens when I click on "attachments). Thanks!!

I want to run the same workspace every x minutes. Will the server queue it or stop the one before. Sometimes the running workspace will take more time than the time allotted and I want it to queue.

I have 3 versions of FME on my machine, 32 bit 2018 and 2019 and 64 bit 2018, installed in separate directories.There are a couple of oddities I've experienced when changing FME options,1) In FME 2019 I removed the Run workspace button to keep only the Rerun entire workspace button which has resulted in the loss of the run workspace button in 20182) If i try and set my preferred python interpreter in 2019, the settings are not saved. If I set it in 2018 they are saved, but I don't have the option to choose python 3.7+, only 3.6+, I can change in the workspace (if i remember)