FME Form

Desktop version 2020.2.0.0 Build 20787, FME Server version 2020.2 Build 20787.  When the workbench is run in Desktop, the result is:> FMEServerNotifier: Sent notification to topic ... on FME ServerAnd the second workbench in FME Server gets triggered as expected. However, when it is run in FME Server, the result is:> FMEServerNotifier: Failed to send notification to topic ... on FME Server>FMEServerNotifier: Reason - unable to connect to FME Server Some things that have been attempted:+ ensuring 64 bit desktop upload to 64 bit Server+ using a different connection+ trying to verify topic and connection credentials with admin person+ verified the Topic can be run directly within FME Server, which triggers the other workbench correctly+ Desktop and FME Server versions appear to be the same ie 2020+ adjusted the python interpreter+adjusted the Notifier's preceding transformer to remove excess rejected data, such that the input into the notifier is purely a single celled table

I'm running into a problem with the Google Sheets (V4) Writer. We have a Tableau Public Dashboard connected to a Google Sheets Document. Tableau Public will only daily update it's data when coming from Google Sheets. Other data formats are not supported.To keep our dashboard up to date I'm writing a selection of the last 24 months of data from our internal database to Sheets. About 1,5 million records. Using a 'truncate existing' mode. Only 1 column of data. All columns from B to Z have been removed from the sheet. Writer is set to end at column A . So no extra colums are created.When starting with an empty sheets this runs perfectly fine but after a week of daily truncates the sheet contains nearly 10 million rows. Only 1,5 million contain a value, the rest is empty. So not a real truncate, just a 'delete value' is performed. The next day my workspace crashed because the sheet will exceed 10 million cells...A drop and create won't work either because it

Due to a company merge, need to change the network domain for the entire infrastructure. What is the best way to handle FME server migration to the new domain? Is it possible to do an in-place migration, rather than building a new FME server?

 I have some problems using data made from FME. The workflow is basically from excel statistics data combined with feature joiner with shape polygon and after that through attribute manager to shape writer. I'm doing calculations based on both data sources attribute information in attribute manager (arithmetic editor) which I guess changes the data to text with point separator. When I try to do thematic maps in other GIS applications the data cannot be read even though it is there and looks good on the surface and contains both calculated data and polygons. I suspect the reason is that attribute manager changes the information to text after calculations. Even if I manually change the data type to double in shape writer this doesn't help. Any tips? Also possible reason is the use of point separator (most often I use comma). I haven't updated all the transformers lately. (The error I'm getting from ArcGIS when I try to do maps from data is that layer doesn't contain

I am importing an AutoCAD DWG with multi-leader blocks for asset locations. The issue I am running into is that the value showing up in FME for the "TAGNUMBERS' is the Default value vs. the value that shows up in AutoCAD.  From AutoCAD: I'm trying to extract the 'T9' text from the MLEADERs shown here:  These are custom MLEADERS developed by the drafting department.  After different attempts to explode blocks, expose attributes both in Model and Paper Space, different combinations of parameters, etc. I attempted 13 different combinations to import the DWG and now luck, I keep seeing this in FME:  FME is only recognizing the 'Default' Tag Number.  I've tried to bring in both Model and Paper Space in a single reader to match Entity Handles, but no luck.   I also tried to leverage the multitude X/Y coordinates and came up with nothing.  If I explode the MLEADERs in AutoCAD first, the 'T9' shows up in the 'autocad_text_string' attribute as ex

Right now I have several parameters accepting a single attribute selection and a published user parameter that accepts multiple attributes (basically you select all the ones you selected above). I want to use a single duplicatefilter transformer to filter out duplicates of the several user parameters that have already been provided.

