Authoring

Hi,when writing using a dynamic Excel Writer (in my case there are no columns defined at design time - see attached screenshot), the font settings get lost in the output file and also in the Feature Type Writer itselfs when I double-check it.Has anyone solved this issue?Thanks! 

 Hello Forum, I’ve set up a simple workspace to convert a csv with eastings and northings (EPSG:27700) to a csv with long lat (EPSG:4326). This is working OK. The workspace is something I’m going to use quite often, so I’m keen to automate it as much as possible. Is it possible to automatically make the ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) the same as the input csv name. For example, if my input csv is called ‘Properties030225.csv’, then when this reaches the FeatureWriter the default ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) is ‘Reprojected’. Instead, I would want that default csv file name to be the name of the input .csv. In this case, Properties030225.csv. Yes, of course, I could type in Properties030225.csv in, but I don’t want to do that every time. Instead, I want it to automatically pick up on the input file name. How can I do this? Thanks,Stuart 

HiAttached is workspace what wrong with it, as I can't write the output in to feature class inside esri gdb. 

How to convert the neatest distances in neighbour finder to individual lines?

Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14|  2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an

Hi everyone,I have a question about the Reprojector. In the reprojector in FME Form, my desired coordintion systems are available:  But when I publish it to FME Flow, some of the coordinate systems are not available to select from: Could you please help me to solve the problem? Thanks!

I use FME Form in different environments for different purposes - on my local workstation (laptop) and also on our virtual desktop environment (VDI, Citrix, headed toward AVD). It was difficult to work across two distinct environments, first with workspaces, but further related to web and database connections.We have OneDrive on both, and while it may not be supported or advisable (but I’m interested to hear from Safe and/or from the community on this point), I have had no (known) complications due to using that for my workspaces and connections. If OneDrive is chatty, or you are concerned about locks or other issues, syncing can always be paused while working within Form.To get the connections working, in Form, I go to Tools, FME Options, Default Paths, and then update the Connection Storage with Database Accessibility: Shared, and set the Database Folder and Shared Key Folder to a location in my OneDrive folder structure. I did this in both environments. If there’s a better way to do

Hi,I need to set log file path as a parameter. So I ‘ve added User parameter LogFile and linked it to log file inNavigator-Workspace Parameters-LoggingI’m running my workflow as follows:"C:\Program Files\FME2\fme.exe" C:\FME\mz\WybranaSiecPomDgn2k.fmw --LogFile "c:\Folder1\File.log"The problem is, that “c:\Folder1” folder does not exists, and the following error appears:“Unable to open log file `c:\Folder\File.log'. The preceding error has occurred during FME logfile setupProgram Terminating”I was trying to create “c:\Folder1” folder using Scripting-Startup Python Script, but it doesn’t help, probably because FME tries to create log file before Python script execution.

I have a user parameter that I use when writing out the file in Form ("$(ProjectID) Report.xlsx"). This works as I want when running in Form, but not when I publish it to Flow. The parameter doesn’t get set a part of the filename (_Report.xlsx).Any ideas what I need to do differently to get the same filename in Flow that I get in Form?

I have a closed polygon dataset that I need to add angle labels to the internal angle.I just wanted to see if anyone has done a similar thing or has some advice on the best way.I am using the “VertexAngleCalculator” transformer which gives me the results for the actual angles but need to figure out the before and after lines to the calculate the position and angle of the label so it is just offset from the vertex and angled midway between the before and after lines towards the interior of the polygon. 

Does anyone have (or know where I can find) the workspace and sample data for the Travelling Salesman blog post from 2016 (or later)?https://fme.safe.com/blog/2016/11/fmeevangelist158/ ThanksDavid

Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!​​​​​

Overwritting .shp files gives mixed results so my workaround is to delete the .shp file(s) first and then create the new version.  But I can not figure out how to do that --I read somewhere that writers have a ‘delete’ setting for the ‘fme_db_operation’ parameter but I can not locate that anywhere.  Can anybody tell me if FME has the ability to delete the .shp files in a folder?  Thanks!  Lewis

Hi all I am trying to compare two databases which contain similar and different geometry files. I am trying to figure out which geometry's are the same and which are unique to each database.   A few big issues I have is the complex of the geometry and even the SAME geometry's has been captured slightly differently; even thou it's of the same area.I also have no data to help identify which geometry's are the same.Example of 2 similar complex geometry's - zoom in to show compilation differencesI am currently struggling to figure the best solution to my problem, the geometry can be complex with donuts and multiple areas representing the “same” geometry. I can't find the sweat when I simplify the data enough to get a match and not corrupt the data too much that everything matches. I have added two SHAPE file, containing 7 Features each, with 6 that should match and 1 that should not.Any help or ideas would be appreciated

I am getting this error with the HDF connector, it seems imp was removed in 3.12 which ships with FME 2024, it seems IMP is deprecated in python 3.12  that ships with FME, would a repoint to a custom python interpreter of 3.11 fix this issue ?  or any other thoughts  2025-1-21 12:20:37 | Message Type: fme::internal::_v0::py::Exception 59 2025-1-21 12:20:37 | Python Exception <ModuleNotFoundError>: No module named 'imp' 60 2025-1-21 12:20:37 | PythonFactory failed to load python symbol `hdfsconnector.hdfsConnector.HDFSConnectorFactory'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date

