Transformers

I need to split the data below into 2 recordsie . 01_GF_CR should be 01_GF_NH and 01_NH_CRhow would i go about doing this ? thanks Line Segment - OnePlanRoute Name - OMEGA01_GF_CR01_GF_NH 01_NH_CR02_GF_CR02_GF_NH 02_NH_CR03_GF_CR03_GF_NH 03_NH_CR04_GF_DN04_GF_NH 04_NH_DN10_EB_ENR10_EB_EBE 10_EBE_ENR13_CR_GF13_CR_NH 13_NH_GF26_BH_SM26_BH_IB 26_IB_QS40_QD_QB40_QD_IA 40_IA_QB

Hello!I have two datasets of lines - streets and roads. I would now like to get all intersections of streets and roads as points, but not intersections of streets and streets or roads and roads. I tried the transformers "Intersector" and "LineOnLineOverlayer" but both only have one input. So how can I sove this problem?Thank you, Stefan

HelloI have two datasources: one is sde featureclass with status quo data, the other is a WFS-Service, which supplies more current data. This data I compare with Changedetector on their geometries and could change this succesfully (-> the geometry) . But now I have the problem, that both dataset have a totally different nongeometry attributes. I don't need the nongeometry from the WFS. But after the delete and/or insert process of the ChangeDetector i lost the old nongeometry attribute information from data, which for example in the new StatusQuo a geometry is now split to two geometries. Has someone a workaround for a solution for this trouble?Sorry for my english, but I hope you understand my problemThanks

