Using readers and writers to extract and load data.
Recently active
Hi,It's possible to use FME Desktop to obtain indices like NDVI from images without downloading them? Thank´s
I am having a unique issue where I cannot write out the date 19700101000000 (01/01/1970) to my ‘Date’ data type fields in an Esri sde feature class. How do I fix this problem? When I want to write out 19700101000000 to one of these fields, the writer runs successfully and I get the success message but then when I read the data back into FME or I check my attribute table in ArcGIS Pro the field shows up as 18991230000000 (12/30/1899). The date is formatted correctly. I can write out other dates no problem. I can write out 19700101000001 and 19710101000000 no problem. I just can’t write out 19700101000000. I can open the attribute table in ArcGIS Pro and manually enter the date as ‘1/1/1970 12:00:00 AM’ (from the calendar/time picker) and the table will accept it. I can also use calculate field and input '1970-01-01 00:00:00' (python format) and the table will update correctly. I have tried using AttributeManager and DateTimeConverter to make sure the date is formatted correctly and the
I am currently researching converting ifc to citygml. fme is using a paid version with a license. When I simply convert ifc to citygml using fme, an error appears and it does not work.Do I need another method to convert ifc to citygml?
I need to extract TAB or Shape file from S3 and read data from it including schema.I have discovered in this articlehttps://community.safe.com/data-7/how-to-extract-the-actual-shapefile-from-featurereader-geometry-and-attributes-14548?tid=14548&fid=7that FeatureReader apparently can’t read all attributes that are in the file, until I expose them. But what is I don’t know the list of all attributes? I don’t know what exactly will be uploaded by other people to S3 bucket, I just need to read the file. Could you help, please, to identify the correct settings of FeatureReader or another way to extract data?
Hello,I am authoring a workspace, that uploading data in PostgreSQL database.And I have difficulties to implement one function.There is a validation that checks if value is not empty or null. If object has missing unique S_ID, it is still gets uploaded in the “Data” table. But also, I add a record in the “Errors” table, that feature has missing S_ID.When features get uploaded in the “Data” table they are automatically assigned another unique key “ID” this is just a sequential number in “Data” table. The task for me is to add “ID” from “Data” table when I create a record with error in “Error” table. Because it will be the only unique attribute by which feature can be identified in case it is missing S_ID. The difficulties for me is that I am logging errors earlier than ID attribute is assigned to the uploaded features. I thought to use VariableSetter and Variable Retriever that should help in this case. But I don't know how to extract “ID” attribute anyway. I am using FeatureWrite
This seems like it should be really easy to do but I’m spinning my wheels. I have a dataset of points, each with an attribute of Contract Number. I have a set of polygons also with Contract Number attributes. I need to determine if the point falls within a polygon AND the point contract number matches the polygon contract number that it falls within. What’s the best way to achieve this?
I am trying to change the FME Server database from the default Postgres to SQL Server. I have followed the instructions in this link: http://docs.safe.com/fme/2018.1/html/FME_Server_Documentation/Content/AdminGuide/Changing_Database_Provider.htmbut after everything is done, I cannot login as admin anymore. I get the login page to come up, and I can confirm that connectivity is there to SQL Server, but it won't accept my password for admin anymore.
Hello,I’m working in FME Form (both tested in 2023.2 and 2024.0 ) with DGN files contaning 3D objects in Smart Solid format.I’m looking for some possibility in controlling solid to mesh decimation process. At the moment I can’t find any way to change default way how FME Reader create mesh from solid objects.For example some circular object is decimated as 8 vertices.I’ve already tested Stroking Tolerance without any effecthttps://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Stroking_Tolerance.htmand “Number of interpolated curve vertices” in DGN Reader parametrs. Any suggestions?
I have multiple sensor output csv files that have the same field names that changes with every single file. The locations of the fields stays the same which is good. An example is ID, DATE, TEMP, COND_HIGH, COND_LOW. If the reader field names are changing constantly what is a good way to strip those names and put the simple ones above in their place? I have attempted or looked at the Schemamapper, but I’m not sure if that is the route to take. The other way I messed with was Reader > UUID > AttributeExploder > AttributeCreator (Conditional Statements) > Aggregator? Any help would be appreciated. I think I am making this harder than it needs to be.
Hi together, Is there a way to delete the content of a ffs file but not the file itself? I am using FME 2021.2.0.1. Thanks for your support
I’ve seen that FME 2023.2 Build 23764) doesn’t recognise ArcGIS Pro 3.3 for access to Esri licenses. Will this be resolved in 2024.1? I haven’t tested 2024.0 as I’m waiting on the .1 release
I’m combining lines based on end noded while keeping some attributes in a list for each original lines (1). Then I create a new attribute based on the lists (2) with conditions based on numbers in the lists (3). I would like to set up the condition statement dynamically: the number of lists varies each time I run the workflow so I would like to pick numbers from the last list available (in this case PR_list{2}) and do something like: PR_list{0}.ORIGINE < PR_list{max}.ORIGINE instead of choosing the list manually. Is it possible to create a dynamic condition in the condition value definition?
I am currently reading all .dwg files from a folder with a dwg reader and it works well. To gain time, I would like to select in the reader the layers I want to keep (named “CADRE”) instead of reading all the dwg files and the thousands of elements contained by them, which I filter after as I am doing currently (see photo). I looked the reader documentation and on forums but I can’t find the right parameters, is it not possible to do something like that? Thanks for your help!
Dear All, I'm looking for tools to write ENHANCED COMPRESSED RASTER GRAPHIC (ECRG, MIL-PRF-32283) and High Resolution Elevation(HRE, NGA.IP.0002_1.0 HRE) files. I have searched the FME reader/writer list, and these two formats are not on the list. ECRG and HRE files are physically formatted within a National Imagery Transmission Format 2.1 (NITF 2.1). Is it possible to use NITF writer to export ECRG and HRE?
Hi, I have a problem. I just created a line out of multiple points of an x,y,z text file with the LineBuilder tool. The problem is that the points name are lost. After the LineBuilder I use a Chopper to split the line into segments. Now I want to add a new attribute to the line segments, which has the initial names of the points. Because due to the LineBuilder the names are lost and are everywhere the same. How can I do that?
Hi Community! I was wondering if anyone had an idea of why I am getting different values for polygonal areas when calculated in FME using AreaCalculator vs the SHAPE_Area attribute of an ESRI feature class?The geometry I am working with enters the workbench with a defined projected coordinate system (DUB-DTLM) from a dwg file and the feature dataset in which the destination feature class resides is also in DUB-DTLM.The discrepancies are minor (at the 3rd decimal place in sqm) but nonetheless have the potential to cause issues.Interestingly, when the features are interrogated in Map3D, they show the same area as is calculated in FME.Any explanation (or even hint!) as to the cause of the difference would be much appreciated.
Hi, Is there a way to divide records into equal parts based on the value of an attribute? In concrete terms, I want to divide 400 areas into 3 pieces, each of which is the same size.Thx
Hi. reading LYRX (“layer files”) from ArcGIS Pro failes when the layer file include Grouped Layers. It works just fine if the LYRX file does not include Group Layers.Thea Layer File/LYRX is made with ArcGIS Pro 3.2.2 where the LYRX file is in JSON format.
Hello.I’m trying to convert and IFC file into CityGML 3 file using the ifc-to-citygml3 FME Workspace, but when I tried to Run it, it shows this error.ISO10303-21: The input data contains a syntax error at the beginning of the file. The file should start with 'ISO-10303-21'. Ensure the file is in an ASCII character system, with no byte order marker.Unexpected character: #ISO10303-21: Invalid file format, unable to continue reading Can anyone help me fix this issue?
Hi All,I’m working on an automation that needs to identify those lines that follow the geometry from another layer. The following screenshot explains what I need to do: Red line follows a river (not exactly the same geometry but pretty close) and need to identify those red lines that follows the blue centerline….I was thinking maybe I need to calculate the percentage of overlap between red and blue?There’s other locations where the red line only overlaps the blue lines for a little section so I can ignore those, see belowAny idea how to approach this?
Hi, I am new to FME so might be making a rookie mistake. But I am trying to update AGOL from a GDB shapefile but it won’t update in AGOL. I have managed to get everything to work and it shows the updates but its not sending the data to AGOL. What am i missing here?
I have a .csv file with x, y, z coordinates. From these points, I want to create a 3D line. Currently, I have the issue that the z coordinates are not being transferred onto the line when I create a line from the points. Does anyone have an idea of how I can proceed?
I had a FME scenario running to read the feature service and related tables and write to an excel file. I have the excel writer setup to “Fanout” the dataset which used to drop each table from the feature service into its own sheet within excel. I went back to run the FME scenario and when I check the excel outputs some of the tables are missing. Prior to running the scenario I check to make sure all the tables are checked and that the reader is seeing all of the tables, which it is. I check “select all” and run the scenario but when I check excel I get 6 of 9 tables. I have double check every setting and even started a new FME template and recreated the reader/writer but I still don’t get all the tables in the excel output.Can anyone help me out? Thank you
Hi Everyone..I was able to find a workspace from community this template attached and did few changes to it and it is working as expected with sample template provided in workspace to create a GDB with domains , fieldnames and field alias. 1) This workspace consider single default words in domainlist provided in excel only like Domain1 - Attached Sample_1_Workspace template - works with 2023 version.This workspace consider single altered words domainlist like alphabets(A,B,C….) in Attached Sample_2_Workspace_template - works with 2023 version This workspace consider 2 words in domain list like FME form in attached sample_3workspace_template -doesnt work and workspace fails.. If there are any special characters or space it doesnt work like : FME Form or FME_Form. I have attached error log and all sample data files with with each workspace.. Any Experts Kindly support : How can i resolve this with text as FME Form or FME_Form (with a space or special characters. Thanks
Greetings, I’m trying to use an ETL to convert RVT files (2023) into File Geodatabase multi patch, however, the following model produces the right objects, but in the wrong location, even though when reading the RVT file directly in ArcGIS Pro, the building falls in the right place. Any clue?