Transformers

Want to Trace downstream of Electrical Network

Hi I have about 100 feature classes in SDE to migrate to new DB. Following initial load, I would like to only process change only updates on a hourly basis. Some tables have over 4 million recordsHas anyone have experience of using ChangeDetector/ UpdateDetector in FME. How is the performance like. Any best practice suggestion regarding reading/writing 100 feature classes?The new DB is on different SDE/SQL Server version, hence I would prefer to use FME rather than SQL replication for this.   

Hello, I have a File Geodatabase Feature Class that has a field with people's names in the format "First Last". I have another spreadsheet with the people's Last names in one field, and their Active Directory usernames in another field. I need to get the names matched up with their Active Directory usernames as well as possible. What would be the best transformer to use to join these to tables using something similar to a "Like" or "Contains" query to get an output feature class with the usernames?The FeatureMerger doesn't allow you to use LIKE queries as far as I can tell.For example, say the Feature Class "Fred Johnson" in the name field, and the other table just has Johnson, I would need a Transformer and Query that joins those two and outputs a new feature class with the username. 

I would like to extract coordinates in a different column using FME SchemaMapper. I would like to use AttributeReprojector as filter value column in FME SchemaMapper

Hey there, I'm trying to convert Microstation DGN files into DWG to use them in Revit. Unfortunately the coordinates change a lot while doing so (see attached) and I can't make out why? Anyone got any idea why that is?  I tried auto selected coordinate system as well as manually selected. DGNDWG

An old version of the Dissolver (Version 3) has a parameter called overlapping input which can be set to Overlap or No OverlapCan anyone recall what the difference is?

Hello,I am trying to use Python caller to check if a folder exist. Here is the code:But it doesnt geve back outcome to attribute "van". Where is my mistake?import fmeimport fmeobjectsimport osdef processFeature(feature):    van = os.path.isdir(feature.getAttribute('_LAS_eleresiutvonal'))    print van    feature.setAttribute('_van', van)class FeatureProcessor(object):    def __init__(self):        pass    def input(self,feature):           self.pyoutput(feature)    def close(self):        pass

Hello, have anybody any idea why the LengthCalculator is giving wrong length in meter?I set the reprojector and lengthCalculator as usual.Thanks

Is there a way to set default annotation styling? I find that the text size is too small and I like to use different colour backgrounds but have to set it on every annotation I drop on the canvas. I can't find any settings to set defaults. ThanksSeb

Hello, I would like to split the line with the intersected Points. Seems easy, but it does not work for me...I have a lot of line which I merged together with a "NetworkTopologyCalculator" it looks that it works. After with aggregator I get 1 Line (what I wanted to). Then setted PointOnLineOverlayer. There I have the points, which intersected the Line. But the result from Overlayer is not as I needed. does anybdy have any idea, whay it been splitted on "wrong" place, and not there where the are the points?I get a sum of 840 lines, what is completely wrong.  Thanks a lot

Hello,Some time ago I had troubles with an unwanted outcome of my AttributeManager, see here:https://knowledge.safe.com/questions/107194/what-is-causing-a-difference-in-attribute-handling.html Now I have a similar issue. I have a table with 224 records, but for 3 records the outcome of the AttributeManger is not what I want and what I would expect.It goes wrong for these three records:This table goes into an AttributeManager where I multiply the values in the 'top' column with 1000.I use this statement: @int(@Value(top)*1000) The outcome is as follows:Does anyone know why it does not result in these values:LocDepth_IDtopB49F0423-8.118110B50D0035-2.012010B50D0036-4.024020 And why it goes wrong for only 3 out of 224 records? Thanks in advance!Eva

Hello all,I am a relatively new FME user. I am looking for advice on the most efficient way to assign attribute values based on CAD layer name. Specifically I am working with several sewer main layers that all begin with the diameter of the mains contained within. The way I have built out my work space does achieve what I am looking to do, however as you can see by then screenshot, it is horribly inefficient. I am wondering if anyone has any advice on how to consolidate the process I built out in that ridiculous branching process? Any advice would be much appreciated.Note: I understand this can likely be achieved in python very easily. I am not expert with such methods so if there is a way to achieve what I am looking to do using strictly transformers, that would be preferable to python solutions. That said, python solutions are also appreciated.Thanks,Nate

Hello dear FME comunity, My company is making databases to government facilities. We are gathering data from the field and digitizing it in AutoCAD. the water and sewage line attributes are in the middle of the line in an attribute block and the accessories are in attribute blocks. My wish is to get an FME module that I can work with that will give me the option to take the dwg data and transfer it to a shape file. the module needs to be flexible enough that if I wish to change the names of the attributes or their types on either side of the module it will be possible. The module should also have the option to check geometry and data validation, and to make a report showing where the problem is.

Hello,I have a trouble with zipfiles.I made a script that take multiple files and put them into a PostgreSQL database (in a binary column).My script works really great : I'm using a datafile reader to get files and the PostgreSQL writter put them into my DB without any problems.Where it doesn't work : when I try to import zip files, FME try to unzip them.  I don't want them to be unzipped, I want them to be imported as zip files directly into the DB. Have you any solution ? Thank you for your answer.Best regards.Arthur Bazin

