FME Form

Hey community! How can I read and then modify property set data in an IFC?Which transformer should I use? How can I read the IFC in the most correct way for my goal? I cannot read thE "IfcPropertySingleValue".....

Using AttributeManager to update 86,000 (existing) records using APN for key. Is this process optimized by FME? It takes a long time, and I assume it is N*N time. (Does the Reader iterate through each record, one at a time, then searching through all the records in the Writer to find the matching key?)

We are about to install Server for the first time on a dedicated virtual machine. Since our subscription now includes floating Desktop licences, does it cause any problems to have the Desktop licence manager installed on the same box? Thank you.

I have an AutoCAD drawing containing points, lines, polygons, and text layers. I want to do the following: have the actual AutoCAD text values in the kml file and set the yellow push pin icon for text features to null or no icon.

Hi,I am struggling to change the color of polygon, line and point as well as popup and labels on map included in HTML Report. It seems like an easy task but I am struggling to find a solution. I assume my questions are:How to change the colour of polygons, lines and points on the map base on the value of the attributes?How to edit labels and popups so they have different values? I have followed the instructions from Add Conditional Coloring to Map section of How to Customize HTML Reports (safe.com). Unfortunately, suggested method is not what I am looking for. I have attached my workbench. Thank you for all suggestions. 

Hello to all the members of the FME Community!We would like to know if you have any applications or workflows that are currently using the FME Server JavaScript API. It is no secret that we have not prioritized enhancements or upgrades to the library, and, if at some future date we decide to deprecate support of the FME Server JavaScript API, we want to make sure that we have provided alternatives to keep your apps and workflows running when you upgrade. What are you using the FME Server JavaScript API for that you cannot do with the FME Server REST API?We have started development on V4 of the FME Server REST API, and this would be a great opportunity to add new capabilities so that there is a smooth transition path available. What impact would the deprecation of the FME Server JavaScript API have for you and your organization? If there are any questions or concerns, we can start thinking about them now.  Note: Please keep in mind that we do not have a target date to deprecate the FME

Hello again everyone, I have a question for anybody who's worked with passing JSON data in the body of a POST request for a webhook. I am working with a developer on a script to call FME server from an outside application and pass the needed JSON data in the body. She is using an AJAX script that looks somewhat like this: $.ajax({        url: <my server url with webhook token>,        method: 'POST',        data: {"A":"1",         "B":"2",        "C":"3",           },        dataType: "json",        success: function (response) {                             alert(JSON.stringify(response));                     },               error: function(data, errorThrown){                             alert('request failed :'+errorThrown);                             //document.getElementById("response").innerHTML="Failed"+errorThrown;             } }); Here's the thing: I have a

Unable to get the Web Service to Authenticate (redirect url)BTW, we are no longer allowed to use our personal accounts for Auth, therefore we have Service Account files we use. Therefore, unable to create a Web conn either. Only way I can create a writer is to select Service Account file and define the table myself. Then I preface the writer with a PythonCaller to get the creds.When defining a NUMERIC in the writer, does not allow me to specify width/precision. Any updates to this writer planned soon? 

BonjourJe souhaite à la lecture de ma couche commune, exclure les communes d'une dizaine de département identifiée par leur nom ?Merci

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.

I have pdfs with multiple pagesi have to split them up by a certain textstring (e.g. SS 66,16)This textstring is always nearly on the same coordinate on the page, so i can isolate them and write the text in a new attribute but how can i fanout them that i have all content right from one page (e.g. pdf_page_number 2) and the pdf is named after that textstring (SS 66,16.pdf) Greetz and cheers Franco

In the workspace I have a geometry extractor transformer, which outputs OGC Well Known Binary format.After geometry extractor, SQL server non spatial writer follows. In the writer, the WKB field is defined as the varbinary (width 8000) type.In an SQL server database, this field is defined as a varbinary (MAX) data type.All translations went smoothly in the latest FME Workbench 2021 version.However, in version 2022, it does not work. I tried different data type combinations for sql server writer and for database, however without success. 1. casewriter data type: database data type:varbinary (8000) varbinary(MAX)  Microsoft SQL Server Non-Spatial Writer: Attribute 'abc' of feature type 'xyz' has specified type 'varbinary(8000)', but existing database table field has type 'varbinary_max'. Information may be lost during conversion.Microsoft SQL Server Non-Spatial Writer: Attribute data '\\x01\\x03\\x00\\x00\\x0\\x95\\xAC!AR\\xB8\\x1EU\\ ... ' too la

We have an IFMEFeature from type FME_GEOM_AGGREGATE.The window "Feature Information" in FME Desktop displays the IFMEMultipoint property with 299 parts of IFMEPoint.How can we get these multipoints in the writer plugin? If we call feature->numCoordinates() we got 598 but if we call numParts () or numVertices() we got the correct number of 299.And if we call feature->getAllCoordinates() we got a list of 598 coordinates, but only 299 of these are correct and the other ones consists of a point with coordinates (1, 1, 0). Where does this point (1,1,0) come from?The list of coordinates starts with1,1,0valid point1,1,0valid Point1,1,0....

Hi list.I got a curious error in a workspace, which I needed to update.I needed to update some schema references (from .../1/... to .../2/...) and thought that it was a good idea to create a private user text parameter, containing the "2" needing to be inserted.However, this yielded a strange error when applied to the root expression in my XMLTemplater. Something like this: "... can not expand namespace prefix to URI"Is it correct that XMLTemplater cannot use user parameters replacements ?And if so, why not ?Aren't these applied to whatever parameters a transformer may have, prior to its execution ?Cheers.

