Transformers

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.  

I want to split a line at regular interval distanceQ1. Assuming the above is a 50m distance line and I want to split at 20m distance, If I split the above , I would get two segments of 20m distance and one 10m distance segment.Q2. I want to do the splits starting from both (A) and (B) Can anyone advise on how this is done? 

Hello,I've converted Sentinel-2 Level-1C scenes into Level-2A bottom of atmosphere (BOA) products using the ESA SNAP Sentinel Toolbox. I would now like to use FME to read the scene classification (SCL-20m) SNAP outputs and create a raster mosaic of these. The attached illustration shows this data in ArcGIS Pro. I've been unable to read the data in FME.Thanks.Tony

Hi there,One of my customers has a very large raster DTM (spacing 1 meter over a large region) that comes from numerous tiles.He wants to compute consistent contours over the whole dataset, and ContourGenerator should be OK for this, but...Computing contours on tiles independently causes issues on tiles boundaries (impossible to combine the contours that do not fit over tile boundaries.Computing contours on the whole mosaic fails after around 1 hour.Any thoughts about a clever method ?Also, I wanted to check more about the surface model used internally by the SurfaceModeller, to see if it could help build a surface model incrementally, but did not find much documentation on using this option.Thanks for your help,Fred

I need to split the data below into 2 recordsie . 01_GF_CR should be 01_GF_NH and 01_NH_CRhow would i go about doing this ? thanks Line Segment - OnePlanRoute Name - OMEGA01_GF_CR01_GF_NH 01_NH_CR02_GF_CR02_GF_NH 02_NH_CR03_GF_CR03_GF_NH 03_NH_CR04_GF_DN04_GF_NH 04_NH_DN10_EB_ENR10_EB_EBE 10_EBE_ENR13_CR_GF13_CR_NH 13_NH_GF26_BH_SM26_BH_IB 26_IB_QS40_QD_QB40_QD_IA 40_IA_QB

Hello!I have two datasets of lines - streets and roads. I would now like to get all intersections of streets and roads as points, but not intersections of streets and streets or roads and roads. I tried the transformers "Intersector" and "LineOnLineOverlayer" but both only have one input. So how can I sove this problem?Thank you, Stefan

HelloI have two datasources: one is sde featureclass with status quo data, the other is a WFS-Service, which supplies more current data. This data I compare with Changedetector on their geometries and could change this succesfully (-> the geometry) . But now I have the problem, that both dataset have a totally different nongeometry attributes. I don't need the nongeometry from the WFS. But after the delete and/or insert process of the ChangeDetector i lost the old nongeometry attribute information from data, which for example in the new StatusQuo a geometry is now split to two geometries. Has someone a workaround for a solution for this trouble?Sorry for my english, but I hope you understand my problemThanks

Dear Community,  I would like to integrate one external library called pyntcloud (https://github.com/daavoo/pyntcloud) within a workspace. I have made some testing within conda environment and everything worked perfectly.  However, when I wanted to run it within a FME workspace there was a problem with a package. The following error occurs:2020-06-30 15:43:16|   0.5|  0.0|INFORM|Using Python interpreter from `C:\Program Files\FME\fmepython37\python37.dll' with PYTHONHOME `C:\Program Files\FME\fmepython37'2020-06-30 15:43:16|   0.5|  0.0|INFORM|Python version 3.7 loaded successfully2020-06-30 15:43:16|   0.5|  0.0|INFORM|Adding folder `C:\Users\SAVe\AppData\Local\Temp\' to the python path2020-06-30 15:43:16|   0.5|  0.0|INFORM|Emptying factory pipeline2020-06-30 15:43:17|   1.3|  0.8|ERROR |Python Exception <OSError>: [WinError 126] The specified module could not be found2020-06-30 15:43:17|   1.3|  0.0|ERROR |Error executing string `import<space>fme<lf>import<space