Transformers

Hi,I'm looking to see if I can retrieve all tables with the same prefix and then save the table content with a dynamic writer in shape format. For this I start with a SQLCreator with the query:select TABLE_NAME GV_TABLEfrom colswhere TABLE_NAME like 'AB$_%' escape '$'and TABLE_NAME in(   select object_name from user_objects where object_type = 'TABLE') The result is then picked up in a SQLExecutor:select *from @Value(GV_TABLE) Attributes to Expose is left empty in the SQLExecuter. The result of the SQLExecuter looks like empty records but if you look with Visual Preview the attributes per table are present. With a dynamic writer I try to write to a shape file per table. The writer does not write anything. So is it possible to make the attributes visible after the SQLexecuter? Attributeexposer does not have a *.* wildcard.

I am trying to read this wms-service/url using the featurereader (espg 3857): https://geoservices.knmi.nl/adaguc-server?DATASET=RADAR&SERVICE=WMS&&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&LAYERS=RAD_NL25_PCP_CM&WIDTH=1131&HEIGHT=489&CRS=EPSG%3A3857&BBOX=-199509.20245398767,6500000,1419509.2024539877,7200000&STYLES=radar%2Fnearest&FORMAT=image/png&TRANSPARENT=TRUE&&time=2022-01-05T14%3A40%3A00Z Somehow this gives me the wrong return, what's more: If I change the date/time the result stays the same, which should not happen Using the exact same url in the httpcaller and saving it as a .png gives me the proper result (but i dont want t

Hi, Is it possible to supress certain warnings in the translation log?For example, when i use a Oracle spatial reader with 2 or more geometry columns I use the parameter "Spatial Column : GEOMETRY1". In the translation log I get: Column `GEOMETRY1' of table `A_TEST' has been chosen to hold the geometry. I would like to remove such warnings in from the log.    

I am using the http-caller to upload attachments to a arcgis portal via the addAttachment in the Rest API. It works fine to upload but the image does not behave in the same way as when I make the post with postman. The attachment link in the portal downloads the image instead of showing it in the browser. This is not the case with Postman. Any help appreciated

Hey, I am trying to modify https://community.safe.com/s/article/data-distribution-fme-server-app the data distribution demo script. I am attempting to download 5 different shape files (points, polygons and lines) all with varying attributes. I have the script working and downloading with the exception of the attributes specific to each feature class. Every attribute is blown away. If I change the user attributes to automatic for the output feature class it sort of works except its merging all the attributes together and showing them in every feature class. Ideally I just want to download the 5 shapes and retain their unique attributes. Seems I can either output the shapes with no attributes or output the shapes with attributes from other feature classes m

Hello, Is there a way to automatically detect datatime fields from a reader reading many tables (at least 2k) and convert them to a different format?

Since our migration from FME Desktop+Server 2020 to the following versions, it is not possible to guarantee the order of execution for our readers. With the first reader and its transformer I want to download three zips. With the second reader I read those zips, extract them and export them to a database. With FME 2020 this worked fine. With FME 2021 and 2022 it seems that the reader order in the navigator pane is not recognized. Any idea? Thanks in advance!

The usage notes in ProjectWiseWSGConnector states:The FeatureReader can access ProjectWise directly (without using the ProjectWiseWSGConnector), however, a local copy of the dataset will not be created. But how is this done?  Thanks in advance.

I have an OS mastermap GML data file. I have multiple <osgb:changeHistory> tags for one particular featureID. Which is as below: <osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Modified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Reclassified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2002-08-12</osgb:changeDate><osgb:reasonForChange>Attributes</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2003-10-14</osgb:changeDate><osgb:reasonForChange>Position</osgb:reasonForChange></osgb:changeHistory> I am trying to read al

Hi,This isn't so much a question as pointing out a minor issue.The WorkspaceRunner transformer (FME 2022.1.2) doesn't allow the user to select an attribute value for the value of a parameter in the workspace to be called if that parameter is in a group:

From original source data, I already have created four corner points (in red) with correct XYZ values. I just need to connect these points and create polygons at vertical plane which will vertically intersect existing gray polygon at XY plane. Any suggestion ? Thanks.

could you please take a look at this question, if you have any idea how to solve it we are taking a picture every 5 m, we found some duplicated area taken more than once how could we keep all coverage without the duplicate point, the sample data show only a few features we are running this on millions of features thanks https://community.safe.com/s/feed/0D54Q00009ltB8eSAE 

Hey - I'm using a python caller to execute this script (shortened version of original script): --------------------------------------------------------------------------------------------------------- import fmeimport fmeobjectsclass FeatureProcessor(object):  def __init__(self):    self.Types = []    self.features = []       def input(self, feature):    if feature.getAttribute('_is_ftr_type'):      self.Types.append(feature.getAttribute('Feature_Type'))    else:      self.features.append(feature)       def close(self):    # Create and output a Schema Feature    schema = fmeobjects.FMEFeature()    schema.setAttribute('fme_schema_handling', 'schema_only') # indicates it's a schema feature    schema.setAttribute('fme_feature_type_name', 'MySchema') # schema definition name    sc

I have 3 counters in my workspace. And I want them to produce a single count. The documentation says : "When multiple Counters have the same name and Count Scope is Global, they produce a single count."  In my workspace the Scope of the Counter is set to Global but, I cannot figure it out how to write the same name for the three counters! When trying to write the same name for the counter transformers, FME (2021.1) automatically changes the names to Counter_2, Counter_3, Counter_X .... so I'm not getting a unique count for my workspace, what I have is three different counts starting from 0.  This is a basic question, Is the name of the transformer what I have to change to get a unique count? I'm sure I'm missing something and maybe someone can help me with this.  Thanks!

