FME Form

Hello everyone,  I have an issue with an automatic process generating PDFs since an upgrade of FME server from FME 2017 to FME 2021. The process is quite complex but basically it creates network maps on demand. My issue is that, since the upgrade, the symbols rasterized on the maps are not rendered as usual. The symbols are imported from SVG files generated from an AutoCad dwg (because the network information is from an Autocad/Oracle DB). It uses MapnikRasterizer to produce a raster version of all the information, including the symbols as markers. I have identified the source of the difference in the rendering, it is how MapnikRasterizer handle the SVG. But I don't think it is directly related to the developement of MapnikRasterizer but how FME is integrating it and how FME handle the SVG. The SVG are made from Autocad blocks and most of them have an outline/contour of a slightly different color. So even a plain round symbol is constituted of two shapes.  My issue is that FME 2017

FME Desktop 2022: Polygons fail to be saved in esri geodatabase polygon feature class, In the screenshot below, and the attached data and workbench, I couldn’t figure out why polygons fail to be stored in esri geodatabase polygon feature class             

In a Workspace of acad2acad, some leader lines and arrows do not come through or move. RealDWG Reader and Writer solves a few scaling problems with blocks, but there remains a few leaders that don't make it or move:Before After It's not clear if the orphan leader on the left has anything to do with the annotation (different geometry and entity handle). autocad_arrow_head_on is TRUE for all. If it is something in the original CAD file, I have yet to find it. Not all leaders and arrowheads disappear.The leaders stay until it hits the Writer:Also, I am using a template that is set to the source file in order to get the paperspace titleblock. That is the only way I can get that specific paperspace info into the file (is there a better way?). If Preserve Model Space Data is set to yes, I get the leaders, but also objects that I was trying to change as well as the mystery "mirrored" orphan leader. To be clear, this occurs in multiple different drawings. Any insight is appr

How to run exec and grant command in fme like "exec dbms_stats.gather_table_stats(‘Schema_name’, ‘Table_name’)" and "GRANT SELECT ON table_Name TO public"

I have a table called PROJECTS with some records sharing similar names. The objective is to find these records and merge them to one if possible. SamplePROJECTS table with Field1, Field2, Field3  From the above table, I want to look into Field3 and find similar names, such as Paper Company, Paper Company. and Paper Co and merge these into a single record. They are not exactly duplicates, but share a similar name. There are more records with similar names, so I can't hard-code Paper Company because there are more records alike that share similar names.  What transformers can I use to complete such task? Thank you.  

I'm attempting to dynamically map 141 different excel files containing attribute names (but no attributes) to the corresponding files that contain the actual attributes. There are 51 different files (.txt files in csv format) containing attributes for the 141 "schema" files, so a total of 7191 files containing data - none of which have attribute names in them (they all come in as col0, col1, col2...). Because there are 141 different schemas and because there might be new schemas added over time, I don't want to manually map the attribute names using an AttributeManager or AttributeRenamer. Also, they can change each year, so manually creating a schema file to use in a schema mapper doesn't make sense (the schema file containing the attribute names is horizontal, not vertical as well). I have been trying to use the FeatureReader to map the attribute name files to the attribute value files, as well as the FeatureWriter but I'm not having any success. Does anyone

cmd.exe mkdir f:\\\\中文​

