Transformers

Hi all, I'm trying to map fields to match a SQL table where some need to be Null and others are Not Null. As far as I can see, I've done this correctly in the 2 NullAttributeMapper Transformers (attached screenshots). Basically I need some to be Null, and others to be Not Null. These have been separated in the screenshots below by 2 NullAttributeMappers. I've attached the error as well, as this is proving to be quite tricky. Any help is appreciated.

I'm trying to get my head around this: I've been given a png image in a polar stereographic projection, a set of coordinates of its extents in LL84 and this PROJ4 string:+proj=stere +lat_0=90 +lat_ts=60 +lon_0=10 +a=6370040 +b=6370040+no_defs +y_0=3609144.7242655749 +x_0=542962.16692185635And the challenge to georeference the image. Problem is I can't use the RasterGeoreferencer with the extents because in LL84 they don't form a rectangle. Any other pure-FME solutions I can try?  

What are FeatureReader/Writer vs Reader/Writer advantages/disadvantages

Here is another simple-yet-not question: I am working with a large pdf and want to populate pdf_document_info_metadata attribute values for every feature.  I have tried: FeatureMerger, Joiner, Aggregator, AttributeValueMapper, NullAttributeMapper, AttributeManager (trying to use Adjacent Feature) etc. This should not be that hard, but I'm at a loss. Any ideas? Thanks,@lorenrouth​ 

Hi, I'm still fairly new to this tooling ecosystem. I have "inherited" a workbench and have made some changes to it. At some point, one AttributeManager started to appear in the "Incomplete Transformers" section of the Navigator. It's missing the attribute called "subcontractista": What I don't understand is, this attribute is being consumed in the preceding custom transformer as well as in the other branch that leads from it. I mean, in the following image, the green transformer is parametrized by this attribute and in the Tester that is hooked to the output, this attribute is visible under the FME Feature Attributes tab.There is no other AtrributeRemover or AttributeManager that might affect the presence of the attribute "subcontractista". In fact, I'm quite positive that I haven't changed that part. 

Hello,How extract the geoJSON geometry from the attached complex JSON file?The data model is a new one. So the supplementary attributes before "horizontalProjection" are right. The goal is to display the shape of thousands other surfaces for verification.Here is the code :Thanks for any information that could help.

Dear users, I have a string attribute stored in a field for >150k point features including addresses, numbers, and sometimes additives. Three examples of addresses:  Maria van Reedestraat 9-BSEduard Künnekehof 1Bucheliusstraat 11-BS What I would like to have, is a new attribute indicating only the street name (= everything before the last space) and a new attribute only having the street number plus additive, which matches everything after the last space.  I have found some tips regarding regular expressions, but I haven't found a way out yet.  Any help would be appreciated! Thanks in advance, Martin

I'm trying to load data from an Excel sheet which has spaces in it's name using the Generic Feature Reader. I've got the reader set up to read a dataset based on attribute values (derived from parameters), and to read the feature type directly from a parameter value. The above works perfectly regardless of the dataset name, but I can't get it to work when the 'sheet_name' parameter value contains spaces. I've tried the following;Using an attribute value for 'sheet_name' instead of a parameter value. This doesn't work eitherUsing an Excel reader rather than the Generic one. This doesn't work Any ideas or help much appreciated. In case it's of relevance, I'm using FME Desktop 2021.1.0.1 Matt

Road is aggregated based on Road ID, that I have in the table as well. So for example I want to create point in X meters ( X value from table) . Snipper is not working for this task. Any solution for this?Thank you 

I would like to apply an Excel macro to an Excel document which I have just written using FME Desktop 2020.2. Python Interpreter used is 3.7.This can be done using the library xlwings according to this post. According to the FME documentation I installed xlwings in the folder: C:\Users\<name>\Documents\FME\Plugins\Python Next step I tried to import xlwings using Python StartUp script in FME Desktop.import sys, six, numpy, xlwingsUnfortunately I got this error: Python Exception <ModuleNotFoundError>: No module named 'pywintypes' Is there an easy way to solve this? In case the answer is no, I will switch to another library which can apply a macro to Excel output. 

Hey! I have a bunch of polygons (in 3D) that I want to create break lines between. My idea was to use Intersector but it does not create the break lines for some reason. I have attached my workspace. To clarify, the green lines in this image is the result I'm looking for.  

Hello,I want to know if 90 columns have NULL values.How can I use Tester Transformer without testing each attribute one by one.Can I use the Text Editor and write it directly and how ?Thank you !

Hi, I have two shapefiles that represent two boundaries that are suppose to align in a perfect world but due to updates, they are now misaligned. The datasets are for the whole province and I need to find the area/ the specific part of the boundary that does not align with the other boundary. The boundaries are polygons but then are transformed into lines, and I need to find a way that the line that is misaligned with a 10 meter tolerance will get highlighted.  I have tried neighborfinder and spatial relator (+using buffer for 10m tolerance) but the softwares outputs keeps highlighting the entire polygon or an entire section of lines (even though one line might be misaligned).  Does anyone have any suggestions or ways to go around this? Any help will be greatly appreciated! Thank you.

I have 4 custom transformers saved to C:\\Users\\{username}\\Documents\\FME\\Transformers. I double-clicked them to install and they all installed successfully, but they don't show up in Workbench Transformer Gallery. I have clicked "refresh" and restarted Workbench, the refresh appears to run but doesn't generate any success or error messages. Any ideas how I could get these to display? I am running Workbench 2021.2. Thanks.

