General

Welcome to the last What’s Up Wednesday in October Community Appreciation DayOctober 27th was the first annual Community Appreciation Day. We wanted to say thank you for being a part of the FME Community and making it what it is today. From the long lost years of FMEPedia to our new community focused community, thank you for contributing! Mark Ireland posted a blog post yesterday highlighting some of the awesome community members as well as some new swag!  Cloud Integration ToolsStewart goes through different ways to store your data in the cloud while using FME Cloud in a new blog post about cloud integration tools. He also pro

Hello experts,I'm stuck in an installation problem that I'm not able to solve.I need to install a library (i.e. cx_Oracle) for both 2.7 and 3.7 python interpreter.I tried to install both cx_Oracle versions in:C:\\Users\\myself\\Documents\\FME\\Plugins\\Python\\python37 andC:\\Users\\myself\\Documents\\FME\\Plugins\\Python\\python27Trying to configure both interpreter in FME, it seems FME 2020 is not able to find the library. Error: Python Exception <ImportError>: No module named cx_Oracle.So I tried to copy the python37 content into C:\\Program Files\\FME2020\\python\\python37 folder.Now the error is "Python Exception <ImportError>: Module use of python27.dll conflicts with this version of Python".Any idea on how to properly configure where to install libraries and let FME looking for the correct version?ThanksRoberto

Hi All, One of our customers is running VID's with FME Desktop in an App-V.It seems the App-V is checking out a Floating License on startup, even there's no FME (workbench) process opened and after all FL's are checked out other users can't start FME Workbench anymore.Why is the FL checked out on startup of the App-V and how can this be disabled until a real FME process is started.Can this be arranged by removing the fme_license.dat, or perhaps using Non-persistant VID's? Kind regards,Krien Guijt 

Hi.In one of my FME-workbenches I'm splitting lines at several points (water lines and devices) by using a PointOnLineOverlayer. After the splitting, I want to create a numbering of the new line segments according to the direction the line has been digitalized. I've tried using a counter with the ID of the lines as the countername, so I get a count based on the ID. But the result is not what I want. The numbering seems random. As you can see from the first example (just a mockup), each line has an ID and you can see where the points are.After I split my lines and calculate a new ID, I get this:The segment IDs are not numbered in the direction of the lines. What I want to achieve is this:

Hi,I have two raster files, DEM_epsg25831_orthoHeights.tif and GEOID_epsg4326.tif, and I have to convert from orthometric heights of raster DEM to ellipsoidal ones. I am using CsmapReprojector [3] with FME Workbench 2019.1 but I have problems with vertical adjustment. I always get this error:CsmapReprojector: Reproject: Could not reproject the geometry of the preceding feature: Program TerminatingTranslation FAILED.   These are the steps that I follow for vertical adjustment: 1) I have converted DEM_epsg25831_orthoHeights.tif into dtm_epsg25831_orto.asc (Esri Ascii GRID), because CsmapReprojector can only reproject raster files in 2D (that is, with Ignore heights and leave them unchanged) [1]. This is the content of dtm_epsg25831_orto.asc (sample data for test),NCOLS          3NROWS          3XLLCENTER    398955.000000000YLLCENTER    4624395.0

