FME Form

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 with with each workspace.. Any Experts Kindly support : How can i resolve this with text as FME Form or FME_Form (with a space or special characters. Thanks

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. The Workspace that outputs dwgs takes inputs from three sources:  Two different folders of CAD files (one of which also happens to be same as the template but used for a different purpose), and a spreadsheet .  Any insight is appreciated. Thanks.

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, a few seconds and you move to the next screen"Thank you!Dor

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. 

Hello everyone, I have colleagues who were wondering whether there would be git integration available with fme workbench.I understand now at the moment there is no integration directly in fme workbench with git. However it's possible to manually check in .fmw scripts in git I heard, but I think it would be an useful functionality if you dan do that directly from fme workbench. I was wondering whether something like that would be available in the future.

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.

Trying to find a  way to find the maximum amount (highest density) of polygons with the rulethe polygons must be non-neighbouring. Essentially selecting a polygon and jump to the next polygon which is not neighbouring and so fort and so on until you encounter a neighbouring one.See attached picture which I hand-picked.

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

I have a test looking for many possible cases. one of the cases I want to find is Any folder inside of any folder that has some specific names. (BTW I am using directory and File Pathname reader to create a list) and then a tester to get all of the special cases.)I have a test line like path_directory_windows CONTAINS *\project_data\working\**\*I don’t get any errors with this syntax but it does not find the folders. Basically i am only wanting to find folders within any project_data\working folder that contain any files.If it doesn’t contain a file I am not concerned with it.Any help with a correct regex statement that would work, or the proper syntax for the contains statement are what i am needing.I have tried this regex unssuccessfullyproject_data\/working\/[^\/]+\/[^\/]+TIA 

I'm trying to read annotation feature class from ArcGIS file geodatabase. For further processing, I need to check 'Split Complex Annotation' and 'Split Multi-part Annotation' in the reader.The annotation in ArcMap looks like the above image. It's in vertical alignment: baseline, horizontal alignment: center.While after importing from FME reader, it becomes to:Any safer partner could explain how FME calculate the anchor point of spitted text? seems the anchor point set to right bottom corner. And will the split consider the ArcGIS alignment setting?

I’m trying to use FME to split out any “Complex” or “Multi-Part” annotations that exist in the dataset and have the “Complex” or “Multi-Part” deleted and insert the split records as new annotations.On my FeatureReader, I have both "Split Complex Annotations" and "Split Multi-Part Annotations" enabled and I am able to delete the old records and insert the new records. However, I’m running into an issue with the geometry of the newly inserted records.From another post it looks like FME splits complex annotations tries to preserve the location of the text but loses other text placement characteristics like the original complex text geometry (lines) and converts them to a point for each split text item.'Split Complex Annotations' when reading ArcGIS geodatabase annotationsIs there a way to create or preserve the complex text geometry for these split records? The converted points seem to be causing an issue in a downstream program with the following error:Error from downstream program: “Err