Best Answers

HI, I have a gdb with a lot of feature classes and I need FME to search thoroug the content of each layer and give me the list of all attributes from each layer that meets certain tester requirements. I was thinking of usint Attribute Validator but the content of the gdb will be changing hence adding attributes manually to each tester is going to be very time consuming. I need FME to search thorouhg the content of each layer saved in the gdb and give me the attributes 

Hi,I am converting a Civil 3D DWG file to GDB. However, once I read the DWG file, the colors appear to be changed to black and white. I attempted to use DWGStyler, but the colors are still not reverting to their original state. I've checked the Reader Parameters to ensure that "Resolve Entity Color" is selected. Could someone please assist me?1 more thing that I found is that, once I use autocad_color or fme_color in DWGStyler the values disappear.  Thanks in advance

Hello, Is the result of the function @uuid() the same as the transformer UniqueIdentifierGenerator ?I would like to create directly an UUID in an attribute creator instead of using 2 transformers (UniqueIdentifierGenerator and AttributeCreator). Thanks.  

I am trying to pass custom Python Interpreter and Python Home to a batch script. The batch script then triggers a FME workbench script. Here’s the commands I am using in the batch script: set NEW_TIME=%TIME: =0%set LOG_DATE=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%_%NEW_TIME:~0,2%_%NEW_TIME:~3,2%SET path=<path to log directory>SET filename=%path%batch_log%LOG_DATE%.txtecho ************* Started FME Update ********** > %filename%echo.>> %filename%echo.>> %filename%echo Time Stamp: %DATE% %TIME% >> %filename%:: activating clone python env which contains all the dependencies for the PythonCaller referenced in the Workbench scriptcall "C:\Program Files\ArcGIS\Pro\bin\Python\Scripts\activate.bat" arcgispro-py3-clone >> %filename%:: Use custom Python set to true"C:\Program Files\FME\fme.exe" APPLY_SETTINGS SYSTEM "Python/Use Custom Python" true >> %filename%:: Use custom Python Interpreter. Directory: "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro

I am learning how to use Keys in Automations. I have created a Global Key (see screenshot below). As viewed in the text editor, is there a way to make the text “Automation Name:” bold or change its font? 

Hi all, I have a layer with multiple polygons sharing a specific attribute (Area_ID), and they are spread with no geometry among them. Multipart polygons sharing same attribute value.Then, I would like to know the way to identify the area that could be filled considering the vertex points that can make up a border.Area between multipart polygons that need to be filled.Finally, the need is to merge all of the multipart polygons into one, without moving those multipart from the coordinates they are now, just filling the space between the polygons with the same attribute in common.Any thouhts? Thanks a lot!

Hi!I would like to get all database connections and additional information (e.g host, service name, username etc ) from FME REST API. I know that I can get all database connections with this request:https://FMEServerName/fmerest/v3/security/categories/NamedConnections/resources?limit=-1&offset=-1 it gives owner, display name, permissions, name, but not connection parametes. Is it somehow possible to get connection parameters as well? Thanks!

I would like to create an Excel list from our GetCapabilities document, where all our wms services are listed.Some of our services are grouped together and I don't want to list these group layers, just the lowest level of layers.The list should include name, title, abstract and metadata link (xlink:href).I have searched the community for examples, and although there are many questions about XML, I have not been able to apply these solutions to my problem and thus create a list.I probably have to use the XQueryExtractor to find the desired layer elements, but I am not able to insert the XQuery expression (Layer[child::CRS]).URL: https://map.geo.sz.ch/mapserv_proxy?SERVICE=WMS&REQUEST=GetCapabilities&lang=deAny help will be appreciated!Thanks in advanceVera

Hi Team, I am trying to create workspace applications in a newly installed instance of FME Flow 2023.1.1 (has to match our Form version) and when creating Workspace applications I can no longer select the "User can Upload" option on any newly created workspaces. If I select workspaces a historic workspace (brought in via backup from 2022) the option is there.  The only thing in changed in between screenshots was selecting a different workspace (same user, repository and service)Any ideas? All help appreciated 

Hi,we connected from FME Desktop 2022.2.5 successfully to a Azure Synapse SQL Pool using the "Microsoft Azure SQL Database (JDBC)" connection. I can use the Reader without any problems and query data from the tables. However I need to use SQLExecutor Transformer as the queries need to be dynamically created. But this gives me the following error:com.microsoft.sqlserver.jdbc.SQLServerException:  '@@TRANCOUNT' is not supported.Seems like the SQLExecutor performs additional statements in the background which are not supported by Synapse. Are there any workarounds to avoid this issue or to force SQLExecutor not to use additional statements?Thx for your help! 

I have a csv-file containing WKT's, and I want to use GeometryReplacer. However, I want to remove the z-coordinates in the linestring. The linestring is formatted like this:LINESTRING (252388.4 6630392.1 39.726, 252360.1 6630378.5 38.626, 252350.3 6630372.4 38.626)What's the fastest way to do this in FME?  

