Transformers

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

I have authored a workspace that creates bills for a lot of customers. The item price on the bill has to be returned with 2 decimals, so I take the mean of all the item prices and ceil the number to 2 decimals. Because of an occasional outlier I can't rely on normal rounding function.In the case below I have 1.173 measurements with an item price of 0,43. The min and max is 0,43 and the range is 0. But the mean value is != 0,43. And since I have to use the ceil function the price changes to 0,44. I understand this must be caused by the internal handling of 32 to 64 bit conversion, but in this case a seemingly very simple operations doesn't work. Why can't I rely on the mean calculation?What can I do to rely on it in the future? 

Hi, I'm running a simple workbench that converts a single dwg to GeoJSON. when I start the process normally in FME it works fine. But when I make a bat+tcl I see that the path to the dwg file changes and there is a "\\" missing between the folder (Linjedata) and the dwg file (T_E6SL_P00_f_C_E6-Profillinje.dwg) (AutoCAD Reader: Error opening file 'C:LinjedataT_E6SL_P00_f_C_E6-Profillinje.dwg' during version check) Is this something I can change in the tcl file? However, I got around this by putting the dwg file on C:, but then I only get a new folder with the same name as the dwg file with an empty file called "C" inside as the result, instead of a GeoJSON file. What I'm trying to achieve is just the same as when I start the workbench in FME, but run as a bat file.

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

I would like to output an excel template with one of the columns having cells containing values from a pick list.  From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.  However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

I have a CAD layer of control points which have two labels around it. I'm trying to extract the neighboring labels and add them as attributes in the final geodatabase. I have tried using NeighborFinder but it captures the nearest label only. I have tried to use a Tester to differentiate between the two labels and then run NeighborFinder but it leads to multiple records. The red circled is the control point and orange circled are the labels.  How can I capture the attributes and have 5 points in the output rather than duplicating them? 

Hello every one,I have a cad file with lines and block on to on them.The block have some attributes, and one of the is Length.for some reason, there are a lot of blocks that instead of having the length properly, it have #### marks.I tried to fixit of course with FME, I managed to recover the length from the line which the block is belonging to, but- when i'm writing it to dwg, it is get mess again!I tried to use Attribute Output in the writer definition, 'Inserts' or 'Limited' got the right length number, but they destroy a lot of other definitions in the cad file.can someone please help me?I'm attaching here small sample..Thanks!

Hi, I am trying to asses assets that are in CAD and not in GIS. Using the Spatial filter or the SpatialRelator i am getting results of one to many. I.e. the results are relating one candidate to many filters. What transformer can i use that only spatial joins one candidate to only one filter? Please help!

I am trying to select a polygon located in between other polygons. All polygons are saved in the same layer. Either NeighborFinder or AreaOnAreaOverlayer do not provide the result I am after.

Hi, I'm encountering issues to connect to an sFTP server through a proxy.With my ftp client I'm able to connect with the following configuration.But I don't know how to configure my FME Desktop environnment and FTPCaller transformer to access to it.Here is how I tested it.Configure proxy settings on Windows Configure FME Desktop environnementConfigure FTP CallerI have the following error See log file attached.I alswo tried with pythonCaller but I didn't yet figure it out. Any tips to solve my case ?Thank you,

Please appreciate if you could let me know in details  

