FME Form

When using the schema mapper and connecting to a postgres table and choosing embedded connections there are no options to choose a parameter that holds the relevant value. For host, port, database and username, I'm able to type e.g. $(STAGING_DB) and create the link to my user parameter that way. However this doesn't work for the password field.Is there any trick to link the password parameter?  (FME 2021.2.0.0 Build 21784)

FME version 19.1.2Warning message: Cannot define schema for 'test' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration.Error message: XLSX Writer: No DEF line could be found for feature type 'test'. If you are using dynamic schemas, ensure that the fme_feature_type attribute exists on the incoming feature and corresponds to a valid feature type definitionWorkspace included below (I've tried 1 query now, but I'd like to add multiple using a conditional value for the sheet name)

In the JobSubmitter (and DataDownload etc) service you can have the body of your POST request be treated as an input dataset.  I'm trying to run a bit of a post process to create a summary of the previous job and as part of that I want to be able to access the file saved on FME Server. I can see the file in /system/temp/requestdata folder but I can't figure out how to get the actual file name for a given job.  The only place I can see this is in the actual job log which I really don't want to have to parse.  each file has a prefix which looks to be some number which is increasing overtime so I'm guessing it's related to a timestamp.  Anyone know of a way to know which file goes with which job?

In my colleague'script there is an ArcGISOnlineConnector and my colleague made a parameter of the password for the ArcGIS Online connection.At FME Server, we first filled in the parameter for the workspace and made a testrun. The script ran and it works. However when I make a shedule of this script, fill in the parameters, after triggering once, then for some reason the value of the password gets the following string (see image below). I am not sure why that happens. Then I change the value to the correct pasword, however after triggering the schedule, the password changes itself again into that long password, while this long password is not defined in the script itself. Since the password is not correct, the script will fail since no connection can be made with ArcGIS Online. Does anyone might know why this happens and what I can do to get the original password all the time instead that it changes itself after running once succesfully.

Hello everyone! I'm trying to combine the components of two point clouds from their x,y,z coordinates but they never match 100% of the points... The help of the tool says that it may be necessary to round the coordinates but the transformer "pointcloudexpressionevaluator" does not have the "round" function... How could I round the coordinates of the x, y, z components to match and match? I would really appreciate any kind of help. 

Hi all!I want call a soap service in FME. I use this link:https://swea.riksbank.se/sweaWS/wsdl/sweaWS_ssl.wsdlI used the program SoapUI to generate and test the xml request. In SoapUI the return works fine. This is the request I use:<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://swea.riksbank.se/xsd">  <soap:Header/>  <soap:Body>     <xsd:getMonthlyAverageExchangeRates>        <year>2022</year>        <month>1</month>        <languageid>en</languageid>     </xsd:getMonthlyAverageExchangeRates>  </soap:Body></soap:Envelope> 

I'm trying to calculate the county left and county right of a road centerline based on it's direction of digitization and position within or along county boundaries. Someone had suggested the TopologyBuilder transformer but I must be doing something wrong. The right and left face fields are <missing> on the centerlines edges but not on the edges that were converted from polygon. I hope this makes sense. I'm using the same projected coordinate system on both datasets and the roads were split at the county boundaries in a prior transformer (LineOnAreaOverlayer). Please help! I've been at this for some time now.

Hi, Is Longitude and Latitude information being necessarily for FME to work?

Hello, I have a dataset of addresses (points) and another dataset containing the hospitals (points).I have a dataset for all the roads in my study (line).I would like to know which is the closest hospital to each address by the road (not Euclidean) and get the distance. I tried with "shortestpathfinder" but I have to put a line as input, which I calculate with "Neighborfinder", but it gives me the shortest euclidean distance and not by road. Thanks

I'm new to FME and want to create a workbench that translates 3D data to zero. I have IN (reader) -> CenterPointExtractor -> Affiner -> OUT (writer). Within Affiner have: 1, 0, @mult(@Value(_inside_x),(-1))0, 1, @mult(@Value(_inside_y),(-1)) I've tried a bunch of variants of this but am struggling to get the data to move to zero. Workbench attached. Thanks for the assistance.

