FME Form

This is my JSON file. I want to insert, in "structure_ids" array, the value 79538. Maybe the problem is my value, I can't write it like that. Thanks for your help 

I have created a workbench on my desktop that will be running each night on a server. Both my machine and the server is using Windows-1252.The workbench run fine on my desktop but on the server i get the error POSTGIS writer: Internal Error: Failed to copy attribute 'NØYAKTIGHET' to 'nã˜yaktighet'I dont have any encoding issues on my desktop which make me wonder if the translation fail due to this. I cannot see any other reasons why this would fail?The server is running 2022.1.2.0 (20220831 - Build 22627 - WIN64)The desktop is 2021.1.0.0 (20210630 - Build 21607 - WIN32)Both are using the same locale as far as i can see. Any ideas how i can fix this? My first try will be to install 2022 version on my desktop, but I doubt that would make any difference.     

Hi!I am familiar with the consept of reading IFC and writing IFC in FME. I also have successfully created a workspace that can read various geometry formats and write to IFC with custom propertysets. Now I'm trying to create a workspace that can read IFC, modify or add propertysets and write back to IFC without breaking the structure of the IFC file. For example, I have a IFC with slabs. I want to add some propertysets to the slabs and write it back to slabs. I have seen the example where you can modify properties for spaces, but I'm having problems applying the workflows to IFC. All in all I think FME has potential for improvement in handling IFC-files in an intuitive way. Does anyone have any good examples of workflows for the described purpose that can be shared?

Coordinate system setter is in the workspace, so I can select local coordinate, but I want to add offset value in somewhere in the workspace. Please kindly let me know how to add off set value (Latitude shift, Longitude shift, and height shift). Thank you.

I’m using FME 2020.2 (FME(R) 2020.2.0.0 (20201027 - Build 20787 - WIN64)) and I have ArcGIS Pro 2.6 and ArcGIS Desktop 10.4 (with 64 bit background geo-processing) installed. I have a File Geodatabase (FGDB) that FME is unable to read.  The error I'm getting is : “It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro-compatible ArcGIS Sever and 64-bit FME." This FGDB contains a relatively new ESRI field type called contingent values on a feature class.  ESRI notes this makes the FGDB incompatible with ArcMap and releases prior to ArcGIS Pro 2.3 and ArcGIS Enterprise 10.7.x. It appears that FME is defaulting to using the ArcGIS Desktop libraries rather than the newer ArcGIS Pro libraries when both application are installed. The only work around I have identified at this time is uninstalling ArcGIS Desktop.  Once I do this FME will read the File Geodatabase without any errors

Like described in the header, In short I'm wondering what the default (X,Y) coordinate order conventions are in FME (particularly in relation to the 'Lat/Long vs Long/Lat discussion')? Reason/motivation of the questionThe reason I'm asking is that in quite some workspaces I prompt users to enter an extent for a particular area (mainly to filter out data for the user defined area). Recently a user asked me if it was possible to incorporate an option to also allow the input extent to be entered by means of explicit Bounding Box (BBOX) coordinates in the form of a specific envelope, i.e. to enter both the (Xmin, Ymin) AND the (Xmax, Ymax) coordinates.Of course these explicit coordinates are meaningless without knowing how to interpret them (i.e. without knowing the underlying coordinate system). In the Netherlands it turns out that the vast majority of spatial files make use of the 'RDNew coordinate system' (EPSG:28992). However, I also wanted to give users the opt

I would like to get the predominant line for each polygon. I have tried using the 'CenterlineReplacer' but that doesn't work well since a lot of these shapes aren't long and narrow areas.  I only need one line per polygon, but it needs to be straight. The length of the line doesn't matter. I'm interested in the direction. Does anyone have an idea about how I can approach this task? 

Trying to remove the editor tracking fields. I can, run to, in Attribute manager and see the fields removed but in the File GDB preview, I still see them.

Hi I am trying to uninstall FME (2020.002) using Windows Add/Remove Programs. However, it just hangs on 'Gathering Information'. This is the second time I have tried - first time I left it for 24hours and no progress. Anyone go any ideas how I can remove it completely?