I have a set of features, all with IFMELine geometry, where some are closed and others are not. The closed ones vary between 2D and 3D closure. I can inspect these features and see the Closed propery right there in the Feature Information:(The straight line to the lower left of highlighted box has Closed = No, as one would expect.) So, for every line in the set, Closed is visible in the Feature Information window and has a value of Closed In 2D, Closed In 3D, or No; however, when I then run this set of features through a GeometryPropertyExtractor, all features are Rejected with the MISSING_GEOMETRY_PROPERTY error. The setup for this transformer in my workspace looks as follows:The transformer was working yesterday. Today, it isn't, and I swear I haven't changed anything. (OK, yes, apparently I did, but I can't for the life of me think what.) Am I missing something simple here? (Feels like a "facepalm" situation, for sure.) Thanks, All.

 Please refer snapshot, creating texture Atlas using CITYGML data FME 2022.1.2 version

So I have data from several 100s of pumping stations. In a specific point in time there is a radical decline in what the sum of all pumping stations is delivering (it declines). I need an analysis that can verify if the decline comes from one, or several, of the pumps or if it is due to a "general" decline on all or most of the pumps? Could this be solved in FME? I have 20+ years of data so there should be sufficient amounts for statistical analysis. However, it is more important to be able to dispaly the results (in for instance in a graph) visually than for instance R technical value. Even if both could be of interest. Would appriciate all the input and since I am doing all the data prep in FME it would be great if this issue also could be solved in FME :) Regards

I have two input table I set to LL-WGS84. I need to determine the length of the lines after the SpatialFilter in meters. I re-projected to XY-M then used LengthCalculator but the resulting values are not in meters. How do I reveal the line length in meters? 

Dear all,  I am facing the following issue - sounds very simple : I have a 2-column table that gives a mapping oldname->newname that I store in a dictionnary inside a PythonCaller ; in another PythonCaller, I need to use this dictionary.So far, I am doing the following : 1) in Python Start-up script, I define a global variableglobal mydictmydict = {}2) in the 1st PythonCaller : I populate a dictionary in the `input`function and then in the `close`function , I update the value of the global`all_progs` class FeatureProcessor(object):    def __init__(self):        tmpdict={}        pass    def input(self,feature):        # do something like :        tmpdict['oldname'] = 'newname'     def close(self):        mydict = tmpdict        pass3) in the 2nd PythonCaller I would like to use this dictionary ; but when I try iterating over the dict `mydict` in the 2nd PythonCaller, it looks empty... What am I doing wrong ? How could I pass the values from a PythonCaller to another ?  Should I put 

In Attribute Manager I have created 3 fields (Borough Code, Block_Leading, Lot_Leading), 2 of which have leading zeros in them. I need to concatenate the three fields into a 10 digit string while retaining the leading zeros in the order listed above. My formula for for Block_Leading is @PadLeft(@Value(Block),5,0) and the formula for Lot_Leading is @PadLeft(@Value(Lot),4,0). Can I concatenate all three fields in a single formula in a new field in Attribute Manager and if so how? 

I'm having some trouble when trying to upload Python libraries to FME Cloud and I couldn't find any documentation over it. I have tested that the workspace successfully imports the PyPDF2 python library on my desktop (windows 10). I then followed the directions on the post that is linked below and I am still unable to have the workspace on FME cloud import PyPDF2. I'm still fairly new to Python and haven't had any experience with Linux, so I'm not sure what I might be doing wrong.My stepsCreated a virtual machine with ubuntu (32 bit. No option for 64)Downloaded the source code for PyPDF2 from: https://github.com/mstamy2/PyPDF2Compiled the library on the virtual machine and copied the folder created in the dest-packages folder to FME Cloud folder located at Resources>Engine>Plugins>Python>Python27. (no files in site-packages)Reference to Post: https://knowledge.safe.com/questions/4164/python-libraries-on-fme-cloud.html?childToView=69192#comment-69192Any h

Hi, we have some problems during clipping raster datasets!So the black area in the example is successfully clipped. But then as result we have raster clipped by clipper. But FME makes the raster square again and fills the missing pixels black. I can remove these nodata values but then sometime black pixels inside the raster are also deleted not only the black areas on the edge! We want to get only the clipped area without black areas. It does not have to be square.Is this possible?

I currently have a dataset, see top half of picture below, that I wish to transform/transpose into the format that can be seen in the bottom half of the image. The blue/green/peach coloured fields are date/measurement.   I am totally unsure of where to begin with this, the current transposer tools seem to only be able to do simple transposing without adding the additional rows of location/sourcetype/date/measurement I need. As can be seen I want to make a individual row for each date/measurement combination.  I have also attached sample data in xlsx and csv. Any help would be appreciated!