FME Form

I have a non-spatial table in MS SQL database with lat/long coordinates. In my workspace I use the VertexCreator + EsriReprojector to create point geometries in our standard projection. Now I want to write the point features to a new feature class in an Enterprise Geodatabase (SQL Server back end).  The database connection I am using for the writer has permission to create table in the geodatabase and I am able to create feature classes in the geodatabase outside of FME.  But in the workspace, the translation fails with this error:“An error occurred while attempting to create the feature class 'My_New_Feature_Class'. The error number from ArcObjects is: '-2147216035'. The error message from ArcObjects is: {This geodatabase does not support this client or operation [This geodatabase does not support this client or operation] [My_New_Feature_Class]}I have searched for this error code and do not find much out there, so

Hi All,I’m working on an automation that needs to identify those lines that follow the geometry from another layer. The following screenshot explains what I need to do: Red line follows a river (not exactly the same geometry but pretty close) and need to identify those red lines that follows the blue centerline….I was thinking maybe I need to calculate the percentage of overlap between red and blue?There’s other locations where the red line only overlaps the blue lines for a little section so I can ignore those, see belowAny idea how to approach this?

Hi, I am new to FME so might be making a rookie mistake. But I am trying to update AGOL from a GDB shapefile but it won’t update in AGOL. I have managed to get everything to work and it shows the updates but its not sending the data to AGOL. What am i missing here?   

I have a fairly simple problem but can't seem to figure it out. I need to copy one excel file to another folder and rename the copied file. I've tried using the PATH reader and the File Copy Writer but nothing seems to get copied. Any ideas?

Hi everybody,My client has a spreadsheet that contains a list of Google Map urls embedded in text, inside cells in a Google Sheet. Using the Google Sheet  V4 reader, I am unable to read the url of the embedded text into the workspace. For example, I cannot read the url for the Google Map url for Safe’s location in this spreadsheet.  I’m really hoping to mine the lat/long coordinates from these urls. I use FME Desktop V2021.2.2.0 in production, but have Form V 2023.2.1.0 available, if needed.Thanks!

HiCurrently I am converting a DWG file to GDB (file) / SHP,The DWG file itself has line and polygon and they have color based on their different layer name.Once I read the file, it showed only FME feature name, I used AttributeExposer to add autocad color column and a few more useful information, then I used DWGStyler and FeatureColorSetter but once I write the file to GDB or SHP and bring the data to ArcGISPro, the layer has only one single color. (Please see the attachments) Can someone give me a clue how to solve it? 

I have a .csv file with x, y, z coordinates. From these points, I want to create a 3D line. Currently, I have the issue that the z coordinates are not being transferred onto the line when I create a line from the points. Does anyone have an idea of how I can proceed?

I had a FME scenario running to read the feature service and related tables and write to an excel file. I have the excel writer setup to “Fanout” the dataset which used to drop each table from the feature service into its own sheet within excel. I went back to run the FME scenario and when I check the excel outputs some of the tables are missing. Prior to running the scenario I check to make sure all the tables are checked and that the reader is seeing all of the tables, which it is. I check “select all” and run the scenario but when I check excel I get 6 of 9 tables. I have double check every setting and even started a new FME template and recreated the reader/writer but I still don’t get all the tables in the excel output.Can anyone help me out? Thank you

Hi Everyone..I was able to find a workspace from community this template attached and did few changes to it and it is working as expected with sample template provided in workspace to create a GDB with domains , fieldnames and field alias.      1) This workspace consider single default words in domainlist provided in excel  only like Domain1 -      Attached Sample_1_Workspace template - works with 2023 version.This workspace consider single altered words domainlist like alphabets(A,B,C….) in Attached Sample_2_Workspace_template - works with 2023 version  This workspace consider 2 words in domain list like FME form in attached sample_3workspace_template -doesnt work and workspace fails.. If there are any special characters or space it doesnt work like : FME Form or FME_Form. I have attached error log and all sample data files

Greetings, I’m trying to use an ETL to convert RVT files (2023) into File Geodatabase multi patch, however, the following model produces the right objects, but in the wrong location, even though when reading the RVT file directly in ArcGIS Pro, the building falls in the right place. Any clue? 

