FME Form

I've been trying to match the closest curve to a series a points.I tried the NeighbourFinder with ListStatistics and a Sorter, but it wasnt giving good matches to the points I have (likely because it's looking at points in all directions, not just points perpendicular to the curves). Any ideas how to match the curve closest to the points?Curves are grouped by _segment_id.

Hi I have a feature service that is apart of a Survey123 survey. The survey will indicate if something has failed in a variety of ways.  I currently have a workspace that has a testfilter transformer looking through 50 different attribute columns looking for the word Fail. Then from each output port there is an action that is taken. Is there a transformer that I could use to search the whole attribute table for the word fail instead? Thanks!

I can't fathom how to do this as a newbie. My feature has two attributes, start_coord and end_coord.On a row by row basis, I want to create a line out of these two points. They are currently WKT POINT geometries that I have created from coordinates.  I have attempted to use LineBuilder but that appears to build a line out of all my features (rows) so 44 rows output one messy line.  I suppose the PostGIS approach would be something along the lines of:ST_MakeLine(ST_GeomFromText(Attribute From Feature), ST_GeomFromText('Attribute From Feature'), ST_GeomFromText('Different Attribute From Same Feature')) Any advice would be wonderful. 

Special Pi Day Post Workbench that approximates π by generating a lot of random points within a square area and filtering the points within the 'circle' area. Inspired by Math Parker. Keep in mind that a buffer does not generate a perfect circle, rounding random numbers has a negative effect on the randomness and with more random points there will be a more consistent result.

The caller just hangs.Works fine on desktop but not the server.I had to add a feature holder between the HTTP Caller and the XML templater. Any other suggestions?? That seems to be only part of the solution.

Hello everyone, I am currently training in remote sensing. Is it possible to calculate the overlap rate between each pair of images, in the longitudinal direction and in the direction transverse to the flight axes via the FME software? I have tried many manipulations via the "AreaOnAreaOverlayer" transformer, but it does not allow me to differentiate between the longitudinal and transverse directions.I am open to any ideas. With kind regards,

Say I have one datasource with an scale attribute. On the same workspace but in a different and unrelated set of features I want to use this scale setting as a variable for a buffer. What is the best way to achieve this?I have tried a few different methods and transfering the attribute through the FeatureReader seems to be the most solid of those I tested, but surely there is a more elegant way to do this?

Hi Community. I am putting together a workbench to upload specific (Plan) files to a SFTP and while I was there I thought I'd add in to download a list of existing files, match them against the options to upload and add/remove only what is necessary. So in summary:Get list of plans on network drive (file and path directory reader). Success!Filter plan name against spatial file (determines if plan is needed or not). Success!Download list of plans currently on the SFTP (FTP caller with SSH-Authentication). Success!Filter needed plan names against plan names already existing on SFTP. Success!Delete plan files from SFTP no longer needed (FTP caller with SSH-Authentication). Success!Upload plan files to SFTP that are needed (FTP caller with SSH-Authentication). No success yet. I'm happy to upload the template file I'm just not sure that will assist without the keys needed to access the SFTP (can't give these out). The creator/attribute manager are there for testing some of t

I want to translate a shp file into gpkg format, but there is a id(32 bit int in shp) field in shp file. I can't do it via FME serverIt throw errors of3792023-3-7 11:28:17 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey'I try to use AttributeRenamer, But it is not working.How can I use AttributeRenamer in this caseThe attached is testing dataset

I have got a school's spatial data (point data) with capacity information in the attribute table. I have set up the Transformers to allocate the students to particular schools. But after allocating, I need to go back to the school's data for the next student. But after looping back, the data should show 1 less number in the capacity (because that seat got allocated to the student).  I am stuck here on how to go back and start the process again with reduced capacity.  Datasets I am usingSchools Feature ServiceMaster Spreadsheet with Students Data Thank you

I need these translation log info to be part of my translation canvass so I can include them into the header of my report. I used to have this solution in place but I'm hoping to find a more efficient way to include the info in my canvass and not the shutdown. https://community.safe.com/s/question/0D54Q000080hedASAQ/using-the-processid-and-timestamp-as-my-log-name-failing-on-rename-with-py3x-but-not-27  

