Transformers

FME(R) 2017.1.2.1 (20180117 - Build 17725 - WIN32)I have a data set in SDE that contains multiple records for a single pipe segment. Pipe size (CONDUIT_WI) is an attribute that can change in these records. Below is the transformer configuration that I have attempted to get the max value of the count attribute. But I keep getting empty results. I have tried different configurations with no success. Any Help is much appreciated.

I want to launch Command Prompt from within FME Specifically, I want to actually launch the command prompt screen. If I put "cmd.exe" (or a variation) into the SystemCaller, it just runs and logs the text you would see in Command Prompt I actually want to launch command prompt. It needs to be launched as it requires user interaction that is not present in the workspace and cannot be fed by a parameter 

I have a dataset with various depth zones that I am trying to process by running a DonutHoleExtractor, then removing some of the polygons that I don’t want based on certain rules and lastly rebuilding it all with a DonutBuilder. This works fine for the depth zones but some of the areas that are land, white in the maps below, get turned into depth zones. This is not surprising, but I would like to find a workaround. I looked at using the holes from the DHExtractor to punch holes in the last step, but the ”land holes” get the attribute data from their surrounding depth zone, so I have not found a way to single them out.  Any ideas to how exlude certain areas when extracting donuts? Or maybe you have a better idea for a workaround?  Please note that this is a follow up question to, https://knowledge.safe.com/questions/81896/selecting-square-ish-donuts.html  The brown map is the original data and the green one is after DonutHoleExtractor

I have a very simple workspace. A DTED reader which is set to read a few thousand .dt0 files. This feeds into a Sorter transformer, which sorts alphabetically on fme_dataset, and finally outputs to an Inspector When exactly 506 features have entered the Sorter, all subseqent features gives the errorERROR |DTED Plugin: Failed to open file Z:\raw\Elevation\Global\DTED0\dted\e016\s05.dt0.WARN  |MULTI_READER(DTED_1): Skipping to next Readerand only the first 506 features are output from the Sorter. This happens regardless of which .dt0 files are read, the limit is always 506 features.This seems like a bug in the DTED reader to me, because a DEM reader does not give the same error.I'm using FME 2018.1.0.0

Hi,When trying to write I am receiving"The error message from ArcObjects is: {Number of parts in shape is incorrect for its geometry type}"FME 2018.1, Postgres 9.5.9, config keyword: PG_GEOMETRYIsn't multipart writeable?Same input data written to file geodatabase and copy/pasted to sde with arccatalog works.Regards,Richard

I am reading a large ECW file and clipping out a section then writing it to ECW again. Does anyone know how FME manages ECW compression. The writer by default is set to 75% compression but the ECW file is already compressed. Does the writer honour the original compression settings or is it further compressing a compressed file? Should I set compression to 0%? Also I can't seem to find a concise answer on whether FME now handles ECW v3 images?

I have a google sheet I am trying to read in that has Timestamp as an attribute, mm/dd/yyyy hh:mm:ss. I want to only read in those features that fall between provided dates and time - say the records between 09/22/2018 12:00:00 to 10/22/2018 12:00:00. This time range will change each month. This all feeds to a monthly report but the google sheet is cumulative.Is there a way to create a user parameter to read in only the dates wanted?The other problem I have is that the reader does not appear to be reading the Timestamp as a date-time format although it is formatted that way in the sheet. Right now I am using a Tester after the reader and set the mode to date/time. When reading the data, the Tester shows "Unable to do a date/time comparison... Comparing as strings instead". None of the records pass the Tester, 74 of them should have passed. How can I set the Timestamp attribute to be read and processed as date-time?

We are syncing data of Smallworld with GSDS (Geo Spatial data Store) which is an oracle database, reprojection is taking very long time to process. It takes more than 2-3 hours to process the same number of records which used to get processed in half an hour before August 2018. We have custom coordinate system defined for reprojection. What could be wrong here? how can this issue be fixed. Please help

