Using readers and writers to extract and load data.
Recently active
I saw on this page ( https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgisonlinefeatures/ft-parameters-w.htm ):The ArcGIS Online Feature Service writer performs a truncation by reading all feature IDs from the layer, and then making deletion requests in batches according to the Features Per Request advanced parameter.I was wondering if there were plans to incorporate the ArcGIS REST API Truncate operation?https://developers.arcgis.com/rest/services-reference/truncate-feature-layer-.htm
Hello FME Community, i am currently trying to combine stock and flow simulations with CityGML. As a tool in between i try to utilize FME.My question:How can I edit the height of a citygml building (LoD2)? I am trying to increase the number of floors and try to show a before and after version.Can i just change the z-axis of the building?Best regardsTobias
I'm an infrequent user of FME so apologies if this is a simple solution. I have an IFC file that was created by exporting from Aecosim and I'm trying to expose the custom attributes (See image below) that I can see when opening the ifc in Solibri. I've searched this community and found nothing that can help me so far. If anyone has a solution or a way forward, your help would be much appreciatedI should add, my goal is to get this information out into an Excel document.Thanks for your help
I get the error above and the following warnings<SOURCE_GML Reader> - Unable to determine features from the parsed XML Schema files, the following namespace URIs were processed<SOURCE_GML Reader> - XML Namespace URI: http://www.w3.org/1999/xlink<SOURCE_GML Reader> - XML Namespace URI: http://www.w3.org/2001/XMLSchema<SOURCE_GML Reader> - XML Namespace URI: http://www.w3.org/2001/XMLSchema-instanceThe same file is read by QGIS without any problems.Any Ideas how I can find out the reasons?
I am looking to take a point feature class that acquires a GPS location from our Utility trucks every 15 seconds and create routes driven based upon historical data. End goal is I would like to build a polyline feature class to reduce the amount of data that I am publishing to our Portal to improve the performance of querying data, as we are acquiring approximately 2.5-3 million points within a 30 day span.Below is an example of the data being received.Here is what the data means:Vehicle is Offline = IsIdle - 0 & GpsActive - 0Vehicle is active but in a Idle State = IsIdle - 1 & GpsActive - 1Vehicle is Actively Moving = IsIdle - 0 & GpsActive - 1The part I am getting stumped on is how I can define routes driven. In the example above, there would have been 2 routes driven. The first route would be fromto and the second route being toBelow is an example of where I would like to take the data, with the addition of some sort of RouteID field. Any help is greatly appreciated.
I have to generate approximatively 850 Excel workbook and I was wondering if it was possible using only one Writer or if I had to use 850 Writers.I thought of the possibility of generating 850 sheets in one Excel workbook, but I would have trouble actually opening the workbook with my computer (lot of memory used).Also I work with a 2017 version of FME (I stumbled in the past on issue that could be esaily resolved with 2018, but I had to work in the limit of 2017).Thanks
I have a dgn that have attributes for some elements:these attributes i'm guessing that are from exporting a shp file to dgn directly from microstation.How can i read these attributes and if possible create new one or change the value of existing ones.Is it even possible?Inspector does not show these attributes anywhere.Readers also does not show them anywhere
Hi So I have a text document and I need to parse into specific headings and then extract that heading and all the sub text. The issue is the subtext is lettered. Is there a regex syntax that will continue to extraxt until it finds a new match? any ideas? Im using string searcher and have managed to get all this data as seperate lines, just not sure if its easier to try and find a way to put the data back together or if theres a more efficient way to parse Current using syntax: chicken{1}\\s|(. Example: I need every line that starts with "chicken" the chickens name and all the numbered lines below TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXTTEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXTChicken: Rene(1) lays three eggs a day(2) escaped two weeks agoTEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXTChicken: Stacey(1) etcand so on
I'm trying to send a message to the websocket server on my FME Cloud instance. I can successfully transmit the following: {"ws_op" : "send","ws_msg" : "hello"} But I want to send a JSON message as "ws_msg", so I tried: {"ws_op" : "send","ws_msg" : fme_get_attribute("payload")} Which isn't received on the other end, similarly to if we have an incorrect message, i.e. without the "send message"-format from the documentation of the WebSocketSender. I would guess it's something with the quotes around the message, but I am unable to escape quotes in the message formatting window. So, how can I send a JSON message (Payload-attribute attached) to a websocket using FME? { "type": "Feature", "properties": { "icon-image": "pulsing-dot-blue"}, "geometry": { "type": "Point", "coordinates": [ 17.3016102, 59.6615453 ] } }
Hi,I am in the process of creating a workbench to transform geotagged jpegs into KMLs. Ideally I want my photos to popup in google earth balloons at the location they were taken at. In order to do this I first need to extract the exif geographical information i.e.latitude, longitude, altitude, bearing etc. I would've thought that KML viewsetter would be the right tool for this however when I fill in the location fields with the appropriate exif information the KML still defaults to latitude 0, longitude 0. I'm quite sure I've got the right parameters "jpeg_exif_gpslongitude", "jpeg_exif_gpslatitude" etc. but it's not working for me.Any ideas from the community?Thanks,Mike
Is it possible with FME Desktop?LAS (LiDAR) to OBJ (Wavefront) to FLT (OpenFlight) with textures???Thanks
Greetings, I´m getting a strange error when trying to generate a PDF in 2019.2.0.0 version (Build 19752 - WIN64 or Build 734 - win32). The same flow works perfectly in version 2018.1.2.0 Build 18590 - WIN32, and we are planning to migrate to the new version soon but in our tests we enconter this error. For some unknow reason, in this example,some polygon near the "LTP" and "FTP" entrances in the 2nd table are dissapearing. In my original flow (not this sample), this behavior occurs in the polygons in the middle of table, so I don´t think it´s a problem related of the fact of be one of the last rows. I generated a small flow with the same problem to reproduce the situation for your avaliation. Thanks a lot for the help.
Hello there!If I want to use the newest FME Desktop functions (v2019) with an old FME Server (let's say v2017), do you think it would be possible to publish on my server a worskspace created on FME Desktop 2017 who will call (with a SystemCaller or whatever) a batch file that will run FME Desktop 2019?Batch file line command example"C:\apps\FME2019.1\fme.exe" "\\NASASERVER\c$\FME\Workbench\Talk2Aliens\SolutionHere.fmw"First of all, is that legal? Does Safe permit that?Secondly, would that work?Thanks!
Hi, Could anybody tell me if this possible with FME please? I'm new to using ESRI Portal Items and FME .I have a Feature service on Portal published via arcgis server from an enterprise geodatabase in Oracle, I wish to create views of this data in Portal by Fanout on an attribute value. e.g a Feature service of Polygons with and attribute of Sheet_no, I'd like to create a Portal item for a definition query on the master layer for each group of unique Sheet_no values, giving these items a new name based on the original item name + the Sheet_no... The data cannot be duplicated and the view must reference the original service and data source.This apparently can be done using the Portal Python API .... but I'd like to see if it can be done in FME. Any pointers are appreciated RegardsPaulg
We have an Oracle (Locator) Database, where we have stored geometric objects that were generated through Microstation. The database also contains attributes pertaining to the symbology of the objects. These attributes are:- a style column which contains a number- an angle column, which is set to 0 for non- point geometries- X-scale column, which is set to 0 for non point-geometries-Y- scale column, which is set to 0 for non point-geometries-a cellname column, which is null for non point geomtries, but contains the name of the DGN cell/symbology used for point geometriesPosting these attributes to another database (PostGIS for example) is not a problem. However, when reading this database in another (GIS) application, how do I get to see the same symbology?Is it something I need to set in the FME workspace, by setting somewhere that these attributes need to be interpreted as special symbology attributes? Or is it something I need to set within the GIS application itself?How do I even go
Does FME Server support Microsoft Exchange Server for notification emails?
I noticed in the applications and formats supported page that AutoCAD Object Data tables (AutoCAD Map 3D) are not able to read in when using FME Cloud - in my workbench on my desktop this reader works great in getting the additional information stored there so seeing if there is an alternative or workaround in being able to get that data while using FME Cloud
Hi, I have .rvt file which is created with DUB DLTM projection system, I do not see the feature on the correct location in FME inspector, or in ArcMap after transforming the file into multipatch file geodatabase.I can see the feature on correct location when adds the file directly into ArcGIS Pro but facing issue with FME.I am using FME 2019.1, which allows direct reading of .rvt file, no need to convert .rvz or ifcLooking for a solution.
An operator is thinking of migrating to Oracle on premise ExaCC with Oracle 12c. I have not worked with an on premise version yet and wanted to know if anyone has seen issues. The operator is a heavy user of FME Server and Desktop.
HelloWhile making INSPIRE gml I get different outcomes from INSPIRE gml writer and an INSPIRE gml feature writer. Is it true or am I doing something wrong with the feature writer settings? I would like to create an INSPIRE gml and then write it to postgres. That is why I wanted to use a feature writer for creating an INSPIRE gml and then connect it to a postgres writer, but it seems INSPIRE gml feature writer does not give a proper outcome. My other solution was to create another workspace and try to use workspace runner and then write the result to postgres, I still have not managed to succeed in this. Below you can see feature writer and writer, both specified by Theme (Energyresourcevector v4.0). You can see the outcomes are different. Why is that?
My FME workspace runs a SQLExecutor which creates an user with provided username and password as attribute:CREATE USER "@Value(username)" WITH PASSWORD '@Value(password)';GRANT @Value(roles) to "@Value(username)";On containing a '#' in the password value, I'm not able to connect to a database through that created user in QGIS. Unfortunately I can't expose the password handed over in pgAdmin to check the password set by FME. After changing the password in pgAdmin to another password containing the '#' as well, the connection works. Therefore I suppose the error to be within the SQL Executor. Does FME encode that character in some way, so that the '#' is stored as other character(s)?
Hi,We are migrating our FME Server to Azure in Q1 or Q2 2020 as part of a organisation wide migration. Is the current recommendation still: 'You can deploy FME Server on Azure by performing a regular install using our available installers (https://www.safe.com/downloads/) on any Azure Virtual Machine that runs a supported operating system and meets the minimum system requirements' https://knowledge.safe.com/questions/77140/deploy-fme-server-to-azure.html @stewart.harper I see that there is a Kubernetes deployment available. Is it still in tech preview? What are the plans for 2020? Is there any change on the upgrade path? 'With regards to the FME Server Kubernetes deployment, for the tech preview, the upgrade path is not yet tested.' We currently run FME Server 2019.0 on a single server installed using the express install and IIS Application Request Routing configured (acceptance/production servers). In terms of the azure server what type of storage is recommended
How do setup DB connection to postgreSQL using private key. I have server IP, user name and RSA key.
Hello all, how do I customize a the balloonstyle so the text displays in this format shown? I want to do this a with the correct kml attributes. What attributes do I need to set? Oh and I also want thedriving directions dialog. Thanks
I am working on a process that archives data from a group of hosted feature layers in ArcGIS Online to a matching group of feature classes and tables in SDE and then deletes the archived data from the hosted feature layers. So far, so good except for one related table (an error log) whose relationship class has the same name. The FME writer fails because, apparently, it's trying to write to the relationship class instead of the table. Renaming the relationship class is a no go because I'm told other things will break if I do. How can I get FME to ignore the relationship class and go straight to the table?