FME Form

I've got a dynamic workspace I've set up, where a user can specify a SQL query that will be read from an Oracle database, and depending on user-specified input, generate either a shapefile, file geodatabase, or geopackage. I'm testing defining the schema based on a Lookup Table as outlined in this tutorial: https://community.safe.com/s/article/dynamic-workflow-tutorial-destination-schema-is-de-1 In my initial test, everything worked perfectly fine for shapefiles and fgdb's. However, some of the records in my database hold empty values in certain date fields that have been defined as 'fme_date" in the Lookup Table. In the .shp and .fgdb feature classes, these values are simply displayed as <null>. When writing the geopackage though, I get the following warning: GEOPACKAGE writer: Encountered date with empty or invalid 'yyyy' value. Expected format is 'yyyyMMdd', but got '' When attempting to open the geopackage in ArcPro, the geometry shows up but I'm unable to open the Attribute Table

FME Desktop 2020: How to filter all features that “don’t contain” a particular value? For example, in the screenshot below, I wanted to select all records that their “concatenation” field doesn’t contain the value 10

Hi folks, I'm trying to read a GPKG Layer from a rather extensive Geopackage which I use as an offline data exchange container. Said layer has a total of 228 objects, of which 47 have multipolygon geometry and the rest are tabular data. The problem: While FME Data Inspector on its own reads the data correctly, the FME Workbench GPKG reader reads all features as type "geopackage_none" and omits geometries completely. I have not found any reader options to resolve this. What can be done do force FME to read all "geopackage_multipolygon" objects correctly? Splitting the data into separate tables is not an option, since I have to use a given data model. Thanks for any helpful advice!

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 i'm trying to do basic treatment but it's not working for me. I've looking for this on technical forum but i don't find exactly what i want to do. I have a layer of points (which represents adresses) and a layer of lines (which represents streets). The points are snapped on lines. I want to calculate in a new field for each point adress, his distance to the startpoint of the polyline which it belongs. I try with "PointOnLineOverlayer" combined with MeasureGenerator/MeasureExtractor but i don't reach purpose. Do you have an idea for my problem ? Thanks Gui

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.

Hi, I have an issue when reading from an Oracle database. In my table a field is set to number(10,2) but when read with the Oracle Reader (Non-Spatial or Spatial Object), I get the attribute with the fme_data_type String. However, in the User Attribute tab of the reader parameters, I do see the oracle type numer(width,decimal) / 10 / 2. How come this can be ? Same behavior with the the FeatureReader. I am using FME 2020.2 Context is : reading from Oracle DB, reading from Postgres DB and comparing both tables with same attributes with ChangeDetector to syncronize Oracle to Postgres.

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-BS Eduard Künnekehof 1 Bucheliusstraat 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 have got a set of polygons as result of my FME processes which I want to write to DGN and Excel (they carry different attributes like area, the country they are situated in etc.). When writing to DGN, the polygons get an igds_element_id I would like to use to identify the polygons in the Excel document as well, so that an user who opens the DGN and the Excel document is able to connect the polyon in Microstation with the respective row in Excel. Is it possible to control the creation of igds_element_ids before writing to DGN (like it is with fme_text_string -> igds_test_string), or do I have to generate an additional ID (is it possible to pass it to DGN?!) respectively merge the igds_element_ids with a second Workbench to my Excel rows after writing th DGN? I'm a little lost at the moment when it comes to find a solution fot this 😵

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 either Using 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

How to convert json data from fme server manual trigger to xml data in fme desktop? (Is there a python caller or any other transformer tool?)

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, xlwings Unfortunately 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.

I'm using FME DEsktop 2020.1, version 20200605-Build 20573 on Windows 10 I have problem with the built in Webbrowser/web view in FME when trying to authenticate Webforum. The Web Service Authentication window(web page) is just white. It did work (rendered the web page) in the past, so Webforum must have added some html/css/iframe that does not work with FME's web component. I talked to Webforum about this and they say the problem is within the built in webbrowser in FME. (Webforum already support Chrome, Edge, Firefox and Safari) It's possible that the built in webbrowser does not support iframes or other html that Webforum use. Have anyone had a similar problem and managed to solve it somehow? FME developers, what web view/web component do you use to render html pages? FME developers, is it possible to use for example Chrome browser instead of the built in webbrowser to authenticate?

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?

I've been trying to run a simple test, where I read in a 12D XML file, then write the same data back out. The 12D file is read in successfully, with all expected data and attribution, but when writing back out, there is an issue with the geometry of the included TIN. The TIN feature is written, but is missing all of it's geometry parts. The image below shows the TIN from the read input file: This image shows the same data when output to a new 12D XML file: The vertex pool exists, but with no parts. Anyone have any ideas why this may be happening?

Hello FME'ers Welcome to What's Up Wednesday Thursday, our slightly late roundup of FME news for the week. Recent Polls I try to do a fun poll on Mondays and recently we had "How do you feel about the Parameter Editor window in Workbench", with this result: Interesting to see how that window is used by a lot of users - but not everyone. My poll for this week was, "which is the last transformer in your Recent Transformer list"? As you can see, mine was the AttributeExposer. How about you? Past, Current and Upcoming Events Starting next week on Monday 6th December, we have the traditional 12 Days of FME competition . This year there are six puzzles spread out over 12 days. Most are just very simple quizzes. One might take a bit more effort. The grand prize?! It's pretty spectacular this year. I'd enter to win it, except our lawyers said that I couldn't. You can find out more details on this page. Currently underway is con terra's annual FME Advent Calendar. Under each door is a different

i would like to get email from workbench when quick translator finish processing even if it fails or successes . i have tested and added the parameters in Emailer transformer and it send emails successfully . but i am not sure how to check the workbench if it successes or not before adding Emailer transformer . i have two output from my Workbench first output is excel file and the second is pdf file . Thanks in advance . FME 2018

error log: QUEUED: trigger success:

Hello, I want to split my citygml file into two by referring to a shape file which is an area.

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?