FME Form

Using FME workbench 2023.0, I am trying to make updates to some rows in a PostgreSQL table by using the FeatureWriter transformer that takes a csv as the updated dataset as input. However, I am unable to fully run the workbench as it takes an incredible amount of time to run, with the warning message: "POSTGRES Writer: Bulk Insert is set to Yes, but a conflicting Feature Operation has been detected. Feature type 'ela_master.lim_watr_chem_anal_arbi' has a Feature Operation of 'Update'. Bulk Insert is now being set to No, which can cause insert operations to be much slower" I have made updates to the exact same table using the exact same FeatureWriter transformer parameters before with no problem... and this is a new issue I'm encountering, and quite frankly I have no idea how to solve it. Can someone please tell me how I can fix this? Thanks.

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that? I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs. I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.Thanks in advance for any guidance you can provide.

Referring to this: https://openai.com/blog/introducing-gpts I'd love to see a GPT fed with FME's documentation - also the Python API It's be great to have FME's built in AI tools use something like that to give more FME specific answers? Just an idea 

A workflow we use at work is as follows: Geometry data is stored in SQL Database (attached screenshot - SQL Geometry.png). It is a multi-part polygon and looks to be correct.I use a SQL Creator in an FME job to get the data from the SQL Database. We call a stored procedure to get this data but no transformations are performed in this GET.I use a Geometry Replacer in the FME job with the following settings:Geometry Encoding: Microsoft SQL Server BinaryMS SQL Server Format: GeometryAfter this Geometry Replacer the shape looks correct in FME Inspector, but the Type looks incorrect (attached screenshot FME Data Inspector.png)The shape looks rightIt is classed at the top level as an IFMEMultiArea type of 1 part which is not right. It seems to have classed it as a shape with 1 part (a donut) with an outer boundary and 2 inner boundaries.I'm pretty sure the data conversion into the SQL format is correct but I can't get access to that right now to double check.Has anybody got any ad

I want to create a PDF report like this , where i have HEADER and the value below   In this yellow boxes 'PDMS' column could go in this attribute values  this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc. 

I need to split this polygon using as a reference the rows, how can I do this? These polygons are initially rows, which I transform into polygons using AreaBuilder. As a result it generates 2 polygons, however I need to fragment the polygon into more parts according to the rows.

In a way through shell script I should be able to dynamically send the criteria that we apply in tester transformer for filtering the input data. How to do it.

I have configured tester transformer with user parameter, such that feeding the user parameter through command line will automatically provide the criteria to tester transformer for filtering. 

I am trying to get all the unique values from each field in a dataset. I would like to be able to expose the field name into each record, so I have an output table that looks like this:  I can run a statistics calculator to get the unique values, but the only way I have managed to expose the field name is by using an attribute exploder. This seems a bit messy because it outputs a whole bunch of combinations I am not interested in.  In the attribute manager, using @Value(fieldName) will return the actual value rather than the field name itself - are there any tricks using string expressions etc. to expose the actual field name? Seems like a simple thing to do but may be better handled in python. Just wanting to know if it's possible in FME! Would be really handy.

Attempting to read a layer via a Feature Service on Portal. As I am the owner I have the relevant permissions to access the layer, and it also has relevant editing permissions. This is confirmed by being able to edit the layer in Portal itself. However, when attempting to read in the layer I am met with the error in the question title. I can successfully connect to our portal, and even the Feature Service using the reader - it just fails when attempting to select the layer. See below:I should add that the log does not provide any useful information. Appreciate that this could be rooted in Portal configuration but any guidance much appreciated!

Hi All,I'm facing some odd behaviuor with the AttributeFilter, Tester, TesterFilter. The screenshot below shows that my data includes 'g2a' values in the attribute table but I filters that value in any of the transformers cited above the values doesn't show up?  Here is another snapshot of the AttributeFilter (unfiltered) after importing all values From Feature Cache:  Why does it go into the Unfiltered values?  Any idea more than welcome 🙂Thanks

Hello i would like to use the output from one workspace as input in other workspace .the first workspace has 5 output that I would like to use them as input at second workspace. How could I achieve it ? thanks in advance FME 2021

Hey community! How can I do a visibility analysis, from several observation points to several points or lines of sight?I can use 3D vector data, LiDAR data and DEM from LiDAR data. Anyone has a "script type" to explore?😊 TNKS a lot guys!

Hi, Is there a way that I can read only point layer type from gdb without reading the full content first and then making selection? Read particular geometry type form gdb

