Transformers

A workspace that stars with a SQL-creator works flawlessly when executed from workbench or server-app. It executes in a matter of seconds. Especially the server-app is highly efficient.We are now testing to have it run via webhook in a stored procedure in the SQL-database.Below is the log with timestamps. Row 91 seems to halt the execution for ~100 seconds. Can I optimize the transformer/call or is it more likely to arise in a conflict between committing and selecting in the SQL database. 902020-5-26 13:31:08 | Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...912020-5-26 13:31:08 | MSSQL_ADO reader: Building features into bulk mode features922020-5-26 13:32:47 | Microsoft SQL Server Non-Spatial Reader: Database read complete. Retrieved 6 feature(s)932020-5-26 13:32:47 | Logger: ------------ LOGGER --------------------

Good Morning,I am rather new to FME (RATHER). I have schemas and data coming for the next months, almost every day, in excel. EVERY TIME SCHEMAS WILL BE DIFFERENT (INCLUDING THE NUMBER OF FIELDS). My goal is to open a CSV file, explode the attributes (I think is the way to call it) and go from there validating each one. I need to test the length, not nulls, ASCII content (0-9, A-Z, a-z).For many I know is a walk in the park. For my is going ascending to the everest.Thanks a lot i advance.

We have noticed that when we do negative buffering on various polygons the results are sometimes missing parts (red: original, yellow: buffer):In the above example we expect a slightly smaller yellow polygon inside the the area marked with black.The workbench (attached, including input data) used to create the above example looks like this (the validator is set to all):We are still using FME 2016 in production due to various reasons and the above is indeed made using FME 2016. In the above example the bufferer rejects the input geometry (INVALID_GEOMETRY_TYPE), though the yellow part is still the result from the rejected port and apparently looks fine except from the missing area.We have tried the same workbench in FME 2018 and though it doesn't reject the geometry the same part is still missing:

I have a SQL stored procedure to get asset details with input of two List Values (Exec get asset details 'L1,L2'.where L1 and L2 contains concatenated values like L1=100,101,... and L2 = 1001,1002...) When I use SQL creator I am getting the correct results as similar to MS SQL Server Management studio.(But I used hard coded List Values ) and outputs asset details along with L1,L2 values but I am not able to pass the List values in the same workspace for SQL creator as list values derived from the another system using Http Caller.However these same List values used in SQL Executor in the same workspace runs outputs asset details along with only L1 values but not with L2 values. Please suggest me.

I would like to extract text between *** CProtOC*** as a separate attribute from text file * E * *** CProtOC *** FCLID [5318] - FCL [Fuse] - FOID [2634] - KEY_ID node NOT FOUND text_line  

I am an SVG file from FME 2015.1. I have some minor issues.  The <!ATTLIST array causes chome and other programs I have that read SVG to have fits. I have to manually delete that. Any way around this?  Also it would be nice to be alble to set the stroke color and width from FME. Any suggestions:  See below:    <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11-flat.dtd" [ <!ATTLIST g xmlns:fme CDATA #FIXED "http://www.safe.com/fme" > <!ATTLIST path fme:access CDATA #IMPLIED fme:visible CDATA #IMPLIED fme:type CDATA #IMPLIED fme:nd{}.ref CDATA #IMPLIED fme:tag{}.v CDATA #IMPLIED fme:timestamp CDATA #IMPLIED fme:user CDATA #IMPLIED fme:id CDATA #IMPLIED fme:version CDATA #IMPLIED fme:tag{}.k CDATA #IMPLIED fme:created_by CDATA #IMPLIED fme:lane_boundary_type CDATA #IMPLIED fme:changeset CDATA #IMPLIED fme:area CDATA #IMPLIED fme:layer CDATA #IMPLIED fme:uid CDATA #IMPLIED

I have a transformer that aggregates areas and writes to FGDB polygons. GeometryFilter or GeometryCoercer show that they are areas in FME. The result in FME show as closed polygons. When I view the results in ArcPro (or Catalog) some of the polygons are unfilled? I'm not sure what the issue is or how to fix it?

