FME Form

Hello ,i am trying to create a connection by SAS token between FME and Azure it works great when I create SAS token for all data inside the storage container ,then use this SAS token in Azure File storage connector in FME .but in case i specify one folder inside the container then generate new SAS token then use this sas token in FME ,it does not work in Fme .my question : How could I create the connection between FME and Azure storage for only specific folder ?i do not like to let FME has access to all data in Azure Container  FME 2021Thanks in advance  

I have two data sets - one is a 'main' dataset and the other is a 'lookup' dataset containing further information. In my main dataset I have a columns called 'Visibility' and 'road_condition' that contain a range of values from 1-13. There are over 4000 rows in the dataset. In my lookup dataset, I have 'code' and 'Column' columns that contain further information relating to each record in the main dataset. See screenshots of the data below.  Is there a way to create new columns in the main dataset called 'Visibility_Info' and 'Road_Condition_Info' that merges the data from the main and lookup datasets together without filtering each of the values in the 'Column' column individually before passing the data through to a FeatureMerger?

I need to write a couple of 100 tables from postgis into several geopackage files. This should be a pretty simple job? But the workbench fail OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int' This is related to https://community.safe.com/s/question/0D54Q00009SAyLQSA1/geopackage-dynamic-writer-error-unsupported-type-mediumint?t=1669103461721 and a follow up

Hi FME community, I am trying to start a job on FME Flow from another application by making use of a webhook and a token. The trigger results in succesfully starting a job on FME Flow, but the response is most of the time the following:502 - Web server received an invalid response while acting as a gateway or proxy server.It looks like this only happens when the job takes longer than 2 minutes. Does anyone have an idea where the 502 response comes from? This indicates an error while in fact the job is started as expected. Version 2022.2Build 22765 - win64

In a lot off my workspaces I need to fetch some 'global' values based upon user input. Example: user needs to provide project name: first check if projectname complies with the rules, once that is ok, use some api's to fetch global values for that project.Now those global values are in an attribute and need to keep track of those when using attributekeepers, list builders,...I can set them as a global variable with variable setter but it means that I need to use a lot off variable retrievers (10+).  Is there a way that I can put that value in a private parameter so that I can use it across the workspace without the variable setter and retrievers?

I am having problems using the FME Define custom Coordinate System Tool (demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw).​I want to make the ITRF2014 coordinate system that is in ESRI available in FME. I have used this ESRI WKT file from ITRF2014 - EPSG:9000 :​GEOGCS["ITRF2014", DATUM["International_Terrestrial_Reference_Frame_2014", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]]​However, when I test the new coordsys files I get errors. Any help in tracking

Hello everyone! I'm a new FME Desktop user seeking some guidance. I've successfully managed to join tabular data with an existing GIS layer and write the data using the ArcSDE Geodb writer with the "truncate" option to update an existing feature class. Now, I'm looking to automate a new process in FME. Specifically, I want to join a table to a feature class and calculate one of the fields in the feature class using a value from the table I've joined. Is it possible to achieve this without overwriting the entire feature class, only updating the specific field's value? Your insights and assistance would be greatly appreciated!

Hi Everyone, I am relatively new and in my current position I am replacing someone who was a bit more advanced than me. I understand a lot of what the workspace is trying to do (and it worked in FME Server) but once we migrated to FME Flow, the workspace no longer works. The premise is similar to the FME Demo "Map Based Data Distribution". The difference in our workflow has an Input Project Area instead of an Area of Interest which allows the user to upload a shapefile or use our municipal boundaries which is stored in our Repository. We also create a waiver for our Digital Licensing Agreements, but that's a User Parameter with "yes/no" and with either setting, the workspace/app fails. I've included images for the parameters for the FeatureReade

 Hello Forum, I notice that when FME Form convert a dataset from one format (e.g.: .tab) to geopackage it adds a field called 'id'. So, two questions: 1) Do geopackage files always have, and have to have, an id field?2) Or is there a way of asking FME Form to not create one/delete it? It doesn’t seem possible via an AttributeManager or in the Writer’s User Attributes. I've noticed that, separately, if I read in the created geopackage I can then use an AttributeManager to remove the id field and then publish again. But there are two problems with this… 1) It's a faff. I'd rather not read in, write out, read in, and write out again. But..2) even after removing the id field via an AttributeManager, the id field always appears in the output geopackage file. This makes me wonder if an id field must always exist in geopackage files.  I've also noticed that when creating geojs

