FME Form

Hi All, I'm trying to create a workflow that iterates through a folder which contains individual GDBs (e.g. 20 individual GDBs) and then merges the Feature Classes with the same name into a new blank GDB.Any idea how to make that happen?Thanks 🙂 

Hi, I have 2 data sets (shape-files). A point dataset with 3d-points or at least points where the elevation is stored in an attribute field (different data quality) and a polyline dataset with 2d-lines whose vertices are identical to the points from the point dataset. Is there a way to assign the elevations from the point datasets to the line vertices and then create 3d polylines from them? Thanks for your help

I have a very simple workspace that just tests whether a string has a “.” Or a “:’ in it and if it does then these characters are deleted. I am using the Testfilter to test for the characters, and then a stringreplacer to delete them and then I must make sure the string is all caps. Is there a way to do these three operations by using the String Functions in the Testfilter? I haven’t been able to figure out how the string functions work. Also, will using the string functions speed up the translation? I have 47 million records to test and right now it takes 4 hours to run. I am using FME2018. I have included the workspace and source CSV file. Thanks.

In the writers, under user attributes we can see the table with name, type, of data, width., etc. Is there a way to copy/pate or export this table in csv? I am tasked with data type for multiple outputs, and it would be great not to do so manually.

We are attempting to use the Automations > Manage Automations as a built-in user, but when browsing to that page it is blank and there are no automations in the popup list. We've made the user a member of 'fmeadmin' and 'fmesuperuser' but it makes no difference. So far only the 'admin' account is able to Manage Automations.What are the minimum permissions required for users to make this work?

I have a feature class with a single feature that I need to convert to a multipolygon type geoJson file. I'm not super familiar with geoJSON, and I'm being told this is a hard requirement. How does one create a multipolygon geoJSON file from a single feature?

