Transformers

I have a dynamic workbench that reads shapefiles and exports them to a FGDB. I have a .shp that had a few duplicate field names and wouldn't export to FGDB until I removed them. Is there a Transformer that will flag these duplicate fields and remove or rename them?

I have multiple shapefiles (total size is 8.4 GB). Those need to be zipped. When using FME's ZipArchiver, compressed file size is 4.43 GB. But when using third party app – 7zip, the result file is ~11% smaller (3.94 GB). My guess woul be that ZipArchiver uses different libararies for compression. Maybe it is possible to use 7zip libraries in ZipArchiver, when compressing files?LZMA compression won't work in this case, because I need to be able to extract archives with built-in Windows extractor.

When I trying to build of lines from points, I get some thing like this:I am using LineBuilder, and group by attribute (each group of points has a different name), but I don't understand why I also get connect line (green one) between them ?

Hello,I've made a FME to raterize some point cloud into elevation raster but I'm not satisfied with the result. I would like to be able to specify in the transform parameters which point is used to color the raster (min z, max z, etc ...). Indeed when we have power lines for example it is desirable that the point used for coloring is that of the line and not that of the ground. This makes it possible to highlight it in the Raster.Do you know if there is a way to control the coloring in this way? Example :That is what FME give me (left) and what I want (right)You'll see the difference on wire and tree Regard,Arnaud

I'd like to read a text file containing several lines of user defined variables given in the following format:var_name = "var value"There are many lines, each one contains one single variable with one single value:var_name0 = "var value0"var_name1 = "var value1"... I read the text file using an AttributeFileReader to which I connected an AttributeSplitter. My results come as one single concatenated line which is obviously not what I want.  In the Delimiter field of the latter, I tried inserting `\n` `\r` or`\r\n` without any success.  I also tried inserting a single newline by pressing one time enter in the "Editor" as discussed here (2013): https://knowledge.safe.com/questions/2361/use-attributesplitter-with-a-carriage-return.html without much success.  I'm using FME(R) 2020.0.0.1 (20200316 - Build 20202 - linux-x64) on Ubuntu 18.04. Thanks.

I'm trying to convert a bunch of building wall tiles from SHP to DWG. The tiles are already polygons, but I coerced them into fme_polygon anyway. Then I use the DWG styler, with Area: Hatch, Fill Pattern: SOLID. The Inspector shows what I expected, however when I write the data, what I actually get in AutoCAD is just line-thin hatches, with some even missing. Also, when I open the file in the inspector, it just shows the lines on the ground, or everything got flattened.. do I need to manipulate the data further? I figured I could leave it as polygons, but AFAIK AutoCAD still interprets those only as the boundary lines, i.e. not opaque surfaces.

I need to find all empty folders. Any hidden system files do not count (for example, Thumbs.db). I tried using Python, but unsuccessfully. Can someone help me on this?import fmeimport fmeobjectsimport osif len(os.listdir(feature.getAttribute('path_directory_windows)') ) == 0:    feature.setAttribute('Value', 0)else:        feature.setAttribute('Value', 1)

Hi all,I'm trying to read an .fbx model exported from Infraworks. It appears in the data inspector with textures mirrored and the following warning : "FBX_1: A texture used by mesh in node 'Mesh N' references a UV set named 'default', which doesn't exist"I've tried to re-mirror the appearance but nothing seems to work and I don't know how to reference the UV set ... Do you have any idea what am I doing wrong ?The area in Infraworks :The area in DataInspector:the fbx file and others : Regards,Louis 

I have inherited some older workbenches/server workspaces and am noticing some issues with writer parameters, specifically where ArcSDE connections are concerned. For examples, I found that "accidentally" saving an old FMW in FME 2018 Desktop when the FMW leveraged fme_where without the explicit setting in the WHERE field, wreaked havoc by turning some updates into inserts. I have fixed that by cleaning up the workspace.1) Now, I'm looking at a workbench that is doing versioned editing in SDE and has the Writer set to 'INSERT' and 'CREATE IF NEEDED'. Yet it's doing updates. How is that possible - what am I missing?

Hi,I am currently calculating date time intervals via the DateTimeCalculator that result is ISO Duration format (PT28M20S for example)I would like to format the result into a FME datetime but havent found a way to do it with the DateTimeConverter. I can split the value into its parts and then combine them but there should be an easier way...I am surprised that FME doesn't recognize and can parse this date time notation, after all FME is producing it....Using FME 2019.2.0.0 build 19801Could be I am missing something, any assistance would be appreciated.Cheers,Itay

I am able to open a dbf with excel with no prompts, and with libreoffice it prompts me to use Arabic (ibm864) coding and then opens fine. But when I specify that with FME, the table is scrambled. Sorry - I tried to upload it but dbf are not allowed.

I have two datasets with 30 columns and after running the changedetector to compare 20 of these columns it states 0 are unchanged, how can I figure out which of these columns is the cause for the datasets not being the same? Would I use featuremerger or is there a simpler solution? to compare the columns to see whats different based on 1 shared unchanged column.

Hi,I need to extract information, responses from a survey123 form, into the FME Desktop, but as information there is no geographic information. How can I do this? It seems that the AGOL reader only reads feature services ... Thanks

Hello,I would like to compare two attributes of the same table: e.g. a table of features with the following attributes: UID, old name, new name.I would like to know for which features the old name is the same as the new name and identify the features whose name has changed. Afterwards I would like to create new tables for all (and only) these features whose name has changed, one with the UID and the old name and one with the UID and the new name.Which transformers should I use ?Thanks for you help!

Hello!  After trying different options with LineExtender, Snipper, PointonAreaOverlayer, I don't get the result I want. What I want: to be able to extend a line with an attribute. However, this value is different for each side of the line. Vertices on each side of the line contain this information for the particular side.  How do I get this to work?  Thanks a lot!!!  Stay safe!

