Data

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 se

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

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. 

The problem: I am loading conductors from oracle spacial into a file geodatabase (ultimately the output will need to be SDE). The target datasets are all populated with existing data that I am trying to add to. The source conductors are currently split into a few target feature classes by fme; Primary overhead and primary underground for now. I will need to add the secondary overhead, secondary underground, and abandoned as well in the future. This part is working well for the primaries. But I am having a hard time dealing with the relationships. Each esri conductor feature class has a number of relationships.Relationships for primary overhead.In the end I will need to deal will most if not all of the relationships. But for now, I am I just working on the PiOH_ConductorInfo and its partner PiUG_ConductorInfo relationships. This is a one to many relationship a

Anybody have any success copying over a select group of folders using the Directory and File Pathnames to a filecopy transformer? I currently have it set up the same as described in https://knowledge.safe.com/questions/62005/copy-entire-folder-from-a-to-b-destination.html where it successfully copies ALL the folders. (path filter is currently set to *) But I would like to set a regex in the Path Filter to only grab the folders I want.example:I have 9 folders with sporadic numbering/naming and only want folders 01,02,03 & 09.01 – test02 – test03 – test group104 – test group205 – test11 - test12 - test17 - test09 - testI tried 01 - test\\n02 - test\\n . . . but I can't seem to skip to the 09 folder?Any thoughts  

Hi, I'm working with the transformer JsonTemplater to create a json file. The source is a list of attributes, for example:_list{0}.Date_list{1}.Date_list{0}.Age_list{1}.Age My Workspace translate with successful with just list of attribute:{           "Attributes" : [        for $value in fme:get-list-attribute(("_list{}.Date")            return {"Date" : $value}] }My question: How can I configure to receive more than list of attribute, in this case _list{}.Age ?  Thanks

I have an FME process connected to our GIS Portal to clip, reproject and label data for AutoCAD export. The user toggles on layers in the viewer and draws a polygon around area of interest and this is passed in my process to clip features, reproject and label if set to label in process and export a AutoCAD 3D Object Data drawing. I have been trying to resolve issue of blank object data tables for text layers and also creation of object data tables on objects not selected for export but are in my process for labeling and styling purposes.

SummaryThis post (actually it’s not a question) describes how to create SDO_GEOMETRIES when writing features with the Oracle Non-Spatial Writer, by post processing the Oracle table with SQL statements.All functionality is contained in a few simple steps inside a single workspace.This post provides both a procedure to renew an entire table each time the workspace is run, and a procedure to append features to an existing table each time the workspace is run.Finally, this post shows how to spatially enable the table by maintaining a record for the table in USER_SDO_GEOM_METADATA, and by optionally adding a spatial index to the table.I hope this is of use to someone.Preliminary RemarksIn this post the Oracle table is called TEST_GEOM, the GML field is called GML, and the SDO_GEOMETRY field is called GEOMETRY. These names can be changed as required. It is possible to put these names in Private Parameters, and use those parameters wherever a name ne