Dear Community,  I would like to integrate one external library called pyntcloud (https://github.com/daavoo/pyntcloud) within a workspace. I have made some testing within conda environment and everything worked perfectly.  However, when I wanted to run it within a FME workspace there was a problem with a package. The following error occurs:2020-06-30 15:43:16|   0.5|  0.0|INFORM|Using Python interpreter from `C:\Program Files\FME\fmepython37\python37.dll' with PYTHONHOME `C:\Program Files\FME\fmepython37'2020-06-30 15:43:16|   0.5|  0.0|INFORM|Python version 3.7 loaded successfully2020-06-30 15:43:16|   0.5|  0.0|INFORM|Adding folder `C:\Users\SAVe\AppData\Local\Temp\' to the python path2020-06-30 15:43:16|   0.5|  0.0|INFORM|Emptying factory pipeline2020-06-30 15:43:17|   1.3|  0.8|ERROR |Python Exception <OSError>: [WinError 126] The specified module could not be found2020-06-30 15:43:17|   1.3|  0.0|ERROR |Error executing string `import<space>fme<lf>import<space

I'm having some difficulties with an translation of an Excel file that contains a normal table kind of structure and needs to be transformed to another more layered kind of structure (Kind of reminds me of a xml) in Excel. The input is as followed:And needs to be transformed to this output:I managed to get a semi result using the AttributeSplitter and work my way from there but it is way to hardcoded to be useful. If a Sub folder 2 or another task is added it needs extra work to correct it. When done i would like to add some extra tasks later so best to prepare for it now. How can i loop through the folder and name attribute and build up the structure so i can add the description and result in?Any ideas on how to tackle this problem?And is there a way to use the indentation option in Excel like the result above?

Hi guys,Pretty new to FME so any help would be greatly appreciated.My client wants me to use FME to produce an Excel sheet that will show the ‘Expected layers’ and ‘Unexpected Layers’ in a given DWG file and a count of features per layer. I am able to use a Tester to filter for the ‘Expected layers’ and ‘Unexpected Layers’ but I am having trouble making an Excel document that will make each Expected layer the head of its own column. Right now all the Expected layers are coming in together in one column and without a count. I'm assuming I have to breakdown the 'autocad_layer' found in Format Attributes in the reader into new attributes based on the list of ‘Expected layers’ that I have? I have been playing around with Attribute Splitter, Attribute Manager and Attribute Exposer all to no avail.. Hopefully someone can point me in the right direction. Thanks in advance,  Fred

Hello Therewe are using Google static MAp Api in order to fetch static MAP for the linesince the api take the center point we thought we should use the bounding Box, get the center from there, but we are missing the zome level that should cover the entire linehttps://maps.googleapis.com/maps/api/staticmap?center=40.714728,-73.998672&zoom=12&size=400x400&key=YOUR_API_KEY we are using image fetcher transformeror do you have any other way to do it Thanks

Hello, I have a Smallworld database in a coordinate system that I cannot find (or are not) in FME Workbench.The main data:- Datum: ETRS89- Ellipsoid: GRS80- Type of Projection: Cylindrical, North UTM- Zone: 30- Origin of Latitudes: 0.000 m- Origin of Lengths: -4000000.000 m- Units: mmAttached image:I have tried the Safe web assistant but I think something is wrong. It looks like this:COORDINATE_SYSTEM_DEF Prueba_CABB \\ DESC_NM "Para CABB" \\ DT_NAME ETRS89/01 \\ PARM1 30 \\ PARM2 1 \\ PROJ UTM \\ QUAD 1 \\ UNIT METER \\ ZERO X 0.000 \\ ZERO_Y -4000000.000 But I'm not sure it's correct. I would greatly appreciate your help Regards Luis

Hello,I've setup four Workbenches, which I successfully get to run in sequence from a "mother" Workbench, which uses a sequence of Workspace Runners, waiting for each one to complete before calling the next one.It works seamlessly when ran from FME Workbench. But, I really need to automate this (this is what it's all about - I can't always be around to press the "Run" button unfortunately...).This is my first attempt in calling Workbench(es) via command line, and I just try the obvious: fme "C:\Users\User.Name\Path\Projects Shared\Project_Name\configs\4_Workbench.fmw" I tried first with the "mother" Workbench, and it failed. So then I tried with individual work benches, and they fail too. I logged separate log files for each of the five Workbenches (mother + 4  called by the Workspace Runners), and the logs for the 4 Workbenches called have a similar error (I did change some names on purpose, to preserve names of people etc. in paths and file names): ERROR |FeatureReader_4(QueryFactory

Hello Thererunning a simple workspace with Mapnik, the input is a line but I am getting box, no idea why   

Problem: I download rasters (satellite images) with differten extends (but overlapping) and different cellsizes. I can not get them to align, whatever I do. I tried: - setting the largest to 'nodata' and using the rastermosaicer. I get an error showing a different number of rows. I also tried it by setting all data to 0 and using the target raster in mosaicer with 'maxiumum' as setting.- The above for both rasters (I was running out of ideas)- Exposing the raster properties of one raster and trying to use the raster resampler to resample the second raster: I get a rejected raster with this weird error: @%0: Failed to obtain raster from feature. Only features with raster geometry are expected - Exposing the raster properties and using the raster georeferencer (the raster gets rejected INVALID_FEATURE_ATTRIBUTES)  and many, many more things. I can not get them to align and could use some help FME version 2020.0.0.1

Is there a way to view the Message from SQL/SSMS after running a SQLExecutor on a stored procedure?Context:We have stored procedures written for importing and validating records. The validating stored procedure (which runs other individual stored procedures) returns a log/report of any issues with more of a textual format than a table.When attempting to expose the output message from SSMS in the SQLExecutor, the only option you have is to expose specific attributes. This doesn't work with the log format mentioned previously.I've reviewed other forums related to this topic where others have had to go outside of the norm to accommodate this, but I think this should be addressed within FME to relay messaging from SQLExecutor from theRelated Forums:https://knowledge.safe.com/questions/82948/sql-executor-run-a-procedure.html 

I have some start and end dates for activities. The start dates need to be created in FME using the previous activities end date plus one day, however if this date falls on a weekend I need to tell it to return the next working day. It would be even better if I could also exclude bank holidays along with the weekends. Any thoughts or ideas on how to do this would be greatly appreciated!

Using Snipper with a geometry that is composed by a IFMMEMulticurve, The Snipper returns 2x the values expected (as the multicurve includes 2 IFMELines).Let's take a look to the example: this is how it is seen on the Data Inspector: IdValuea = 10b40c60 Something like this sketch is the result:the points that their measure are beyond the minimum/maximum measure of the line, are located at the beginning/ending of each segment. How could I manage this behavior? 

Hello,I am trying to create what I would call a pivot chart in excel using FME, I have managed to input my data which represents the number of exports from a certain area of a building by date&year; (similar to below - however my table has a lot more rows as it runs to 2030).DateAreaNumberUnitsExported01/01/2020Area 1501/01/2020Area 2401/01/2020Area 31001/02/2020Area 1201/02/2020Area 2801/02/2020Area 31101/03/2020Area 1101/03/2020Area 2501/03/2020Area 38Basically I am trying to get my data to look like this:-Area 1Area 2Area 301/01/2020541001/02/2020281101/03/2020158so that I have the date running down the side, the Area Number as the table header and the units exported in the relevant cell corresponding to the correct area and date. I would then like to export this as an excel fileHow should I go about achieving this?Thanks,Tom

Essentially I want to use an Attribute Value Mapper against a list. I have a csv lookup table of old ID's and new ID's. Then in my workbench I have a json attribute of a configuration file, which I send through a regex string searcher to get a list of all the old ID's in the config. Is there a way to replace all the old values in the list for their looked-up values from the table, so I can then reinsert them in the config? Or should I just hand this step off to python? I have about 20 features going through the workbench and around 60 features in the lookup table. Each json attribute has anywhere from 5-50 matches feeding the list. I've also looked at the List String Replacer but it doesn't allow me to import the lookup table like the attribute value mapper does. I'm not seeing a way of doing this keeping the transformers under a handful. How would y'all approach this problem? Thanks

Hi group (especially @mark2catsafe I think).Is it possible to build a custom transformer with Python with multiple INPUT tags? Much like what's possible with a custom transformer in Workbench.I have the multiple OUTPUT tags option covered, but can't seem to find any examples of multiple INPUTs.I've scrutinized an FMW file with an embedded custom transformer with two input tags, but can't find anything relating to tags, just a bunch of TeeFactory's.Is it possible to make one such? And if so, how should one define them in the FMX file?Cheers Lars

Hi,I would like to extract the project listing as well as the corresponding Lat/Long from the map content together with its attributes such as Project Title, Location, Project Type, Status etc. from the project linkurl: https://iaac-aeic.gc.ca/050/evaluations/exploration?active=true&showMap=true&document_type=project Sample project url:https://iaac-aeic.gc.ca/050/evaluations/proj/80774 I have limited past exposure to htmlextractor, any assistance will be much appreciated.

Hello,I have two layer of networks, one is base (red line) and another is candidate (black lines). Want to populate ID in candidate layer as per connectivity with base. All first intersect of candidate layer should get ID 1 then remaining lines should follow the order. Any help? Thanks in advance.

Hi Folks,I got a set of 235 points and I need to cluster them, but based in two parameters. I need to spatial optimizer them in clusters of max 5 points and maximum distance between them of 15 km or in groups with less them 5 points and maximum distance between them of 15 km. I am trying to use a NeighborFinder approach, but I got strugle into points that could be in on or more clusters and because of this, I don´t know how to optimize them.Any ideas or tips?

Hi Everyone, I have quite an interesting question on how one can "Rate" your Input data in the FME workspace. The idea is to use some predefined questions, and then check the Workspace if the requirements are met. If the requirements are met, the Evaluated table gets a Rating/Value. Once this is done, an HTML page is exported with the rating.  I have made an example, but I find the process to be quite tedious, and can be a bit overwhelming on bigger workspaces. My Question is: Are there better ways to rate tables and create ratings on quality of the input data? Or should I rather work with loggers? So in my example, I have a table to Evaluate. I am using three different "Codes" to use for my Rating system Using Statistical Calculators, Aggregators and FeatureMergers, I add the Rating "CODE", to my Evaluated Table.  The Workspace:   The final result is a HTML: 

I have a sql executor using an ODBC connection with parameters in it. The params are fed by published params and an inbound reader [into the executor]Only a few small columns are returned and typically less than 200 rows.-When I run the query with params it errors about every other time. Not much detail in verbose just 'Error running translation.' Then it terminates.-When I attach a logger to the result of the SQL executor the translation never errors. -When I hard code the sql executor [just for testing with no params] it never errors. Unless I have nothing attached to the 'result'.- In short the translation works with a logger attached to the 'result' of the sql executor regardless of params or no params, it fails with nothing attached to the 'result' regardless of params, and it works occasionally with params and no logger attached. I can run the translation in production with a logger attached but why do I need to? And why doesn't it work without

Hi.I'm trying to find self-intersections using GeometryValidator but it just keeps passing all geometry. What am I doing wrong?Above is a zipped shape file which I've tried running through a GeometryValidator in multiple versions of FME. 2015, 2017, 2018, 2020. Checking for self intersections in 2D. Always passes no matter what settings I use. Here's a screenshot.It's originally a rectangle that I've twisted so that it self intersects in the middle. To me it should be obvious that there's a self intersection but as mentioned the GeometryValidator fails to detect it. Does anyone know what the problem is? 

I've been experimenting with the chart generator transformer and can't seem to get the background color to change, even after I change the color using the "Background Color" parameter under the Style section. This is for a bar chart. No matter what color I change it to, it will only keep the default white color RGB(1.0,1.0,1.0).  It won't change the color in the preview or after I write it out to a png. The documentation states: "This parameter sets the background color of the chart. The default background color is white, with an RGB value of 1.0,1.0,1.0."  FME 2020.0.0.1  

Hello everyone!  There were two adjacent DTMs with different resolutions(one is 0,5m and the other is 5m.). I resampled them to bring together and mosaick at 1m resolution. There seems to be no problem with 0,5m res. area in the mosaicked image, but after the resolution is reduced for 5m area, defects like a stair steps appear in 3D view(as seen in the image). So, how can i get a smoother suface for the downsampled area from 5m to 1m. Which transformers or parameters should i use in my workflow. Thanks a lot. @daleatsafe @daveatsafe @takashi @jovitaatsafe @redgeographics @deanatsafe @rylanatsafe @hollyatsafe @lenaatsafe @annabelleatsafe @steveatsafe