Transformers

How to convert all the attribute names of all the feature classes within a File Geodatabase, to uppercase?

Hi team,I've seen this at multiple locations, where Sophos will prevent FME from installing custom transformers from the Hub (i.e. Emailer) and display a Lockdown alert, Sophos believes it to be malicious behavior. Has anyone else experienced this? Is it possible for Safe to reach out to Sophos to see if this can be looked at, as the only way to get around this, is to allow exceptions per Transformer on the Sophos side and we have to re-do this each time we upgrade FME Desktop.

I have a string column containing lake names in the format ''Blue, Lake'' and I would like to reverse the format to ''Lake Blue''. I somehow can't find a way to reverse a string at the comma.  Is there an easy way to accomplish this using string functions in FME ?

I am wanting my StringReplacer to search for values which start with a certain string, and replace the ENTIRE value with a new string (not just the start). I have table with a list of values starting with "Sh 1" and "Sh 77", and they all have following text after Sh 1 and Sh 77. I would like to replace the entire value, e.g. "Sh 1 Rs 401 Rakaia to Chertsey" should be replaced with "State Highway 1".  I have tried a few expressions, but currently I am only able to replace the "Sh 1" part of the string, not the following text.  How do I change my expression so the entire value is replaced?   

I have a large set of featureclasses that need to be run into a workspace, one at a time because loading the dataset all at once will make my FME workspace terminate because the memory is full. I have used workspacerunner on a folder with multiple csv files, which solves the memory problem. But I can't figure out how to do a simular thing with multiple featureclasses. I wouldnt mind if the featureclasses need to merged into one and the input the first xx number of features into the workspacerunner. If that is even possible.

The writer stops working after I added a geolocation field to the sharepoint list. Even without writing anything to the geolocation field, the writer still gives me this error. Could anyone help me? Kind regards.  https://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint-user-attr.htm

Hi there. I am outputting SQL data into a CSV into well known text. Some of these features are polygons and others are multipolygons. I am finding in the output some multipolygon WKT strings are spilling over into other fields which throws everything out. I'm not sure the field length is exceeding the maximum length for a CSV but is there anything I can do to keep it all on one line or is this a problem with multipolygons? I'm using a GeometryExtractor to convert to WTK, then a couple of StringReplacers to remove Z and change the SRID from 0 to 3857 so the csv can be brought into Power BI. Most are appearing fine. Regards, Josh

Hi I'm using FME 2022.2.5 it crashes at the start and before loading the main window, sometimes it happens when I enable/disable cache. the issue with Qt6Sql_fme.dll ! appcrash event in the the log file.. anyone with helpful tips it does start after 5-6 tries. this log is from the start up crash------------------------------------------------------------------Felet uppstod i programmet med namn: fmeworkbench.exe, version 2022.7.45.22795, tidsstämpel 0x6424fcdc, felet uppstod i modulen med namn: Qt6Sql_fme.dll, version 6.2.4.0, tidsstämpel 0x6254adbaUndantagskod: 0xc0000005Felförskjutning: 0x000000000000edbfProcess-ID: 0x7968Programmets starttid: 0x01d98ca438014579Sökväg till program: C:\\Program Files\\FME\\fmeworkbench.exeSökväg till modul: C:\\Program Files\\FME\\Qt6Sql_fme.dllRapport-ID: 4320bc12-2030-4046-b3b8-63e036810fb4Fullständigt namn på felaktigt paket: Pro

Hi, i am using this structure to generate solid meshes from a LAS, extruding the point from x,y and z and then building the mesh of each small cube. But I found that the solid mesh was moved in the space (there is an offset) when I use cloud compare to viz it, and I don't know why it is occurred.Very grateful for the answer!! thanks:) ! 

As you see, I connect separate inputs to the two duplicates of my custom transformer. But all the data goes into one of them. Why is it like this?

I'm using FME serverI got a dataset with only one feature inside.I converted it to fgdb with ignore schema selection as attached fmw.But the output is zero feature.It can be success if I duplicated the feature to make it become 2 features.The attached is dataset, log and fmwIs any other thing I can do on fmw for this situation

