Transformers

Hi,I need to update a database model which has a lot of fme jobs associated with it. So I would like to extract all connections made by all our workspaces and make a little data model of all fme jobs and associated connections. I get some info out of the fmw reader but there are connections made by sql statements (and pl/sql) as well which as I see it now would need sql parsing.Is there any alternative for going down the python route? Cause I would to need learn something I hardly use and thus forget. Administering fme jobs this way would make it possible to gather more quickly where to update the fme jobs after a data model change. Any alternative transformer to the python caller? Any alternatives to the fmw reader? Any workflows you guys use to organize that forest of jobs? All the best, Robbert

I'm having a problem using WFS XML filter. I'm trying to read only 6 features from entire dataset and I get the following error:I wrote query in SQL and need to convert it to XML:"SAV_ID" IN (21,23,25,55,56,88)Interestingly when I'm quering only 2 of thoses features, I get no errors. XML filter (working one) for 2 features is:<ogc:Filter>    <ogc:Or>        <ogc:PropertyIsEqualTo>            <ogc:PropertyName>SAV_ID</ogc:PropertyName>            <ogc:Literal>21</ogc:Literal>        </ogc:PropertyIsEqualTo>        <ogc:PropertyIsEqualTo>            <ogc:PropertyName>SAV_ID</ogc:PropertyName>            <ogc:Literal>23</ogc:Literal>        </ogc:PropertyIsEqualTo>    </ogc:Or></ogc:Filter>I tried the following variants (for more than 2 features):(1) (gives error)<ogc:Filter>    <ogc:Or>        <ogc:PropertyIsEqualTo>            <ogc:PropertyName>SAV_ID</ogc:PropertyN

Hello, I'm using FM0 writer on FME desktop and everything works fine.  When I try to run the same workspace on FME Server I get exception: Caught a COM Exception in FM0Writer::open()  Im writing file to nas share. \\\\naslocation\\test.fm0 but when I would write it to zipped location: \\\\naslocation\\test.zip\\test.fm0 then it works fine. What can be the reason for that?

String text = "John.Davidson/05051988/Belgrade Michael.Barton/01011968/Krakov Ivan.Perkinson/23051986/Moscow";

I want to filter from a dataset the polygons that contain no further polygons. I have tried the Transformer AreaOnAreaOverlayer and SpatialRelator (Attributes (s) that Must Differ = element_id) so far. 

Hi, I want to read a dwg file, transform the coordinate system and write it back in to a dwg file again. Therefore I use the CsmapReprojector. The transformation works fine, but I have the problem that all hatchings/solids of the dwg file are lost after the transformation.How can I solve this problem?Thanks and best regards!