I have FeatureReader transformers within my workspace that are configured to read features from an Excel file.  The name and path of the Excel file are variables provided by parameter values, but the Excel sheet name is always the same. The schema of the file is likely to vary every time the workspace is run.  I'm really struggling to get any features to read in, and am a bit unsure of where I'm going wrong. From similar posts in the past (eg; https://community.safe.com/s/question/0D54Q000080hdRJSAY/how-to-expose-attributes-from-featurereader-if-feature-type-is-dynamic) it seems that what I'm trying to do potentially isn't possible without scripting something bespoke in a PythonCaller, but it really seems like something that FME should be able to do. Does anyone have an

I have two tab files and while joining them I get this error for one of the row ERROR |FeatureJoiner (FeatureJoinerFactory): The UTF-16LE string 'DOÃƑ±A ANA-HILL' could not be converted to the encoding: windows-1252.

Hello,I have a SQLExecutor connecting to my SDE on a SQL database. I am using the Microsoft SQL Server Non-Spatial Format with an embedded Connection. My SQL Statement is:FME_SQL_DELIMITER ; GO DISABLE TRIGGER gisowner.SEGME_MSLINK_COUNTER ON gisowner.[a10]; GOI get the following errors:Query failed, possibly due to a malformed statement.Provider error `(-2147217900) Incorrect syntax near the keyword 'TRIGGER'.'A fatal error has occurred. Check the logfile above for detailsFailed to read features from dataset 'AHS_GIS' using the 'MSSQL_ADO' reader

Just curious about it as there are different approaches, and would like to understand better my results and analysis.

I am converting ESRI gdb tables to Josn format(text_line), but unfortunately few of attribute values are given extra/unnecessary precision?data from tables : "aos" : 105.20 ,"aos" : 293.22 output generated : "aos" : 105.20999999999999, "aos" : 293.22000000000003To avoid this I have used attribute rounder , but no use, client required only 2 digits after (it should be float) . could some one help to resolve this issue on this.I have used the below transformers gdb readerattribute manager and attribute rounderJosn templaterText file writer (text_line)Thanks in advanceChandra Sekhar Guda  

I am trying to extract getVertexIndices from a mesh and I have to implement a loop when I use the getVertexIndices() method. Also, I am getting different sizes of the list coming through the getVertexIndices() method. Is there a way to get the list of all vertex indices at once and of uniform size?  @daveatsafe​ @Takashi Iijima​ @Hans van der Maarel​ 

As workaround I can create user parameter as intermedia parameter then get it accessed by shutdown python script. But I am more like to find the way to let shutdown python script to DIRECTLY access deployment parameters. Any tip?Thanks,Daniel

I have 200 files. Their names have spaces. I want to replace these spaces in each file name with a dash. What is the best way to do this. I know I start with the pathnames reader. But, what is the next transformer(s) I need to add?

I have a gdb with polygons ( multipolygons). I read polygons and simply write to a new gdb and my polygons holes are filled? It happens also while reading Isee. As if there is a geometry validation happening. How can I stop this? It is really annoying.  

Hi, I need some help setting a basic test with the tester transformer. I'm trying to fail rows from a feature if they match any values in a csv file I've added as a reader. I'm having some issues getting things configured correctly. So something like NOT @Value(field) Contains <Right value>. But I can't seem to connect the right value. Connecting the csv as an input isn't what I want, but I cant figure out the syntax to use in conjunction with '$(SourceDataset_CSV2)'. Sorry for this basic question but I couldn't figure this out looking at the documentation. Thank you.

Hello, I wanted to continue my course when I realised that instead of eight completed modules there is only three. Howewer in the list of completed modules there is the correct number. It seems that there is no cenection between modules and the whole course. When I click to continue course it shows up an empty incomplete module next to the completed one.

Hello Forum, I've searched previous questions, but couldn’t find an answer. I've no doubt someone has posted this before. But, sorry, I couldn’t see it. I need to replace a specified value within an attribute to another value. I have an attribute (field) called Zone Type. Each cell in that attribute has one of several possible values. Where the value is "container" I need to replace it with "Outside CPZ". I don’t want to change any other values. How do I do this? I've tried through AttributeManager but couldn’t work it out. Thanks,Stuart  

The first dataset has 10500 objects ( a table with x,y id, date,etc. etc.)The second dataset 7000 object s )(a table with x,y,id ,,date, adress etc.etc.)Based on the x and y we would like to get a combined file as a result.Where all 10,000 objects from the first dataset are located at the closest object to an address point.A list of these.. It seemed logical to us to use the transformer neighbor finder for this. But this doesn't work. ideas more than welcome  Johan 

I have a column that contains a lot of special characters. By using transformer 'StringReplacer', I can replace i.e. an '#' by an ' '; How can I replace a list of special characters of 10 or more characters. Do I need to use 10 StringReplacers?

I am running an FME-routine in FME Desktop (2022.2) where I want to modify data from an ESRI Geodatabase and write them back to another ESRI Geodatabase. This routine has always worked fine for months until recently, where it suddenly gets the following error messages in the log-file:2023-11-28 20:05:40|6109.0|  0.0|ERROR |An error occurred while attempting to insert a row into the table 'UPDATE_TABLE' using a cursor. The error number from ArcObjects is: '-2147155558'. The error message from ArcObjects is: {Overflow or value larger then maximum 32bit integer [UPDATE_TABLE]}2023-11-28 20:05:40|6109.0|  0.0|STATS |Storing feature(s) to FME feature store file `D:\LOGS\Matrikkeloppdatering_log.ffs'2023-11-28 20:05:40|6109.0|  0.0|ERROR Any tips on how I should resolve this issue? Is it related to version compatibility? I am currently using ArcGIS Pro 3.1.2. 

Hello!I have a newly installed PostgreSQL database with a PostGIS extension enabled. Because of licencing consideration we want to migrate our oracle database to this database. We are using database side bussiness logic in our views, so i want to write directly to the views without success.We have Postgresql 12 AND postgresql 16 for compatibility testingEvery version of FME from 2018-2023 (mainly using 2018 because we have too many scripts to migrate all) I have tried most of the version combination with the same error every time. This is what im trying:Created the table definition with FMEBased on the created definition created a simple view but the workbench keep dropping this error: Invalid PostGIS metadata detected for table 'public.generated_np_node_view'. Attempting to correct and continuePOSTGIS Writer: Table 'public.generated_np_node_view' does not exist.

We have a process that sends an e-mail to approximately 10,000 subscribers to inform them of crime in their area based off a buffer from the subscriber address that we are considering to replace. Is this feasible using FME Flow or FME Hosted? Or is that too many e-mails to send at once using these platforms?

I have a map that has 5 layers in it and want to have them all displayed using different symbology in the HTML Layouter but I can only define a single colour for the layer.Is it possible to generate HTML output with a little more cartographic input for each incoming layer?