Transformers

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 can have more than one set of functions for each timely period. In the example above, where the TIME attribute has "2 Intermediary", you have two sets of basic-medium-detail FUNCTION_LEVEL. I'm joining an excel spreadsheet as sample data. Thanks a ton in advance for your help ! PS. This is somewhat related to my previous post but the added c

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 below. Does anyone know how I need to parameterize reader and/or writer such that the pattern style of the hatch is preserved 1:1? In the REALDWG reader, I already linked the read-in DWG file as a "Template File". This helped to preserve the styling of the dimension but unfortunately not with regard to the pattern style of the hatch. Here some more details: Regarding the parameterization of the REALDWG reader, I only unchecked the "

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. This is a great tool as it can be used for many other things like Pavement, Road Construction by yea

Hello, I try to read the attribute "IFCPROPERTYSINGLEVALUE" with FME. Unfortunately this does not work, in the "list builder" I can see the attribute "Identity Data.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 within a workbench so that it can be filtered. I added the .ifc as a text file, there is 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 to the same attribute. I would like to change the list so that the index can be set according to the pattern. This would then have to look like this: _list{0}.col2 892 _list{1}.col3 1448 _list{2}.col4 48 _list{3}.col5 70 _list{0}.col6 874 _list{1}.col7 1628 _list{2}.col8 50 _list{3}.col9 78 Then

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 ?

