Using readers and writers to extract and load data.
Recently active
Is it possible to publish an elevation raster as an Elevation layer / Web Layer in FME? Similar to this screen in Arcgis Pro: By using a regular writer or AGOLConnector?By pythonscript? Described here: https://pro.arcgis.com/en/pro-app/help/sharing/overview/web-elevation-layer.htm
I'm currently putting together a FME workspace that reads data from a DB2 database. As I didn't have any driver installed, I followed this guide to install them in my computer. I'm using the db2jcc4.jar driver, Everything works fine. I sent the same workspace to a client. They had installed the DB2 dirvers, so I told them to copy the db2jcc4.jar one to the plugins folder of the FME installation. When they run the worskpace, the db2jcc4.jar is ignored and FME uses the db2jcc.jar that is found in their IBM products installation, instead of the driver in the plugin folder. Is there a way of forcing FME to use the db2jcc4.jar driver? With the other one, FME reads the alias of the fields instead of the names, which provokes several errors. We are using a FME Desktop 2018.1 in a Windows machine. Thanks for any help provided!
Hello, I have a few DGN files where I want to separate the data depending on what layer they belong to. In Microstation I can see that the objects in the file is on a level, ex "Växel spårspärr bef V". But when I check the data in FME inspector all igds_level_names and fme_feature_type are set to "ECT_DGRM_RFPT_MARK". Anyone know why they are different and how to solve this?
I have several point-based datasets that I need to consolidate into an existing point dataset while maintaining all the attributes for each layer. How can I do this? Thank you
Hi all, I've been asked to read a WMS which starts with a regular looking URL, which then forwards to a URL which is proving difficult. The URL looks as follows -http://<url>.co.uk/WMS/MS/7.2.1/mapserv.exe?map=D:\\Websites\\<service>\\Services\\WMSSHARE\\map\\Layers.map&SERVICE=WMS&VERSION=1.1.1 The part that's giving me trouble is where the D:\\ is. I've tried enclosing the URL in speechmarks and using a pythonCaller to workaround this, but so far I've had no luck. I managed to get the URL changed once, but it just forwards to this one, which is causing issues. Has anyone else experienced something like this?
In our Local Authority, we're considering using FME for automating certain actions that are recurrent and would make Gazetteer maintenance more bearable. We already use a Gazetteer software, but we believe that there are actions that could be more automated, and our software doesn't do.We'd like to hear stories and experiences form users that have attempted similar things using FME, or even other ETL solutions such as Python.
Hi,I need a text based format that can handle measures values for futher treatment in QGIS. Can GeoJSON suitable for this? I currently does not manage to keep the M-values using GeoJSON as Output port and I currently can't determine if I miss some configuration option or if the format does not handle M-values at all.If GeoJSON is not the answer, what file format could I use? I need to handle custom CRS as well (EPSG:2154).Thanks for your help!
Hello,I need to control the projection associed to a dwg in fme 2018. I have tried to read the autocad_entity : autocad_info in the autocad layer 0 of a Autodesk AutoCAD DWG/DXF reader with the [read drawing system variable to read] checked but it seems to have nothing provide in any of de field.Is anyone know how to get this information?Thanks by advance
Is it possible to append to a json file saved as an Azure blob? AzureBlobStorageConnector overwrites.
FME Desktop 2020: How to permanently reorder the fields of attribute table of geodatabase feature class? In the screenshot below, I wanted to permanently move F3 to be to the right of F1. Which tool can be of help on this?
I'm trying to read the attached Civil 3D file, extract non standard attributes and certain geometric details such as edge strings. I've attached a screenshot of the file when viewed in Civil 3D, and displayed the 'Property Sets' or attributes I want to get out. I've also attached a shot of what FME makes of the file. Anyone know how I set FME to read the attributes in the dwg and expose them so they can be worked with in Workbench?
Hi,Is there a way to read Civil3D Feature Lines in FME, without having to explode them to 3D Polylines manually in advance? Jasper
Hi, I am using FME to write a Shapefile to PostGIS and I am wondering if there is a way that you can specify that it writes polygons only? When it is writing into PostGIS it is coming in as an unknown geometry with a warning triange!
I am utilizing FME Cloud (Server 2020) to run a regular ETL pipeline from a Firebird database using their Jaybird JDBC driver. Working with a local instance and FME Desktop seems to have no issues with connecting and running SQL statements.The database cannot have external ports opened due to sensitive data being stored within it. However, we are able to create an SSH tunnel to a jump server that is otherwise locked down which FME Cloud could then use to create a connection. Needing to keep a secure encrypted connection throughout the entire path I have managed to load some external Python libraries and establish a temporary SSH tunnel from the FME Cloud instance to the jump server for the duration of the workbench execution. I have tested this connection by using the Firebird Python library in a PythonCaller to execute an SQL statement successfully.However, when I try to use the SQLCreator or SQLExecutor with the already established to work JDBC driver with this local SSH tunnel it fa
Greetings!I wanted to start using FME 2019 today with a new workflow I'ven been tasked to create. It's pretty simple: read polygons from a DWG file and store them in a SHAPE file.The source file has many layers, so my idea was reading all the layters except one (it contains texts I don't want). I have checked the "Single Merged Feature Option" and in the "Feature types to read" parameter I have picked the ones I want:When I try to run this, I get the following error:ERROR |ACAD reader: The encoded string is not a valid fme-wwjd string: 'ELC.02 - AREA DE EXPANSI\xC3\x93N OESTE'It seems the Reader doesn't like the accents in the layer names.If I use "Single Feature Types" instead of merged ones, FME is capable of reading all the features.I still have FME 2018.1 installed, so I have tried the same steps in that version and it works fine with merged features.Could this be a bug of FME 2019 (19238) or is there something new about that reader that I am missing?
I need to use the ASCII 36 ($) character in the name of attributes on a geopackage file. In the direct way is it impossible, because the Use Attribute pane of the Feature Writer for geopackage changes the '$' char into a '_'; same story using an opportune schema in 'Dynamic Schema Definition'.Is this a FME bug? Is there a way to workaround this issue?
I specified a ADE schema file in CityGML writer and tried to export a attribute to a attribute of cityGML difined by ADE.Then the attribute generated as follows: <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_key"> <gen:value>1</gen:value></gen:stringAttribute> <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_key_codeSpace"> <gen:value>../abcde.xml</gen:value> </gen:stringAttribute> <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_string_value"> <gen:value>XXXXYYYYZZZZ</gen:value> </gen:stringAttribute> The results I'm expecting are as follows: <aaa:extendedAttribute> <aaa:KeyValuePair> <aaa:key codeSpace="../abcde.xml">1</aaa:key> <aaa:stringValue>XXXXYYYYZZZZ</aaa:stringValue> </aaa:KeyValuePair>
I can't connect to a specific ArcGIS Server feature service using a FeatureReader.I get the service layers listed as output ports but when I execute the translation it throws this error:ArcGIS Feature Service Reader: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Failed to execute query.'. Details: '' Using a Reader instead all service layers are read without problem. I don't understand why the Reader connection works different than the transformer. Any idea?Generally I would stick to the Reader connection and forget about this weird thing but I prefer using a FeatureReader here because I need to catch any error and work further with it in the translation.
Hello, I am trying to save multipolygon .shp file to .wkt file. See attachment. Is it possible to save the output of my workbench directly to the file with extension. wkt? I noticed that .wkt Reader exist, but I cannot find Writer. I know that I could save it to .txt, but it doesn't solve my problem because in the next step of the process I need to seed this file to external tool which reads only file with .wkt extension. I would like to avoid manual step of changing .txt file extension into .wkt as I would need to do it multiple times.
Hi, I have a ESRI-JSON file which geometry looks likes this: "geometry":{"hasM":true,"paths":[[[333334.24000000209,6611588.879999999,0], ...Note that the hasM property is true.I am trying to convert that file (among other operations) but when it is read by FME it seems that the third coordinate is parsed as a Z value and not as a measure: Where I should expect something like that (2D but with true measure): Question: how to deal with that data to output a true M-Value? I am thinking of two approches:Find a proper setting in the ESRI-JSON reader what would parse the M-value as a true measure and not a Z ; I did not find that kind of settings if it existsLet the reader as it but find a way to transfer/copy the Z value into a M value using transformers; I did not find the proper method yet Any thoughts about this? Thanks a lot!Jean
Hello all, I'm wondering if anyone has any suggestions for using FME to compress the delta tables of an ArcSDE enterprise geodatabase? I'm thinking it could be achieved using the python caller to run the ArcPy command for executing the compression. Does anyone have and suggestions or best practices in this area? Thanks!
Hi! Is there a way to change the "else if" condition statement to an "if" condition? I want to assign two values to the same element and with the "else if" I just assign the first value.
Hello FME Support,Is there any news on the 'Unsupported Font Issue' in the PDFWriter? https://knowledge.safe.com/questions/2007/unsupported-font-family-message.html We need to be able to read DWG drawings in a range of True Type Fonts but it keeps failing and reverting to Helvetica when writing to PDF.
Hi, My name is Jie, and I'd like to build a geological voxel model as the following picture copied from the question asked by @philip_wehrens . I want to know how to efficiently build a model like this? With this model, I want to export the model for Finite Element Analysis. To be specific, The finite element code is developed in Matlab. All the best,Jie
Hello,I have a table in Postgreql with geometry that I can perfectly load in QGIS but the FME reader doesn't show the geometry. The allowed geometries is postgres_none but they are polygons. What am I missing? TIAJonathan