FME Form

Hi new at this...I am trying to separate some data from a CSV separated by a comma and then merge it back into one feature, I can't work out how to merge the 4 results I get from each entry.

Hi,I have some FME workspaces, that investigate the recent FME log files from previous translations. This is done to uncover any problems in a rational way.I want to extract the statistics at the bottom, but the "|STATS |" string is used extensively thru-out the log file, and would completely swamp the output if this was the only search criteria (while reading as a TEXT file).Do anyone have a good idea how to extract just the summation details ?CheersLars I

Hello, For a FME workflow involving hydrographic CSAR raster files both band and point coordinate information are present in the file. The point coordinate information is the location where the measurement to generate the raster file was taken. This is crucial information for a user.According to the help page of CSAR raster (CARIS Spatial Archive (CSAR) Raster Quick Facts (safe.com)) this GCP and Z-value information, which to my knowledge is the point measurement location, is not included in the functionality of the CSAR reader or writer. Is there a workaround available in FME to include this point information in the CSAR raster file ? It is important that is saved in the same manner as in the original file. If not,would it be possible to add this functionality in future releases ?  Thank you!

I can create an AWS RDS Postgres Reader and Writer on FME Desktop and successfully run the workspace. However after publishing the workspace FME Server it fails. It looks like Readers/Writers to AWS RDS Postgres are not using system Proxy Settings. Completed steps in manually setting the proxy:port using fme.exe in the FME Documentation.  Thanks 

Hi everyone, I'm using FME Desktop 2022.1 and I would like to use the LDAP reader with an encrypted connection (LDAPS, Port 636).  When testing the stored connection I get the following error:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetI know how to get the root and the ldap server certificate. But where do I have to store them within the FME Desktop installation? Kind regards,Peter

I would like to calculate the average of pixels for each polygon, how can I do that? I have several raster fragments and several polygons.  Thanks

Hi partners, You can now find the updated 2019 versions of the FME Product Brochure and the FME Customer Stories on the partner portal under Marketing > Collateral. These updates include files that are suitable for both print and digital copies. Please feel free to use these for any of your upcoming events.

Here is my colour setter. I also tried GeometryColorSetter and it worked, but the coloured output is too bad. Random colours are spread so badly. @chrisatsafe​ @Hans van der Maarel​ @safesoftware safesoftware​ 

Hi, I will try to upload shapefile to geoserver over the rest api.This should be possible with the HTTPCaller! I am using the following option: - http methode: PUTUpload from data...But I get the error: I have access to the given url. So what is the problem here?Does someone has experience in uploading shapes to geoserver with fme?

Hello FME friends,Welcome to the What's Up Wednesday newsletter for October 26th, 2022.  For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Spatial "For Dummies"Did you know that Safe Software helped to produce an e-book on this subject? The actual title is "Spatial Data for the Enterprise for Dummies", but that was just a bit long to fit in a heading.  The book is available for free download from our website. Obviously, it's not in-depth technical content or training. Instead, it's a very good overview of the sort of work that we're all doing with FME. For existing FME users, I think it's a great book to share, for example, with the manager who doesn't quite get what you do, or what the potential is. Like, "You remember what I was saying about Real Time Tracking, and Digital Twins? This book shows how useful they would be." And they might not even notice you'v

Block legacy authentication with Azure AD with Conditional Access How will this influence the FME Server Azure AD integration? And what can be done to fix it? https://learn.microsoft.com/en-us/azure/active-directory/conditional-access/block-legacy-authentication

Have a FeatureWriter to insert data into a SQL table. It ran successfully without any error. However, no data shown in the destination database table. Reviewed the log and it says Features not written (see below):Below is the Feature Writer: Both FME Desktop and Server are the same 2021 version. FeatureWriter insert works well in my other workspace. Not sure why it didn't work here.