I would like to filter a view based on the current time -1 day. I have the correct date format working in FME, an attribute creator returns the right value - in the format SQL Server requires.Unfortunately it appears that the string is being parsed. MS SQL Server Spatial (JDBC) Reader: Executing SQL: SELECT [title], [user_email], [LOGIN], [COMPANY], [request_date], [theme_id_list], [age_min], [age_max], [request_area], [download_status], [ROW_CREATED_DATE] FROM [dbo].[V_SELF_SERVICE_ACTIVITY_REPORT] WHERE [request_date] > CONVERT(DATETIME, '@DateTimeFormat(@DateTimeAdd(@round(@DateTimeNow(),2), -P1D), %Y-%m-%d %H:%M:%S)', 102)com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting date and/or time from character string. The where condition:[request_date] > CONVERT(DATETIME, '@DateTimeFormat(@DateTimeAdd(@round(@DateTimeNow(),2), -P1D), %Y-%m-%d %H:%M:%S)', 102) In the attribute creator which returns correctly it is:@DateTimeFormat(@DateT

I've got a table with POSTCODE_FROM and a POSTCODE_TO attributes, constituting several alphanumeric ranges, for example:(from) 7887AA (to) 7887AA(from) 7887AB (to) 7887AC(from) 7887AD (to) 7887AJ(from) 7887AK (to) 7887BBEach feature has a FROM and a TO value and I would like to determine all in-between values, e.g. 7887AE, 7887AF, 7887AG, 7887AH, 7887AI. Does anyone know what (sequences of) transformers are capable of doing this?

Hi, I am trying to run a workspace and it fails due to memory issue. In my workbench, I am using line divider which stores feature in a temp file and it fails after a while at this transformer.Can somebody suggest what I can do to optimize the WB?

Hello everyoneas can be seen in the picture above , I have a Multipatch 3D Urban Model with Lod2 detail level and my Multipatch 3D urban model in GDB fileI want to convert the 3D urban model to Cesium 3D tile format.I'm trying but I can't create the json file.Can you help me

Hello:I have an issue that I can't seem to understand. I'm new to JSON (in fact this is the first json output I've ever created). I have a structure that has a ROOT and SUB. The JSONTemplater says my current structure is valid and produces the file. However, when I run it through https://jsonlint.com/ the results are invalid. So, I looked at the output of what another area is expecting and I manually modified the file to see if the updates I made were valid. The short of it is, I need to modify what's in my JSONTemplater to add a comma (,) before each NEW record and add brackets ([ ]) around the entire output file. EVERY attempt I've made in modify the JSONTemplater has failed or I get an error. I'm loosing it! :) I've attached the file I manually revised and the one from the actual results of the workspace. Can someone tell me what's wrong with my JSONTemplater? ROOT Structure:{   "totalInvestment": xs:double(fme:get-attribute("tota

Is it possible to read constant properties from an Autocad block?Constant properties are never changing in a block and can be displayed. This is an example:It shows 1 block, with some dynamic attributes ('12 345'). The 'N' is a constant property, so there is no attribute defining it.My questions is: is there somehow a way to read this information?I am aware it is possible to explode the block and extract this autocad_text entity, but that is not the solution I am after. 

Hi,I plan to install a fault tolerant FME Server 2018.1. I would like to install 2 systems that each have 2 engines. A load balancer will manage the requests to these 2 systems (as below)I have 2 questions:1/ Is it possible to dedicate one engine to a "message streaming" workflow (WebsocketReceiver/WebsocketSender). Let say the engine1 of the host1.2/ Is it possible to send "big job" only to the engine1 of the host2? In my comprehension, I will have to duplicate queues on both hosts so it seems not possible to only use one engine... Thank you in advance! Laurent 

Hi there, The MRF2DCleaner plugin for FME Desktop contains some very interesting transformers. I am however, having a hard time finding the link for a trial or full version download. Where can I find that? I've already reached out to the sales people of MRF but they answered that I should ask safe for the prices and download.  Can anyone shed some light on the origin and availability of this plugin. Cheers Rolf

I am trying to make a chart with XY coordinates generated from the Profile Generator. I have two inputs and trying to plot both on the same chart with different color. I can run with one dataset, but when I try to run with data series it gives me this error: ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numeric.

Hi, everyone, I meet some problems when converting the CityGML file to glTF file, the export city model is divided into many parts (Building, WallSurface, RoofSurface and GroundSurface). I want to know how to integrate them into one complete city model. Thanks

I have an ArcSDE database on SQL Server 2016 and I want to delete features from a condition.Each night I want to delete thousands of points older than 30 days from now.My points layer has a datetime2 field (created_date).I thought using the SQLExecutor to do this and run this script.DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())Unfortunatly it doesn't work and I don't understand why. The log doesn't say much :Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Â Query Text `DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())'. Provider error `(-2147217871) Query timeout expired'If I replace DELETE by SELECT *, it works though.Is there any SQL beast here who would know if it's my query or FME the problem? I don't have access to this SQL Server, so I can't test my query over there.For sure I could create a procedure straightly in SQL Server, but my FME script is doing a FGDB backup of those points bef

HelloI'm looking for the rasters that are in the same polygon to assemble them and then cut the mosaic according to the polygon.In this treatment I try to remove the black edges of the images to make the mosaic but I still have black pixels.Thanks D045_3P_79_4_0001.zip

I am using the QGIS plugin "QGIS2WEB" for publishing spatial data into webmaps, written in javascript. The plugin converts all the data showing into .js files, stored in a data registry. Now I want to replace/add spatial data manually, without using the plugin. Is there a way to convert and export spatial data, e.g. json as .js with FME? Thank you.

I have 3D polygons where I need to calculate the aspect for each polygon and add it as attribute. Is there a way to do this? I found a transformer to calculate the aspect for raster but not for vector ,is there a way to go around? Thanks !

Hi,I have the building data captured through stereo plotting process. My task is to create citygml using this data, when I try to extrude the feature using "Extruder" transformer(ref attached screenshot Extrude.png) the building is not extrude properly (ref attached screenshot Issue.png).Same building I tried in Arcscene using the extrusion option, it rendered properly (ref attached screenshot arcscene.png)  Kindly help me to resolve this issue. Regards,K.Jayakumar   

From this Q&A: Replace attribute values for all attributesMy first idea was to use a StringReplacer to replace every attribute with '0' if it matched the regex '^0*$' (0 or more '0'), '1' otherwise.I thought it should work theoretically, but the StringReplacer replaced '0' with '1' in fact.If you set a character (e.g. 'x') other than '0' to the Replacement Text parameter, it worked fine.I'm afraid that there could be a bug here. See also the attached workspace. (FME 2018.1.0.3)Original:Unexpected Result: Every <empty> was replace with '0', but '0' was replaced with '1'.Comparison: Every '0' and <empty> was replaced with 'x'.

hi guys,I have an NW line FC, I need to locate the overlapping in this NW as a point in a new FC any suggest?