FME Form

Hi all,I would like to: list feature classes/layers from a file geodatabase. Sort. Keep first N tables and drop the rest.  All is good till dropping the tables . So my question is how to drop a list of tables in a File Geodatabase I looked at SQLExecutor and there is no option for Esri File geodatase. In the geodatabase writers you can only "Drop and Create" tables. This example seems promissing, except I would need to update the User Private Parameter with an sql of tables to drop, and it does not seem to be working in that direction : workspace variable => Published Private Parameter. Or does it?https://gis.stackexchange.com/questions/251542/how-to-delete-a-single-feature-class-from-a-geodatabase-using-fme Just to mention that in this example, if I hardcode the Published Private parameter with list of tables to drop it works"FME_SQL_DELIMITER ; DROP TABLE first_table; DROP TABLE second_table;"  All suggestion are welcome and thanks in advance

I am looking for suggestions on how to create Response Areas based on a Road Network and Station Points.  For example:DATA INPUTS:1) Greater Geographic Region Polygon - basically the greater region of interest.2) Road Network within Geographic Region - network has topology, along with speed and time cost attributes.3) Station locations - they may or may not fall exactly on the network. How can FME take the Greater Geographic Region and split it into sub regions; one region for each station based on the drive times out from the station. The result is a Station Response Area.

I am reading a CSV file. The data does not have a header record and in the Fields setup of the reader I select None for the field Names Line (default is 1.) The data preview shows the first record being read at that point. However, when I save the reader and preview the data it starts at the 2nd record.

I'm looking for some ideas on the best way to update an existing SDE feature class that I'm using as a reader in my workspace. Let's call it FC 1. It's a compilation of active and inactive parcels. I'm using FC 2 as a reader as well and I need to compare the two feature classes. If parcels have been removed from FC 2, then I need to update a field called "Inactive" in FC 1 to "YES". So as I'm writing it out, how do I get that end result to also be the reader for the beginning of the process? This is something that will run nightly. Thanks in advance for your ideas!

How to read a csv file that is inside the Tableaut panel on this website below: https://www.saopaulo.sp.gov.br/coronavirus/isolamento/

According to the current political situation here in Europe, we want to work out a plan B if gas supply will end, and for that case, how to get our gas network back working.  For that task, we would like to analyse our gas network (trace?) in dividing the network in zones/branches. The idea behind that is to use major valves as "stop-object" for the network trace, because you need to get back the gas network in little branches. (vent these parts, before going back on pressure) Our Gas network is topologically correct, and I would use the specific stop-objects (disconnect slides/valves) to divide theses network parts/areas. Is there any way I could use FME transformers to get these resulting network-parts? thx in advance, Christian  

I'd like to create a string attribute with a specific length. I'm using an Esri AGOL writer to create and write to a feature service. In AGOL, I want the Field length of this string to be 12. In a PythonCaller, I'm using: objText = '00123'    feature.setAttribute("TextField_test", 'ABC' + objText)      In AGOL, this creates a field of string type with a length of 254.  In an AttributeCreator (before the PythonCaller), I created the 'TextField_test' attribute with a value of @string(12). This creates an attribute a value of '@string(12)' which is obviously not what I want (the python overwrites that value). In AGOL, this creates a field of string type with a length of 200. I understand that I could the User Attributes in the AGOL Writer to Manual and change the attribute to Width to 12, but I also have an Excel Writer and would have to set the Cell Width to 12 as well. During development, I'm adding and removing many attribute

Hi Everyone, I'm looking to read a password protected Excel file and copy specific data to another Excel file. Is this possible?  

I have a Geopackage with lots of tables and would like to speed things up by only reading the needed tables for later processing. The 'Where' field only applies to table content, I want to filter on table names. I would like to use a wildcard to import layers containing a certain string. ExampleIn a dataset all hydrographic layers might contain the string 'hydro'I would like to use sql to only import these layers by using something similar to 'LIKE %hydro%' edited by including an example  Edit 2: I realise I made a huge, and embarrassing, typo. The file I am working with is a geopackage, not a gml... *facepalm*

Hello! I have a basic scenario where I need to batch move point features, while also dragging line features snapped those original points. The model is a network of split lines with a "station" at every line endpoint. We can assume every endpoint or intersection has a singular station. The sequence of lines and stations make up the backbone of the model. Maintaining that consistency is critical.  Now let's say I've received GPS data which places these points more accurately. A subset of stations now have fields for "Current XY" and "New XY". I need to physically push the points to the new location and this part is simple. Looks like I can use VertexCreator to reset their geometry. But I also need the line endpoints to automatically move with the station. Any thoughts on making this happen? Note that the stations and line endpoints generally have the same XY coordinates, but we assume a tiny spatial buffer is needed to catch everything.

I am trying to understand differences between FME and smallWorld and what can one do with them. It's the first time I have touch with smallworld and I am especially interested in analysis of the distribution grid. To be more specific, I am interested if and how would be following possible: 1) Distribution grid operator exports part of it's grid to some file2) This file is provided to me3) I can open this file to access distribution grid details What I need for this, is it possible to do it with FME?

