FME Form

We would like to migrate IOT sensors event data, which is exist in MySQL to Hono-Ditto system.Can you please help us with the process? Thank you.

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

Hi,I do have a question for anyone that experience about extracted information from a website . I have a geodatabase that I set it up as a field with Domains.The project I am working on is Campground for my Forest here we have many campgrounds.  I work on about 18 campground so far…My question is can I go to Recreation.gov site and select a campground using in FME ? For example, in the search box , type Colorado Campground and then it turns to new page and you will see the campground map that has all the Site number you can pick.So click on number three and then click View details...which will bring another page and it gives you all the information about that site number…That is what I plan to use this…I have done input all the information into my geodatabase  there. Will HTMLExtractor work for this type of thing ? Am I making myself clear  Thanks ! 

Hello all! I am using a CSV file as a configuration source, which contains a list of database connections and corresponding table names. This CSV connects to a Feature Reader, where:The database connection is set using a parameter (dbConnection) read from the CSV. The feature types are dynamically set using the table names from the CSV.The Feature Reader successfully reads data from all specified tables and outputs them through a generic port. I’ve exposed both the feature attributes and the fme_feature_type.Now, I need to join the database data with client data, but since all table outputs are merged through a single port, it's difficult to manage and distinguish between them.What I’m looking for is a way to automatically separate the data by fme_feature_type (i.e., table name) and route each to a different port or stream without manually updating filters or Testers every time a new table is added to the CSV. This is essential because users will be updating the configuration file with

I can't remove the "issue." fields. I tried deleting them with Attribute Manager and AttributeRemove without success. Could someone tell me how to do this deletion?

Hi everyone, I'm working on an FME workflow that needs to process multiple Shapefiles. The challenge is that these files come with different schemas (different attributes, attribute names, etc.). I’ve noticed that transformers like DuplicateFilter, AttributeExposer, DatetimeConverter, SchemaMapper... don’t handle these schema changes dynamically. That means every time a new Shapefile with a different schema is added, I have to manually update these transformers to accommodate the changes. Is there a way to make this process more dynamic, so the workflow can adapt automatically to different input schemas without manual intervention each time? Any tips or suggestions would be greatly appreciated! Thanks in advance!

I have a process that downloads groups of shapefiles of the same schema to a folder from a google bucket. I am trying to read in those shapefiles with a feature reader so that I can add an attribute containing the shapefiles name. Then I want to write all those shapefiles to a singe feature class in a geodatabase. How would I set up my featurereader so I can create and write that attribute in all those shapefiles before writing to the feature class? 

Hi, I’m using XSDDrivenXMLWriter to write very dynamic XML to a file. There is one part of the xml with a lot of features that is very static and contains always the same data like origin and publisher… I don’t want to create all the 30 features with the XSDDrivenXMLWriter for this static part and thought I could use the _XML_FRAGMENT_ feature and 3 attributes like xml_fragment, xml_document_append_path and xml_document_append_as to tell the XSDDrivenXMLWriter to add my static xml to the output. But somehow I can’t get it working.Can you please provide me an example workspace? Unfortunately I cannot provide my workspace because it is restricted by the customer.Many thanks. 

Is it possible to only read the (selected) attributes, and not the geometry?Quite often, I need to join the attributes from two spatial datasets, but only need the geometry from one. And I am assuming that reading in only the selected attributes without geometry is noticeably faster than reading the attributes with geometry.Is it possible to read any dataset without geometry (other than reading it with and then doing a GeometryRemover)? And does this apply to all formats?

For years I’ve successfully used the Geocoder transformer with the ArcGIS Online service. Now with the recent upgrade to Version 2025, it appears to be broken. I’ve read a bunch of recent articles concerning the new (?) ArcGIS connector package, but nothing seems to relate to the Geocoder transformer. Anyone else having similar problems?

Hi everyone,I’m running into an issue where FME hangs while reading a DWG file using the ACAD reader. The translation process stops and doesn’t progress past the following message:while reading dwg file translation will be stopped by 'LogCount_func' Loaded module 'LogCount_func' from file 'C:\Program Files\FME\plugins/LogCount_func.dll' FME API version of module 'LogCount_func' matches current internal version (4.0 20240212) Additionally, when using a PythonCaller with arcpy, I can confirm that the Python Factory locale is being flipped from UTF-8 (German_Austria.utf8) to ANSI (German_Austria.1252):import locale print("Startup locale:", locale.getlocale()) import arcpy print("After arcpy:", locale.getlocale()) Output:Startup locale: ('German_Austria', 'utf8') After arcpy: ('German_Austria', '1252') This matches the warnings shown in the FME log:PythonFactory script changed the current FME process locale from 'German_Austria.utf8' to 'German_Austria.1252' and FME has restored it back to