I have a few datasets of polygons and need outlines of the extents of each. Each polygon dataset has on average around 10,000 features and I need an outline of the extent of these to use in further processing stages e.g use as a clipper. Using the raw polygon data as the clipper instead is not an option due to how slow this makes the processing. I have tried dissolving the polygons however this does not make a single polygon for the dataset as some of the features are not adjacent to each other. I then tried aggregating, which does achieve what I wanted however is useless for further processing as the aggregate is deaggregated by most processes - effectively slower than just using the raw polygons.Hull building looked promising but does not accurately replicate the intricate boundary of each dataset. In ArcGIS it is possible to dissolve based on a common attribute rather than requiring a shared boundary. Surely there is a way to replicate this process in FME?

error log:QUEUED:trigger success:

I'm using a point on line over layer to split a long line into sections, I then need to create start and end points of each section. Simple process i've done a million times. This particular output needs to have the coordinates identical at the start/end of each section, theoretically they should be as they are split by the point at that location. The measure values are coming out identical, but some lat/longs are coming out wrong to the 9th decimal place - the issue is that its only a handful and so i'm not sure whats causing it. Any ideas?

Hello, I have a series of points that I would like to convert to a polyline feature. I have used the below workbench to accomplish the majority of it, but I'm stumped trying to fill in the gaps (in the line). Can anyone point me in the right direction? 

 I´m right now trying to learn the basics of FME and have been busy doing calls to open data in Sweden, primary published as json files. I have managed to read the, and explode a list and write back to an excel file. I now try a larger dataset of about 1 million rows. I can not figure out how to extract more than the limit 500 records. I have tried searching in the forum an Google without understanding how to proceed. I attach the links to the dataset below. I would realy appreciate if someone could show a setup that loops and writes all data to a csv for example.  Dataset:https://www.vgregion.se/ov/dataportal-vast/#esc_org=https%3A%2F%2Fcatalog.goteborg.se%2Fstore%2F6%2Fresource%2F1I try using this download URL: https://catalog.goteborg.se/rowstore/dataset/ce5b8afd-6721-49c7-9ebc-f1ad33fba266

OK, here goes.  I have some data in a SQL Server database but it is stored in an object-oriented fashion which means a normal SQL query doesn't work, I have to pivot data in order to create a traditional tabular view.  Now that in itself wouldn't be a problem, but all data is stored in the same location with each asset class (e.g. door, window etc.) having a different number of attributes, so depending on how I pivot I get the relevant attributes as fields.  All good so far?  OK, so I want to push this data from the source database into the target database (Oracle in this case) and the method for doing this is currently using SQLCreator to create the fields by which I want to pivot (based on the asset class as a parameter) and then SQLExecutor to retrieve the pivoted table, which works, up to a point.  What doesn't work is that the attributes of the output from the SQLExecutor are not exposed, and I can't get them to be exposed without Populate from SQL Query option, which fails as it 

I am using FME 2019.2 to read multiple Autocad drawings (r.2018) and then write them out into a single combined DWG. I've referenced a template file with all of the block definitions in it for the writer, but cannot seem to get any of my CAD blocks to write. The log tells me that "AutoCAD Writer: 3189 feature(s) were rejected and not written to the destination dataset", but doesn't give any hint as to why they were rejected. I've tried this using both the RealDWG and Map OD readers & writers, and I've tried it both with and without a DWG Styler transformer. Why are my blocks getting lost in translation?

Hello FME community, I have a long number (see the picture). I want only up to 3 decimal places to be displayed. Thanks in advance for your help 

Hi folks, When working with XML files, often I find it really usefull to be able to use the XSD reader to directly structurize the XML in FME feature types, AND to be able to use the known XML schema to generate the correct schema (attribute names, list elements, data types etc). However, when working with the XSD reader, I noticed something peculiar, which I think might be a bit of a bug.  The thing is, when you select a feature path, FME will generate a feature type with all attributes/lists that are contained at that path.What I think is quite nice and usefull, is that when you select both a feature path and a subpath of that feature path, the attributes/lists that belong to the subpath, are not included in the feature type of the parent path.  So in my case, when I select only 'msg:GMW_PPO' for the feature path, the feature type contains all contents of that feature path, including a list attribute for the subpath 'msg:GMW_PPO/msg:monitoringTube'.If however I select

I have a layer with 75 parks. I need to buffer all of them with 300 meters. But after this I need to clip the buffers with roads and railways(barriers). When I done this I only want to keep the polygon that are on the right side of the road. Sometimes these areas intersect an other park. So if I go for spatialfilter areas are kept even though they should not be. On the pictures below I only want to keep the selected polygon(yellow) because that polygon are intersected of the orgianal park. I've tried group by i spatialfilter but get no success. Is it possiable to solve this? Have attached my workbench with orginal data.  best regardsJesper

I have a SQLExecutor that runs fine on Desktop but does not output any results on FME Server. The Server log file indicates that the SQLExecutor created results but that they are not being output to the downstream workspace. Any idea why Server might be behaving like this? Here's some log output from Desktop:2021-11-02 12:06:53| 492.3|  0.2|STATS |SQLExecutor_4_RESULT Feature Counter -1 361 (TeeFactory): Cloned 132885 input feature(s) into 132885 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_INITIATOR Feature Counter -1 2147680433 (TeeFactory): Cloned 1 input feature(s) into 0 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_<REJECTED> Feature Counter -1 2147745969 (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)Note that it says "Cloned 132885 input feature(s) into 132885 output feature(s)" And here's the equivalent section from the Server log:806 2021-11-2 04:10:34 | SQLExecutor_4 RESULT Transformer Output Nuker (Te