I'm trying to create a server app that allows users to select one (or more) values from a list in order to filter / select data for download as a CSV.My workspace is a slightly more complex version ofReader (Web Feature Service) ------> Tester (based on Published Parameter) --------> Writer (CSV)And is designed to be run as a Server App where users can define the value(s) from a list to filter the data for download.The Published Parameter is configured as "Choice (Multiple)"I would expect the Tester to be able to work with the list provided from the User Parameter. However, Tester (using the "In" operator) requires values to be comma separated whereas "Choice (Multiple)" provides a whitespace separated list.So I can't think of a way to offer users multiple choice values for downloading filtered data.I've found some fairly old topics covering this, but I don't think the provided solutions will work adequately for a Server App

I think this can be done using FME, but I'm not sure where to start... I'm looking for a way to decode IOT dataframes. I attached the documentation, not sure what to do more because I really don't know where to start. Can anyone give me a pointer?

Hi, I'm currently working on a project in which I need to change the table format from long to width. The data is coming from a csv file and consists of information on purchases. Each purchase has it's own line, so there are almost 1.7 million single rows in the dataset. Currently each row has got the name of the product bought and the company who bought it. I would like to have a single row for each company, containing the number of items they bought from each category. My current table looks like this; In which; Deb.nr. Is a unique ID for each buying companyTotaalGroep , is the total number of items in the group, bought by all companiesGroup is the group the item belongs toGroep.total_count is the number of items within the group an individual company has bought%vanGroepperDebNr. is the percentage of sold items a company has bought. The other columns are seemingly irrelevant for now.  I would like for the data to look like this; In which the % Total group is the percentage of

Is it possible, and if it is, how could i transform my .FME to .FMW file??

I'm trying to create a ellipse2D or circle shape from four points. i have 4 coordinates (North, South East, West) i want to join up the points with a round shape. I have tried 2D ellipseReplacer, and used East+West for the Primary Axis & North + South for the secondary Axis. its seems to almost work but the scale an shape is slightly differentI have managed to create a Square using BoundingBox Accumulator - But need to fill that box with a round shape, touching all edgesusing 2019.2 DesktopThe image attached shows the 2D ellipse shape overlayed on the 4 points/box. As you can see it's not right. Even when I scale it down it's still incorrect Grateful for any assistance

FME Desktop 2018.1.01. on Windows Server 2012.I started a translation at 1523 yesterday which simply reads point data from SQL Server Spatial and writes it to an ArcSDE layer. At 1821 STATRP lines started appearing in the log. And at the end I got 2 lines saying "Translation was SUCCESSFUL with 1 warning(s)..." instead of the usual 1 line.Statistics are ticked in the translation options but I've never noticed this situation before. What is STATRP, and how is it different from STATS?2019-06-17 18:21:30|9989.8| 2.5|INFORM|Transaction #3779 was successfully committed 2019-06-17 18:21:34|9993.1| 3.3|INFORM|Reading source feature # 3780000 2019-06-17 18:21:34|9993.1| 0.0|INFORM|Transaction #3780 was successfully committed 2019-06-17 18:21:36|9995.6| 2.5|INFORM|Transaction #3781 was successfully committed 2019-06-17 18:21:39|9998.1| 2.5|INFORM|Transaction #3782 was successfully committed 2019-06-17 18:21:40|9999.4| 1.3|INFORM|Reading source feature # 3782500 2019-06-17

So I'm trying to intersect this centerline data with parcel data to return the length of the parcel line from the centerline to the edge of the property. In areas where none of the parcels intersect each other there is no issue however when parcels do intersect my length measures get split due to the self intersection that is going on. I've attached some sample data as a go by. So I'm basically trying to figure out how to intersect the polygons turned into lines (desired output) via chopper based only on where the centerline cuts through the parcel line(s).  

Hi guys,I noticed that question severl times, but never find out any final solution, taht will work for me.I have a database, with a lot of attributes in domain field. Is there any option to export those coded values with fme?Thanks in advance. Miha 

Hi, I've been attempting to extract a volume calculation from two LAS files and have tried a few methods advised in this forum but I'm having limited success with final reported volumes being incorrect.I have an existing level LAS file with a secondary as-built LAS file which I need to create a volume calculation and also generate a glb model solid. Method as follows:1. Read 'existing' LAS and use TINGenerator to create surface to extract volume calc.2. Read 'as-built' LAS and use TINGenerator to create surface to extract volume calc.3. Compare difference of volume calcs.This method works OK for comparing surface area difference but not the volumes. My design software shows that the TINVolumeCalculator creates wildly different values which I assume is operator error.However my preferred method using design tools would typically follow this pattern...1. create surface DTM from existing LAS file.2. create surface DTM from as-built LAS file.3. extrude as-built surf

i would like to ask : is it possible , to extract the map after using clipper and add to the sheet file . the output that i get n inspector ,i would like to let workspace to save the map automatic new sheet file in my feature writer .Thanks for help

I need to update some measurements of line strings. How do I calculate the length of a line string with points stored in Oracle Spatial SDO_GEOMETRY?