Transformers

Hi there,I'm using the Coordinate Extractor tool to extract the elevation values at the beginning and end of a line so that I can calculate the slope of the line. To identify the starting coordinate of the line, I'm using coordinate index == 0 and to find the ending coordinate on the line, coordinate index == -1. However, I'm confused as to whether the first coordinate on the line refers to the left- or right-most coordinate on the line.   Since I'm looking at the slope of lines, it's important to know whether the elevation associated with the first coordinate references the right or left hand vertex of the line because it would indicate the direction of the slope; for example, if the first coordinate is defined as the left-most vertex of a line and is higher than the right-most vertex of the line, I would be able to say that the slope of the line moves downward left to right.For context, I'm creating a map where I'm trying to identify the slope along vario

Dear experts, I have a dwg-file wich is told to be in RT90 5 gon W. I have not been able to position it right though, but now I think I have localized the issue. It seems like the two first digits of all the coordinates are missing. Therefore, I would like to add 6200000 and 1400000 to the coordinates. How is this done? I have tried to set up a new coordinate system with the right parameters but I just cant get it to show up in the coordinate system gallery? Is there maybe a better way?Thanks.

Please look at the image for better understanding and help me to solve this problem. Thanks in advance.

Hi,I am doing an update task where I need to update dataset A with the new lines from dataset B. Dataset B includes all of the lines that are already in dataset A plus a number of new lines. I am using a spatial filter to filter out just those lines in dataset B that are not in dataset A. In the spatial filter I am using "Filter Equals Candidate" as the test. My expected result is that the new lines would fail that test and appear at the Failed port, however all lines fail.When I do a select by location in ArcGIS with the selection method set to "identical to the source layer feature" and reverse the selection I get the correct new lines.I can get the spatial filter to output the data in the correct way (based on my test in ArcMap) but only if I add a coordinate rounder to both input features with the precisions set to 3. This however changes the output data making it inaccurate.Is there anyway I can achieve what I need to do using the spatial filter without introdu

I have trail data from two different sources and am trying to figure out where they overlap, and where they don't. There is any combination of A, B or A+B. Where the trails do overlap they misalign ever so slightly. I have tried two different methods but have not yet got satisfactory results out of any of them. Most promising so far seems to be Buffer plus the LineOnAreaOverlayer. My gripe here is that it creates small gaps, see arrows, where a small piece of a segment that does not actually overlap gets registered as an offender. The red is the outline of my buffer, the greens are coupled lines and the blues are singles.  How can I keep the blue segments intact? All incoming segments have ID's, so maybe there is a way to rebuild them from that? It does feel like a slightly cluttered method that would also problems elsewhere. Some places the trail goes from A to B to A+B and back to B - and so on. Any ideas on how I could get this to work?Just as a side note: I began with a Anc

