Data

I have an Excel Writer writing outputs of a workspace into a spreadsheet, I have also provided this writer with the location of an Excel Template which also happens to be an xlsx file as the extension of the writer and template need to be the same. In my template file I have a picklist in one of the columns which contain different values, this was enabled in the Data Validation menu of Excel. The picklist works as expected in the Template, after saving and running the workspace the output has all the correct values in the spreadsheet, however the column which should have picklists doesn't contain these and only has the column name. How can I enable this to carry through from the template to the actual writer?

Hello,My fmw used a shp file reader. If this file is empty, ican't get error. Have you any idea to intercept that the file is empty? Thanks an advance.

I have FME reading attachments from AGOL and writing them to a FGDB or SDE GDB. The problem that I'm having now is that FME isn't writing the blobs to the file geodatabase in a way that esri can handle them.The first screenshot is a directly downloaded database from AGOL. The second screenshot is from the database that I reloaded data with FME. The first screenshot allows you to view attachments, while the second screenshot doesn't allow me to view attachments.Thoughts @Mark2AtSafe?

Here's the output:  Terminator(TestFactory): Terminator: Termination Message: 'PARCEL_LIMIT_EXCEEDED'Terminator: Termination Message: 'PARCEL_LIMIT_EXCEEDED'Bridge failed to output feature on tag `PYOUTPUT'f_218(PythonFactory): PythonFactory failed to process feature=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `FFS' writer using keyword `W_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==============================================================================Total Features Written 0=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Successfully closed POSTGRES database reader... Last line repeated 5 times ...Closing the Geodatabase reader... Last line r

I'm trying to convert my GDB model, which is modeled in City Engine, to Cesium 3d tiles. Both reader and writer are implied with default settings. The transformation process goes smooth, I found that the output models are grouped in different data set. So every time I click on one model in Cesium, a group of models are triggered and all the model share the same attributes.What I am looking for is to keep the original amount of models after transformation, so they are independent and hold their own attributes. What settings are needed to make it work for me?

Hi,Can somebody who speaks French reach out to @ferjanibarour (email: ferjanibarour@gmail.com), he's been asking questions here and has also contacted me directly. @david_r maybe? Or somebody French-speaking from Safe.The problem is that his questions are very generic and I fear there's a big language barrier. I recommended him to contact Veremes but apparently he hasn't had a response yet.

Dear FME Community   Could you please advice me on this error..FYI, i'm already develop the workbench for coordinate transformation and its running successful on the desktop version. once i'm upload into FME server, the error message as follow  "EsriReprojector: Reproject: Could not reproject the geometry of the preceeding feature: Reprojector: Invalid reprojection parameters"  2014-10-07 15:50:27|   1.9|  0.0|INFORM|The OGC definition of the FME coordinate system '_NonEarth_Meter_1' is 'PROJCS["Kertau_RSO_Malaya_Meters",GEOGCS["GCS_Kertau",DATUM["D_Kertau",SPHEROID["Everest_1830_Modified",6377304.063,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Rectified_Skew_Orthomorphic_Natural_Origin"],PARAMETER["False_Easting",804671.2996],PARAMETER["False_Northing",0.0],PARAMETER["Scale_Factor",0.99984],PARAMETER["Azimuth"

This should be simple but I am having a brain misfire. I want to read in a large ECW file and create a shape file which follows the raster data snuggly (not including the white, nodata areas). Obviously I need it to run as quickly as it can.

I drape various geometries on a DEM I create from SRTM data and want to write this to a DXF file.This works fine for all kinds of geometries except for filled polygons of type autocad_hatch.Documentations says:... their geometry must be 2D or planar 3D with a constant Z, which can be stored as an elevation value.The phrasing "which can be stored as an elevation value" is not really clear to me as it is not defined how to do that.  I have tried several things to force these features to 3D with constant Z valueBoundsExtractor+3DForcer to _minzBoundsExtractor+2DForcer+3DForcer to _minzBoundsExtractor+2DForcer+setting attributes elevation, autocad_elevation, autocad_hatch_elevation to _minz... but always get the error message about inconsistent Z values and Z being dropped. Nothing seems to allow me to move these hatches to their desired height.What am I missing here ?

We are a gas and electric utility in the Netherlands.Smallworld 4.3 is our registration system and we currently use Smallworld Sync Manager to load changes to an Oracle Spatial database nightly.Next week we are reviewing Sync Manager and also looking at alternatives.My question is are there organisations that use FME instead of the Sync Manager to populate Oracle Spatial nightly from Smallworld? What are the pros and cons?We do have the FME Smallworld license and I've made a connection to Smallworld via FME Desktop last year before we upgraded. I found the reading the Smallworld features very slow. We don't have SpatialBiz plugin.Would @MarkAtSafe or @erik_jan have any thoughts?Thanks,Annette