Hello everyone, I am currently exploring the generation of displacement vectors between two sets of coordinates in a point cloud, with the aim of creating graphical representations for further analysis. My current situation involves the availability of two distinct pairs of coordinates for each point, and the aim is to create arrows indicating the direction of displacement, with a length proportional to the displacement of each point. However, I am facing a major difficulty concerning the scale of these arrows, which must be adjusted so that they are visible on screen or on a plane. I've appended the script I've developed so far, but I notice that it doesn't take the notion of scale into account. More precisely, the problem lies in the inability of the "Scaler" transformer to allow individual definition of the X and Y coordinates of each point, which is necessary to determine the origin of each arrow. Does

I have geodatabases, which can contain strictly structured data of linear utilies and related objects, such as powerlines, utility poles etc. However, geodatabase sometimes contains only powerlines, sometimes only poles, sometimes powerlines, poles, power plants and more. So, one geodatabase may contain two layers of data with strict and specific names and attributes, the other may contain all of defined layers, and so on. I convert this geodatabase into an XML file through XMLTemplater provided with an input from XSD file. Since the structure of the geodatabase is always the same, XML Templater allows me to set the template beforehand, and XMLTemplater just writes the attributes afterwards. The reduced ROOT template looks something like this:<?xml version="1.0" encoding="UTF-8"?><geodatabase:Utilities xmlns:gss="http://www.isotc211.org/2005/

Hello Everyone im still new to FME i been given a task to run a topology rules by referring all the rules from esri gdb as shown in the image that has been attached with. My problems is that i already did some reading that FME is capable to do topology rules checking by using TopologyBuilder but i have no experience on how to operate the builder to do topology checking on Area, Line and Point, Can anyone help me with this situation ?

I have switched from using a custom transformer to a linked custom transformer for the sake of reusability. While there were no errors when I ran it with the local custom transformer, I started encountering an error message randomly after seeing the "Translation was SUCCESSFULLY" message, which reads "Error missing translation." after I changed it to a linked custom transformer. Here's some additional information that may help:1) The number of records outputted by the custom transformer in both cases is the same.2) In both scenarios, they were executed in "Moderate" mode with parallel processing.3) Debug logs are enabled, and although there are some "BADNEWS" messages, they were present in both cases. Can anyone provide me with some hints or guidance to resolve this unknown error message?" Here below is the screen capture for the error message.

Hello,Has anyone faced issues while trying to read DGN files (V7 or V8) in FME 2022? My current version is FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64). Below an screenshot of the error:I have tried to changed the reading parameters but still unable to read it. Also I have loaded the same DGN onto FME 2020 and works fine.Can this be a bug in the 2022 version?

I am trying to read a parquet file with the "FeatureReader" transformer and I have no problems doing so. However, the three columns that I have in my parquet file, which are datetimes [ns], do not appear in the parquet. If I use an "Attribute Exposer" I can't get them either, they seem to come as "missing". Any alternative in this regard? 

I'm trying to copy metadata from SDE (Test) to SDE (Prod) environment. Any help would be greatly appreciated.