Hi, New user here,I try to make an atlas in a geospatial pdf. I have multiple vector map with a main shapefile with multiple polygone (it's the foundation of my atlas)But I want to chose between 2 raster image (ecw) as base layer for each map,I want to chose the good raster based on the size of the main feature of my atlas. I created a BoundingBoxAccumulator where I can have the area of the futur map to display.How can I switch between the two raster based on the value of the area ?if area >XXXX then put raster 1 as base layerelse put raster two as base layer.Thanks in adavnce for your help.

Is there a good way to calculate the age of this tree with FME? https://twitter.com/reisir/status/1091726774919196673?s=19 

Hi,I have two shape files, one is polygon and second one is point. I need to reposition point shape that are outside of polygon so every point is inside of polygon with same id. Input: Output:Thank you.

Hi, so I have an update SQL query that the sql executor transformer executes. It looks like UPDATE *TABLE_NAME* SET COLUMN_NAME = @VALUE(ATTRIBUTE_1) WHERE OTHER_COLUMN_NAME = '@VALUE(ATTRIBUTE_2)' The first attribute is always a number, but the second one is a string so I have to put quotes in. But, the string can contain quotes itself, which causes the query to fail for those cases. If I put double quotes around it I get a SQL error: it thinks I'm setting it equal to the value of another column in my database table instead of a FME attribute. How do I put the whole string value of attribute 2 in my where clause, quotes and all?Thanks! 

I need to check a long list of keyword (excel1) if they are available in an even bigger list(excel2) of phrasethe end result will be keyword 1 : phrase 228keyword 2: phrase 228keyword 3: phrase 230.....etcthis case is used to much land use with standard naming Any idea

I'm trying to migrate from dwf's to GIS. When I inspect the dwf in inspector, none of the attributes that I really need and can see in Autodesks design review are even listed in the available columns under table view schema. Is this a known issue or is this due to my limited experience with FME?

Can somebody explain met the different encoding options for JPEG2000? Normally we convert our TIFFS to ECW with a nice result and the converting is very fast. Arcmap server needs an additional license to use ECW's, so I was thinking to use JPEG2000 instead.The image quality is a tiny bit better and the file size is smaller, but the convertion took so long...I used the standard FME writer options. Encoding profile 1 that is.What is the difference between all those profiles? There is very little documentation about it or I cant find any.  ThxKoen

Hi I'm wanting to use window functions in the Inline querier. For example, ROW_NUMBER() OVER (PARTITION BY .. ORDER BY). I see that SQLite version 3.25 onwards supports window functions. However, when I tried to write a query in the inline querier it was unable to execute the query. I'm using FME 2018.1.1.2. Does anyone know what version of SQLite the inline querier uses for FME 2018.1.1.2?

With the attached Workspace I am trying to match up to adjacent boxes that slightly overlap. I was hoping MRF2DCleaner would do this and remove the overlap. However, it doesn't seem to read areas at all.Problem.png shows the overlap. ExpectedResult.png shows what I want to achieve. Any ideas?

I'm creating an attribute for storing start date/time of processing with AttributeCreator and I'm having a hard time removing the decimal of a second. @DateTimeFormat(@DateTimeNow(local),%a %b %d %H:%M:%S PST %Y) OutputThu Jan 31 11:16:20.9415159 PST 2019 WantThu Jan 31 11:16:20 PST 2019

 Hi,I need to reproject data using FME and am wondering if FME's NAD27_to_NAD83_Canada_FME (Reversed) is the same as NAD_1927_To_NAD_1983_NTv2_Canada? 

FME Server 2018.1 - Build 18520 - linux-x64 (on FME Cloud)Workspaces loaded with FME Desktop 2018.1.0.1 (20180730 - Build 18528 - WIN64)Python Compatibility Scripting : Pyton 3.4+Apologies for the way the question is elaborated but I really do not known where this error in FME server is coming from and how to describe it (I googled it and I can't seem to find any reference)It is incosistent, it appears on workspace execution and the job fails (at the end) but if the job is rerun (same workspace) everthing works fine, then it may appear and disappear again. It appears in workspaces that do not have any python transformer neither start-up shut-down scripts.Could anyone help?Thanks

I have two datasets . Both of them consist of linestring. One data set is street centerline and the second one is the left and righ side of the street. I would like to find the lines in second dataset where they intersect with lines in the first dataset.It is pretty straight forward. I can do it in QGIS with help of spatial query. However, I am not able to identfy those lines correctly. Both Spatial Relator and Spatial Filter find some of the disjoint lines as intersected. I do not know what I am doing wrongly.I would be very happy, if someone could help me. Thanks in advance.Here is the snapshot how my two datasets look like. I would like to find the intersection as marked in the pic. This is how the workbench and spatial filter parameter lok   Here one can see the lines that are detected as intersected however they are not even touching each other.  Those lines are however identfy correctly as intersected.

When I move feature classes from file geodatabase to ArcSDE using FME, all the embedded metadata in feature classes disappear once they are moved to ArcSDE. Metadata is in the description of feature classes. Please advise what do I need to do to retain metadata?

I'm trying to map the header from my json so i dont have to manually paste them into the json extractor. So far i have two https callers one for the response body and the other for metadata. I create a list from the metadata for the header. This works fine! I next use attributeexposer but it just adds the list as an attribute. How do i get the list to become the header?

If I have a 2018.1 FME Server can I use FME Desktop 2017? What if I have FME Server 2017 and FME Desktop 2018.1?

HiI am extracting multiple hrefs. There are some irregular CSS tags that are being rejected. I have corrected the spaces by using a stringreplacer but there are a couple I cannot figure out. one being "Unsupported or invalid CSS selector: "democratic-republic-of-congo-(kinshasa)"I need to remove the parenthesis, there are also ones with the word "the" at the end of the CCS href. I only have about 12 of these, so is there a way to replace an entire href with another and I will just create 12 transformers? any ideas?

Hello, new user here.I try to make a geospatial pdf from multiple shapefile as source. I use Mapnikrasterizer for the style of each layer, but when I try to save the file, my layer are well stored but the transparency turn black. Thanks in advance for your advice.

I have an unconventional excel spreadsheet where the first column is a work order number and the subsequent columns are employee names. Below each employee name are the hours they spent on each work order. See below:  The goal is not only to use the value of an attribute column but also the attribute name (in this case the employee name) in a httpcaller without transposing/pivoting. So in theory the Request URL in a HTTPCaller would have the following format:https://***BaseAddress***/addcost?data={"WorkOrderID":@Value(Work Order ID),"Employee":"AttributeName","Hours": AttributeValue} I've yet found a function to extract the attribute name. The text editor only allows me to extract the value of the attribute. I'm unsure how to accomplish this. Any recommendations is greatly appreciated.