FME Form

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 records, 3) added a new field called 'Color&#39

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.

Hello community!I have 4 point clouds that I would like to aggregate. By aggregating the clouds with the "point cloud combiner" I lose the color information, why?

I'm encountering an issue reading NetCDF files I got from here:https://dap.ceda.ac.uk/badc/cmip6/data/CMIP6/CMIP/AS-RCEC/TaiESM1/historical/r1i1p1f1/day/pr/gn/latest/ When attempting to use a ListSearcher to search the "netcdf_coordinate_variable" list for an element with axis = T, I get no matches, even though its the first element.I also get no results using a ListExploder and a Tester to test the axis attribute.In fact the only attribute from the list that will match is "name". Looking at the list there are 2 elements, and the second element only has a "name" attribute and no others.I could see why this might trip up the ListSearcher, but I don't understand why the ListExploder + Tester method also fails to match? This is with FME 2022.1.2 on MacOS. I've attached a workspace (data linked above) and a screen shot showing the list has an element with an axis value of "T".

Hi, I have a workspace where run is disabled when "Prompt for user parameters" is on. When i disable this option run is active. This is the only workspace where this happens. Any ideas?  

Hi altruist, I have a very large datasets of daily records of soil moisture data which a FME workspace is getting failed to process. So, I have broken down by Financial Year by using testFilter and intend to produce average SM value by FY (as you can see in the image). Now I have to use a series of other transformers on each of the FY output that need to be repeated for each FY output port. Can anyone suggest which process would do it faster so that I can do like a batch process for each FY without manually changing the trigger etc? Looking for kind response.

Hello , i have attribute contains may values as streetname (park: mo (beside))street name (park: far away )How could I use test filter at first to find which value contains parentheses inside it ,I mean as (beside) which value has no parentheses inside it then the values that include parentheses after string as ( park: mo (beside))i would like to extract only the word beside at new attribute .all values include parentheses ( at the beginning but I am interested in the second parentheses ,how could I get the all values that contain two parentheses then extract the string inside the parentheses as beside word .thanks for help FME 2021

Hi,I've got a problem with the ListExploder. I am trying to divide a well-formed XML based on a XML-tag. This itself works fine, but the problem is, that all Object, wich get rejected lose there geometry information. I can see it in the DataInspector, the Min and Max Extent shows "nan". Leaving out the ListExploder, the geometry is visualized, so it seems clear, that the objects loose their information at the <Rejected>-Output-Port of the ListExploder.This problem appears since we installed FME Desktop 2022.2. I tried the same workflow with an older version (2020.1.3.0) and there it works as expected. I put on a screenshot to clarify the situation in FME 2022.Does anyone know about this problem? Any solution would be helpful. Thanks in advance and greetings,André

Hello , I am not sure how to use Regex expression First example :street name 34 (56)street name 56 ( 44 )street name 55(70) or street name 55( 70 )I would like to extract the number between parentheses and add - before the number so it should be street name 34 - 56 second example : street name 56 (text)street name 40 ( text )street name 10(text)street name 40( text )i would like to extract the text between parentheses and create it in new column  third example :street name 20 ( GdR 20 ) street name 22 (23-50)I would like to extract it and add - before the value in parentheses So it should be street name 20 - GdR 20thanks in advance FME 2021

Hello, I have a feature class from an geodatabase that contains larger and smaller features that overlap one another. I sort these features to have the larger features come before the smaller features. The attributes of the feature class are: Id and date The goal is to union the smaller and larger overlapping features, but only keep the attributes of the larger overlapping features. Since there is one feature class the overlapping areas share the same attribute names.  Therefore, I use the AreaOnAreaOverlayer transformer, with accumulation mode set to Use Attributes From One Feature.  However, I am unsure of the behavior of Use Attributes From One Feature accumulation mode. Which attributes are copied over to the resultant feature when the overlapping features are unioned? The document mentions the following for the Use Attributes From One Feature accumulation mode: "Takes all attributes from one representative feature" How does the AreaOnAreaOverlayer determine which of the