Transformers

Hello! I am using GeometryReplacer to convert a CSV file with a column containing WKT geometry. The column in question has the name "GEOMETRI, LINJE" and contains a linestring. When using GeometryReplacer, the result is a point with a point that seems to be the centre point of the coordinates of the linestring. As an example, the string LINESTRING (280696.375713613 6653063.17617913, 280698.536236071 6653059.93539544, 280707.427616957 6653067.91270913, 280704.353027305 6653070.5718137, 280696.12642256 6653063.17617913) converts to a point with coordinates 280701.671, 6653065.356, neither of which appears in the original linestring string. The coordinate system used is ETRS89.UTM-33N, which I set using a CoordinateSystemSetter before the GeometryReplacer. All of the LINESTRING () WKT-geometries become points. Does anyone have any insight as to why this happens and what I can do to make sure that GeometryReplacer produces the expected linestring instead of a point? Thanks!

 IMX Writer: Detected in invalid table names 'RoofSurface'. This writer expects only specific table names. Please add a new IMX writer to see the valid table names I guess it has something to do with the original tables from my citygml. but how to tackle this issue? 

I would like to combine lines on the attributes in column A OR B OR C and so on. The "combine on attributes" is an AND condition. What would be the cleanest workaround to achieve this?

When I run the tool the "Band 0" values are staying the same after the reprojection transformer is run, any tips to get the new values for "Band 0"?

I see how I can create a geometry using a creator where I can specify the geometry parameters. For example, creating an Clothoid by specifying Start X, Start Y, Direction etc. But these are all values that must be hand entered. How can pass these values into an "inline" Creator to set the geometries accordingly? I see 2DArcReplacer etc but not one for Clothoids. Is there a GeometryReplacer of sorts that would let you specify the type of geometry desired and which incoming attributes to assign to the relevant Geometry Parameters?

I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

Hi, This question is linked to a previous question I posted on the community, about the number accuracy of the Esri ASCII GRID writer of FME. Please see that question for more details and screenshot, but a quick recap of it; when I created a dummy raster with Real32 interpretation, in which an original pixel value would be '0.0250313',the rounded pixel value would become '0.025',but the Esri GRID File seems to convert to Real64 interpretation and stores the value as '0.02503128908574581',whereas I would like the rounded value '0.025' to be written to the file. I noticed that this could save up to 50% in the file size. I suppose that this item is related to the Floating Point Precision and String Formatting in FME. Now I have been investigating some options for an efficient workaround to this question. I.e. to be able to create Esri ASCII Grid files that don't write out pixel values with 16 decimal values. I came up with two methods, but I think they

In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

Here is the background. Esri uses subtype/domain objects in its GDB implementation instead of native RDBMS' relational tables with foreign key constraints. The result is often "nu-disciplined" databases from the RDBMS standpoint. I hope to create relational tables to protect data assets by extracting all the domains in our GDB.

Is there a way to read and use AutoCAD's SHX Fonts with FME? I need to be able to read in a DWG, determine the font used and recreate a map, currently trying to use the PDF Writer, using the original AutoCAD SHX font.Using the PDFStyler I can choose / define a Windows Font but can't figure out if and how the AutoCAD Fonts can be defined.  

Hello FME community, I'm trying to delete or merge some layers of DWG files and write them back as DWG files. during the transformation I lose my blockreference and the blockreference is written as a polyline. I would like to know how the blockreference can be written as a block reference. the first picture refers to properties in the source and second shows properties after transformation.   

Hi All, I'm trying to identify whether a coordinate system in DWG is set to a User Coordinate System (UCS) or a World Coordinate System (WCS). Essentially want to query this in a tester transformer. Thanks in advance for any help!

Hi, I have an attribute "descripion" which contains some html code:<figure class="bs-special-article-teaser-image bs-asset--full bs-asset--square" id="SP-NjExNTY5NjMw"><div><div class="[ js-bs-lazy-image-loading ] [ bs-fixed-size__content ]" data-noscript><noscript><div><img class="bs-fixed-size__content" src="/tourismus/rundgaenge/stadtrundgang_stationen/Burgplatz287.jpg.scaled/586dd9dd596cf8b34ecc51781c490af2.jpg" alt="Burgplatz"/></div></noscript></div></div><figcaption class="bs-asset__caption"><span class="bs-asset__caption__copyright">© Braunschweig Stadtmarketing GmbH/Frank Sperling</span></figcaption></figure> <p class="bs-paragraph"> Der Burgplatz ist ein Ensemble von hoher geschichtlicher und kultureller Bedeutung. Seit dem 9. Jahrhundert lag hier der Fürstensitz der Brunonen. Herzog Heinrich der Löwe hat den Burgplatz im 12. Jahrhundert zum Zentrum der welfischen