I wanted to create a custom new projection system with below ESRI WKT string using the FME online tool and getting " FME Data Streaming Service Failed to Complete" error.  PROJCS["Exelon_Custom_NAD83",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",40000000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-77.0],PARAMETER["Standard_Parallel_1",38.18],PARAMETER["Standard_Parallel_2",39

Started to build a FME Workspace that would test in-coming email for 2 files attachments with a specific pattern. I'll email reply back if the 2 files are not found, if found then save them to a network UNC location. I've got reading email json -> into 2 ListSearcher (1 for each file) This is where I'm hung up as testing for the 2 specific files (it has 2 files and very specific for each to the 2 files)? 

The data I have looks like the table shown in the appendix 'Current format'. I want to come to the result shown in the appendix 'Needed result'. So I need some form of grouping based on the ID column. And also a sorting based on the BOTTOM_DEPTH or based on the DBK column.Within each group, the first row needs to get a top depth of zero. All following rows need to get the BOTTOM_DEPTH value of the row above.

Hi,I have points in autocad layer and two text strings (both in different layers). I need to connect those strings to points and create two new attributes. I tried to options: (1) to first merge two text by using NeighborFinder and that to use second NeighborFinder to connect them with point, (2) to first merge two text by using NeighborAggregator and that to use second NeighborFinder to connect them with point. But in some cases it does not work correctly. Is there any other transformation that can be useful in this situation? or any suggestion what may be wrong?

Hi!  I have a workspace which reads 2 tif files and 1 shape file and writes a kml file. I have about 100 pairs of tif and shape files that I want to process in an automatic way. I am trying with Workspacerunner but can not make it work. Any tips on how to proceed?

I have a very simple workbench: An excel file as input and straight after it a statistics calculator. Only: the results make no sense. Example: one column has a sum of 78000 in excel and an average of 68. In FME the sum is 1500 and the average 1.8. It is very clear that the results in excel are the right results. What is happening?

I've noticed that when I deal with GeoTIFF files exported from FME that I need to specify whether the raster is filled with elevation data or colour data when loading into other programs. I believe other software's specify in the TIFF header/metadata that the raster is elevation data but I dont think there's an option in FME to do so. Is anyone aware of a way to set this parameter?

Hello,I'm trying to install Pandas lib but it depends from a NumPy version newer than the one installed with FME (1.15.1). Pandas pip installation includes the correct NumPy library but the script fails because FME looks in the default \\FME2020\\python\\python37 folder instead of the custom one.Is it possible (without side effects) to upgrade that library? ThanksRoberto

Hi guys,I am trying to send a few request for every featrue individually using a Rest url (include spatial overlay) to the server in order to intersect between data in DB and input data. Then save the result in json file for every feature.It might be genereted some duplicate features , therefore I saved the results a json files. Then the json files are read using FeatureReader. But the problem is some of json files format, which were generated using HttpCaller, have been changed to Ansi encoding instead of utf_8 encoding.I dont know, how should I solve the error.Any help, I would be pleased.Thanks in advance

Hi, I'm traying to automatically set that output .dwg filename is same as input filename but in different folder. I was using FilePathExtractor and fanout. FME generates the .dwg with appropriate name but it contain only one point and all my data are omitted. How to resolve this?

Hi, With FME I want to update one column of an ArcGis sde data table. The table is a non versioned feature class with enable archiving and an active service has been created.I get the following error: Objects in this class cannot be updated outside an edit session I have tried all the different transaction types of the writer but it makes no difference.What could it be? Greatngs, Hans

I had a fatal that gives me the following...2020-10-21 16:26:33|1678.6| 0.0|ERROR |An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {No spatial reference exists.}2020-10-21 16:26:33|1678.6| 0.0|STATS |Storing feature(s) to FME feature store file `X:\\__FME_Workbenches\\COGO_SCAN\\path2fgdb_wksp2_log.ffs'Saying no spatial reference exists. following the error feature list is a section that tells me to "Rerun translation specifying transaction #88 for the keyword 'TRANSACTION'" I assume this would be using a commend line but know nothing of particular parameters and steps to accomplish this.any idea what i need to do?

My FME Workbench has a python startup and shutdown script (Esri ArcGIS 3.6 python interpreter) that works fine when running in the software or in command line with arguments.  When I put the workbench on a windows task scheduler, the workbench does not run and I get a 0x1 error in task scheduler. If I remove the python startup/shutdown the job runs fine on scheduled task.  Any ideas on how to resolve this? Thanks in advance! More detail:FME Desktop Version: FME 2020.1.0.1 (20200710 - Build 20596 - WIN64)FME_HOME is 'C:\\Program Files\\FME_64\\' Command line to run workspace: "C:\\Program Files\\FME_64\\fme.exe" "D:\\SOE\\FME Workbenches\\GRI\\GRI_Guardrail_AssetID_Creator.fmw" Python Interpreter: Using Python interpreter from `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python36.dll' with PYTHONHOME `C:\\Program

I have a field with data like this: 10-234-RI want it to be like 10-234R.  So in other words, I want to remove the 7th character which is a dash '-' from the string: 10-234-R String Replacer doesn't work because it removes both dashes and not the specific 7th character dash I want to remove. AttributeTrimmer i can't get it to work. I chose Trim Type Both but how is it supposed to know to remove the 7th character only. Any help would be appreciated.  Thank you.

HelloAs shown in the drawing, I would like to have another curve parallel (2) that goes through 2 points at the same distance each from the original. The whole problem is that everything is in 3D.The distance between the new points and the curve is unknown. I have the shape of the curve and the point location but transformers like LengthToPointCalculator are not working as I lack informations.So i would like to know how to calculate the distance bewteen a point and a curve in 3D. Note that the curve can have any shape.And also, the OffsetCurveGenerator is only 2D, and does not work with a 3D length in my case I thought about getting the distance in 2D which I don't know once again how to obtain, use an OffsetCurveGenerator and then force it in 3D, but the elevation changes between the beginning and the end of the curve, so a 3DForcer does not work, I think. Has anyone an idea on how to solve it ?Thanks in adva

Hello, I would like to total the number of times each record appears in the dataset. Here is an example of what I would like to count:I've tried using the FieldCalculator but I just keep getting 0's for the sum function. See photo below:I'm not sure how to set the parameters in the FieldCalculator to perform this function. Here is what I have currently set:Thank you!                 

Welcome to What’s Up Wednesday Gartner Peer Review SurveyJust over a week left to fill out the Gartner Peer Review Survey to earn a community badge. Get started by visiting http://fme.ly/CommunityInsights and entering your community username.  BlogHave you seen our virtual 3D booth at a conference lately? Want to create one for your company? Dmitri explains the motivation and how he created it in a new blog post.  Community GroupsAre you interested in user research regarding FME and what we do with that research? Check out the

Hello all ! I'm trying to build a pdf report.In the end it should contain map content as well as a table out of the spatial data attribute table.By now i'am failing at the simple point to write an attribute to pdf. Create a Text Attribute --> fill this attribute with text --> Style it with pdf Styler --> route to PDF pageFormatter and place the Object on the pge --> route to pdf Writer The pdf is always empty, no matter what i try.Any idea, i guess the Adobe Geospatial pdf writer needs a kick in any way.Version: 2020 RegardsAl

Dear all,  i need help to find solution to filter polygons with area below 1000 and dissolve it with neighbour with longest common boundary. In qgis is tool Eliminate selected polygons. I tried neighbour finder, spatial filter, but i can't find good solution.  Thanks in advance