Dear FME users, I have the error: Error decrypting data. Most likely this is because the encryption key is incorrect. Please contact your administrator to retrieve the correct encryption key. System;Remote environment: Windows Server 2012 R2 machines with RDP (remote desktop)The workspace is managed by RES/Ivanti v10.2. with separate autorisationEnvironment variables for Oracle on serverPath=C:\\ProgramData\\Oracle\\Java\\javapath;C:\\Windows\\system32;C:\\Windows;C:\\Windows\\System32\\Wbem;C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\;I:\\APP\\Oracle\\Client11g\\X32\\Client\\binTNS_ADMIN=I:\\APP\\Oracle\\network\\admin and FME: PATH=I:\\APP\\Oracle\\client11g\\x64\\11.2.0\\client_1\\bin;%PATH% The netwokdisk "I" is mapped for every employee. Collegue:With 2 colleges we work with FME.In FME options we have the following in Default Path:Connection Data Directory : I:\\APPDATA\\FME\\FME_ConnPublic key file : I:\\APPDATA\\FME\\FME_Conn\\fme_publicKey.jceksPrivate key file :

My input is contour lines, I want to convert to raster. How can I do this? I was thinking contour->vector->raster, but i am not sure how to convert contour to vector. Any help would be appreciated

Dear All, I have GML with various types features like building, stream, road etc. In building feature member there are sub types like representation_point, roof_outline , roof_surface. My task is to extract only representation_point from building feature member. Kindly advice which transformer I have to use or steps to achieve the task. I tried xmlflattener but ended up with failure.

I am struggling to read two geometry columns from this database. If I set Handle Multiple Spatial Columns to "No", it only gives me one of the two columns. If I set it to "Yes", then I get the above error. What does it mean to have a "Custom SQL SELECT statement"?Mine is nothing fancy:select building_id, floor_id, space_id, agency_code, space_type, space_category,usable_sq_ft, obj.objgeom, SDO_UTIL.interior_point (OBJ.objgeom) from esm.esmobject obj join esm.att_space ats on obj.IDOBJECT = ats.IDOBJECT where building_id = 'BD0303' and floor_id = '01' It was also difficult to retrieve data tables. I had to type in each one. Luckily there were only two. If I let FME search for tables, it errors:My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer. Any info is appreciated. Thanks, Loren  

I've created a workspace server app which allows the user to select a projection from the list of FME coordinate systems and reproject their data. The desktop workbench has access to our FME server (e.g. \\\\A-FME\\FME\\CoordinateSystems) and is able to choose from the list of custom coordinate systems created by our survey department, but the server app does not list the custom coords. I've manually copied the custom files to the server (/a-fme/fmeserver/#/resources/browse/FME_SHAREDRESOURCE_ENGINE/CoordinateSystems?name=Engine) but it still doesn't list any of the coords. I've followed the instructions as stated here. Any ideas or suggestions will be much appreciated.

I am using a change detector before uploading anything to portal. I am able to use Inserted and Deleted without any errors. However, when I try to run anything from the Updated side it sends back the Error Code: "Operation rolled back." Any ideas as to why this might be happening

Hello everyone,This is the FME news for 19th January, 2022. Favourite Transformers PollThank you to everyone who took part in my "Favourite Transformers" poll over the last couple of days. Here's the top-ten list of favourites:  FeatureReaderTestFilterAttributeManagerFeatureWriterHTTPCallerAttributeCreatorFeatureJoinerTesterFeatureMergerSpatialFilter So in my not-very-scientific method, the FeatureReader is the FME Community's favourite transformer ever!   Some statistics:There were 65 different transformers mentioned. There were 4 FME Hub transformers on the list. The highest Hub transformer was the NoFeatureTester (22nd). The least-loved favourite was the JSONFragmenter.Of the most-used transformers, 6 of the top 20 were not anyone's favourite!Inspector, AttributeRemover, AttributeRenamer, StringReplacer, AttributeFilter, Counter I'm not sure why no-one likes the Counter! But none of my personal favourites made your top-ten, so I'm obviously no judge. My

Hello,I'd like to "remember" an attribute and use it to populate an attribute of another feature in the same execution.I thought AttributeKepper would do the job (because of the name haha), but the value of the attribute is empty, except in the first pass through the breakpoint. 

As the question suggests I cant seem to find instructions on how to convert LAS scans to GLTF format and retain the color_red, color_green, color_blue values. I've expereince with successful conversion of CAD models to GLTF but the resulting LAStoGLTF refuses to play ball. I've tried various combinations of reading LAS > use PointCloudPropertyExtractor to expose color data and even forced the issue with PointCloudLASClassColorSetter but all to no avail. The resulting GLB is created using default white colors leaving me with non-viewable model. Is this translation just too new a possibility for GLTF writer or am I missing something fundamental here (most probably I hope!). Thanks for any advice.Source LAS from Drone:Resulting GLB model:

module skp/skp is unavailable for use with this fme edition

Hi everyone,I have a series of regularly produced Excel files, each containing a number of sheets. The number and name of the sheets in each file isn't fixed.I can read data from all the sheets no problem by keeping the reader parameters blank - but annoyingly for these files the header starts on row 2 and in some cases junk is written into row 1. As such, FME picks up attribute names from row 1, so for one sheet the attribute for column B might end up named"995" and for the next sheet it might be "376", so I end up with a lot of attributes where there should be one - ideally just called "B".Is there any way to force the Excel reader to always use column letter as the attribute name regardless of how many sheets are in a file and what they are called?

Hi all,I have an issue when I'm running my workspace. It throws a Python error relating to what I'm guessing is something with the python version: File "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site.py", line 177 file=sys.stderr) ^SyntaxError: invalid syntax Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instabilityWarning: not all Stashed Objects that were registered were dropped before shutdown. This may cause instability I'm using Data Interoperability extension to ArcGIS version 2020.2 and have ArcGIS Pro 2.7.2, since I need to be able to write to an SDE and we dont have that license to our regular FME version. But I do have a regular installation of FME, so I'm wondering if the issue could be related to different python versions between the two? I do not have any individual python software installed - everything is installed via either FME or ArcGIS. Another colleague has experie