HiI am creating an automation in FME Flow.My first workbench looks at a SQL database and extracts the most recent date/time. I would like to use this value to feed in to the Where clause of an Oracle reader in a second workbench so I can extract all records greater than that date/time without having to read all the records in. However, I cannot find anyway to pass the attribute value of the first workspace to the second. Im sure I read somewhere that this was possible using parameters with workspace runners in Form?    

I have created a geojson file from nine features drawn from a postgis database. I have tried all the examples from the community pages with no success. Can anybody point me in the right direction?

Hello everyone,Is it possible to connect to a cloud (PIX4Dcloud) where point clouds are stored, so we can download for exemple files automaticly with FME ? Thank you

@ReplaceRegularExpression(@Value(DETAILS),<.+?>,,caseSensitive=FALSE), @ReplaceString(@Value(DETAILS),&qout;,",caseSensitive=TRUE) The first expression replaces any text in details attribute that is bracketed with <> to be deleted.the second expression replaces any instance where &qout; appears with “.These work fine as separate transformations, however when trying to lump them into a single statement in attribute manager’s text editor the transform fails.I’ve tried comma separating, spacing, and barring the functions, but have had no luck. Any suggestions on how to get this to run? Thanks!

I posted this Thursday, but apparently it hasn’t been ported to the new system, so here goes again: I have a job that harvest a number of data layers via WFS. As of late, the job has been throwing an error, when reading a particularly large dataset.I've tried to retrieve the same dataset as an XML (GML) file using HttpCaller, and the resulting file is 452 Mb.The error says something about "message: comment or processing instruction expected", but it points to the end of the very last line of the data file, and the data file syntax seems ok.So I'm wondering whether I've hit a limitation in the WFS reader ? E.g. a limitation in downloaded file size ?For now, I've split the original FeatureReader fetching 5 layers at once, into 5 FeatureReaders each fetching a single layer. I'll see if that solves anything tomorrow.Using Desktop 2022.2.6 and Server 2022.2.6Cheers.Ps!It would have been nice to have had a checkbox "Read layers individually" and keep the complete layer list, instead of havin

Hello,I am using the String Concatenator to join two fields and separate them with a comma.However some fields are blank so I end up with some records that contain a comma only and others that contain a comma and then the value of one of the fields.My current setup looks like belowgenerally works well, except for some results like theseIs it possible to modify existing Transformer or is a different one more suitable?My only other thought is to perform some sort of trim on an other transformer after this one to remove first character?Thank you

Hi, I would like to have attribute values in one of the attribute tables in Shape file.Attribute value should be as shown below. How do I get the 

I have a dozen files in a folder. I was able to use the Path Names Reader to write the File Name, Upload Date, Upload Time, and File Size to the CSV Writer.  Does anyone know how, or if it is even possible, to get the name of the user who copied/uploaded a file into a folder? I see in the Pathname Reader the path_ownername attribute, but all this has in it is the value “Administrators”, no user name. 

Hi,I'm trying to upgrade a FME Flow Hosted instance, but I can't create snapshots from the backups tab, because I get this message "Snapshots not supported for unsupported instances"...How can I get a snapshot of my current instance to restore in the new one ?Thanks 

I have a workspace that writes to a simple Excel sheet. The sheet has 3 columns: Report Name, Upload Date, and Upload Time.In Excel you can set a Filter for each column allowing a user to filter the data in that column. In Excel, I added a Filter to each column, but when I write to the sheet in FME Form, the Filters disappear. Is there a way to “keep” or “add” a Filter to each column in the sheet by tweaking a Writer parameter or is there another Transformer I need to add before the Writer? The screen capture below shows what I would like the sheet to look like:  

Hi All,  I have a table with a 'route_ID' and a measure value (like a event table). On the other hand I have a polyline feature classe.  The attribute 'Name' correspond to route_ID from the table. The measure values are points on the lines. Now the measure values changed by a predetermined value (e.g. the point was 10 m and now the point is 10.5m). My Problem, the Polyline feature class is not defined as route form a linear referencing system. And so the table and the Polylines have no relations. I don't no where (which coordinate) my old and new points are.  Can I build a route feature class with FME? The Basisc should be my polyline Feature Class. I would have assumed a route feature class, how can I creat points (with coordinates) form the table?  Thanks for your help.  Debby

My work colleague is trying and failing to connect to Oracle Spatial.I suspect that her installation of FME is slightly broken and she lacks the access rights to the folder where FME connections are stored.When she goes to Tools | FME Options | Database Connections FME pops up an error message "Unable to retrieve database connections"And she is also unable to create a new database connection.If I knew the folder location, we could check if she has the proper access rights assigned by IT.Thanks,Nick

Can someone provide a link/info on where I can learn more about CRON Expressions? I know what they are used for and why but have never actually used them before. Thank you. 

Can someone expound on this topic a bit, why would someone use Schedules and create Notifications in Schedules when it can be done a whole lot easier in Automations? Example, setting up an email notification in an Automation is just a matter of adding the Trigger --- Workflow --- Email (one for Success and one for Failure if you like). As opposed to going through the brain twisting effort of using Notifications (Classic) to do this.  Automations are so much easier to work with. Does Safe have plans to remove Schedules and Notifications (Classic) in future releases? keep only Automations and improving upon them?