I am trying to convert a GeoTIFF to an Esri polygon shapefile or feature class, not a raster. The GeoTIFF is in WGS1984 which is fine, and contains grids that have stretched value and pixel value fields. I used a GeoTIFF reader and tried both Esri Shapefile and File geodatabase writers as output but I'm getting just one feature. I don't mind if every grid is a polygon since it's a small enough TIFF file that I can classify them after the shapefile/feature class is created but if I can do a simple transofmation to pre-identify classes to create fewer polygons that's fine, too. I didn't see this capability in current ArcGIS as a direct approach, so I wonder if FME has a better way. Thanks for any assistance you can provide!

Hi  I'm trying to read an INSPIRE compliant GML file sourced from the OS Open Names dataset. I've tried both the GML SF-0 and INSPIRE GML readers and various parameter settings, but cannot get the xlink:title attribute of certain elements in the gml to show as an attribute in FME.   An example of a feature from the gml is below. An example of the attribute I want to read is the value "New Forest" from the xlink:title attribute of the names:inDistrict element.     <gml:featureMember>     <names:NamedPlace gml:id="SP62DS">       <gml:identifier codeSpace="http://data.ordnancesurvey.co.uk/id/postcodeunit/SP62DS</gml:identifier>" target="_blank">http://inspire.jrc.ec.europa.eu/ids">http://data.ordnancesurvey.co.uk/id/postcodeunit/SP62DS</gml:identifier>       <gn:beginLifespanVersion>2015-03-09T09:02:10.000</gn:beginLifespanVersion>       <gn:geometry>         <gml:Point srsName="urn:ogc:def:crs:EPSG::27700" gml:id="LOCAL_ID_1">     

I have a large amount of stereo image pairs for the Appalachian Trail and was wondering if anyone has ever used FME Desktop to process stereo image pairs into a DEM product. If so I'd greatly appreicate any help you can provide on this topic.

For some reason I can't add more photos (logos) on my pdf. My current PDF looks like this:My PDFPageFormatter settings looks like this.I have moved that two logo objects around and they never appear on the pdf at all. The location map object, which is created by the workspace using raster and vector data can be moved around anywhere and I don't have to do anything extra to locate the jpeg on the PDF page. I added a rastergeoreferencer after my reader using page units, following a related question but that did not work either. How can I fix this without using Avenza's Mapublisher transformer.

CityGML to MapInfo (TAB) coordinates with 3 decimals (mm's) are rounded to 1 decimal (dm's). When same CityGML file is converted to SHP coordinates are not rounded.  E.g. 55499.763, 388968.263 becomes 55499.8, 388968.3

When I specify message:AIXMBasicMessage in the Feature Collection parameter in the AIXM5 writer, none of my features get written. All the features in the xml now appear as:<!-- orphaned feature - parent id:'uniqueid', id:'INS5', type:'InformationService' -->Using FME 2016.1.3.1 WIN32

I try to write json to an elasticsearch index with elasticsearch writer but get the following errors: ELASTICSEARCH writer: {"error": "Content-Type header [application / x-javascript; charset = UTF-8] is not supported", "status": 406}I use Document source: json attribute Raw json attribute: _response_body where _response_body contains: { "Id":"13d5ccdf-76a8-45c7-83b6-24753699f5b0", "Beteckning":"A014821" }

Hello allWe need to transfer Rooms feature from Revit to GDB we need to show the client Room as a feature in GDB in 3d view

I'm trying to use the DatabaseJoiner transformer to link to an Oracle Spatial view (not table), but the SDO column is not appearing, nor is the geometry showing up in the resulting joined features. Can this transformer be used for this purpose?

Hi ! When I run my workspace, It stops because of duplicate data (but there aren't) I think It memorises something in a channel or something but I don't know where I can clean it .... Error : WARN |Oracle Writer: Abnormal channel cleanup required, likely due to previous error 

I'm making workflow that creates a layout for drawings and exports them to pdf. The lining, north arrow and all work but somehow the layers of the PNG's are not correctly exported to the PDF. When looking at the drawing in the inspector everything is transparent and also the shape of the image looks OK but somehow in the export to PDF the transparency is lost and the image gets a bit squeezed together.I cant find the option to tackle this, for example the pdf styler made everything transparent or nothing but not only the transparent parts.

I have a png (map symbol) that I'm trying to rotate for each degree (so I end up with 360 for each symbol), but when I use the Rotator, it just makes the image size bigger at certain angles. Is there a way to ensure that all the angles get resized back to 60x60 so they all appear the same size on the map? (0* is 60x60) (60* is 82x82)

I have a total of 4 million records from various featureclasses stored in SQL spatial database and I have one workspace reading from SQL and writing out to an Esri FileGeodatabase (using API, not ArcObject writer). When I run this workspace in Desktop, it took approximately 16 hours to finish. However, it took 3 days to finish in FME Server. I checked the timestamps of the log in FME server, writing out was gradually getting slower and slower. I was just wondering why there is a significant difference between Desktop and Server with the same workspace?