Using readers and writers to extract and load data.
Recently active
I am trying to update approximately 10 attribute fields in a point layer in AGOL using FME. When I run the script, it keeps failing and I’m not sure where the hang-up is based on the warning and error messages I am getting. Below is what I keep getting once my script has failed, with the ones in red being the error messages (the last two bullet points): Feature Caching is ON The workspace may run slower because features are being output and recorded on all output ports regardless of whether or not there is a connection. ArcGIS Online Feature Service Reader: Reading from from feature service 'https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/HII_2020_2022/FeatureServer' using filters defined in 'HII_2020_2022' ArcGIS Online Feature Service Writer: Feature Service 'HII_2020_2022' does not support geometry updates. If features contain geometry, the geometry will be ignored ArcGIS Online Feature Service Writer: Attribute 'OBJECTID' on feature type 'HII_2020_2022' is mar
Hi,I am hoping someone can convert a Geodatabase provided by the United Nations (Unitar & Unosat).It is published under creative commons 4.0.The map shows each building damaged in Gaza.I do not have any product that opens Geodatabsae files.I would be appreciative if someone could convert the file into KML so I can open the file in Google Earth.The zipped geodatabase file is 2.35Mb.The link is the location of the Geodatase file. https://data.humdata.org/dataset/unosat-gaza-strip-comprehensive-building-housing-unit-damage-assessment-march-2024#I have also attached two images.The first image shows the page with the GeodatabaseThe second image shows how the UN have used the file to present to the public.I have submitted a request to UNTAR however they have not responded.ThanksHarry Sullivan
Hello FME Experts,I'm currently working with road network spatial data, which contains a multitude of line features representing roads. Each road feature intersects with others, and I need to determine the correct start and end names for each road segment (i.e., the names of the roads at the start and end nodes).I'm wondering if there's an efficient way to accomplish this using FME. Specifically, I'm looking for guidance on:How to identify the start and end nodes of each road segment. How to extract the names associated with these nodes.Any suggestions, workflows, or examples would be immensely helpful. Thank you for your insights!Best regards,Vishnu N V
Hi,I am creating some admin areas which feature multiple islands within each admin areas.I am using the Aggregator to group the areas, and that is looking fine in the Inspector.When I come to write these features to an esri ArcGIS Portal Feature Service, I receive the following error:<type 'fmeobjects.FMEAggregate'> cannot be converted to esriGeometryPolygonI am building Homogeneous Collections where possible, but even the admin areas that are made up of a single contiguous area have "fme_aggregate" as "the fme_geometry(string)" attribute in the inspector.
I am trying to bring in some files that are dgn/bentley related (cit and nm1) and I can’t figure out how to read these files or view them. I found in a search this site that says how to read a .cit file but I can’t find this or how to view these?https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/ingr/ingr.htmI do not see this INGR in my lists or anything when I put in reader format .cit
Hi all,i have following problemi join a gdb (with included domains) with an excel sheet…...if i don’t resolve the domains the feature class is written but no geometryif i resolve the domains i have geometries right but no domains anymore Can somebody help me? Thx Franco
Hello,I have a workbench, which when published to FME Server - is not updating the data, rather - I am getting the cached data. Is there any way that when I publish the workbench to FME server- can I use the option of “Rerun Entire Workspace” rather than “Run Workspace”. Please find the below snapshot of the options in workbench : Also, want to mention that - when I did ran the workbench in FME Desktop - it updates the data only when I use the option “Rerun Entire Workspace”, but when I use the option “Run Workspace” - I am seeing the cached data. Please let me know If I am missing anything.
Hi all,i’m building an FME desktop workspace for eventual use with a server automation. we’re taking some emails, parsing them for some specific data, reading text files with additional information, and then putting it all together to be sent out via an API for a software called Desk Alerts.Where i am running into issues is - the text files are UTF-8 encoded and contain line feeds and tabs that the API isn’t happy with.so for instance i might have a message that looks like: now you can see i’ve got 4 tabs and almost 20 line feeds.this text is actually the combined result of several files and the content is variable so for readability’s sake maintaining the line feeds (and preferably the tabs) is paramount.When sending to the API, i get the following error response: {"status":"Error","errorMessage":"Request model invalid","data":{"validationErrors":["[queryParam] : The queryParam field is required.","[$.body] : '0x0A' is invalid within a JSON string. The string should be correctly escap
Hello Experts, I have two Layers PD and AA. I want to align the PD layer to AA layer. Any help would be highly appreciated. Thanks in advance
Hi All, I want to update geometry column (esri SDE) from postgresql writer. What I need to do ? esri keeps the point value like. 2D000000010000000100040001000000110000000101000090D1D3C2A00380A6E4AFBA0880A8D6B90700000000 I can reading from the postgresql as sde.asText / asBinary but I can not write
Hello, I have a folder containing multiple shapefiles, for example, (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after every iteration, so i can't get a configuration of the loop. I appreciate any assistance or proposition you can provide. Thank you.This is my wokspace and the custom transformer , using a loop.
HelloHow could FME detect unwanted spike and unwanted zigzag and fix it without changing geometry of lines ?I have used spike remover and zigzag remover but sometimes it catches data that has no relevant with spikes ,what is best angle for transformers?How to keep the original geometry without changing it ,after fix the problem with zigzag or spike remover ?what is the best method to detect dangle lines and fix it ?thanks in advance fme 2021
Hello all,I want to understand the difference between two MapInfo WritersI am running FME Desktop version FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)The Writers are;MapInfo TAB (MITAB)Precisely MapInfo TAB (MAPINFO) Is one Writer better than the other?
Hi, I have some questions about how to make a CityGML more efficient. Context: I have about 1.8m pipelines and cables. I want to visualise these as 3D cylinder/pipes (not actual ‘FMEPipeGeometry’), regardless of the ‘is it necesary to do this’. All features also have attributes like diameter and such. I want to write this to CityDB and CityGML. This results in huge filesize (somwhere like 15gb or 20gb). What I did: My thought process was it would be more efficient to use relative geoetries (a circle) that I extrude/scale/offset/etc to the proper location using the transformation matrix. Of course I cut the original geometry into pairs of 2 vertices. I wanted to reaggregate this to 1 feature once I had the relative geometry up and working. This all worked just fine until I discovered that in CityGML schema the cardinality is 0-1 on features with relative geometry. This means I cannot gather all separate bits of the cables again, giving me an even more absurd amount of features. I also
The Esri ArcGIS Portal Feature Service Reader has most of the capabilities needed to read from a Utility Network including being able to set branch versioning. However there doesn't seem to be a way to resolve domains that are defined at the subtype. The Utility Network uses the subtype layer concept where domains can be applied differently on each field by subtype. Is accessing the subtype domains something the FME can/will support?
I am trying to edit features (location) that are within a trace network from FME.When editing in ArcGIS Pro I’m able to move features and have the network adjust (example: Move a point connected to a line and the line moves with the point) but I am unable to replicate this behaviour when running from FME. It simply moves the point feature away from the line. Notably I did have this working in a geometric network but since completing a recent upgrade and moving to the trace network in ArcGIS Pro it’s not showing the same behaviour.Is it even possible to maintain the network structure using a trace network out of FME?
I have been working on FME for a while now. But not much with geo-related issues.A user receives requests : With and without address. Requests without addresses do contain coordinates (in both RD-Amersfoort and ETRS89)The user would like to see a map with a polygon in it.What steps/attributes do I need to realize this?I have already tried with the following attributes : AttributeReprojector, AreaBuilder, HullAccumulator Please give your advice and tips
I’m fairly new to FME. I’m using FME Workbench 2023.1. I am trying to recreate an excel output similar to the below image, but I’m not sure FME is capable since there isn’t much information out there on using FME to write an excel output like what I have a need for… All I see is more simple outputs. I need to be able tie the output values of a lot of those cells to data created in other transformers, but since the layout is not your typical excel sheet layout, I can’t seem to find any info if you can use a template and then tie the output from another transformer to the particular cell it goes with in the excel template. If anyone knows where I can find more information on this, I would greatly appreciate the help! Sample template with values
I am totally new to FME.I would like to merge all the shapefiles located in the all the folders called 2012. Any ideas how to do it?
Hi!I have many workbenchs to manage and I would like to find a way to create a table linking the workbench name with the output writers of each workbench. The goal is to find which workbench generates which table(s). My idea is to add a custom transformer to all my workbench. The information I would like to have is :name of the workbench directory of the workbench writer information (table name, table qualifier and writer)With ParameterFetcher, more specifically, the FME_MF_DIR and FME_MF_NAME parameters, I can get the information about the the name of the workbench and directory. But I cannot find a way to extract the information of the writers. All the writers I have are in a postgis format.I would prefer not to use Python if possible. I’m sure there’s a way to extract the information since it appears in the log, I just don’t know how to get to it! Thank you 😀 !
"Hello, I have a folder containing multiple shapefiles, labeled as (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after everh iteration, so i can't get a configuration of the loop. I appreciate any assistance or proposition you can provide. Thank you."
Hello, I am trying to convert an shapefile in IFC format, never did before.What I did is to connect the reader for shp format to a writer for IFC format but the result is empty.Please, can you explain me the setting to use or the procedure to perform this conversion?Thanks
Hi there, I am getting an Error on Windows Server FME 2021.2.5 when add Reader FGDB and tried to open Tables. (Geodatabase Error (-2147024894) Please see the attached image for more details.I have used FGDBs many times using FME, Windows Server Patches installed by the IT Department recently and it seems since then I am having this issue on FMEI have tried on different servers, ie: Windows 2012 & Windows 2019 and FME on all servers have the same issue.I can drag and drop FGDBs on to the FME Workbench canvas without any issues. Could anyone help me to identify this issue and let me know how to resolve it?thanksRegards,Pushpa
We have a series of databases (postgis) that get _year_month added to their endings so that we can see which one is the newest. The rest of the name, schema etc is the same.It would be convenient to have our workspaces automatically look for the most recent database.So if there exists: supercooldatabase_21_09, supercooldatabase_23_07 and supercooldatabase_24_03 on the server I would like to have FME check all supercooldatabase’s and select the one with the higest number, aka _24_03. This attribute would then be passed on to guide FeatureReaders correctly.Would it possible to do this within FME?
Hi, I am using a sql executor reading dynamically some data from our db. I am using following query: select * from t_@Value(F_CLASS_NAME) where fid=@Value(FID). How can I expose the attributes of each query ? I can not use the attribute exposer of the sql executor as the attributes name and number change depending on the table name. I tried a few things but nothing has worked so far. I am reading about 10-40 tables so I want to avoid to manually type in all diff attribute names.