@takashiHi!I would like to split the value of an attribute with respect to its number of characters. For example in element 1 from screen shot :1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769I want to have something like:1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769with a limited characters per line = 69 and each new line must start with a * Thanks in advance for your help !

@takashiHi!I would like to split the value of an attribute with respect to its number of characters. For example in element 1 from screen shot :1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769I want to have something like:1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769with a limited characters per line = 69 and each new line must start with a * Thanks in advance for your help !

Hi, I think i have a simple question. I have a csv where the xy is in one attribute. See example (geo_xy) but i have to do an poinonarea but because i have no x and y seperate he doesn't do it. FME doesn't recognise the geometry. I have already tried to extract the x and y by using multiple tranformers. Even used stringextractors but the number of numbers of x and y is various so it's not flawless. I am sure there is an easy way to do it but I cannot find it.Can somebody help me? ThxNathalie 

Hello,I am using SystemCaller to delete temporary files during translation. Now I store them in a created folder "Temp" that I'd like the SystemCaller to delete with all its contents.The typed text in SystemCaller is:Del $(Output)\\Tempwhere the $(Output) is a public parameter.At the end of the translation it prompts to delete the full directory with*, Are you sure (Y/N)?Is there a way to type the Yes choice in the SystemCaller? Otherwise translation will get stucked here.For single files the Del command works fine in SystemCaller.Thanks.  

Hi,I wounder if it's possible to set custom name of sketchup groups in the Outliner, using i.e. GeometryPropertySetter and "Traits from attribute"? Basically the same as setting the sketchup_layer_name as trait. I have mananged to group objects using aggregator.I tried to solve it by the suggested solution on this tread: https://knowledge.safe.com/questions/2300/writing-multipatch-features-to-sketchup-groups.htmlbut couldn't get it to work. Any suggestions are appreciated. Thanks! 

I have tried to use the polygon path segmenter to get the number of line segments in a set of polygons. I can see that it is creating a segment attribute when I go into the attribute properties on the inspector however I can't seem to get these attributes to come through into my routine. I have tried exposing them in different ways but to no avail. Is anyone able to help please? I'm sure it must be something simple I am missing!Thanks

In a directory I have some textfiles and their names contain a date (xy... 2017-12-13.txt). Each month there's a new file. I want to read only the newest file, but I don't want to change the name in the reader each month. So my idea is to read them all (or at least one record to get the fme_basename), compare the dates and then read only the newest file.So I tried various approaches (first extracting the date out of the filename, then use Aggregator, Sorter, VariableSetter...) but I don't manage to compare the dates of the features as I can't see a way to set the initial value...Any ideas?

Hello All,  I am trying to loop through a feature class with 30+ fields, each field having terrible quality data filled with duplicate white space. I am trying to find a way to loop through the feature class, checking each field and then replacing the duplicate white space with single white space. I can do this manually, one at a time, with 30+ StringSearchers->StringReplacers. However, I am wondering if anyone has found a way to build a custom function to loop through each field and replace values? I would prefer to call a custom transformer and loop through all fields than build 30+ groups of two transformers. Currently in the string replacer I only see the option to do one string at a time.  

Hello all,I have a series of point features that I need to convert to line features, but running perpendicular within a layer that contains parallel polyline features.I want to convert the green dots in the first image below, into the green lines in the second image. There is no data relationship between the existing point and polyline features apart from their spatial proximity.Can anybody recommend a sensible way of doing this?Thanks and stay safe (and sane),Robin

