Transformers

Hi guys, I have created all the vertices (point features with z information) on my line feature. Now i would like to create 3D polyline feture from existing line.1. I would like to maintain line feature and its attributes - so an option of creating line from points is not an option.2. Is there any option to define each vertice on my line feature a z information from existing points?Thanks in advance again. Bye, Miha

Hi,  is there a way to expose the file type suffix (e.g. ".shp") after the file has been created and zipped with the FeatureWriter? The "_dataset" attribute only yealds the .zip suffix whereas _feature_type attribute does only show the file name without the suffix. Thank you for your help.

Hi,I have boxes shp and building shp.(Jpg_1_1)I want to cut the buildings according to the box limits but I want the buildings that touch the box limit to stay in that box. A building can be in more than one box. (jpg_1_2)I use clipper but cut buildings according to the box borders .(jpg_1_3)  Finally, I want to export according to the box names .Example: (1149334,1149935)

I want to create boundaries on some point cloud data (see https://knowledge.safe.com/questions/109029/how-to-create-disjoint-boundaries-of-disjoint-clus.html ) Note that the point cloud data were previously stored in an oracle dabatse as multipoint For some reason, the ETL get stuck during the boundary polygons creation with the HullReplacer My datasets is very big (~ 26 millions of points). I would like to know if there are some transformers like pointcloudthinner for single multipoint in order to reduce the density of the input points or if there a reverse transformer for pointcloudcoercer so that I can reconvert first the single multipoints to a pointcloud and then use for instance the PointCloudThinner before sending the data to a Hull replacer Thanks

Hello, I have a table like this: System ErrorAffected RegionTotal Error 1City2Error 1Village5Error 2City 7Error 2Village3 What I would like to have is this:Affected Region Error 1Error 2City 27Village 53 What transformer do I need to use to change the table structure?Thanks.

Hi guys,I've seen that the transformer "OffsetCurveGenerator" creates me some gaps on one of the offset lines generated.Here are the parameters set:The input line from a ESRI Shapefile, which makes the issue (nothing really complex..):and here is the one on which has been created gaps (PINK) right side, and (BLUE) the Left side with no gaps:As you see, the other MultiCurve line, well created is the LEFT side from the transformer output. But the RIGHT side (pink) is created with gaps.I need to say that I tried to isolate that line, and the output stays the same.I use FME Desktop 2015.1.0.1 - WIN64 - Build 15480.Thanks for the help,

Hi,My question is so : What is the best way to recover all the points of a point cloud (las) within 5 centimeters of a facade (stl)?Among three ideas, only one seems to work (taking 1h30 of calculation for three million points and 96 facades)PS: A facade is composed of two triangles in STL formatThis idea is to start from the stl, to extract the 6 points of the two triangles, to keep only the 4 unique ones composing the plan thanks to PythonThen go through a "TinGenerator" before using an extruder on either side of the Tin surface in order to "Clipper" the point cloud with the 5 cm extruded planesBut this solution seems particularly time-consuming to me given the lack of input. I therefore seek to simplify this process so that it is more efficientBest regards, Corentinhttps://www.zupimages.net/up/20/22/6jkm.png

Hi, I appreciate this is an additional question on this topic, but I am struggling to get the Counter transformer to reset to 0 in my particular example.I have a dataset along the following lines: Site,Date,EventSite1,20200101,0Site1,20200102,0Site1,20200103,1Site1,20200104,0Site2,20200101,0Site2,20200102,4Site2,20200103,0Site2,20200104,0 I would like to set a Counter for each site to essentially calculate a value for "how many days since last event", i.e. the Count +1 for each 0 and resets when it encounters a non-0 value, resulting in:Site,Date,Event, Days Since Last EventSite1,20200101,0,0Site1,20200102,0,1Site1,20200103,1,0Site1,20200104,0,1Site2,20200101,0,0Site2,20200102,4,0Site2,20200103,0,1Site2,20200104,0,2 I'm struggling to have the Counter reset to zero, perhaps I should be looking at an alternative approach, as per the advice from @takashi this Knowledge base article? https://knowledge.safe.com/questions/5287/counter-by-group-but-reset-to-1-within-a-group.html

i have network properly noded and i got paths by short path finderbut some points has two paths and i would like to get the two paths if it is possible ,how could i do that?  i read some where that i can remove the path after it founds but i am not sure how could i do thatFME 2018Thanks in advance 

Looking at migrating one of my clunky ArcGIS scripts over to FME but is betraying my lack of experience with Raster Transformers!It's somewhat straightforward I think, I just am looking for what the key Transformers are for the 2 following Steps:Subtract from a DEM Raster's Cell values the values in overlaying PolygonsBuild "Filled" Contours (ie. Polygons that contain Cell elevation values within certain range intervals)Use case is water pressure contour generation. Hydraulically this is the imaginary Hydraulic Grade Line which at most times of the day is almost a flat surface (Hence the 2D polygons with an HGL attribute value) and subtracting the local Elevation from that (from the DEM) derives the local Water Supply Pressure.My ArcGIS process migrating from builds a second Raster out of the Polygons, and uses that in a Raster Subtract ArcGIS Geoprocessing Tool to create a 3rd raster with the Delta Cell values, and then create Filled Contours from that, but I suspect

FME(R) 2020.1.0.0 (20200305 - Build 20510 - WIN64) When using the BulkAttributeRenamer with a variable prefix. The prefix doesn't get added on the attribute but shows in the inspector.  Any thoughts?

Ny mappe.zip

Dear community,  is there a way how I can set a data type (integer, char, float, ...) in a transformer?  Usually I create the data type in the Feature Type Properties menu of the Writer. On some occassion, it would be helpfull if I could set the types manuelly in a transformer, so that the writer recognizes the formats automatically.  I do not want to tell every writer which format it has to be. We can of course tell a single writer all the data types and then copy the attributes from one Writer to another. This one should work.  But can I set the data type to a specific type in a transformer before I write the data out?  Thank you very much for your help.  Kind regards, ThomasK  

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!