Transformers

It is a large data set. If there are no values, I want to send the data to a writer, if there are any values, I want to go to the terminator. My issue is that the data set is large and using a tester or attributeValidator isn't work because values are getting to my writer before validation is complete.

I have my SDE destination schema in a file. But I don't see any parameter for Attribute Name Column Alias. So I'm guessing there's no easy way to assign Attribute name aliases. If I'm wrong, would love to learn how to do this.

Hi Folks, I have successfully done a Cross Join In one InlineQuerier where the contents of a field called Query_Filter - is the WHERE Statement I want to apply in another InlineQuerier. I can get the statement to work fine when I paste it in to the second querier - EG Select * FROM "Detected" WHERE (ChemCode ='7440-38-2' AND Concentration > 160 )However when I Write SELECT * FROM "Detected" WHERE Query_Filter It doesnt work. (Query_Filter just containing the text string above.)Im missing something. Any thoughts ?

Hi folks !I want to read HTTP tables for a bunch of url stored on an attribute of my features. However, a basic authentification is needed to access the page.If I set the attribute containing the URL in the source dataset of the feature reader, I cant set any authentification parameters.Everything is working fine if I manually enter one url, then go to the parameters. (as if I use a Reader)Any clue on how to use this authentification in the FeatureReader ?

Hello,I'm using TopologyBuilder to topology of my network.My data is clear and I want to build topology using start/end points (Nodes). It's working fine for me, but I have a problem with 2 cases (similar case) (from 3000 lines).the tool is creating complexe intersections. So, splitting lines, creating additional lines and additional nodes !!the problem is when two line are almost parallel for a while, please see below an examplebut I don't want that, I want to keep the original lines and create just two nodes for each. this result distorts my network.do you have any idea about this strange behavior ? do you have any solution ?Thank you :)Youssef

I'm seeing something weird on my non-Windows FME's in build 17539: the peak process memory usage that's reported at the end of a logfile is 0... This is on my Mac:And this is on FME Cloud (Linux)A Windows machine with the same FME build does show it correctly.Anybody else notice this?

Hello,  I have one main workbench which in turn executes other three workbenches. I used shutdown Pythin script to execute the other workbenches from main workbench.  I am new to FME server and I need to publish this to FME server so that it can accessed in Java Application. I have few questions on this 1. As which type of service I would be able to publish e.g. Data Download Service, Job Submitter etc. 2. Do I need to publish all four workbenches (main plus three workbenches)  to FME server? 3. What is the best way to publish this as a service. 4. Are there anything I have missed and should consider before publishing as a service.  Thanks.

Here at Safe, we are always trying to improve FME as well as our Knowledge Center articles. It recently came to our attention that we don’t know much about how our users integrate R and FME using the RCaller transformer and the great things they are accomplishing with it!Our questions to you: How do you use the RCaller transformer?Are there any RCaller related articles you would like to see?

Hi Guys,an easy one for you i think.... i have one point X and bout 1500 points Y1,Y2.... how can i produce lines from X to Y1 X to Y2 X to Y3 and so onThxGreets and CheersFranco

I have an attribute [complete] withe the value 1-A. I would like to split that value to attribute [split1] with the value 1 and attribute [split2] with the value AI've tried AttributeSplitter;AttributeTrimmer;AttributeCreator

Has anyone else experienced performance issues with the Point On Line or Point On Area Overlayer? In 2016 I have a workbench that does some overlays of about 700,000 lines with 2500 points and it runs within about 30 min (most is reading in features for other parts of the process). But when I try to run it in either 2017.0 or 2017.1 I get to a point where it says, "Creating spatial index" and it's been at it for hours. I tried upgrading the transformers to the latest version, with no change.Just wondering if anyone has any ideas or has had a similar experience.

