Transformers

 Hi allI would like to find out below the points which are X and Y, what the chainage is for each point?The line I have is the road which has a chainage to and chainage from for each section. But i want points to automatically link to line so it picks up the road chainage.What would be the easiest way to find the offset of the points to the line? I also have an option of point to point, so find nearest point that it can offset to if that option is also possible.Much appreciated

I am trying to set-up a very simple converter that takes one dwg with defined layer names and output to a new dwg that matches the layer names that we want then to be called. Unfortunately all feature_types in the output end up the same feature type.  

I have to add 2 Vertical Coordinates systems to add to FMEThese are: WKID 6647 (CGVD 2013) Orthometric WKID 5713 (CGND 1928) Normal-orthometric*I have all the required grid files in .byn format and installed, that I understand to be able to work with the CSReprojector.I'm trying to use the online Define Custom Coordinate System from FME to create a custom coordinate system for 6647 and 5713. I have the ESRI WKT info needed however I cannot submit because I need to reference a Datum. However the datum is vertical and is: Canadian_Geodetic_Vertical_Datum_of_2013 and Canadian_Geodetic_Vertical_Datum_of_1928 And does not appear in the list of Datum's.How do I do this, do I even need to or are the .byn files enough when working with the CSMapReprojector?A second further problem is the CSMapReprojector asks for "Vertial handling" as seen here. With items like "Geocentric or ellipsoid height -> Orthometric height". However I have: Normal-orthome

How can I separate every single word from the string e.g. “GROUND ROUND STATION 49” in String Searcher by using regular expressions? I have never used regular expressions earlier. Expression \\s*(\\w+)\\s* can select first word “ground” but how to obtain 2nd word, 3rd word, n word in single separate columns? By trial-error-method I got the second word by applying this expression \\s+(\\w+)\\s+. However how to create more general expresion? 

Currently I have a schema mapping table stored on a ESRI Geodatabse table. Trying to use the SchemaMapper I found that the reader does not allow me to select the ESRI readers:I tried to create a custom reader that connect to the ESRI Geodatabase, but the SchemaMapper does not recognize my custom reader neither.what should I do in order to be able to extract the schema mapping table for the SchemaMapper from the geodatabase?, or how to enable the custom reader? thanks

is there an easy way to clip a raster based on a shape file with a feathered edge? So use the "clipper" but not just end up with a harsh cut, as I want to merge this with another raster dataset and for them to blend in. or is the "Alpha Compositing: Blending Two Raster Images" method the only realistic method?  The effect i'm looking for is similar to that of a feathered lasso in Photoshop.

I'm trying to replace the per mille sign ‰ to the other symbol with StringReplacer, but this function seems to not work for this particular character. As import file I use .txt-file. Is it a known issue? Is there a workround for this problem? I work with FME 2018.1  

I am using Kafka connector to consume data from Kafka topic.Kafka topic has 5 partitions.I want to configure FME job in such a way that Kafka connector consumes data from topic at partition level making partition as unit of parallelism for better speed. Is Kafka connector has inbuilt feature to handle partition parallelism hiding from developer. That way I can be assured of parallelism taking place with single kafka connector in the job. Please confirm.

I'm trying to call a PowerShell script using the System Caller transformer. The syntax of the system caller command line is: C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe -ExecutionPolicy Bypass -file "C:<path>powershell_script.ps1"I'm using it to access ProjectWise and run some process. I have tested it with PowerShell and it only works with Admin rights. However it does not work within FME and does not recognize the Powershell module commands for ProjectWise. The error I get is:'New-PWLogin : The term 'New-PWLogin' is not recognized as the name of a cmdlet, function, script file, or operable'I have tried running the workbench with Admin rights but it still gives the same error.

Hi I tried to install NLP Trainer on my desk but I received an error (probably python installation)  Francesco 

Hello everyone, I have a workspace that takes 2 point feature classes from a geodatabase and calculates the Root Mean Square Error (RMSE) of the x and y coordinates (i.e. sqrt( x(observed) - x(predicted))**2/n)). As part of this calculation I would have to do a truncated mean calculation where I would drop the top and bottom 10 % of records of residual X,Y values and then calculate the RMSE on the remaining 80% of the records. I understand the statistics calculation for truncated mean but I am not sure how to do this in FME workspace. Any help/suggestion is greatly appreciated. Thank you!

How do i compare data row count from two tables across two databases? Basically i am trying to load data if source has more rows than target table.

Hihow can Export right value of tester into csv file ?ThxFrancesco  

I am trying to setup a workbench for change detection where multiple users will upload data for change detection. I need to be able to handle the following cases1. User 1 adds features to fgdb and uploads. Writer fgdb has 4 features now2. User 2 adds features to a separate fgdb that does not contain user 1 features. Writer fgdb has 8 features now3. User 1 now has fgdb with all 8 records, he deletes two records and uploads. Writer fgdb should have 6 features now.Here is a screenshot of my workbench. I can get item 2 to work but not 3. 

