FME Form

Hi, and of course “HELP!” 😁 I need to take some values in a column and create column names from them, taking the associated values with them. My starting table looks like this (note this is in Excel, but the table exists within an FME workflow, I am just showing it like this to make it easier to understand… hopefully!!!!!): Asset_ID is my unique identifier. You will see there are either 3 or 4 duplicates of that number. Column B “CHAR_TYPE_CD” has the values I want to turn into new column headings, combined with the existing column headings in C, D, and E. This is ultimately what I want it to look like: Note The values from the original Column B are transposed and combined with the previous column names. There are 4 individual attribute values in the original column B, namely: CM-ELCNT; CM-GRPNG; CM-VOLVL; and CM-VN Original column C “EFFDT” now becomes “EFFDT CM-ELCNT” Original column D “CHAR_VAL” now becomes “CHAR_VAL CM-ELCNT” Original column E “SRCH_CHAR_VAL” now becomes “SRCH_CHA

Hello everyone, I was wondering if there is an environment variable available for the R interpreter.If I look at the following post, there appears to be an environment variable for python, but not for R. It would be nice that the R interpreter would be able to look at a certain folder on the C disk for example and when there is different version of R, then the R interpreter would automatically change it. For now, I manually changed the interpreter, however ideally I would like during an update of R, that the R interpreter would automatically change the R interepreter. Does anyone know whether that is possible or might be possible in the near future?

