Data

I am struggling to get 113.gz os mastermap files to convert over to .shp. I am not that experienced with FME but am finding that the workbench keeps crashing when its reading the files.Does anyone have any tips? I have found previous docs regarding a translator called Fanout - but doesn't seem to exist in my software.I would be grateful for any tips as would like to start moving all of our processes over to FME.Thanks,Alice

Hello,I have a DWG file with two layers. In the first one I have lines representing a nework of pipes. In the second one I have autoCAD text describing the pipes diameters. I would like to create a shape file representing the pipes with their diameter as an attribute. I linked a DWG reader containing the first layer to a SHP writer to create the shape file representing the network of pipe. How can I extract the text (diameter information) from the second layer of my DWG file and how can I link the diameter to the right pipe in the SHP file ?Thank you for your help,

Using FME Professional Desktop 2012 SP3, Windows 7 Pro, 64-bit.  I have a workbench that I created to extract geometries in WKB format from SQL Server and write them into an AutoCAD Map DWG file.  I noticed the resulting DWG file has no coordinate system assigned, and the units are set to "unitless".  Although the objects are correctly positioned and the coordinates are correct, the coordinate system is not set.  Is there any way to write the AutoCAD Map DWG file with the coordinate system and the units set?  I have posted this question in the Google group FME Talk.  I am just trying to increase exposure to my question.  Thanks,

I'm trying to convert ZFS directory to LAS but it's not working. There's an error warning: 'Data type of the file not supported, please update library'. What went wrong?

We are attempting to convert Oracle Spatial databases to PostGIS, and find it is taking a very long time to convert large 4269 SRID lines and polygons at roughly 1-2 per second, with smaller ones at around 10-20 a second. I am also very puzzled while for very long periods it will seemlingly do nothing but burn CPU (no new rows). I've tried both 9.6/2.3 (Azure for PostgreSQL PaaS) and 10.3/2.4 (on-prem) with the same results.For instance, it took 2 hours 54 minutes to convert 2136 rows, or about 12.3 a second.Is the overhead for converting the SDO_GEOMETRY number based geometries to the geography binary type really that high? Any suggestions for getting better conversion speed? Currently using 2017.1 - will a newer version run significantly quicker?

Hi, I have an issue which could potentially be solved in different ways, and I want to put this out to see if people have better solutions. It is probably best explained with a simple example:A user requests output of a collection of data - X-points, X-polylines, X-polygonsSo we have a list of what they want. The data will be read from three Postgis tables and output dynamically using the Postgis schema to a FGDB. The user will then be sent the FGDB along with one layer file showing the three datasets.However the geographic area the user has requested data for contains no X-points data, so currently all that is exported is the X-polylines and X-polygons and the layer file contains a broken link for X-points. I am looking for the best way to write an empty X-points feature class to the FGDB so this link remains but isn't broken.My initial thought is too look at the list the user has requested, then compare it to what is read from Postgis. Then I'd have to create a dummy feature

I need to copy all of the features in a folder containing many zipped shapefiles to tables in a SQL Server.  The table names in the SQL Server need to reflect the shapefile names.  Currently I am using the Table Name Expression: NatTitl_@Value(fme_basename)When I run the workspace runner that I created, the same table name is applied to every shape file.  Hence, the fme_basename parameter is not updating when a subsequent shapefile is opened.