Hi,  I noticed the following behavior.I created two shapefiles for this test : line.shp and surface.shpBoth contain several feature including one with multiparts (multiline and multisurface). When using CoordinateExtractor with mode Specify Coordinate + index=0, I get in the _x and _y attributes the first point of the first part of line/surface.I assumed I would get the same with @XValue() and @YValue() but it is not the case for the multiparts features.For those I get a point far far away from the feature, with integer values for X and Y. Anybody knows why ? Is it a normal behavior ? Tested on FME 2018.1 and 2019.0, see enclosed test workspace on FME 2019.

I am looking to change the RouteName column (incoming website data) from - to _ format using FME workbench 2019 2.3.1 . What transformer would complete this task? would StringFormatter work?

hey i am trying to do a 2D grid that is originated on the same angle of a line as an input feature,while i could do distance chopper on the line and an oriented boundary box, this doesn't give me the control i require to maintain the same polygon size. the 2D grid creater allows me to define the cell size within the grid but doesn't allow me to orientate it to the input featuremaybe i could do a start point, end point of the input feature, then draw a line, get the angle and rotate the grid? the challenge with this approach is that the line is not straight, so the grid needs to follow the line and not just the start and end pointsany advise would be grandmany thanksJames

 Hello Community, My goal is to find parallel lines (green) and the dots (5 points) of line (1). Line 1 and A,B,C and D belong to the same type in my dataset. A,B,C and D are almost at an angle of 90 degrees of line 1, sometimes it can even be 45 degrees; it's variable. If I use a bufferer all blue lines are processed. How can I exclude the A,B,C and D lines from processing?Greetings.

Hello, I'm looking for an alternative to the ArcGIS command "Spatial Join" in FME. Important for me is the matching option "WITHIN_A_DISTANCE_3D".My goal is to determine the number of neighboring points in a space from each point of a point cloud (and write it into an attribute of the point. In ArcGIS I would use the following command arcpy.SpatialJoin_analysis("powerline_01", "powerline_01", "e:\LAS\powerline_10m_DIST.shp", "JOIN_ONE_TO_ONE", "KEEP_ALL",""", "WITHIN_A_DISTANCE_3D", "10 Meters", "DIST_10m")Unfortunately, I have found only similar transformers in FME, which do not work in space, but only 2D. For me it is not interesting which point is closest to the origin, but the number of points within a space. Thanks a lot for any advise

Hi, I´m currently setting up a custom Python interpreter for FME Server 2020.0I have installed a custom Pyhon installation and added a packge to it. I´ve also runned the following commands with administrator privileges in command prompt:"C:/Program Files/FMEServer/Server/fme/fme.exe" APPLY_SETTINGS SYSTEM "Python/Use Custom Python" true"C:/Program Files/FMEServer/Server/fme/fme.exe" APPLY_SETTINGS SYSTEM "Python/Python Interpreter" "path_to_pyhon_folder/python37.dll"When I run my workspace that uses Python I get:The PYTHONHOME for the user-specified Python interpreter is not set through FME Options or a PYTHONHOME environment variable. On my local computer I can set the PYTHONHOME-parameter under Tools-FME Options...But what is the command to set this parameter on FME-Server?The documention only covers the two commands I've already runed.

Hello, I have an XML file (consists of 300+ entities) that I wish to insert to Azure SQL, thus creating 300+ tables. When inserting data to Azure (contrary to SQL Server) you must specify a primary key or a clustered index. I know this type of functionality is feasible by changing the attributes of the Writer at the Index column. However, doing this for 300+ tables manually, is not sustainable. Dynamic writer was not able to assist either. My other thought is to read as merged dataset, create a uuid and then using SQL Executor assign this attribute as a clustered index in every table? In this case, will the Writer be able to pick up this automatically? Other suggestions are much appreciated. Kind regards, George

I'm trying to read in JSON file. It has ANSI encoding. The reader throws an error:"A JSON syntax error was found at line 1, column 49. A sequence of bytes was found which is invalid in the UTF-8 encoding."Is it possible to get around this?

Hello everyone.I work with sewer programs, and found that working with NetworkFlowOrientor can be very helpful in ongoing work.The purpose for which I use NetworkFlowOrientor is to find mistakes made during autocad typing.As we know, sewage flows gravitationally so it is important that the beginning of the line be in the high sewer pit and the end point will be in the low sewer pit.When I work with NetworkFlowOrientor I put the sewer line in line port, And in destination the layer of sewer pits.When I check the result coming out in GIS, most of the lines that needed to be flipped were flipped.But about 20% reversed incorrectly.I guess the problem is in my file, I guess in the sewer pits layer.So I would like to understand the nature of the NetworkFlowOrientor well.And here's a small example of him turning the line the wrong way.The arrow indicates the flow direction, here in the original file. (Red is the end of the line)And in the picture here the line flipped over to me, even th

Hi All,Not to be hyperspecific but i'm trying to match phase values between two attributes on the same feature. I have an electric transformer with a phase value, and I've joined the phase value of it's connected electric cable to the same feature. The phase values can be any combination of A,B, or C. For example, the electric transformer might have a value of AC, and the cable it's joined to has a value of ABC. I'm trying to find a way to test if the phase values of the transformer are contained within the phase values of the cable. I've tried setting up a tester and matching XFMRPhase - IN - PrimaryPhase, the inverse of that. I've tried removing the commas and testing the same. I've tried testing XFMRPhase - LIKE - PrimaryPhase and I keep finding results that don't match. For example, i'll find a transformer with phasing ABC, primary cable with phasing ABC as unmatched. I'm not sure what the best way to tackle this would be, but a nudge in