Data

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?

Hi allI have a gml file to need to export any vector format.I used many transformer but not achieved. You can find int the attached gml sample file.Do you have any idea?Thankyou

Hi,I created a workbench to convert an excel files records to point feature class and I need to create a polygon surrounding the point depend on a field in the attribute table, So I used the Hill Accumulator to do this but each time I choose a field in a the group by option I got an error as you can see below.Please note that when I cleared the group by option the workbench is working fine and I got one polygon, so what did I miss in my workbench. Any Ideas to solve this?Cheers,Rawan

Hi, does anyone know a way to limit attributes returned from WFS. I just want to return back the unique id so I can cross check against a clone out the data.This structure works in postman but I dont see a way for it to work in the fme reader. Does something need to be added to the xml filter? http://example.com/geoserver/wfs?  service=wfs&  version=2.0.0&  request=GetFeature&  typeNames=namespace:featuretype&  featureID=feature&  propertyName=attribute1,attribute2 Many Thanks Oliver

Hi all, I am currently attempting to load in 1000 data sets I have in 1000 different tables. I need to do this in Microsoft SQL Server.My data sources are either in Excel or Geodatabases. The plan is to download all the data sources and put them into one location. Once I have done this, I would directly like to set up some workbenches to load the data directly.My question is what would be the most efficient way to create the SQL server tables with the Geometry using FME. Then in the future, these tables will need to be continuously updated with the data. As there are so many columns with each data set, is there a quick and easy way to create the 1000 tables without much manual input.At the moment, I have tried creating the tables individually by writing up SQL Script but is taking a lot of time to create. Any past examples I can base this on or transformers that can speed this would be great.  Thank You

I am trying to write out some text to a pdf and I keep recieving the error "Unsupported font family 'Arial'. Reverting to 'Helvetica'.   I receive the error regardless of which font I try to use.  The Pdfstyler shows all of the fonts installed on my C:\\windows\\fonts folder, but just can't seem to access them when the workbench is running.   Also, I don't even have Helvetica installed on my machine.  I am using windows 7 and FME 2012.  Is there a setting I need to change?

I'm trying to get ground, and vegetation from a set of laz files, but there is no output from the PointCloudLASClassifier transformer. Is there something I'm missing that should go between the reader and classifier?I'm running FME 2019.1.1.0. There aren't any parameters for the transformer, so I'm not sure what other info I can include.