FME'ers!This was asked in some capacity, but I can't seem to get this to work after reading all replies / documentation / trying numerous things.Problem: Split a single polyline into multiple lengths based on a table of measurements.Attempt: FeatureMerger (to get the geometry into the table of measurements)MeasureGenerator (to apply geometry)Snipper (to clip the Merged output based on two fields in the measurement table)Additional Info: Polyline is projected, US Feet, reading from a GDB, writting to a GDB*I assume I'm missing some logic in the Snipper or missing an iterator of some kind? I've tried numerous iterations of starting/ending, etc. My output is the correct number of records but no change to geometry / length) In other attempts, my output was flattened to the end of the polyline (correct number of records, just geometry at a vertex at the ends of the line).Losing my head about this one. Any insight would be massive!Many of you have chimed in previously, and I

Hello,I'm a student from Czech Republic and I'm designing sewer pipes in a sub-programme of AutoCAD. I've exported my project into 3D-DWG model. However I need to export it to IFC so me and my classmates can put it together with other parts of the building as well in IFC.I've read that this software can do this so I've downloaded student version. But I've just started it and I really don't know what to do. https://knowledge.safe.com/articles/595/autocad-to-ifc-conversion-example.html - this tutorial wasn't really helpful neither. Can you please tell me exactly (step by step) how can I transform the 3D-DWG file into IFC? Here's a screenshot of the model:Thank you all for reponses.

HiI would like to transform from DWG to TAB. My DWG's are currently in tile format, they each have a name eg. 1234.dwg and then within that they have multiple levels, so Road, building, Vegetation etc. Would it be possible to get this to directly translate into TAB. With a single tab file and then within the file I would have the multiple levels?Thanks for any help. B

Can I add my own fonts (Truetype or OpenType) to FME Cloud? Where do I place the files?(let's assume I have the relevant license to use the font on a server)

Hello all,Can anyone help me in transforming my feature schema as per the included screenshot? I need to create new field names based on distinct data values held within the existing ‘Attr_Type’ field, and then populate these new fields with the relevant ‘Attr_Value’ value.I’m using FME Desktop v2019.0.2TIA,RB

Hello. I have created this workspace before for other datasets without an issue, but for this particular dataset I'm getting the following error when trying to update or insert:MS SQL Server Spatial (JDBC) Writer: Updating using SQL: UPDATE [lccgis].[DRA_TASWATER_SEWER_LINES] SET [Material] = ?, [Diameter] = ?, [InvertLevelDownSteam] = ?, [InvertLevelUpStream] = ?, [JointType] = ?, [PipeClass] = ?, [SurfaceLevelUpStream] = ?, [SurfaceLevelDownStream] = ?, [Class] = ?, [SHAPE] = ? WHERE [MXASSETNUM] = ?MS SQL Server Spatial (JDBC) Writer: Error writing feature. Error: <null>delete works fine. Any ideas much appreciated.Lara

ESRISHAPE writer: 129837 of 361189 features writtenDBF Writer: DBF file exceeds maximum size of 2 GBUnable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Unable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Destination Feature Type Routing Correlator (RoutingFactory): Unable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Stored 1 feature(s) to FME feature store file `C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV -1 2 -1 0 19480448bc73853f0954bf85b3af46ed9e867a09.ffsupdating'Saving spatial index into file 'C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV -1 2 -1 0 19480448bc73853f0954bf85b3af46ed9e867a09.fsi'Finished saving spatial index into file 'C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV

Hi!I'm looking for the attributes that contain autocad model units and block units.I looked on the attribute to expose but I don't find the answer. I test some attributes but there are only empty on the attributecreator. I checked the attributes on the reader, I use AttributeExposer and AttributeCreator. I don't understand... Thanks!

Hi guys,I'm trying to create a point table from a Road Polyline Table. Desired result:-Point layer where the roads intersect (Cross) with Attributes. (Point Object, Road A, Road B) Can someone please help me achieve this?? Thanks in advance. Tim  

Hello, I would like to process an excel file within FME, using python caller. First of all I wold like to find a string srt= "number: " in the excel, get the position of it (like A1) and define a cell that containes the value (like A2) and save the value as an attribute number and the value. Could you give me an example python script, please?

Hi, I am currently trying to get the shortest route of a fiber network that is in the forum of an autocad file. I created the topology using the topologybuilder transformer and I sent my edges to the networktoplogycaluclator which produced a network id while I sent my nodes to an attribute filter that filters out the hub. However, when I try to calculate the shortest toute using the shortest route transformer, I send my hub to the network port while I send my network lines to the from-to port. The results do not create a path (only nopath and <rejected>). I tried multiple ways such as putting a snapper before the shortest path but that also failed. Is there anyway to generate a path to the hub?