I am receiving this error below when I try to retrieve the getJSON variable:Python Exception <Exception>: Unable to update feature service layer definition.Object reference not set to an instance of an object.(Error Code: 400)Error encountered while calling function `processFeature'PythonCaller_3 (PythonFactory): PythonFactory failed to process featurePythonCaller_3 (PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsJSONFormatter (JSONFormatterFactory):This is the code in PythonCaller (simplified for readability):import fmeimport fmeobjectsfrom arcgis.gis import GIS def processFeature(feature):   getJSON = feature.getAttribute('JSON')   gis = GIS(profile='username')    lyr = gis.content.get('item_id').layers   for lyr in gis.content.get('item_id').layers:      lyr.manager.update_definition(getJSON)I know getJSON is giving me issues because if I replace lyr.manager.update_definition(getJSON

Custom format of version 2017.x (32-bit) not working when saved with 2022.1 (64-bit) version. Enclosed the custom format of version 2017.x for your reference. Above screenshot shows the v2017 custom format when consumed as Workspace Resource in FME Desktop v2022.1. Above screenshot shows the v2022.1 custom format (same old v2017 custom format opened and saved in FME Desktop v2022.1) when consumed as Workspace Resource in FME Desktop v2022.1.

Looking for a workbench example that updates a SDE Feature Class with attachments with an AGO HFL. Basically we would like to truncate and fill the SDE Feature Class with attachment with what is in a HFL in AGO.

Hi,I am having a large set of DWG files in which all the texts are referenced to a native Autocad font file called XARB.SHX, when I try to read it through FME desktop the fme_text_string shows something which is unrecognizable as FME is referring windows fonts.I am unable to read the autocad (XARB) style applied to the text in dwg file.It will be very helpful If anyone can suggest me some workaround.Thanks in advance.IMRAN

I have state name and county name as input parameters. I need to use state name as first input and then filter county name list to provide based input selection for county name. I checked Parameter Manager and cannot find a way to do this

Hello,I have a number of Workspaces that are run by colleagues using FME Server. These typically connect to a database, do some stuff, and create file-based output. The can run on three different environments, and because of that the database but also the output directory should be different. Right now I allow for that by using a database connection parameter and an output path parameter. It is to easy though to set one and forget the other, so that Production output ends up in a Test directory (or the other way around). Is it somehow possible to have a single Choice-Parameter, that influences which database connection is selected in the database connection parameter? I know I can use the ${} notation, but that does not see to work for a database connection.

Hi,Microsoft SQL Server Spatial reader connects successfully to a SQL Server entreprise geodatabase however it fails to retreive spatial data,throwing this error : Microsoft SQL Server Spatial Reader: Failed to load mssql_spatial_wrapper.dll. Cannot read/write curves and full globe and may orient geography incorrectly. Ensure Microsoft System CLR Types for SQL Server 2012 and Microsoft .NET Framework 4.5.2 (or higher) and are installedMicrosoft SQL Server Spatial Reader: Microsoft System CLR Types for SQL Server 2012 is available at http://www.microsoft.com/en-ca/download/details.aspx?id=29065. Please expand 'Install Instructions' and download 'SQLSysClrTypes.msi'Microsoft SQL Server Spatial Reader: If you have confirmed that Microsoft .NET Framework 4.5.2 (or higher) is not installed, it is available at http://www.microsoft.com/en-ca/download/details.aspx?id=42643Microsoft SQL Server Spatial Reader: Schema lookup query failed for table `domain\\TableName'. Provider

Hi, I have a problem that is bugging the *** out of me. By know it's a question of FME pride since I assured my colleague that FME was the way for this :) I have a rather sizeable SQL table containing measurement data from gauges. It is listed in a fairly common way (described by the attached picture). For analytical pictures I would like it to turn the attribute "name" inte columns that have their value displayed for each time step. This is for data analytical reasons.  I have tried with attribute pivoter without success, working with lists, creating a structured table than make a join. The problem is that the amount of names is so large that I can't make any manual type-ins for name etc. It has to be dynamically otherwise it won't work Please, any suggestions or will I have to admit defeat and hand it over to a sql colleague. It will give him alot of work (and also he will laugh in an evil way). Thanks in advance

This image of my output display on a CesiumJS website demonstrates where I am up to. I am trying to convert GDB multipatch to C3DT.I can control colour through either geometrycoloursetter or appearancesetter but I cannot figure out how to prevent dark shading on top of models nor create defined edges to accentuate the geometry.I want the edges to look like this:

Is it possible to write object data to a dynamic block with AutoCAD RealDWG writer?

The line combiner when used in 2018 and 2021 behave differently for the same input data. In 2021, the output does not correlate to the explanation on the FME help.  For the following dataset, the output expected is as shown in the 2018 output screenshot however, for 2021, despite the configurations being set as per the result which is expected does not yield the same results. It appears that for some reason the duplicate lines(?) are not merged as expected. In the example below, K1, K2 etc. are kring_id and the numbers are _overlap (As set in line combiner)  The help states that duplicate lines are accepted by the line combiner for 2018 and 2021. Here are the transformer settings from 2018 and 2021 that are used in the workspace.  2018 - Break Across Attribute ValuesIf this parameter is set to Yes, two lines with the same values for the attributes selected above will not be combined if the node at which they meet is also connected to another line with different values for these attribu

Hi,I use ZipExtractor to unziped a file, then put it in a folder, but when I go to use PythonCaller to read the files from the folder, it still hasn't finished unzipping all the files.How do I make it use the next task only when the previous task has finished?Thank you

My project covers the whole state of NSW, and the workspace has many many transformers. What I want to know is how to lock the bounding box of the map in the Graphics View. If I'm debugging one particular area of interest, the map jumps to some sort of saved view for each and every transformer. I spend the day zooming and panning the map to get back to my area of interest. I click another transformer to see what the data was doing at that point. then have to zoom and pan again to get back to my area of interest. What I want to do is lock the Graphics View to my area of interest. I can see the hover for "2D" button is "Lock the current view in 2D", but it doesn't lock anything consistently. Sometimes it even centres the map on another state where there is no data. Other times it drops me in the ocean and I have to zoom out until I see land, pan, and zoom in again. Is it possible to keep the bounding box of the map in the Graphics View fixed?

I would like to be able to populate a user parameter dropdown choice list from the results of a sql query and/or stored proc every time the workbench is run. As in, the dropdown choices need to always be able to reflect the database results every time. This seems unusually difficult to do. I need the dropdown to always reflect whatever the latest values in the database are, every time the workbench is called. Using Workbench 2021.2.1.0 (20211203 - Build 21797 - WIN64) Any help is greatly appreciated.

Hey there,So i've modified the Data Downloading script on FME Server and am having some issues exporting to a dwg with object data. The script lets them pick from a tree list what to download and then export to DWG and it completes fine but the issue is if I only download one layer, say contours, its including every single feature class as a layer in the DWG even tho its empty. I can see it creating object data during the FeatureWriter process.  Is there an option to not include layers if they're empty im not seeing? thanks for any help.