I have been trying to set up a batch process to create dwg files, adding a template based on the respective input file.  I have tried to follow the advice from the links below, but am missing something or what I am doing isn’t quite the same.  At any rate, my workspace fails after trying numerous different configurations.  Published ParametersBatch processing I have attached the two Workspaces.  The goal is to apply a CAD template to it’s respective output file, with the inputs controlled by the WorkspaceRunner parameters

My dataset contains some river basins polygons, with 1 forestry polygon falling into each one. Each river basin also contains multiple habitat polygons. I am trying to measure the distance (edge to edge) between the forestry polygon and each of the habitat polygons falling within the same river basin. I’ve done some spatial joins to associate each forestry polygon and each habitat polygon to it’s respective river basin, but I’m unsure how to measure the distances between them, while grouping by river_basin_id. Any help would be greatly appreciated.

Hi All,I’m trying to improve the performance of my workbench by reducing the number of transformers. I was able to use AttributeManager to calculate the length of lines with the expression @Length() but I can’t work out how to round up the value up to 3 decimal places,Is that doable using the arithmetic expression instead of AttributeRounder transformer? 

Hello,I am trying to convert data from shapefile to DWG.To do that, I am using the DWGStyler to assign the correct setting to each object.Reading the post in the community, I am able to use the DWGStyler using a template and the right color is assigned to each object in CAD so, I see the match between the color in the canvas and the color in the Layer’s list. But, in some cases, I don’t have the template and when I open the file in autocad I can see the right color in the canvas assigned by the DWGStyler but in the Autocad list layer I see all layers in “red”, I attached an example. How can I resolve this situation to have the perfect match for the layer’s colors to avoid a manual rework without using the template? Thanks Max  

I have a Flow App, which performs a relatively long process, which at the end directs the user to a certain url following the success or failure of the process.The url reference is made by a single HTML writer at the end of the process.My problem is that this process can take some time,And in terms of the user experience, the customers are not aware that the process is running behind the scenes.I want to make a reference to some kind of loading GIF that will at least show them that something is really moving behind the scenes..And this is where I need your help.Because if I write to two HTML writers, it simply downloads the two HTML files for me,It does not direct me HTML line after HTML, but simply disrupts the process.Does anyone have a solution?It doesn't even have to be a reference to the HTML of the loading GIF, just an indication in terms of the user experience that will tell the customer: "Don't worry

I’m working on an upload process via REST call and I want to use FME to do the upload.For the API I need to provide a list of file names in advance. I want this to just work and I want to be able to use FME’s multiple file picker to allow the user to pick folders, multipler files or just a single file. etc.Does anyone have a good/robust method for getting a full list of the files (and filenames) that this input could be.My initial plan is to split up the input parameter into a list and then figure out what are folders and what are files and for folders I would use a PATH reader to get the files.I guess I need a “MultiFilePathResolver” kind of thing. 

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything: 

Hi everybody!I have a point layer and a line layer. The line layer consists of connected lines, and at the lines endpoints there is a point from the point layer in the exact same location. I moved the points in the z-direction because their height had to be corrected (new z-values were derieved from a point cloud). Now i also want to move the corresponding line endpoints in z-direction as well so that they again match the points in x, y and z. I guess the AnchoredSnapper with Group Processing could do the job but don’t know how to prepare the data for that. Can anyone help me with this? red: original position of points and lines; green: points moved in z-direction due to height correctionQuestion: How can I make the lines follow the points in z-direction? I am grateful for any advice!

Hey! I have an 50 diffrent  MXD and I need to retive the map extent from start  in every mxd. There is an option to igonore map extents.But is there an an way to extract the start extent? 

Good morning,I would like to use FME processing to "periodically" update the values ​​of certain Utility Network attributes.This concerns the updating of data which potentially can be versioned, but I am only considering here the updating of "descriptive" (simple) attributes which are not involved in asset group assettype distribution rules and which have no impact on connectivity rulesDo you have experience of the best methodology to use and perhaps illustrate this with an example Workbench?THANKS 

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

I have two polygon datastets and i send them to the Topology Builder so that they will get break at the intersection. However it does not give the result I expected. My expectation would be a similar result to thearea on area overlay  my output looks. The overlapping area are not broken. Any idea what i may have been doing wrong 

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart

Shall we consider installing a Graphic card while preparing a machine for FME Form installation. How a Graphic Card impacts on the performance of 3D / 2D data processing.