FME Form

Hi, In the FME basic training I am trying to create a PostGIS connection for Exercise 4 'FME Hackathon' (page 430).The Hackathon PostGIS Database should be located at postgis.train.safe.com, but I cannot get a connect with it using the given parameters (below). I followed the steps Tools -> Database Connections -> Add Database Connection.Host: postgis.train.safe.com Port: 5432 Database: fmedata Username: fmedataIn the log window the following error appears:Error connecting to PostgreSQL database(host='postgis.train.safe.com', port='5432', dbname='fmedata', user='fmedata', password='***'): 'server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.'Isn't the server online or am I doing something wrong?My version is: FME Workbench 2017.1Thanks,Koen

Why does featurewriter hang when I import featuretype from dataset? Is this a bug?  FME Flow Version: FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64)Windows Version: Windows 10 Pro for Workstations (Build 19045.3693) I add a FeatureWriter to the canvas.I open its configuration dialog.I set the format as Microsoft SQL Server Non-SpatialI set the connection one of the Database Connections I have saved in FME.I click the drop down menu below the Feature Types input port list and select Import from Dataset...I select the table from the dialogs.The table attributes are loaded and the table shows up in the Feature Types input port list.I close the dialog and the FeatureWriter transform is now not accessible and immovable. I am able add other transformers, readers, and writers, but if I resize the Flow window, the window panes do not resize with the window.

I have a report coming out of an out-of-the-box Vertigis Studio workflow that is written out as multiple excel files. Each has the title Results (number) e.g. Results (1), Results (2). (The dataset name is exposed as the tab name, for some reason and not the file name). If I were reading a group of spreadsheets with the same structure, I would just set the reader to read *.xlsxw, and it would be non problem. However - here I have differing attribute schemas.  The datasets called by each report vary depending on a spatial interaction, but come from a finite list of possibilities. And as I say, the attribute schemas can vary.  I need to read all files of the output, expose attributes and write out into a single excel sheet, fanned out by dataset (presumably using the FME basename - is it possible to grab the tab title instead?) I have done the reading thus far using a Reader set as pic attached ...however, this isn't dynamic. Moreover, this workspace needs to be usable by a relativ

Hi everyone, If I want to change a numeric value of an attribute, I tend to use the ExpressionEvaluator. I kind of see it as the 'transformer equivalent' of the Arithmetic Editor. Is there a 'transformer equivalent' of the Text Editor as well? I guess there is the StringReplacer, StringConcatenator, AttributeManager, etc., but which one would be the best/most efficient to use? And speaking of efficiency, I have another question regarding transformers. A colleague of mine told me a while ago that, for debugging's sake, it is wiser to use e.g. an AttributeCreator, AttributeRenamer and AttributeKeeper in series instead of using a single AttributeManager to perform all those tasks in one go. I tend to agree with them on that, but does this also have any consequences for performance? I can imagine the difference being minimal, but best practices and all that. Thanks in advance!

I've always had a hard time with XMLUpdater, but it usually ends up working. This time I just can't make sense of the errors and how to solve it. I have two XML, I want to take elements from one of them and use those elements to replace the elements in the other XML.  If I take the exact text from the XML-fragmenter at create an attribute containing just that, the XMLUpdater accepts it and produces the expected result.If the XMLUpdater is part of the same flowpath as the XMLFragmenter the XMLUpdater will throw an error.I even tried putting it into a new attribute with different datatype. Can that be right?? The attached workspace is made in FME 2023.2 but the error is the same in FME 2022.2.Any help or ideas is appreciated.

Hi.I haven't really used XML Updater before, but is now tasked with trying to update certain sub-elements i a large hierarchy. I'm trying to update QGIS project files (QGS).I've extracted the needed replacement tag with content, and routes them in via the "update" connector. But I'm stumped wrt. how it's set up correctly.My XPath is set to be this: //field[@name=fme:get-attribute("fieldname")]/editWidgetThis is the location of the tags I want to update (replace) in the source XML file.But it doesn't replace anything, and it errs with this somewhat cryptic message in the log:XMLUpdater(XQueryFactory2): The following error occurred while executing query number 1:XMLUpdater(XQueryFactory2): The following error occurred near line 2, column 26 of the query:XMLUpdater(XQueryFactory2): invalid expression: syntax error, unexpected "type"My replacement XML tag looks like this (example):<editWidget type="TextEdit">            <config>              <Option type="Map">           

