FME Form

I'm trying to write data to a csv. I have a uniqe identifier that has two leading zeros. When writing to a csv file the zeros are removed. When viewing the feature information window the attribute has a string value. When doing the same in the written csv it says 64 unsigned integer even though I have set it to string in the writer parameters. What am I doing wrong? Making sure FME writes it as a string will keep the leading zeros right?

"" Error connecting to PostgreSQL database(host=, port=, dbname=, user='postgres', password=): 'could not connect to server: Connection timed out (0x0000274C/10060) ""  How do I get FMe server to connect to my PostgreSQL db stable every time ?

I am trying to get from a table like this example:to this table:I have searched for answers but can't fully seem to get where I need to be- including trying variations of attribute transposer, attribute exploder, attribute exposer, and attribute pivot (this helped me get closer to the answer but didn't allow for text..). Any advice would be much appreciated!

Find the points on a polygon that are perpendicular to a line as in the screenshot.Existing features are the polygon(s) and line A. Pts a and b are required.Thanks very much for any help and ideas.

Hello FME community, I am currently working on a deep learning project that involves preparing training samples for building polygons.  I have the building polygons in an OGC GeoPackage file with Coord.System EPSG: 26916, as shown in following screenshot:  Additionally, I have the PNG aerial images for the same area without projection, which means every aerial image X,Y starts from the upper left (0,-0) and ends at the lower right (2000,-2000) as shown in following screenshot: I need to have the polygons of the training sample in pixel coordinates for each corresponding image. The output should be a CSV file that includes the vertices of every polygon in pixel coordinates as shown in following screenshot:  I have attached the datasets for better understanding.Does anyone have any ideas or potential solutions?

How can I convert a Multicurve geometry type to multiline geometry type?

Which transformer to use to count the number of joint between connected overhead line and underground cables in ArcMap?

Hi everyone,  I have DWG files drawn in local coordinates and I need to transform them to shapefiles in a national projected coordinate system. This is currently done with Spatial Adjustment (Transformation - Similarity) as the links file (.txt) provided has two displacement links:  -1000 -1000 "Destination X Value" "Destination Y Value"1000 1000 "Destination X Value" "Destination Y Value" p.s. I've just replaced actual numbers by "Destination X Value" etc.  What would be the best way to replicate this process with FME? If it is Affiner how do I utilise the values from the links file?  Thanks in advance!

Hello,what are the options for converting Excel data to XML, please? Can you provide me with multiple options (easier/more complex)? Is it possible to show me a graphical representation or even send a file directly? The problem may also occur with the XML file format, but I would address it by using an XSD file. Thank you very much in advance for your help.