Hello,I am at very early stages of incorporating FME into my work, and I am trying to figure out how to unzip all zip files in a folder (and all zip files in subfolders).I was able to unzip files with the "directory and file path names" transformer (**/*.zip) by passing folder and file locations to ZipExtractor. However, That transformer asks me to provide a "source folder" before it can start running. Is there a way to define the source folder to the folder of my .fmw file?I plan to use this same file with different folders and I would like users to be able to copy the .fmw file into another folder and run it there without providing a source folder location everytime.Thanks!

The Transformer Emailer causes the following error message on our mail server:  2018-05-17T22:22:23.651384+02:00 warning: Illegal address syntax from xxx.xxx.de[xxx.xxx.xxx.xxx] in RCPT command: <> Unfortunately I do not have any further information about our mail server. I don't care about the error message, but the guys from the central IT pressure for this error message to disappear. Is it possible to make changes to the email settings and if so, where? With REST?

Hi,Has anyone had an error when writing to sql server from FME Cloud, when I run locally it runs fine. Transferring input attributes onto output feature, this may take several minutes...COM.safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed.COM.safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed.Destination Feature Type Routing Correlator(RoutingFactory): COM.safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed.COM.safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.s

I have file geodatabase which contains polygon featureclass and Table with unique ID and common field. While creating relationship class in fme the following error is coming... Error :-------------------------------------------------------------------------------------------------------------------------------- Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri toolsGeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures(SortFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsSome error has occurred closing the pipeline factory, see previous warningNone of the edits made during the edit session were savedSome error has occurred closing the pipeline factory, see previous warningSome error has occurred closing the pipeline factory, see previous warningAbnormal termi

Please help, at a complete loose end. I have a process that's copying data from one SDE database to another. So far it's working almost okay. My main problem is a featureclass which uses multipoint geometry, and I'm dynamically setting the geometry on the writer (intended as this process will be a child workspace run against different datasources). The only way I could initially get it to work was to tell it to set the geometry based on the first feature, but I have one dataset that has 4-5 multipoint features towards the end of the dataset, so the process bombs out trying to put an aggregate into a simple feature type.

Hi at all,at https://sentinel.esa.int/web/sentinel/missions/sentinel-2/data-products you may download Sentinel-2 tiling grid in kml format (Sentinel-2 tiling grid kml) (nearly 100 Mb). I tried to export it to SpatialLite and Shape polygons in order to work with inside a GIS more easily.But till now, I haven't success to export geometry Placemark (no polygon nor lines).By inspection them inside FME DATA Inspector, I see a complex structure --> IFMEAggregate made up by polygons and points. What I'm looking for!! But sure due to my illiteracy I can't find a manner to explode and extract and I just get or error on output or strange void features.Any hints?Best,fz

Good day, I have a position (coordinates) for each day of a month. I would like to display them on a map with a color ramp. e.g. Light yellow for the first day of the month and then getting darker with each day. The output should be a pdf. The pdf styler has no color ramp option and I couldn't get GradedColorizer working properly. Any other solution available?

I would like to create a folder for output that is named by either a UUID or Timestamp. Within that folder I want to output multiple feature classes within one geodatabase, plus add other items such as layer files loose into that folder.So for example it might look this this:UUIDFolder/ (containing loose lyr files etc.)PLUSUUIDFolder/export.gdb (containing multiple features classes)The problems I'm facing are as follows:- I can create a parameter for UUID/Timestamp, using @UUID() for example, then link my writer to that parameter, but whenever it tries to write out it creates a brand new stamp.- I can create an attribute from the parameter and use a fanout expression with the attribute value but this always fails to write. And it seems impossible to populate a new parameter from the attribute.I'm trying to do this all in one workbench rather that export attributes as parameters using JSON to a second workbench.It is failing in both Desktop and Server.Any ideas?

As you can see, these models seem to show different heights according to latitude. It's weird. Is this because some of the parameters I converted to 3d tiles are incorrect? Can someone help? Thank you

In much the same was as you can order the sequence of layers in a PDF, I'd like to do the same in a KML file. I'm not talking about the draw order though, I mean the appearance and sequence of layers. By default it appears to be alphabetic in order. So you'd get:RailRiversRoads...by default if you wrote them out to KML.But what if I wanted:RiversRoadsRailI don't want to put the layers into a KML folder and I don't want to change the featuretype name in any way. I thought it first setting kml_draw_order might be an option but that appears to relate to the render order on the map rather than the layer order in the 'Places' list.Is it possible? Thanks in advance.

HiI'm wondering if anyone has encountered this - I'm looking to read some data held in views in an Oracle workspace. The views are generated by Oracle Workspace Manager (viewname_CONF for conflicts seems the naming convention). I can read user-generated views using the Oracle Spatial Reader, but I cannot seem to read the workspacemanager-generated views using the Reader. I can access the data in the workspacemanager-generated views using SQLCreator transformer, but then I have the overhead of exposing all the attributes (which I can probably automate).So FME can access the data as the user I'm connecting as, but seems to ignore these views. Has anyone else encountered this? Is there a way to access them via Reader? some setting I'm missing??ThanksMary

I'm creating a SQLite Tilecache via the WebMapTiler, with PNG blobs, and would like to use PNG Optimization. This seems to be available in the PNGRaster writer, but I'm not using the PNGraster writer, I'm using the SQLite writer. So, is there any way I can pull that piece of code or is there another transformer I could use to do the same job of PNG Optimization?

Hello,is there a way to access a value of GML xlink:role property? I can access other xlink properties such as href and title but not this one.Thanks for suggestions.

When using the geodatabase SDE reader (ESRI) or shapefile reader, the geometry of the polygon feature class does not appear correctly. Recent edits to the SDE data (v10.3.1) are not reflected. In ArcCatalog and ArcGIS on the same machine the data appears correctly however the data is not displayed the same in FME Desktop or Data Inspector. (Note: SDE geodatabase is compressed nightly). I am running FME v2017.1.

Is it possible to write annotation features to an ArcGIS SDE annotation feature class without a spatial index being created in FME?I am writing annotation features to ArcGIS SDE on SQL Server using the GEODATABASE_SDE writer. I delete the spatial index on the target annotation feature class before running FME. I do not want a spatial index created on the feature class, but FME appears to always be creating one. Referencing this article I have tried the below FME and SDE settings, but the result is always the same.Environment:FME 2018.0.1.0 (20180518 - Build 18310 - WIN32)ArcGIS Desktop 10.2.1ArcSDE 10.2.1SQL Server 2014Feature Type Grid 1 ValueSDE LOAD_ONLY ModeSpatial Index Createdunset/blankYesYes0YesYes-1YesYesunset/blankNoYes0NoYes-1NoYes

I currently struggling to get the wanted attribute output in my Writer(FGDB). This is a brief of the current work-space. Reader (Excel Spreadsheet with file-paths) into a Feature Reader (using User Parameters created from the Excel) -Then into A Feature Writer (FGDB using user parameters from the Excel). This currently runs and works however the features created only contains the data/attributes from excel file, I want only the attributes from the feature-class. When Inspecting the Feature reader there is the attributes from the loaded features but I cant interact with them using any known transformers atm.Any suggestions?

BADNEWS: TEST clause must be specified for factory TestFactory (fcttest.cpp:298)

Hi, i'm new to FME.When I add a reader (Oracle Spatial Object), fill in the right parameters and click OK the translation log says: Error running translation (immediately). I do this in Citrix. When I do this in FME on a Windows 2012 Server de translation works fine. What could be the problem?Thanx, Erwin