FME Form

Using the AttributeConcatinator transformer, how do I represent a blank space in the Separator String: data entry?

We need this to be able to post the attribute to an API which requires one of the other File Structure types than the default

I run this command from the command line: C:\\Progra~1\\FME\\fme.exe C:\\BIDW_Prod\\FMETemplates\\FINANCE_finance_EDW_CALL.fmw and get this error: Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLCreator_<Rejected> INPUT FEATURE_TYPE SQLCreator_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLCreator<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>translation<space>when<space>features<space>are<space>rejected<comma><space>change<space><apos>Workspace<space>Parameters<apos><space><gt><space>Translation<space><gt><space><apos>Rejected<space>Feature<space>Handling<apos><space>to<space><apos>Continue<space>Translati

I have a stream of features containing polygons and multipolygons.I would like to identify only the polygons and promote them to multipolygons (containing one polygon). I tried GeometryAggregator but it is converting multipolygons into geometryCollection(multipolygon) which I don't want.Must be something simple that I just can't see. Any help appreciated.Simon

Hi, I made a workspace to create INSPIRE datasets. When checking whether the created INSPIRE GML is valid, I wanted to add an XML Schema Validation step into the process. When doing so however, I noticed that in FME's XMLValidator I get two Validation Errors;no declaration found for element 'so:soilProfileObservation'element 'so:soilProfileObservation' is not allowed for content model '(metaDataProperty*,description?,descriptionReference?,identifier?,name*,boundedBy?,location?,inspireId?,localIdentifier?,WRBSoilName,otherSoilName*,validFrom,validTo?,beginLifespanVersion,endLifespanVersion?,isDescribedBy+,location)' See also below screenshot;If I however validate the GML using either (the XMLTools plugin) of Notepad++, or INSPIRE's validat

Hello, I have a digital model in ifc format that I want to convert to CityGML format in FME and then integrate it into a Postgis database. I want the model to keep its characteristics at the end of the process.

Its possible to write the TAGs but in MicroStation the tags do not work.I use FME 2016Thx for help.