Hi, I'm currently trying to create geojson with the JSONTemplater to get a txt file at the end of the process. I'm really close to get it but there is something I cannot work around. Here's my final txt file that I have right now :  { "message" : { "sucess" : true, "message" : "La tâche a fonctionné. Vous recevrez un courriel dans les prochaines minutes. Votre numéro d'analyse est le dc82c137-f34a-4fae-806a-af03f2a16cca." }, "geojson" : { "type" : "FeatureCollection", "name" : "transport_hors_norme", "features" : { "type" : "Feature", "geometry" : { "type" : "LineString", "coordinates" : "[-74.25854312432821,46.386997802914244],[-74.25854690900775,46.38701144003504],[-74.2585653228558,46.387067245480985],[-74.25858324562817,46.38711253856072],[-74.25860564958018,46.38716441447192],[-74.25863316909272,46.3872

Hi, fellow FME-ers! I have a NetCDF-file I have exported from ArcGIS Pro that I have attached (zipped). It was exported using the settings in the png-file in the same zip-file. I want to export every grid point in the file as a 3D-point with the Prediction as an attribute. Can anyone help me? I saw other threads about this but still couldn't figure out how to do it... Kind regards,Peter

I have two Workspaces. One creates a KML file of points in countries around the world the KML contains an html popup. The popup presents a link to a server app, the server app generates a static HTML Page for that country. I want to change the text "country parameter" to the country that the popup is in.The goal is to create the html only at run time.

Hi, I will calculate the average z-value of a ground surface based on a point cloud.So at the moment I am using SurfaceDraper to drap the ground on the surface. After that I am using BoundsExtractor. But here I have only the possibility to get the min_zvalue. I will get the average z-value calculated on all z-values of the polygon. How can I do this? I saw thatt there is also an elevation extracotr. But this transformer only extract the first z-value of the first coordinate. I cannot calculate the average on al z-values. Can anyone give me some help or hints?

My question is similar to this one: https://community.safe.com/s/question/0D54Q000080hbnqSAA/extruding-building-heights-from-3d-terrain-model-creates-sloped-buildings and Takashi's answer helped me to progress. However, in Takashi's answer, the z value of each vertex is the same (the minimum z value of the whole vertices) but I would like to keep the proper z value of each vertices and then extrude them with different elevation in order to keep a flat roof. My idea is to extract each vertices of the building footprint and extrude them with their own elevation values. SurfaceDraper: Drape the polygon by the terrain surface.VertexExtractor:Calculate elevation of each vertices (building highest altitude minus z value)Extruder: vertical using the elevation calculated beforeRebuild the 3D building geometry from those extruded vertices My question then, is there a way to rebuild the 3D buildings from those extruded 3D points (that are now lines)?   

I am currently upgrading from FME2019/ArcMap 10.8 to FME 2021.2/ArcPro 2.9. In our ArcMap workflow we use the tool VPF-to-Geodatabase via arcpy scripting:arcpy.production.VpfToGeodatabase(in_vpf_features, in_target_geodatabase, in_product, {import_notes}) Being that the tool is not yet developed for ArcPro 2.9, is there a way to force FME to recognize this is an ArcMap tool? I still have both versions of ArcMap and ArcPro installed. I've also tried the option under Translation > ESRI ArcGIS Compatibility set to "Esri ArcMap", with no luck. When changing this, it forces the Python Compatibility from 3.7 to 2.7.

For example, we have walls lines, but some times the room has only 3 wall lines. Or sometimes there is gap between wall lines. Is there way to create room shape(area or polygon)? Please see attached Sample CAD Cleaned File.dwg. This is my input dwg file. And I want to create a new layer called _Plines, this layer will have the enclosed polygn created based on the wall lines. The out put is something like CAP Level 1_RevC_MB.dwginputresult

I am experimenting with an aerial raster over a river delta trying to find the fastest way to extract centre lines over the water ways. Creating a point cloud with some sorting has resulted in a multipoint geometry that does a decent representation of the shore lines. Up until this stage the workspace is blazingly fast. But in the next step it becomes painstakingly slow. I have tried both creating a hull around the multipoints as well as buffering them. The former was slightly faster but still very slow. Are there other methods that might process faster? 

My data is all in LL84. I'm curious if I should reproject into UTM or other coordinate system before I use Buffer and Dissolver?  This is due the answer that I got for my other question https://community.safe.com/s/feed/0D54Q00009LDzFBSA1 The solution was changing LL84 into UTM and then everything found correct matches for nearest neighbor. I'm doing additional work with same data but this time applying a 4 foot buffer to each point and then running them through dissolver to see which points are near each other. It appears to work fine but after my last answer I'm thinking I should reproject the data to UTM and then do this work.  Thoughts?

However, if an old verison of file is already present in the path, then it is able to rewrite the file. But i want each time it creates a new file. Kindly suggest

We use FME(R) 2020.0.2.1. I've made a workspace that uses a DateTimeConverter. I then loaded it on FME-Server (FME Server 2020.0.2.1). Now I wanted to change something and downloaded it from FME-Server. When I opened it in FME-Desktop, in the DateTimeConverter there was just a text DATETIMECALC_1_ADD_INTERVAL on a red background in the Mode-Field, and I couldn't do anything with the transformer. I viewed the workspace on FME-Server, there the Transformer looked ok, with all the different parameters filled in.I then tried to use the DateTimeConverter in a new, empty workspace, but it didnt't work anymore neither.(We have FME2021.1.3 installed on the same server, but we don't use it for some reasons. I tried it with this version all the same, but it didn't work neither)What's wrong here, how can I get this transformer to work again? Thanks, Vera

Hi FME'ers, I have access to Ordnance Survey's CodePoint with Polygons through the PSGA. I am trying to write a workbench that would dissolve the individual postcode polygons into the areas (DN), districts (DN1) and sectors (DN1 1). The issues here are vertical streets (sometimes stacked) and islands postcodes. I haven't had too much issue with areas and districts, they iron themselves out at these scales, but sectors are just a mess. I have been playing around with the Dissolver, Clipper, DonutBuilder and DonutHoleExtractor but each approach has it's issue.  I would be very grateful if anyone could share how they have achieved the above.  Many thanks,David.

Hello,When I open my app with the URL, I want to integrate external data (like local files) and run the processing but when I run it, an error message is displayed.  Thanks in advance

Using FME Server 2021.Uploaded workspace that has no problems to run on Desktop. When running on FME Server it fails with the message:FAILUREINCLUDE -- failed to evaluate TCL expression ` FME_CleanseFMEUUID {StringPairReplacer_9f3b9011_1d33_4123_9fa5_4f7dd23e28558} ' -- invalid command name "FME_CleanseFMEUUID" while executing "FME_CleanseFMEUUID {StringPairReplacer_9f3b9011_1d33_4123_9fa5_4f7dd23e28558} "

Dynamic attribute name reading does not seem to work still (FME 2021). I'm trying to extract attribute names from certain excel row. I don't know the attribute names beforehand and workflow should be completely automatic. Basically I have attribute names like Extra1, Extra2, Extra3... and if there is any extra attributes, those names would be changed in excel: "Extra1" --> "car". What I'm trying to do is reading those changed attributes automatically, but can't get excel reader to dynamically detect changing attribute names. I know there is a work around with generic reader (link to question below) but that really don't work because I have to read specific cell range from excel and can't determine that cell range with generic reader. Any ideas how to work around this?  https://community.safe.com/s/question/0D54Q000080hFpiSAE/dynamic-excel-sheet-reading-without-having-to-reload-the-reader

Hi! I have created components (resistivity and resistivity_class) in a LAS-data. When i uploaded it in FME inspector, the created components showed up, but not in ArcGIS Pro. Any ideas how I can make it to show up in ArcGIS Pro? 

I have a test Shapefile with 19 roads/segments. I want to merge all segments that are shorter than 200m with the shortest adjacent segment, and use the attributes of the adjacent segment for the new road segment. I've got most of the logic working, but can't get it to loop until there are no more segments less than 200m in length.  The attached workspace shows one iteration going from 19 records to 18 records. Any pointers as to where I'm going wrong appreciated!

Hi, I've been having a problem and I couldn't find any answer that could help me in the forum.I need to cut a raster mosaic that I did by tiles that I have: But when I run the workspace, in the clipper the whole image is set to "outside" and I can't figure out why. I also need to transform the raster mosaic to multiple rasters by that tile and with the ID that appears in the image, but I didn't get there since everything goes wrong after the clipper transformer. What am I doing wrong? Thanks in advance.