FME Form

Hello,FME throws an error when I want to write to a PostgreSQL table that contains a generated column (value calculated from another column). Message: generated columns cannot be used in COPYIs there any way to ignore this column (by clearing the column from the writer, the error still occurs) or work around this problem?Thanks for your help

I have workspaces authored in FME2018 that use informix spatial readers. In 2018 I am able to set a WHERE clause within the FeatureReader. In version 2021.1 I can no longer do this as the WHERE clause option is greyed out.Is this a known bug or intended behaviour?

Hello dear FME users, and welcome to What's Up Wednesday. These are a few highlights of what's been going on with FME and here at Safe this week. Standards for Transformer DesignHere's an interesting question from user David Runneals on Twitter:Luckily Safe co-founder Dale was on hand to give a great answer, which gives advice on both how to design a custom transformer and how Safe designs its transformers too:In the earliest of days, we thought data was inherently good and so if we encountered anything in the data stream that wasn't expected, clearly we should shut down the translation then and there so the user could fix the input.With time, however, we realized that data is inherently evil and so we needed to put the decision of what to do with bad input in the hands of the workspace developer as much as possible.  Then they could decide to ignore it, or shut things down, based on their needs.So the policy we have now is if there is some problem with the *configuration* of the trans

Hello,I am trying to login on the password protected website (url: Mijn Kadaster - Inloggen). A HTTP-caller if configured, see attached file 1). Unfortunately, no access to the secure website is established so far. See attached file 2.What have I done wrong? Kings regards,Pim.

​I am getting a HTTP status 405 error when I try to generate a GEOPDF using the link http://arcgprdcgy001.network.lan/fme/GenerateGeoPDF/. It says: HTTP method GET is not supported by this URL. The method received in the request-line is known by the origin server but not supported by the target resource.

Hi all,My question is regarding performance actually...I'm going through a process of reading data (shp) trimming it, doing change detection and writing it to a sde. Some of my data contains 5.000.000 objects, so it takes forever to run it, which is not a problem in production mode. In the testing fase, when tweeking and changing settings it is a big hazzle though. I have added a tester to both my original data source and the revised data source to filter out a small portion of data, but it still has to go through every single object when reading the data... So my question is: Is there a way to avoid having to read everything from both datasets? Thanks :-)

I have tried to use LineExtender and Snapper but results are not correct, not sure what I am doing wrong. Workspace (FilterGeoJSON) and Geodata (LineArea) are attached.

I have created a User Parameter of type Choice. I am trying to transfer control to a workspace runner based on what is selected. So far, I am having no success. When I run the workspace, the value is showing as 0 instead of my actual choice.

Hi FME team,I want to create a list from attributes, retain the site IT and Metric - with the metric values. So effectively I will have a feature for each Site ID and Metric combination. I've tried ListBuilder and ListExploder but not working as I'd like. Attached is an example of what I have and where I need to get to. Any help would be very much appreciated! Thanks.

Hi, just learning FME.I would like to know what transformers to use when I need the ff: Identify points that are near each other (points within 30m buffer)Identify the similar attributes of the points within that 30m buffer The goal is to know the potential duplicate points based on XY and other attributes. Thank you!

I am struggling with creating centerlines in wall geometry from CAD, where some squirrely ones show up:I was hoping that I could filter by # of vertices, or separating by angle, but this is not reliable. Any ideas? Thanks,@larue​  

Sometimes one ends up with tables that contain empty columns. Is there a way to detect if an attribute is not being used, if it is "empty", and then remove it from the table? A automatic table cleaner of sorts. This would make the management of data "creep" a lot easier.

Hi,i want the start and endpoint of a line. So I use a Coordinateextractor and with coordinate index 0 I get the start and with -1 the endpoint. Normally it works fine but I have a line and suddenly the endpoint is somewhere in the line. I found out that the line was aggregated with FME and this somehow mixes the parts and the indexes of the line, so the endpoint is now in the line. In the help of the aggregator is listed: If the order of individual geometry parts within the resulting aggregate is important, you can first route the features through a Sorter. But I don’t have attributes to sort the line.If I use the dissolve function of Arcmap the line is dissolved correctly. So is there a way with FME to get a aggregated line where the coordinate index of start is 0 and coordinate index -1 is the end at the correct position?

Hello, Dynamicly filling the Where Clause in a FeatureReader (Arcgis Online feature Service) only gives an error in Automations. I want to retrieve notifications (meldingen) of the previous month (maand) of the year (jaar) out of Arcgis Online (on a certain point in a month). I want to put this functionality in an Automation. I do this using the following steps:-In an AttributeManager I take the current DateTime; extract the month and year and calculate the prevous month (use conditional value for use in January).-This values are put in a privat parameter: Maand (month); JAAR(year)-The private parameter is then used in the where clause.EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = $(Maand) AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = $(JAAR) This setup works in FME Desktop and on FME Server > (from log)where 'EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = 7 AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = 2021' When putting the Workspace in aan aut