Hello, I wanted to share training resources with some new people at my org, but I'm getting an internal server error on your website https://engage.safe.com/training/live-online/

Hi,In Postman:I have setup a POST request to https://xxx.com/loginIn Body as form-data or x-www-form-urlencodedusername:user@test.compassword:Test123And I get my response back OK In my httpcaller I am setup like this : But now I got a server error, just like my request is malformatted, as you see I even tried to put the form data into a specific attribute instead of passing directly inside the httpcaller. I got a feeling that fme httpcaller is having a problem with the "@" in the username, because in cURL I would put username in double quote to make it work just like :

Workbench is S-57 .000 files to File GDB. I only want to write Soundings that meet that meet the criteria SORIND where it's equal to US,US,graph,Chart * (for any chart number). Is this the correct transformer, syntax etc: 

I need to export the Data Model of our entire Geodatabase for an external consultant without the Data and it needs to vendor agnostic format (cant export an Esri XML Workspace for example). In the past I used a package call Geodatabase Diagrammer but it is no longer compatible with current releases of Esri let alone Pro. I was hoping to get some tips on how someone would be able to use FME to do this. I am hoping to be able to produce an XLS with a tab for each featureclass that lists the fields in one column, data type in another, field length, alias, perhaps domain. Any tips would be very appreciated!

I am trying to find a way to identify the date when the workspace was run in the resulting Bentley files. According to the end-users, that can be specified in the file description.  Is that the best practice? If yes, how could I add the description from the FME DGN V8 writer?  Any pointers would be greatly appreciated!

I encountered a strange color overwrite behavior while writing to Bentley files. Namely, I am taking colors and styling by level from the seed files. These colors are specified in RGB. The resulting DGN file has colors in hex. Is there a property that sets this? Issue with the seed file? Attached is the workbench with the writer with the current properties as well as the resulting DGN file. Any pointers would be really appreciated!

I have some polygon features. Imagine one has area 100 units. Now I want a polygon having area 30 units to be split from this. Similarly I have many polygons and a list of areas. How do I split a polygon into two based on area?

I am translating a group of point objects at different rotations from Smallworld to Microstation V8i. The same object in Smallworld and using the same FME translator. The resulting DGN has different size cells to represent the same object. The point objects that are at 0, 90, 180 or 270 are the correct size when translated but other angles translate larger. I am open to any ideas on why this is happening and what can be done about it. Thanks

Updating a GIS Layer in a database that is using Branch Versioning from a GIS Layer that uses traditional versioning. The branch version feature service that I am updating is set to a specific version where I am not reconciling or posting the results to default. I set the Feature Type Handling to Truncate existing and feature operation to Insert. The branch version layer is not truncating, and I am getting a duplicate record result instead of a single set of records. It appears that it is not truncating. I am also Getting the following errors : ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '' and the message was: 'Could not access any server machines. Please contact your system administrator.'. Details: ''ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details

Where can I locate data for posted tutorial on the website so as to use it for practicing purpose. For example, I want to do hands on training on common GIS operations on this link https://community.safe.com/s/article/area-and-distance-measurements.

I have a Survey123 form, that needs to be exported to a specific excel template file. The Survey123 form has 1 layer (parent record), and two related tables associated with that single record. The final format for the excel template would need to be 1 file per record, with two sheets (from the two related tables). Prior to exporting out to the template files, I would need to filter the data down by a site name For instance, a site (that I have filtered down to) may have 4 records taken on it, so I would need to create 4 separate excel files, based on a Plot ID field. Each on of these excel files would then have 2 sheets based on the related tables of the record. Open to suggestions and comments. Thank you!

Does FME support writing a hierarchy of layers to GeoPDF? I can't find any documentation on how to do it.

I am working with conductor line segments and need to establish a parent child relationship between these lines. For example I would like to assign conductor "2" a parent value of "1" and a child value of "3". Has anyone accomplished this task or have an idea of how to go about this?

Hello I'm doing a spatial join between a polygon layer and a point layer. For polygons that are "passed" I want to retrieve the attributes of the corresponding points. Wich transformer should I use ?Thanks