Transformers

When doing the comparison, how to specify that my unique keys are going to be 2 columns?  1 column can have the same value in multiple rows, but there can not be two rows with the same value in the two columns.  Example:  This can happen 1 | apple | red |  2 | apple | green |  This can not happen 1 | apple | red | 2 | apple | red |  So in order to check which row has changed and update it or leave It unchanged, I need to specify two unique keys in ChangeDetector.  I have specified the two columns in *Update Detection Key Attributes* but not working as expected  May you advise?  Thanks

Hi,Is it possible to see the table name of a SourceDataset geopackage in the command-line ?I have a geopackage 'biotopes.gpkg' containing several biotopes tables.The command-line only indicates the geopackage as source :--SourceDataset_OGCGEOPACKAGE "E:\\biotopes.gpkg"I would like to see something like--SourceDataset_OGCGEOPACKAGE "E:\\biotopes.gpkg\\biotope1"so I could choose the table of the geopackage in order to do some batch proccessing with a loop on the biotopes.Any idea ? Thanks.

Hey folks, I'm (relatively) new to FME and have had no formal training so I'm flying a little bit in the dark here. I'm curious as to the amount of time our dashboards run on Server and a few of the pre-existing dashboards (AverageRunningTime, DailyTotalRunningTime etc.) look as though they can tell me this, however they only give me data for the past day. Is there a way to modify these dashboard so that I can interrogate or view the data from the past, say, month?Thanks all! Marty

Hi guys.I would like to know if anyone has used FME on Debian 10? It was indicated to me that there is a problem with a library on Debian 10, but was not told what library it was, or if there is a workaround.I was told "You may be able to deploy it but may encounter an issue with running workspaces " Anyone know if this has been resolved? 

Hi,I have extracted spatial features from a non Geospatial PDF as a vector file. I am now trying to georeference this in FME and cannot figure out how. Does anyone know how I can georeference the PDF to begin with, in FME? So that I can extract the vector features thereafter...I have tried this already...1) Converted the PDF to a GEOTIFF format2) Georeferenced in ArcGIS using the Georeferencing Toolbar3) Converted back to a PDF 4) Tried to read the features in FME but it did not work. FME was unable to find the spatial features (such as lines, polygons etc.) Any help would be much appreciated! Thanks.

Hello, I have a list of points and their geometry:Point IDStreet NameRegion 1Street AA  2Street A A  3Street B A  4Street B A  5Street C B  6Street C B  7Street A C  8Street A C   I would like to create points that are located midway between points that share the same street name and region. In this case, I would like to create a center point between Point 1 & 2, another one between Point 3 & 4, another one between Point 5 & 6, another one between Point 7 & 8. There are always exactly two points sharing the same street name and region, never more or less. What transformers could help me? Thx.

Hi I am using FeatureMerger to merge attributes and geometry as followsTable1:ID1 Value1ID1 Value2ID1 Value3 Table2:ID1: Code1ID2: Code2ID3:Code3 I would like to end up with 9 records in the outputExpected result:ID1 Value1 Code1ID1 Value1 Code2ID2 Value1 Code3ID1 Value2 Code1ID1 Value2 Code2ID2 Value2 Code3ID1 Value3 Code1ID1 Value3 Code2ID2 Value3 Code3 I have tried various options in FeatureMerger, but I am still missing records in the outputThis seems to be in the Used Supplier port. Any suggestions ?

Hi.I'm trying to use SqlExecutor to update a table in my MS/SQL database. The table has a Danish character in it's name (Graveforespørgselssvar), but the database has collation Danish_Norwegian_CI_AI, so that's perfectly acceptable.But FME fails, because it mangles the name as UTF-8 (Invalid object name 'dbo.Graveforespørgsselssvar').I then tried to instead add the complete command as an attribute, and use AttributeEncoder to encode this attribute to both "Latin-1 Western European (iso-8859-1)" and "Windows Latin-1 (windows-1252)", both of which do contain all Danish characters, but it still yields the same error.Why do FME insist on sending SQL commands as UTF-8 even though both the attribute encoding and the database collation dictates otherwise ?It looks like a severe bug to me.

Hello,I'm using a SQL Executor transformer in my workspace. It is very very very slow (10 features in 10 minutes, I have 200 000 features to read).I have 2 readers and 1 writer from PostgreSQL spatial tables. I created indexes in geom attribute (gist) and primary key (btree) for the 2 readers.The SQL script is :update ref_assainissement.fildo SET nodterrain = 't' FROM ref_assainissement.canaexp WHERE idfildo = idfildoaval OR idfildo = idfildoamont(so very simple)Any idea ? Thank you ! 