I have created a workspace, successfully ran it in FME Desktop. I published it to FME Server. I built the schedule.  I have admin rights to all the servers. ​The workspace reads from a File GDB on another server and writes to a File GDB on a different server. In FME Desktop I am able to make connections to the folders which these GDBs reside. All paths are UNC paths. ​When I run the workspace on FME Server, I receive these errors:​632023-6-30 16:27:10 | Geodatabase Error (-2147024891): Access denied.642023-6-30 16:27:10 | Could not open File Geodatabase dataset `\\\\myserverBob\\folder5\\thtestfmeserver\\test2.gdb' for writing​The Reader reads from this File Geodatabase: \\\\myserverAnn\\folder1\\folder2\\Staff Folders\\folder3\\th_fmeservertest1.gdb​The Writer writes to this File Geodatabase:\\\\myserverBob\\folder5\\thtestfmeserver\\test2.gdb The Workspace I published from FME Desktop is for testing (since I am new to FME Server), it includes a single reader, TimeStamper Transfor

I have a process I need to run on point clouds. In short, I tile them, sort the tiles, and remerge the tiles back into a single cloud. This is for compatibility reasons with a piece of software that doesn't like clouds that are not well-sorted spatially. The workspace is fairly simple; input, tiler, sorter. pointcloudcombiner, output. It works well and does what I want when run on a single input cloud. However, I need to run it in bulk on large numbers of clouds. And performance suffers. I realized this was because it was tiling every input cloud before sorting them and assigning them back to the combined clouds, so I added Group Bys. Then I changed the group bys to "Process when group changes" to keep the data moving. But each step holds another set of data "in process" when set that way. So instead of only keeping one cloud in memory at a time, it keeps 3. If I create a custom transformer of my steps and copy it as many times as I have input clouds, ea

Upgraded to FME 2023. When writing to SQL server database, Bulk Insert = 'Yes' results in features dropping and not writing to DB (even though the correct amount of features are listed in the Total Features Written message). If I set Bulk Insert = 'No', the correct number of records write to the DB but one of the nvarchar attributes is empty in the database. Everything looks correct in the final inspector prior to writing. This is using workbenches originally created on 2022.1.2.0, Build 22627. New version of FME is 2023.0.0.3, Build 23319. I reran workbenches on 2022 and it's working correctly

Can FME be used to start and stop a geocoding service? if this is possible I would like to create a workbench that does this on a schedule eventually using FME Server.  Can someone provide me some pointers on where I should start?

Hello everyone, I'm a beginner in FME and need some help. I'm trying to join (1:1) data from our datalake with an existing GIS layer. My goal is to append the result of this join nightly to another existing layer. I've attempted to use SQLExecutor to query multiple tables in the datalake and DatabaseJoiner to join the query table with the GIS layer, but it doesn't seem to be working. Any suggestions or advice would be greatly appreciated. Thank you!

The input-data are in e57-formate and we want to split them up into a huge amount of small pnts-files for using them in Cesium JS.We need a tileset.json-file for each pnts-file. There should be an overall tileset.json-file in an superior folder listing all children tileset.json-files. Each generated file (pnts and tileset.jsons) should not exceed a specific file size (e.g. 2 MB). We are using version FME 2023.0. Our workbench has an e57-point-cloud-reader, a PointCloudExpressionEvaluator, a PointCloudSplitter and a Cesium-point-cloud writer. The data are splitted by the attribute set in the PointCloudSplitter. How is it possible to get multilevel tileset.jsons?  We already created an superior tileset.json-file and many pnts-files. The problem in this case is the big size of the generated tileset.json. In another case many tileset.json- and pnts-file-doublets. The problem in this case is the missing tileset.json-entry-file.   

Dear All, Here is my issue with the FindString() function : I have the following string stored in user parameter value_to_test = "101,102" ; the attribute "ProgNum" contains values that range from 100-900 and I want to set a new attribute "FoundNum" to be = "true" when "ProgNum" is one the (comma-separated) values of value_to_test. As FindString(string,strToFind) should return the index in string that matches strToFind , I've tried the following expression :@FindString($(value_to_test),@Value(ProgNum))I have also tried the FindStringRegularExpression@FindRegularExpression($(value_to_test),@Value(ProgNum))None of the them is working ! Quite despaired I've also tried to revert $(value_to_test) and @Value(ProgNum) in the function call, but it does not work better... Does anyone have an explanation what it is not working and what I am doing wrong ?? Thanks in advance NB : I know that I could work with AttributeSplitter etc. but I would like to know why the FindString and FindRegularExpress

Good morning from Vienna!This might be quite an easy task for advanced fme-users, but I have not too much experience working with fme. I have a task to read ifc-files and use the ifc-space information and location for write to dwg-files. I have one autocad-block as a template to be placed into the center of each room. So my idea is to derive the centerpoint of the footprint of each room and use those xy-coordinates for the autocadblock-x and -y. I just can't find a way how to merge both datastreams... FeatureMerger-Transfomer? but what data can I join the two streams on?Thx for your help!

Hi, I have two datasets. Both are polygons. Dataset 1 is the area of a city minus a few areas within that are not relevant for this project. Dataset 2 contains houses as polygons. My goal is to create a third dataset of polygons of random size. The polygons have to be inside of the polygons of Dataset 1, rectangular (preferably not just squared), and within a random distance to the houses. Does anyone know a way to solve this?

Dear all,I am using a CSV reader to read my data from csv file. I have a column that contains almost only integer except 5 values, that contain a letter (e.g. 12a or 12b). Unfortunately the reader set the Type of this attribute to uint32, and the values that contain a letter are set to Null... So I loose this information...It seems that in older versions of FME there was possible to choose "Manual" for "Attribute definition" parameter. But I doesn't see this option in the 2022.1 version of FME.How could I do then to force this column to be read as a string ?I've seen that it is possible to specify manually attribute types in the FeatureReader, but could I use this transformer to read a file ? (I set the file path in the parameter, but I don't know what to pass in input, and the output is empty)  Thanks in advance for any help

I would like to manipulate whole ''column'' (list of attribute values) in a PythonCaller but I don't really understand how I can do that. For example in the example here below, I create a new attribute in `input` (=iterating over each each feature, right ?) ; what I am trying to do  1) in `close` : to print all unique values of the newly created attribute(WITHOUT iterating over each feature, so to work directly on the list of all attribute values that my data contain) 2) in `close` (or somewhere else) : to add directly a new attribute to my data by applying a function on the firstly created attribute (again WITHOUT iterating over each feature) Is it possible to do all these things in a Python caller ?  import fmeimport fmeobjectsdef processFeature(feature):    pass class FeatureProcessor(object):    def __init__(self):        pass    def input(self,feature):                progs_dict = globals()[fme.macroValues['VARNAME_DICT']]        all_prog_cols = list(progs_dict.keys())        all_

Hi, I will train a model to detect some objects based on aerial photos.For this I used these instruvtions decribed here:https://engage.safe.com/blog/2019/01/fme-does-computer-vision/After indicating the objets witch OpenCV I will preparte the data for training witch " RasterObjectDetectorSamplePreparer". Inputs are the source directory of the negative files and the annotation file. If I execute this I get an error: I don´t know what the problem !Does anyone have experience in this regard?

Based on the unit of "Find Your Way Around the FME Academy""Show Off What You Know""You've worked hard to earn points and badges, and your profile is the place to show them off. Click your profile image in the top-right corner of Trailhead and click Profile to see all the badges and points you've earned so far, and a breakdown of skills you've learned." However once I click the profile in the top right corner of trailhead, I can't click my profile to see the badges and points that i achieved.  Do anyone know the reason why please? Thank you 

I am new to FME attempting to take over support for Smallworld to Microstation translations; inspecting the existing file that the translations are using I am noticing red and yellow symbols that seem to indicate an error. Just looking for some clarification on what these mean and if this is a cause for concern. It looks like the writers are just not receiving anything for some of these attributes. Any information is appreciated. thank you.   

I have an Excel dataset. I am translating two time attributes named "Occurred_time" and "Reported_time" with this format:%I:%M:%S%p to this format:%H:%M:%S.Although it shows me the Preview Data, the result is rejected. I can't find what is the problem.

Emailer & AGO Online Connector: Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer' PythonFactory failed to load python symbol `fmepy_emailer.Emailer' Factory proxy not initialized All references and solutions found for the error message below were mainly focused on FME Server & Cloud. For us, the problem only occurs in the FME Workbench [2021+].  We did reinstall the Geo packages for both of the transformers, but no succes. Where can I find the factory proxy to set up? Or is it something else?  Thanks in advance for your help!