Hi,I need to write to several feature classes with the same schema but different prefixes to the names e.g. FAIL_wPressureMain. I am using an XML workspace schema only as template to define the output ( has subtype and domains). In the schema there is wPressureMain. The writer creates a feature class wPressureMain with everything correct but when I output a prefixed name e.g. FAIL_ the the subtype is not respected (haven't checked domains yet). I am presuming at the moment that somehow the new name does not match the schema 'name' wPressureMain and hence thinks it's something new and just writes out the data with the new name , loosing the subtype definition? Is there a way to fix this or is this correct behaviour? Or something broken in my script?I could create a schema for FAIL_wPressureMain and all my other classes and prefixes likewise, the result would empty feature class output, creating a different problem of deletin

The project number attribute from the TPL Corridors and Concepts layer did not exist in the target TDE Projects layer. However, I created a separate workspace that added in the field of TPL_Project_Number field into the TDE Projects layer already, so the target TDE Projects layer has the field in the table. This is my current workspace.This is how the attribute manager configuration is:The issue I am experiencing is that the script is inserting new records with just the tpl_project_number into the target TDE Projects layer, but I want these tpl_project_numbers inputted into the target TDE Projects layer for only the TDE Projects and TPL Corridors and Concepts polygons that overlap one another into the existing corresponding r

I'm using FME Workbench 2022.2.4. I have a couple of workspaces that I run daily  (via a batch files) to generate public facing data (a dashboard and a downloadable csv file). When I open and run one of these workspaces in FME Form 2301.0, it had 123 errors.  I noticed that Upgradeable Transformers did not appear in the Navigator Pane, and discovered that this is a know issue. The notice says that the issue is fixed in 2023.1.0.1 but, I don't think that version is available.https://community.safe.com/s/article/Known-Issues-in-FME-2023-x In the 2023.1 log file, the first error I see is:2023-09-22 12:15:35| 118.0|  0.1|ERROR |DateTimeConverter_2_1 (TeeFactory): DateTimeConverter_2_1: @Tcl2 -- failed to evaluate expression `DateTimeConverter_2_2ec7b318_cca9_46ee_ac8d_5fa555c5bb630_DateTimeConverter {DateTime_FME}' -- F

How can I fix the texture that the 3D-tiles writer puts out? When converting from obj(including .png and .mlt) to 3D tiles, the writer makes the texture very dark when they are being viewed in Cesium. There is no problem converting to kmz, the textures is perfect there but we need to use 3D-tiles for its streaming capabilities. KMZ: 3D-Tiles:  I have read multiple posts on FME forum and on Cesium forum:including this idea: https://community.safe.com/s/bridea/a0r4Q00000Hbqi5QAB/options-to-choose-and-set-gltf-appearan

I am TRYING (without success) to build areas from parallel horizontal and vertical lines. After MUCH work i finally have 2 areas that will simply not create areas.I started with parallel lines.use Intersector and others.but end up with 2 areas that are missing because of one line that the intersector chopped that is always incomplete in AreaBuilder.

I have a tree canopy coverage layer where tree canopies are overlaid. The layer contains around 5,000,000 entities and I need... :1) remove the overlapping area of the entities (I've tried with the space and overlap cleaner but it takes too long, I have 32gb RAM)2) merge all entities into one, and for display performance reasons, the resulting layer must be cut on a 1 km or 500 m grid. In attached an exemple of the layer  Any idea how to proceed? Thanks to all

I'm trying to setup a workspace that allows the user to choose what attributes to keep in the final spreadsheet. But AttributeKeeper seems to work wrong when passing User Parameters in the "Attributes to Keep" box. I've created a User Parameter of the type "Attribute Name" that allows to select multiple attributes, and I've setup AttributeKeeper to use this parameter. I'm facing the following:1- When selecting only one attribute: Schema gets lost, but the attribute is still retrievable by exposing it.2- When selecting more than one attribute: Both schema and attributes get lost.3- Noticed that AttributeKeeper has a comma delimiter when multiple attributes are selected, while "Attribute Name" User Parameters use a blank space as a delimiter. So I've created a third parameter of the type "Text" with the value "a1,a2" (where a1 and a2 are the attributes),