Dear community, I am trying to activate a workspace when a survey123 form has been edited and the user confirms that all necessary information has been completed (yes/no field). The work space would then extract data from ArcGIS online feature layer of incidents and the relevant repeat tables. The extracted data would then be used to populate a MS word template which once complete would be saved/exported as a pdf document. This pdf document would then be attached to an email and sent to the manager of who filled in the survey123. My main problem is trying to find a way to fill in the relevant field in the template with the extracted information from the ArcGIS online layer. Is there a transformer or series of transformers which make this possible? Thanks in advance. 

The texture image displayed by the Appearance Setter converter is correct, but the texture map written in 3dtile format is incorrect. It should be due to the loss of texture coordinates. When will 3dtiles improve? Currently, it can only be used simply

Hi,We are trying to use a FileCopy Transformer to transfer files from one location to our server (synology) / other computers (other computer).If we do it in Ubuntu GUI / SystemCaller command it works perfectly.But the file copy transformer always give error messages as we don’t have sufficient permission. Even if I put our NAS credential in the transformer (with a featureWriter), it give the error messages. The files are created in the server but there’s no content inside.Does somones already experienced it ?Thank’sSam

I’m using the SchemaMapper and I have a question. After transforming the data, I noticed that in the 'Unexposed Attributes' section, the attributes are correctly mapped, but in the resulting table, the attributes still appear without the mapping. Does anyone know how to ensure that the attributes, after passing through the SchemaMapper, show up correctly mapped in the final table? Is there any additional configuration needed? 

Hello, I want to access an api (not open to public but from one of our suppliers) using the HttpCaller .Connecting to the API with postman works fine. Connecting from the same server with FME gives the error: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'SSL connect error'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered Connecting with FME from another environment works fine. We dont use a proxy.I have changed the option: Verify SSL certificates to NO Any ideas on what could be the problem?

Hello Forum, I have read in 45 tif files into a single FeatureReader via Select Multiple Folders/Files> Add Files. But when I click three dots next to Feature Types to Read, in order to ensure that all 45 files are listed separately, I can only see one listed. And that doesn't appear to be a input file, but instead it just states ‘TIFF’... What I am doing wrong here? I use this function quite often and it usually lists all selected input files, but on this occasion it is not. How do I get Select Feature Types To Read to list all the selected input files?  Thanks,

Hi community,how can I set a NoData value for the pixels that are located outside my geographic area of interest?Attached you can find a GeoTIFF file:https://we.tl/t-XjrxojSLZhThanks! 🙏

Hi, I’m trying to generically read some tables and distribute them into different DWG Object Data layers. For this, I have a mandatory attribute containing the output layername.I use a SchemaScanner with a Group By on this attribute to generate the schemas and finally write everything using a dynamic DWG Object Data Writer.But it doesn’t work, I get a Layer 'XXX' is not definedBut(bis) if I use another DWG writer (e.g. RealDWG) with the exact same configuration, it does work.I guess the difference comes from the Object Data table definition? But I have no idea how to do that. I’ve tried to sort schemas and features to make sure that the schemas arrive before the features but it doesn’t change anything.When using the RealDWG Writer, if the parameter Output Schema Before Data Feature is set to No, I get the same error, but once set to Yes, the file is written without problem. What should I change when working with a AutoCAD Object Data Writer? Any help appreciated. Best Regards, Julien F

Hello, I am using FME Form 2024.1 and have the Esri ArcGIS Connector Package (version 3.11.3). I am experiencing some weird datetime functionality. I have a Portal Feature Service Reader (old school) in my workspace and would like to upgrade it to the new ArcGIS Feature Service Reader. Setup was great and reading the data worked well, but I noticed that any datetime attributes that come through are now being read differently. I have attached two screenshots of two datetime attributes that are being read differently depending on their Reader. The old version looks correct, you can generally start to make out the date for a feature (20250906), but the new way of reading looks completely different.Is there a setting I missed when setting up my new reader, or is this some new format? At first I didn’t notice this, but when I went to write the data back to Portal after passing it through my workspace, I got an error regarding these attributes (basically saying they were invalid)DateTimeConv

Question:I need to generate a square georeferenced PNG where: the interior of a geographic region is transparent, the exterior is filled with a solid color (e.g., gray). Currently, I have two geometries in EPSG:2056, which I merged using a junction node.How can I produce a single georeferenced PNG with these properties?I’ve attached my script and the two input files. 

hello , How to use textures for different meshes of the same model in the PythonCaller converter?

Hi.Is it possible to execute dynamic SQL in the InlineQuerier ?I tried something like: SELECT * FROM Merged WHERE @Value(“sql_where”)but it doesn’t seem to work.Are there not substitution done in the “SQL Query” window in InlineQuerier ?Yes, I know it has to be SQLite syntax, and it is.Cheers.

I have a point layer, and within this layer I want to search around each point for those that are within 5000 m. For this, I used the Neighborfinder with "candidate only." It outputs a list with points that sometimes have 8 neighbors. In this list, I would like to keep either the initial point or the neighbor with the highest value in the TEST field. I'm stuck. I attached an image of the result and circled in red the points I’d like to keep.Moreover, the Neighborfinder transformer says it does not compare a point with itself, but I notice the opposite. Could you please help me?