How can i do this? I tried everything i could.The number of columns needs to be dynamic.. if Town III is 5 times then there should be JB5 ZB5 and RT5.The RT1 Column is the Order in which they should be (see colour)

Hello, I am trying to make a REST API call to one of our servers from inside of a Workspace with an HttpCaller and I am not sure where would be ideal to store or pass credentials like username-password pairs/tokens that are required for this. I don't want to just leave it hardcoded in the Workspace, what I'm looking for is some kind of storing mechanism for sensitive data from where we can retrieve it later in a Workspace.(whether it's in the Cloud/Server does not matter, as long as it's via an FME feature) Any alternative/tipp would be greatly appreciated on the topic of credentials/security measures when working with the FME ecosystem. Thanks in advance!

I am trying to extract images (pdfs, tiffs, etc) from attachments in an ESRI geodatabase. I have been able to get what looks like the proper file but it won't open. Any ideas or perhaps know what to fix this?

i want to read an aprx or lyrx file in fme . is it possible?

Hi all,I wonder if it is possible to have FME expose the day of the week at the time of running the workbench? E.g. If the workbench is running today I would like to have an attribute "day_of_week" that has "Wednesday" as a value.If it is run tomorrow the attribute should read "Thursday" etc etc Thanks!Ed

I have attached the actual workbench below. SO in more detail, what I am trying to do is to output fanned out (by council name) shape files and GDBs to an already existing folder (of the same name as the council name attribute) on a drive somewhere. Is there a way to direct the output data to go into the different council folders when this workbench is run for all councils?The intention is to place this in the server and then schedule it to run on a quarterly basis.any thoughts?thanking you in advance.

Hello, I am passing in a list of values to a user parameter (eg: LGA LGATYPE ABBNAME). The user parameter is assigned to a parameter of ChangeDetector (Selected Attributes).  If I open the FME workbench and run it, the ChangeDetector recognises the parameter value passed as a list of attributes. It then uses those attributes to check for any differences between 2 datasets. That is as expected. However, if I run the tool from the command line and pass in the attribute list as a parameter, (eg: LGA LGATYPE ABBNAME), ChangeDetector does not recognise it as a list and does not find any attribute based changes.  If I reduce the command line parameter down to just one attribute (eg: LGA) then it works. The parameter is a list parameter:  Any thoughts on what might be going wrong?

I have an excel spreadsheet with 3 columns (featureclass, tag, summary). I want to update the metadata.xml file that corresponding to the featureclass. These xml files are embedded in a column in an sde table gdb_items. I'm able to extract the xml, but I don't know how to add xml elements. I have seen the xmlUpdater which works but only when that tag exists in the xml. Also, the "tag" field in the excel is a list of tags separated by commas. I need to create multiple <keyword> tags, one for each item. Here's my workspace so far. shows the xml without the existing "summary" and "tag" <idPrup> <searchKeys> with child nodes <keyword>, respectively shows xml with those nodes (lines 80 to 86)

Hi everyone. I am new to XML and am having some difficulties using the XMLUpdater and XQuery. My issue is around updating 3 attributes within an xml element from 3 attributes in an FME list to create multiple children. When I do this for a record which has say 2 items in the list it’s producing 9 children instead of 2, do I need to group my data somewhere in my XQuery? I’ve attached a sample workbench and data. I am reading an Excel document, then creating a list of all LCS_Codes and their measures per TAC_Code. I then want this list to form the children of a location element within my XML. So I’d hope to go from something like this: Input table:To this output XML text: <tractionCurrentSection id="M58"><location> <part idEl="B077/MSBFA" startPos="0" endPos="149.302"></part> <part idEl="B077/MSBLO" startPos="0" endPos="133.761"></part>

Is there a way to have this python module in FME?  

I'm trying to convert a DWG with solids to an OBJ mesh.The conversion is good but the OBJ doesn't include the color of the solid ("autocad_color"). I tried GeometryColorSetter but I can't seem to set it up properly.I also tried the AppearanceSetter, following this post: https://community.safe.com/s/question/0D54Q000080he8G/how-to-set-the-color-of-an-ifc-objet-ifcproxy but I can't set it up correctly Could you give me some suggestions on how to setup the transformer GeometryColorSetter (or a better one) so that it takes the "autocad_color" of the geometry and gives the same color to the resulting obj.