Transformers

I am trying to set up a tester or string searcher transformer to test if the entire string is uppercase but can't get it to work. THIS SHOULD PASSbutThis Should FAIL

At the most basic level, I am looking for a way to1) execute a stored procedure2) execute a multi-step process that populates multiple database tables3) executes another stored procedureon MS SQL Server, as a single transaction. Setting "a very large transaction interval on your database writer" is not really a good answer; it is not a guarantee. See this answerTechnically, step 2 would happen only if the result returned from the stored procedure in step 1 indicated it was safe to. But one step a time; I need to figure this part out before that becomes relevant.Is there a way to have a database transaction span a workspace, or some subset of it?See this related question and my comment there.Note: Getting FME to call a stored procedure was actually pretty straightforward, even for this FME n00b; it is the environment in which it needs to happen (a single transaction) that is proving bothersome.

I am trying to merge rows based on an attribute "LeasePage" to create one row. I have looked at all the examples and none quite match what I am trying to achieve. It is probably something simple I have missed.I am using Attributecreate, AttributeExposer and Aggregate transformers to get to this stage and I have tried switching on the different choices to no avail :(

I have multiple input tables that I wish to merge together that have all the same names for Fields. I was want the merge/aggregation to be done based on the "ID" field, and I want the Value Fields to be renamed "FME_Basename"_ValueFurther to this my inputs other than ID typically have complex valueNames and they frequently change, so I would like to be able to do this semi-dynamically. "BulkAttributeRanamer" claims to support this...but it doesn't actually append anything. Attempting to manage these changes previous to merging in attributeCreator FeatureManager...do not allow for you to use an attribute value for a Field Name.Any suggestions?  I want something like this...  

Hello, I am new to FME and use Quick Translater on files downloaded from GeoFabrik. Is there a way to force Translator to make shape files for each subcategory? For instance, I am extracting the data highway. I would like Translator to make different shapes files for the subcategories primary and secondary in on single step. I tried out different options but did not find a solution. Also, with the default parameters some features are missing. I modified some parameters and now it goes better but I don't which parameter is responsible as the help is very parsimonious. Can you recommend me a set of parameters with which extraction unfolds like a charm?

Hi All, we do a lot with 3D models here with FME and one pretty common task for us is moving data from real world coordinates to a local/relative coordinate system.  It looks like FME has several ways to do this, however, none seem to be the ideal approach.  1. Use the writers built-in 'move to local coordinate system'   - Handy, however, the whole model is 'normalised' / scaled so that it fits into a 1*1 space meaning that a custom scaling must be applied in external application to have it scaled correctly2. Use models Center Point with Offsetter to move to center origin - Keeps scale and rotation, however, instead of offsetting the geometry it applies a TransformationMatrix. This is great in some cases, however, several formats (e.g., 3DS) can't handle the big original coordinates and so precision after the transformation is lost.3. Use the CommonLocalReprojector - So far I've found this to produce the best results, however, it requires that the input data

I am trying to install Python pandas v0.20.2 and I am receiving the following : C:\Users\x2fneal\Documents\FME\Plugins\python27>fme python -m easy_install pandas-0.20.2Processing pandas-0.20.2Writing C:\Users\x2fneal\Documents\FME\Plugins\python27\pandas-0.20.2\setup.cfgRunning setup.py -q bdist_egg --dist-dir C:\Users\x2fneal\Documents\FME\Plugins\python27\pandas-0.20.2\egg-dist-tmp-kzbgnpwarning: no files found matching 'README.rst'no previously-included directories found matching 'doc\build'warning: no previously-included files matching '*.so' found anywhere in distributionwarning: no previously-included files matching '*.pyd' found anywhere in distributionwarning: no previously-included files matching '*.pyc' found anywhere in distributionwarning: no previously-included files matching '*~' found anywhere in distributionwarning: no previously-included files matching '#*' found anywhere in distributionwarning: no previously-included files matching '.git*' found anywhere in distrib

HI all, i am a bit lost and was hoping someone could help pint me in the right direction.I am currently using fme 2017.1 and i have been tasked with updating some ascii to gda 2020 from gda94. I note that within the coordinate system gallery there is a parameter for Geodetic Datum of Australia 2020, Latitude-Longitude; Degrees LL-gda2020_fmeis this the conformal or conformal + distortion transformation grids? i am a bit lost with this. I have copied the GDA94_GDA2020_conformal_and_distortion.gsb into my reporject>gridata>Australia folder but i cannot see it in my coordinate system gallery.I feel that this should be a failry basic process to get this to display but i am not sure what i am doing wrong.any help is very appeictive.

I'm trying to create multiple geometry with XML.I'm using GeometryReplacer to create my geometry.My XML looks like this, but it seems that I can't create more than 1 geometry... Why??Functions aren't supported more than once??I don't want to use a Creator for each geometry... any solution?Thanks!<?xml version="1.0" encoding="US_ASCII" standalone="no" ?><geometry>    <arcBy3Points>            <startCoord x="100" y="0"/><midCoord x="80" y="40"/><endCoord x="50" y="50"/>    </arcBy3Points>     <line>            <coord x="50" y="50"/><coord x="100" y="50"/>    </line></geometry>

Hello, Thanks for the help. We have installed FME 2017.1 32-bit version (only 32 bit works with Smallworld) in a Windows 2008. But when we try to open fmeworkbench.exe an error appears:"The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the comand-line sxstrace.exe tool for more detail" Any idea about the problem? Where can i see the application event log? or how can I use the comand-line sxstrace.exe tool? Thanks so muchRegards

Hey what gives!? - No FME Wiki page?  https://en.wikipedia.org/wiki/FME_(software)   You also wont find reference to it in the list of Visual Programming Languages: https://en.wikipedia.org/wiki/Visual_programming_language   If Safe haven't made one, as it's core users, I say let's start working on one!

Hi! I find LandXML very useful for getting data out from AutoCAD Civil 3D. But I have never succeeded to WRITE a LandXML-file from FME. Does anyone know how to setup a workflow for doing that? Typically I´m creating a surface using the SurfaceModeler, and I want the Triangles or the TIN-surface to be written to the LandXML-file.  Best regards, Svante

I want to perform a Regex search in a string and I want to pass the regex pattern via a feature attribute. However, when I pass the regex pattern in the attribute and select it in the StringSearcher in the field "Contains Regular Expression", I get no match. When I enter the pattern manually in this field, the matching works.How can I pass a regex pattern via an attribute?

I am noticing in FME Desktop 2019.1 that the Connection Break Attributes parameter in the LineBuilder transformer is no longer available. I do still see it in the 2019.0 documentation. Does anyone know why it was removed or if it is still available?

Is it possible to BEGIN a transaction when an SQLExectur gets run, and keep the transaction untill all writers have successfully committed? I know it is possible to set on the reader - however I am not sure if you can set the whole workspace as a transaction

I'm using the attribute creator to create a new attribute from the value of an existing and setting the value to another attribute. 19 features go in, but only 18 come out!This is in 2019.1.0.0 (Build 19608 WIN32) - same process works fine in 2018.1

Hello FME Community, I am currently translating IFC to CityGML using one of the tutorial workbenches (https://knowledge.safe.com/articles/1025/bim-to-gis-intermediate-ifc-lod-300-to-lod-4-cityg.html). This is working mostly fine.I want to import the model in 3D CityDB using the Importer/Exporter tool. It needs to be georeferenced, so I can later export it to KML and COLLADA. My question is: How can i add the correct coordinates and coordinate system (UTM32) to the resulting CityGML model) Thanks in advance and best regardsTobias

I am dealing with Assessment Fabric parcel Data and I am trying to write it as Microsoft SQL Server Non Spatial File Format. I want to add the Logitech and latitude information for the parcel as well in the file i am writing to but for some reason neither the new string field i have created nor the coordinate information. I am not sure where i am going wrong. Any help will be much appreciated. 

I created a Custom Transformer and submitted to hub.safe.com - to try the functionality. It is really easy to upload custom transformer and I recommend you to do it. However I wonder what happens when someone gives a comment on a transformer. Do you get notified by e-mail? Can someone test it and add a comment to : https://hub.safe.com/publishers/sigtill/transformers/looper - so I can check if I get an e-mail ? Thanks.

Hi community,I have some problems using the XMLAppender, to define the correct append path in the main xml document.The main xml document looks something like this:<DATA>  <NAME>Features</NAME>    <CHILDREN>     <Type>      <NAME>Boulder</NAME>      <CHILDREN>        <Type>          <NAME>Bouldertype1</NAME> </Type>  <Type>          <NAME>Bouldertype2</NAME>  </Type>      </CHILDREN>    </Type>     <Type>      <NAME>Debris</NAME>      <CHILDREN>        <Type>          <NAME>Debris1</NAME>  </Type>  <Type>          <NAME>Debris2</NAME>  </Type>      </CHILDREN>    </Type>    </CHILDREN></DATA> The xml_fragments have an attribute that define if they are to be appended to Boulder/Bouldertype1 or Debris/Debris1 etc.. and the xml_fragment's looks something like:<Type> <NAME>Boul

Picture a very curvy stream polygon. I would like to quickly calculate the shortest width and the longest width. Bounding boxes would not be applicable.Thanks,Pete

Hi community,We are trying to retrieve the output of a FME Server hosted 'child' workspace using HTTPCaller (GET) transformer on the main 'parent' workspace.This seems to work perfectly when running the 'parent' workspace on local machine with HTTPCaller getting the output of the 'child' workspace which is hosted on FME Server.The problem:When we upload this 'parent' workspace to FME Server, the HTTPCaller seems to fail. Log as below: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Timeout was reached'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set up HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered  Is there anything we need to change so that the HTTPCaller works when published on Server too? We are using FME Cloud, so proxies should not be a problem and currently have 2 engines

Hi there,I've seen some similar questions already asked about this, but none of them were quite the same as what I'm trying to do. That or I simply misunderstood.Essentially, my data looks like this:WeekCountLength150350027040003653800 And what I need to get to is something like this: Week_1Week_2Week_3(Count)507065(Length)350040003800 Now if it where only these 3 cases above, I could quite easily take a more manual, individual approach, but in my actual data there are a lot of "weeks" so I need to have it pretty dynamic.Any suggestions? Best regards,

Hi, As a non-expert in remote sensing, I would like to calculate the NDVI index from a CIR aerial photograph.I came across this promising custom transformer on the hub ( NDVICalculator - @dmitribagh ) , but I always get this error message:_RasterExpressionEvaluator_4 (RasterEvaluationFactory): Input 'B' is referenced in the expression list, but no 'B' feature was providedI (think I) have an infrared and red band entering the transformer, and I also get a preview of the output of the transformer, but I can't write the result as the translation stops with the fatal error above ... What could I do wrong (as a FME newbie...)? My workbench with a sample of the aerial photograph attached Any help much appreciated!  

Guys!I was under the impression multiple string functions can be performed on an attribute within the one attribute manager, is this not the case? For example, Pad Left string function followed by the Left string function. Anyone know how to write it? I'm trying to cut down on transformers. My particular scenario below in case there's another way around this.Sample data format: (regex: \\d?\\d\\.\\d{2}\\\\ )Pad Left to add any missing leading zeros such as the bottom line.Left to then strip the bracket off the end.Results in bottom line changing to 03.98, the rest simply lose the bracket.