Hello, I have a IFC which contains some 3D pipe (ifcFlowSegment), somehow it has about 70 face polygons, which makes it looks great but it creates some issue in the following workflow in ArcGIS Pro. I'm wondering if there's a way to generalise/ simplify pipe solid, for example by reducing the number of face polygons to half or something? Thank you. 

uninstalling prevous version is not going, does anyone have a solution?

Hi I have upgrade FME Flow and FME Form to version 2023.1. S3 Connector v2.1.2 works fine in Form, but not on Flow.The Packages Folder was empty after new install. I ran a S3 Work Bench on the Server, it unpacked on engine, but all the folders are empty. Got the following error.59 2023-9-18 15:42:59 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_amazons3'60 2023-9-18 15:42:59 | PythonFactory failed to load python symbol `fmepy_amazons3.connector.S3Connector'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date61 2023-9-18 15:42:59 | Factory proxy not initialized62 2023-9-18 15:42:59 | S3Connector_CALLER (PythonFactory): PythonFactory failed to process feature 

Trying to convert data to XLS where each layer is a separate sheet. I was able to do this in FME desktop but unable as FME Form. Is there something special I need to do with FME Form?

I am importing a project into FME Form that contains two automations, associated workspaces, and the repository for the workspaces. The repository for the workspaces already exists in the FME Form environment I'm importing into and it has other unrelated workspaces in it. The Preview Import page states that I will overwrite the exisiting repository during import. What, exactly, does "overwrite" mean? I only want to add the two new workspaces to the existing repository. Is that what happens? Or does the import process completely replace the repository, wiping out any existing workspaces and keeping just the two new ones? Something else? I'm trying to figure out if I should include the repository during import or not. I can't find any documentation that provides an answer. If anyone has one or can point me in the right direction I would greatly appreciate it!

Hi All, I have put a workbench together to populate some GIS metadata but I need to have the <CreateTime> automatically populate every time I run the workbench, below an example of the XMLTemplater transformer settings:Currently the time if fixed as 00:00:000, How can I set it as variable parameter ? I have tried the ROOT Template Functions but didn't work. Any advise more than welcome :)Thanks 

Hi, I would like to read all the layers published to Esri Portal/Enterprise that are shared with particular group. I use Esri ArcGIS Portal Feature ServiceIn the Parameters I would like to change the Feature Service so instead of reading one layer will read all layers from that group; A9 WTC in this case

My configuration in the JSONTemplater looks like this:  {  "type": "Feature",  "geometry": {    "type": "Point",    "coordinates": [      fme:get-attribute("X"),      fme:get-attribute("Y")    ]  },  "properties": {  "33064" : fme:get-attribute("33064"),  "33085" : fme:get-attribute("33085"),  "33103" : fme:get-attribute("33103")  }} As result I get: { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 7.61438690276304, 47.5603635244644 ] }, "properties" : { "33064" : "", "33085" : 94328460, "33103" : "2. von B Spezmast Nr.55" } } The number is not set in double quotes which results in error when I use the json string. Any ideas what could be the reason.

Hi;I created a very simplified version of my custom transformer.All it does is find the center point and define the layer name for the future dwg writer.Attached is a custom transformer and workbench example, where dwg writer creates a dwg file with point in the default layer that come from custom transformer.When I use the transformer in "linked" mode and start the entire workbench, I get an error.When I use it in "linked" mode but with the use of feature caching to the transformer, and then I only start the dwg writer with "run to this", then it's ok.When I use the transformer in "embedded" mode, everything works fine.The difference in the translation log is in line:"Using MultiWriter with keyword `PRIMARY_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')"in embedded mode and"Using MultiWriter with keyword `REDIRECTED_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')" in linked mode.Note tha

I have created a workspace which takes multiple zipfiles as a user parameter and reads them with a FeatureReader containing an Directory and File Pathnames Format. If I run this workspace in FME Desktop 2021.2 it works fine.My next step is publishing it to FME Server 2021.2 and starting it there.I add the same files to the user parameter and request the workspace to run.It starts like it should and gets the filenames as parameters but then it gets weird. FME Server seems not able to process the parameter it created itself.On the FeatureReader it gives an error which tells me the FeatureReader (QueryFactory): The clause '@EvaluateExpression(... is in correct.I asked several colleagues and searched the internet on this specific error but  I can't find anything that looks like this. So did anyone ever run into this error and does one know how to fix it? The complete error (without the file paths which are formatted like "D:/ProgramData/Safe Software/FME Server///resources/system/temp/uplo

I have changed the project file extension to .zip and extracted the XML documents, but getting nowhere with Esri ArcGIS Layer Reader (safe.com) Have also tried pointing a regular xml reader at them. Any ideas?