I want to loop number of times (22), so, created Custom transformer. Tried embedded, didn't work, so now Linked Always with fmx.1. Unable to work out whats the issue, it works if just run for only one iteration (test purpose), so, seems no issue in both main & fmx (custom). 2.But an issue to loop, or going to next iteration 3.Could not change CustomTransfomer>Transformer Pramaters>Advanced > Maximum number of iterations or Attribute to holdl iteration count !? 4.However, I have used 'LoopRecs' for iteration from main to loop transformer and added 'MyCounter' for loop test. 5.Please note, added sampler, just to run 3 times for testing, but actually wanted to loop based on 'LoopRecs' variable, which is passed thru main to custom. Whats issue here ? I have spent a lot of time figuring out . . is this a bug ? tried to get help from our FME tech support here , no response

The problem I am facing is I cannot figure out how I can send Answer value for Observation Question to the FME Server. I have been using this syntax: {"Address":"~~Location~~", "InspectionId":"~~InspectionId~~","Observation_Id":"~~ObservationId~~","Facility_Id":"~~Facility_Id~~","AnswerValue":"[~~AnswerValue~~]"} Also, I can find API documentation for the InspectionAnswer, but I am having trouble setting the right Syntax, so it will send Answer Value to the FME Server. Can someone help, please?Thank you

Has anyone worked with spatial indexing using GDB/SDE as output format? The spatial indexing function only appears for SQL Spatial formats. Any response is very much appreciated. Thank you!

I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:No errors were given, but the temp table was not created on the SQL server tempdb. I tried using the fully qualified name tempdb.dbo.##MyTempTable for example to no avail. Appreciate any suggestions! 

hello, I'm having several java.lang.NumberFormatException: warning when writing to MS Azure SQL database. It does not prvent the workspace to run properly however, it create a very long log file with hundreds of thousands of warnings. Is there a way to correct that so that I won't have such warning anymore? Thanks

Unable to use Windows/IWA to login to FME Server Web Interface. Have followed all the steps, ensured the SPN is correct, ensured the service account is set correctly, done all the browser checks, and confirmed the Tomcat properties are right.Going to the URL <server name>/fmetoken/sso/generate throws a 403-Forbidden with a description "The Server Understood the request but refuses to authorize it". Going to the URL <server name>/fmetoken allows me to generate a token by using userid only. Adding the domain to the front of the username causes the token generation to fail. So it appears that it's something tied to the domain and how the users credentials are being passed but that leaves me unsure of how/where I missed a configuration that strips the domain during passing of the credentials in order to get a good token returned.Here is the message that appears when attempting to login:

i am currently working on a task, extracting geometry from IFC file and point cloud and building solid meshes and compare them getting the differences. but as I use generated point cloud solid meshes and IFC solid meshes from IFCwall IFCdoor IFCwindows and IFC Column. but the geometry is always invalid when i put them in to CSG builder. how can i compare difference of two big geometry and what kind of geometry accept CSG builder ?

I try to make a custom transformer to do linear referencing of point features to a maximum of 10 polylines. Inputs are point features and polyline features with or without measurements. The custom transformer would output a list with the combination _kp{0}.KP, _kp{0}.DCC, _kp{0}.selectedRoute. The KP is the distance along the polyline, DCC is the perpendicular distance to the polyline (negative values on LEFT side of the polyline, positive on the RIGHT side), and selectedRoute name is the name of each polyline. At the end of the custom transformer FME shows the list being created for each feature, but it can not be used in the attributemanager following the custom transformer.

I am feeding all feature services in an ArcGIS Online group into a FeatureReader. I don't know the services or their attributes ahead of time. I can read all the records from these feature services but how do I dynamically expose their attributes? I can see them in an Inspector so they are there. I want to compare each feature service and its attributes with a corresponding feature class and its attributes in an SDE geodatabase.

Hello ,i am struggling with get the relationship between classes .i have Exported xml from arc catalog and I would like to find the relationship between classes .I have used the workspace here https://community.safe.com/s/article/geodatabase-xml-workspace-document-schema-readerlist exploder for data element ,I have chosen relationclasses but it seems for me , it does don’t show all relationship classes with others ( some are missing ) My target to find name of feature class and the feature classes related to it FME 2021 please if someone has sample workspace ,I will be appreciated .Thanks in advance

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:  But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.  Any suggestions are greatly appreciated.

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Co

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?