Best Answers

Heya FME specialists, another PostGIS question:As a start I have a PointZ PostGIS table created with a PostGIS writer in workbench.Next I have a very simple workbench to duplicate some PostGIS tables from the production server to my local server for offsite development / analyses:I use a PostGIS FeatureReader with schema and generic because I want to dynamically create a clone of the table which is altered (data AND schema) in production without having to update readers and writers. This works wonderful!The one problem I have is that the geometry column definition changes from PointZ to GeometryZ:Original:(  pkey serial NOT NULL,  the_geom geometry(PointZ,28992),  CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))Duplicate:(  pkey integer NOT NULL,  the_geom geometry(GeometryZ,28992),  CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))I double checked to make sure the Create Generic Spatial Columns parameter is unchecked. Do I need to change another parameter or do I forget a crucial step? I att

 Hello everyone i have polygons and there are points in them my question is how can i find the point with smallest value inside the polygon thank you very much to everyone in advance

I logged into FME Server several days ago and had no problems. Today when I logged in I get this message. Any ideas on a fix? (Our FME Server environment includes a Load Balancer between FME Server 1 and FME Server 2); I am logging in using the Load Balancer URL.

I’ve been building some automations in FME Flow with optional parameters (date or numeric fields) that can either be filled or be blank when run outside of an automation.  When I try to save an automation with one of these optional parameters filled in, it saves fine, but as soon as I try to save an automation with a blank optional parameter, it loads forever and doesn’t commit the change. As I've said, it seems to affect date and numeric fields.  Has anyone else come across this issue before?  Currently have 2021.1 (upgrading soon)

I'm just wondering if there's an impact on performance having multiple automations running constantly. They are triggered by a schedule within the automation to run once per day.

Hi Guys,I'm just trying to read my group content from arcgis online and do some query from "last modified date" on service level.Anyone know how we can read/convert this format? Seems DateTimeConverter cannot recognise it..  Thanks! 

After installing FME on my computer, all of my files have defaulted to open in FME. For example an xlsx will now open in FME unless I specify that it should be opened with excel. Any suggestions on how to resolve this issue?

Dear all ,  It's a hollow PIPE , I want to extract XYZ for each a) centre point (c1)b) face centre point (v1&v2) + face INNER vertex point (vf1&vf2)c) radius (e.g. distance from v2 to vf2)d) total length (e.g distance from v1 to v2)  thank you for kind support

I have different gdbs at different level in a folder.In each gdb there is the same dataset. I want to merge (usually with a junction) the similar datasets from the gdbs (all dataset has the same structure). But I not sure of what reader should I use:I use a reader with feature Type Name as "any schema".And Reader "PATH\\**\\*.gdb" Then I put a FeatureReader , but I cannot get attributes from all the dataset. Any Help will be appreciate. 

I created an FME Server role that provides read-only access to view FME workspaces published there (i.e. - Workspace Viewer). I would also like to add read-only access to view items under Schedules but only see options for Full Access or None for a role's permisssions. is there a way to provide read-only acccess to Schedules? We are currrently running FME Server 2020.1.2.1 (Build 20624).

Hello All,British National Grid Long/Lat (OSGB 36) [EPSG: 4277] seems to be missing from FME's suite of coordinate systems - or am I mistaken? I have a table with Longitude and Latitude data in this projection and I want to create points from them, and then convert them to British National Grid (Meters) (OSGB 36) [EPSG: 27700]. I can try to use the Reprojector transformer, but I can't see EPSG: 4277 anywhere.Is there anything which I could use instead? Or is there another solution such as creating a custom coordinate system?Many thanks,Jane

Dear All, I have the following setting : I've created a User parameter of type "choice" where the user can tick which attributes he wants to keep and send to the Writer (column1, column2, column3, etc.).  With the MultiChoiceParamSplitter followed by a ListExploder, I can get a table where the attribute "_choice_param_values" holds the attribute names the user has selected (e.g. column1, column3), but how can I use it then in the AttributeKeeper (or any other transformer that would do the job) ?  I've tried to pass the table as input with "_choice_param_values" as Attributes to Keep but it does not work at all...  Or maybe, from the outset, I didn't tackle the issue from the right angle and you have suggestions about how I could I achieve what I want in a totally different way around ? Any ideas are welcome, as I've run out... NB : I've seen the (seemlingly related) post below but it did not solve my issue.Having trouble passing user pa

I have a batch file (.bat) that I need to run. What Transformers would I need to use to get this to run using a workspace in FME Desktop?

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_versionThis 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

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  

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 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?​​

"" 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!

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?

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

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?

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

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_