I have points and lines, I want to snap the lines to the points, both edges, ends, and sides. I tried using the snapper and also tried using the anchored snapper, but I still don't get to snap some. I have used intersection transformer, it does the major part of the snapping but creates new points at any intersection without a point. I really would love to do this snapping based on relationship (attribute)

Greetings,Can one pass a user parameter into the JSON Network Authentication Username and Password Fields? If yes, how? Thank you,TylerFME Workbench 2022.1

I've created different user parameters for my workspace. Some specific combinations will lead to an error. The user has to choose the output format (Geotiff, JPEG or JPEG2000) and the color depth (Gray8, RGB24 or palette). JPEG and JPEG2000 don't support palettes, so those combinations will lead to an error. How can I configure the workspace to respond to invalid combinations of output format and color depth with a costum error message in the log file? Thanks in advance!

Hello FME community, I have 200 dwg files that works as tiles (mosaics) for a large area. I want to do a certain process on all DWG files and then save the file with the same name. when I read and then write all DWG files with fme, they are all saved in one DWG file. does anyone know how I can read all DWG files at once and write them to individual DWG files. Thanks for your support 

Hi community. I have run into something that I am trying to automate but falling over at the last step.The process I have is:Download data-set names from FTP.Split data-set name list into attributes.Download data-sets from FTP to local drive.Read downloaded data-sets using the feature reader.Dynamically write data-sets into SQL server. The last step I have missed is setting the primary key attribute for each data-set (fortunately it is the same 'ATTR_STR_1' for each data-set) as the dynamic writer is reading from the schema attributes coming out of the feature reader.Has anyone had success with setting a primary key in dynamic writing?I have tried a few things:SQL To run after write: alter table landmap_polygon add primary key (ATTR_STR_1)Error here is that the column is already populated and not set to no 'nulls' and I would need to set this for each table (we won't know table names until after the fact).Read schema from existing table (after setting primary key).T

Hey all,I am trying to set up a workspace to update, insert, and delete a heap of our ArcGIS Online feature layers once a week or so.I have been able to set it up once using the AGOL feature reader into the change detector in a similar way to How do I write updates to an existing ArcGIS Online feature service? (safe.com).I am unable to add dynamic layers using the AGOL feature reader, thus limiting my ability to update multiple features using it. My question revolves more around how to cycle through multiple layers and add to the change detector.I have tried setting up a CSV with the required information and then using a standard feature reader, but that does not bring the attributes that are used to compare in the change detector.Has anyone done a similar project or have an idea on how to Have it work? Cheers 

I have a dataset with a messy 'comments' column. I want to extract numbers from these comments, but only when the come before a ceratin word. For instance, a comment could be: on januari 21, 16 boats passed or21 boats passed on januari 12 2017 I only want the numbers when they come beofre the word 'boat'. Is there a way to do that?

Hi all,Is there any suitable transform for following scenario?. Like I have a shape file which have data with some attribute and I have an excel file which holds same attribute data like present in shp file attributes. I want to filter those attribute matching feature.all related suggestions are welcomes!Thank you in advance,Saravanakumar 

Hello. I saw that in the latest version of workbench 2021.1 that the sorter doesn't work well on number values. The sorter stops at 99 while the highest number is higher. Now i filter all values below 100 and then the next stop is 999, etc. Do you recognise this problem? Greets, Jacob

I've got an issue with the stringsearcher. It does not seen to work as I expect it do do. It might be my regex skills, but I think I tried all possibilities. What  I've got the following text: "324324" "maatvoering; hoogte; bouwhoogte; maximum bouwhoogte (m)"="8", "maatvoering; hoogte; goothoogte; maximum goothoogte (m)"="4" asdfasdf sadfsadfsf 343244 In this text I would like to find the first number after it finds the word 'goot' in the text. In this example this should be the bold number 4. I'm trying to do this with the following expression: (?=goot.*")[0-9]*(?=") But it does not give any results as you can see in the screenshot below. Any ideas what I'm missing here? 

 We may not have the certificate on the date we plan on doing the installation.

Hi All,  I'm trying to find a way to snap a point on a line segment to a point on one of the line ends, based on whichever one is closer. The points on the line segment and the line itself share a common asset ID, but the points on the ends of the lines are strictly geometry. The only attribution is a unique ID, but it doesn't relate to the line or the point on the line at all.  Right now I am using a spatial relator on the lines and end points. I now have, per each line segment feature, a list of end points that touch it.  I want to find a way to use NeighborFinder (or anything else - i'm open to ideas) to say "ok, where the line asset ID and the on-line point asset ID match, find the closest line end-point from the list. I've attached a small diagram/graphic to illustrate what I'm on about.  Any help would be appreciated!