Hi there,I have a database containing a BUILDING table which is related to a BUILDING_FUNCTION table.A building can have 0-n functions associated to it (i.e. Schools, Public buildings, etc).But it's more complicated than that. The functions are timely (Origin, Intermediary, Present)And there are three levels of details in the functions (I-basic, II-medium, III-detail) Here is an example simplied dataset for only one building, number 14...I need to denormalize this table to get only one entry per building.Here is the desired result. Note that in INTERMEDIARY functions, there are two functions listed. This is due to the fact that the a building ca

Hello everyone, I have a question with regard to preserving the pattern style of hatches in DWG files.  I have a simple DWG file with two lines (blue), one text (yellow), a dimension (magenta), and a polygon (blue) which is filled with a hatch (cyan):  If I now simply read the DWG file with a REALDWG reader and do nothing but write it again with the REALDWG writer, the hatching pattern looks very different in the result - which is basically because the lines of the hatching pattern are much closer together than they were in the original DWG file:More details

I have a workspace with dozens of Readers & Writers that all point to the same database, all using the same connection. How to point all the relevant Feature Types to a single Reader/Writer definition, and then delete all the duplicates?(and then I'll need only one User Parameter!)  An output Feature Type let's me select which Writer to use, but input Feature Types have Reader field disabled. Why? How do I enable the UI control? 

We are wanting to check one feature service and one field in that service and whether it changed from "Sampled" to 3 other options. If it did change we want to send an email to let us know what the unique ids that did change. How would we use change detector to accomplish this task? We would like to schedule a task each night in FME server to send the email.

Issue: I can set the Alternative and retrieve data from that Smallworld alternative, but only once at a time.  Current work around: I have to clear the Alternative parameter, cache the Reader, and then re-enter the Alternative name and re-run the workspace. Potential cause: It seems to me like the Reader moves into the Alternative on the first run and then when I run it again it cannot find the Alternative because it is already in it. Which is why I need to cache it without a value in the Alternative parameter, effectively moving back out of that alternative. More details: In the smallworld environment I have moved into the alternative of interest ( mainly for testing ), do I need to stay in TOP?I am not writing back into Smallworld just reading out. Potential Fixes: I have tried messing around with 'Export Changes from baseline' but that does not seem to help.

Hi. I am trying to model some buildings' roofs in LoD2 using point clouds(las) and some shp files from arc gis, but I cannot find the right transformation. I have seen the sixth demo in this webinar, https://www.safe.com/webinars/gain-total-control-of-your-lidar-and-point-cloud-data/but they are just roofs in LoD1.Can someone help me how to do that?Many thanks

I'm trying to write hierarchical XFM-elements, one parent with all the xml data, and two graphical child elements (a point and a text). This is the warning I get on every parent element:DESIGN WRITER: Feature found with igds_type of 'igds_xfmstore', that has unsupported 'Topology' information. Skipping XFM feature store element write Because of this, all parent elements are skipped.What is this 'Topology information'?

I am trying to create a pdf file using the straight line diagram. I have a data file with the Road reseals as lines and I would like to be able to show the distance or length of the Reseal, the Year Applied, and stone size as a stacked straight line chart. This will then show the overlaps as well. Many years ago we used to do the very same thing on paper, in a book, by hand so we could see the surfaces applied to the roads over time. I am currently reviewing or trying to, do some analysis and update what we had on paper into a modern approach. I have watched the video of it being used here https://www.youtube.com/watch?v=2tPhZMSrnYw at the end of the webinar but I am struggling to sort it out given it was a very short session at the end. I would like some more specifics or how to on setting it up, or even a sample workspace may be the one from the demo would be a good example to follow.

Hello,  I try to read the attribute"IFCPROPERTYSINGLEVALUE" with FME. Unfortunately this does not work,in the "list builder" I can see the attribute "IdentityData.Assembly Code" only it is empty. While in the data with GlobalId"0q2mDI5en2pRRKYDPxu88G" it does have an attribute. How can I make this data visible withina workbench so that it can be filtered.  I added the .ifc as a text file, thereis already some described on the forum of how to read the"IFCPROPERTYSINGLEVALUE" only I didnt get it working. 

Hello FME community, I have loaded a text file as CSV into the workflow so that a table is created.This then looks like this:I need a process that can work independently of the number of attributes but according to a pattern. Therefore I have converted these attributes into a list. Here is an excerpt from it: (fme_basename: 102)_list{0}.col2   892_list{0}.col3   1448_list{0}.col4   48_list{0}.col5   70_list{0}.col6   874_list{0}.col7   1628_list{0}.col8   50_list{0}.col9   78 The pattern looks like this:col2 and col6 belong in one attribute (x)col3 and col7 belong in one attribute (y)col4 and col8 belong in one attribute (dx)col5 and col9 belong in one attribute (dy) So every 4th element belongs t

Hi,I'm using a FeatureMerger to check that two files contain the same features based on their attributes.Apparently, they don't seem to contain the same features although I thought they would. I must be missing something in the data. That's allright, FME's there to help me isn't it :)But strangely, the features which are not merged are not output by the UnmergedRequestor port of FeatureMerger. Isn't that weird ?