Hello FME Folks,I am using FME 2018 (FME(R) 2018.0.1.0 (20180518 - Build 18310 - WIN64) to read SharePoint Reader using Python 3.6 for SharePoint 2013 intranet. The internet has NTLM authentication enabled. I am unable to logon for the SharePoint reader. It is giving me following error: 2023-03-13 09:43:34| 3.3| 0.0|ERROR |Microsoft SharePoint List Reader: Encountered an unexpected response from the server, reproduced below. Verify that the SharePoint server is either SharePoint Online or SharePoint Server 2012 or greater, and that the server supports the selected authentication mode2023-03-13 09:43:34| 3.3| 0.0|ERROR |Python Exception <AttributeError>: 'bytes' object has no attribute 'encode' Please help. THanks,Vivek 

Hi,When we try to convert dgn file issued from teigha in FME software, we have troubles with OdDgCellHeader2d cell name.it seems to be an encoding trouble. Teigha used UTF8 encoding and FME try to read an ansi string. Note that there is no trouble with the string linkage of the cell.We have post on the teigha forum and aidan.wessel have answer.We join a dgn file with two ERPTRL Cell, one dropped with teigha library and the other with microstation.inside microstation, we have no trouble. FME is not able de read igds_cell_name for the one dropped by teigha library.thanks for your answer,best regards,G. COSTAMAGNA

Hello, i have a list of files from an FTP server that I have read into a List. The last field in the list is the file name. The file name generally follows this format: "ProjectInfo_YYYYMMDD". YYYY is the four digit year, MM is the 2 digit month, and DD is the 2 digit day. I want to choose the one that matches today's date. I'm guessing this can be accomplished with the use of a user param or regular expression but I can't seem to find a reference on it. Any assistance would be appreciated.

I'm setting a variable via a variable setter as one of the first transformers in my workspace (after an sql creator) so I'm sure the variable is set.However when fetching that same variable downstream in the workspace in a custom transformer (or a custom transformer in a custom transformer).The value is empty. I'm pretty sure that the variable name in setter & retriever is exactly the same (see screenshots). I've tested it by setting the first transformer in my custom transformer to be the VariableRetriever, but the output is empty.I don't cache the data so it's not related with data caching. If I do a VariableRetriever in the main it finds the variable. When I do it in a custom transformer it doesn't find it. What am I overlooking? In other workspaces this works without an issue

I have a chain of workspaces (connected with workspace runners) and would like to set a few initial settings, from attributes, that are to be carried on through all the child workspaces, also in and out of custom transformers.Example: Say I want to fetch a scale setting from dataset Z, and then not use that source any more. This attribute can of course be saved to a separate "settings file" and be used in the child workspaces. But how do I set values on transformers that are not "naturally" connected to the settings file? I have been trying to get user User Parameters to do the job, that works sometimes, but requires extra steps in custom transformers. And sometimes I can't get them to work at all.What is the best practise in order to get this working? And what are the unintuitive settings that one needs to know about beforehand?

Hi, I am writing to a Non spacial SQL Database, using a FeatureWriter.When INSERTing new rows in the table, a UniqueID is created by SQL database.Is there a way to retrieve that UniqueID after INSERT completed sucessfully ?I would need the UniqueID for the next step of my Workbench.I do a SQL Executor to select the last inserted row, it will work, but, if multiple rows are inserted simultaneously, there is a chance that I won't get the right UniqueID. Any Idea ?Thank you.

ho un dato vettoriale in cui per ogni entità ho diversi valori e devo prendere il dato con il valore massimo

I am making an HTTPCaller request that in return outputs key, I need to make another HTTPCaller request with the value of the returned key (e.g, if returned key = "Yes" value is 15225 | if returned key = "Male" it's corresponding value is 15222)is there a way to store an object on FME desktop to be used like _instance ?? I think it might be done using JsonValueMapper transformer

I apologize if this has been asked before but I couldn't find anything related.I have a csv with the following data:With no header names. And I'm trying to get the following:I'm not sure which transformer to use, I thought BulkAttributeRenamer could help me here but I can't manage to make it work.I appreciate all your help before hand.

I am trying to transform a the KML within a KMZ file to MapInfo format using gentrans. The following works in the CMD:"C:\\Program Files\\MapInfo\\Professional\\UT\\fme.exe" GENTRANS OGCKML "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\PARQUE1.kmz" MAPINFO "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\tab"  I have used FME GENTRANS GUI GENERATE_CMDLINE to generate a command line. If I run the result on the command line with: fme.exe gentrans <generated commandline> it fails. The command line I use is the following:"C:\\Program Files\\MapInfo\\Professional\\UT\\fme.exe" GENTRANS OGCKML "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\PARQUE1.kmz" "RUNTIME_MACROS,\\"KML21_LOG_VERBOSE,No,KML21_RASTER_READ_MODE,GroundOverlay,KML21_SCAN_SCHEMA,Yes,KML21_FAIL_ON_NETWORK_ERROR,No,KML21_DELETE_DOWNLOADED_FILES,Yes,KML21_TRAVERSE_NETWORKLINKS,All,KML21_MOVE_TO_KML_WORLD_COORDSYS,Yes,KML

Hi I just updated my FME 2021 to 2022.I opened a workbench to make jp2000's from geotiff tiles. We use this wb very often. When I open this wb in FME 2022 I can update the clipper and rastermosaicker transformers.When I run the wb I get an error that some geotiff tiles have 3 raster bands and some have 4 rasterbands.I used rasterselector to select the first 3 bands followed with the rasterbandkeeper, but the wb gave the same error. Then I used rasterselector to select the fourth band followed by the rasterbandremover. Then some tiles were outputted as rejected. When I don't upgrade the clipper and the rastermosaicker everything works just fine... Maybe it's because I just updated to a new version and my pc's need a couple of restarts for things to settle down... I already purged the temp files.    

Hi,I am creating a table in Oracle SDE with FME. Is there to uncheck the Allow NULL property of a field via FME Desktop? Or even a way to uncheck it after the table is created with FME within ArcGIS Pro Catalog? See screenshot below. Thanks, Annette

Is there a way to automatically set the datetime within a parameter and use it to fanout a dataset so that does not then create a folder for every minute the workspace was running.  I just want the initial date time the workspace was run. The default date time parameter is not really ideal for this as it defaults to midnight and requires user input. I'm hoping to not have to use a workspace runner. Using DateTimeNow seems to create multiple folders as the outputs are written.

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc.   Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'