I am wanting to read and write features to a POSTGIS connection however I can't even connect as I am unsure what to do for the schema field. Can someone provide examples of what to add in the schema for table field.

I need to be able to read an existing geodatabase annotation feature class (regardless of whether it is populated or not) and get a value for the "Annotation created with new features" annotation feature class attribute. Is there a corresponding FME geodatabase format attribute? If there is, would FME properly set the geodatabase attribute if I used that format attribute on a schema feauture used to build a geodatabase?

Hi, I have a workspace I am wanting to upgrade from FME 2019.2.3.2 to 2022.2. It creates geopackages that could be read in either QGIS 3.22 (late 2021 release) or ArcGIS Pro 2.6.10. We just tested and they also open in ArcGIS Pro 2.9.5 (Oct 2022 release).Upon upgrading (with or without changing the feature writer to specifically use the new OGC Geopackage writer format) ArcGIS Pro can no longer read the output. QGIS can read it fine.Whilst I presume this is likely an esri compatibility issue, what I am wondering is what the underlying SQLite version is, and what the Geopackage version is - I could not find this in the documentation of the writer (easily - forgive me if I have missed something)?I then have something to check against the esri compatibility as they list out the versions supported. Cheers John

I did a spatial join of two AGOL layers, one is a strip map and the other is parcel data with owner info. I merged the two and created a table with the owner information and its respective page number. Some parcels are on more than one page, however, and I'm trying to make a table that includes these records and doesn't just omit them (there should be an individual record for each parcel and every page it shows up on). I've been trying to use the Spatial Relator with Generate List checked, followed by a List Exploder but it is not working. Does anyone know of a better way to do this? Edit: There is no common attribute between the two layers.

Imagine having a raster with transparent gaps (null) and wanting to fill these gaps with another dataset (presumably of lower resolution). If this second source is placed under the first the secondary data would "shine through" the gaps. This is how one would solve it in Photoshop, and I'm trying to figure out if the same solution is possible in FME. Is it posible to set the layering/stacking order of incoming datasources before running the RasterMosaicer?  (This is a follow up question to: https://community.safe.com/s/feed/0D5Dm000007hjgQKAQ)

Hi, I have a dataset in .dbf format, with 885 rows. When I read the file in FME it reads the 885 rows, but when I use the DuplicateFilter it tells me I have 330 unique rows and the rest are duplicates.  But actually all these 885 rows are unique, I can see that when I look at the file using ArcGIS Pro, and my colleague have looked at the file in another text-application. So it seems FME keeps the total number correct, 885, but changes some unique numbers so they are duplicates somehow. In AGP:In FME: How can this happen? I have tried reading the file both using the "normal" .dbf-writer, as well zipping the file and using Creator > ParameterFetcher > FeatureReader > FeatureReader > AttributeExposer.  

Hello, I have a raster dataset. I need to intersect vector lines with it and then get the average values of the raster cells (pixels) that intersect with the vector line. I have a working solution to do this but I have to convert the raster to polygons with a RasterToPolygonCoercer. Some rasters are larger (8.2M cells) so this takes forever and is very memory intensive. Is there a better way to do this without converting raster to vector polygons? I'm not super experienced with rasters so please explain well.  Thanks in advance!  

I have read all the SchemaMapper tutorials and implemented what I thought should work for a SchemaMapper and input mapping table, but the feature type in question here is not being mapped at all. I am hopelessly confused, hence the following explanation and question: I have a feature type Safety/Fire (i.e. fme_feature_type = feature_dataset/feature_class) that I want to split into three different feature types based on the value of the Type attribute. The values are FDC, Fire Alarm, and Fire Extinguisher. I also want to put the three new feature types into a different feature dataset, namely Life_Safety. Here is a screenshot of part of the mapping table I am using:  In the SchemaMapper I have set first a Filter Features action with SRC_FIELD = SRC_FIELD_VALUE indicated and with Ignore Blank Attribute Values set. Then I have a Map Feature Types action with SourceFeatureType --> TargetFeatureType indicated. Finally, I have a Map Attributes action with SRC_FIELD --> TargetAttr indic

Recently we installed FME server… And I’ve been banging around in it like a bull a China closet… Nothing is broken… just throwing up workbenches and trying to get things to process in the same way they are on FME Desktop. I’m having some success… but I feel its more like luck than “repeatable success”. I’ve looked on the Safe.com website and read through questions and articles… That helps some… but still needing a little more guidance…   What suggestions do you have? What guidelines/articles/manuals/reference material could you suggest? Here are some of the areas/errors where I’m struggling with…  Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`odeq1', userName=`msaccess', password=`***', dbname=`')  Microsoft Word Writer: Aborting translation: Not authorized to access destination file. Please ensure that destination file is closed and check destination filepath  CSV write

I try to run diffrent workspaces with a WorkspaceRunner. It works with a fullpath but not if I use a AttributeValue or a UserParameter fed by a pathReader. The ErrorMessage contains "An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner ..." I run it on Windows 10 with FME 2022.1. I already added FME_Home to PATH environment. With FME 2019.2.x it worked fine. An Example Workspace is provided.