Transformers

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 run the script, the result I'm expecting is this one :column_1column_2column_3column_4data1.1data1.2

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 within a certain time. This might reduce the computing time of the script treme

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 else than a white area coverage? And bonuspoints if there are any ideas how to expose the feature specific attribute values as well, such as station, netbeheerder, status, totalecap... and so forth

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! Kind RegardsAlexander

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>>[DeleteExistingDestinationDB]I know that is

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. Many thanks, 

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 to their distinct heights, also cutting polygons with more than 1 z value into 2 parts, and then running the AreaGapAndOverlapCleaner on them with the Gro

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></ns1:currentValues><ns1:currentValues><ns1:laneNumber>3</ns1:laneNumber><ns1:panelValue>Blank</ns1:panelValu

I have a workspace that writes a simple CSV file a little over 10 MB in size using a FeatureWriter. I then use an Emailer to send the file to myself but receive a 'Message size exceeds limit' error. (Error wording is - Emailer: SMTPSenderRefused: Could not complete request. Message: (552, b'5.3.4 Message size exceeds fixed limit', 'myemail@company.com')) Is this limit imposed by the Emailer transformer itself? I can email the file to myself as an attachment manually without issue so I don't think it's our company email server. Wondering how I can overcome this issue. Running FME Desktop 2020.1.2.1 (Build 20624). Thanks, Aaron

Hello, I've got an FME workspace which uses the LineBuilder then aggregates the lines using the Aggregator which grouping the line features into aggregates grouping by an attribute. However, I'm getting the following error message:FileGDB Writer: Failed to write Geometry to feature class 'BUS_ROUTE' with geometry type 'esriGeometryPolyline'. Dropping containing feature.I've tried using GeometryCoercer after the Aggregator but this doesn't work as the GeometryCoercer cannot coerce IFMEAggregate features into lines. Any help would be much appreciated, thank you.

For exemple, I would like to have "This feature A overlaps 5% of the feature B" and "The feature B overlaps 30% of the feature A" (I have one dataset) For now, I used "AreaOnAreaOverLayer" to have overlaps. Then, I calculated the area of the overlaps and the features to know what part of the feature the overlap represents. However, at the end, I have for a feature the percentage that represents the overlap compared to one feature, but I haven't the other feature. I only have " Field 1: Feature A / Field 2: 80%" . That's allI want another field that tell me the name of the other feature. Thank you for helping   

Hi, I've downloaded a json file that contains geometries defined as an array of coordinates. A portion of this json file is described below. One json feature can have one or more geometries. I can't find the proper way to parse this json file and transform this array of coordinates to a polygon. Do you have any solution ?  Thanks for your help.{ "identifier" : "2", "country" : "REU", "name" : "[FM][D 2] La grande montée/Plaine des cafres", "type" : "COMMON", "restriction" : "PROHIBITED", "restrictionConditions" : "", "region" : 931, "reason" : [ "OTHER" ], "otherReasonInfo" : "Zone dangereuse", "regulationExemption" : "", "uSpaceClass" : "", "message" : "Vols interdits sauf lorsque la publication d'information aéronautique l'autorise explicitement ou avec l'accord du gestionnaire de la zone lorsqu'il est désigné par l'information aéronautique", "applicability" : [], "zoneAuthority" : [ { "name" : "Autorité mentionnée en ENR 5.1 de l’AIP", "service

Hello!  I am generating a few TIN surfaces which i want to use in Unreal Engine. This means that i will need to generate a UVmap to be able to texture it in engine.  My current setup looks like this: (Ignore my Apperance setting and image rasterizer, i was trying to see if generating a georeferenced texture would work in the appearance setter.). My TIN surface is far away from Origin, so what i am doing is removing the xmin and ymin extracted in the bounds extrator for the offset in the texture coordinate setter. I have tried to do the same thing for the appearance setter aswell.  It seems to generate a UVmap, but the UV is VERY offset in regards to where i need it to be. the scale is correct though.  This is how my UV looks in 3Ds max, its the correct size, but WAY offset.  As you can see below, the size is correct if i manually move the UV down to the 1:1 UV.   Moving this manually for every tinsurface i generate is both nonexact aswell as timewise impossible. Do you have any tips?

HI EVERYONE, I have a problem where I need to update ENERGY ADE using FME workbench but there is nothing appeared, I would like to ask, is it any of you have been work with it? I really need the helps since this is my final project.

I have a field with a code (number) and I would like to know if a feature haven't a number code in her line (maybe a message like "error" or other but with letters). Thanks for helping