I'm using Python Caller with the module ifcopenshell to validate properties and naming of Ifc entities.To do this im also using an excel file that lists the requirements, and the script is now dynamically creating attributes based on the excel file. My challenge is that i want to write a excel file with the results, but i dont want to manually decide wich attributes to expose so the reader can access them.Is it even possible?

I have been working with the following workflow:Bufferer to buffer the buildings with 50 meterClipper to clip the vegetation to the buffersSpatial filter where "BuildingBuffers OGC-Contains Vegetation". The vegetation is the candidate.Area calculator of the resulting areasStatistic Calculator to sum the calculated vegetation area for each building ID. The result is missing data for many of the building buffers. I think one problem is that the vegetetad areas only are counted once, while in reality they can be included in many of the building buffers. Do you have any advice? 

I have points contained by polygons. I want to buffer these with a spesific buffer of 2500 square meters. And I want these buffers to not cross or expand outside of the polygon. I need apply this to a lot of points with a single operation.The polygons look like this (there are hundreds in the project), and you can see the points inside:This is how I want it to look (the shape of the buffer is customized to the polygon): I got some help help here previously: Buffer/expand point contained inside another polygonBut this method does not work on irregular polygons. It only works on squares.

I'm have the following error:An error occurred while attempting to open an insert cursor on the table 'SurveyedGeneralLawn'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [GisGeoDbMaint.ASSET.SurveyedGeneralLawn]}It seems to be with a relationship class with attachment TABLE. When i remove the relationship it work fine. I only want to insert records into the feature class and the attachment table. I using an Arcpy truncate function as a startup script.I've looked at previous post regarding this matter, but it don't seem to work for me.Using FME 2014 - SP4Rudy

I have already included the network network utility package xsd file from github and followed the import instructions but now I do not know how to map the shapefiles to this network utility ADE in FME. The ultimate goal is to include this heating network system in my citygml model in cesium (3D tiles). Currently the cityGML is without the heating system

I have two seperate features classes - holes and polygons. I simply want to merge them with disolve by grouping by a certain id. However output has lines at the border of the holes. How can i get rid of them? Holes are brown and Polygons are pink in the picsAfter dissolve This is before dissolve

Hi All, I'm working on a workflow to identify if lines are perpendicular and running in parallel. Below screenshots shows what I'm trying to achieve: Line A and B should run in parallel and have the same YLine A should have the X for start/end to be perpendicularLine B should have the X for start/end to be perpendicular  I have put this workflow together and create a QA tool to flag the issues (not perpendicular and not parallel) but can't find the workaround: Any idea how to get this done? Thanks 🙂

Hi All, I'm running a workbench that worked fine in my last FME ('22 now running '23) on the same files. These are the errors I'm getting below - I'm thinking this could be something with the new FME and coordinate systems?  Any thoughts are appreciated. Feature Caching is ONThe workspace may run slower because features are being output and recorded on all output ports regardless of whether or not there is a connection.AutoCAD Reader: Failed to retrieve or apply texture for mesh entity. Texture must be file based with a valid path. The texture information will be skipped... Last line repeated 9 times ...Further instances of this message will be suppressedAutoCAD Reader: Failed to retrieve or apply texture for mesh entity. Texture must be file based with a valid path. The texture information will be skipped... Last line repeated 9 times ...Further instances of this message will be suppressedAutoCAD Reader: Failed to locate or read world file. Geometric attributes wil

Hi All, I'm putting a workflow together to help me QA some data and the final output will be an excel file with some fields as info, Below an example of the desired output which the header is bigger thna the normal rows and the QA QC field says pass in green and fail in red: Is this possible using the ExcelStyler or need to use the FeatureWriter? Thanks 🙂