Hi I'm trying to convert our DTM tiffs to a more weboptimized format.I'm thinking of jpg, png, ecw, jpeg2000. When I try to convert them to gray8 I loose the numbers behind the comma, because the rasterinterpretationcoercer converts from float to integer.That's just not an option. I also tried this: The numericrasterizer gives an error:NumericRasterizer (VectorToRasterFactory): No values were specified for either both WIDTH and HEIGHT or both X_CELL_SIZE and Y_CELL_SIZE. When any of WIDTH, HEIGHT, X_CELL_SIZE, Y_CELL_SIZE, INTERPRETATION_TYPE, BACKGROUND_COLOR, BACKGROUND_ALPHA, BACKGROUND_VALUE, or GROUND_EXTENTS is specified, values for either both WIDTH and HEIGHT or both X_CELL_SIZE and Y_CELL_SIZE must be provided.Also tried the propertyextractor in serie with the rastercellcoercer and kept the attributes. Then I get all rejected in the numericrasterizer.Also this takes way to long. I have a lot of DTM tiles. Can somebody point me into the right direction?I've fou

Hi, I'd like to know how to correctly write geometry called MultiLineString and MultiPolygon using GML writer with known Application Schema and validate Output File set to Yes. I keep getting FAILED message 'Surface' is not allowed for content model '(MultiPolygon)'and'LineString' is not allowed for content model '(MultiLineString)' PS. Prefer Polygons over Surfaces is also set to Yes.

I am trying to build a workbench based on Dimitri's rooftop building smart recognition workbench.My first step is to use a decent resolution raster file from my GIS software I use. Problem is, it is not georeferenced, but does have a text file with the extension RCT or raster coordinate text. It does not have column names, but I was able to use, with and expert's help, a CSV reader, since it is always space delimited as X left, Y bottom, X right, Y top. But I am getting an error that the @GeoreferenceRaster is failingon the first attribute coordinate, X Upper Left. I have attached a copy of the workbench, PNG file, and RCT coordinate text file. Please note that the raster has an extension of JPG, but is really a PNG.

I have an Address: "198 whitten farm Apt 3". I would like to count the number of blank spaces in the address. if it has more than 3 blank spaces I want to eliminate whatever is there after the 3 blank spaces.

When there are duplicates present in the Update Detection Key Attributes, FME sometimes detects that there are two updated records, when in fact there are no changes. So it will report that 1 change as originalValue = apples, revisedValue = pears and a second change as originvalValue = pears, revisedValue = appleswhere all other fields are identical, i.e. if you put them through a matcher you would get no unmatched recordsIn these scenarios how is the comparison controlled? Does it relate to feature order? In an ideal world, a key value would be unique, but the world is less than ideal.

Hi, I have a FileGeodatabase and want to change some Z-Values from Line and Area Features (with all kinds of Geometry).For Example i just want to set all Z-Values which include 99 or 0.153 to 0 and keep all other Vertex Z-Values.The Elevation Extractor gave me only the first Z-Vertex-Value to manipulate. The 3D- Forcer changes every Z-Value. The Offsetter is not the right one either.I tried the Coordinateextractor an Coordinatereplacer but i dont know how to put my changes to every list element. I dont want to destroy the geometry (with Chopper or something else). I just want to add these simple changes for the height.My further suggestion are maybe some FME-Feature-Functions tricks with Expressionevaluator or a Python Skript?Can you help me or give me hint?  Thank you Richard

Hello,I'm new in FME and I want to put, in a polygon, the minimum value (from a raster) in this polygon inside this polygon.    I use :"RasterToPolygonCoercer" to extract data,"AreaOnAreaOverlayer" to transfert data to polygon.But I cannot think how to do this.

Hi.I'm trying to write features to some MS/SQL tables, and my translation is apparently successful, and the log file shows lots of features written. No errors are reported.However, the database tables in question are completely empty !I have a few constraints on my tables, and some fields which may not be NULL, so that may be the cause, although I should have handled that. But where do I see what the actual problem is, since FME doesn't include any error message from the database in the log file at all.Cheers.

Hi, I'd like to create an empty folder in zip file that my files are going to be written. zip file location is defined as published parameter and used as prefixed parameter of every writers destination parameter, e.g. $(zipfile_location)\\lines.gml AND $(zipfile_location)\\data.dwg) Cheers, Želimir