FME Form

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 D

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 no

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 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.

is there a way to replicate sde. default database and store it in the folder? also for recurring backups or replication of the database would not be overwritten and saved into a different folder with a different name. Please let me know if I can accomplish this in FME. Thank you,Sarah

I have one column with this values. I would like to filter only words that contais ABC letters. But can´t be JACABC or RDABC. Sometimes the ABC is stay in second or third word after the comma, like image below:  Thank´s

Below as a screenshot of the Revit project (what i am trying to export) followed by what i am able to convert and export into ArcMap. Missing room tags and door swings.

For more information visit us:AutoCAD Classes in PuneAutoCAD Course in PuneAutoCAD Training in Pune

Has anyone experimented with connecting to "Databricks on AWS" data sources? If so, which reader format or transformer should be used to make the connection and browse the available data?

Hi, I'm trying to insert a decimal into a string of numbers, so 123456 becomes 1234.56  Thanks!

What format can I write to using FME so that my vector data can be read/processed with OpenCV?I'm in the early stages of an image segmentation project to identify impervious cover data from aerial imagery but we're having some early issues getting my vector impervious cover data into a format that my computer science counterpart can use in OpenCV. It seems like XML or GeoJSON would work, but I don't have any experience with OpenCV. Any ideas?

Hey there, So I recently set up a Data Distribution service on FME Server using this tutorial https://community.safe.com/s/article/data-distribution-fme-server-app . Everything works fine and I can use the area of interest box to draw an area and download all the relevant layers. I am trying to add a second option in the User Parameters to allow the user to either draw a selection or choose a layer to clip by.In user parameters I added a 'Choice' option and added a layer as an option to clip by my thought was I could add a second geometryreplacer, set the encoding to OGC well known text and the source as $(LAYERCLIP) by when I run it and select the City Bounda

Using a RabbitMQConnector in Stream mode to continuously listen for change events. It is set to not Auto Acknowledge messages as we do not want that to happen until confirmation it is written to the database. Was thinking to use a FeatureWriter as it chains outputs after writing. Doing this with Transaction Type of None and it inserts/updates the features in real-time fine. But the output from the FeatureWriter seems to always be blocking. We ideally want to use that output to acknowledge the message in RabbitMQ. Would try a SQLExecutor but also need to write the shape to an ESRI geodatabase. Worst case can probably use a PythonCaller using arcpy. But would be nice to have a persistent connection with an actual writer. Any thoughts on how to do something like this while keeping a data steam going?  

I am wondering about how it works if you want to have mulitpled editons of FME Desktop using the same Lic seerver, so floating lic. So say if we had 10 floating lic, and had 8 ESRI Editions, and 2 professional Editions how does that work on a Lic server, can users pick an edition when they start FME Desktop ?, or do you have to set up user groups for specific edtions, or would you need 2 lic servers, one for each edition ? Just trying to understand how this would work and what the options are for users to be able to choose an edition.

My organization is upgrading to FME Server 2021 (from 2018), and we'd also like to update our authentication method from Windows Directory to Azure.  I restored the backup configuration from our FME Server 2018, so all our user profiles are coming from the Windows Directory. I have successfully set up a connection to Azure and can import new users (the user says Type = Azure AD), but is there a way to migrate my existing users from Type = Directory Server to Type = Azure AD? Alternatively, I could re-import all my users from Azure AD and re-assign roles, but I was hoping there would be a way to switch the authentication.  Thanks

Hi,I'm looking to see if I can retrieve all tables with the same prefix and then save the table content with a dynamic writer in shape format. For this I start with a SQLCreator with the query:select TABLE_NAME GV_TABLEfrom colswhere TABLE_NAME like 'AB$_%' escape '$'and TABLE_NAME in(   select object_name from user_objects where object_type = 'TABLE') The result is then picked up in a SQLExecutor:select *from @Value(GV_TABLE) Attributes to Expose is left empty in the SQLExecuter. The result of the SQLExecuter looks like empty records but if you look with Visual Preview the attributes per table are present. With a dynamic writer I try to write to a shape file per table. The writer does not write anything. So is it possible to make the attributes visible after the SQLexecuter? Attributeexposer does not have a *.* wildcard.

Hello FME friends, Server Apps TroubleshootingAs I mentioned previously, I'm getting a weekly report of new and updated knowledgebase articles, and the one that stood out this week is FME Server Troubleshooting: Server Apps. Besides simple troubleshooting steps, there are a number of FAQ-type issues, such as "Why don't users have the ability to upload files to my app?" Solution: Ensure the "User Can Upload" setting is enabled.  Also, there's an interesting issue where the OK button doesn't work (answer: there's a user parameter that's hidden, but is required and has

Hi,I want to read google sheets with FME, in order to update AGOL feature service.On my Google drive, I have a folder "HEBERGEMENTS", with 9 spreadsheets.In FME, I defined a Google Drive Connection, and I use the GoogleDriveConnector. I can access to the folder HEBERGEMENTS, but when I run the connector, it reads nothing...Is there a option to see files ?I don't understand...Because the goal of that is to run my workspace with a batch.Thank you very much for your help !Christine