I'm using FME Desktop version 2022.1. I'm not sure what the "request denied due to lack of license" is referring to. The workbench is writing to a hosted feature service. The writer is configured to truncate the existing data and insert new features. The web service and connection have been verified as well. Thanks,Frank

Hello,I want to merge a jpg with a png over it.How can I replace this Paint.Net function (Merge Layer Down)?https://www.getpaint.net/doc/latest/LayersMenu.htmlThank you.

I have a table containing ten lines (each one a street). Each street has a name and a zone value. But there are some duplicate records…  Street_name                       Zone_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone BHigh Street                         Zone DHigh Street                         Zone DAcacia Avenue                   Zone BAcacia Avenue                   Zone B Acacia Avenue                   Zone B Acacia Avenue                   Zone C Acacia Avenue                   Zone C  How would I reduce these down to unique records only. So, I’d end up with this… Street_name                       Zone_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone DAcacia Avenue                   Zone BAcacia Avenue                   Zone C   Thanks,

Dear, I have a workspace that reads a in a postgis database with an SQLExecutor. It all runs smooth.  However I want to make my workspace generic, so that it can use other input data from different databases/schemas in the future. That is why I put everything to read in user parameters. That being said I encountered the following problem. My workspace runs fine with the original data. However when I change the name of the schema of my input data, and I change it in the SQL executor accordingly, I get the following error: 'Error executing SQL command ('select version(), postgis_version()'): 'ERROR: function postgis_version() does not exist'  When I try to read in the schema with the changed name with a PostgreSQL reader, it works just fine. However this is not desired, since my data contains geometry. Does somebody has any clue what can be the cause for this? Attached you can find the logfile and some screenshots. I tried running it both on the 2021 version of FME d

I know that I am missing something obvious, but if I have a point that is on a line dividing two adjacent polygons, how do I select both polygons. At present I am using the point on area overlayer transformer and just getting one picked up?? The image below should make this clearer..Regards...

I am using NeighborFinder to find adjacent horizontal (or vertical) lines. I create a list and the transformer automatically supplies the angle value for each item. I want to remove any list item which does not have an angle value of 90 or 270.The ListElementFilter has been very helpful, but it seems to only filter one value at a time. I also tried AttributeManager to conditionally change the list{}_angle value to 90 when it finds 270, but no luck there.Would this be a Python situation?Any help is appreciated.  

I like to use the PDF2TextReader_custom transformer to convert pdf files to text files in FME 2022. I downloaded the pdftotext application(v. 4.04) from XpdfReader and followed the installation instructions. Trying to run the transformer it gives the error 'Error opening pdf file'. Using the command-line executor of windows I'm able to convert the pdf to text(including a xpdfrc-configuration file in the same directory as the pdftotext-file, as advised by XpdfReader). My question, what can be wrong when I use the FME-transformer?

I have some data that I have run through the statistics transformer in the format shown below i.e. ID, Year, Count I want to create a chart but need to include the years that have a zero value in a five year period i.e. 2015 to 2019. How do I manipulate the data to add in the missing years with a zero value?  Any assistance would be greatly appreciated. 

I am trying to merge two TIF files using the RasterMosaicker, but for some reason all it writes is the first file, not the merged files. Can't figure out what I'm doing wrong. I have not uploaded the TIF files because they are 380MB each, but anyone wanting to test it can access them at https://drive.google.com/drive/folders/1T_lRY4zRAJDSOYRAaqic4bHLwoe4VGfT?usp=sharing.

In the source file, i have 4 files but when I aggregate the fields it gives me only two files please anyhow help me where I doing wrongSource fileAfter Aggregate the fields

I'm working with the SchemaScanner transformer and trying to compare two similar schemas for differences.  However, one of my datasets is a shell and has no features in it (the top feature reader and stream in the workspace screenshot) This seems to be causing SchemaScanner to output different results than my dataset that has features.  I'm basing my workspace off this article here - https://community.safe.com/s/article/How-to-SchemaScanner-Transformer How can I compare the schemas in this case?  Here's the list exploder output from the feature class that has featuresWhile here's the list exploder output from the featureclass with no features

Hi allTrying to generate watersheds based on input points and a DEM. The ESRI Create Watersheds tool does what I need but I haven't been able to figure out how to do it in FME. Any pointers? Inputs: DEM + PointsOutput: Watershed areas per pointESRI tool https://doc.arcgis.com/en/arcgis-online/analyze/create-watersheds.htmThank you

I want to take the results of a SQL expression (SQL Executor) that returns a format like:POLYGON((2861292.56247401 15394288.32744411,2861296.63792518 15394295.48523819,2861287.86169601 15394300.48260353,2861283.78591676 15394293.32480944,2861292.56247401 15394288.32744411))and generate an fme polygon object without first writing the geometry json to a file.  I have looked at FeatureReader and ESRI JSON reader. Looks like the variable passed is expected to be a file.  The issue I have is the new ArcSDE Geodb reader reads Esri Annotation geometry as a point. The annotation geometry type is stored as polygon. I need to get the polygon like I had before with the Esri Legacy Reader.