I wasn't able to find any schema documentation for the FME Server repository, is there any public details I might have missed? Essentially just trying to query source and targets for each workspace. Was able to query this information for readers and writers but we often use "SQL Creators" and/or "Joiners" to pull in tabular information. Is there a way to access those from the repository database? To list out the connection name would be great or even grab the SQL?Here is what we have so far:SELECT   fme_item.name AS "Workspace",   fme_item.title AS "Workspace Title",   fme_item.username AS "Username",   fme_item.lastpublishdate AS "Publish Date",   fme_dataset.location AS "Data Location",   fme_dataset.format AS "Data Format",   fme_feature_type.name AS "Table/Feature Name",   fme_repositoryinfo.name AS "Repository",   fme_dataset.is_source AS "Is Source"FROM   public.

FME Data Inspector disappeared from machine this morning. Upon investigation, it look like Trend Micro AV has picked it up as a virus. Anyone else had this problem?

What are all the files that specify the FME Server hostname, that can't be accessed from the FME Server Web UI or backend database?

I need to pack all the attributes of DGN file by using AttributejSonPacker but unable to expose the attribute "_packer" how can i unpacked the same?

Ahoy, Matey!Would the "Scuttler" be a good name for a transformer created by an FME "Savvy" on the Talk Like a Pirate day?http://metro.co.uk/2017/09/19/international-talk-like-a-pirate-day-pirate-phrases-to-say-to-ye-crew-mates-6937117/

Dear All,I have multistory building plans and each floor located the same place.I need to move each floors side by side.for example, 15 floors need to move side to side as like 5 (Column) X 3 (Row)Please advice to achieve this taskThanks in advance.Venu

Hi,I am trying to calculate the width from a polygon at point feature locations (see figure). I was thinking about creating perperdicular linen at the point feature locations (perpendicular to polygon). Clipping the perpendicular lines (using the polygon as clipper) and calculating the length of the perpendicular lines. Is there an easier way to do this?Kind regardsMichael

Hi all,I have a polygon layer representing the sealed area of our road network with numerous attributes about the road. I also have a road centreline layer which has no attribute information. I want to get the road polygon attributes applied the appropriate centreline. The obvious transformer is the LineOnAreaOverlayer, however, this creates a lot of 'stub' centrelines that get associated with an intersecting road (please see image for an example). In the example, a small section of Road 2 is given the attributes of Road 1.So far the methodology that I have come up with is to:1. assign a unique identifier to each centreline2. process through the LineOnAreaOverlayer3. determine the lengths of each segment 4. combine segments based on unique identifier 5. use the attributes of segment with the greatest length fo

Is it possible to use the MSWordGenerator transformer to out .docx via FME Cloud?

Hi all.I Need some help. I have two ESRI shapes, the yellow one and a pink one.Both have a column named ID with the values shown below. The red label is for the pink areas and the black label belongs to the yellow areas.The yellow areas can completly be overlapped by each other. (area 800 is under area 700)I want all to be "clipped" and joined between the pink and the yellow based on the ID column. I need the result as shown in the second image, the blue hatched resulting areas in a shape file.Any ideas?

I am running into something while trying to read a DWG file and handle the data based on layers. I set up the reader with 'Group Entities By Layer Name' and most layers are being sent to my writer as Feature Types, with one exception: There is one Feature Type that seems to contain data from several layers, as in this example:The Feature Type is A208, while the autocad_layer is A234. Both A208 and A234 are available as Feature Types from the reader, but the A234 reader contains no data. The data on layer A234 (and other layers) can be exported from A208. I found a workaround on this by exposing autocad_layer in A208 and take it from there, but in a different setting I may have missed it. Is there something special with these layers that make them come "grouped" up like this, and how can I determine if my DWG files have things like thi

I keep getting an error trying to write to a specific table, getting an ESRI gdb error message (http://support.esri.com/en/technical-article/000004275).It claims that the table name has a leading underscore.I placed a StringReplacer (Image 1)I keep getting the same error listed in the ESRI blog above????Geodatabase Error (-2147467259): General function failure.Could not open File Geodatabase table `Delta_Block_Polygon'A fatal error has occurred. Check the logfile above for detailsAny suggestions appreciated