Hi Guys, I am reading in JPG's and writing to a TAB file with attributes.I want to convert the EXIFF date format to DD/MM/YYYY with time if possible.The format EXIFF provides is YYYY:MM:DD HH:MM:SS eg 2020:06:03 08:55:21Can this be done in the feature writer? eg changing the value with a @Value(jpeg_exif_datetime,%d/%m/%Y) command is this the right approach?Dave      

FME Server 2019.2.1 any antivirus or windows defender exclusion needed for FME Server/Desktop versions

HelloI want to write Lines (with 2 points) instead of Polylines, so i use a Chopper to create Lines with 2 Points. But if i use a DWGStyler to set the Linetype all those Lines are written to DWG as Polylines. If i do not use the DWG Styler everything is like i need it. I'm not sure if the DWGStyler is the main reason for this.So i would like to know, is it possible to force the Writer to create Autocad Lines instead of Polylines? The writers Autodesk AutoCAD DWG/DXF and Autodesk AutoCAD RealDWG DWG/DXF create the same result. Thanks

I currently have a template like this:-    {    "pd_id" : fme:get-attribute("pd_id"),    "name":fme:get-attribute("district_name"),    "code" :fme:get-attribute("district_code")    }  Is it possible to add a rule that says: IF district_name is null then name = fme:get-attribute("pd_id")

Hi All,I am trying to create json file using the json templater . input for this file has postGIS file with geometry in wkt format . i tried to convert using json templater but it not giving the desired output . can somebody help me with this ? i am uploading the json format file which is my desired output for this . file name examplebody.jsonalso i am attaching the screenshot of the out put which i am getting.

I have 1 Road(Line) layer with so many attributes e.g. Name, Speed, Direction etc. I want to find if any segment of 1 continuous road(line) has different names. Ex. ABC Road is of 5 KMs but in database there are few small segments which has name as XYZ Road, abcd Street etc. How to detect these segments.@takashi @david_r Thanks

Hi, I have a road network and a start and end point on the network. The points are not snapped to the network. I would like to snap the points to the network, then trace the path between the start and end points along the network. I have tried using vertexCreator, followed by Neighborfinder and shortestpathFinder, but no results in the output. Any suggestions and what would be the considerations to improve performance ?

Hello,I'm having some issue with some an excel fileUsing the inspector, I have the right information in the feature information mode.However, in the table view mode some attribute have <missing> value.How can I correct this? It prevent me to get the right information into another file because those values are missing in the output.

Is it possible to write KMZ data in tiled format ???I'm trying to write some raster data to a single KMZ file.Writing the raster data to KMZ is no problem - but not in a tiled format - it doesn't seem possible ?.........................With Geotiff, you get an option to write:No. of Columns per Tile 512No. of Rows per Tile 512..........................Has anybody else come across this or know a solution ?..........................RegardsHoward L'

Hello!I am working with polyline data that have known z-values derived from as-builts and inputted into a spreadsheet that was then used to plot the x, y, and z values. The vertical datum on these values were in NGVD29 but we need to convert the elevation values to NAVD88. However, the horizontal coordinate system is already in NAD83, so CsmapReprojector using the "NAD27 heights in NGVD29; NAD83 heights in NAVD88" has no impact. Are there any alternative solutions that can be explored? I would really appreciate the help!

 i have source excel file that it includes first name and second name and id for each name and another excel file that includes first name and second name at the same cell how could i merge to get id for each name although ometimes the second name repeated

Hi I have been working on a workspace the pat few weeks. Before I know it is now looking quite hard to read. I have considered including junctions, create tunnels, using custom transformers if possible,I have a number of lines crossing across (see attached). Any suggestions what are the best practices?

Hi,I was formating big date numbers and I encountered a strange rounding effect when evaluating a big float number (see screenshot below). It can lead to issues when formating a datetime as FME needs seconds to be within 0 and 59 (60 not allowed). As a workaround, I do the flooring using attributesplitter on strings (separator .). However I wanted to ask whether this behavior is correct? I believe this is due to the size of the number.Thanks for your answer

Hi,We are having issues with performance using the DEM Distance Calculator. The issue probably lies in the fact FME is trying to be too precise. Working with a large polygon and a 5km raster cell In the logs we see:VectorToRasterPopulator_ClippingFactoryPipeline::CLIPPER (ClippingFactory): Clipping with an automatic tolerance of 1.6032000000000016e-11 Is there a way to change this tolerance and make things run faster.Also I attach the workbench to try to see if there are other barriers to the performance. Many ThanksOliver 

If anyone knows, I was wondering why I have some greyed out numbers between the transformers, and then it comes back to black when writing the data?

I have a line starting at (A) and ending at (B), consider it's a 50m distanceI may be at either (A) or (B). Using a nieghbourfinder , I know this line is there. How do I know at which end I am.Please advise. Expect your feedback  Gosh, my professor always used to say to me, it all depends on which end of the stick you are in :). Now I am still trying to figure it out.