Hi There,I've got a question that seems to appear a fair bit within the forum but I have so far been unable to find a methodology that works for my case.I'm attempting to identify water mains within a water distribution network that have accidentally been duplicated, incorrectly split and not removed, or more generally are errors that went unnoticed. What I think it boils down to is isolating where lines overlap exactly (Scenario B of attach image), where mains have been split and a segment wasn't retired/removed when (Scenario A), or where a segment was completely replaced the old segment wasn't removed or retired (Scenario C). *Orange segments below are the erroroneous segments I'm attempting to isolate.From the forum posts I've read here there's a lot of talk of using the LineOnLineOverlayer which I have tried using. However, I'm don't want to report on valid intersects where mains are connected to each other. I've have some difficulty trying

https://www.railml.org/index.php/en/

I can't create the exact footprint through RasterExtentsCoercer, even i have set the Extents Type as 'Data Extents'. The transformer only allow me to generate a rectangle that covers the entire extents.My aerial imagery is in RGBA, possible the alpha band caused this issue. Is there a way to create the exact footprint?PS: i have attached a sample image.Thanks and Regards,Jian

HiI have a LAS (LIAR) file and I want to convert it to GLTF. FME can help me with the task? Does the trial version work for me? 

Hello everyone, So I would like to generate a HTML report by using "HTML Report Generator".For the final product, I would like to generate the report with the "current time" on the HTML page. This is what I write in the text editor:   KE Indoor run on @DateTimeFormat(@DateTimeNow(local),ISO) The output is:   KE Indoor run on 2022-01-18T16:58:52.1754106+08:00 However, this is what I want for the result:   KE Indoor run on 2022-01-18 16:58:52 May I ask how can I fix the problem? Thank you in advance.

How to back-up FME Server content. I can find articles on "configuration" backup - but how about content?

Hello,  I have an issue with generalising contours inside a tiling system. All contours need to match at tile edges, hence a surface tolerance of 0 is required. When this happens, vertices are added in what seems to be every 0.1m. Therefore i need to generalise.  The standard generalizer causes overlaps between different elevations, so the only option is sherbendgeneraliser but it takes an age with the amount of vertices. I have tried adding a generaliser with 0.1 tolerance before the sherbend generaliser but this also causes overlaps. I want vertices roughly every 5m or so in the output. Question:How do i fix these generalised overlaps?is there a quicker way to speed up sherbendgeneraliser?