General

Hi everyone, I've got to convert waypoint files to GPX files. I also need to convert txt to GPX. Please let me know if there is a work instruction for either conversion. Kind Regards, David

Hello,I have a pipe table (Polylines) and a manhole table (Points). I would like to spatially join the point located at each pipe start, to link the attributes of each entity. I manage without problem to find the point for the beginning of the line thanks to a NeighborFinder, but impossible for the end point. How to do ? Possible ? Thank you in advance.

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.  

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

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.

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.

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

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

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? 

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.

Hi, I have created a random polygon (in EPSG: 4647) and now I want to put hatches inside of it via DWGStyler. They should be depicted in an angle of 45° and as lines - this works. Between the lines, there has to be a distance of 2 meter and this is where I got stuck. I've tried to achieve this via Pattern Scale in the DWGStyler and by setting "autocad_hatch_pattern_space" to 2 by using an attributecreator, but this doesn't seem to work properly.

Hello FMEers FME Academy UpdatesIn case you missed the announcement, there are a number of useful updates to the FME training academy that may be of interest to you. New modules include:Read From and Write To Multiple LocationsImprove Data Quality by Handling Null and Missing ValuesBuild a Shared Library of Custom Transformers These are part of the new Build Advanced Workflows trail. I count 11 trails so far, each with different modules:  And don't forget, online FME training materials are free of charge to use.  FME Hub UpdatesThe Hub Monthly Digest is a must-read if you are Swedish since most of the new items relate to Swedish formats.  There is a web connection for the Nationella Geodataplattformen (NGP) and several transformers for the Digital Twin Cities Centre (DTCC). The DTCC project seems to be about modelling urban environments to assist in real-world planning and design.  It looks like a series of projects, actually, so I'm really happy to see FME functionality may pl

I am attempting to append records to an ArcGIS Enterprise Portal table from a Postgres database using an SQL statement. I have a SQL statement that works correctly to query the database. I can use this in the SQL Creator Transformer and connect it to an Esri ArcGIS Portal Feature Service writer in FME Workbench. I can run this in FME workbench, and the records successfully write to the Portal table. The project works on my local machine and on the network server we plan to use for scheduled tasks. FME is installed on the server. I would like to run this on a 12-hour interval using Windows Task Scheduler.  Here's what I've tried:Copied the "header text" from the log in FME Workbench, and saved this as a .BAT file. Placed the .FMW and .BAT files in the same directory on a network server, and edited the .BAT file to point to the .FMW file in its new location.I created a new scheduled task in Windows Task Scheduler to Start a program, and pathed to the .BAT file.Nothing i

I have created a workspace with the help of Mr. Takashi(a person from this forum) that reads the shapefile ,creates buildings then this buildings are separated in storeys and then the storeys are separated in roof,ground and wall surfaces. All this work is attached.I want to find a way to write this information in CityGML (Lod 2).In conclusion i want a workspace that gives me a CityGML writer with the buildings.

I have two Arc SDE Geodatabases. Both in different coordinate systems. I need to do a spatial filter. Can I temporarily reproject data to do the spatial filter? If so, how do I do that?

Hello FMEers,Here is your weekly FME news update, just a day late. Unfolded FormatIn case you missed it, we revealed the new Unfolded format reader and writer last Tuesday.   And it really was a reveal, because that format hasn't even been exposed in the FME betas yet. But when it is available, do give it a try. I just created an account on Unfolded itself and it certainly looks like a useful platform. FME TerminologyI'm sure you've noticed that by clicking "More" on the FME Community menu that there is an option to access documentation. But what you might not have noticed is a newly added link to the FME Terminology page:  The FME Terminology page looks like this:  It has been available for quite a while, but fairly well hidden from view! Now that you can find it through this link, I hope that you'll share it with other FME users - especially beginners - to help them understand the terms we use in FME. Deprecations and Other ArticlesThere are a few new and up

Hello, FMEers. Here's the latest news for you... Conference TrainingA traditional part of the FME User Conference is pre-conference training.   As we plan for the upcoming conference, we're gathering interest on training course topics and welcome your feedback. We've created a survey that lets you vote for existing course ideas or submit your own. If you are interested in filling it out, we'd appreciate you doing so by Feb 4th. If you already signed up for training courses from a previous postponed UC, don't worry. We will be in touch with details of any changes.  World Tour RegistrationsSpeaking of FME events, registration is now open for the upcoming FME World Tour. The theme this year... performance and power in the form of motor racing!  So "put your pedal to the metal" and visit the World Tour website to browse the schedule of events and see when the World Tour is at a venue near you. Don't forget to click on the Virtual button too, to find online

I have a CSV file that looks like this:- ID,X_COR,Y_COR187347635,335375,369977185565488,282016,438601185768788,281568,438584 FME has classified the X_COR and Y_COR columns as time? I lost hours of work by not spotting this and getting mysterious geocoding errors.  I can't see an easy way to override it in the Reader and it doesn't make sense to me to have the time classification?  

I'm trying to output CSV files to Word or PDF. Formatting issues... not sure which transformers to use and what settings to use... Thank you in advance!!!  

I want to use the RasterCellCoercer to polygonise a raster. I am using it in favour of the RasterToPolygonCoercer, since this one is running out of memory constantly when dissolving. So I would like to write the raster cells as polygons to a PosgresDB and then ST_UNION them.However, on the RasterCellCoercer I am unable to retrieve the band values. There is only one band. The _band{}_value field is always empty. When I use the RasterToPolygonCoercer I get the expected values.Could someone give me a hint on how to solve this issue? Thank you in advance!

I have a large postgres database with over 100 layers. I would like to know how, and if, the indvidual layers relate by a shared attribute. For instance: a river will have an attribute with the county-name it flows through. However, the county will not have an attribute with the river name (but wil have an attribute with it own name). Both will have a completely different geometry obvioulsy. I am also not interested in creating that attribute (using spatial relator). I just want to know which features share which attributes. Since the dataset is so large I can not use the matcher since I will not know beforehand which attribute might match. How would I best go ahead to try and find these relations?

Hiwindows 10, FME desktop 2020.2.5 I installed scipy using pip"fme.exe python -m pip install numpy --target C:\\Users\\<user>\\Documents\\FME\\Plugins\\Python\\python37 " I check numpy version and it says 1.16.5 using pip list in commando prompt. But when I run the script in FME desktop it saysERROR |C:\\Users\\<my username here>\\AppData\\Roaming\\Python\\Python37\\site-packages\\scipy\\__init__.py:149: UserWarning: A NumPy version >=1.16.5 and <1.23.0 is required for this version of SciPy (detected version 1.15.1 UserWarning) But the only version of numpy that i have installed is 1.16.5.  Any suggestions on how I can fix this problem?