I need to extract the Values from Logfiles and create an HTML report with separate columnsfrom this code I need the date and time ... stats (Table Names), inform (Transation Success and durationI m using fme desktop transformerFMEServerJobSubmitterFMEServerLogFileRetriever 2022-10-27 11:52:48|  1.7| 0.0|STATS |Past Track                                                                  12022-10-27 11:52:48|  1.7| 0.0|STATS |Past Wind Radii                                                             12022-10-27 11:52:48|  1.7| 0.0|STATS |Storm Surge Communication Points                                          3082022-10-27 11:52:48|  1.7| 0.0|STATS |==============================================================================2022-10-27 11:52:48|  1.7| 0.0|STATS |Total Features Written                                                    8782022-10-27 11:52:48|  1.7| 0.0|STATS |=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-2022-10-27 11:52:48|  1.7| 0.0|INF

Hello, I would like to use a FeatureReader as an entry point of my workspace.But only Reader can work. As a workaround, I use a Reader to read a dummy file (ie. an image) connected to a FeatureReader. Is it possible to choose an arbitrary transformer (ie. FeatureReader) as an entry point? Thanks!

I want to make a custom transformer with a geodatabase SDE table reader from a specific table, and some other transformers. But when i try to create it, the SDE reader is converted into an input of the custom transformer. Isn't it possible to have a fixed reader in a custom transformer?

Hi, i try to extract a map extend from arcgis. I need to create a polygone with the map extend. Not the data extend. Can you help me ?

I work for a city entity and have a federated login. I'd like to connect to ArcGIS Online in FME Data Inspector so that I can use a specific basemap. Is this possible? How can I format my credentials here?Thanks!

I have reviewed the recommended Virtual Memory settings in this post. But, my server is hosted in Azure. It has 32GB of physical memory, 4 cores, and has a dedicated 149GB drive for the pagefile that is managed by Azure. Still getting this error when reading in 5M well records from Enverus data to our SQL Server Enterprise Geodatabase (SDE). The FME version is the lates - 2022.1.3. Just upgraded from 2020.2.2. 2020.2.2 did not have this issue.  To clarify - I have NOT made the suggested settings as Azure manages the pagefile and it is substantial.

Hi All, I'm looking for the latest, or what you have found, the best workbench/template for generating (as much is possible) FGDC compliant metadata. I'll be using a template xml document. Any and all recommendations are welcome! Thanks, Jerry

There appears to be a change in message recorded in _reader_error that gets added to data coming out of the rejected port of either the SQLExecutor or SQLCreator when connecting to an Oracle DB. Previously (in 2019.2) a failed connection to the database resulted in a single error in the translation log and the following sort of text in the _reader_error attributeError connecting to Oracle database: message was `ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'....orError connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'.  orAn error occurred while accessing a table result for feature type `'; message was `Execution of statement In 2021.2, I now get two errors in the log. One which contains the useful information above and a second that seems to always readError connecting to Oracle database: message was `%5'. (serverType=`%0', serverName=`%1', userName=`%2', password=`***', dbname=`%4')It's this sec

Hi, I created shape files from spatial database for the use of our corporate software using fme. And I scheduled in Task manager to run this task daily to keep the files updated. But now I needed to keep them up-to-date checking database table for every half-an-hour. I'm looking for some help to update existing shape files (similar to update detector used in case to update database table) rather than delete and create each time. your help with is greatly appreciated.

Hey there,following my issue with clothoids I now have a problem with writing geometry properly into LandXML.While the geometry is proper within FME Desktop, it gets worse as soon as it's written to LandXML.Any ideas?A sample workspace is attached. Cheers,MariaKa

Hi, I read that safe is building a way to generate custom transformers from OpenAPI description. Could anyone tell me if the plan is to make it compatible with 3.0 or only 3.1 specs?

I'm hoping this is fairly straightforward, I've searched a number of examples but I cannot quite find what I am looking for yet. 2 datasets:1dataset is a table with LRS and Milepoint (no geom)1dataset is a highway network with LRS and Beginning_Milepoint and Ending_Milepoint (polyline)ObjectiveIs to place points along the linear feature based on LRS and MP from the table (the table contains assets located on the highway network). This is often referred to as Make Route Events Layer in other software. Are there any recommended workflows to consider?  Thank you in advance!

My parameter says this.$(FME_MF_DIR)\\CF\\PNM.sdeBut I want it to say this.C:\\Users\\USERNAME\\Desktop\\CF\\PNM.sde Can this be done? This is a problem because it breaks the connection when the workbench is put in different folder.