Using readers and writers to extract and load data.
Recently active
Hello,I'm generating a DEM file with the writer U.S. Geological Survey Digital Elevation Model (USGSDEM)However, whenever I click somewhere on the DEM raster that is generated, I obtain a round up value to 1 meter.Just before going into the writer, I have an inspector on my data and I do have floating point value for the elevation.Is there a way to force this writer to not do the round up and keep the value in floating point? Thanks
With FME Desktop 2019 and newer, Postgres and Postgis support SSL, this mode has different options as shown below in the screenshot. By default: Value is set to Disable For Verify-CA and Verify-Full, options the root certificate needs to be stored when connecting to RDS instances.
New to FME and befuddled by the performance disparity of Oracle Non-Spatial reader over high-latency network links. Needless to say, I understand the benefits of having FME close to the data, but… I compared the performance of the Oracle Non-Spatial reader against a CSV export from Oracle SQL Developer of the same database view on various machines in various locations on our network. The size of the fetch was 46394 database rows with just 8 columns. From a desktop machine in the data centre close to the source Geodatabase:SQL Developer CSV Export: 8m16sFME Desktop Reader: 10m11s From a remote desktop machine on VPN:SQL Developer CSV Export: 8m50sFME Desktop Reader: 72m Remote FME Server:FME Server Reader: 32m9s The most interesting fact is that the SQL Developer export suffered almost no performance impact even when it was executed over a high latency network link whereas the FME reader was de
Hi All,I'm a bit behind the curve with JSON. Could somebody help describe the process to expose the three attributes in my simple file sample following: {'items': [{'att1': 'abc', 'att2': 'xyz', 'att3': 123}, {'att1': 'cde', 'att2': 'tuv', 'att3': 456}]} Notice that 'items' holds all the attributes. I have successfully setup a reader to intake the JSON, but now need to expose the attributes att1, att2, and att3. I looked at several transformers, but the parameters are somewhat foreign to me. A detailed workflow would be much appreciated, since some of the JSON lingo is foreign to me. Thank you, TylerFME Workbench 2021.0
Hi,I read several WMS layers (from the same source) and each layer is written to a single layer in a pdf. For example, I read a WMS background map and write it as one layer, then I read a WMS line network and write it as one layer and this is where I have problems. In my line network layer, I want everything to be transparent, except of course the network itself. Can I create pdf with layers that are transparent for some values (white, no data...) by using a WMS source ? If not, is this a limitation of FME pdf writer or the pdf format itself ?I can't use the workaround by "pre-generating" the layers before writing them since the pdf would be huge.By the way, I am using FME 2013...Many thanksRickard
Hello, I would like to convert an IFC file to a geodatabase, with all properties. The transformer "Geometryfilter" is really good to convert the model to multipatch, but I can find how to get data set in the "IFCPROPERTYSINGLEVALUE" to my geodatabe, consequently the values present in this field are missing in the exported geodatabase.Thanks for your help!
I need to write anotations to a DGN file (v8). To generate the labels (anotations), I'm using LabelPointReplacer, followed by AttributeCreator, where I add specific igds attributes manually. Everything goes well with a single exception that I'm unable to resolve: I set up igds_font attribute on each feature manually. If the input string is composed of basic alphanumeric characters, all goes as expected and correct font is used to write the feature. If non-standard diacritics (Czech) goes in, the igds_font is forced/overwritten to 1025 (Arial) in the writer. I was trying to add/alter multiple igds attributes, to specify Resource Font File, to play around with encoding of the incoming String and eventually went out of ideas what else to try. I'll appreciate any ideas. Thx.
Hi All, im trying to put a basemap under some vector linework output as a pdf.... Currently i use a http fetcher to get an esri basemap jpg, georeference image then use pdf formatter to try and combine the vector and raster. it all works perfectly when sent to an inspector but when send to pdf i get nothing.... is there a simple workflow im missing somewhere ? similar to this https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_DataInspector/DataInspector/Background_Map.htm with the data inspectors basemap under my data. I just want a raster basemap underneath my outputs. I have read lots of posts around this but not found a solution that works for me.
I have an Ifc Model that I read in as multiple features using the IFCreader. Aftwerwards I am using the Esri Shapefile writer to output a single feature e.g. "IfcWall" to a shapefile.The translation is shown as successfull, however there is no file being written in the output directory...Could someone point me in the right direction of what I may be doing wrong?Are there transformations necessary between the reader and the writer?
It is supposed to be QuadrupleD, a DirectX library for Delphi and the suggestion is to use Direct Draw with Delphi to open???
Is there a plan to support ETL for semantically rich CAD models using the STEP ISO10303 AP 242 or the ISO 14306 JT file formats? For our facilities, we develop BIMs and use IFC to extract, transform, and load geometry with associated metadata. However, we develop product models using CATIA and NX and are in need of extracting geometry and the metadata associated to that geometry. What methods do you recommend for extracting, transforming and loading these semantically rich CAD models?
Hi everyone, i hope you re doing well .i need to convert some dwg files to kml , my internship boss told me to use FME .i am new to FME , i am asking which transformers i need and how configure them ? i will attach one of my dwg files. please see it and tell me how to proceed.thank you so much.
Hi, when adding attributes to the SpatiaLite Writer, FME converts them to lowercase. However, my output needs to be in camelCase. Any ideas how to solve this? Should I raise an Idea in the Community, or is it just me? I found this track on underscores: https://community.safe.com/s/question/0D54Q000080hThDSAU/-in-fieldname-change-to-underscore-how-to-solve SQLite and GeoPackage (which is in fact a SQLite implementation) do not have this behaviour in FME.
Setting NoData and Adding Alpha Bands to Remove Black Borders (safe.com)I have already checked the method suggested in the above link, but didnt work.
Hi, I have a very simple point dataset which I am publishing to AGOL. It publishes fine first, but when trying to overwrite it, it gives the attached error (Fme_error1). The error is strange as it mentioned FMELine, even though it is reading in a point dataset and writing to geometry type "arcgisonline_point". I have tried changing the geometry type to multipoint but it still fails. Attached also is a picture of the workbench. Any ideas please?
Hi all, I have a geodatabase which contains point, relational table that has been created. At the moment I have to manually publish the feature layer via ArcGIS Pro. I have tried to see if I can create a workbench. I have got everything working in terms of writing to the feature service but the attachments unfortunately do not come through. Is there a limitation to the ArcGIS Portal Feature Service writer for this?
I am new to FME. I have no idea which translator should I use and how to set the workspace. I would be very grateful if anyone could give me an instruction.
Hi guys, I'm struggling with getting coordinate system information in my GEOJSON file. As mentioned in documentation I've tried to add attributes json_crs_type und json_crs_properties attributes to my features, but the GEOJSON writer ignores these attributes and passes my attributes on to "properties" section of every feature. { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 630533.503899999, 475902.4741000012 ] }, "properties" : { "json_crs_type" : "name", "json_crs_properties" : "LL84" } }, Could anylone tell me how to configure my features to get the crs information to my file like in example below?{ “type”:”Feature”, “crs”: { “type”: “name”, “properties”: { “name”: “urn:ogc:def:crs:OGC:1.3:CRS84” } }, “geometry”:{ “type”:”Point”, “coor
Hello, On our server running FME Desktop 2021, we have both ArcGIS Pro 2.8 and ArcGIS Desktop 10.8.1 with background geoprocessing installed. When trying to connect to our ESRI enterprise geodatabase with an SDE direct connect file to a branch versionned dataset (https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/overview-of-versioning-in-arcgis-pro.htm), I have the following error: "This version of the Geodatabase client is incompatible with the dataset and cannot open it.It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME". So it does not recognize that ArcGIS Pro is also available in addition to ArcMap.Is it an expected behavior ? Can I somehow tell FME to use the one of ArcGIS Pro ?I would like to ideally keep both ArcMap and ArcGIS Pro as I still have many python script written with arcpy from ArcMap.
I have been trying to add file names into my shapefile using FilenamePartExtractor but it is not working...creating only blank records. Does it work on Mac.??
Hi every one , i hope you re doing well .I am FatimaZahra , i am new to FME and I need some help . i am working on my graduation project which is developing a web app that can convert any ifc file to a citygml file . For that, someone was telling me to use FME Workbrench to generate a conversion model then getting its python code in order to insert it finally in the back-end of my web app. But honestly i have no idea about how can i proceed , if some one can help me please . Wish you a Good day .
Hi, I am very new to FME so please bear with me while I try and explain what I am after. I have 215 projects that are pinned to an individual lat long. I have multiple geospatial data sources that contain various polygons of areas. I am using spatial filters to see if a project has intersected passed or failed in that filter. For the 215 Projects, I would like to create an KML with a token radius, say 500m that shows all of the other polygons around that project for that distance. If I combine all of the polygons into one KML centred on the project, the file is massive. I just want a KML reduced to the polygons that are within 500m of the project centred on the project.
What is the best management practice for setting attribute data types prior to writers, preferably at the reader? My specific issue de jour is an attribute (data e.g. 1023, 1034, 1002.1) that is reading in as real32 but indeed they need to be strings for my use case. A custom python transformer (type casting to strings) changes the values to strings '1023.0', '1034.0', '1002.1', due to real32 initial type, which won't work. I need strings '1023', '1034', '1002.1'. Thanks for reading and any response is appreciated. TylerFME Desktop 2020.2
Hey guys, I've brought some data sources casted through a query (SQLexecutor transformer with a Creator) from a postgresql DB. Applied some transformations, such as AttributeManager, and generated some IDs by adding columns with counters. And the FeatureWriter wants to write everything casted as "Text" on Automatic Attribute Definition. Before I switch to "Manual" and cast everything (again), I just wanted to know if there's a way to have the FeatureWriter recognize the casting brought over from the query. Thanks and all the best!
Hi team, Are there any example workbenches suggested where it is possible to convert an ifc file to a geodatabase?