Applies to FME Workbench 2017.1If you apply a select statement on a DataReader (in this example MS SQL Non Spatial), it misreads the SQL if there are embedded comments, treating everything after the first comment as a comment, hence producing wrong result.My Sample WorkspaceHere is my workspace (a simplified version to illustrate the problem). I used a DataReader and a SQLExecutor to show the inconsistency in number of records read, resulting from incorrect parsing of SQL statement on the DataReader. Both the DataReader and SQLExecutor have the exact same select SQL. The correct number of records should be 98,792.DataReader select statement configuration:After I press OK and go back into it, looks like this:And now the SQLExecutor configuration:The SQLExecutor has the same SQL as above, yet produces the correct result. The Editor dialog automatically detects that it is SQL and gives the appropriate syntax highlighting (whereas the DataReader dialog doesn't).Conclusions:The Data

I am using a string concatenator towrite batch files for me.I am entering a windows path in the string concatenator (seebelow).%SendKeys% "E:\FME\Development Work\TimesheetAnalysis\Output\@Value(HomeTeamFP)\@Value(Name) @Value(DateFrom) to @Value(DateTo){ENTER}"But the string it writes out is %SendKeys% "E:\FME\Development Work\TimesheetAnalysis/Output\RUR370\Amy Hutsby 2018-01-01 to 2018-01-31{ENTER}"I.e. it changes to ...Analysis\Output... to...Analysis/Output... This then leads the batchfile to fail to work. It has happened several times and I dont know what iscausing it or how to fix it. Any ideas from anyone? Thanks

Hi,I was wondering, did anybody come across the invalid characters being shown for the domain values in the output while reading from an esri featureclass when the parameter is set to resolve domains.In my case, the domain description are having Arabic characters, for which my output is showing '????????'. Are there any settings or parameters in the workbench to set the character encoding settings or anyone come across such an issue and had a solution or work around.RegardsNandakumar

Hi, I'm trying to update the Z coordinate of some features by using the Surface Draper transformer. The height information comes from some GeoTIFF files, but after reading them I get the following error:Surface Model TIN is full. No room for vertices to be addedSurfaceDraper_5(SurfaceModelFactory): Fail to add a vertex to the Surface ModelI have tried using ascii files instead of the GeoTIFF, but the result is the same. I cannot figure out where the problem is, can anybody help?

Hello,  I am trying to achieve an apparently simple task: using the Tester, I want to Pass only the feature names that are in a list of names.  I have extracted the unique values from an attribute and concatenated that list into a field named "_concatenated". Both the ListConcatenator and the reader are entering the "Tester" transformer.  I then try to use the Tester by using "NAME in _concatenated" where "NAME" is the LeftValue and "_concatenated" is the RightValue.  For some reason, nothing passes. If I enter in the RightField the value of the "_concatenated" box, it works.  Not Working:Working:

Hello everyone,I have line feature which I have to buffer and dissolve. When I use the bufferer and dissolver, it takes very long time because I have a large amount of feature. If I Buffer the lines with group by fme_feature_type than the output buffer polygon is completely dissolved. I do not need to use dissolver. But it takes also much time. I tried this way with small set of features, it is faster than using Dissolver. But it shows this massage and running with a long time. Should I have to use any additional transformer to improve the work-space? I attached my workflow below.     Constructing donuts from 11750 features...PolygonDissolveFactory: Completed 100% of processing on pass 5.Completed 379339 segments of intersection processingPerforming low-level intersection at phase #1... 3.44% donePerforming low-level intersection at phase #1... 100% doneCompleted intersection processing, phase #2. 2 new nodes were generated among 11599 intermediate linesFinish splitting 11600 lines i

Good afternoon,I've been working on this process for quite awhile with no luck. The objective is to convert a CAD drawing of interior spaces. I took the original CAD exterior walls (BLUE), and created polygons. I then used a centerline replacer to create the middle line (RED). However I cannot extend the line. I've tried intersector and snapper\\anchor snapper, no luck. I've also tried line extender, intersector, snapper and again the lines will not budge. I'm at a lost. Any help would be greatly appreciated! The large gaps in the front of rooms are for doors, which I have worked around. These wall lines are my biggest problem. I'm thinking Python might be a better position.Thanks, David

sample.pngI have generated output using schema (any format) reader to read from ESRI geodatabase and supplied both database name and layer name as parameters. I used ListBuilder and ListSearcher to search for the layer in a database. FeatureReader is used to read the data and DynamicWriter to write it to postgis. I got the output with some unnecessary fields listed in the attributes image and actual workspace can be seen as a sample image. How can I get rid of this attributes automatically. I tried attributes to remove option in the Writer but it is a manual process. I tried attribute remover with no luck. Any help is appreciated.

More information for my question. We are not using SQL AG in our system, ideally we will move to this. For now, I have 75 tables in one database that has roughly 300 tables. I only want 75 table in this data copy. We are building this new database as a 'datamart' for reporting and other tools to pull data from this source, as to not effect our Production system. I am testing this today and I am finding the data takes longer than I expect to copy from one server to another. I am testing this using Workbench for now but once I have good results, I'll push the workbench to FME server to schedule this work. For my first test, I am pulling all data and I see the 2500 features are pulled at a time. I am using a static reader not a dynamic reader. For my second test, I will refine the data from the larger tables (over 1 million records) to add in a where condition to limit the number of records we pull. I am attempting to get this to build within 5 minutes. I am looking

Hey I am curious to know if fme can export to landxml with points, Lines and attributes to the objects ? I am new in the use of FME. And it could be nice to get some guidelines on how to do it.I have looked at https://knowledge.safe.com/articles/1203/creating-landxml-files.html but I think it is hard to understand what is going on in the template. Thanks

Is here a transformer or setup a Tester to test an attribute to be a number?i.e. ISNUMBER() like in SQLThx Brian

Currently my workbench creates a polygon that I convert to a Raster with a cumulative oil number as the Z Value.   Now, what I want to do with this Raster is:     From the middle of the Raster to the short side of the polygon (see attached jpg) I want to slowly decrease the pixel value from 100% to 0%.     How can I accomplish this in FME 2017?

I am a bit of a novice but I can extract a value from the block, change the type from text to numeric ( tried both types) but scaler stops processing at the Scaler transformer. If I add a value for the scale or IF I use AttributeCreator and put a value in as an attribute it will pass that hand value thru Scaler. I need to have Scaler read the value from the North Arrow block and scale the entire drawing accordingly. What am I missing?

Hi,I need to identify short segments in polygon using some tolerance for better understanding I am attaching the snapshotRegards,K.Jayakumar

I would like to add a new attribute filled in by the workspace in an feature class that is in a feature-dataset in an existing FGDB.  Can you help me ? Thank you  PS: I am still in v2012 SP4

I have a set of point objects with rotation attributes. I would like to use this rotational value to go in a straight line in that direction until it encounters something. In this case it will be a line object. Finally I would like to retrieve a attribute from this neighbouring line. The Neighbour finder will pick the nearest object, but I want to pick the first object along the points bearing/heading. Is there some way to do this?

Hi there,I'm working on a project where I need to identify the running slope of various segments of a pedestrian network. I've calculated the slope along the different route segments, but would like to know whether the segments correspond to an upward or downward slope.Specifically, I'm hoping to create four fields to track whether a route segment is above or below a specific slope value and whether that slope corresponds to an ascending or descending slope. The fields would include:  High upward slope: slope > 8.33% Low upward slope: slope >= 0% & < 8.33% High downward slope: slope < -8.33% Low downward slope: slope < 0% & > -8.33%However, I'm stuck on how to identify whether the slope of the route segments correspond to an upward or downward direction. Does anyone have any ideas how to approach this problem? I uploaded my current workspace in three consecutive segments so that all my steps are visible.The end product for this project would lo

Hello World,I'm wondering if anyone on staff has experinace (or a reader) for converting DeLorme files to ESRI.Let me know if you need any of our product info. We are currently running FME 2017. Thanks for the time.Chris Caird

I got error after appear this message :Standard2DExtract_3_GeometryPartExtractor_13_GQuery(GQueryFactory): The Geometry Part XQuery matched no parts; no action will be performed. Further warnings will be suppressedI could not convert RVZ file from Revit to GIS. I dont know what to do

Where can I download the data files for the "Getting Started Exercises"