Transformers

Hi guys,  I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?

I found that after using the Hyper File Writer, that I had no way to open the file and view it in FME, and could only use Tableau to open the file to see the data there. I could not find a Reader for Hyper Files as well.

I am using user parameters to direct the input and output of a workspace app.the user parameter is a choice configuration with allow choice edit enabled. This does allow the user to type or paste the value required in. I have the allow edit enabled to the parameter.It would be nice though if the checkbox allowed actually ADD(appending) the new value to the parameter list and not just to run the workspace with the new value and then lose it. (edit: I am not sure why but previously the app would not allow me to change or edit the value but now i am able to do that so i assume that was user error)

I have two tables. One with input data the other with unique high/low lookup ranges to categorize the input data. The lookup ranges and input data are numeric values. How can I append the associated data in the lookup ranges table to the input data based on where it falls between the min/max values? I considered AttributeRangeMapper but that will not allow comparison between two tables. Thank you, Gil

To populate in an automated way the json templater what I would to do is to add the string stored in 2 attributes that I created in the table of my source.The first one is to create the list of attribute name and the second one to run the command in Json templater to add the value of the same attributes present in the source. ( see picture)something like:{   "id":fme:get-attribute("id"),   "@ns:com:here:customer:$(CustomerName)": {                    "objectidOriginal": fme:get-attribute("objectidOriginal"),                   "toaddr_l": fme:get-attribute("toaddr_l"),                   "toaddr_r": fme:get-attribute("toaddr_r"),                   ..............................                   ..............................                   ..............................                   "filegdb_t

I force the autocad_text_size = @Evaluate(@Value(autocad_text_size) / 100), autocad_box_height = @Evaluate(@Value(autocad_box_height, and autocad_box_width = @Evaluate(@Value(autocad_box_width) / 100). When viewing the Attribute Creator transformer value they look correct but when I open AutoCAD DWG file the text is still at the original height.I try using TextAdder and DWG styler but nothing seem to work. Can someone show me what I am doing incorrectly in my workspace?  

Hello,I have seen this post concerning the customization of the FME Server Web Interface:https://knowledge.safe.com/content/idea/42274/customize-the-fme-server-web-user-interface.htmlIn 2018.1: is there a workaround for changing the color of the "FME Server menu"? Can we modify a css file? Or ??Thank you

Hi All,I'm trying to create and write dynamic attribute name with the joined workspace. In a FFS file, I have C-SEGMT entities. I would like to count how any entities I have until the current year (e.g. 2023) but also for the two previous years (e.g. 2022 and 2021) and put the result in a dynamic attribute name (for my example, three attributes named "NumEntities__2023", "NumEntities__2022" and "NumEntities__2021" I can create them, as you can see it in my Workbench and the screen capture, but I don't know how to write them in my Writer. It's OK for a FFS Writer, but if I want to write in a GEOJson file or other formats, it fails. I could name them directly "NumEntities__2023", "NumEntities__2022", "NumEntities__2021" ; or I could expose them with AttributeExposer : I can see their name if I have enabled feature caching. But my goal is, if I run the workbench next

I need to read multiple geodatabases from url, where some geodatabases are at the root folder, and some in subfolders.I tried to follow the article here, but already the initial schema reader fails. I set the source to https://arealdata-api.miljoeportal.dk/download/**/*.gdb. The error message I get is: Unable to connect to the File Geodatabase at 'HTTPS:\\arealdata-api.miljoeportal.dk\\download\\**'. Make sure the correct filename was specified, and that the Geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from

I use FME for updating several things in AutoCAD drawings (dwg) and writing out to new drawings using acad reader and writer. At present, when the new drawing is completed, the autocad_entity_handle is different on each object in the new drawing.  Is there any way to preserve the original autocad_entity_handle from the original drawing in the new drawing?Thanks!

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

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.

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.

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?

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)?

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 

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?

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.