Transformers

Hello there II have an attribute with the values like this (24 16 17.2) or this ( 25 7 17.2) we need to replace the first space with a letter A and second space with letter B and add letter W at the end we should get a result like this (24A16B17.2W) and this ( 25A7B17.2W) for the second caseAny idea, please Thanks 

Hello, I have an entrance like this.   I would like an exit like this.  How to do it ? with the transform AttributeSplitter ?  Thank you

I am reading a CSV file and need to change the values of one of the attributes according to the count of these values. The values are typically in the range of whole numbers 1 - 6 (might be more) with various total counts. I need to change these values so the most frequent gets a value of 1, the second gets 2, third gets 3 and the rest is deleted. In the example below: 6 is changed to 1, 4 is changed to 2, 1 to 3 and 2 is deleted. If the counts of any values are equal I should get an error.  Attribute name6666444112  Thank you for your help. 

Hi, I try to repeat this sample of LRS-Tasks on my data:Probably a beginner-question: How can I set/transfer the attribute 'von_km_l' as startvalue in my MeasureGenerator? After the five line segments are joined in one NLE(network linear element), I got the attribute on the treats:  As you see, the needed value is avaliable within the trait-attribute. But how to set it as startvalue in the MeasureGenerator?Thanks and best regards from Berlin,Christoph 

Hi,Is it possible to use FME functions like @DateTimeFormat in SQL Editors ?I would like to use the "SQL to run before write" field in my writer to create a backup of the destination table whose name contains the current date as suffix.Example:create table myschema.mytable_@DateTimeFormat(@DateTimeNow(), %Y%m%d)) as select * from myschema.mytable; But this doesn't work, even with single or double quotes around the FME functions... Thanks for any help,Christian

Hello.I have two entries : a rectangle and a numeric raster. The bounding box of the raster is included in the rectangle.I wouldlike to create a new raster with a bounding box corresponding to the rectangle (area outside the initial raster filled with nodata).The clipper can be used for such operations when the raster is wider than the rectangle but in my case, the clipper result bounding box is an intersection of the inputs.Do you know another way to proceed ?Thank you in advance.Paul

I have a problem with geting the backupConfiguration.fmw to work and have now looked into this problem alot. The error message I get is:  HTTPCaller(HTTPFactory): HTTP/FTP Transfer: Failed to create file 'C:\\ProgramData\\Safe Software\\FME Server\\resources\\backups\\' for resource download ''url'' The below feature caused the translation to be terminated Storing feature(s) to FME feature store file `C:\\ProgramData\\Safe Software\\FME Server\\resources\\logs\\engine\\current\\jobs\\229000\\job_229856_log.ffs' (This logfile does not say anything more than the info above)  There seams to be a problem accessing resources\\backups, but the user have this access and fmesuperuser role .If I use the url and token in a browser I get the backupfile.  Anyone knows about this? Best/Johan

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