Hi everyone! Curious if I could pick your brains on how to achieve the workflow: I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB. The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GIS Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the asset_id does not exist in the API table. The asset_id field in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GIS Feature class. Here is how my workspace is looking now, with the top line connecting to my API as the original source in the Change Detector, and my GIS FC as the Revised source in the Change Detector. That’s one of the main prediciments here is that the data schemas are different as the original source is a Hansen API table whereby the fields have different schemas/naming conventions than the fields in the GIS FC (by de

Curious if I could pick your brains on how to achieve the workflow: I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB. The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GRI_TEST1 Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the assetkey does not exist in the API table. The assetkey in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GRI_TEST1 Feature class. Would I be going the right route here in using the PythonCaller to achieve this? Right now my writer is writing to a xlsx document and not the API table yet so I could test out the logic. # Import necessary modulesfrom fmeobjects import * # Function to check if asset key exists in feature classdef assetkey exists(assetkey, feature_class): # Implement the logic to query the GIS feature class # Assume 'feature_clas

Hello, I am using the SQL Executor to read two tables from oracle using a join. I would like to use Oracle Spatial Object as Format to have the geometry included. This is my sql query: select a.nm, a.fid, b.mlpst, b.featfrom t_csm ajoin t_fl bon a.clss=b.clss Both table a and b have a geometry (GEOM). When I use SQL Executor - Oracle Spatial Object, how can I know the geometry of which table will be used ? I want it to be the geometry of table b but I don’t how to specify it. The geometries of these two tables are not the same and my next transformer is the neighborfinder so it makes a big different if I use the geometry of table a or table b.Thanks for your help.

Hi All, I’m having a bit of headache to get my worflow working: I need to load some attribute data into a template GDB but for some reason fails becuase of the data type (I asume). Below some screenshots that explains the issue: Error Value 4510069419 can’t be written into table UPRN_Lookup_Monthyear_FulSupply Raw data value FME reads value UPRN as unit64 data type see below: Template GDB in FME FME reads the template GDB (in the FeatureWriter transformer) as Float Template GDB in ArcCatalog UPRN value is Float in the GDB template What value can’t be written? Thanks

Hi, I have 100 polygons that state the population within each polygon, I'm essentially trying to break it down 1 stage below where I have that population essentially scattered across the polygon boundary in the form of points to then get a rough estimation of the population in small selections (and not for the entire polygon) I saw a question asked very similar to what I need where I have the population value in a field and I would like to add that as an input into the RandomPointGenerator (however this transformer does not accept inputs (aside from the fixed value you state), and this does not seem to have been changed in the 5 years since raising this question). Someone had mentioned the use of workspace runner, but I am not sure how to incorporate that into what I'm trying to do.

Hi all, When using a FeatureReader, FeatureWriter, or any other transformers, I can’t seem to access the Coordinate System Gallery. However this doesn’t seem to impact readers or writers (when accessed through parameters anyway). Excel Reader Reprojector (note that Source Coordinate System does use the Coordinate System Gallery) I’m currently using FME via Data Interoperability through ArcGIS, is this a limitation of the extension? Or have I missed a setting to use the gallery in all cases? Cheers for any help.

The last few weeks I have been getting an error message whenever I try to frequently run my workspaces. Since I am testing transformers, and attempting to find the ones that create the most appropriate outputs for my task, which is converting a shapefile to match with a preset schema. If I run the full workbench and then change something because the output did not match what I needed, then run the workbench again. I get an error that says “Failed to write to file” with the file path pointing towards a .dbf filetype in my output folder. The only fix at the moment is completely closing FME and reopening. But doing this for every small iteration is not feasible long term.

I am using the HTTPCaller to interact with an API, for that I use the setting Multipart/ Form Data. This is the way another user got the Endpoint to work for them and I just always used it. This works pretty well, the API does what I want, the connection is stable, but there is one problem. Sometimes it takes a lot of time to configure the Multipart-part. For some jobs I need to configure dozens of parameters, this leads to a lot of typing, proofreading, etc. For this particular endpoint I don't just need to give parameters about the object I want to edit (some inspection), but also something like a table definition. The row (row_id) and the value, for each attribute of my dataset. Since this API endpoint doesn't like it when I send in null values as values, I need to run several configurations of the same HTTPCaller one that drops each variation of Null values in the dataset. Now I was wondering if I could somehow build the whole statement about the rows and their values with somethin

Greetings, I should read and write features one by one, namely in the feature reader I have a condition by which I retrieve data from the database, more precisely the ID. But every time I should first write a feature in the database that gets a new ID, and when reading the conditions for the second time, it should select that new ID, and not immediately select that first ID for me. how to create this?

Hello, I am working on a project which will fetch information and save to local machine, then I use xsd-driven-xml reader to read in the files to parse data down streams. I noticed that reader activate before HTTPCaller task and caused the httpcaller failed to create file in the designated location. How to specify the reader to activate only if my HTTPCaller successful? I have already have the tester set up and will be able to tell either failed or success, but xsd-driven-xml reader did not have condition parameter setting or anything for me to make sure it activate after tester passed. I can separate this into two workspace, or create custermized transformer to encapsulate some condition tester and xml reader together, but thought there might be better way and would like to ask for help here. Any information is appreciated.

Hi!I have a shapefile with a lot of lines with the same geometry, but different data. They are the fibers of an optical cable. How can I shift them parallelly to each other?

Hi All, For a project I need to write a geodatabase with a time_only field in one of the objects.To be able to do this I had to change my Python Compatibility to Python 3.9, which only works if Arcgis Pro 3.2 is installed. Otherwise I get this very helpfull error: But I don’t want to use 3.2 as default. Now I have 2 folders: C:\Program Files\ArcGIS\Pro2_9C:\Program Files\ArcGIS\Pro3_2 I manually renamed the Pro folder to include the version number. The issue now is that FME can’t find my Arcgis Pro, which makes me very sad 😥. How can I tell FME to just use C:\Program Files\ArcGIS\Pro2_9 and stop looking for C:\Program Files\ArcGIS\Pro. Only when I want, I manually will change the folder to 3_2.

Hi, I would like to write custom hatches in a DWG file. But our FME Flow is deployed with Kubernetes.So the OS is Linux. Since the RealDWG writer is only available on Windows, I will need to use the other DWG writer (Acad). Where should I put these .pat files to write these custom hatches successfully? The documentations says: The ACAD format writer will look for custom hatch patterns in custom <filename>.pat files located in folder specified by the ACAD operating system environment variable, or in the related folder for any installed AutoCAD product. On windows, I have tried to create an “ACAD” environmental variable, pointing to a folder where I placed my .pat files. But no result. Secondly, will this be possible on a Kubernetes FME Flow? Thank you in advance Jasper

FeatureReader does not recognise attributes Hello all, I am having problems with a FeatureReader that does not recognize the attribute columns of a CSV file. The background is, I regularly download the GNAF dataset from Geoscape Geocoded National Address File (G-NAF) | Datasets | data.gov.au - beta The GNAF arrives as a zip file containing a large number of CSV files. I only need five of them. I have built a Directory and File Pathnames Reader that returns all of the CSV files, which I then filter down to just the five that I want. I am attempting (but failing) to build a FeatureReader that reads the CSV file. I should point out that the CSV file is actually a pipe-separated-value file. The separator is a pipe “|” and the file extension is “.psv” But I have confirmed that a normal CSV reader does successfully read the psv file. Now, the FeatureReader is successfully reading the correct number of features. And FME automatically recognises that two of the columns are LONGITUDE and LATITU

Hi ! I don’t know where to post that so sorry if it’s the wrong place 😊 When I use the button “alignment Middle” the alignment is vertical and when I use the button “alignment center” the alignment is horizontal. The action seems to be the opposite of the picture on the button. Do you have the same thing? On FME 2018 is the reverse and it look more logical. FME version : 2024.0.1.0 Thanks !

Hi, I’m on the version 2024 of FME Workbench, I have to calculate a number of neighbor between points (let’s say 5) in a distance (of 20 for example). But the issue is that I don’t know how to export the 5 distances in specific attributes… If someone can help me I’d love that !

I have dgn/dxf formatted CAD 3D lines which are "cables" below the ground. These cables are sometimes 1m below ground and sometimes 50cm and 10cm etc. below the ground. I have pointcloud LAS data as ground elevation data. Now I want to extract the cables(lines) which are below the ground upto 50cm. I want to cut the cables layer with elevation model to selct the cables network from 0 to 50 cm below the ground. How can I cut those lines? I am trying with qgis and FME but, unable to get the right solution. Anyone has idea what software or methods to follow.

Current Version: 2024.0.3.0 (20240603 - Build 24220) Since upgrading from 2023 to 2024, some weird behaviours have happened.Some critical workflows have not been outputting the correct information on our public facing website.In this case, I’m referring to the Building Control (BC) header on that page after you type in an address.Instead of stating that there was a BC information against a property, it would say no information found. Whilst investigating I found the following: The result of SQL Query was outputting NULL values as a string value called {NULL}. Never seen that before. Therefore, the Conditional Value was returning the wrong information. i.e. If xxx IS NULL and xyz HAS A VALUE…. Subsequently I had to add a StringReplacer to fix this anomaly for now. SQL Statement WITH bc_html_aggAS(SELECT blpu_uprn, ARRAY_AGG(bc_html) AS bc_html FROM myproperty.buildc_html_temp GROUP BY blpu_uprn ORDER BY blpu_uprn) Select Distinct(bc_html_agg.blpu_uprn), b.address_string, bc_html_agg.bc_

Hi, I want to write a RealDWG using custom hatches on FME Flow. When working on FME Form, we put the hatch files in <FME install folder>/plugins/realdwg/Support and it works. But when uploading the workspace to FME Flow, where should these files be placed? Is there a designated location for them in the Resources? Any help appreciated. Cheers, Julien

HI All, What the best way of loading data into a blank template GDB? Attributes, domains, etc are already set up in the template GDB but need to know how to load data into the template using FME, Do I need to use the template GDB in the writer and then map the fields from the reader to the writer? Any idea how to do this? Thanks

In FME Form 2024.0.1.0 I got an error when trying to read data or schema with “Microsoft SQL Server Non-Spatial” Reader: “Unable to decrypt data”. On the same server, connection with SQL Server Management Studio works fine.Does anybody know this problem or has a solution?Regards, Martin

Hello I have several GDBs with several FCs in different subdirectories. However, all GDBs have the same structure (same FC with identical attributes). I would like to merge all the data depending on the FC and then process it further in an existing workflow. Using the example, I was able to read and save all data, but it deleted all attributes and combined all FCs into one single FC. My question now is how I could read all FCs with the same name from all GDBs, merge them in one FC and then process them further in an existing workflow.

Hello! I have a GIS layer with a field named “yttyp” wich contains all various of attributes since its a text type. I also have an Excel-file with allowed attributes. How can i check if there is unallowed attributes in my GIS layer that is not in my Excel-file, and list them in a new excel-file. I have tried change detector, listsearcher, featureMerger but i dont get it to work.