FME Form

I have two SQL Server spatial tables (one containing current records and one containing archived records) that I need to merge and read the features ordered by their version number in order to do onward processing in FME. I have been trying to use a SQLCreator to read these records into FME in the correct order using SQL similar to the below: Select a.* from( SELECT [fid] ,[toid_version] ,[SHAPE] FROM [dbo].[a_boundaryline] union all SELECT [fid] ,[toid_version] ,[SHAPE] FROM [dbo].[boundaryline] ) as aorder by a.fid, a.toid_version This SQL works in SQL Server management studio without issue. However, when I use it in a SQLCreator (or SQLExecutor) I get the following warning(s) in the log and the geometry is not read (i.e. features have no geometry): --- Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT * INTO #fme_tempAdoDataTypeTable_spatialReader FROM ( Select a.* from( SELECT [fid] ,[toid_version] ,[SHAPE] FROM [dbo].[a_bo

I am trying to set up my anaconda environments in FME, using the custom interpeter function. As interpeter I selected the .dll file (C:\\(...)\\anaconda2\\envs\\gdal\\python27.dll). This succeeds in recognizing Python and having a basic setup. However, my packages are not included. Trying to import geopandas, which works fine in my Anaconda editor, results in the following error in FME: Python Exception : No module named geopandas 2018-12-04 12:50:20| 0.5| 0.0|ERROR |Error executing string `importfmeimportfmeobjectsprinthelloPieterimportossys#sys.path.appendrC:UsersfvzfAppDataLocalContinuumanaconda2envsgdalpython.exeimportgeopandasasgpd#fromrasterstatsimportzonal_statsprinthelloPieter#TemplateFunctioninterface:#Whenusingthisfunctionmakesureitsnameissetasthevalueof#theClassorFunctiontoProcessFeaturestransformerparameterdefprocessFeaturefeature:printhelloPieter#TemplateClassInterface:#Whenusingthisclassmakesureitsnameissetasthevalueof#theClassorFunctiontoProcessFeaturestransformerparamet

I am new to FME Server. I have a workspace that I published to FME Server. It reads from an Excel spreadsheet, and writes to a File Geodatabase and Access Database. The data for the reader and writers reside on separate servers, they are not loaded into FME Server. Can someone take a look at the screenshot and let me know if the Published Parameters are correct? I seem to recall that for the spreadsheet (see red arrow in the screenshot), does there need to be a parameter added to replace the UNC path? What you see in the screenshot is how the workspace was published into FME Server from FME Desktop. Do I need to add the UNC paths shown in the screenshot as Resources? Can someone explain or point me to a link that explains this process? Can I keep the UNC paths for the File Geodatabase and Database Path or do I need to replace these with an FME Parameter as listed here: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/!Transformer_Parameters/FME_parameters.htm

Please can you tell me how i do this?

Hi! I have encountered some difficulties as I am trying to check whether certain microstation files contains empty levels. I've studied the feature-reader for Microstation datasets, but I cannot find a way to read empty levels but only levels that has content within. My hypothesis is that the feature reader outputs all the levels that is associated with a feature, and hence, misses the empty layers. For Autocad files, I had the same issue initially. However that was solved by using a Schema (Any Format) - reader on the Autocad-file dataset and hence reading all the layers as fme-feature-types. Any ideas?

Hi guys, I am still learning FME and have made a few workspaces which are working well for me however I am doing a merge with a SQL non spatial and a mapinfo tab file and am trying to make an end result of the poly's having no fill or patterns, just an outline and being transparent. I have tried many things, the closest I have gotten is creating the attribute mapinfo brush transparent and setting to True, and if I create a pattern with Mapinfo styler the transparency works - obviously with the pattern though, I have tried doing an attribute expose and remove for the mapinfo_brush_background and foreground. Sorry I have been trying to do this for a couple of hours and tried all sorts of combos but just can't get it. Thanks in advance Garry

I need to do a transformation, like pivot table, using Python, and for that I would need to install libraries, like "pandas"... How can I install custom libraries to FME Python ? I created a environment with Anaconda, installed pandas there, but now, how to use that environment in my PythonCaller?

I am trying to mosaic 228 ECW tiles into one uniform image using RasterMosaicer transformer. The individual tiles are quite large as the 228 individual tiles together are 15GB. I am finding the process using RasterMosaicer extremely slow and is taking close to 24 hrs to complete using FME desktop. Just wondering what the best method is to mosaic these tiles and have a resulting image equal to the size of the individual input tiles, 15GB...or less.

I'm having trouble removing buffer segments correctly when generating a buffer around a line dataset with roads. Input data (road lines with road name and city): When buffering this, I end up with: This method has a lot of overlap that i'm not able to process properly. Is there a way to buffer it like this or process the _overlap >= 2 in a way that this is the result: I tried the areaonareaoverlay and correct the overlap afterwards but did not get the desired result.

I have 3 workspaces; they need to be run like this: ​ 1st to be run is workspaceA, 2nd to be run is workspaceB, 3rd to be run is workspaceC. ​ I know in Scheduler I can set each to run for example: ​ workspaceA runs at 905p, workspaceB runs at at 910p, workspaceC runs at 915p. ​ But, this approach poses a risk that if workspaceA fails during its run, workspaceB and workspaceC will still run and that could corrupt my data. It seems more prudent that if, for example, workspaceA fails to run that workspacesB and C will not run. ​ What is the best way to deal with this situation using FME Server? ​ Should I create a new workspace using FMEJobSubmitter Transformer or add FMEJobSubmitter Transformer to the workspaceA, B, and C? ​ ​

When using a FeatureReader to read CSV file, one can manually select in the "Parameters" section which attributes we want to read from the file. Very short question : does something equivalent exist for reading only a selection of attributes in a reader that loads "Esri ArcGIS Portal Feature Service" data ? Thanks in advance

Dear All, I am facing the following very weird issue. I want to test for several attributes if, for each of them, there are some features that contain a specific value. To do that, I have created a Custom Transformer that takes as input 2 user parameters (defined exactly in the same way, published and required) : 1) colname = the name of the attribute ; 2) progname = the value to test if the feature is equals to. When I go back in the Main, right-click on the custom transformer > Properties, in the prompt I can see well the 2 user parameters (colname, progname). But when I click on "Run to this" custom transformer, the prompt only asks for 1 of the 2 parameters (always 'progname', even if I switch the order of the parameters in the parameter manager of the custom transformer). In the Translation log, I see that the following command line is run : fme.exe myscript.fmw This results in translation failure with the error message : Undefined macro `progname' dereferenced in file [...] When

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 Tran

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, each runs one at a time and the ov

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?