Hello, I need more input/ information on what are all the scenarios I can use the below rest api call ? POST /transformations/transactdata/< repository >/< workspace > Query-based job transformation submitter (synchronous Also, the input here is a file and The 'application/octet-stream' type is used . So, may I know what type of input file should I use ? Will this API call convert my any input file into a streamed data and pass it to a workbench ? Thanks.

I'm new to FME and the Vmap/VPF format, And I would like to now how to convert an ESRI shapefile, obstacles (points with attribute height), to the VPF format. Is there someone who can guide me?

What is the best solution to transfer files from IFC format that have a geo-reference as shown in the picture to KML, bearing in mind that I kept the same geographical reference? Thanks for the help.

Hi all, I have roof shapes which I transform to fme_composite_surface (GeometryCoercer). Now I will use BRepSolidBoundaryCreator.Beta to create ground and walls. It works for a single building. Unfortunatley if I use a bigger area the transformer stopped by saying: BRepSolidBoundaryCreator.Beta_2_DonutBuilder_<Rejected> (TeeFactory): BRepSolidBoundaryCreator.Beta_2_DonutBuilder_<Rejected>: Termination Message: 'Element BRepSolidBoundaryCreator.Beta_DonutBuilder gibt ein <Rejected>-Feature aus. Um mit der Umsetzung fortzufahren, wenn Features abgewiesen werden, ändern Sie 'Workspace-Parameter' > Umsetzung > 'Behandlung abgewiesener Features' in 'Umsetzung fortsetzen'' What is going on here? Are donut polygons not working? Inside Transformer BRepSolidBoundaryCreator_Beta error comes from DonutBuilder: INVALID_GEOMETRY_DEGENERATE How can I avoid this?

Hi all, we are using the transformer BRepSolidBoundaryCreator.Beta to create buildings based on 3D roof shapes. For most of the buildings it works fine but we found some buildings with strange results. For example: We have this roof shape as input: The roof polygons have adjacent roof polygons that directly connect (lower left corner). Because of this we have 5 nodes First step is to create faces so we can use it later for the transformer. Result roof shape after creating faces: We have 3 Faces. After using the BRepSolidBoundaryCreator.Beta we have this result: The result of the walls are not correct. We have duplicate wall surface. The transformer should take the roof polygon (input) an should create a vertical sidewall surface that bridges between the boundaries of the planar surface and the source surface. Why does it turn multiple wall surfaces? Is it because we have three faces? Is there a way to create only the outer wall? Or do I have to manipulate the input polygon that I only

Is it possible to loop in FME? I want to connect a transformer back to the previous transformer in a particular condition.

I am not that familiar with the SQLexecutor, but I was wondering something. When I am running the SQLexecutor, I don't get any feedback, so therefore I was wondering if I can get some kind of feedback mechanism that the database operations have occurred succesfully or not

I have two polygons which overlaps and I use transformers to have the intersection (I tried Clipper, AreaOnareaoverlayer, spatialrelator and intersection) . So, it created a new polygon (the overlap of the two polygon.) The problem is that this new polygon belongs (in the attribute table) to one of the two polygon (The feature name of the new polygon is the name of one of the polygon) but I would like the name of the both polygon even if it created two overlap (the same but one with the name of the first polygon and one witch the second). Thanks you

Hi, I have to transform a series of points to a line consisting of cubic Bezier curves. I couldn't find a function to do that in existing transformers or the Python API of FME Objects. The Generalizer (NURBfit algotirhm) creates a spline curve, but it's not exact cubic Bezier curves. The expected line has to pass through the both ends of each 3 segments. So, I wrote the following script. Is this the "re-invention of the wheel"? If you know an existing function (transformer or Python function) that creates cubic Bezier curves based on control points, please let me know. ----- import fmeobjects class CubicBezierCurveReplacer(object): def __init__(self): self.set_coefficients(32) def set_coefficients(self, n): self.n = n r = 1.0 / float(self.n) s = range(0, self.n) self.k0 = [(1.0 - (r * m))**3 for m in s] self.k1 = [3.0 * (r * m) * (1.0 - r * m)**2 for m in s] self.k2 = [3.0 * (1.0 - (r * m)) * (r * m)**2 for m in s] self.k3 = [(r * m)**3 for m in s] def bezier_coords(self, p): coords =

is there any Geometry smoothing function in FME needs polygons edges smooth

Hello, I have some polygons which overlaps and every polygon is a feature I succeeded to have in attributes the name of polygons which intersect the feature (the 1st polygon). Now, I would like to know how can I have the name of the polygon which intersects the most the first polygon. Thank you!

Hi everyone, I have a XML question. I got an XML structure from filegdb_polygon via GeometryExtractor (GML 3.2.1) and XMLFragmenter: <gml:Surface gml:id="ID_1" srsName="MysrsName" srsDimension="2"><gml:patches><gml:PolygonPatch><gml:exterior><gml:LinearRing><gml:posList>"list of xy coordinates"</gml:posList></gml:LinearRing></gml:exterior></gml:PolygonPatch></gml:patches></gml:Surface> However, my XML structure should look like this: <gml:MultiSurface srsName="MysrsName" gml:id="ID_1"> <gml:surfaceMember> <gml:Polygon srsName="MysrsName" gml:id="ID_2"> <gml:exterior> <gml:LinearRing> <gml:posList srsDimension="2" count="####">"list of xy coordinates"</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </gml:surfaceMember></gml:MultiSurface> I used XMLUpdater to delete the attribute /gml:Surface/@srsDimension and to rename the following elements (Plain Text) : //gml:Surface -> gml:MultiSurface//gml:patches -> gml:surfaceMember//gml:PolygonPatch -> gml:Polygon But how to creat

Sorry, I'm new to FME and don't know which transformer to use. I am working on an FME project that is currently getting an XML response using an HTTPCaller. The Output of the HTTPCaller has many "attributes" and then the Output is passed to an XML Fragmenter. The XML Fragmenter output is the same but has one new attribute pulled from the XML response. It then is passed to an XMLQueryExtractor which then adds another attribute. I need to get the value of a tag and I'm wondering if I should add an XML Flattener or Fragmenter or perform this in the XML Query Extractor or some other transformer. an example of what I need is the value in <sub3> in the following XML example and save it to a variable for later use. <Root><sub1><sub2><sub3>value</sub3></sub2></sub1></root> Thank you

I am trying to clip a point cloud using the values of a csv using the reader, but the PointCloudFilter transformer does not accept the @Value() field. I am at a loss now. Any help would be great.