Customer has a working migration chain on FME 2021.2.5 and we would like to upgrade to 2022.2. At first, I started extracting data using FeatureReader from our source (Oracle Spatial), but I have strange warning message in the log and not all data all extracted from the source.  Warning message in the log relates to entries in ALL_SDO_GEOM_METADATA which are all set correctly – I would mention once more that data reading from Oracle using same workbench in 2021.2.5. is working. Here is the warning message: Execution of statement `SELECT table_name, column_name, (SELECT COUNT(*) from TABLE(META.diminfo)) dcount, SRID FROM ALL_SDO_GEOM_METADATA META WHERE ALL_SDO_GEOM_METADATA.owner = '<SOURCE_SCHEMA>''did not succeed; error was `ORA-00904: "ALL_SDO_GEOM_METADATA"."<OWNER>": invalid identifier'. (serverType=`ORACLE8i', serverName=`SERVER_NAME',

Hi all.I'm using a dynamic writer to output a series of features as tables in an SQL Server database, adding a fixed schema name in the "Table Qualifier" parameter.However, FME completely ignores this setting, and outputs all features to the default "dbo" schema.I've then tried to add it to the "Table Name" parameter (with "fme_feature_type_name" in "Schema Definition Name"), but then it just errs because the data features "fme_feature_type" now contains my added schema.Is this really WAD ?Why doesn't the dynamic writer accept and use the setting in "Table Qualifier" ?? 

For example:In the parameters dialog of the writer-plugin a file was chosen from the hard disc and the filename is availiable in the parameters list.Now if we add the FeatureTypeImporter in the FME via Writers - Import Feature Types ... and select in the Format: field the FeatureTypeImporter we want to have this file displayed in the Dataset: field.The Dataset field is defined in the fmf file of the FeatureTypeImporter and a default value is set there.There also exists a parameter in the writer fmf file for this file.

Hello, I have an FME Server Workspace that uses a Python Caller to write custom EXIF tags to a JPG.  I want these images to be provided directly to the user via data streaming. The only way I have found to accomplish this so far is to pass the image path to a filecopy writer. This works OK - It will display the image, and if saved - it will retain the custom EXIF tags - however, when saving the image - it wants to save it as the .fmw workbench name (and .fmw as the filetype).  Does anyone have any suggestions to get around this? It seems that the mime-type isn't coming across using the data streaming.  FYI - I have tried a JPG writer at the end (feature reader - feature writer), but this cuts out the custom EXIF tags.

Hi, I have a need to convert ellipsoid heights to a height datum (Australian Geoid 2020). I currently have the geoid in a dat/gem/gdf/gsb. Is there a way I can open and of these in FME to make one of the grids that FME accepts? I wish to use the CSMapReprojector I have tried to rename the dat file from Geoscience Australia as a txt but that does not work This is the list FME accepts, via a gdc filehttps://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/CoordSys/vertical_grids.htm Does anyone have any ideas? I can seem to find anywhere to convert any of these formats

I've found not documentation around any name formatting limitations for Attributes for the Hyper file Writer. When I work in Tableau Prep, I have no issues writing a file with a field name like "Budget$" to a hyper file. I've found in FME that when writing to an Excel file, it also takes such a name, but when using the Hyper writer, it drops the "$" and replaces it with underscore "_". Why is it doing this? Is this a mistake in creating the code for the Writer or is it a Necessity and if it is a necessity, shouldn't this be documented?

IfcPresentationLayerAssignment is the entity where autocad layer information is stored in my ifc model. I can see that it is included in the ifc-file by reading it as plain text. However I can't seem to expose that entity in FME. I have tried different combinations of AttributeExposer, GeometryPropertyExtractor and listexploder. Is there anyway to expose that attribute and its values in FME?

Hello, I’ve used FME Desktop in the past to convert a planning applications shp (points) file to a csv file for use in PowerBI. To get data working in PowerBI certain set fields need to exist (in the output csv) that are not in the planning apps shp file: Name, Icon and Color (sic). This is where Name is typically the main reference value in the dataset (e.g.: the site name or an planning ID), Icon is the name of the icon type to be used in PowerBI (e.g.: hexagon-thick) and Color is the colour PowerBI uses for the icon (e.g.: #8B0000). So, when creating this output csv for use in PowerBI I read in the shp, connected to a AttributeReprojector to convert to LL-WGS84 (because the source shp was in EPSG:27700 and PowerBI requires LL-WGS84). I then connected to an AttributeManager where I 1) renamed the Planning application number field to 'Name', 2) added a new field called 'Icon' (with the value of ‘hexagon-thick’ for all record

Is it possible to read all layer names from a DWG source file? By all I also mean the layers which do not have any features on them. For example, if I have a DWG file with the following layers and numbers of features on them:L_01 (with 10 features)L_02 (without any feature)L_03 (with 1 feature)L_04 (without any feature)I want to somehow get access to all the layer names, i.e. L_01, L_02, L_03, and L_04 in FME, even though L_02 and L_04 do not have any features. Alternatively, is there a way to convert a DWG file to a DXF file such that all layers are preserved (i.e. , again, also those that do not have any features on them)?

How can I pass a published parameter in a workspace into a custom transformer within the same workspace? I think you can pass a publishedParameter into an attribute and then make this attribute available in the custom transformer, just wondered if there was a simple cleaner way?

Hi all, I'm manually fixing broken photogrammetric models of buildings (common errors like holes in overlit white walls etc.) and then I want to convert these fixed OBJ models to SLPK. I use this workflow: OBJ Reader – merge mesh parts: yes, move to coordinate system: yes, coordinate system: EPSG:5514 (Czech/JTSK.Krovak),Offsetter (to move it to correct geolocation) – X Offset: -747078.00223783311, Y Offset: -1054893.7301940639, Z Offset: 289.74612628016621,Esri Indexed 3D Scene Layer Writer – coordinate system: EPSG:5514 (Czech/JTSK.Krovak), geometry: i3s_terrain_mesh....but no file is created. I guess the problem is probably that the models are really big (over 0.5 GB)?  Thanks for your help,Michal

When overlaying polygons I can get points, lines and polygons in a single result GeometryCollection. I'm sure this is a simple question (and have searched the knowledge base etc), but how do I use FME Workbench to detect such GeometryCollections and then extract just the polygons from the GeometryCollections?

I have a template dwg with a property set attached to lines and polylines. When I write a dwg and use that template is it then possible to fille the property set from FME?

I would like to import Autocad(.Dwg) file data into an Azure SQL table.In this table, I have the field GDB_GEOMATTR_DATA wich is populate by ESRI (Arcgis Pro) to store complex geometries. How can I populate such GDB_GEOMATTR_DATA field with FME? I tried to use the geometryExtractor transformer but it's not working.   @Takashi Iijima​, @jdh​, @Hans van der Maarel​ and others, any thoughts? Thanks, 

Hello , i am using GDB writer to write my output as GDB .but I have found most of times ,it create a folder that contain different files but when I view the output of writer again in FME ,I got no data to read .but for the same canvas ,when I use writer Esri shape File ,it save well and when I view the shape file output again in FME ,I found the data .it works great with shape file but GDB not at all . what is the solution to save my output as GDB ? Do there some restrictions should I look before writing my data into GDB?  FME Desktop professional 2021 

hello all,I am trying to get FME workbench to output into excel file this part of the log file.any suggestions very much appreciated.thank you!

I am trying to convert speciality maps for use in avionics software. I have converted the mbtiles to CADRG, and they import and display in the computer software, falconview properly. However I import them into the aircraft they display all black.  The only thing I can tell is the CADRG has been exported with. 217 color tables bet pallet, with the last table being 0,0,0 which I think is causing the display to be all black.  many ideas with resolving this issue? Thanks.

I am new to FME and am having trouble with a CADRG exporter. I need to limit the number of colors to 216 on the export however FME exports at 217 rendering the image all black on avionics software.