Using readers and writers to extract and load data.
Recently active
I have a giant spreadsheet that many people have added notes or comments to by right-clicking on the cell and saying "new comment" or "new note". Is there a way for fme to figure out which cells have comments?
Hi, I created a shapefile with line segments (roads). This shapefile has to be loaded into a postgis database and the person who has to do that sends me that she gets this error ERROR: Column has M dimension but geometry does notCONTEXT: COPY tmp_shp_crab_wegsegment, line 1, column geom: "01050000208A7A00000100000001020000000700000000F3BE9F41600A4180690B0048FD0941005FDD2623600A41008F7F97..."I did some searching on the forum and found some things like the Measure remover, and I also set the output dimension to 2D in the writer but she says she still gets it. Does anyone know what else it could be due to? Thx!Nathalie
Hi everyone! So I have some LAS files that I would like to filter. The flow is as follows:Everything seems to be working, but when I read the processed las-files into my program that I need to use, I can’t get it to work. The original files do work, so it’s something that happens along the way. Any ideas?
I’m trying to read this wfs-service https://avoin.metsakeskus.fi/rajapinnat/v1/gridcell/wfs or alternatively https://avoin.metsakeskus.fi/rajapinnat/v1/gridcell/ows with FeatureReader and FME returns following error: 2024-09-11 10:32:43| 0.0| 0.0|ERROR |<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema=" xmlns:ows="http://www.opengis.net/ows=" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance=" version="1.0.0=" xsi:schemaLocation="http://www.opengis.net/ows https://avoin.metsakeskus.fi/rajapinnat/schemas/ows/1.0.0/owsExceptionReport.xsd="><ows:Exception exceptionCode="InvalidParameterValue=" locator="namespace="><ows:ExceptionText>Unknown namespace [v1]</ows:ExceptionText></ows:Exception></ows:ExceptionReport>2024-09-11 10:32:43| 0.0| 0.0|ERROR |Received error report: ExceptionReport2024-09-11 10:32:43| 0.0| 0.0|ERROR |The XML Module halted on error, see the logfile for details2024-09-11 10:32:43| 0.0| 0.0|ERROR |A fatal error has oc
Hi guys i been working on a “easy translator” type of app on Flow and really struggling to get it read shapefiles in a zipped file. Error message below.. have no idea why it add a “_0” after “.zip”.. can this be the reason it failed? Shapefile Reader: 'C:\Users\SVCAWS~1.SC\AppData\Local\Temp\fmeengines\AWSGISFME01_Dynamic_Engine1\TempFS_1725628283291_20936\dsGENERIC_1_0\Inputtt.zip_0' is not a valid Shapefile and cannot be read Thank guys!
I have a fileGDB with a single feature class, and that feature class has metadata.How do I export that metadata to an XML file?I am using FME Desktop (FME Form) 2022.1
Hello, I have recently upgraded FME Form 2024.1. I tried to run a project, but I immediately got the following error message: “FME failed to restore the process locale to UTF-8. A non-UTF-8 process locale may cause undefined behavior.” Is there any quic fix for this issue?
Hi, Is it possible to rollback all the inserts been made to database through multiple writers(Oracle/Esri) if one of the writers fail?
Hello guys,i am a little desperate in my attempt to write data from our oracle spatial database to AIXM gml. I already watched the Overcoming the Complexities of AIXM with Model Based Data Integration - FME by Safe Software webinar and also read this artical https://support.safe.com/hc/en-us/articles/25407686750477-AIXM-4-5-and-5-1-Reading-Writing-and-Validation-EU-Airports-Demo. discussing the matter. I even downloaded the demo workspaces to try to figure out why exactly mine is not working but without any result yet. I will attach my workspace , a log-file of a successful translation and the resulting gml file to this post and i hope that someone can make out the issues.Dont wonder about the Geometry-Extracter and Geometry-Replacer transformer i use in the workspace, i have already tried it without them and thought they could help, but also with no result.Thank you guys for reading this and helping me out in advance, it is very much appreciated!
HelloCould not able to write “Esri Geodatabase (File Geodb Open API)” facing Error Geodatabase Error (-2147219884): this so frustrating form last 2 days i am suffering from this issue.
Team: I have been developing some processes in fme server 2018 and have an issue that I am not sure how to troubleshoot. The work bench is pretty simple, read access, sort some things, a couple of joins and then push the data into a clean database that has the same schema as the source data via a feature writer instead of an access writer in the workbench—this forces me to use a 2 step approach as I have some SQL executors port processing.The feature writer works in desktop but not on server. Initially, I thought it was a permissions issue, but then I broke the process—to a 2-step approach—each process worked fine independent of each other. The log below contains the information related to the issue that I had with the first approach—handling everything in 1 process. I was basically pushing records to a couple of clean preexisting tables. I don’t have a project number for support, I will be happy to talk to any of you later tonight to see if we can solve this to make sure its not a p
Hi guys,im working on a data loading workbench for our sql sde database. when applying change detection before writting into database, is there a way it can be dynamic and detect changes in group? Like original dataset a comparing to update dataset a, and b to b with key and compare field listed in a sheet? Thanks guys!
Hi All, I am trying to reproject some .e57 files containing LiDAR scans and oriented imagery collected with a terrestrial scanner. Reprojecting the point cloud is straightforward, but I am having some trouble with the imagery.I can see in the Feature Information window that the image locations seems to be stored in the e57_translation_x, y, and z Geometry Traits (Geometry->Raster->Geometry Traits), here’s a screenshot from Data Inspector:I’m working from a local coordinate system, hence the low translation values.My goal (I think) is to extract these translation values, reproject them in the same way I’m reprojecting the point cloud, and then write the new values back in to these traits, but I’m not sure how to access these trait values, and was wondering if anyone had experience with this. Thanks for looking!
Hello everyone,I'm looking for a way to check if the ending character of a string attribute is an uppercase letter, and if so, convert it to lowercase. For example:Foo1K → Foo1k BAR4 → BAR4 BAZ → BAzWhat's the best way to accomplish this in FME? Are there any specific transformers or approaches that I should use to achieve this result?
Hello there, How can I read a tsv file in FME? Do we need to use csv format only:? Thanks,Siva
I have a shapefile that can’t be read by FME Workbench 2024.1.1 or 2022.2.3. The copied log is attached.The “Speed Zones” shapefile comes from https://opendata.transport.nsw.gov.au/dataset/speed-zones where you have to login and download the "Speed Zones data" as a ZIP file. Once unzipped you get the standard 4 files.When I load the shapefile into QGIS, it shows the following properties: 434MB MultiLineString 442,943 features EPSG:3308 - GDA94 / NSW Lambert Fields: Type Text (string) 200 length Status Text (string) 200 length Direction Text (string) 200 length Speed Text (string) 200 lengthThe only issue I can see is that there is no unique identifier field but I didn’t think that was an issue for FME. Any suggestions on how to read this file into FME?ThanksDoug
Hi,I have an NDVI raster and need to clip it with many polygons. After that, I need to calculate the standard deviation for each piece of the raster (clipped by the polygons), and in the end, I need to correctly assign the deviation value to the attributes of the corresponding polygon. Thank´s
Not a question, but just an issue I thought worth sharing. When converting my data to a geodatabase, I kept getting the following error message: "Geodatabase Error (-2147219884): The Field already exists". Not a very helpful error message and googling this didn't help much.It turned out that my sewer pipe input file had a field named 'shape', and geodatabases don't like that! Using the AttributeRenamer to change the field to 'shape1', everything then went tickety-boo!
Is there any way to read dynamically any excel file and that the header are simply the column name A, B, C, D...Through a Reader I can read any Excel file but the problem is that it always takes the first row as the header.Thank you!
Hello,I am running on macOS 14.6.1 and I use FME 2021.0.3.2 which stopped working from today. It crashes after “Initializing Main Window”. I am attaching the relevant part (I hope) of the crash report. Has anyone run into the same problem?(Data inspector and Quick translator work, only Workbench crushes)Thank you! Notes:PC register does not match crashing frame (0x0 vs 0x7FF89317AA78)Crashed Thread: 0 CrBrowserMain Dispatch queue: com.apple.main-threadException Type: EXC_CRASH (SIGABRT)Exception Codes: 0x0000000000000000, 0x0000000000000000Termination Reason: Namespace SIGNAL, Code 6 Abort trap: 6Terminating Process: FME Workbench [1810]Application Specific Information:abort() calledError Formulating Crash Report:PC register does not match crashing frame (0x0 vs 0x7FF89317AA78)Thread 0 Crashed:: CrBrowserMain Dispatch queue: com.apple.main-thread0 ??? 0x7ff89317aa78 ???1 libsystem_kernel.dylib 0x7ff802e92db6 __pt
Dear all,I’m spending a lot of time trying to sort out an issue with a substring operation but I cannot see my results are not correct in several places.In FME workbench 2024.0, I use the the AttributeManager to read a substring from the attribute _response_body and to write it to the attribute info. The response body is the result from a reverse geo-coding with OpenStreetMap and I want to extract the location for the given coordinates. To extract the relevant part, I use the following sequence of String operators:1) Take everything left of </result>2) From this, take everything right of address_rank3) From this, take everything right of >The actual (unfortunately complicated) condition statement which I’m using is:@Right(@Right(@Left(@Value(_response_body),@FindString(@Value(_response_body),</result>)-1),@StringLength(@Left(@Value(_response_body),@FindString(@Value(_response_body),</result>)-1))-@FindString(@Value(_response_body),address_rank)),@StringLength(@Righ
Hello, I am using FME 2022.2 and I’m trying to load in Raster data, based on an Area of Interest (AOI), specified by the end-user in FME Server (yes my organization is not using FME Flow yet, but the old FME Server). We have a few big Raster datasets on a local drive (of the entire Netherlands), which are loaded in as regular Readers. Then, using a Creator and GeometryReplacer, the end-user can specify an AOI (using a User Parameter), and the Rasters are then clipped in the Workspace using a Clipper. However, this means that the big Raster datasets need to be loaded/processed every single time the Workspace is ran, which is bad for performance. What I want, is that the Raster data is loaded into the Workspace, but only the data which intersects the AOI, specified by the end-user. I tried using a FeatureReader and use the AOI from the end-user as trigger to load in the Raster data. However, for some reason, the entire Raster dataset is loaded every time, instead of only the Raster data
Hi!So, I have a workbench that takes a shapefile and an excel file as input, does some magic and outputs an excelfile. The workbench works as expected. So far so good. Se image below. Now, I have a number of shapefiles that I want to process in the same way, so I figured a workspacerunner would be a good solution, instead of replaceing the input shapefile in the image above.So in a second workbech, I take a PATH as reader, filters out my shapefiles and into the workspacerunner (see img below). Everything seem to be working - but only the shapefile that has the same filename (test.shp in the images) gets treated properly.So in this example, test.shp get an output excel file that seems fine, but the other two does not. Any ideas of why that is? My guess is that I’m doing something wrong 😅 I can’t share the workbenches I’m afraid. Cheers!
Hi,I'm programming in Python using FME Desktop, specifically using the Python Caller transformer. I'm trying to use a variable called test in my script, where test should have the value assigned to the attribute _creation_instance. I'm declaring it as follows: test = feature.getAttribute('_creation_instance'), but I'm getting the following error:Python Exception <NameError>: name 'feature' is not defined How can I properly get the value from _creation_instance? Thank´s
Hi, I have a workbench which is fed by a set of user parameters. It produces a dataset of 10.000+ buildings for a chosen municipality and extraction date. Is it possible to create an input which loops through these user parameters:Userparameter 1: CityUserparameter 2: Extraction dateRun City Date 1 A 2020-01-01 2 B 2020-01-01 3 C 2020-01-01 Workbench should behave like first run City A with first date, than City B with 2nd date, than City C with third date