FME Form

I have a workspace writes data from one ArcGIS database to another. I used the drop and create option on tthe tableI get the error , [DDL operations are not allowed across database boundaries.]} My question is how can ArcGIS allow you to drop a table but not create it again? This was very inconvenient. Is there anyway to stop FME from droping the table if it does not have the permission to create a new table?Best regards,Kicki M My error message:Geodatabase Writer: Dropping table/feature class `DBO.GVF_GEOM_TMP'Geodatabase Writer: Creating feature class `DBO.GVF_GEOM_TMP' in feature dataset 'gdbhmag.DBO.hmag'An error occurred while attempting to create the feature class 'DBO.GVF_GEOM_TMP'. The error number from ArcObjects is: '-2147220989'. The error message from ArcObjects is: {The operation is not supported by this implementation. [DDL operations are not allowed across database boundarie

Hello! I am trying to add an attribute to a table from a dataset that is specified by the user. This input data varies in attributes, so I don't know the format of them beforehand. However, I am consistently just adding 1 attribute to this data and writing it to another table. It looks something like this: The first dataset that I input works fine, but any dataset after that does not match the attributes of the first dataset will not go through properly. I've done some research on dynamic workflows in FME, but I'm still struggling a bit to find a solution to this. Any ideas?

FME(R) 2023.1.0.1 (20230831 - Build 23620 - macosx-aarch64)

This is what I am trying to accomplish in FME:A. Read a .jpg file, clip collars, add GCPs.B. Feed that into a GeoTiff reader to convert to GeoTiff.C. Feed the GeoTiff into a CADRG writer (requires GeoTiff for input). I've done this with some (limited) success using "reader to GeoTiff writer",then "GeoTiff reader to CADRG writer". (see my previous post on how the resultant GeoTiff raster was flipped horizontally) As the GeoTiff is an intermediate format, how can I streamline this flow? Thanksbill  

We are currently using FME server version FME Server 2021.1.3 and FME Workbench 2021.0.1 and we wanted to upgrade the FME server to the latest version, so if we upgrade the server will it be some issues with the old workbench automations already running in the FME Server. Or the old workbench is compatibile for the upgraded FME server ?  

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