I am sending this date, Oct-23, through the DateTimeConverter. I have set t he input format as %b-%y2099. The DateTimeConverter is failing to parse the date with the message "Attribute(string: UTF-8)         : `fme_expression_warnings{0}.message' has value `Failed to evaluate expression '@DateTimeParse(Oct-23,%b-%y2099,repair)'. Result is set to null'". What am I doing wrong? I have attached a sample project that demonstrates the failure.My FME Form version is FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64). https://docs.safe.com/fme/2023.1/html/FME-Form-Documentation/FME-Transformers/!Transformer_Parameters/Date-Time-Functions.htm#Format

Hi how can I include the following api curl post in an http caller? curl -X 'POST' \\ 'https://<a domain>/upload' \\ -H 'accept: text/html' \\ -H 'Authorization: Bearer <a password>' \\ -H 'Content-Type: multipart/form-data' \\ -F 'filter=<a textstring>' \\ -F 'file=@<a filename>' \\ -F 'adddata=false' \\ -F 'type='  

Hello I'm currently transforming a GeoTiff in a point raster using centerpointreplacer. I have a grid of points every 100m.The next step is to add 8 attributes for the 8 neighbours (or less if the point is on a border) and in each attribute set the slope from this point to the neighbor [in %].I have z values for each point, I don't know how to get the distance between 2 points and how to add the attributes according to the neighbors.Maximum distance for neighbors: @sqrt($(Resolution)^2 + $(Resolution)^2) * 1.1  Thanks,Antoine

The second image represents the two input layers. It is possible to see that there are shifts between the layers. Following the AreaOnAreaOverlayer (fig. 2), “intermediate” polygons are created. I performed a TestFilter to identify polygons <= 1. Now, I would like to dissolve polygons less than or equal to 1 on the rest of the polygons according to a specific attribute (OBJECTID_CAD). Indeed, I would like to respect as much as possible the geometry of one of the two layers (which was created by surveyors).

Hi  I am setting up a job to update data in AGOL using FME Desktop 2020.2.3 I am aiming to have a single job which I will publish to our FME Server to refresh the data on schedule.  I have multiple Feature Services to update and am hoping to use a single Feature Writer to update them.  In my workspace I generate the Service ID and am passing through to the Feature Writer Feature Service constraint parameter. This works successfully when the Feature Writer only updates a single Feature Service however when I try multiple it cannot find the Feature Service, it seems to still connect to the first. The log shows that it maintains a connection to the first Feature Service and does not switch to the second. Are there any issues with this methodology? Suggestions for alternatives? Thanks

I have a column of health conditions for individual patients.Often patients have multiple health conditions. If they have more than one, then the conditions are seperated by a ; (Some patients have up to 5 separate conditions)I need to find out how often individual health conditions feature. ie how many times is "Arthritis" listed as one of the health conditions? I've used the Attribute Splitter, using the ; as the delimiter. This creates a list of the health conditions, I've named the list "Health_Conditions". I now want to find out the number of times each health condition appears in the list / exposed values of the list. ie how many times does eg "Arthritis" appear? And how many times does "Diabetes" appear?  Note: From the screen shots below you can see health conditions can appear in any of the exposed value lists{} I've tried Statistics Calculator, Counter, ListHistogrammer but can't get the result I am looking for. Many tha

Hi,I would like to be able to read the name of the layers from AGOL that are shared with the same group. ArcGISOnlineConnector reads only the genaral name.

Hi,When using a 'File/Folder/URL' public parameter inside a GroupBox with Conditional Visibility of the user parameters, it doesn't seem to enable file upload within a published FlowApp. When you're editing the Workspace App in Flow the expected behaviour is working with a display window which allows you to upload a file. Also when running the workspace in Flow it works. Only doesn't work in a published app. Is this a known issue of FME Flow 2023.1.2 and Form 2023.1.2.0?Previous post and reply by Kelvin Jenkins seem to highlight this. Thanks.

Hi I need to reproject from EPSG 7791 to wgs84 but I received an error I use data interoperabilit 3.2 with reprojector engine ESRI can you help please ? thx Francesco   

I have a bunch of attributes that I want outputted into a list on a pdf. What's the way to achieve this? Somewhat stumped. Thanks!