FME Form

I have a request to build a FME workspace that can read a text file and load it into an Oracle database with the filename with a suffix appended as the table name (ie. filename_ext).That is fine, the problem is the column headers and fields will differ, depending on the filetype (file A might have 10 columns, file B will have 17 and the column names will be different between A and B)I’ve considered using a tester that directs the flow to an attributemanager based on a “user parameter”. This becomes problematic if the source text file changes column structure or an additional file type (file C, D and E) is introduced.Is there a way for the text file to be read (as generic in the featurereader), have the attributes exposed, split and output with the 1st row as the column headers. Ideally without having to know the column names prior.Thanks Thomas

Hello FME Community!I’m trying to read a Civil 3D file in FME, but I’m not able to access the specific attributes I need.I'm trying to retrieve Pipe and Structure Data Fields (Attributes), but I'm running into errors. Here are the errors that I’m seeing:```2024-10-27 15:13:47|   5.1|  0.0|ERROR |AutoCAD Reader: An error occurred for dataset 'C:\Users\Dor\OneDrive\Perach\Ayalon\חומר ראשני\R6407_01-RME-DR-SVD.dwg', in function AutoCAD2004Reader::readC3DSchema. Exception thrown: 'Not that kind of class' (Object of class AcDbProxyObject can't be cast to AeccDbNetworkPartDef.)2024-10-27 15:13:47|   5.1|  0.0|ERROR |An error has occurred. Check the logfile above for details2024-10-27 15:13:48|   5.6|  0.0|ERROR |Failed to obtain any schemas from reader 'CIVIL3D' from 1 dataset. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information.2024-10-27 15:13:48|      |     |ERROR |Workspace generation faile

Hello,I am struggling with a similar problem as this post (I think?).  One of my attributes in the Workspace contains a 0 or 1 that is used as a Boolean.  The value has been assigned the datatype ‘buffer’ in AttributeCreator and ‘string’ in the FeatureWriter, which outputs an Excel file.  I am using a template, where the cell format is set to ‘General’.For some reason, the Excel file that is generated will give me inconsistent formatting of the attribute value:  What is going on here??? As you can see, even though they all should be interpreted as strings, some of the values become numbers.  The formula bar does not show anything different.   I started using the Excel template in hopes of making the data format consistently, but even when I changed the cell format to ‘Text’ it still gave me issues when being read by Python. I would like to solve this issue before reverting to a Yes/No or True/False format.  What could be causing this?  Any insight is appreciated. -Thanks  

I have a dataset that has customer data, vehicle data, planned driving distance (with a bunch of other scrubbed attributes).  In this data, there are many days when a customer was not planned to have accumulated any distance but did use a machine.  If the planned driving distance to date is missing, I want to copy the value for the previous planned_Driving_dist_to_date that has a value, but I want this sorted by date and grouped by customer and machine.   The attached spreadsheet shows my dataset. 

Hello, All my data is in Excel spreadsheets. All the schemas are the same.I have two readers:The Updates Reader includes the 3 records that have been changed. These 3 records already exist in the Address Reader spreadsheet.The Address Reader is the original spreadsheet that includes these 3 records before they were updated. I would like these updates written to the Addresses Writer which creates a new excel spreadsheet with the 3 records updated but no new records added. In my workbench here, I run it, and the results are the 3 records are added to the 95,393 thus the new spreadsheet has 95,396 records in it. Having the 3 records added results in having 6 duplicate records whereas previously there were no duplicate records. I need the Addresses output to be 95,393 records with the 3 records I mention previously updated. I have tried changing all the parameters in the Writer with no success. The results are always the same, 95,396.I know I can use FeatureJoiner/FeatureMerger, but is the

Hi,I'm using the Raster Mosaicker to create a mosaic with overlapping images. However, the final result generates 'shadows' as shown in the image below. What is the best configuration or additional transformer I can use to solve this problem?Thank you 

Hi there I would like to scrape the data from this page. So want the lat/longs of the pins on the map and the background water outage data. I can't find an easy way to scrape the data and am just going around in circles trying to extract the data. https://www.ccc.govt.nz/services/water-and-drainage/water-supply/maintenance-and-repairs/water-status-map/#12  

When writing to Geotiff I would like Band interleaved by Pixel (BIP, interleaved RGBRGB) rather than Band Sequential (BSQ, per channel RRGGBB) interleaving but whichever option I use, the Geotiff always saves using Band Sequential interleaving.I have checked using Photoshop and also GDALinfo and both agree that INTERLEAVE=BAND rather than PIXEL. Is this a bug/can anyone else replicate this?

Bonjour,J’ai une table avec plusieurs colonnes (23) chaque colonne à la valeur 0, 1, 2 ou 3 dedans. J’aimerais savoir une façon de calculer le nombre de fois dans une ligne que l’on peut retrouver la valeur 1, 2  ou 3 et mettre ce résultat dans 3 colonnes distinctes (une pour le 1, le 2 et le 3) voici l’exemple du résultat :Merci pour votre aide!

Hello :)Here is what I am doing: I am working with FME-Flow and FME Workbench 2023.1.1. I have geodata in the form of .csv-files and am using a simple CSV-Reader ➡ MSSQL-Writer to create my datatable in my MSSQL-database (see attached image for FME-script). The datasets are saved to the ‘dbo’-schema and work without problem in GIS (QGIS in this case). This is done for a number of CSV-files. As an example I have shown the summary annotation for the dataset ‘ov_boende_aldre’.What’s the issue? When FME writes to the MSSQL database, the resulting datatable(s) is/are not recognized by the systems view ‘geometry_columns’ (se image below). Why not? When creating a dataset directly in MSSQL or in GIS (QGIS, for example), the dataset appears in said systems view. What can be the issue here? Any secret sauce to make FME create the dataset correctly that I am just missing?All help and hints are appreciated. Also, if you are aware that there is a similar post with a solution then do please direct

Hello, I’m trying to dynamically add a suffix to selected attributes using BulkAttributeRenamer.  I want the suffix to be the day the script is run and expressed in YearMonthDay.Example: the attribute is “addresses_count_“ and using the BulkAttributeRenamer and running the script on the 24.10.2024 I want it to be “addresses_count_20241024”.I tried using UserParameters. The first parameter I made was a Text Type Parameter where before the script is run the User needs to input by hand the Date. It has a few flaws. For example, the user may enter the wrong date, the date is not entered automatically by the script and will not always be processed correctly by BulkAttributeRenamer.The second UserParameters I made and think it is the right way to do it is a Scripted Type Parameter. Below you can see what I made.I have not been able to get this to work using the BulkAttributeRenamer. Even when I select the string to be a UserParameter it doesn't seem to add and generate a correct date string.

I know that there is a reader parameter for file geodatabases to only read in spatial data, but is there a way to only read in attribute data? I have an FME workflow that involves working with all of the attribute data and there is no need for me to read in the spatial data/geometry. However, my tool is getting hung up/stuck when reading in features from the file geodatabase - I suspect there's a multi-part feature with geometry issues, so I want to revise the tool to simply read in attribute data & not spatial data.  Is this possible? Thanks in advance for any help!

Hello,I’m using HTTPCaller to retrieve a set of data via an API that I know works, as I tested it in Postman. The problem with HTTPCaller is that the response_body is not as full as what I received in Postman (I don’t have the full result), so I cannot continue with my process.I don't know if anyone can help?Thanks!

I have over 30 000 .png files that have been georeferenced. However, some of the files have up to 3 or four bands when only 1 band is necessary. So I want to change this.  I want to change the number of band from 4 or 3 to 1 for each file and then replace the old one with the new så I dont loose the accompanied georeferencing files. I also want some type of iterator for this, since i have my files in a directory tree: Directory → Subdir → folder → Files

Hello,I am creating buffer polygons for points, but I would like to loop through the newly created buffers and associate them with subsequent points that fall within the new buffer.If 2 points are next to each other, the first point would be buffered and the second point would be associated with that buffer.Thank you.

Hello,I have a API request working in postman, but cant get it to work via FME. If I could see the request headers/body, etc I would be able to debug the issue by comparing the working request vs the fme request.Does anyone have any ideas how I can see this?Thanks

I’m not sure if there is already a Hub or Custom Transformer for this, but posting my own version up called “FeaturePrioritizer” for any comments or use.  I may upload this to the Hub if some belief is useful. 😉FeaturePrioritizer is a helper when the user needs to change the order of Features coming out of an Output Port to feed into a downstream Transformer or Writer that has a dependency on the order that features come into it.This is commonly needed when needing to say: Make sure that the first feature entering a Writer/FeatureWriter is a Schema Feature, or say when using an Aggregator that the output Attribute Parameter has been set to take only a single feature in the group (Eg.. The first feature in the group to enter the Transformer)  to use as the Attribute output.Not much to it, behind the scenes this just uses a temporary sorting ID and a Sorter, but puts this all into a single Custom Transformer to make it easier.As an example, here is a set of Features their original order

Hey everybody,I'm currently trying to transform LAS file into Cesium 3D Tiles with FME Workbench. Las file is provided by an Agisoft Metashape project with EPSG:3945 coordinates. I would like to transform this points cloud into Cesium 3D Tiles with EPSG:4326 coordinates.I can't use Cesium ion for my project. Unfortunately, I obtain this strange result. First screenshot is the original file and the second one transformed file.Has anyone run into the same problem ? Can someone help me to handle it ?Have a nice day !

Hello ,How could i convert Geospatial Electrical Network Data (includes stations, cables , houses) are connecting to each other to convert these data as compact Block diagram .it is not important the coordinates ,I need to create a simple block diagram  of electrical data .I would like to adjust the positions of elements by bringing them closer together without overlapping and create the suitable connections between them .Is there any idea that I should to test ?FME 2021thanks in advance .

I need to export data of an oracle database to XML, it’s data from an electricity network, so not highly structured or nested.I created a workbench using the xml-templater and got some results, so far so good.Are there any limitations using the XMLtemplater compared to the XSD-driven Writer?I don’t want to create the whole export and realize later, that I would have better chosen the XSD-driven Writer for XML.Also a little problem with XML templater:I created an Attribute Value using Attribute Manager, a simple number “0.4”.When I write this value using the XMLtemplater it gets written as “0.40000000000002” to the Textfile.What am I doing wrong?  

is it possible to automate my 2D to 3D workflow in ArcGIS Pro in FME? here is the process: 2D polygon layer with a height field → extrusion in ArcGIS Pro → “Layer 3D to Feature Class” Geoprocessing. Here, I group it based on a field so multiple polygons will be merged into a 3D multipatch. → then use this multipatch layer on top of the 3D AGOL terrain layer so they appear good on a 3D scene in AGOL.Does FME have a transformer & writer to automate this workflow? Thanks! 

I have two spreadsheets. One is the original data; the other is data that has changed. The schemas are the same. The spreadsheet with the changes has 3 records. I need to add these 3 records into the original data (while deleting the original 3 records in the original data), thus updating the records in the original. What is the best way to do this using ChangeDetector?Currently, when I use ChangeDetector, the records from the changes spreadsheet are output to Inserted; The records from the original spreadsheet are output to Deleted. Deleted includes the 3 unchanged records that are in changes spreadsheet.  In the screenshot below the 95,392 in Deleted include the unchanged records that are in Changes. The transformer outputs the Original and Revised separately with no way for me to delete the 3 records in 95,392 and add the 3 changed records? 

I built a flow where an Excel spread sheet updates a snowflake data table. The spreadsheet in located in a SharePoint documents library. To get the flow to run on an online FME server I had to put in a SharePointOnlineConnector. When I run the flow, I keep on getting “Could not decode contents of ‘jjjjj.xlsx’ as ‘utf8’. I’m running FME workbench 2022.2 at the present time. Any ideas on how to clear this error would be greatly appreciated.

I am trying to convert 15 dgns (approx. 50 MB) into 5 gdbs using a workbench. The conversion is aborted with the error shown in the jpg. If I deactivate a few readers (dgns), the run is completed without errors. Could this be a memory problem? Please help.

Hi, I'm trying to dynamically create the line drawings in a GTFS, that is, I want to create the shapes table, which is empty by default. I thought that it must be possible to do from the stop_times table, the stops table and the 'mother' lines in kml that contain the total theoretical route of each line. With stop_times I can know all the patterns that each line has (starts and ends) identified with stop code. patterns from stop_times.txtstops.txt, with coords The spicy part starts here. I should cut the parent line by start and end, keep the correct segment - I don't know how to identify it - and reorient it in case the 0 vertex of the line doesn't match the stop coords origin The thing is, I don't quite know how to do it. Any help would be appreciated. Thank you very much!Pol PD: I cannot attach KML on this thread. ‘Mother’ lines comes from there:R11: https://www.google.com/maps/d/u/0/viewer?mid=1Oovi7a-WCKVFI_h4IigcGDBCXPo&femb=1&ll=41.91271293489377%2C2.6520825662537018&amp