Transformers

I have several IFC files, each one has its own structure.I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types. I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume) is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ? example of such data:GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((....some also have PolygonZ , some have POLYHEDRALSURFACE Z   

Hello everyone, is there any way how to write custom file properties (metadata) to Sharepoint, please? Thanks a lotLubo

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

In a same dataset I have two columns that I want in a same column. How can I do that ? Thanks

For example, as you see on the screen, I would like an only feature for Roda (and Mira too) in a first column and all the color in another column . Here, I have many line for Roda and Mira, I would like an only. How I can do that ? Thanks!

Hi, Im trying to write a scripted parameter to allow only specified EPSG codes from the CsmapReprojector and apply the correct transformation . Based on a chosen source and destination CRS selected by the user a certain transformation is applied. This works fine, except when I try to use the <Auto> parameter. According to the documentation I should "Use the alternative blank string and NULL_FME respectively when passing in as an attribute." Unfortunately when I use "" as blank string in my script, the workspace fails because "Parameter 'TRANSFORMATION' must be given a value."  So how do I pass a "blank string" that triggers the automatic transformation in CsmapReprojector? My script looks something like this:  import fme if fme.macroValues['SOURCE_CRS'] == 'EPSG:25833' and fme.macroValues['DEST_CRS'] == 'EPSG:31468':  return 'DHDN_t

Hello, I am in the process of developing a 3D noise model using FME to process the geospatial datasets ready to convert into noise modelling files. As part of this process, after having draped road centrelines to make them 3D, I need to then generate an elevation surface from the 3D road centreline geometries that will be used to drape bridges and breaklines so that their elevations align (there is a reason why we want to do this rather than draping bridge and breaklines to DTM/DSM which I can explain if required).  Appreciate any advice on how best to approach this?

Hello,I'm currently having a problem with my PostgreSQL and Postgis writers.When the feature operation is set to "INSERT", the INSERT is perform on all columns of the table instead of just the columns that are specified in the attribute definition.It result in empty data on columns that arn't defined in the feature attributes but have a default value in the DB. For exemple :I have a table with 4 columns (column_1, column_2, column_3, column_4).The column_3 have a default value ('my_default') In my script, I have a feature to INSERT some data into this table. This feature have an automatic attribute definition (to avoid defining every new column each time I modify my script).But my customer havn't any data for the column_3 and the column_4.So, the feature in FME have only column_1 and column_2 defined in it's attribute definition (beacause I chose the automatic definition option).After I

I have no problem adding the WMS reader to the canvas (selecting layers etc.), but as soon as I try to read the data I get an error: '<WMS> Exception detected for the GetMap operation, requested Content-Type, 'image/jpeg', returned Content-Type, 'application/xml'.' This is the WMS creating the error: https://service.pdok.nl/hwh/luchtfotocir/wms/v1_0?request=GetCapabilities&service=wms The layer is '2020_ortho25IR'. Does anyone know what is creating this error? Thanks. FME desktop 2021.2, W10 

hi everyone,I will give some background information beforehand. I have one dgn file that consists of many models (each model does represent a floor of a building) and the dgn file consists roughly of 1.5 million features (yeah, that's a lot for one building). The idea of my current script is that at first the dgn file is read, some transformation steps take place and finally each floor will be written to a seperate dxf file. So far so good, since each floor/model needs to exported to a sepereate dxf file. However, after some time only a few adjustments are to be made (e.g to only one floor and thus only one model is adjusted in the whole dgn file. Therefore I would need to run the script to overwrite the output of that specific model/floor since changes have occured.  I would like to know if there is a possibility of reading the dgn file and only taking the features of that one model that has changed

I have some 3D Data with existing appearances - I just want to make a few of them brighter. I can use the AppearanceExtractor to get the unique appearances, and I can see that with the ApprearanceSetter I can apply one based on a trait I can also see that it's possible to just update an existing appearance. I just can't figure out how to just update it based on the appearance name as this doesn't seem to be a trait For some reason I can't figure out how to do this - has anyone achieved this?

Apologies for asking what I expect is going to be a very basic question. However I would like to read all files of a particular format (eg dxf) in a folder, apply a coordinate reprojection to them and then output them to a different folder. To read the files from a particular folder I believe I would use the Directory and File Pathnames Reader? To apply the reprojection transformation I would use the csmapreprojector, however to write the many files (eg dxf) out to a different folder I am not 100% of the methodology (and or writer) for that.Many thanks in advance

Hello, Im working with this WMS:https://service.pdok.nl/kadaster/netcapaciteit/wms/v1_0? When I access it with a feature reader then it gives me these layers here:And when ran it just gives me a white area cover of where the data is in the world (right place and all, just no symbols). I am accessing the same data in ArcGIS Pro and there I can query "IndicatiefVerzorgingsgebied" based on symbology and see that it has some 8 sublayers: So my questions are:How can I query and expose these sublayers in FME and make them appear as something

nID='1' nOperTime='2022-07-31 23:51:56' szUserName='default' EventType='Save Config' Remarks='Saved -P2P- config.IP:Local LoginUsername:default Group Name:user' I want to split this into nID, nOperTime, szUserName and EventType I've tried using the KeyValueAttributeCreator transformer to do this with:- Key,Value Delimiter: =Key,Value Separator: <a single space> After this runs I see thousands of columns created with name 1,2,3,4... which appear to be the value of nID rather than the key. I wonder if the issue is the quotes and if so is there a solution that will see quoted fields as a single value?

I am fairly new to FME and am having a tremendous issue with attempting to transpose columns into rows. I have tried the other fixes to transposing rows to columns but to no avail. Here is the sample sheet I am trying to transpose. And under the inspector it tabulates into thisThe issue is that I am wanting to combine the rows of A and C into columns and having rows B and ROM status falling underneath these columns stated above. Columns E, F, and G are not needed. I have tried using the transposer transformer as well as attribute pivoter with an aggregator but does not work. Any help would be greatly appreciated, and will answer anything I did not clarify.

come si esegue un INTERSECT tra un vettore polygon ed un vettore point?

When running workspaces pre 2022 in FME 2022.'GeometryFilter' sorts out Points, Areas and <Unfiltered>, when I send them into GeometryFilter_4 the <unfiltered> features exit through the Area-port. 

Hello FME enthusiasts, I am slowly getting better within FME – but now and then I simply get stuck. In my example, I load a simple .xlsx File with a borehole identifier (BID) and a complementing link to its online available drilling profile (URL). The goal is to extract the profile for each BID via ImageFetcher and to write it into a single .pdf File via the fanout option. Works great so far, but I just cannot figure out how to provide the BID as additional information (here: headline directly in each .pdf) via the PDFPageFormatter. Whatever I do, only the fetched raster image is written as .pdf File. This is more a general question, as more information could be added to the .pdf File (e. g. date and time of image extraction). Please see my attached FME template file. I am quite sure the solution is simple, but I need some help/hints. Thank you in advance! Ki

See below my Workspace to generate a CSV file from a SQL View:The CSV looks good except I need to put double quotes (“ “) for certain text strings. For example under Ledger Type column, AA should be ‘AA’.Please let me know which of the String Function(s) in AttributeManager I should use to put double quotes around text strings (or other Transformer you deem more efficient):Also, how can I replace all the comma separators in the CSV file with pipes character ’|’ instead.Many thanks!

Hi All,Question regarding using Esri Template Geodatabase and Change Detection. Or anytime using Templates in writers really. When using a Esri Template Geodatabase and selecting "Overwrite Existing Geodatabase" does this process actually Delete Existing Geodatabase and Replace with a New Geodatabase that includes whatever magical newly transformed output was created up to that point in the workspace?Example Scenario: When detecting changes between two Geodatabases a set of "changes" is produced and then we write that out to an existing geodatabase with same schema. To set this up we tell the writer the destination gdb and also identify a Template Geodatabase and select "overwrite existing geodatabase". In this case does the write delete the gdb and reassemble with existing data and applied changes from source?or SourceDB>>UPDATES>>[CreateNEWDestinationDB]>>ApplyUPDATEStoNEWDestinationDB>>[DeleteExist

I think the current messaging set up for each case could do with some improvements as well that would optimize both the user's and experts' experience and increase overall efficiency. An example would be an easily found "Reply" button at the top of messages sent from FME experts. I honestly think that FME has one of the best user support systems in the bizz and I usually don't submit too many suggestion cases for other software because of the headaches their systems usually cause. However, because of how responsive/active your team is, and how much they've helped me personally with many issues in the past while being a great experience almost every time, anywhere I can help improve an already great system, I'm game. :)

Hello. I need to calculate the distance in metres from a set of points to a singlehotspot location, but have it calculate the shortest distance along a line roadnetwork (to the hotspot). I have three datasets: Table 1: several 'home' locations (points)Table 2: one hotspot 'destination' location (point) Table 3: a road network (lines) The road network layer does not contains things like no left turn, one-way, pathways, best avoided roads, dead-ends etc. etc. That's absolutely fine, as I just need a crude distance along the network.  Also, the home locations may or may not be on the network, so I may need to introduce a tolerance for where a point doesn’t snap to a network line. I need the shortest distance added to table 1 as a new column in metres. I’ve looked at ShortestPathFinder and LengthToPointCalculator but they don’t seem appropriate. 

Hi, I have a street network of 3D polygons and the set is not 100% topologically correct. There may be small gaps or overlaps between consecutive road polygons. And normally two consecutive polygons should share the same set of vertices at their junction (materialized by the line separating 2 adjacent polygons).  This would be very easy to solve in 2D using transformers such as the Snapper, AreaOnAreaOverlayer, AreaGapAndOverlapCleaner or TopologyBuilder . But these transformers seem to support 2D only and as a result will not take the z information which is stored in each polygon vertex coordinate. Roads crossing at different z value (bigger than a tolerance of x meters) should not obey to the same rules as those roads which are consecutive.Do you see a possible solution using FME? I was thinking about classifying polygons according

Hi,New in XML transformers, I'd like to know in FME Desktop 2022 how can I read and parse data contained on this XML: <SOAP-ENV:Envelope><SOAP-ENV:Body><ns1:GetSiteValuesResponse><ns1:siteValues><ns1:siteRAIId>1558</ns1:siteRAIId><ns1:x>144.882271794492</ns1:x><ns1:y>-37.825548770183602</ns1:y><ns1:enabled>true</ns1:enabled><ns1:reportedTime>2022-07-26T23:58:04.878</ns1:reportedTime><ns1:currentValues><ns1:laneNumber>1</ns1:laneNumber><ns1:panelValue>Blank</ns1:panelValue><ns1:annulusFlashing>false</ns1:annulusFlashing></ns1:currentValues><ns1:currentValues><ns1:laneNumber>2</ns1:laneNumber><ns1:panelValue>Blank</ns1:panelValue><ns1:annulusFlashing>false</ns1:annulusFlashing>&l