Hi all, I’d like to classify polygons by shape, these might include: pie shaped, L shaped, T shaped.I was originally thinking that I’d have to convert them to raster and use some sort of supervised classification. Another method might be to convert them to centerlines and compare their linework: a T shape polygon would have 1 or 2 lines at the top, meeting at 90degrees to another line point downwards

Hello all, I would like to create a simple FME workspace in which PostGIS writer automatically reads attributes from the reader and adds an attribute with PrimaryKey (there are 30+ feature types in total). Is it possible to do it somehow?  I have seen and tested this method:postgresql - FME PostGIS writer define column as serial/PrimaryKey with pre-existing id values - Geographic Information Systems Stack ExchangeHowever, the goal is to set up a straightforward process with automatic attribute definition. I would really appreciate it if you could share what methods you use.

I am using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) - FME Forms.When running a workflow with the Data Inspector, from a file geodatabase with the SpatialRelator, the workbench appears to change coordinates on the fly. The dataset is in British National Grid (EPSG27700) with an expected data format of XXXXXX.XXX YYYYYY.YYY (depending on decimal places specified, ESRI being 3 decimal places resolution in metres).  An example is 283400.7988999998 377644.82890000001.However, inspecting the output, within the inspector attribute table and the feature information windows, this is replaced by an arbitrary grid XX.XXX, YY.YYY. An example is 66.069000000013411 97.342000000017881.  (These examples are different points). This doesn’t appear to be any projection or coordinate system with which I am familiar in this area and seems to be an arbitrary grid. Finally, when I click a point in the Inspector visual preview window, the coordinate system restores itself back to EPSG27700. This sol

FME Flow 2024.1 Is it actually possible to terminate a workspace that contains a JMSReceiver? I have a workflow set up and a terminator is triggered if certain conditions are met. This results in a Program Terminated and Translation Failed message in the log file but the workspace is not actually aborted and has to be manually stopped

I have a workbench file that generates the raster created by the QRCodeGenerator. So I have two output streams, the raster itself from the data stream and the PNG created by the PNG Format writer. Each QR code has URL data with dynamic parameters that can open an AGOL feature using the Camera app (Ios) or Google Lens app (Android OS). I’d like to extend this use case futher to include generating an email using the QR Code as a clickable image that opens the URL data of the QR Code.  The way to accomplish this is make the email in HTML with an HREF link to the QR Code PNG sent from that email. My challenge is how to create this email with Custom HTML that will make this picture an inline image on the email and not as an attachment or a reference to a picture stored from another server. Hope I can hear out out some suggestions or snippets of Custom HTML that will create this HTML email with the HTMLReportGenerator transformer. I do not have FME Server so I’ll have to use Form Emailer tra

Hello! I am currently trying to convert the CityGML models into FBX format using the workflow below.However, it was found that the absolute position of the FBX generated would be 100 times less than the original model. Therefore, I added a Scalar transformer in my workflow. There isn’t any problem in display but the relative dimension value would be multiply by 100 as well. The enlarged dimension could not be visually observed even being compared with other normal objects but the dimension value would be 100 times larger. (Not sure if I am describing the issue clear enough)Moreover, I also found that the Aggregator transformer at the end was not actually grouping the surfaces as one surface. They were just grouped under an object where this object was not a geometry. I tried the Surface Dissolver to merge the surfaces but in vain. If I don’t group the surfaces together, they will be exported as a series of Surface Member which would be difficult to manage during viewing.Therefore, I at

I have set up an automation process that retrieves information from an API to generate a report. However, this task has become complicated because an essential piece of information we need to include in the report is located in a different API, which requires an ID to access the relevant data.I am considering generating the report first, which will consist of the necessary IDs. Then, I plan to make a second API call to retrieve the information from the second API, one ID at a time. I have successfully completed the first part, but I am now stuck on the second part and unsure whether this can be achieved using FME or if a Python script is the only solution.

I think what I’m trying to do should be pretty straightforward and that I’m just missing something obvious, so I apologize if this question is not great …I have a workbench that uses sqlcreator to connect to some data in my db. I do a few transformations and then finish everything up with an excel writer. I’m having an issue configuring the excel writer correctly. 1.New records are being added to the db, and I occasionally need to rerun the workbench. I want the new records to be appended to original excel output. 2.Also in between runs, I am writing notes and other relevant information in the excel sheet on empty columns I created in the workbench. I want to keep the text I’ve written.The first time I ran the workbench I had the writer configured to INSERT. No problem. I thought I simply needed to change it to UPDATE and it would start to append new features to rows below the original, but instead I get an error because I don’t have a field to put in the Row Number Attribute field. I

Hello there how could we find the closest road facing  the Building  from the North, south, Est and West the ides is to take each side of the building  check its facing what direction and then towered that direct we should check the closest road we can see from that building side  we are expected to get this result  each color represent the relation​​​​​​​I am attaching this sample data for referenceThanks​​​​​​​

Hi,I think this question has been asked before, but the links in its answer were broken so I’m unsure what the answer was.If anyone is able to put me in the right direction that would be greatBasically I have a complicated workspace doing a few things on large files. In order to make it more efficient I would like to know if there is a reasonably easy way to get a rough indication how long each individual transformer was running in total. Then I can get an idea of where bottle necks are, or things I could improve.Currently I just look through the log to see if something takes a while, but that's tedious. Is there a better way? Is it possible to get some sort of summary how long each transformer takes to run?I do run the workspace on FME server/flow, though I do test it locally as well.Thanks